Multi-Entity Consolidation in QuickBooks Online: A CFO’s Guide
Multi-entity consolidation in QuickBooks Online is harder than it looks: QBO runs one company per subscription and cannot consolidate entities on its own. Below is how finance teams actually do it, where each approach breaks, and what it takes to produce consolidated statements a lender or auditor will accept — not just a spreadsheet that ties out for you.
Why QuickBooks Online can’t consolidate entities natively
QuickBooks Online is built around a single company per subscription. The moment a business becomes a group — a holdco over operating entities, a roll-up of acquisitions, or a property portfolio with an LLC per asset — QuickBooks has no way to combine those companies into one set of statements. Each entity lives in its own file, with its own chart of accounts, its own banking, and its own intercompany activity that QuickBooks has no concept of across the wall.
So consolidation has to happen outsideQuickBooks. The question is only how — and how well it holds up when someone who matters reads it.
The four ways teams do it today — and where each breaks
Classes or locations in one file
Works until the entities are real legal entities with their own tax returns, banking, and intercompany activity. Classes give you a P&L slice, not a consolidated balance sheet, and they never eliminate intercompany balances.
“Combine reports” (Desktop Enterprise)
Intuit's own feature requires an identical chart of accounts across every company and does no intercompany elimination. It produces a combined report, which is not the same thing as a consolidation an auditor or lender will accept.
Export to a spreadsheet
The default for most teams: pull each entity's trial balance, map mismatched accounts by hand, convert currency, and key in eliminations every month. It works once. By month three the workbook is fragile, slow, and impossible to audit.
Third-party consolidation software
Tools like Joiin, LiveFlow, or JustConsolidate automate the data pull and basic eliminations. They solve the plumbing — but they still assume someone on your side knows what a correct elimination and a defensible consolidated statement look like.
Getting intercompany eliminations right
Eliminations are the part the tools and spreadsheets quietly get wrong. If Entity A sells to Entity B, or the holdco lends to a subsidiary, those transactions are real inside each company but are not real for the group — the group did not sell anything to itself. Leave them in and you overstate revenue, assets, and liabilities, sometimes badly.
- Intercompany revenue and COGS — remove sales between entities so group revenue reflects only outside customers.
- Intercompany loans and interest — eliminate the receivable on one side against the payable on the other, and the matching interest income and expense.
- Investment in subsidiaries — eliminate the parent’s investment against the subsidiary’s equity so capital isn’t double-counted.
- Unrealized intercompany profit — back out margin sitting in inventory that one entity bought from another and hasn’t yet sold outside.
Multi-entity reconciliation: aligning the books before you add them
Consolidation is only as good as the books underneath it. Before anything sums, the entities have to speak the same language and their intercompany balances have to agree.
- A mapped, unified chart of accounts — every entity’s accounts roll up to the same group accounts, so “revenue” means the same thing everywhere.
- Reconciled intercompany balances — what Entity A says it owes Entity B has to match what B says it’s owed, every period, before eliminations can net to zero.
- Consistent close timing and currency — entities closed to the same date, with a defensible FX policy if any entity reports in another currency.
Making consolidated statements lender- and audit-ready
A spreadsheet that ties out for you is not the same as statements that survive outside scrutiny. When a lender computes a covenant off your consolidated numbers, or an auditor traces an elimination back to source, the bar is higher: the consolidation has to follow real consolidation accounting, document its eliminations, and reconcile to each entity’s books on demand. That is the difference between a combined report and a defensible consolidation— and it’s the difference that matters most when the numbers carry financing weight.
This is exactly the discipline a CFO brings to a 13-week cash flow forecast or a covenant package: numbers built to be questioned, and to hold.
When to bring in a CFO instead of another tool
Software moves the data. It does not decide what’s correct. If your consolidated statements have to do real work — back a covenant, support a refinancing, satisfy an auditor, or give a PE sponsor numbers they trust — the consolidation is a CFO problem with a tool underneath, not a tool problem.
Cipher CFO runs multi-entity consolidation as part of a monthly close — eliminations, reconciliation, and a board- and lender-ready package — for PE-backed and turnaround-stage companies. See the full range of CFO services.
Multi-entity consolidation FAQ
Can QuickBooks consolidate multiple companies?
Not natively. QuickBooks Online is one company per subscription and has no built-in consolidation. QuickBooks Desktop Enterprise offers a “combine reports” feature, but it requires an identical chart of accounts and performs no intercompany eliminations — so it produces a combined report, not a true consolidation. Consolidating multiple entities requires either a dedicated tool or a finance function that builds the consolidation outside QuickBooks.
What's the difference between combining and consolidating financial statements?
Combining simply adds the entities' numbers together. Consolidating adds them and then removes the double-counting created by intercompany activity — intercompany sales, loans, and receivables/payables between the entities — so the group's statements reflect only transactions with the outside world. Lenders and auditors expect a true consolidation; a combined report overstates revenue, assets, and liabilities.
Do I need consolidation software or a CFO?
Software solves the data movement: pulling each entity and mapping accounts. It does not decide which balances to eliminate, whether your consolidated statements follow GAAP, or how to present them to a lender in a covenant package. If you have clean books and a finance lead who knows consolidation accounting, a tool may be enough. If the statements have to survive lender or auditor scrutiny — especially under a covenant or forbearance — that's CFO work, with or without the tool underneath.
Stop rebuilding the consolidation workbook every month.
A 20-minute call, in confidence. Tell us how many entities you're on, what the statements need to do, and we'll tell you straight what it takes to get them lender- and audit-ready.