Appearance
Reconciliation
Also known as
- bank reconciliation
- bank rec
- BRS
- reconcile
- match
- matching
- statement matching
- auto-match rules
- bank vs book
- cash reconciliation
The reconciliation page compares each bank account's statement balance with the ledger and holds the auto-match rules. Select a bank account to open its workbench, where you match statement lines to ledger lines.
Check bank against the ledger
- Go to FinanceReconciliation, or press Ctrl K and type
bank reconciliation. - Read Bank balance vs ledger ("Statement balance against the ledger at the latest statement date."): Ledger balance, Statement balance, Statement date, Unmatched (statement lines / ledger lines), Open statements and Difference. "No statement yet" means nothing was imported for that account.
- Select a bank account to open its workbench.
Set up auto-match rules
Auto-match in the workbench applies these rules. "Built-in rules are used until you add your own": Amount and reference (±10 days, the reference must appear) and Amount and date (±4 days, only a unique candidate).
- Under Auto-match rules select New rule, or the pencil on a rule (needsPermission:
finance.reconciliation.manage). - Fill in the drawer and select Save ("Rule saved").
| Field | Required | What to enter |
|---|---|---|
| Name | Yes | For example Bank fees. |
| Action | Yes | Match ledger lines, or Create an entry (book the line straight to an account, for fees and interest). |
| Bank account | No | Empty = All bank accounts. |
| Priority | No | Lower numbers run first. Create-entry rules run before match rules. |
| Date window (days) | No | 0–90 days between statement and ledger date. |
| Amount tolerance | No | Allowed difference in amount. |
| Statement text contains | No | Only lines whose text contains this, for example maintenance fee. |
| Require a reference hit | No | The entry number, reference or source number must appear in the statement text (or the other way round). |
| Post to account | Yes for Create an entry | The account for the booked entry, for example 6950 Bank charges. |
| Active | — | Inactive rules are skipped. |
Delete rule: "Rule … no longer applies to future auto-matches."
Differences by role
- Permission:
finance.bank_statement.viewshows the page; Permission:finance.reconciliation.manageedits rules and matches.
