First page of the EU Taxonomy KPI Calculator (Turnover, CapEx, OpEx)Excel workbook preview

CSRD, ESRS and EU Taxonomy

EU Taxonomy KPI Calculator (Turnover, CapEx, OpEx)

EU Taxonomy KPI calculator in Excel: turnover, CapEx and OpEx alignment from activity data, the 10 % relief check and a split by environmental objective.

Excel workbook · 16 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

Companies that report under the CSRD also disclose how much of their turnover, capital expenditure and operating expenditure comes from environmentally sustainable activities, as required by Article 8 of the Taxonomy Regulation. An activity counts as aligned only when it is eligible, contributes substantially to an environmental objective, does no significant harm to the others and is carried out with minimum safeguards. The calculation is checked by the assurance provider, so it needs a clear trail.

This calculator follows Annex I of Delegated Regulation (EU) 2021/2178 for the three denominators and numerators, and the amendments made by Delegated Regulation (EU) 2026/73, which apply from 1 January 2026: the option not to assess activities below 10 % of a KPI denominator, and the option to treat OpEx as not material. Activities are entered once with their amounts, and every share, check and breakdown is a live formula.

Who it is for

The group controller who must produce the Article 8 Taxonomy KPIs for the sustainability statement and needs a calculation the auditor can follow line by line.

What is inside

  • Inputs sheet: net turnover, CapEx denominator from 4 parts and OpEx denominator from 5 parts
  • Activities sheet with 10 worked activities and 16 blank rows, status worked out by formula
  • Alignment test per activity: eligible, substantial contribution, no significant harm, minimum safeguards
  • KPI sheet: aligned, eligible not aligned, not eligible and not assessed shares for all three KPIs
  • Check against the 10 % relief for activities not assessed, per KPI
  • OpEx not material switch that marks the OpEx KPI as exempt
  • Aligned amounts split by the 6 environmental objectives and by enabling and transitional activities
  • Reconciliation check that activity totals equal each denominator

How to use it

Enter the three denominators on the Inputs sheet from the consolidated accounts before you list any activity.

Files

  • XLSXeu-taxonomy-kpi-calculator.xlsx16 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What goes into the CapEx denominator for the EU Taxonomy?

Under Annex I of Delegated Regulation (EU) 2021/2178 the denominator covers additions to tangible and intangible assets in the year before depreciation, amortisation and remeasurements, excluding fair value changes, plus additions from business combinations. Right-of-use assets from leases count. Leases that do not create a right-of-use asset do not.

What is the 10 % materiality relief in the Taxonomy disclosures?

Delegated Regulation (EU) 2026/73 lets non-financial undertakings skip the eligibility and alignment assessment for activities whose combined turnover, CapEx or OpEx is below 10 % of the relevant KPI denominator. It applies from 1 January 2026, and for the 2025 financial year companies could choose the earlier rules instead.

Can a company leave out the OpEx KPI?

Where operating expenditure is not material for the business model, the company can omit the eligibility and alignment assessment for OpEx, provided it discloses the total OpEx denominator and explains why OpEx is not material. The calculator has a switch for this case and still shows the denominator.