Odoo Bank Reconciliation: Models, Reports and Audit Trail in 19/20
Odoo bank reconciliation in Odoo 19 and 20: reconciliation models, auto reconcile rules, the summary report, as-of-date history, audit trail and fixes.
Most finance teams do not struggle with matching one payment. They struggle when the bank balance in Odoo drifts from the statement and nobody can explain why. Our Odoo ERP support services often start with exactly that problem in bank reconciliation.
Related service: Odoo for finance teams — accounting, tax and reporting automation.
This guide is for accountants, controllers and Odoo administrators on Odoo 19 or Odoo 20. If you are new to the Accounting app, read our overview of how Odoo Accounting works first, then come back for the rules, reports and controls.
What is bank reconciliation in Odoo?
Bank reconciliation in Odoo is the process of validating bank transactions against invoices, bills, payments or accounts. Odoo's own documentation calls it compulsory for most businesses and useful for catching errors and fraud.
Per the Odoo bank reconciliation documentation, every transaction is linked to a journal entry. It posts to the journal's main account and a suspense account until it is fully reconciled.
At that point the suspense account is replaced by the account of the matched item. So a non-zero suspense balance simply means "bank lines we have not explained yet". That one idea makes the rest of the process easier to follow.
Outstanding accounts are a related, optional setup. With them, a registered payment posts to an outstanding receipts or payments account first. Without them, no entry is created, and the invoice turns paid only when the bank line is matched.
How does Odoo bank reconciliation work, step by step?
Odoo bank reconciliation works in four moves: get the transactions in, let Odoo match what it can, clear the rest by hand, then review the report. The steps below are the same in Odoo 19 and Odoo 20.
- Bring in transactions. Use bank synchronization, import a file, or enter lines by hand. Record an opening transaction for the starting bank balance.
- Open Bank Matching. On the Accounting dashboard, click the bank journal or its "to reconcile" button to see unmatched lines.
- Let the rules run. Default matching rules and automated reconciliation models match lines without any clicks.
- Match the rest. Use Reconcile, Batches, Set Account, Receivable or Payable on each open line.
- Clear differences. Write off fees or discounts with a model button, or leave a partial payment open.
- Review and lock. Run the reconciliation report, compare it with the bank statement, then set the lock date.
Odoo bank synchronization supports over 26,000 institutions and needs an Enterprise subscription. Journals sync every twelve hours by default, and some banks only return three months of history.
If your bank is not supported, Odoo can import bank transactions from CAMT.053, CSV, XLSX, OFX, QIF and Belgian CODA files. European teams choosing a feed can use our guide to EBICS, bank sync and CAMT.053 imports.
How does Odoo auto reconcile bank transactions?
Odoo auto reconcile runs in two layers: fixed default matching rules first, then your own automated reconciliation models. Knowing which layer acted on a line tells you where to fix a wrong match.
With no partner on the line, Odoo compares the transaction label with the number, customer reference, bill reference and payment reference of open invoices, bills and payments. This is why a clean payment reference matters so much.
With a partner set, Odoo matches on amount in a fixed order:
- Exact match: the transaction amount equals the open item.
- Discounted match: the amount fits an early payment discount on the payment terms.
- Amount in label: the invoice amount appears in the transaction label.
Anything these rules cannot place stays open for a reconciliation model or a person. That is healthy. A rule that guesses is worse than a line a human reviews, so resist the urge to automate the last few percent.
How do Odoo reconciliation models work?
Odoo reconciliation models are custom rules that pick bank transactions by conditions and create counterpart items for them. They are either Manual, shown as buttons, or Automated, applied without a click.
The reconciliation models documentation lists the settings below. A transaction must meet every condition, and a model with no conditions is offered on every line.
| Part of the model | Options in Odoo 19 and 20 | Typical use |
|---|---|---|
| Type | Manual button or Automated | Buttons for judgment calls, automation for fixed patterns |
| Conditions | Journals, Partners, Amount, Label | "Label contains CARD FEE", amount below a limit |
| Label matching | Contains, Not Contains, Match Regex | Pick up bank codes or reference formats |
| Counterpart amount | Fixed, percentage of balance, percentage of statement line, from label | Split fees, tax or commissions |
| Counterpart details | Partner, account, taxes, analytic, label | Post to the right cost center |
| Next Activity | Activity type | Flag a line for review |
Three default models exist in most localizations: Internal Transfers, Bank Fees and Cash Discount. Odoo's own example is a $103 bank line matched to a $100 vendor bill, with the Bank Fees model writing off the remaining $3.
Two details cause most surprises. If a line fits several automated models, only the first in the sequence applies, so order them with care. And a model with a partner but no account works as partner mapping, which names the partner and leaves the match to you.
Which Odoo reconciliation models should you set up first?
Start with the few Odoo reconciliation models that remove repeat clicks without hiding real exceptions. In our projects, these are the ones that pay back fastest.
- Bank fees: automated, limited to a label pattern and a small maximum amount, so a large mislabeled debit never slips through.
- Internal transfers: used on both the outgoing and the incoming journal, as Odoo requires for a full transfer.
- Card and gateway payouts: a manual button that splits gross sales and fees; our Odoo Stripe reconciliation guide covers payouts in depth.
- Partner mapping: label rules for customers who never quote the invoice number.
- Recurring debits: rent, leases and software, each posted to its own account with analytic distribution.
Review the list every quarter. Archive models nobody uses, and test any regex against last month's lines before you switch a model to Automated.
What does the Odoo bank reconciliation report show?
The Odoo bank reconciliation report, named Bank Reconciliation Summary, explains the bank balance as reconciled plus unreconciled transactions. It is the document you place next to the bank statement at month end.
Odoo's accounting reporting documentation says the report gives "a detailed overview of reconciled and unreconciled transactions", with the calculations behind each balance. Open it from the Bank journal's menu on the dashboard.
In Odoo 20 the report has a Reconciled Transactions section with receipts, payments and a total, above the unreconciled part. Per our Odoo 20 accounting release notes, this is an Enterprise feature.
Read it in this order: the book balance, the unreconciled receipts and payments, then any unexplained difference. Old unreconciled items are the real finding. A receipt that has sat open for three months is usually a duplicate, a wrong journal or a payment that never arrived.
How do you run a historical bank reconciliation report in Odoo?
To run a historical bank reconciliation report in Odoo 20, open the Bank Reconciliation Summary and set the end date to the period you need. The report then rebuilds the position for that date.
Odoo states the report "reflects balances and reconciliation statuses as they existed at that point in time, rather than their current live status". It is described as "designed for review and audit purposes", with a complete trail as of the selected end date.
This matters because reconciliation keeps moving. A June payment matched in August shows as reconciled today, but it was open on 30 June. An auditor checking the June close wants the June view, and a report that only shows today's status cannot give it.
The Bank Reconciliation Summary section appears in the Odoo 20 documentation and not in the Odoo 19 pages. On Odoo 19, test the report's date filter against a closed month you know well, and save a PDF at each close.
Whatever the version, export the report at every month end and attach it to the close file. Our Odoo month-end close checklist shows where this step sits among accruals, tax and lock dates.
What changed in bank reconciliation between Odoo 19 and Odoo 20?

Odoo 20 tightens bank reconciliation in seven ways: stricter bank accounts, a fuller report, matching rules and faster manual work. The table summarizes what our release notes testing found.
| Area | Odoo 19 | Odoo 20 |
|---|---|---|
| Summary report | Unreconciled items | Reconciled and unreconciled, as of the end date |
| Invoice and bill matching | Default rules and reconciliation models | New Matching Rules with payment tolerance and matching order |
| Manual entries on bank accounts | Allowed | Blocked; bank balances change only through bank transactions |
| Statement errors | Less specific feedback | Exact message such as "Incorrect ending balance", with a Review link |
| Set Account | Splitting a line takes more steps | Several accounts and amounts in one step |
| Re-running automation | No on-demand menu entry | "Run Auto Reconciliation" in the gear menu |
| Payment statuses | In Process, then Paid | Paid, then Reconciled |
The Matching Rules menu sets a payment tolerance, in percent or amount, and whether the oldest or newest invoice is matched first. It sits under Accounting, Configuration, and existing reconciliation models stay as they are after an upgrade.
The bank consistency change is the one to plan for. Imports or scripts that post manual journal entries on bank accounts need to create bank transactions instead. Our Odoo 20 accounting upgrade checklist lists the tests to run before you move.
How does the Odoo audit trail cover bank reconciliation?
The Odoo audit trail records each change to accounting fields with the date, user, old value and new value, and lock dates stop changes to closed periods. Together they show that a reconciled balance stayed reconciled.
Open the report from Accounting, Review, Audit Trail. An optional Restrictive Audit Trail setting prevents tracked records from being deleted; they can only be cancelled or archived. Changes are also recorded in the chatter of each record.
| Control | What it does | Where to set it |
|---|---|---|
| Audit Trail report | Lists changes with user, time, previous and updated value | Accounting, Review, Audit Trail |
| Restrictive Audit Trail | Blocks deletion of tracked records | Accounting settings, Reporting section |
| Lock Everything date | Blocks posting or editing on or before the date | Accounting, Accounting, Lock Dates |
| Lock date exception | Timed exception with a reason, logged on the company record | Lock Dates window |
| Hard Lock date | Irreversible lock for inalterability rules | Lock Dates window |
| Secure Posted Entries with Hash | Hashes posted entries; available on cash journals in Odoo 20 | Journal, Advanced Settings |
Odoo's year-end closing documentation says bank accounts should be fully reconciled up to year end before the lock date is set. Lock date exceptions need Administrator rights in Accounting.
Controls only work with clear roles. Decide who may unreconcile, who may grant a lock date exception and who reviews the Audit Trail. Our guide to Odoo internal controls and approvals covers the access rights side.
Why does the Odoo bank balance not match the bank statement?
The Odoo bank balance usually differs from the statement because something reached the bank account without passing through a bank transaction. The fix starts with finding that entry, not with a balancing journal.
One Odoo forum user described "a phantom figure" of about $20,000 in the running balance. Another asked how to resolve an unexplained difference on the report. The causes repeat.
| Symptom | Likely cause | Fix |
|---|---|---|
| Book balance differs from statement | Manual journal entry posted on the bank account | Reverse it and record a bank transaction |
| Difference from day one | Opening balance missing or wrong | Create an opening transaction at the start date |
| Same line twice | File import plus bank sync overlap | Use Find Duplicate Transactions and delete extras |
| Statement flagged in red | Ending balance does not follow the previous statement | Review the statement and correct the gap |
| Payment will not match | Payment sits in another bank journal | Move or re-register the payment |
| Unexplained difference on the report | Payment dated after the bank's transaction date | Correct the payment date, then match again |
A third user wanted a formal, documented monthly reconciliation like the one in QuickBooks. The answer in Odoo is weekly matching, plus a month-end report and lock date.
Not sure how healthy your journals are? The free Odoo health check tool scores the setup. For daily cash planning on top of clean bank data, see our Odoo cash flow forecast guide.
How does Odoo bank reconciliation differ by industry?
The matching engine is the same everywhere, but the volume and type of bank lines change the rules you need. The table shows common patterns.
| Industry | Pain or cost driver | Odoo approach | How iVentureTeam helps |
|---|---|---|---|
| Retail and eCommerce | Daily card and gateway payouts net of fees | Manual model buttons that split sales and fees | Design payout models per provider |
| Wholesale and distribution | Customers pay many invoices in one transfer | Reconcile with several items, partial payments | Reference rules and matching order |
| Professional services | Payments without invoice numbers | Partner mapping models | Label rules from past bank lines |
| Manufacturing | Supplier batches and foreign currency | Batch payments, exchange difference entries | Batch setup and currency checks |
| Multi-company groups | Transfers between entities and banks | Internal Transfers model on both journals | Intercompany and lock date policy |
How iVentureTeam helps with Odoo bank reconciliation

iVentureTeam sets up Odoo bank reconciliation so that most lines match themselves and every month end leaves a report an auditor can follow. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.
- Bank feeds: bank synchronization or file imports, with opening transactions and duplicate checks.
- Rules: reconciliation models, matching rules and partner mapping built from your real bank lines.
- Clean-up: tracing unexplained differences, suspense balances and old open items.
- Close routine: a month-end process with the summary report, lock dates and Audit Trail review, designed with our Odoo consulting services.
- Upgrade readiness: testing imports and scripts against the Odoo 20 bank consistency rules.
Odoo accounting case study: Fernando Tax Management B.V.
A Dutch tax practice moved to Odoo 18 and got accounting data it could trust, which is the same goal as a clean bank reconciliation. This project was a migration and customization, not a bank reconciliation setup, so read it as a related example.
Fernando Tax Management B.V. had outgrown its legacy system. Manual entry across systems produced duplicate and inconsistent records that staff had to reconcile by hand, and reports had translation gaps.
We migrated the firm to Odoo 18 and customized Sales and Purchase with an office cost tracking workflow. We also resolved a hidden journal lines issue that had been obscuring accounting data, and built localized tax reports for the Netherlands and Curaçao.
The project took 10 weeks and cut manual data entry by 60%. Read the full Fernando Tax Odoo accounting automation case study.
The bottom line on Odoo bank reconciliation
Odoo bank reconciliation works well when rules handle the routine lines, people handle the exceptions, and a dated report closes each month. The tools are in the standard Accounting app.
Set up a small set of reconciliation models, keep every bank movement inside bank transactions, and save the summary report at each close. On Odoo 20, the as-of-date report and stricter bank accounts make that discipline much easier to prove.
Ready to get your Odoo bank accounts reconciled and audit ready?

Send us one bank journal and we will show you where the difference comes from. Request an Odoo bank reconciliation review, call +91-90235-15208, or email business@iventureteam.com.
Frequently Asked Questions
How do I do a bank reconciliation in Odoo?
+
Import or sync bank transactions, open the Bank Matching view from the bank journal, and match each line to an invoice, bill, payment or account. Then compare the reconciliation report with your bank statement.
Can Odoo reconcile bank statements automatically?
+
Partly. Odoo matches lines by reference and amount, and automated reconciliation models handle patterns such as bank fees. Lines that fit no rule stay open for a person to review.
What is a reconciliation model in Odoo?
+
It is a custom rule with matching conditions and counterpart items. Manual models appear as buttons in the Bank Matching view, and automated models apply on their own to transactions that meet every condition.
Where is the bank reconciliation report in Odoo?
+
On the Accounting dashboard, open the menu on the Bank journal card and choose the reconciliation report. In Odoo 20 it is named Bank Reconciliation Summary and is an Enterprise feature.
Can I see a bank reconciliation for a past date in Odoo?
+
In Odoo 20, set the end date on the Bank Reconciliation Summary. Odoo says the report shows balances and statuses as they existed at that date. On Odoo 19, test the date filter and keep a PDF from each close.
What is the suspense account in Odoo used for?
+
Each bank transaction posts to the journal's bank account and a suspense account until it is reconciled. A balance on the suspense account means some bank lines are still unexplained.
How do I unreconcile a bank transaction in Odoo?
+
Expand the transaction in the Bank Matching view and delete its counterpart items with the trash icon. The line returns to the unmatched list, as long as the period is not locked.
Does Odoo have an audit trail for accounting?
+
Odoo has an Audit Trail report under Accounting, Review. It lists changes with the user, time, previous value and new value. A restrictive mode blocks deletion of tracked records.
Is bank synchronization included in Odoo Community?
+
No. Odoo's documentation says bank synchronization requires a valid Odoo Enterprise subscription. Community users can import statement files or enter transactions by hand.
What is conciliación bancaria in Odoo?
+
Conciliación bancaria Odoo is the Spanish term for the same bank reconciliation process. The Bank Matching view, reconciliation models and reports work the same way in every language.
Free written answer from a certified consultant
Getting Odoo Accounting set up right?
We map your accounting, tax and reporting in Odoo and show what to set up first, and what to watch.
Free, with no obligation. A senior consultant replies within 12 business hours.
Free Odoo tools
All tools- Odoo Health CheckVersion, modules, findings and upgrade cost
- Odoo App SelectorWhich apps you need, by industry
- Odoo Project EstimateIndicative cost and timeline in minutes
- Odoo Implementation Cost CalculatorImplementation cost and timeline, in minutes
- Odoo Migration Cost CalculatorVersion jump or legacy ERP, priced in minutes
Continue reading
Odoo Tax Automation: Fiscal Positions, Tax Returns and E-Invoicing
Odoo tax automation in 19 and 20: fiscal positions, tax mapping, tax reports, VAT return checks, lock dates, closing entries and e-invoicing explained.
Odoo Accounting for CFOs in the GCC: VAT, E-Invoicing and Controls
Odoo accounting for CFOs in the GCC: UAE and Saudi VAT, ZATCA and UAE e-invoicing, AED and SAR multi-currency, lock dates and hashed audit controls.
Odoo Singapore GST Setup: Tax Codes, GST F5 and InvoiceNow in 19/20
Set up Odoo Singapore GST in Odoo 19 and 20: IRAS tax codes, the 9% rate, GST F5 boxes, PINT SG and the InvoiceNow timeline, plus when you need an AP.
