Accounting: Monthly Bank Reconciliation
Reconcile each bank at month-end: statement balance, outstanding items and trial balance
Version: 19.0.1.0.1
Accounting
Monthly Bank Reconciliation
A month-end bank reconciliation your accountant can file
Odoo's Bank Reconciliation report is built around the last bank statement, so a statement that covers part of a month, or runs across month-end, gives the wrong month-end figure. This report reconciles one bank as at any date, from transaction dates, in the layout accountants already use.
What It Shows
- Bank side — balance as per bank statement, less outstanding cheques and payments, add outstanding deposits, to the cash-book figure.
- Books side — balance as per trial balance. Odoo holds uncleared items in the outstanding accounts, so it equals the bank statement and they are not listed twice.
- Difference — 0.00, or the entries that explain it, listed.
- Reproducible months — a cheque cleared next month still shows on this month's page when you rerun it.
- Same for everyone — figures never depend on who runs the report or their lock dates.
Where to Find It
Accounting → Reporting → Monthly Bank Reconciliation, or Monthly Report on a bank card in the Accounting dashboard. Pick the bank, pick the month, print to PDF or export to Excel.