Which transactions can be bank matched together?
This article explains which transactions can be matched together, and how to do this.
In this article:
When reconciling transactions within the bank matching screen, the following logic is in place to help ensure that the correct transactions are reconciled together.
Transactions should generally only be matched one-to-one (with the exception of where a related payment for some reason has been split).
Recurring transactions
We recommend that recurring transactions are 'Quick Matched' before reconciling other transactions.
Recurring paid in and paid out transactions can be remembered for Quick Matching in ExpensePlus. Please see How to Quick Match transactions for more information.
Bank Matching a single bank transaction
Usually, when bank matching, you would select a single bank transaction waiting to be matched in the left-hand table.
If there is a corresponding match in the right-hand table, this will turn green and you can simply click the confirm button in the right-hand table next to the match or at the bottom of the page.
If you are using the expense and payments process flow in ExpensePlus, and recording cash and cheque deposits then over 95% of transactions will match as described.
Where several potential matches exist for a bank transaction (transactions with the same payment value), the system will highlight these in amber.
You then need to select the correct payment.
If a purchase has been paid by multiple bank transactions (e.g. two supermarket shops have been entered into ExpensePlus as one purchase), you cannot match the two bank transactions to one purchase transaction in the right hand table. This would cause issues for your financial reports, and ExpensePlus will not allow you to match these transactions.
For information on how to proceed in these circumstances, please see Date range too large when matching transactions.
To better understand the Bank reconciliation functionality, please view the module overview video here.