Intercompany Accounting and Consolidation in Odoo Multi-Company

Intercompany Accounting in Odoo Multi-Company#

When a parent company sells to its subsidiary, both entities need to record the transaction - and at group consolidation, those intercompany transactions must be eliminated to avoid double-counting. Odoo automates the mirror entries and supports consolidation reports.

Setup Prerequisites#

Settings → Companies: multiple companies defined and linked in the same Odoo database.

Accounting → Configuration → Settings → enable Multi-Company and Intercompany Transactions.

Intercompany Transaction Rules#

Accounting → Configuration → Intercompany Rules → New:

For each pair of companies that transact with each other:

• Company A (Parent) → Company B (Subsidiary)
• Rule Type: Sales (creates a purchase in Company B when Company A makes a sale)

Rule options:

• Validate: automatically post the mirror invoice in the other company
• Draft: create draft for review before posting

How It Works in Practice#

Scenario: Parent sells $10,000 of services to Subsidiary.

1. Parent records: Customer Invoice to Subsidiary - $10,000
2. Odoo automatically creates in Subsidiary's books: Vendor Bill from Parent - $10,000
3. Both entries are linked - changing the parent invoice updates the subsidiary bill

Without this automation: the accounting team at each entity would have to manually create and match intercompany entries - error-prone and time-consuming.

Intercompany Balance Sheet Accounts#

Parent GL:

• Accounts Receivable - Intercompany: $10,000 (owed by Subsidiary)

Subsidiary GL:

• Accounts Payable - Intercompany: $10,000 (owed to Parent)

At consolidation, these $10,000 balances offset each other and are eliminated.

Consolidation Report#

Odoo doesn't have a native full consolidation module in the standard edition, but you can:

1. Export the chart of accounts and balances from each company
2. Sum by account code across all companies
3. Eliminate intercompany receivable/payable balances (they net to zero)
4. Eliminate intercompany revenue/expense (parent's revenue = subsidiary's expense)

For automated consolidation, use:

• Odoo Consolidation module (Community/Enterprise add-on)
• Export to Excel with a consolidation worksheet
• Third-party BI tools (Metabase, PowerBI) connected to the Odoo database

Intercompany Loans#

Record intercompany loans using journal entries between companies:

• Parent posts: Debit Intercompany Loan Receivable, Credit Cash
• Subsidiary posts: Debit Cash, Credit Intercompany Loan Payable
• Monthly: Parent accrues interest income; Subsidiary accrues interest expense

At consolidation: loan receivable/payable eliminate; interest income/expense eliminate.