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).
What's included
Template preview
Step by step
Create one tab per entity using the provided template. Each tab captures the budget in the entity's functional currency. Add the entity name, functional currency, and reporting period.
Populate the rate table with budget rates for each currency pair and period. Include both average rates (for P&L translation) and closing rates (for balance sheet translation). Group treasury typically provides these.
Each entity completes its budget in local currency. Revenue, costs, and headcount are all entered in the functional currency of that entity. This is where operational detail lives.
The consolidation tab automatically translates each entity's budget to EUR using the rate table and sums across entities. Intercompany transactions are flagged for elimination.
Use the scenario tab to test the impact of different exchange rate assumptions on consolidated results. The template calculates the FX variance between budget rates and alternative rate scenarios.
Watch out
Using a single exchange rate for both P&L and balance sheet translation
Forgetting to eliminate intercompany transactions before consolidating
Not distinguishing between transactional FX (P&L) and translational FX (OCI)
Applying budget rates to the forecast instead of updating to current spot rates
Related templates
Import this template directly into Grove FP and start planning. No credit card required.
FAQ