How do I upload bank statement transactions?
Open Banking provides an automated transaction feed for accounts whose banking providers offer this. However, you can also choose to upload transactions to ExpensePlus instead. This is still quick and efficient.
This article explains how to upload bank statement transactions into ExpensePlus.
For an overview, please watch the bank reconciliation module overview video here.
In this article:
If you usually use Open Banking, on the rare occasions that a provider's Open Banking feed is unavailable or requires reconsent, you have the option to upload bank statement transactions instead.
If you choose to upload transactions:
- You must disconnect from Open Banking. Otherwise, when the bank feed becomes available again, you will likely end up with duplicate transactions. To disconnect, you need to go to the Bank & Cash Account Settings screen.
- Do check that ExpensePlus has all transactions from the last date that Open Banking imported transactions (if not, any missing transactions will need uploading).
If you choose not to upload transactions:
When the Open Banking feed becomes available again, it will automatically pick up from where it left off (there is no need to upload any transactions). Note that you may need to disconnect and reconnect for transactions to be re-imported.
How do I upload bank transactions?
1. Upload transactions
Within the Bank Reconciliation screen, click the 'Upload Transactions' button for the relevant account.

2. Select the file to upload
In the pop-up that appears, select the file with the transactions you downloaded from online banking.
PDF files cannot be uploaded. The statement needs to be in .CSV, .XLS or .XLSX format.
If you only have a PDF or paper statement and need to upload transactions manually, see this help guide article.
You should not modify the bank transaction file after downloading it from your bank. ExpensePlus knows the statement layout and format for most major banks, and most issues can be avoided by simply not opening the downloaded bank transaction file.
Simply select the downloaded file and upload it to ExpensePlus.
When downloading transactions from your bank, we recommend you only download transactions up until the previous day.
ExpensePlus purposely does not import bank transactions from the day of upload to prevent errors.

3. Check the upload
Check that the transactions look correct, and click 'Yes, upload these transactions' if they are.
ExpensePlus knows the download format of statements from major bank accounts.
It can automatically find the column headers and the data to import, as well as setting the date format correctly.
If the transactions do not look correct, or ExpensePlus is not able to select the data automatically, click 'No, something doesn't look right'. You can then specify the transaction columns yourself on a separate screen.

4. Check the bank balance
A pop-up will then let you know your transactions have been uploaded successfully.
It will ask you to check that the bank balance on your account within ExpensePlus matches your actual statement.
If it does, you can click 'Yes'.
This is a way of checking that you have not missed or double-imported any transactions.
You need to check that this balance is correct.
If it isn't, it's far easier to sort any errors at this point, before you match any transactions.
If the closing balance doesn't match your bank statement, you can select 'No' to delete the import.
Double-check your statement file before retrying. At the bottom of this help article, we've listed the common reasons a closing balance might be incorrect.

5. Match your transactions
You can then reconcile your bank transactions.
Frequently Asked Questions
What if ExpensePlus can't automatically read my bank statement format?
If something doesn't look right, or ExpensePlus is not able to automatically select the data, then you will be able to specify the bank statement format yourself and ExpensePlus will remember this for future reference:

When specifying the bank statement format yourself, be sure to check that the date format at the bottom is correct (as sometimes dates are saved within the .CSV in American date format which is MM/DD/YYYY even though in Excel these may appear as DD/MM/YYYY).
Why is my closing balance shown in ExpensePlus different from my actual bank statement?
Here are some of the common reasons for this:
- The bank statement was uploaded to the wrong bank account in ExpensePlus (you will need to delete the upload)
- You've uploaded one or more transactions twice (you will need to find and then delete the duplicate transactions)
- You've missed uploading one or more transactions (you can just upload the missing transactions)
- Your bank account opening balance was set incorrectly (you will need to correct the opening balance)
- The previous upload caused an issue (check that the balance at the start of your current statement upload matches between your bank statement and ExpensePlus).
Most commonly, issues occur when downloading part-month statements from your bank account.
How can I delete incorrectly uploaded transactions?
If there is an issue with the transactions you have uploaded, the best point to realise this is at the point of upload (which is why we ask you to check the closing balance every time you upload transactions).
If the closing balance doesn't match your bank statement, you can simply select 'No' within the pop-up to delete the import, and then double-check your CSV file before retrying.
You can also delete transactions from within the 'View Statement' screen, but note the 'Delete Last Upload' option (which allows you to remove the last statement you uploaded) is only available if none of these uploaded transactions have been matched.

Where transactions have been matched, or where you need to delete specific duplicates, you can do this by clicking the 'unmatch' or 'delete' buttons to the right of the transactions shown on the View Statement screen.

What if I don't have access to online bank statements?
Nearly all banks provide downloadable statements, so you may just need to request access to online banking.
However, you can still upload bank transactions if you do not have bank statements for a bank account.
This should be used for bank accounts with paper statements, and where there are just a few transactions each month/year.
For details of how to upload transactions to ExpensePlus manually, see How do I manually enter bank transactions?
At the bottom of the 'Upload Transactions' pop-up, there is an option to upload transactions manually.

For bank accounts with more than 1 or 2 transactions each month, we'd highly recommend that you contact your bank to ask if they offer online banking so that you can access downloadable spreadsheet statements (and if they don't, it may be worth considering an alternative banks, as most provide this as standard).
Without downloadable statements, you will need to manually key in transaction data each month, which is not only extremely time-consuming (and just unnecessary), but it is also prone to errors.
Why are transactions with today's date excluded?
We exclude transactions with today's date because the benefit of uploading transactions with a statement date of today is outweighed by the fact that transactions dated with today's date might not yet have appeared on your statement at the point you downloaded it, which would then result in either:
- missing bank transactions (causing your bank balances to be incorrect, along with your financial reports)
- next time you upload, having to figure out which transactions with today's date are missing (which can be time-consuming and lead to errors)
It's best to only download transactions for days that are complete and therefore won't change (e.g. yesterday). If you accidentally include transactions from the current day, these will automatically be excluded, to prevent the issues described above.
To better understand the Bank Reconciliation module, please view the module overview video here.