How multi-entity consolidation works
If your organization runs more than one legal entity — a holding company over several operating subsidiaries, a few sister companies under common ownership, or a property portfolio with one entity per building — sooner or later someone asks for the consolidated numbers. Consolidation is the process of combining the financial statements of every entity in a group into a single set of statements that present the group as if it were one company. It sounds simple. In practice, it is a sequence of deliberate steps, each of which involves judgment.
Here is how the process actually works, step by step.
Step 1: Get every entity onto the same chart of accounts
Each company in a group usually keeps its own books, and those books rarely share an identical chart of accounts. One entity calls it "Sales," another calls it "Revenue — Services," a third splits revenue across four accounts. Before you can combine anything, you have to map each entity's accounts to a single master chart so that like balances roll up into the same caption.
This mapping is the foundation of the whole consolidation. If two entities' "cash" accounts do not map to the same consolidated line, your consolidated cash balance will be wrong — and nothing downstream can fix it. Done once carefully, the mapping can usually be reused period after period.
Step 2: Combine the trial balances
Once every entity is on the master chart, you combine the trial balances into a consolidation worksheet. The classic layout is one column per entity, then a combined column that simply sums across. At this stage you have a combination — the arithmetic total of the group — but not yet a consolidation. The difference is what comes next.
A combined column is useful on its own: it shows what each entity contributes and lets you sanity-check that every entity tied out before you started. But it double-counts everything the entities did with each other.
Step 3: Eliminate intercompany activity
Entities within a group transact with one another. The parent lends cash to a subsidiary; one company sells inventory to another; a shared-services entity charges management fees. From the group's perspective, these transactions never left the building — so they must be removed, or eliminated, before the combined column becomes a true consolidation.
Common eliminations include:
- Intercompany receivables and payables — a "due from subsidiary" on one entity offsets a "due to parent" on the other.
- Intercompany revenue and expense — intercompany sales and the matching cost, or management fees charged and received.
- Investment in subsidiary against subsidiary equity — the parent's investment account is eliminated against the subsidiary's equity it represents.
Each elimination is an entry in a dedicated eliminations column of the worksheet. The combined column plus the eliminations column equals the consolidated total. Critically, eliminations are a matter of judgment: you decide which balances are genuinely intercompany and how to treat differences when the two sides do not agree. A good consolidation tool recommends eliminations and explains them, but the call is yours.
Step 4: Handle non-controlling interest
If the parent owns less than 100% of a subsidiary that it still controls, the group consolidates the whole subsidiary — but a portion of that subsidiary's equity and earnings belongs to the other owners. That portion is the non-controlling interest (NCI). Consolidation presents 100% of the subsidiary's assets, liabilities, revenue, and expenses, then carves out the minority owners' share as NCI on the balance sheet and in the income statement.
NCI is driven entirely by the ownership percentages and consolidation method you configure. Get the ownership inputs wrong and the consolidated equity will not reflect who actually owns the group.
Step 5: Produce statements that tie
The payoff is a consolidated Balance Sheet, Income Statement, and Cash Flow where the consolidated total equals the combined entities minus confirmed eliminations, with NCI presented correctly — and where every line can be traced back to the entities and eliminations behind it. "Tie" is the operative word: a consolidation you cannot trace is a consolidation no one will trust.
Why it is worth automating the mechanics
The judgment in consolidation — which balances are intercompany, how to resolve differences, what ownership structure applies — is yours and should stay yours. But the mechanics are repetitive and error-prone: re-mapping charts every period, re-keying trial balances, rebuilding the worksheet, and re-deriving NCI by hand. ConsoliView connects to each entity's QuickBooks Online company read-only, applies your saved chart mapping, builds the worksheet, detects candidate eliminations for you to confirm, computes NCI from your ownership inputs, and exports a package that ties — so you spend your time on the judgment, not the keystrokes.
ConsoliView is a consolidation preparation aid — not an audit, not a GAAP-conformity opinion or guarantee, and not a substitute for a CPA or auditor. You review and confirm every elimination and ownership call; the consolidated statements are only as correct as those inputs.