I have been having an issue with credit card data uploads… Some credit cards work others do not. In our company, we each have credit cards we use solely for the business and upload the data each month.
This month Tesco bank has removed the QIF upload option and now only allows you to get a full 3 month set of transactions in CSV format. Just to add insult to injury, they have also reversed the polarity of all transactions… so spending money on your card reduces your balance as it appears as a positive amount. Paying the credit card bill puts you further into debt!
MBNA went one further and did the same switch for QIF files… They rectified this after some arguing but now QuickFile is reporting a parsing error “Data at the root level is invalid. Line 1, position 1.” I have looked at the file and it looks exactly the same as all other QIF files… I can see no mistake. They do offer a CSV option, but it too has the polarity of transactions reversed.
I have raised the issue with both banks but there staff clearly do not understand double entry (which might be a bit worrying for a bank?) and have explained to me that credit cards are different from normal bank accounts and work in reverse… so they have the understanding level of a child!
Do I need to accept that someone will need to go through each downloaded file each month and check to see what each bank has decided to do each month and edit the CSV to make it usable… or is there some other way to sort the problem.
…and how do we get the numpties in the banks IT departments to at least find out what it is that they are sending to their customers…
I appreciate, this is not just a QuickFile issue and would probably apply to any financial software… but it is getting to be a real problem when each bank has its own standard and changes it on a whim!