Steps in Preparation of Consolidated Financial Statements: Your Complete 2026 Guide

You’re staring at spreadsheets from eight different Xero entities, trying to eliminate intercompany transactions while the board pack is due in three days. Your balance sheet won’t balance. Eliminations don’t reconcile. Month-end has stretched into a second week. Preparing consolidated financial statements shouldn’t take this long or leave you second-guessing the numbers. This guide shows you the steps in preparation of consolidated financial statements and the practical ways to cut the manual grind.

Seven steps in preparation of consolidated financial statements transform individual entity data into unified group reports. The process requires identifying all controlled subsidiaries, gathering aligned financial data, converting foreign currencies, eliminating all intercompany transactions, adjusting for non-controlling interests, combining the statements, and conducting final reviews. Finance teams using automation reduce month-end close from over 15 days to under 5 days by streamlining these steps with proper consolidation workflows.

Why Consolidated Financial Statements Matter

Consolidated financial statements present your parent company and all subsidiaries as a single economic entity. They provide investors, lenders, and regulators with a comprehensive view of your group’s financial position.

Who Needs to Prepare Consolidated Statements

Under IFRS 10, consolidation is required when the parent controls an investee – i.e., it has power over relevant activities, exposure or rights to variable returns, and the ability to use its power to affect those returns. Ownership of more than 50% often indicates control, but it is not the test. Where the parent has significant influence but not control (usually presumed at ≥20%), the investment is accounted for using the equity method under IAS 28 rather than full consolidation.

Your group needs consolidation if you operate multiple legal entities, own subsidiaries in different countries, or manage holding company structures. Even businesses with just two entities benefit from consolidated reporting.

Regulatory Context: IFRS, US GAAP, and Jurisdictional Reliefs

IFRS 10 bases consolidation on control and requires consolidated financial statements when a parent-subsidiary relationship exists. Certain investment entities under IFRS 10 generally do not consolidate many subsidiaries; instead, they measure those subsidiaries at fair value through profit or loss (FVTPL), except for subsidiaries that provide investment-related services, which are consolidated.

Some jurisdictions also provide relief; for example, the Companies Act 2006 permits small groups and some intermediate parents not to prepare group accounts if specific conditions are met. If you report under US GAAP, consolidation follows ASC 810 (voting-interest and VIE models). Always check the framework you report under and any local company-law exemptions that apply.

The Seven Steps in Preparation of Consolidated Financial Statements

Each step below addresses a specific consolidation requirement, from determining which entities belong in your group to presenting final statements to stakeholders. The process follows this sequence:

• Start with Trial Balance data from every entity
• Eliminate intercompany transactions that create artificial profits
• Aggregate everything into consolidated reports that reconcile back to source systems

The process works the same whether you’re consolidating manually or using automation. Automation just executes these steps in seconds instead of weeks.

Step 1: Identify Subsidiaries and Determine Control

Before you consolidate anything, you need to know exactly which entities belong in your consolidated group.

Defining Control and Ownership Thresholds

Under IFRS 10, you control a subsidiary when all three are true:

1. You have power over the investee
2. You are exposed, or have rights, to variable returns from your involvement
3. You can use your power to affect those returns.

Majority ownership often indicates control, but it is neither required nor sufficient on its own.

Under US GAAP (ASC 810), some entities are assessed under the variable interest entity (VIE) model; the entity that is the primary beneficiary (power + economics) consolidates the VIE.

Document each subsidiary’s incorporation date, ownership percentage, and business activities. This creates your consolidation scope. All controlled entities must be included, regardless of ownership percentage, although non-controlling interests will be accounted for separately.

Structured Entities (IFRS) and VIEs (US GAAP)

IFRS uses the term structured entity for arrangements in which voting rights are not the dominant factor for control; related disclosures are in IFRS 12. In US GAAP, the comparable concept is a variable interest entity (VIE), consolidated by the primary beneficiary. If you report under IFRS, assess control and structured-entity disclosures; if you report under US GAAP, perform the VIE analysis.

Step 2: Gather and Align Financial Data

Data collection is where consolidation lives or dies. You need complete, accurate financial information from every entity in your consolidation scope.

Trial Balance as Your Foundation

Trial Balance is the definitive report for multi-entity consolidation. It ensures all accounts reconcile before you start eliminations. Pull complete Trial Balance data from each entity, including all account balances, to guarantee your consolidation ties back to source systems.

Without accurate Trial Balance data, your consolidated statements won’t reconcile. Every balance sheet account, income statement account, and equity account requires its Trial Balance entry to be verified before consolidation begins.

Ensuring Consistent Accounting Policies

All entities must use consistent accounting policies and practices for consolidation to work properly. Review depreciation methods, revenue recognition policies, and inventory valuation approaches across all subsidiaries. Apply uniform accounting policies across all consolidated entities; adjust subsidiary figures where policies differ (IFRS 10). This prevents distortions in your consolidated results.

Handling Different Reporting Periods

If a subsidiary’s reporting date differs from the parent’s, you may use its statements, provided the gap is no more than three months and you adjust for significant transactions in between. Where feasible, align reporting dates to simplify consolidation and audit.

Ideally, align all entities to the same reporting period. dataSights continuously pulls data from multiple entities, eliminating period-end bottlenecks that slow manual consolidation.

Watch how dataSights automates the complete consolidation workflow, from data gathering through final statement generation. This demonstration shows the exact steps you’ve just learned, executed in seconds instead of weeks.

Step 3: Convert Foreign Currency Translations

Multi-currency groups face an additional step before consolidation.

Translate each subsidiary’s results into the group presentation currency before combining them:

• Translate income and expenses at transaction-date rates (or an average rate that approximates spot).
• Translate monetary assets and liabilities at the closing rate; non-monetary items at historical rates (or the rate on the date fair value was measured if carried at FV).
• Equity items remain at historical rates.
• The net difference is recognised in OCI as a cumulative translation adjustment (CTA) and is reclassified on disposal of the foreign operation.

The cumulative translation adjustment (CTA) is recognised in OCI until disposal of the foreign operation.

Step 4: Eliminate Intercompany Transactions

This is where consolidation gets technical. Intercompany transactions create artificial profits that don’t reflect the group’s true financial position.

Types of Intercompany Transactions to Eliminate

Common eliminations include:

• Intercompany sales and purchases
• Intercompany loans and interest
• Dividends paid between group entities
• Management fees charged internally
• Asset transfers between subsidiaries

All intra-entity balances and transactions must be eliminated when preparing consolidated statements. The group should only show transactions with external parties.

Upstream, Downstream, and Lateral Transactions

• Downstream transactions flow from parent to subsidiary.
• Upstream transactions go from subsidiary to parent.
• Lateral transactions occur between two subsidiaries that are part of the same parent company.

All three types require elimination before generating consolidated statements. The direction affects how you allocate the elimination between controlling and non-controlling interests.

Unrealised Profit Elimination

If one entity sells inventory to another and that inventory remains unsold at period-end, the profit is unrealised. You must eliminate it from both closing inventory and profit figures.

Calculate unrealised profit by identifying intercompany markup on goods still held within the group. This prevents the group from recognising profit on sales to itself.

Eliminate unrealised intercompany profit in closing inventory and PP&E. Defer profit until sale to third parties and adjust the carrying amount to cost to the group. Consider any deferred tax effects (IAS 12).

Intra-Group Cash Flow Elimination

Also eliminate intercompany dividends (and related investment income) and intercompany interest income/expense together with the underlying receivable/payable. In the consolidated cash flow, eliminate all intra-group cash flows.

Why Eliminations Are the Hard Part

Manual eliminations are time-consuming and prone to error, often failing to provide a complete audit trail. System-based rules provide repeatability, documentation (who/what/when), and drill-down to the underlying entries – so you spend time reviewing eliminations, not rebuilding them. IFRS 10 requires eliminating all intragroup balances, transactions, income and expenses in full.

Note for Xero users: Xero has no native intercompany module, so eliminations must be managed in your consolidation/reporting layer.

Step 5: Adjust for Non-Controlling Interests (NCI)

When you own less than 100% of a subsidiary, you must account for the portion you don’t own.

Non-Controlling Interests (NCI)

NCI represents equity in a subsidiary not attributable to the parent. At acquisition, IFRS 3 permits measuring NCI at fair value or at its proportionate share of the acquiree’s identifiable net assets. In subsequent periods, attribute the subsidiary’s profit or loss and OCI between the parent and NCI.

NCI in Balance Sheet and Income Statement

In the income statement, allocate the subsidiary’s profit between the parent and NCI based on ownership percentages. If you own 80% of a subsidiary that earned £100,000, £20,000 goes to NCI.

On the balance sheet, NCI increases with its share of subsidiary profits and decreases with its share of losses or dividends declared.

Eliminate intra-group balances and transactions in full. For attribution, direction matters:

• Downstream (parent→sub): the elimination adjusts the parent’s profit – no impact on NCI share.
• Upstream (sub→parent): the elimination reduces the subsidiary’s profit – NCI’s share decreases accordingly.

Step 6: Combine Financial Statements

Now you aggregate all adjusted entity data into unified group statements.

Aggregating Assets, Liabilities, and Equity

• Combine the following in all entities line by line:
  • Assets
  • Liabilities
  • Equity
  • Revenues
  • Expenses
• Add the parent’s cash to all subsidiary cash balances. Total all receivables, inventory, fixed assets, payables, and debt.
• The parent’s investment in subsidiaries is eliminated and replaced with the underlying net assets plus any goodwill arising on acquisition.

Produce a Statement of financial position (balance sheet), Statement of profit or loss and other comprehensive income, Statement of changes in equity, Statement of cash flows, and notes (including significant accounting policies and required disclosures).

Goodwill and Investment Elimination

On first-time consolidation, eliminate the parent’s investment against the subsidiary’s identifiable net assets. Any excess is goodwill, calculated as Purchase price − Fair value of identifiable net assets acquired. Goodwill is recognised under IFRS 3/ASC 805 at acquisition in the consolidation layer and is tested annually for impairment under IAS 36 (not amortised under IFRS). For foreign operations, translate goodwill at the closing rate.

Operational note: Xero does not calculate or track goodwill – post this adjustment in your consolidation layer.

Preparing Consolidated Income Statement

Combine all revenues and expenses from the parent and subsidiaries. Eliminate intercompany revenue and corresponding expenses. Subtract total expenses from total revenue to arrive at consolidated net income.

Allocate net income between the parent and non-controlling interests. Your consolidated income statement displays revenues and expenses that reflect the group’s performance with external entities only.

Preparing Consolidated Balance Sheet

Add all assets line by line and all liabilities line by line. Eliminate intercompany balances like receivables and payables between group entities.

Equity shows the parent’s share capital, reserves, and retained earnings plus non-controlling interest as a separate component.

Preparing Consolidated Cash Flow Statement

The consolidated cash flow statement shows cash activities from operations, investments, and financing for the entire group. For majority-owned subsidiaries, cash flows are fully consolidated.

Eliminate cash transfers between group entities to show only external cash movements.

Step 7: Review, Audit, and Present

Your consolidation isn’t done until you’ve verified every number.

Final Reconciliation Checks

Review consolidated financials for accuracy, completeness, and compliance with accounting standards. Verify that:

• All intercompany balances eliminate to zero
• Trial Balance reconciles to consolidated statements
• Non-controlling interest calculations are correct
• Currency translations are accurate

Run variance analysis comparing the current period to prior periods and budgets.

Audit Trail Requirements

Maintain system-level audit logs that show who made each adjustment, when it was made, and the reason for the adjustment. Document all elimination entries with supporting schedules.

Automated consolidation creates audit trails that manual processes cannot achieve. Every elimination is timestamped, user-identified, and permanently recorded.

Stakeholder Presentation

Present consolidated statements to investors, lenders, and regulatory authorities as required. Include all necessary disclosures about consolidation methods, intercompany eliminations, and non-controlling interests.

Prepare management commentary that explains significant variances and key business performance drivers.

Continuous vs Period-End Consolidation

Spreadsheet consolidation produces a point-in-time snapshot; issues surface days after the close. With continuous consolidation, mismatches and elimination breaks are visible during the month, so you fix them when the context is fresh. Teams adopting continuous consolidation typically reduce month-end from over two weeks to under 5 days with fewer reworks.

Common Challenges in Manual Consolidation

Manual consolidation processes create predictable problems.

• Finance teams using spreadsheets often encounter data quality errors, late reporting, a lack of validation controls, and failed integration across close processes. Entry errors multiply when consolidating manually.
• Slow reconciliation consumes resources on intercompany eliminations and group ownership calculations. When reporting deadlines are tight, time is the commodity finance teams lack most.
• Spreadsheet-based consolidation leaves organisations open to data manipulation. No audit trail exists showing who made changes or when.

How Automation Transforms the Consolidation Process

Modern consolidation doesn’t require weeks of manual work.

dataSights syncs data from multiple Xero entities via API into a cloud database where Power BI connects directly to create real-time dashboards. Automated data sync from Xero to Power BI eliminates CSV exports and broken formulas.

Consolidate both small and large entities simultaneously without performance degradation. Automated elimination rules run with full audit trails documenting every adjustment.

With continuous consolidation, issues surface daily instead of two weeks after month-end. You make corrections while context is fresh, transforming consolidation from reactive reporting to proactive management.

Preparing consolidated financial statements doesn’t have to consume weeks of your finance team’s time. The seven-step process is effective, but manual execution can create bottlenecks, errors, and stress. Automated workflows transform 15-day manual consolidation into 5-day completions by eliminating spreadsheet gymnastics and providing continuous visibility. Your consolidated statements become reliable management tools, rather than period-end ordeals. Start with accurate Trial Balance data, automate your eliminations, and watch month-end close shrink.