How do I manually enter bank transactions?
You can upload transactions to ExpensePlus manually, for example, from a paper bank statement.
However you should only do this if your bank doesn't offer the option to download statements as .CSV or .XLS from your online banking login (most banks do) or an automated transaction feed.
Usually, you would only need to enter transactions manually for a savings account.
For example, an account that issued an annual paper statement that consists of just a handful of transactions.
Usually, bank transactions should be uploaded to ExpensePlus using the file upload option or via automated feed. This makes it quick and easy to upload the transactions from your bank and prevents errors.
To learn how this works, please read this help guide article.
To upload bank transactions manually
1. Within the Bank Reconciliation screen, click the 'Upload Transactions' button as you usually would for uploading bank statement files:
If you are connected to an automated feed, and there is no 'Upload Transactions' button, you can still enter transactions manually.
Click on the 'View Statement' button in the next column and then click 'Upload transactions'.
2. In the pop-up that appears, select the 'Upload Transactions Manually' option at the bottom of the pop-up:
3. Then add the transactions you wish to upload. Use the + button to add additional rows as required, or the 'copy' button to duplicate existing rows:
Note: Each line showing must contain a 'Date', 'Description', and a 'Paid In' OR ' Paid Out' amount (not both).
You will then be asked to confirm to upload these transactions:
- At the end of the process, the system will ask you to confirm your new balance for the account, based on the transactions you've uploaded, in the normal way.
You should check that your bank balance is indeed correct, and then click 'Yes'.
To better understand the Bank Reconciliation module, please view the module overview video here.