What do I do if I've uploaded my bank statement incorrectly?

This article covers if you are uploading bank statement transactions from a CSV or XLS file and you have uploaded the transactions incorrectly.

How to prevent errors when uploading bank statements

When uploading bank transactions, we strongly suggest that you check the transactions uploaded as soon as you've uploaded them.

The easiest way to check that you've uploaded transactions correctly is to check the closing bank balance in ExpensePlus.

This is calculated within ExpensePlus (not imported from your statement) so if it matches the closing balance on your actual bank statement (which it should), then that usually indicates that the upload has been done correctly.

How does ExpensePlus calculate the statement closing balance?

The closing bank balance in ExpensePlus is calculated from your bank account's opening balance, plus all paid in transactions, less all paid out transactions to date.

To aid you with this check, at the end of the bank statement upload process, the system will ask you to confirm whether the newly calculated balance is correct as of the latest date. If this is not correct, click No, and the upload will be deleted.

Reasons for incorrectly uploaded bank transactions

If the confirmation above has been overlooked, you may find that you've accidentally uploaded your bank statement transactions incorrectly. 

Common reasons for this include:

• The opening bank account balance for the bank account has been incorrectly set in ExpensePlus.
• The number of header rows on the bank statement upload screen has been set incorrectly (and therefore some transactions in the spreadsheet didn't get uploaded).
• Transactions are missing from the spreadsheet file you have uploaded. The most common reason  is either when bank statements start partway through a month, OR when you download transactions, you are including that day in the download. This risks missing transactions because more transactions for the current day may appear after you do the download and then get missed from future downloads.

Less common reasons include:

• Some transactions have been uploaded more than once (either because you've uploaded a file twice, or there is a date overlap in the way you have downloaded transactions, and some are in more than one file).
• A statement has been uploaded to the wrong bank account within ExpensePlus.
• You are keying in transactions manually, and made a mistake.
• The date format has been incorrectly set on the bank statement upload screen, so transactions have been added to the wrong month, or not uploaded.
• The 'paid in' and 'paid out' columns have been incorrectly set on the bank statement upload screen.

How to delete the last upload

When spotted straight away, mistakes can easily be corrected.

On the bank statement screen, select the bank account which has incorrectly uploaded transactions.

You can delete the last bank statement upload for a bank account.

Clicking the 'Delete Last Upload' button on the bank statement screen.

How to delete individual bank transactions

From the bank statement screen you can delete individual bank transactions. To do this, click the 'delete' button (dust-bin icon) to the right of each transaction and click 'confirm' in the popup.

Ensure the correct balance and re-upload transactions

Once you have deleted the last import or any incorrectly uploaded transactions, we recommend that you check your bank balance in ExpensePlus matches your bank balance in your bank account for the relevant date after the last uploaded transaction.

You can then upload the bank statement correctly as needed.

Or you can upload transaction manually - see How do I manually enter bank transactions?

To better understand the Bank Reconciliation module, please view the module overview video here.