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
Go to the Accounting dashboard, click the drop-down menu on the bank journal and choose Models under Reconciliation. Or: Accounting → Banks and Cash → Bank Reconciliation → Reconciliation models. 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:
- Internal transfers — the full amount to a liquidity or internal transfer account; use the model on both sides of the transfer;
- Bank fees — the remaining balance to the bank charges account;
- Cash Discount — discounts for early payment.
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.