There isn't a statement transaction for a payment or deposit that has been made. Why?
This article explains why a statement transaction might be missing from your Bank Matching screen.
In this article:
You may be seeing either a bank deposit transaction or an expenditure transaction listed in the right-hand table of the bank-matching screen, where there isn't a corresponding statement transaction in the left-hand column.
Checks to make
Firstly, ensure that your statement uploads are up-to-date and therefore, all transactions from your bank accounts are in the system. Note that ExpensePlus doesn't upload transactions from the same day if uploading bank statements manually, only from the previous day and before.
ExpensePlus can connect to many banks through Open Banking, which allows for an automated feed of your bank transactions - removing the need to manually upload bank statements. For more information, please see our separate article Overview of Open Banking.
Secondly, please check that the payment or deposit has actually been made. For example:
- The Bank Deposit may have been recorded but not yet banked. Is it still sitting around in a safe, tray, or desk drawer somewhere?
- Has it been paid in so recently (including on the day of upload) that it hasn't appeared on your statement yet?
- Has the payment been incorrectly marked as paid, but not actually paid by the bank?
- Has it been paid by cheque, and although the cheque has been sent it hasn't been presented yet, so no funds have cleared?
Next steps
Once you have established that none of the above scenarios are relevant, the following may be true:
- The payment or deposit may have been recorded as a duplicate by error. Search your statement to see whether a duplicate entry has already been matched elsewhere.
-
The payment or deposit may have been recorded against the wrong bank account by error. You can edit this by clicking on the pencil icon to the right of the transaction in the bank matching screen.


- You may find that the bank statement transaction has been manually reconciled instead of matched to its corresponding payment transaction. This would occur where a user has ignored the suggested match, hasn't clicked the corresponding transaction, and instead has clicked on the statement to enter a new transaction. This can also happen where a transaction has been previously matched, is then unmatched, and then re-matched manually. Where this is the case, you will now have 1 statement transaction and 2 payment transactions, and one of these payment transactions will need to be deleted. For best practice, keep the transaction that has the attached receipt or invoice and has been through the approvals process correctly.

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

