HSBC Credit card import backwards

Hello, When I import the data form my HSBC Credit card the “debits” are actually show as “credits” This doesn’t happen with the HSBC bank account data. I am importing both as CSV files, anyone else had this problem and is there an easy fix

Diarmid MacLennan

Hi @Discoderm

Is the monetary value just one column?

The exports for credit cards are backwards compared to a current account. If it is just one column, you would need to reverse the entries before importing the data (that is, convert +ve figures to -ve and vise-versa).

You should be able to do this in software such as Excel or Google Sheets.

Once they’ve been converted, it would work fine.

If money in and money out are separate however, you may be able to use the “Other” option and manually select them.

This topic was automatically closed after 7 days. New replies are no longer allowed.