QuickBooks Multi-Entity Workarounds

Managing multiple entities in QuickBooks when you cannot yet upgrade to a true ERP.

Key Takeaways

  • •QuickBooks Online does not support true multi-entity consolidation—you need separate company files or workarounds
  • •Classes and locations provide 80% of the segmentation value of multi-entity at a fraction of the cost
  • •For three or fewer entities with simple needs, separate QuickBooks files with a consolidated reporting approach works
  • •Beyond three entities, consider a true ERP like NetSuite, Sage Intacct, or Microsoft Dynamics
  • •The best workaround depends on your specific needs: legal structure, reporting requirements, and budget

The Multi-Entity Challenge

Growing businesses frequently reach a point where they operate multiple legal entities. Perhaps you have separate entities for different business lines, for liability protection, or because you acquired another company. Maybe you operate in multiple states and have formed entities in each jurisdiction. The challenge is that QuickBooks Online does not have native multi-entity functionality. Unlike NetSuite or Microsoft Dynamics, QBO treats each company file as a completely separate database.

Option One: Separate Company Files

The most straightforward approach is creating separate QuickBooks Online company files for each entity. Each entity has its own subscription, its own chart of accounts, and its own data. This approach provides clean separation and is conceptually simple. However, it creates operational challenges: you must maintain multiple subscriptions, manage multiple logins, and consolidate financials manually or with third-party reporting tools.

The Consolidation Problem

When you have separate company files, consolidated reporting becomes a manual process. QuickBooks does not natively pull data from multiple company files into a single report. You have several options: manually combine reports in Excel, use QuickBooks' Consolidate feature (which has limitations), or implement a third-party consolidation tool like Solver or Insight FP&A. Each option has trade-offs between cost, complexity, and capability.

Option Two: Classes and Locations

If your entities are more like segments than separate legal companies, QuickBooks classes and locations may be the answer. Instead of creating separate company files, you run one company file and use classes to distinguish between entities. Each transaction gets tagged with a class, and you can run P&L reports by class to see each entity's performance. This works well when you do not need separate balance sheets or when the entities are closely related.

When Classes Work

Classes and locations work well when: entities share a bank account, entities have the same tax return, you do not need separate balance sheets, and you want simple consolidated reporting. If any of these do not apply, you need separate company files or an ERP.

Setting Up Classes for Multi-Entity

To use classes for multi-entity, first enable class tracking in QuickBooks settings. Then create a class for each entity. When entering transactions—invoices, bills, expenses—assign the appropriate class. At month-end, run Profit and Loss by Class to see each entity's contribution. You can even set up class-based rules to automate some of this tagging, though consistent manual entry is usually required initially.

Option Three: Combined Company File

Some businesses choose to put everything in one QuickBooks company file, using only the chart of accounts to distinguish between entities. This approach treats the combined business as one reporting entity, which works for income tax purposes but makes entity-specific reporting difficult. It also creates a messy chart of accounts with multiple sets of revenue and expense accounts. This approach is generally not recommended for businesses with distinct entities that need separate visibility.

Handling Intercompany Transactions

The trickiest part of multi-entity in QuickBooks is handling transactions between entities. When Entity A bills Entity B for management fees, rent, or shared services, you need to track this in a way that works for both. Options include: recording it as a journal entry in each file, using one file to track all intercompany activity, or simply eliminating it in consolidation. The right approach depends on how complex your intercompany activity is.

Third-Party Consolidation Tools

Several tools specialize in consolidating data from multiple QuickBooks company files. Solver (now insightsoftware) offers financial consolidation, budgeting, and reporting across multiple entities. Other options include Phocas, CFODashboard, and NetSuite's QuickBooks integration. These tools pull data from each QuickBooks file and create consolidated reports, dashboards, and even multi-entity budgets. They range from a few hundred to several thousand dollars per month depending on complexity.

When to Consider an ERP

If your multi-entity needs exceed what QuickBooks can handle, it may be time to consider an ERP system. True multi-entity ERPs like NetSuite, Sage Intacct, or Microsoft Dynamics offer: native consolidated reporting, intercompany transaction automation, unified dashboards across entities, centralized chart of accounts, and integrated billing and revenue recognition. The cost is significantly higher—typically $50,000+ for implementation plus ongoing fees—but the capability matches complex organizational needs.

Making the Decision

Start by honestly assessing your requirements. How many entities? Do you need separate balance sheets for each? Do you have complex intercompany transactions? What are your consolidated reporting needs? What is your budget for both software and the people to manage it? For most businesses with fewer than five entities and straightforward needs, a combination of separate QuickBooks files with consolidated reporting or classes within a single file will work. Beyond that, the complexity often justifies an ERP.

Frequently Asked Questions

Can QuickBooks Online handle multiple companies?

QuickBooks Online supports multiple company files, each as a separate subscription. There is no native multi-entity functionality—you must manage multiple files and consolidate manually or with third-party tools.

What is the difference between classes and locations in QuickBooks?

Classes typically track business segments, departments, or projects. Locations track geographic regions, stores, or physical addresses. Both can be used for segmentation, and businesses often use both simultaneously for different dimensions of analysis.

How do I consolidate QuickBooks reports from multiple companies?

You can use QuickBooks' built-in Consolidate feature (limited), manually combine reports in Excel, or implement a third-party consolidation tool. The right approach depends on number of entities and reporting complexity.

When should I move from QuickBooks to NetSuite?

Consider NetSuite when you have more than 5 entities, need real-time consolidated reporting, have complex revenue recognition requirements, need advanced inventory management, or have outgrown QuickBooks' user limits (typically 25+ concurrent users).

Struggling with Multi-Entity Complexity?

Eagle Rock CFO helps businesses evaluate their multi-entity needs and design the right QuickBooks setup or plan the transition to an ERP.

This article is part of our QuickBooks Online Guide: Setup, Reporting, and Best Practices guide.