Take a free trial of Clear Books Or take a look at our new product Clear Books Micro

Importing Credit Card statements records incorrect Debit/Credit

Problem reported by Andy Gambles 2 weeks ago

Using Lloyds bank export credit card statement as QIF and import into Clearbooks. All the outgoing transactions on the card are recorded as credits in clearbooks and all the payments as debits.

Is there a way to switch this around?

I don't know if this is due to the Lloyds QIF file or clearbooks.

3 Replies

Hi Andy,

Would it be possible to send the QIF file to support@clearbooks.co.uk so that our technical team can investigate? The mapping on QIF files are fixed so I don't think there would be a way of changing it in the Clear Books UI.

I’ve looked at a few qif files for credit cards.

They all have spend as positive figure and payments as negative figure. So there should probably be a way for clearbooks to identify it is a credit card account (which it is set as) and treat the values accordingly.

Hi Andy - yes I'm sure this will be possible, if you send through an example file I will raise it with our technical team.

As an alternative, are you able to export as CSV easily from Lloyds? You would be able to map the columns of the statement file manually on the first import, this mapping would then be saved for future imports.

Reply to this problem

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.