Reconciliation models are custom rules that supplement the standard matching and allow for more automation — useful for recurring entries such as bank charges or cash discounts.
Where to find it
In Odoo 18, go to Accounting → Configuration → Reconciliation Models (under Banks). In older versions you reached this via the drop-down menu on the bank journal on the Accounting dashboard. Click New to create a model.
Manual or automatic
Reconciliation models can be manual or automatic. Manual models appear as action buttons while you reconcile. Automatic models are applied automatically to transactions that meet the model's match conditions.
Match conditions
The match conditions determine which transactions the model applies to. Among other things, you can filter on:
- journals;
- partners;
- amount (lower than, greater than or between two amounts);
- label: contains, does not contain or Match Regex.
Every condition you fill in has to be true. If you leave everything blank, the model is available for all transactions.
Counterpart items
In the Counterpart items tab you define one journal item per row: partner, account, amount type (fixed, percentage of balance, percentage of statement line, or From label — an amount or percentage is then pulled from the label using regex), amount, taxes, analytic and label. Fill in at least a partner or an account.
Standard models and partner mapping
Odoo ships with standard models such as:
- Invoices/Bills Perfect Match — matches a transaction one-to-one with an open invoice;
- Invoices/Bills Partial Match if Underpaid — links a partial payment to the invoice and leaves the remainder open or writes it off;
- Line with Bank Fees — the remaining balance to the bank charges account.
Which ones you see depends on your localisation. With partner mapping you link transactions to the right partner automatically, based on for example a reference or a label: under Counterpart items set only the partner; you can leave the account blank.
Tip: the order of the models matters. If more than one model fits, the first in the list wins. Drag the handle next to the name to change the order.