Appearance
Reconciliation workbench
FinanceReconciliationWorkbenchPermission:
finance.bank_statement.viewAlso known as
- match statement lines
- auto-match
- manual match
- unmatch
- ignore line
- create entry from statement
- book bank fee
- deposits in transit
- outstanding payments
- bank rec
The workbench reconciles one bank account: statement lines on the left, open ledger lines (bank postings) on the right. You let Auto-match do most of the work, match the rest by hand, and book bank-only items such as fees and interest straight from the statement line.
Reconcile a bank account
- Go to FinanceReconciliation and select the bank account.
- Choose a Statement (default All open statements) and an As of date.
- Select Auto-match. The toast reports what happened, for example "12 matched, 2 entries booked, 0 reversal pairs; 1 lines left".
- For each remaining statement line, select it and the ledger line(s) that settle it. The bar shows "Selected statement … · ledger … · difference …". When the totals agree, select Match selected. One statement line can match several ledger lines and the other way round.
- For bank-only items (a fee, interest), select the statement line and Create entry (below).
- For lines that need no entry (a transfer already booked elsewhere), select the eye icon (Ignore).
- When Difference shows Reconciled and the statement has no unmatched lines, reconcile the statement on its statement page.
Select Show matched and ignored lines to see everything; use Unmatch or Restore on a line to undo.
The summary
| Figure | Meaning |
|---|---|
| Statement balance | Closing balance of the latest statement up to As of. |
| Deposits in transit | Money in on the ledger, not yet on the statement. |
| Outstanding payments | Money out on the ledger, not yet on the statement. |
| Ledger balance | The bank GL account at As of. |
| Bank items not in the ledger | Unmatched statement lines. |
| Adjusted bank balance / Adjusted ledger balance | Both sides after those items; they must agree. |
| Difference | Reconciled when zero. |
| Unmatched | Statement lines / ledger lines still open. |
Book a statement line
- Select an unmatched statement line and Create entry (or the document icon on the line).
- In Book statement line, choose the Account, add a Description and, for a tax-inclusive amount, a Tax code (amount is tax-inclusive).
- Select Create entry. "Entry posted and matched".
Posts when you select Create entry (a bank journal entry dated on the statement line)
| Account | Debit | Credit |
|---|---|---|
| Money in: the bank's GL account | ✓ | |
| Money in: the account you chose (and tax) | ✓ | |
| Money out: the account you chose (and tax) | ✓ | |
| Money out: the bank's GL account | ✓ |
Customer receipts and vendor payments should be recorded as receipts and payments so the invoices and bills are settled; then match them here.
Differences by role
- Matching, auto-match, ignoring and booking need Permission:
finance.reconciliation.manage; others see the workbench read-only.
