Multi-Entity Workarounds in QuickBooks Online
Managing multiple companies in QBO—workarounds, tools, and knowing when to upgrade.
Key Takeaways
- •QBO is one company per subscription—no native consolidation
- •For 2 entities, manual consolidation in Excel is often manageable
- •For 3+ entities with intercompany transactions, consider upgrading
- •Third-party reporting tools can help bridge the gap
- •Sage Intacct is typically the best 'next step' for multi-entity
Option 1: Classes Within One Company
Best for: Divisions or locations within one legal entity. Use classes to track segments—doesn't work for separate legal entities.
Option 2: Separate QBO + Excel
Best for: 2-3 entities with simple relationships. Export and consolidate manually—requires discipline.
Option 3: Third-Party Tools
Best for: Growing to 3-5 entities. Fathom or Reach Reporting connect to multiple QBO accounts.
Option 4: Upgrade to Multi-Entity ERP
Best for: 3+ entities with intercompany transactions. Sage Intacct or NetSuite handle natively with audit trails.
Multi-entity consolidation is QuickBooks Online's biggest limitation for growing businesses. If you have multiple legal entities—holding companies, subsidiaries, or related businesses—QBO doesn't have native tools to consolidate them.
Your Options
Option 1: Classes Within One Company
Best for: Divisions, departments, or locations within one legal entity
Use classes to track different segments. Get segment P&Ls easily. Doesn't work for separate legal entities that need their own equity, tax, and legal reporting.
Option 2: Separate QBO Accounts + Excel Consolidation
Best for: 2-3 entities with simple intercompany relationships
Each entity has its own QBO. Export financials and consolidate in Excel. Works but requires discipline. Intercompany eliminations are manual.
Option 3: Third-Party Consolidation Tools
Best for: Growing to 3-5 entities, want to extend QBO's life
Tools like Fathom or Reach Reporting connect to multiple QBO accounts and provide consolidated views. Better than Excel but still has limitations.
Option 4: Upgrade to Multi-Entity ERP
Best for: 3+ entities, complex intercompany, audit requirements
Sage Intacct and NetSuite handle multi-entity natively with intercompany eliminations, consolidated reporting, and proper audit trails. This is the "real" solution.
When to Upgrade
If you're spending more than 5 hours per month on consolidation, have frequent intercompany transactions, or need audited consolidated statements, it's time to evaluate a real multi-entity solution. The cost of workarounds adds up.
Handling Intercompany Transactions
Intercompany transactions (management fees, loans, shared services) are the complexity driver. In separate QBO accounts:
- Record the transaction in both entities (receivable in one, payable in other)
- Use a consistent naming convention (e.g., "Due to/from [Entity Name]")
- Reconcile intercompany balances monthly—they must match
- Eliminate in consolidation (both the intercompany balances and any intercompany P&L)
Frequently Asked Questions
Can QuickBooks Online handle multiple companies?
QBO is one company per subscription. You can have multiple QBO subscriptions, but there's no native consolidation. For true multi-entity operations, you need workarounds (classes, manual consolidation) or should consider mid-market ERPs like Sage Intacct.
How do I consolidate multiple QuickBooks companies?
Options: (1) Manual consolidation in Excel—export each entity and combine, (2) Third-party tools like Fathom or Reach Reporting that connect to multiple QBO accounts, (3) Consolidation software designed for QBO. For complex intercompany transactions, manual approaches become unwieldy.
When should I upgrade from QuickBooks for multi-entity?
Consider upgrading when: you have 3+ entities, intercompany transactions are frequent and complex, consolidation is consuming significant time (5+ hours/month), or you need audited consolidated financials. Sage Intacct is often the best next step for multi-entity.
Can I use classes instead of separate QBO companies?
For single legal entities with multiple divisions or locations, yes—classes work well. For separate legal entities that need distinct financial statements, separate QBO accounts are usually required. Using classes for legal entities creates complexity around equity, intercompany, and legal reporting.
Struggling With Multi-Entity Complexity?
Eagle Rock CFO helps growing businesses with multi-entity structures evaluate their options—whether optimizing QBO workarounds or planning an ERP migration.
Schedule a Consultation