IFRS Group Consolidation & Financial Statements Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Transform signed legal-entity trial balances into comparative IFRS group financial statements through a visible mapping, translation and journal chain.
2. Explain ownership, acquisition goodwill, non-controlling interests, foreign-currency reserves and intercompany eliminations in one traceable close workpaper.
3. Review an executive dashboard and 39 close controls, then test ownership and EUR/USD decisions in an isolated pro-forma scenario layer.

FINANCIAL MODELING EXCEL DESCRIPTION

IFRS Group Consolidation & Financial Statements Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

Group consolidation requires more than adding the numbers in several company accounts. Each legal entity brings its own local chart, ownership status, currency, internal transactions and financial results. A reporting team also needs to show exactly how the final group figures arise and why the balance sheet and cash-flow statement reconcile. This Excel workpaper follows that path from source trial balances to consolidated financial statements for a fictional four-entity example.

The editable model contains 27 worksheets. Its FY2025 comparative and FY2026 current-year cases include a USD parent, a USD subsidiary, a EUR subsidiary and one equity-accounted associate. Begin with period keys, the entity and control register, group chart of accounts and local mapping. Enter debit-positive and credit-negative trial-balance amounts in the period-keyed, multi-entity import. Closing, average and historical currency rates feed the translation schedule, while the FX section includes an exchangeability documentation area.

Ownership schedules cover illustrative acquisition consideration, fair-value land uplift, related deferred tax, identifiable net assets, proportionate acquisition-date NCI and goodwill. Further schedules calculate NCI and translation-reserve attribution and roll forward the associate investment using share of earnings, OCI, dividends and impairment entries. The intercompany workpaper compares bilateral receivables and payables. Matched sales and purchases, inventory profit, fixed-asset gain and depreciation adjustment inputs feed the elimination workflow. Automatic and editable manual journals reconcile to the signed group consolidation ledger.

The resulting outputs include a comparative consolidated statement of financial position, IFRS 18-ready profit-or-loss presentation, OCI and equity analysis, and a direct cash-flow statement reconciled to closing cash. Supporting pages include an IFRS 18 comparative presentation bridge, IFRS 12 disclosure planning, IFRS 19 subsidiary eligibility screening, a pre-elimination entity contribution view and an account-level audit trail.

An executive dashboard collects group revenue, operating profit, earnings, assets, cash, NCI, goodwill, entity contribution and close status. The separate Downside, Base and Upside pro-forma section tests a foreign-exchange factor, ownership stake, incremental subsidiary profit and transaction premium or discount, while statutory actuals remain separate. The sample close gate includes 39 integrity controls. Designed for consolidation accountants, group controllers, finance teams and reporting advisers, the workbook is editable, source-system-neutral through manual trial-balance imports and macro-free. The companion secondary PDF is a full 27-page preview, one page per worksheet; the Excel file remains the editable deliverable. The workbook itself contains methodology and accounting review points for adapting the fictional case to a live group.

Source: Best Practices in Financial Modeling, Management Accounting Excel: IFRS Group Consolidation & Financial Statements Model Excel (XLSX) Spreadsheet, PDMM Financial Models