Odoo Multi-Company Setup: Managing Multiple Entities in a Single Database

Businesses operating multiple legal entities face a choice: run separate ERP instances or consolidate into a single database. Odoo's multi-company feature manages multiple entities in one database with strict data separation, inter-company automation, and consolidated reporting.

Key Takeaways

• Multi-company runs all entities in one database with shared master data (products, contacts) but separate financials, taxes, and warehouses.
• Inter-company transactions automate — a sale in Company A creates a purchase in Company B automatically.
• User access is company-scoped — employees see only data for companies they belong to, enforced through record rules.
• Consolidated reporting combines all entities for group-level P&L, balance sheet, and cash flow without manual spreadsheets.
• Multi-company is NOT needed for departments or offices — use analytic accounting instead.

When to Use Multi-Company

Use it when you operate multiple legal entities sharing customers or products, a parent company has subsidiaries, you run multiple brands under one umbrella, or you operate in multiple countries with different fiscal requirements. Do not use it for internal organizational divisions like departments.

Setup Process

Step 1: Create Companies

Navigate to Settings > Companies > Manage Companies. Your primary company exists; add additional ones. Each company needs its own legal name, address, logo, currency, fiscal year, chart of accounts, and tax configuration.

Step 2: User Access

Assign users to one or multiple companies. Users see the company switcher in the top navigation bar. Record rules enforce data isolation — users only access data for their assigned companies. Admin users can belong to all companies for cross-entity reporting.

Step 3: Inter-Company Transactions

Enable inter-company rules under Settings. When Company A sells to Company B, Odoo automatically creates a purchase order in Company B. This eliminates manual duplicate entry and ensures both entities' books stay synchronized.

Configure transfer pricing rules, inter-company journals, and elimination accounts for consolidated reporting.

Step 4: Shared vs. Separate Data

Shared across companies: Products, contacts, employees (can belong to multiple companies).

Separate per company: Chart of accounts, tax configuration, bank accounts, journals, warehouses, sequences (invoice numbers), fiscal positions.

Configurable: Whether products have company-specific pricing, whether warehouses are shared or dedicated, and whether purchase/sale flows cross company boundaries.

Multi-Company Accounting

Each company maintains independent books with its own COA, tax rules, and bank accounts. Journal entries are always company-scoped. Inter-company transactions create journal entries in both entities simultaneously.

For consolidated reporting, Odoo aggregates data across all companies. Elimination entries remove inter-company revenue and expenses. Multi-currency handling converts subsidiary figures to the parent's functional currency.

Common Configuration Mistakes

1. Over-sharing data — Keep financial data strictly separated. Share only what genuinely needs sharing (contacts, products).
2. Missing inter-company rules — Without automation, staff manually duplicate orders across entities, causing errors.
3. Wrong user company assignment — Users accidentally creating records in the wrong company is the most common operational error. Default company settings and training prevent this.
4. No elimination entries — Inter-company sales inflate group revenue without proper eliminations.

Frequently Asked Questions

Q: How many companies can run in a single Odoo database? A: There is no hard technical limit. Businesses commonly run 5-20 companies in one database. Performance depends on total transaction volume rather than company count. For 50+ companies, ensure proper database sizing.

Q: Can different companies use different currencies? A: Yes. Each company sets its own functional currency. Inter-company transactions handle currency conversion automatically using Odoo's exchange rate system. Consolidated reports convert all entities to the parent company's currency.

Q: Can I separate companies later if needed? A: Splitting a multi-company database into separate instances is technically possible but complex. It requires data extraction, deduplication of shared records, and re-configuration. Plan your multi-company architecture carefully before implementation.

Q: How does multi-company affect licensing costs? A: Odoo Enterprise licenses are per-user, not per-company. A user who belongs to three companies still counts as one user. This makes multi-company very cost-effective compared to running separate instances.

Next Steps

ECOSIRE's Odoo implementation services include multi-company setup, inter-company automation, and consolidated reporting. Contact us for a free assessment.