Bank Reconciliation Report
This module adds a Bank Reconciliation Report in Odoo in XLSX format. For each bank journal, the report displays:
- The balance of the bank account in the accounting,
- The list of journal items of the bank account not linked to any bank statement lines,
- The list of draft bank statement lines not linked to any journal items,
- The computed balance of the bank account at the bank.
The last field (computed balance of the bank account at the bank) must be compared to the real bank account balance at the bank. If there is a difference, you need to find the error in the accounting. The field Computed balance of the bank account at the bank is a formula, so you can easily change its computation to try to find the difference with the real bank account balance at the bank.
auto_awesome What this module does
AI-generated from the code · Odoo 13.0Adds an XLSX bank reconciliation report that compares the accounting balance of a bank account with the balance at the bank, listing unreconciled journal items and draft bank statement lines.
This module gives accountants an Excel report to help reconcile bank accounts. You start it from the Accounting dashboard on a bank journal card (a 'Bank Reconciliation' link under Report), from a bank statement form (a 'Bank Reconciliation Report' button), or from the Accounting reports menu. A small wizard asks for a date and one or more bank journals; bank journals with a bank account are pre-selected. Clicking 'Export XLSX' downloads the file.
For each selected bank journal the report shows: - the accounting balance of the bank account up to the chosen date; - the journal items on that account not linked to a bank statement line, with date, label, reference, partner, amount, statement line date, move number and counterpart accounts; - the draft bank statement lines not linked to any journal item, with date, label, reference, partner, amount and statement reference; - a computed 'Bank Account Balance at the Bank' as an Excel formula, so you can adjust it to find differences with the real bank balance.
It also adds a 'Statement Line Date' field on journal items, shown on the journal item form, and a related stored field used by the report. If no bank journal is selected, the file contains a warning sheet instead.
Depends on
Menus it adds
Models and fields (3)
- account.move.line · extends an existing modelstatement_line_date (Statement Line Date)
- report.bank.reconciliation.xlsx · new model
- bank.reconciliation.report.wizard · new modeldate, journal_ids (Bank Journals)
Text generated by AI (DeepSeek) from reading the Odoo 13.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 13.0
Confirmed on 2026-11-03 in branch 13.0 of OCA/account-financial-reporting.
terminal Installation and usage
OCA documentation · Odoo 13.0Configuration
Source · Odoo 13.0This module doesn't require any configuration.
Usage
Source · Odoo 13.0You can launch the Bank Reconciliation Report wizard from:
- the menu Invoicing > Reporting > OCA accounting reports > Bank Reconciliation,
- the form view of a bank statement: click on the button Bank Reconciliation Report,
- the invoicing dashboard: on a bank journal, click on the options, then select Bank Reconciliation.
No verified information in OCA: Installation.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.