EU Taxonomy Alignment Screen and Article 8 KPI Workbook (16 Climate DA activities)

All Industries, Financial Model, Renewable Energy

Excel, Financial Model, Financial Reporting, KPIs (Key Performance Indicators), Report

Article 8 of the Taxonomy Regulation asks every in-scope company for three numbers: the share of turnover, CapEx and OpEx that is Taxonomy-aligned. Getting there means screening each activity against Article 3 and then filling the 21-column Annex II template. This workbook does both.

Criteria library: 16 climate change mitigation activities from Annex I of the Climate Delegated Act (solar PV, wind, hydro, grid, storage, RE manufacturing, cement, iron and steel, freight rail, urban transport, cars and vans, new buildings, renovation, RE installation, building acquisition, data centres). For each: the substantial contribution criterion, the numeric threshold where one exists (cement 0.722 tCO2e/t, hydro 100 gCO2e/kWh, cars 0 g/km from 2026, new buildings PED 10% under NZEB, data centre refrigerant GWP 675), which DNSH objectives apply and which the Act marks N/A, and whether the activity is enabling or transitional.
Activity register: pick the section code, enter turnover, CapEx and OpEx and the metric; the quantitative test says Pass or Fail, DNSH is checked only on the objectives that apply, and alignment computes from the four Article 3 conditions.
Summary: the three KPIs with eligible, aligned, eligible-not-aligned and non-eligible splits, enabling and transitional shares, and integrity checks.
Turnover, CapEx and OpEx templates in the Annex II layout: rows A.1, A.2, A, B and total, columns 1 to 21, filled from the register.

Every criterion is read from the EUR-Lex text and the library cites the section. Add your own activities in the yellow rows. Live formulas, no macros, no locked cells. Excel and Google Sheets. Not legal advice; the delegated acts control, and the Guide says exactly what to check by hand.

How to work with this template

Open the workbook in Excel or Google Sheets. Yellow cells are inputs, blue cells are formulas. Start with the Guide sheet, which walks through the sheets in the order they are meant to be used, then enter your own data in place of the example values. Use it if: you report Article 8 Taxonomy KPIs inside a CSRD sustainability statement or for investors. Every figure the workbook produces can be traced back through live formulas to the inputs and to the cited source, so an auditor or client can follow the working. Not suited if: you need criteria for the four non-climate objectives; the library covers climate change mitigation, and you can extend it.

Why you need this template

Screen activities against Article 3 with 16 Climate Delegated Act criteria and produce the turnover, CapEx and OpEx KPIs in the Annex II template. Building this from a blank sheet means re-reading the underlying rules, checking every formula against them and testing the arithmetic against a worked example; that work has been done here and is documented inside the workbook. No macros, no locked cells, no hidden sheets. Contents: 1 Excel workbook (.xlsx), sheets: Summary, Criteria library, Activities, Turnover KPI, CapEx KPI, OpEx KPI, Guide, Sources.

You must log in to submit a review.