The HSBC business credit card/commercial card csv format was changed in May/Jun 2019. Since Jun 2019, the Paid Out amount (positive value) on the csv file becomes Money In on QF.
Before the change in Jun 2019, the csv format is:
14/05/2019 xxx BILL xxx IE -0.79
After Jun 2019, HSBC changed the csv format as below (now consistent with current and savings accounts csv):
Date Description Paid Out Paid In
01-Jul-19 NON STERLING TRANSACTION FEE 1.97
The Paid Out amount was integrated as “Money In” on QF account. All balances are wrong.
I read the post and understand there was a change last March. I also know this happened with other people as well but I don’t see a solution apart from the advise of using “Other”, which I don’t know what it means.
When you go through the import process, the first step where you select the CSV file, you’ll have the option of selecting the name of the bank too. By default, we will select the one set up on your account, but you can change this.
Simply change the name of the bank to “Other”, and we’ll prompt you to select the fields manually.
Thanks for the quick response. I have now deleted the old and upload again with the workaround.
HSBC bank file format changes must be generic to all and actually it only impacts credit card transactions.
The workaround requires a few more steps on every file import, i.e. select “Other” and change the format to be 4 columns.
Will there be a permanent fix to make this more user friendly?
So the Bank Feeds is not the solution for credit card!
HSBC current & savings account csv file always works on QF in 5 columns as below:
Date / Description / Paid Out / Paid In / Balance
Now HSBC has made the credit card csv to be the same format as current/savings, except no “Balance” column. But the same logic shall be easy to replicate to credit card file. I can see a quick fix was delivered when the issue was raised last March. Certainly when this happens again, another fix shall be delivered to address the problem.
Hsbc should really be supporting credit cards. It’s a poor show on their part. Other banks seem to. Make sure you tell them how you feel about that. Banks won’t do anything about it unless their customers stand up and tell them.
I’m not very technical but if the csv is the same format as the savings and current account and they import fine, just using hsbc from the list should work. Quickfile doesn’t use the balance field from what I understand
As @Spike mentioned, it’s certainly worth letting HSBC know that them supporting credit cards through Open Banking would help.
We don’t use the balance column from CSVs, only date, description and value (or money in/money out, depending on the format). If the current account CSV is working fine and is the same format as the credit card version, it should work all OK.
