Expense transactions are showing as income (or vice versa) after importing a bank file

Sometimes when importing a bank file, transactions are imported showing expenses as income, or income as expenses. The great news is, this is easily fixed!

In this article

What causes this to happen

This issue usually only happens for credit card accounts updated by uploading a bank file, and seldom happens with an account connected to a bank feed.

For example, some credit card providers may show an amount spent as 23.95 and a credit card repayment as -300.00. This does not match what PocketSmith would expect as the spent amount should be -23.95 and the repayment should be 300.00.

If you are experiencing a reversed balance issue instead, where an account that is meant to be negative is displayed with a positive balance, you need to adjust the account balance settings.

Fixing the transaction amounts

To fix the transaction amounts, you need to re-import the bank file with the following steps:

1
On the import form, choose to Replace existing transactions with overlaps. 

This ensures all incorrect transactions will be replaced with the new correct ones.

2
Then tick the checkbox option Amounts in this statement file are reversed.

This will ensure incorrectly marked debit/credit transactions are fixed.

Note

You should only use these options when the amounts of each transaction are incorrectly shown as negative when it is a positive amount, and vice versa and not if the balance is the wrong way round.

Still need help? Contact Us Contact Us