Skip to Content

Group finance Odoo consolidation for groups of companies

Your group's consolidated figures come out of Odoo, with one column per company and the adjustments in plain sight. Even if each company keeps its books in different software.

  • Consolidation scope
  • Intercompany eliminations
  • Sub-consolidations
  • Minority interests
  • Balance sheet by company
The problem

The consolidation lives in a spreadsheet only one person understands

A group with many companies has usually consolidated the same way for years: each company sends in its accounts, someone copies them into a workbook with linked tabs, and eliminations between group companies are done by hand.

It works while that person is around and the group doesn't change. When a company joins or a shareholding changes, formulas have to be rebuilt, and nobody can say for sure where each figure comes from.

  • Intercompany balances that don't match, and nobody knows why
  • Each company with its own chart of accounts and its own software
  • Weeks of work at every close
  • Adjustments that are hard to justify to the auditor
What we do

What we set up in Odoo

We reproduce your current consolidation, level by level, and leave it ready to repeat at every close. It's the method we're following with an industrial group of more than twenty companies.

Group scope

Which companies are in, with what percentage and by which method: full consolidation, proportional consolidation or the equity method. With temporary joint ventures and minority interests where they belong.

Common chart of accounts

Each company keeps its own chart of accounts. We map it to a common group structure, so all the companies' balance sheets can be added together.

Loading balances

Companies that aren't on Odoo stay on their own software. We load their balances at every close, whether they come from SAP, Sage, A3 or a spreadsheet.

Intercompany eliminations

A catalogue of counterparties between companies, validated by your finance team, from which the eliminations are generated. Mismatches show up company by company.

Sub-consolidations

We set up the intermediate subgroups and the adjustment levels you already use today, one on top of another, up to the group consolidation the auditor reviews.

Reports

A consolidated balance sheet with one column per company and the group total, taken from Odoo on the spot, without waiting for someone to update the spreadsheet.

How we work

From the spreadsheet to Odoo, step by step

Starting point

We start from your master workbook and a scope questionnaire. What is a hidden formula today becomes a written rule.

Pilot

We load one subgroup and check that it matches your consolidation to the cent. Until it does, we don't move on.

The full scope

The remaining companies and their counterparties go in. Questions are settled with your team in reviews with minutes.

Parallel close

One close done at the same time with the usual method and in Odoo. The results are compared and every difference is explained.

Closing in Odoo

From that close on, the group consolidation is done in Odoo and the old spreadsheet is archived.

Case studies

Groups of companies on Odoo

Read on

What sits around the consolidation

Business solutions

Odoo partner

ERP and CRM with Odoo: implementation, custom development, hosting and support from a single team.

Business solutions

Managed Odoo

Odoo Private SaaS: your Odoo on a dedicated server in the European Union, with backups, updates and monitoring.

Business solutions

Custom Odoo development

Modules and integrations when the standard isn't enough, tested separately and deployed after review by another person.

Frequently asked questions

What finance teams ask us

Do all the companies have to be on Odoo to consolidate?

No. Odoo receives each company's balances at every close, whatever software they come from. If some already keep their books in Odoo, all the better, but it isn't a requirement.

How often can we consolidate?

As often as you close: monthly, quarterly or yearly. Once it's set up, repeating the consolidation means loading the period's balances and reviewing the mismatches.

What happens when a company joins or leaves the group?

It's added with its percentage, its method and its date of entry, its balances are loaded and its counterparties are added. The rest of the consolidation isn't touched.

Does it replace the consolidated annual accounts?

No. Odoo gives you the consolidated balance sheet and the trail of every adjustment. The annual accounts, with their notes, are still prepared by your team and reviewed by your auditor.

How does your group consolidate today?

Tell us how many companies you have and what software they use. We'll tell you how we would set it up and what we would need from your team.