Back to knowledge base

Reconciliation models for automatic bank reconciliation

Reconciliation models are custom rules that complement the default matching and enable more automation – useful for recurring items like bank fees or cash discounts.

Where to find it

Go to the Accounting dashboard, click the dropdown menu on the bank journal, and under Reconciliation select Models. Or: Accounting → Bank and cash accounts → Bank reconciliation → Reconciliation models. Click New to create a model.

Manual or automated

Reconciliation models can be either Manual or Automated. Manual reconciliation models appear as possible action buttons when reconciling. Automatic reconciliation models apply automatically to transactions that meet the reconciliation model's matching conditions.

Matching conditions

Matching conditions determine which transactions the model applies to. You can filter by journals, partners, amount (lower than, greater than, or between two amounts), and by label: contains, does not contain, or Match Regex. All conditions must be met. Leave everything blank and the model is available for all transactions.

Counterpart items

In the Counterpart items tab you define each journal line: partner, account, amount type (fixed, percentage of balance, percentage of statement line, or From label – then an amount or percentage is taken from the transaction label via regex), amount, tax, analytic, label. Set at least partner or account.

Default models and partner mapping

Odoo provides default models such as Internal transfers (full amount to liquidity or internal transfer account; use the model on both sides of the transfer), Bank fees (remaining balance to bank fees account), and Cash discount. Which ones you see depends on your localization. With partner mapping you automatically link transactions to the correct partner based on e.g. reference or description: in Counterpart items set only the partner, account can stay empty. Tip: the order of models matters. If more than one model matches, the first in the list wins. Drag the handle next to the name to change the order.

Frequently asked questions

Where do I find reconciliation models in Odoo?
Go to the Accounting dashboard, click the dropdown on the bank journal, and under Reconciliation select Models. Or via Accounting > Bank and cash accounts > Bank reconciliation.
What is the difference between manual and automated?
Manual models appear as buttons when you reconcile a transaction; you choose when to apply them. Automated models apply automatically to transactions that meet the matching conditions.
Why is the wrong model being applied?
The order of models matters: the first model that matches wins. Drag the handle next to the name in the list to change the order.