This module extends the functionality of accounting to allow you to consolidate journal items in a consolidation company.
auto_awesome What this module does
AI-generated from the code · Odoo 14.0Consolidate the accounts of several subsidiary companies into one consolidation company. Users define consolidation profiles, run configuration checks and generate consolidation journal entries for a chosen month.
This module adds a consolidation area to Accounting for companies that need to combine several subsidiaries into one holding company.
In Accounting settings you can mark a company as a "Consolidation company", choose a default consolidation journal and a consolidation difference account, and list the subsidiaries to consolidate with a percentage (0-100). Only one company can be flagged as the consolidation company, and each subsidiary can appear in only one profile.
On each account you can set a "Consolidation account" that points to the matching account in the consolidation company. A "Consolidation" menu appears under Accounting with two wizards: - "Consolidation: Checks" verifies that every subsidiary account is mapped to a valid holding account, that intercompany partners are not linked to a company, and that the user has access to all subsidiaries. - "Consolidation: Consolidate" lets you pick a year, month, journal and target moves, then creates one journal entry per subsidiary on the holding accounts, applying the consolidation percentage and converting foreign currencies using monthly or spot rates. A balancing line is added on the consolidation difference account when needed. Previously generated consolidation entries are reversed first, and the new entries are flagged for automatic posting.
Journal items and moves show extra columns "Consolidated from" and "Intercompany Partner" for consolidation managers.
Depends on
Menus it adds
Models and fields (9)
- res.company · extends an existing modelis_consolidation (Consolidation company), consolidation_percentage, consolidation_profile_ids, consolidation_diff_account_id (Consolidation difference account), consolidation_default_journal_id (Default consolidation journal)
- account.move · extends an existing modelconsol_company_id (Consolidated from Company)
- account.account · extends an existing modelconsolidation_account_id (Consolidation account), consolidation_company_id
- account.move.line · extends an existing modelconsolidated, consol_company_id (Consolidated from), consol_partner_id (Intercompany Partner)
- res.config.settings · extends an existing modelis_consolidation (Consolidation company), consolidation_profile_ids (Consolidation profiles), consolidation_diff_account_id (Consolidation difference account), consolidation_default_journal_id (Default consolidation journal)
- account.consolidation.base · new modelcompany_id (Company)
- account.consolidation.check · new modelstate, message
- company.consolidation.profile · new modelcompany_id, sub_company_id (Subsidiary), consolidation_percentage (Consolidation percentage)
- account.consolidation.consolidate · new modelyear, month, journal_id (Journal), target_move (Target Moves), consolidation_profile_ids
Text generated by AI (DeepSeek) from reading the Odoo 14.0 code on GitHub; it may contain mistakes, so check the code before deciding. The module is very large and only part of the code was read. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 14.0
Confirmed on 2026-11-03 in branch 14.0 of OCA/account-consolidation.
terminal Installation and usage
OCA documentation · Odoo 14.0Configuration
Source · Odoo 14.0To install this module, you need the modules currency_monthly_rate to be available in your system.
To configure this module, you need to flag a company as Consolidation in the Accounting settings.
Then, you should define a consolidation difference account and a consolidation journal on the consolidation company, and create consolidation profiles for each subsidiary you want to consolidate.
For each subsidiary to consolidate, make sure the related partner of the company has no company_id defined.
Afterwards, you should define a consolidation account from your consolidation company, on every active account of the subsidiaries.
You can then use the 'Consolidation : Checks' wizard in Accounting > Adviser to ensure every active account of your subsidiaries are set, and company partners have no company defined.
Make sure you also defined currency rates and monthly currency rates on the consolidation company for the currencies of your subsidiaries, as P&L accounts are consolidated using monthly rates and B.S accounts using standard 'spot' rates.
Known issues
- Consolidation manager has access to all the settings, or he wouldn't be able to configure the module.
- Functional mapping of accounts is not tested. If no consolidation entries are generated, it's probably because the balance of mapped accounts is 0
- Correctness of companies hierarchy in profile rest on user
Usage
Source · Odoo 14.0To consolidate subsidiaries in your consolidation company, you should use 'Consolidation : consolidate' wizard in Accounting > Adviser.
You have to select the month until which every account move will be processed, and select if you want to consolidate all the moves or only posted ones.
This will generate a journal entry in YTD (Year-To-Date) mode on your consolidation company for each subsidiary. Those entries are flagged as 'auto_post', so they will actually be posted when you run the consolidation the next time.
The generated journal entries are unposted, allowing you to modify or delete it to run the consolidation again.
No verified information in OCA: Installation.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.