How to Reconcile Bank Statements
Bank reconciliation ensures that your internal accounting records match your actual bank balance. This guide explains how to use the Reconciliation Matcher to bridge the gap between your bank statements and internal payments.
Prerequisites
Before reconciling, ensure:
- You have recorded and Confirmed your internal payments.
- You have created or imported a Bank Statement with transaction lines.
- Reconciliation is enabled in Company Settings.
1. Access the Reconciliation Matcher
- Navigate to Accounting > Bank Statements.
- Locate the statement you wish to reconcile.
- Click the Reconcile action (green scale icon).
2. Match a Statement Line to a Payment
The interface is divided into Bank Transactions (left) and System Payments (right).
- Select a Bank Transaction on the left.
- The system will suggest matching System Payments on the right based on the amount.
- Select the corresponding payment.
- Verify that the Remaining Balance at the bottom is zero.
- Click Reconcile Selected.
The payment status will update to Reconciled, and the statement line will be marked as matched.
3. Reconcile Multiple Items (Batch Match)
You can match multiple bank lines against multiple payments if their totals align.
- Select multiple checkboxes for Bank Transactions.
- Select multiple checkboxes for System Payments.
- Ensure the totals match and the difference is zero.
- Click Reconcile Selected.
4. Handle Discrepancies (Direct Write-off)
If a bank transaction has no matching internal payment (e.g., bank fees or interest), you can record it directly:
- Select the Bank Transaction.
- Click the Manual Entry / Write-off tab.
- Select an Account (e.g., Bank Service Charges).
- Enter the amount and description.
- Click Reconcile.
The system will create the necessary journal entry and reconcile the line.