Skip to main content
iVentureTeam
Odoo Accounting & Tax

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.

Siddharth JambukiyaSiddharth JambukiyaOdoo Techno-Functional Consultant
November 22, 202614 min read0 views
Odoo Bank Reconciliation: Models, Reports and Audit Trail in 19/20 cover

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.

  1. Bring in transactions. Use bank synchronization, import a file, or enter lines by hand. Record an opening transaction for the starting bank balance.
  2. Open Bank Matching. On the Accounting dashboard, click the bank journal or its "to reconcile" button to see unmatched lines.
  3. Let the rules run. Default matching rules and automated reconciliation models match lines without any clicks.
  4. Match the rest. Use Reconcile, Batches, Set Account, Receivable or Payable on each open line.
  5. Clear differences. Write off fees or discounts with a model button, or leave a partial payment open.
  6. 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 modelOptions in Odoo 19 and 20Typical use
TypeManual button or AutomatedButtons for judgment calls, automation for fixed patterns
ConditionsJournals, Partners, Amount, Label"Label contains CARD FEE", amount below a limit
Label matchingContains, Not Contains, Match RegexPick up bank codes or reference formats
Counterpart amountFixed, percentage of balance, percentage of statement line, from labelSplit fees, tax or commissions
Counterpart detailsPartner, account, taxes, analytic, labelPost to the right cost center
Next ActivityActivity typeFlag 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 bank reconciliation: What changed from Odoo 19 to 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.

AreaOdoo 19Odoo 20
Summary reportUnreconciled itemsReconciled and unreconciled, as of the end date
Invoice and bill matchingDefault rules and reconciliation modelsNew Matching Rules with payment tolerance and matching order
Manual entries on bank accountsAllowedBlocked; bank balances change only through bank transactions
Statement errorsLess specific feedbackExact message such as "Incorrect ending balance", with a Review link
Set AccountSplitting a line takes more stepsSeveral accounts and amounts in one step
Re-running automationNo on-demand menu entry"Run Auto Reconciliation" in the gear menu
Payment statusesIn Process, then PaidPaid, 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.

ControlWhat it doesWhere to set it
Audit Trail reportLists changes with user, time, previous and updated valueAccounting, Review, Audit Trail
Restrictive Audit TrailBlocks deletion of tracked recordsAccounting settings, Reporting section
Lock Everything dateBlocks posting or editing on or before the dateAccounting, Accounting, Lock Dates
Lock date exceptionTimed exception with a reason, logged on the company recordLock Dates window
Hard Lock dateIrreversible lock for inalterability rulesLock Dates window
Secure Posted Entries with HashHashes posted entries; available on cash journals in Odoo 20Journal, 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.

SymptomLikely causeFix
Book balance differs from statementManual journal entry posted on the bank accountReverse it and record a bank transaction
Difference from day oneOpening balance missing or wrongCreate an opening transaction at the start date
Same line twiceFile import plus bank sync overlapUse Find Duplicate Transactions and delete extras
Statement flagged in redEnding balance does not follow the previous statementReview the statement and correct the gap
Payment will not matchPayment sits in another bank journalMove or re-register the payment
Unexplained difference on the reportPayment dated after the bank's transaction dateCorrect 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.

IndustryPain or cost driverOdoo approachHow iVentureTeam helps
Retail and eCommerceDaily card and gateway payouts net of feesManual model buttons that split sales and feesDesign payout models per provider
Wholesale and distributionCustomers pay many invoices in one transferReconcile with several items, partial paymentsReference rules and matching order
Professional servicesPayments without invoice numbersPartner mapping modelsLabel rules from past bank lines
ManufacturingSupplier batches and foreign currencyBatch payments, exchange difference entriesBatch setup and currency checks
Multi-company groupsTransfers between entities and banksInternal Transfers model on both journalsIntercompany and lock date policy

How iVentureTeam helps with Odoo bank reconciliation

Unreconciled lines piling up? Check your Odoo health

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?

Request a reconciliation review

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.

We use cookies to improve your experience

Essential cookies make the site work, and we use analytics to improve it. Choose “Only necessary” to turn analytics off. See our cookie policy.