Bank Reconciliation
Go to: Financials → Bank Reconciliation
Bank reconciliation matches your bank statement transactions against ledger entries to ensure your books match your bank.
Select Bank Account
Choose the bank account to reconcile and set the statement date range.
Import Bank Statement
Upload your bank statement (CSV format). The system reads transactions from the file.
Match Transactions
ERPX automatically suggests matches between bank statement lines and ledger entries based on:
- Amount
- Date proximity
- Reference numbers
Review each suggested match and confirm or reject it.
Handle Unmatched Entries
For bank transactions with no matching ledger entry:
| Scenario | Action |
|---|---|
| Bank charge / fee | Create a new journal entry |
| Interest received | Create a new journal entry |
| Duplicate bank transaction | Mark as duplicate / ignore |
| Missing payment entry | Create the missing payment entry |
Save Bank Clearance
Once all transactions are matched, click Save Bank Clearance to mark the reconciliation as complete.
Bank Reconciliation Statement
After reconciliation, the Bank Reconciliation Statement shows:
| Item | Description |
|---|---|
| Closing Balance (Bank) | Balance as per bank statement |
| Closing Balance (Books) | Balance as per your general ledger |
| Difference | Should be zero after full reconciliation |
| Outstanding Deposits | Deposits in books not yet on bank statement |
| Outstanding Cheques | Cheques issued but not yet cleared by bank |