Free Template

EU Subsidiary Consolidation Template

A consolidation workbook for European multi-entity groups. Handles entity-level data collection, intercompany matching and elimination, multi-currency translation, and production of consolidated P&L, balance sheet, and cash flow statements. Follows IFRS 10 consolidation principles and supports both full consolidation and equity method for associates. For context on cross-border planning, see [Cross-Border FP&A for EU Subsidiaries](/blog/cross-border-fpa-eu-subsidiaries) and the [IFRS budgeting guide](/guides/ifrs-budgeting-guide-european-finance-teams).

What's included

Everything in this template

  • Entity data collection sheets with standardised chart of accounts
  • Intercompany matching report with discrepancy flagging
  • Automatic elimination entries for intercompany revenue, costs, receivables, and payables
  • Multi-currency translation with separate P&L and balance sheet rates
  • Consolidated P&L, balance sheet, and cash flow statements
  • Minority interest calculation for partially owned subsidiaries

Template preview

See the structure

fx=SUM(EntityRevenue) - SUM(IntercompanyEliminations)
Entity
Revenue
Eliminations
Consolidated
Parent (DE)
€8,500k
(€1,200k)
€7,300k
Sub 1 (FR)
€3,800k
(€600k)
€3,200k
Sub 2 (PL)
€2,100k
(€400k)
€1,700k
Sub 3 (NL)
€1,600k
(€200k)
€1,400k
Group Total
€16,000k
(€2,400k)
€13,600k

Step by step

How to use this template

1

Configure your group structure

Enter each entity's name, country, functional currency, ownership percentage, and consolidation method (full or equity). The template adjusts calculations based on these parameters.

2

Collect entity-level data

Distribute the standardised entity input sheets to each subsidiary. Each entity completes its P&L, balance sheet, and intercompany transaction log in local currency using the common chart of accounts.

3

Run intercompany matching

The matching report compares intercompany balances between counterparties and flags discrepancies exceeding a configurable threshold. Resolve mismatches before proceeding to elimination.

4

Generate elimination entries

The template automatically generates elimination journal entries for matched intercompany transactions: revenue/cost eliminations, receivable/payable eliminations, and dividend eliminations.

5

Review consolidated statements

Check the consolidated P&L, balance sheet, and cash flow statement. The template calculates translation reserves, minority interest, and goodwill adjustments. Drill down to entity-level detail for any line item.

Watch out

Common mistakes to avoid

Not reconciling intercompany balances before running eliminations, leading to consolidation differences

Using the same exchange rate for all financial statement line items instead of applying IAS 21 rules

Forgetting to eliminate unrealised profit on intercompany inventory transfers

Not accounting for minority interest in partially owned subsidiaries

Related templates

You might also need

Reporting

IFRS P&L Template

An income statement template structured to IFRS presentation requirements. Separates operating expenses by nature and function, isolates finance costs and tax, and calculates key subtotals including gross profit, operating profit, profit before tax, and net income. Designed for European companies reporting under IFRS who need a clean, auditable P&L structure for both internal planning and external reporting. For background on IFRS-aligned budgeting, see [IFRS Budgeting and Planning: A European Perspective](/blog/ifrs-budgeting-and-planning-european-perspective).

View template
Budgeting

Multi-Currency Budget Model

A budget template designed for European multi-entity groups operating across currency zones. Includes local currency input sheets, centralised exchange rate assumption tables, automatic translation to group reporting currency, and built-in FX variance analysis. Supports EUR, GBP, SEK, PLN, CZK, DKK, CHF, HUF, RON, and NOK out of the box. For detailed guidance, see the [multi-currency planning guide](/guides/multi-currency-planning-guide) and [working with multiple EU currencies](/blog/working-with-multiple-eu-currencies-financial-planning).

View template
Budgeting

Annual Operating Budget Template

A comprehensive full-year operating budget covering revenue, cost of goods sold, and departmental operating expenditure. Pre-built formulas calculate gross margin, EBITDA, and net income automatically. Designed for finance teams who need a clean, auditable starting point for annual planning. For tips on running an efficient budget cycle, see [Budget Season Survival Guide](/blog/budget-season-survival-guide). Pair this template with the [budget variance calculator](/tools/budget-variance-calculator) for automated BvA tracking, and review a worked [annual budget example](/examples/annual-budget-example) to see realistic UK figures.

View template

Build this in Grove FP in minutes

Import this template directly into Grove FP and start planning. No credit card required.

FAQ

Frequently asked questions