# Bank Reconciliation
Bank Reconciliation lets you match transactions recorded in your ERP cash book against your bank statement. Use it to verify balances, identify missing entries, and resolve timing differences between your books and the bank.
Overview & List View
The Bank Reconciliations list shows all reconciliation records with bank account, date range, notes, closing balance difference, and status.
List columns
`Id`, `Bank Account`, `From Date`, `To Date`, **Notes**, `Difference`, `Status`
Quick filters
| **Filter** | **Shows** |
|------------|-----------|
| Approved | Approved reconciliations |
| Draft | Draft reconciliations |
| Cancelled | Cancelled reconciliations |
Header actions
| **Action** | **Description** |
|------------|-----------------|
| New | Opens the new bank reconciliation form |
Click a row to open the reconciliation in view mode. Select a row to show footer action: **view**.
There is no edit form — reconciliations are edited on the view screen while in Draft status.
List View
Quick Start — Create a Bank Reconciliation
1. Navigate
Go to Accounts → Bank Reconciliation from the left menu.
2. Create new reconciliation
Click New and fill in the form:
- Select From Date and To Date (maximum 31-day range).
- Select the Bank Account to reconcile.
- Add optional Notes and Statement Sort Order.
3. Save
Click Save to create the reconciliation in Draft status and open the reconciliation view.
4. Reconcile on the view screen
- Upload Statement — import your bank statement file.
- Fetch Cash Book — load ERP transactions for the selected account and period.
- Match transactions manually or use Auto Match.
- Once matching is complete, click Approve. Resolving differences first is recommended but not enforced by the system.
| **Field** | **Description** |
|-----------|-----------------|
| From Date | Start of the reconciliation period. Mandatory. |
| To Date | End of the reconciliation period. Mandatory. Maximum 31 days from From Date. |
| Bank Account | Bank account to reconcile. Mandatory. Only active leaf cash/bank accounts are shown. |
| Notes | Optional remarks about this reconciliation. |
| Statement Sort Order | How imported statement lines are sorted. Options: Auto Detect, Old First (Ascending), New First (Descending). |
Form actions: Save, Reset, Cancel
Statement vs Book Balances
The reconciliation view shows a summary panel comparing bank statement and ERP cash book balances.
Account info
`Account`, `From`, `To`, `Status`, `Currency` (when multi-currency is enabled)
Balance comparison table
| **Row** | **Statement** | **Book** | **Difference** |
|---------|---------------|----------|----------------|
| Opening | Bank statement opening balance | ERP cash book opening balance | Variance |
| Closing | Bank statement closing balance | ERP cash book closing balance | Variance |
| Not Matched Count | Unmatched statement lines | Unmatched book lines | — |
| Not Matched Value | Total unmatched statement amount | Total unmatched book amount | — |
Bank Statement section
Columns: `Date`, `Narration`, `Deposit`, `Withdrawal`
Cash Book section
Columns: `Date`, `Narration`, `Ref`, `Party`, `Dr`, `Cr`
Matched lines are visually highlighted. Unmatched lines show remaining balance to match.
Reconciliation Workflow
1. Select account and date range
Create a new reconciliation with the bank account and period (up to 31 days).
2. Upload bank statement
Click Upload Statement (Draft only). Accepts `.xlsx`, `.xls`, and `.csv` files. The system parses transaction details and sets statement opening/closing balances.
3. Fetch cash book entries
Click Fetch Cash Book (Draft only). Loads journal lines for the selected bank account within the date range and sets book opening/closing balances.
4. Match transactions
Auto Match — automatically matches lines with the same amount, date, and debit/credit direction. Prefers matches where the book party name appears in the statement narration.
Manual Match (Draft only):
- Select a statement line (radio button).
- Click Match on a book line with the same direction (deposit/credit or withdrawal/debit).
- Partial matches are supported — the system matches up to the smaller remaining balance.
Un Match — click on a matched row to undo the match and restore unmatched balances.
5. Refresh totals
Click Refresh to recalculate unmatched counts, balance differences, and line balances after matching changes.
6. Approve
Click Approve to lock the reconciliation. The system does not require opening/closing differences to be zero or all lines to be matched before approving — reconciling fully first is a best practice, not a hard rule. Use Open later if you need to revise an approved reconciliation.
7. Download statement
Click Download Statement to export the reconciliation as an Excel file (`bankReconciliationStatement.xlsx`).
Group By
Use the Group By toolbar to organize unmatched lines: None, Amount, Date, or Party Name.
Actions & Status
Statuses
| **Status** | **Description** |
|------------|-----------------|
| Draft | Editable — upload, fetch, match, refresh, delete, and approve available. |
| Approved | Locked — only Open and Download Statement available. |
| Cancelled | Listed in filters; no dedicated cancel action in the view UI. |
View toolbar actions
| **Action** | **When available** | **Notes** |
|------------|-------------------|-----------|
| Delete | Draft | Confirmation: Are you sure to delete? |
| Auto Match | Draft | Matches by amount, date, and direction |
| Refresh | Draft | Recalculates all balance totals |
| Approve | Draft | Confirmation: Are you sure to approve bank reconciliation? Does not enforce zero differences or full matching |
| Open | Approved | Reopens for revision; confirmation: Are you sure to open/revise bank reconciliation? |
| Download Statement | All statuses | Exports reconciliation to Excel |
Data toolbar (Draft only)
| **Action** | **Description** |
|------------|-----------------|
| Upload Statement | Import bank statement file (.xlsx, .xls, .csv) |
| Fetch Cash Book | Load ERP journal lines for the account and period |
Row-level actions (Draft only)
| **Action** | **Description** |
|------------|-----------------|
| Match | Match selected statement line to a book line (same direction) |
| Un Match | Undo an existing match on a matched row |
Master Update is not available for bank reconciliation.
View Tabs & Side Panels
Bank reconciliation uses a dedicated reconciliation workflow screen, not the standard transaction view with side panels. History, attachments, and other transaction side tabs are not shown on this screen.
Best Practices
- Reconcile monthly: Run reconciliation for each bank account at the end of each statement period.
- Upload before fetching: Import the bank statement first, then fetch the cash book for accurate side-by-side comparison.
- Use Auto Match first: Run Auto Match to handle obvious matches, then manually match remaining items.
- Refresh after changes: Click Refresh after manual matches to update balance differences.
- Resolve differences before approving: Ensure opening and closing differences are zero or documented before approval.
- Download for audit: Export the reconciliation statement after approval for record-keeping.
FAQ
What date range can I reconcile?
The period must be between 1 and 31 days. The system shows an error if the range exceeds one month.
What file formats are supported for bank statements?
`.xlsx`, `.xls`, and `.csv`. The system auto-detects date, narration, and amount columns.
Can I edit an approved reconciliation?
Use Open to revert an approved reconciliation back to Draft for revision.
Does approval require all differences to be zero?
No. The system lets you approve even with unmatched lines or non-zero opening/closing differences. Fully reconciling first is recommended for accuracy but is not enforced.
What does Auto Match do?
It matches statement and book lines with the same amount, date, and debit/credit direction. It prefers matches where the book party name appears in the statement narration.
Can I partially match a transaction?
Yes. Manual matching supports partial matches — the system matches up to the smaller remaining balance on either line.
Is Master Update available?
No. Bank reconciliation does not support Master Update.
Why are some book lines not matching?
Check that amounts, dates, and directions (deposit vs withdrawal) align. Use Group By to organize unmatched lines by amount or date for easier review.
Related documentation