Odoo Consolidation: Multi-Company Accounting Guide

What Is Odoo Consolidation?

Odoo Consolidation aggregates financial data from multiple companies into unified financial statements. When you operate several legal entities, subsidiaries, or divisions, consolidation lets you see the combined financial position — eliminating inter-company transactions and providing a true picture of the group's performance.

Module Setup

Install the Consolidation module from Apps. It requires the Accounting module and is only available in Enterprise edition. The module works alongside multi-company Odoo setups or can import data from external sources.

Consolidation Groups

A consolidation group defines which companies are combined and how.

Creating a Consolidation Group

1. Consolidation → Configuration → Groups
2. Name the group (e.g., "ACME Holdings Group")
3. Add subsidiary companies
4. Set the consolidation currency
5. Define the chart of accounts for consolidation

Group Structure

# Example consolidation structure:
# ACME Holdings (Parent)
# ├── ACME Manufacturing (100% owned)
# ├── ACME Sales USA (100% owned)
# ├── ACME Sales EU (100% owned)
# └── ACME Logistics (75% owned → minority interest)

# Consolidation methods:
# Full consolidation — 100% owned subsidiaries
# Proportional — Jointly controlled entities
# Equity method — Significant influence (20-50%)

Chart of Accounts Mapping

Each subsidiary may have a different chart of accounts (different countries, different standards). Map subsidiary accounts to the consolidated chart:

Data Import

From Odoo Companies

For subsidiaries running on the same Odoo instance, consolidation pulls journal data directly. No export/import needed.

From External Sources

For subsidiaries on separate systems (different Odoo instances, SAP, QuickBooks), import trial balance data:

1. Export trial balance from subsidiary system (CSV)
2. Import into Consolidation module
3. Map accounts to consolidated chart
4. Apply currency conversion

Inter-Company Eliminations

The most critical part of consolidation is eliminating inter-company transactions to avoid double-counting:

# Common eliminations:
# 1. Inter-company sales/purchases
#    Company A sells $100K to Company B
#    → Eliminate $100K revenue + $100K cost of goods

# 2. Inter-company receivables/payables
#    Company A owes Company B $50K
#    → Eliminate $50K AR in B + $50K AP in A

# 3. Inter-company dividends
#    Subsidiary pays $25K dividend to parent
#    → Eliminate dividend income + dividend payment

# 4. Inter-company investments
#    Parent holds $1M investment in subsidiary
#    → Eliminate investment + subsidiary equity

Configuring Eliminations

• Define inter-company account pairs (AR ↔ AP, Revenue ↔ COGS)
• Odoo matches and proposes elimination entries
• Review and validate before applying
• Elimination entries only affect consolidated reports, not subsidiary books

Currency Conversion

For subsidiaries reporting in different currencies:

• Balance sheet items — Converted at closing rate (period-end exchange rate)
• Income statement items — Converted at average rate for the period
• Equity items — Converted at historical rate
• Translation differences — Recorded in a separate equity account (OCI)

Consolidated Reports

• Consolidated Balance Sheet — Combined assets, liabilities, equity
• Consolidated P&L — Combined revenue and expenses
• Consolidated Cash Flow — Group cash movements
• Minority Interest — Non-controlling interest in partially owned subsidiaries

Consolidation Workflow

# Monthly consolidation process:
# 1. Close subsidiary books (lock periods)
# 2. Import or sync trial balance data
# 3. Map any new accounts to consolidated chart
# 4. Apply currency conversion
# 5. Generate and review elimination entries
# 6. Produce consolidated financial statements
# 7. Review and approve consolidated reports

Best Practices

• Standardize charts of accounts — Consistent structures simplify mapping
• Close subsidiaries first — Consolidation is only as accurate as subsidiary data
• Automate eliminations — Define rules to reduce manual entry
• Document mapping — Maintain a mapping table for audit purposes
• Reconcile regularly — Verify inter-company balances net to zero

DeployMonkey + Consolidation

DeployMonkey's AI agent configures consolidation groups, account mapping, and elimination rules for multi-company financial reporting.