If you run a holding company with subsidiaries, your lenders, investors, and auditors don’t want to see five separate sets of books — they want one consolidated picture of the whole group. Consolidation is the process of combining the parent and every entity it controls into a single P&L, balance sheet, and cash flow statement, as if the group were one company.
This guide walks through how consolidation actually works, the order you do it in, and where the manual approach breaks down.
What Consolidation Means
A consolidated financial statement reports the parent and its subsidiaries as a single economic entity. You don’t average the numbers or pick the biggest entity — you add each line item across all entities, then strip out anything that happened between group members so the group isn’t counting its own internal activity as real business.
The guiding principle under US GAAP (ASC 810) is control: if the parent controls an entity — usually by owning more than 50% of its voting interest — that entity is consolidated in full.
Step 1: Standardize the Chart of Accounts
You can’t add “Sales” in one subsidiary to “Revenue – Services” in another and expect a clean total. Before you can consolidate, every entity needs to map to a common account structure.
- Build a group chart of accounts that every subsidiary conforms to.
- Map each subsidiary’s local accounts to the group accounts (a “mapping table”).
- Apply the same account for the same kind of transaction everywhere.
Step 2: Align Accounting Policies and Periods
Consolidation assumes the entities are speaking the same accounting language:
- Same period end — all entities should report through the same date. If a subsidiary has a different fiscal year, you’ll need an interim close.
- Same accounting policies — depreciation methods, revenue recognition, and inventory costing should match. If one entity uses FIFO and another uses average cost, normalize before combining.
- Same currency — foreign subsidiaries must be translated into the group’s reporting currency before they’re combined.
Step 3: Combine Line Items
With accounts and policies aligned, you add the entities together account by account: the parent’s cash plus every subsidiary’s cash, the parent’s revenue plus every subsidiary’s revenue, and so on. This produces a combined (but not yet consolidated) trial balance.
Step 4: Eliminate Inter-Company Transactions
This is the step that turns a combined total into a true consolidation — and it’s the one spreadsheets get wrong most often. Anything that happened only between group members has to be removed, because from the group’s perspective it never left the building.
Common eliminations:
| Inter-company item | Why it’s eliminated |
|---|---|
| Inter-company sales & COGS | The group can’t book revenue selling to itself |
| Inter-company loans | A loan from parent to subsidiary isn’t group debt |
| Inter-company interest | Interest paid to a group member is internal |
| Receivables & payables between entities | They net to zero for the group |
| Management or franchise fees between entities | Internal cost shuffling, not group expense |
| Unrealized profit on inventory still held in-group | Profit isn’t real until sold outside the group |
| Parent’s investment in subsidiary vs. subsidiary equity | Eliminated so equity isn’t double-counted |
A worked example. Say the parent sells $100,000 of goods (which cost the parent $60,000) to a subsidiary, and the subsidiary still holds all of it in inventory at period end:
| Line | Parent | Subsidiary | Combined | Elimination | Consolidated |
|---|---|---|---|---|---|
| Revenue | $100,000 | $0 | $100,000 | ($100,000) | $0 |
| COGS | $60,000 | $0 | $60,000 | ($60,000) | $0 |
| Inventory | $0 | $100,000 | $100,000 | ($40,000)* | $60,000 |
Because the sale was internal, consolidated revenue and COGS are zero, and the inventory is carried at the group’s original cost — not the marked-up inter-company price.
Step 5: Present Non-Controlling Interest
If the parent owns less than 100% of a subsidiary, you still consolidate 100% of that subsidiary’s assets, liabilities, revenue, and expenses — but you separate out the slice owned by outside investors.
- On the income statement, show the non-controlling interest’s share of net income.
- On the balance sheet, present non-controlling interest as a separate component of equity.
The Manual Approach vs. Multi-Entity Software
Most holding companies start by consolidating in Excel: export each subsidiary’s trial balance, paste them into a master workbook, build elimination columns by hand, and pray the formulas survive the next new entity. It works — until you add a subsidiary, change an account, or get asked for a mid-quarter number.
| Spreadsheet consolidation | Multi-entity software | |
|---|---|---|
| Combining entities | Manual copy/paste each period | Automatic |
| Inter-company eliminations | Hand-built columns | Applied automatically |
| New subsidiary | Rework the model | Add an entity; it’s included |
| Mid-period report | Re-run the whole workbook | One click |
| Audit trail | Version-controlled files, maybe | Built in |
EmLedger keeps every subsidiary on one platform with a shared chart of accounts, records inter-company transactions once so both sides post together, and generates consolidated P&L, balance sheet, and cash flow across any set of entities on demand.
Consolidation Checklist
- Build and enforce a group chart of accounts.
- Align period ends, accounting policies, and currency.
- Combine all entities account by account.
- Identify and eliminate every inter-company transaction and balance.
- Eliminate the parent’s investment against subsidiary equity.
- Separate and present non-controlling interest.
- Produce consolidated P&L, balance sheet, and cash flow.
Consolidation isn’t conceptually hard — it’s combine, then eliminate. The difficulty is doing it accurately, every period, as the group grows. That’s the part worth automating.