Automatic bank reconciliation in Odoo: what it is and how to do it

A tool to reduce the time spent

Automatic bank reconciliation is a fundamental tool of Odoo's accounting module that allows for the automatic linking of bank transactions with existing accounting transactions in the system, such as customer invoices, received payments, supplier invoices, or any other accounting entry. 

  This prevents the user from having to review each line of the bank statement to find matches manually, significantly reducing the time spent on accounting and minimizing errors.  

In practical terms

When an automatic reconciliation is performed, Odoo compares each line of the bank statement with open invoices, pending payments, or reconciliation rules that the user has configured. The system analyzes various criteria, such as the amount, payment reference, customer or supplier name, and even patterns in the transaction descriptions. 

As a result, if it finds an exact match or one that meets the established rules, it reconciles the operation automatically. For example, if a customer pays an invoice of €1,500, and that same amount appears in the statement with the customer's name in the description, Odoo will automatically mark the invoice as paid and record the corresponding accounting transaction.  

Tools

To implement automatic bank reconciliation in Odoo, it is first necessary to correctly configure the bank accounts. This is done within the Accounting module, linking each bank account with the corresponding accounting account. 

Then, you can choose to import the statements manually in formats such as CSV, Excel, OFX, or CAMT.053, or establish a direct connection with the bank, which allows for automatic daily synchronization of bank transactions.  

Set up reconciliation rules

These rules are essential because they allow Odoo to automatically recognize certain types of recurring or special transactions, such as bank fees, interest, or recurring supplier payments. 

  Per exemple, si el banc cobra una comissió fixa per transferència, pots crear una regla que automàticament registri aquesta despesa comptable cada vegada que aparegui a l'extracte.

.  

Odoo applies automatic reconciliation

Once the statement is imported, the lines that match invoices, payments, or predefined rules are reconciled without manual intervention, while those that do not find a match remain pending, ready to be reviewed and reconciled manually. This ensures that the bank and accounting balance is always up to date, providing a clear view of the cash flow and the financial situation of the company.

Benefits

Automatic bank reconciliation in Odoo not only saves time and reduces errors, but also brings transparency and control to financial management. Thanks to it, companies can keep their accounting up to date efficiently, allowing financial managers to focus on analysis and decision-making instead of repetitive tasks.   

The setup 

1.  Pre-setup

Bank connection or statement import

Odoo allows you to connect to the bank via synchronization (depending on the country and bank) or import statement files in formats such as CAMT.053, OFX, QIF, CSV, or Excel.

Set up bank accounts

In the Accounting module > Configuration > Banks and bank accounts, the bank account is linked to the accounting account.

Define automatic reconciliation rules

In Accounting > Configuration > Reconciliation Rules, you can create rules that automatically recognize certain items (e.g., commission charges, internal transfers).

    2.Automatic reconciliation process

Import or synchronize bank statement

Each line of the statement appears as a pending transaction in Odoo.

Apply automatic matches

Odoo searches for invoices, payments, or rules that match the amount, reference, or name.

If it finds an exact match → reconciles immediately.

Manual review (if necessary)

Lines that do not match automatically remain pending, and the user can reconcile them manually with invoices, payments, or create a journal entry (e.g., bank charges).

   3.Practical example

The bank records a credit of €1,200.

Odoo has an open customer invoice for €1,200 with the same name in the description.

Odoo automatically reconciles the transaction with the invoice and marks the invoice as paid.