When importing a bank file, occasionally transactions are imported showing expenses as income or income as expenses. The great news is - this is easily fixed! 🙌
What causes this to happen
This issue usually only happens for credit card accounts updated by uploading a bank file due to the way that card providers notate credit and debit amounts.
For example, some credit card providers may show an expense as 23.95 and income (a credit card repayment) as -300.00. This does not match what PocketSmith would expect as the expense amount should be -23.95, and the income should be 300.00.
Note If you have an account connected to a feed, and are experiencing a reversed balance issue instead, where an account balance that is meant to be negative is displayed with a positive balance, you need to adjust the account balance settings. See: Troubleshooting balance issues
Fixing the transaction amounts
To fix the transaction amounts, you need to re-import the bank file via the Account Summary page.
Alert
This will replace the existing transactions within PocketSmith that match the transactions in the file. Therefore, you will lose any of the following that have been added to these existing transactions:
- Categories
- Labels
- Notes
- Attachments
- Splits
- Head to the Account Summary page (Manage > Account Summary)
- Drag-and-drop the file you'd like to import onto the Account:
- On the import form, choose Replace transactions on overlapping dates. This ensures all incorrect transactions will be replaced with the new correct ones.
- 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 incorrectly showing as positive instead of negative. If an account balance is showing incorrectly, please see: Troubleshooting balance issues
Still having trouble? 🛟
Please send us an email to [email protected] and include a copy of the file you are having trouble with, as this will help us investigate further.