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 aren’t reconciled are available to match with whenever you process a bank statement.
Match bank payments with unreconciled cheques
Make sure you add a Cheques Batch for the current period before you upload the bank statement data for the same period.
Add or Edit an existing bank statement batch.
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 Cheque Batches.
The middle column will give the following status:
Auto - when the system finds a match automatically based on amount & 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.
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 is now matched with the cheque.
Demo
The following gif shows how to select multiple transactions (200+) and how the system matches them with cheques automatically:
