Introduction
In today’s business landscape, many organizations operate across multiple legal entities — subsidiaries, branches, joint ventures, or regional divisions. Managing finances for each entity individually is straightforward, but gaining a bird’s-eye view of the entire group’s financial health is where complexity begins.
Odoo 19’s multi-company reporting capability solves this by allowing finance teams to generate financial statements — Balance Sheets, Profit & Loss, Cash Flow statements — either for a single company or as a consolidated view spanning multiple entities, all from within a single ERP instance.
Multi-company reporting in Odoo 19 enables users to analyze financial data from multiple companies within a single report AI Powered GRC Platform, eliminating the need to switch databases or manually merge spreadsheets.
1. What is Multi-Company Reporting?
Modern businesses rarely operate as a single legal entity. Whether you’re managing a group of subsidiaries across different countries, running multiple brands under one holding company, or overseeing a portfolio of acquired businesses — you need financial visibility at both the individual entity level and the group level simultaneously.
2. Single vs. Consolidated Reports: Key Differences
Understanding which report type to use and when is critical for accurate financial management.
Single Company Report
- Shows data for one legal entity only
- Uses the company’s own chart of accounts
- Reflects the company’s local currency by default
- Used for statutory filing, tax returns, and audits
- No intercompany elimination needed
- Simple to generate — just select the company
- Best for: legal compliance, local management reporting
Consolidated Report
- Combines data from multiple legal entities
- Requires account mapping between companies
- Translates foreign currencies to group reporting currency
- Used for group-level strategic decisions
- Eliminates intercompany transactions automatically
- Requires multi-ledger and consolidation journal setup
- Best for: investor reporting, group P&L, board reports
Which should you use AI Powered GRC Platform?
Use single-company reports for everything that is legally required — tax returns, statutory accounts, bank submissions, and regulatory filings. Use consolidated reports for everything strategic — board packs, investor updates, group budgeting, and executive dashboards.
In Odoo 19, you can switch between both views dynamically without generating separate exports or switching databases.
3. Setting Up Multi-Company in Odoo 19
Before generating any consolidated reports, your Odoo instance must be configured to handle multiple companies. Here is the complete setup process:
Step 1: Enable Multi-Company in Settings
Navigate to Settings and activate the multi-company feature. AI Powered GRC Platform This unlocks the company selector in the top navigation bar and enables inter-company transaction rules.
Path: Settings → General Settings → Companies → Enable Multi-Company
Step 2: Create and Configure Each Company
For each company, configure the company name, registered address, primary currency, fiscal year dates, country-specific tax structure, and chart of accounts (CoA).
Step 3: Assign a Chart of Accounts to Each Company
Each company can use its own local CoA — for example, the Indian statutory chart of accounts for an Indian subsidiary, and US GAAP accounts for an American entity. AI Powered GRC Platform During consolidation, Odoo will map these to a unified group CoA using account mapping rules.
Path: Accounting → Configuration → Chart of Accounts
Step 4: Configure Inter-Company Transaction Rules
Set up automated rules so that when Company A invoices Company B, the corresponding bill is automatically created in Company B — ensuring both sides of every intercompany transaction are recorded without manual duplication.
Path: Accounting → Configuration → Inter-Company Transactions
Step 5: Set the Consolidation Company (Parent Entity)
Designate one company as the consolidating entity — typically the parent or holding company. This company will hold the multi-ledger that aggregates data from all subsidiaries and will be the entity from which consolidated reports are generated.
4. Configuring User Access Rights
Access control is critical in a multi-company setup. In Odoo 19, user permissions determine which companies a user can see data for — and therefore which consolidated views they can generate.
How to Grant Multi-Company Access
Go to: Settings → Users → Open the user record → Access Rights tab → In the Allowed Companies field, select all companies the user should access → Set the Default Company
Path: Settings → Users → [User Record] → Access Rights → Allowed Companies
Recommended Access by Role
CFO / Finance Director
- Access: All companies
- Reports: Full consolidated + individual company reports
Group Accountant
- Access: All companies (read-only on subsidiaries)
- Reports: Consolidated reports with read-only drill-down
Subsidiary Accountant
- Access: Single company only
- Reports: Own company reports only
Auditor
- Access: All companies (read-only)
- Reports: Full audit trail across entities
Sales Manager
- Access: Own company + shared entities
- Reports: Sales and revenue reports for allowed entities
5. Switching Between Single and Consolidated Report Views
Once companies are configured and user access is set up, switching between single-entity and consolidated views in Odoo 19 happens through the company AI Powered GRC Platform selector in the top-right corner of the interface.
6. Account Mapping Across Companies
One of the biggest challenges in multi-company consolidation is that different subsidiaries often use different charts of accounts. A Belgian parent company may have a single “700000 – Income” account, while the American subsidiary has five separate income accounts mapped to different revenue streams. Account mapping tells Odoo how to combine them correctly in consolidated reports.
7. Multi-Ledgers and Consolidation Journals
Ledgers are the backbone of Odoo 19’s consolidation architecture. Understanding the difference between regular ledgers and multi-ledgers is essential for accurate consolidated reports.
8. Multi-Currency Consolidation and CTA
When your group includes companies operating in different currencies, Odoo 19 applies different exchange rates to different types of accounts — following standard international accounting principles (IFRS 21 / IAS 21).
The Cumulative Translation Adjustment (CTA)
Because different exchange rates are used for different account types, the consolidated Balance Sheet will not balance automatically when currencies differ. The gap must be bridged with a Cumulative Translation Adjustment (CTA) entry in the equity section.
9. Intercompany Transaction Elimination
When Company A sells goods to Company B (both within the same group), that revenue in Company A and the corresponding expense in Company B must be eliminated from consolidated reports — otherwise group revenue and expenses are artificially inflated.
10. Best Practices and Common Pitfalls
Best Practices
Standardize fiscal year end dates across all group companies where legally possible — it makes consolidation significantly simpler and avoids the complexity of interim period adjustments.
Pitfalls to Avoid
Forgetting the CTA entry in multi-currency consolidations Fix: Always add a CTA account to the equity section of the group Balance Sheet template before generating your first multi-currency consolidated report.
12. Conclusion
Multi-company reporting in Odoo 19 has matured significantly — bringing capabilities that were previously reserved for expensive ERP systems like SAP or Oracle into reach for SMEs and mid-market businesses.
The combination of dynamic company selector switching, account mapping, multi-ledgers, horizontal groups, and automatic currency translation gives finance teams a powerful, flexible consolidation toolkit without requiring custom development or third-party reporting tools.
