The steps below explain how to match a payment with a cheque when you process your bank statement data.
You can use the same method to match bank receipts with deposits.
About the reconciliation status
After you add your cheques or deposits, these will show as unreconciled until you match them with your bank statement.
You can check the reconciliation report, or the cheques and deposits listings to find any unreconciled cheques or deposit.
All cheques or deposits that are outstanding are available to match with whenever you process a bank statement.
Match bank payments with unreconciled cheques
📎NOTE: Make sure you've added a Cheques Batch before you process the bank data for the same period.
Within the bank statement batch entry, select the transactions you want to match.
You can select a single payment line or multiple payment lines at once.
Click the Cheques button beside the header "Select & Match with".
The - Cheque payment matching - window pops up.
The columns on the left (Date/Details/Account/Amount) are based on the Bank statement batch.
Select the expand (+) button on the left to view more details
The columns on the right side (Cheque number/Amount) are based on the individual cheques within all Cheques Batches.
The middle column will give the following status:
Auto - when the system finds a match automatically based on amount and cheque number
No match - when the system doesn’t find a match you need to select manually
Manual - when you have manually selected a cheque to match with
Click the drop-down arrow on the right.
Check the list of all available outstanding cheques, and make your selection.
📎NOTE: To be able to match, the amount must be exactly the same. You can't match a single bank transaction with several cheques. You can't use the split and match features together either. In that case, create another line in the bank statement batch.
To undo a match, simply click the drop-down arrow on the right and click Select none.
Click Save to apply the changes and quit the page.
📎NOTE: You can save even if you can't match every single transaction.
In the Bank Statement page, the transaction will appear as "matched" with the cheque.
Demo
The following gif shows how to select multiple transactions (200+) and how the system matches them with cheques automatically:
