Skip to Content

Bank reconciliation in Odoo: statements, rules and month-end routine

How to get bank statements into Odoo when your bank has no direct feed, reconciliation models that match most lines automatically, how outstanding payments work, and a weekly routine that makes month end a formality.
November 7, 2026

Bank reconciliation is the single best health check for a company's books. If the bank balance in Odoo matches the bank statement, line by line, almost every other number can be trusted. If it does not, nothing else can. Yet in many companies in the region, reconciliation is done once a month in a spreadsheet, or not at all. Odoo can make it a few minutes a day.

FlexCode Middle East is part of FlexCode Systems GmbH, an Odoo Silver Partner. We implement Odoo, so Odoo is the system we describe, next to an honest look at the topic itself.

Key points

  • Statements in, daily. Import statements as files when your bank has no direct connection; most regional banks provide Excel, CSV, CAMT or MT940.
  • Rules do the matching. Reconciliation models match invoices, book bank fees and handle recurring items automatically.
  • Outstanding accounts. Payments recorded in Odoo wait in an outstanding account until the bank line confirms them.
  • Weekly, not monthly. A short weekly routine turns month end into a check rather than a project.

How reconciliation works in Odoo

In Odoo, each bank account is a bank journal. Statement lines from the bank arrive in that journal, and reconciliation means matching each line to what it represents: a customer payment against an invoice, a supplier payment against a bill, a bank fee, a transfer between accounts. When a payment is registered in Odoo before the bank line arrives, it sits in an outstanding receipts or outstanding payments account until the matching statement line clears it.

  1. Statement imported
  2. Rules suggest matches
  3. User validates
  4. Invoices and bills paid
  5. Outstanding accounts cleared

At the end, the journal balance equals the bank balance.

The result is that customer and supplier balances are only reduced by money that really moved, and cash in the balance sheet equals cash in the bank.

Getting statements into Odoo

Odoo offers bank synchronisation with many banks worldwide, but coverage of banks in Egypt and the Gulf is limited. In practice most companies in the region import statement files, which works well if it is done regularly.

FormatTypical sourceNotes
Excel or CSVOnline banking export at most regional banksMap columns once and save the template
CAMT.053Corporate banking platformsStructured, includes references
MT940SWIFT-based corporate bankingCommon with international banks
OFXSome online banking toolsLess common in the region
  • Ask your bank for a structured format such as CAMT.053 or MT940 for corporate accounts.
  • Import daily or at least weekly, not at month end.
  • Never edit statement lines to make them match; fix the Odoo side instead.
  • Check that the closing balance of each import equals the bank's closing balance.

Reconciliation models: let rules do the work

Reconciliation models are rules that tell Odoo what to do with statement lines. Odoo includes rules that match lines to open invoices and bills by amount and reference. You add rules for your own recurring cases.

  • Bank charges: lines containing words such as commission or fees go to the bank charges account, with VAT where applicable.
  • Card settlements: payment gateway or POS card payouts matched to the card clearing account, with the fee split out.
  • Internal transfers: transfers between your own accounts go to an internal transfer account.
  • Recurring payments: rent, salaries and loan instalments matched by partner and amount.
  • Small differences: underpayments within a tolerance written off to a discount or exchange account.

A well-tuned set of rules usually matches 70% to 90% of lines with no manual work. The rest are the lines that deserve attention.

Person reviewing a bank statement with a pen
Good rules leave only the lines that genuinely need a person.

Cheques, currencies and payment gateways

Three situations are common in the region and deserve their own setup.

Post-dated cheques

A cheque received today may clear in three months. Treat it as a payment in a cheques-in-hand account, and reconcile it only when the bank credits it. Our guide to post-dated cheques in Odoo covers the full lifecycle.

Foreign currency accounts

Keep a separate bank journal for each currency account, and let Odoo book exchange differences when a payment is reconciled at a different rate. See multi-currency and revaluation in Odoo.

Payment gateways and couriers

Online payments and cash on delivery arrive as one net payout covering many orders. Use a clearing account per gateway or courier and match the payout against it. Our guide to bank and payment gateway integrations and cash on delivery in Odoo show how.

A weekly routine

  1. Daily or every two days

    Import statements for each bank account

  2. Weekly

    Reconcile all lines; investigate anything left unmatched

  3. Weekly

    Review outstanding payments and receipts older than two weeks

  4. Month end

    Confirm journal balances equal bank balances, print the reconciliation report

Items that sit in outstanding accounts for weeks are the ones that cause trouble: a cheque that bounced, a payment registered twice, a transfer sent to the wrong account. Finding them weekly means finding them while someone still remembers what happened.

Bank reconciliation is the first item on our year-end closing checklist, and a clean bank is what makes management dashboards reliable.

FlexCode automates your bank reconciliation

We set up statement imports for your banks, build reconciliation rules for fees, cards and couriers, and clean up old outstanding items.

Book a free call

Frequently asked questions

Can Odoo connect directly to banks in Egypt and the Gulf?

Coverage is limited. Most companies import statement files in Excel, CSV, CAMT.053 or MT940, which works well when done regularly.

What is a reconciliation model?

A rule that tells Odoo how to handle certain statement lines, such as matching invoices, booking bank fees or splitting card settlements.

What are outstanding payments and receipts?

Accounts where payments registered in Odoo wait until the bank statement confirms them.

How often should we reconcile?

Import statements daily or every few days and reconcile weekly. Monthly reconciliation leaves too much to investigate.

How do we handle post-dated cheques?

Record them in a cheques-in-hand account and reconcile them when the bank credits the amount.

Talk to us about how Odoo fits your business. Book a free call

Run invoicing, stock and accounts from one system.

FlexCode Middle East implements Odoo in Arabic and English for companies in Egypt, Saudi Arabia and the UAE.