Subsidiary reporting pack
The pack a subsidiary completes for its parent at each reporting date, in Excel. It maps the local trial balance to the group reporting lines, translates it into the group currency under IAS 21 with a proof of the translation reserve, matches every intercompany balance and transaction with the counterparty, collects the data group finance needs for the consolidated notes, and lays the figures out for the free Wide GAAP Consolidation template. A fully worked example shows a UK subsidiary reporting in sterling to its Irish parent in euro.
What it does
Maps up to 300 local ledger accounts to the group reporting lines for this year and last year, and checks both balance and every mapping is valid.
Translates assets and liabilities at the closing rate, income and expenses at the average rate, and share capital, reserves and dividends at historic rates, carrying retained earnings and the translation reserve in the group currency (IAS 21.39–41).
Proves the period's translation difference with an independent analysis of opening net assets, profit and dividends, and checks that last year's opening equity agrees.
Matches up to 20 intercompany balances and transactions against the counterparty's confirmed figures, records cash and goods in transit, flags differences above your threshold and foreign currency balances not remeasured, and agrees receivables, payables and dividends to the trial balance.
Collects the notes data – property, plant and equipment and intangible asset roll-forwards with the exchange difference, the borrowings maturity with contractual interest, revenue by market, the tax reconciliation, employees, key management pay by IAS 24 category, commitments, later events and the cash flow information the group statement of cash flows needs.
Lays the group-currency figures out in paste blocks for the rows of the Consolidation template, with the intragroup sales, margins, stock held, items in transit, charges and interest its Adjustments tab needs, and runs 20 automatic checks before sign-off.
What it does not do
It does not consolidate: group finance combines the packs, using the free Consolidation template or its own system.
Fair value adjustments and goodwill from the acquisition, the subsidiary's own other comprehensive income, hyperinflation, segment information and IFRS 16 or financial instrument schedules are outside its scope. The Consolidation template treats a translated subsidiary in a simplified way – see the Instructions tab.
What you get
One Excel workbook (.xlsx) with Instructions, the blank pack and a worked example: Fenwick Precision Limited, a UK subsidiary of an Irish engineering group, with sales to its parent, a management charge, cash in transit at the year end, a dividend and stock bought from a fellow subsidiary.
Clearly marked input cells, protected formulas and built-in checks, with a status line on every tab.
Works in Microsoft Excel 2010 or later (Windows or Mac). No macros.
Scope
IFRS Accounting Standards – IAS 21 translation and the data needed for IFRS 10 eliminations – for one subsidiary in one local currency reporting to its parent in one presentation currency. The full scope and limitations are set out in the Instructions tab.
Consolidating the packs? Use the free Consolidation template. Translating foreign currency transactions first? See the IAS 21 foreign exchange template.
Designed for finance teams, auditors and advisers preparing or reviewing IFRS financial statements. It is a working aid: it does not replace the Standards or professional judgement, and its scope and limitations are set out in the Instructions tab. The worked example is fictitious.



