If your business operates through more than one legal entity — a holding company with subsidiaries, regional operating companies, or a structure that’s grown through acquisition — you’re managing multiple sets of books. Each entity has its own profit and loss, its own balance sheet, and its own chart of accounts. At some point, someone needs to produce a view of the group as a whole. That’s what financial consolidation is.
For many multi-entity businesses, this starts in Excel: exporting reports from each entity’s accounting software, pasting them into a spreadsheet, manually adjusting for intercompany transactions, and hoping nothing breaks. It works up to a point. As the entity count grows, the process becomes one of the most error-prone and time-consuming tasks in the finance calendar.
This guide explains what financial consolidation involves, how the process works step by step, and what to consider when deciding how to manage it.
What Is Financial Consolidation?
Financial consolidation is the process of combining the financial statements of multiple related entities into a single set of group financial statements — typically a consolidated profit and loss, balance sheet, and cash flow statement.
The result is a group view: what the organisation as a whole earned, owns, owes, and generated in cash during a period — presented as if it were a single economic unit, regardless of how many separate legal entities are involved.
Simple Example Parent Co. owns 100% of Sub A and 80% of Sub B.
Sub A: Revenue $500,000 | Sub B: Revenue $300,000
Before consolidation: two separate P&Ls.
After consolidation: one group P&L showing $800,000 in revenue — but adjusted to remove any sales between Sub A and Sub B (which would otherwise inflate the group figure), and with a separate line showing the 20% of Sub B’s results belonging to the minority shareholder.
When Does a Business Need Consolidated Reporting?
Not every multi-entity structure requires formal consolidated financial statements, but most will need them eventually. Common triggers:
- Statutory requirement: Under IFRS 10 and most national equivalents, a parent company that controls one or more subsidiaries is generally required to produce consolidated financial statements. Control typically means ownership of more than 50% of voting rights, though it can apply in other circumstances.
- Lender requirement: Banks and other lenders often require consolidated financials as a condition of credit facilities, to assess the group’s overall leverage and debt serviceability.
- Investor reporting: Businesses with external investors or PE backing typically report on a consolidated basis as standard governance practice.
- Internal management: Even where consolidated statements aren’t required externally, group management needs a consolidated view to understand the organisation’s actual performance — not just entity-by-entity snapshots.
The Consolidation Process — Step by Step
Step 1: Align Accounting Standards and Reporting Periods
Before combining any numbers, every entity needs to be reporting on the same basis. That means consistent accounting policies — the same depreciation method, the same revenue recognition approach, the same inventory valuation — and the same reporting period. Entities with different fiscal year-ends may need adjustments to align them to the group period.
For groups with entities reporting under different frameworks (IFRS, US GAAP, FRS 102, or local GAAP), each entity’s figures may need restating to the group accounting policy before consolidation.
Step 2: Convert Foreign Currencies
If entities operate in different functional currencies, their financials need to be translated into the group’s presentation currency before consolidation. Under IAS 21, the standard approach is:
- Assets and liabilities: translated at the closing rate (spot rate at period end)
- Income and expenses: translated at the average rate for the period
- Translation differences: recorded in equity as the currency translation adjustment (CTA) — not in the P&L
Example A Singapore-based group has a UK subsidiary reporting in GBP. The UK entity’s balance sheet is translated at the GBP/SGD closing rate; the P&L at the average rate for the period. The difference arising from using two different rates goes to the CTA reserve in group equity.
Step 3: Eliminate Intercompany Transactions
This is the most important — and most error-prone — step in consolidation. Any transactions between entities within the group must be eliminated, because from the group’s perspective, they are internal and didn’t happen externally.
The most common eliminations:
| Transaction Type | What Gets Eliminated |
|---|---|
| Intercompany sales | Revenue in the selling entity and cost of sales (or inventory) in the buying entity — both removed from the group P&L |
| Intercompany loans | The receivable in the lending entity and the liability in the borrowing entity — both removed from the group balance sheet |
| Intercompany interest | Interest income in the lender and interest expense in the borrower — both eliminated from the group P&L |
| Intercompany dividends | Dividend income recognised by the parent — eliminated as an internal transfer |
💡 Partial ownership: For subsidiaries not 100% owned by the parent, only the group’s proportionate share of intercompany profits is eliminated. The minority shareholder’s share remains in the consolidated accounts.
Step 4: Adjust for Non-Controlling Interests (Minority Interest)
Where the parent doesn’t own 100% of a subsidiary, the minority shareholders’ portion of net assets and profit must be presented separately in the consolidated statements — not attributed to the parent.
Example Sub B reports a net profit of $200,000. Parent owns 80%, minority shareholders own 20%.
• Group’s share (80%): $160,000 → included in consolidated profit attributable to parent
• NCI share (20%): $40,000 → shown separately as “profit attributable to non-controlling interests”
On the balance sheet, the NCI’s share of Sub B’s net assets is presented as a separate component of group equity — not as a liability.
Step 5: Combine and Present
With currencies aligned, intercompany transactions eliminated, and minority interests separated, the entity financials are aggregated into a single set of group statements: the consolidated profit and loss, consolidated balance sheet, and consolidated statement of cash flows. These present the group as one economic unit.
Common Challenges in Consolidation
Intercompany mismatches. Before you can eliminate intercompany transactions, both sides of each transaction need to be identifiable and in agreement. In practice, one entity may have recorded a transaction in a different period, or at a slightly different amount due to FX timing. These mismatches must be resolved before the consolidation can close.
Chart of accounts differences. Each entity’s accounting software may use a different chart of accounts. Mapping each entity’s accounts to a consistent group structure is a prerequisite for meaningful aggregation — and maintaining that mapping as entities add new accounts is an ongoing task.
Timeliness. Consolidated statements can only close as fast as the slowest entity. Groups with subsidiaries in multiple time zones or with inconsistent close processes often find the same one or two entities holding up the group close every period.
Complex ownership structures. Groups with partial ownership, step-acquisitions, or changes in ownership percentage during a period require careful NCI calculations. Each change in ownership needs to be assessed to determine whether control has been gained, maintained, or lost — with different accounting treatment in each case.
Excel vs Consolidation Software: When to Make the Switch
Excel works for consolidation at low entity counts with straightforward structures. Most groups start there. It starts breaking down when:
- The entity count grows beyond 3–4 and manual linking becomes fragile
- Intercompany eliminations are numerous or involve partially-owned subsidiaries
- Multiple currencies require exchange rate application across every line item
- The process needs to be repeatable and auditable by more than one person
- Month-end close timelines are tightening and manual consolidation is the bottleneck
Consolidation software automates the mechanical steps — currency translation, intercompany matching and elimination, NCI calculation — so finance teams spend their time reviewing results rather than building and debugging spreadsheets. The audit trail is also a material improvement over Excel, particularly for groups with lender or investor reporting obligations.
If your group structure has grown past what Excel can handle cleanly, BrizoConsol is built for multi-entity consolidation — connecting directly to Xero, QuickBooks, MYOB, and Zoho Books, with automated intercompany eliminations, multi-currency support, NCI tracking, and a custom report builder. See it in action →