Skip to Content

Odoo 20 accounting and reporting updates

Faster reports, banking, reconciliation and tips from the OX 2026 sessions
​ September 24, 2026 by
Odoo 20 accounting and reporting updates

After the keynote, Odoo Experience 2026 had sessions on Reporting, Bank synchronization and Hidden gems. Below, what matters for accounting and reports, with the Contaldia filter (Spain first) and screenshots from those sessions. It is still not “Odoo 20 in production in Spain”: it is what we saw in Brussels.

OX 2026

Reporting · Bank · Hidden gems
Brussels, 24–26 Sep

0.2 s

a user report in 20
(2.5 s in 19, session demo)

1 Oct

16:00 · Contaldia course
live walkthrough

Bank: more connectors, duplicates and pay from the bill

In 20 there are more connected institutions (the session slide says 200+, in 50+ countries). In Spain we will still check bank by bank: we do not treat CaixaBank, Sabadell or BBVA as covered until we try it on a live database.

More bank connectors in Odoo 20

Bank synchronization: more connectors. Figures from the OX 2026 slide, not a Contaldia count.

If the statement arrives short, Fetch Missing Transactions recovers lines. If duplicates slipped in, Find duplicate transactions flags them and you can delete them by hand.

Fetch Missing Transactions and Find duplicate transactions in Odoo 20

Statement menu: recover missing lines or find duplicates.

Delete duplicate statement transactions in Odoo 20

Duplicates selected for deletion. The demo is a Belgian bank.

Payments: Send to Bank uploads the SEPA remittance from Odoo. And from the bill itself, Register Payment in one click. The demo is KBC (Belgium). We will look at the Spanish circuit on 1 October; we do not treat it as identical.

Send to Bank: upload a SEPA remittance from Odoo 20

Send to Bank on a payment batch. KBC demo; the mechanism is what matters.

Pay a vendor bill in one click in Odoo 20

Register Payment from the bill, with account and method already filled.

Documents, VAT, assets and sequences

From Documents, many things can be done such as creating the invoice and editing the actions: send, create supplier invoice, move the PDF to another location in Odoo. Useful in any company to centralize documentation in Odoo.

Documents actions: send or create a vendor bill

Actions on a PDF: Send, Create Vendor Bill, and the rest of the circuit.

In the purchase invoice, lines can be grouped by VAT type. 

Group vendor bill lines by VAT type in Odoo 20

Group by taxes on the vendor bill. Hidden gems, OX 2026.

An entry is split into several lines (Split) to create an asset per unit, without having to redo the invoice manually.

Split into 10: from one €500 line to ten of €50, ready for Create Asset.

The purchases dashboard warns of irregular sequences. In supplier invoices, a gap is not illegal, but to resequence it requires developer mode and Resequence, already available in previous versions.

Irregular sequences warning on the purchases dashboard

Irregular sequences on Purchases. The gap is a vendor gap; it is not a 347.

Resequence wizard for vendor bills

Resequence: first number and start date. Developer mode.

Change period or date in bulk: entries are selected and Actions → Change Period. Very useful for moving or changing the date en masse of incorrectly accounted invoices in closed quarters or periods, easy to search and resolve.

Change Period on Odoo 20 journal items

Change Period on two journal items. Hidden gems, OX 2026.

Reconcile every bank on one screen

Accounting → Reconcile combines the pending statements. Auto-reconcile exists; it needs to be properly configured or it mixes what shouldn't be. It is useful and available since several versions, although personally, I prefer to do it bank by bank and keep it up to date to avoid accumulating or having to do massive reconciliations that may have some errors.

Reconcile screen for all banks in Odoo 20

Reconcile: several bank journals in the same view, with Match.

Auto-reconcile of bank statements in Odoo 20

Auto-reconcile. Use it with clear rules; not blindly.

Taxes of another country, compared P&L and mismatches

When creating a tax from another country, Odoo offers to install the entire package from that country. In an easy way, we avoid creating taxes manually and prevent mapping errors in reports, a very good solution.

Prompt to install taxes of another country in Odoo 20

Create Luxembourg Taxes. The pattern applies to any localization country.

The P&L compares by amount and by percentage (Horizontal Analysis). The gear on the right opens the report settings without leaving the screen, allowing you to configure your company's report.

P&L with percentage comparison in Odoo 20

Comparison + % of a column. Demo figures.

If the Balance Sheet does not balance (assets ≠ liabilities), there is almost always a chart account not mapped in the report. Accounts Coverage Report marks them in red. Contaldia advice: fix the account number so it fits the PGC; do not twist the report.

Unbalanced Balance Sheet in Odoo 20

Unbalanced: the report itself warns and links to coverage.

Accounts Coverage Report with unmapped accounts

Accounts in red: they are on the chart and not on the Balance Sheet. Map them or renumber them.

Composite reports: Accounting → Settings → Accounting Reports → New, check Composite Report, add the ones you want and upload them to the menu, allowing you to group several reports with a simple click.

Create a Composite Report in Odoo 20

Composite Report: several reports in one, then Add to menu.

Spreadsheets, % search and mass edit

From a report, a pivot table is inserted into an Odoo spreadsheet. The dashboard remains a sheet within the ERP, not an orphan Excel. A functionality that existed before but is very useful.

Insert a pivot table into an Odoo 20 spreadsheet

Insert in spreadsheet → Pivot. It also works for a list of bills.

Two tricks have not been mentioned in OX 2026 but I use them every day. 
The % in the search omits what is between two words: useful for contacts or products with long names. 

Percent wildcard search in Odoo

contaldia%online finds Contaldia Online Consulting. The % omits the word in the middle.


And the bulk change of accounts, analytics or different items, if you select several entries (or invoices) and change the account in the list, it applies to all. Bulk editing of accounts, analytics and more, without entering one by one.

Mass edit of accounts from journal items

Several journal items selected: change the account in the list and it applies to all.

Reports: more columns, faster

The Balance Sheet in 20 has more columns than fitted in 19: before/after, debit and credit, percentage of a column, and a Load more to add others. Less parallel Excel for the same cut.

Load more. Session capture Reporting, OX 2026.

Speed and memory: Odoo drops the dictionaries of 19 and moves to data objects. In the demo, a user report went from 2.5 s to 0.2 s. It affects audit, balances, ledgers and journals. Session figures, not a Contaldia database.

Report speed comparison Odoo 19 versus Odoo 20

Same query: 2.5 s in 19, 0.2 s in 20. Reporting slide.

There are snapshots of a report: computed once and reopened without hitting the whole journal again. And line grouping (by journal, by tag, by whatever you ask) goes further than in 19.

Report snapshots in Odoo 20

Snapshot list on a report. Reporting session, OX 2026.

Line grouping in Odoo 20 reports

Group by on the report, with more options than in 19.

How we will look at this

Contaldia has been running Odoo since 2009. On 1 October, at 16:00, the online updates course: which of this touches closing, the 303 and the bank in Spain, and what is worth waiting for before upgrading a production database.

On 29 October, from 12:00 to 14:00, the full Spanish accounting course on Odoo 20.

Sources: Reporting, Bank synchronization and Hidden gems sessions at Odoo Experience 2026 (Brussels); Contaldia notes. As of 24 Sep 2026 Odoo had not yet published the formal 20 release notes on odoo.com. What only appears in partner blogs we leave as rumour. The figure “49 AI features” does not appear in these sessions: we do not use it.

1 October · 16:00 · online

Odoo 20 updates live. Limited seats. Free for the first 100.

Register for the course