Skip to Content

Accounting: Monthly Bank Reconciliation

Reconcile each bank at month-end: statement balance, outstanding items and trial balance

Version: 19.0.1.0.1 Accounting
Module Icon

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.