- Status
- In progress
- Sector
- Industrial group
- Company size
- More than 20 companies
- Business lines
- Business solutions
- Solutions
- Consolidated accounting in Odoo, Managed Odoo
Consolidated accounts that live in a spreadsheet
The group has more than twenty companies, with holdings at several levels, minority shareholders and joint ventures. At each close, the balance sheets of all of them are gathered and copied into an Excel workbook, and the transactions between them are eliminated by hand.
It works. But when someone asks where a figure in the consolidated accounts comes from, it has to be traced cell by cell.
- Balance sheets that arrive in different formats depending on the company
- Companies consolidated by different methods: full, proportional and equity method
- Balances and transactions between group companies that have to be matched and eliminated
- A consolidation scope that changes every year: companies that join, leave or merge
The same consolidated accounts, inside Odoo and fully traceable
The accounting criteria are still the group's own. Odoo reproduces its consolidation level by level and records where each number comes from.
Consolidation scope in writing
A questionnaire answered by the client sets which companies are included, with what percentage and by which method. Every change of scope is recorded in minutes.
Loading balance sheets
An importer for each source format loads the balance sheets into Odoo and checks that they balance before going any further.
Consolidation tree
The companies sit in a tree with the same levels the group uses for its consolidation.
Intercompany transactions
Each company declares its balances with the rest of the group. Odoo matches what agrees and leaves the rest for review.
Methods and minority interests
Full, proportional or equity-method consolidation depending on the company, with the minority shareholders' share calculated in its own layer.
The group balance sheet
The report comes out with the same columns as the workbook the group has always used, so the two can be laid side by side.
Status in November 2026
The project is in progress:
- The consolidation scope is closed and the client has identified the counterparties between companies.
- The balance sheets for a full group close are loaded in Odoo, in draft, and they balance.
- The declaration of balances between companies and their automatic matching are being built.
- The next step is the first parallel consolidation: the group does it as usual and we do it at the same time in Odoo, to compare the two results.
Nothing is posted until the client accepts the consolidated accounts in writing, level by level.
The group's Odoo is hosted on our servers, as Managed Odoo. The method is explained in consolidated accounting in Odoo.
What will be measured at the close
When the project closes, three things will be measured: how many companies end up consolidated in Odoo, how many days the consolidated close takes before and after, and how far Odoo's consolidated accounts differ from the group's in the parallel test.
Do you consolidate several companies in a spreadsheet?
Show us the workbook you consolidate with today. We'll tell you which part Odoo can do and which decisions need settling first.