EU Taxonomy Article 8 KPI template: the turnover, CapEx and OpEx KPIs after Delegated Regulation (EU) 2026/73, and an Excel workbook that computes them

If you are looking for an EU Taxonomy Article 8 KPI template in 2026, there are two things to know before you download anything. First, the template changed: the 21-column Annex II table that every company used for FY2022 to FY2024 was replaced on 8 January 2026 by two shorter templates. Second, the arithmetic behind the template did not change: three denominators, one numerator each, and an activity-by-activity screen against Article 3. This page sets out what the KPIs are, what the new templates ask for, what the 10% non-material rule lets you leave out, and the Excel workbook Bindler built to do the screen and the arithmetic. It is a working aid for preparers, not legal advice and not assurance.

The three KPIs, and where they come from

Article 8(2) of Regulation (EU) 2020/852 asks every non-financial undertaking in the CSRD's scope to disclose the proportion of its turnover, capital expenditure and operating expenditure that is associated with environmentally sustainable (Taxonomy-aligned) economic activities. Delegated Regulation (EU) 2021/2178 defines each ratio in Annex I:

An activity counts in a numerator only if it passes all four Article 3 conditions: substantial contribution to one of the six objectives under the technical screening criteria, no significant harm to the other five, minimum safeguards (Article 18), and the criteria of the delegated act for that objective. Eligible-but-not-aligned activities are reported separately, and everything not in a delegated act is non-eligible.

What Delegated Regulation (EU) 2026/73 changed

Commission Delegated Regulation (EU) 2026/73 of 4 July 2025 was published in the Official Journal on 8 January 2026, entered into force on 28 January 2026, and applies from 1 January 2026. Under its Article 4, undertakings may still apply Delegated Regulations 2021/2178, 2021/2139 and 2023/2486 as they stood on 31 December 2025 for a financial year that starts between 1 January and 31 December 2025. So an FY2025 report can use either layout; an FY2026 report uses the new one.

For the non-financial KPIs the changes are:

The workbook, and how it maps onto Template 1

The EU Taxonomy Alignment Screen and Article 8 KPI Workbook takes the activity register and returns the three KPIs. Eight sheets, live formulas, no macros, no locked cells:

1. Summary: the three denominators (inputs), then eligible amount, aligned amount, eligible-not-aligned, non-eligible, the aligned proportion, the eligible proportion, the enabling and transitional shares, a prior-year input, and four checks (eligible not above the denominator, register rows with no substantial-contribution answer, quantitative tests waiting on a metric, aligned row count).

2. Criteria library: 16 climate change mitigation activities from Annex I of Delegated Regulation (EU) 2021/2139 (sections 3.1, 3.7, 3.9, 4.1, 4.3, 4.5, 4.9, 4.10, 6.2, 6.3, 6.5, 7.1, 7.2, 7.6, 7.7, 8.1) with the substantial contribution criterion summarised, the threshold and unit where the test is quantitative, which of the five DNSH criteria apply to that activity, and the enabling or transitional flag. Fourteen blank rows take activities you add from the delegated acts.

3. Activities: one row per activity or per activity per segment. Pick the section code and the name, eligibility, DNSH applicability and category fill in. Enter turnover, CapEx and OpEx, the metric value where the criterion is quantitative (the sheet says Pass or Fail against the library threshold), then answer substantial contribution, the applicable DNSH questions and minimum safeguards. Taxonomy-aligned computes from those answers; the aligned amounts flow to the Summary.

4. Turnover KPI, CapEx KPI, OpEx KPI: the activity-level table in the 21-column layout of Annex II as it stood before 2026/73, with rows A.1 (aligned), A.2 (eligible not aligned) and B (non-eligible), DNSH columns showing N/A only where the library says the objective does not apply, and E and T markers.

5. Guide and Sources: how to use it, the CapEx plan rule, the adaptation exclusion, and the article behind every figure.

The KPI sheets carry the pre-2026 layout, so here is how the workbook's figures fill the new Template 1 for the turnover row (CapEx and OpEx are the same mapping on their own rows):

Template 1 columnWorkbook cell or figure
(2) TotalSummary, denominator input
(3) Proportion of Taxonomy-eligible activitiesSummary, eligible proportion (A / denominator)
(4) Taxonomy-aligned activities, currencySummary, Taxonomy-aligned amount (A.1)
(5) Proportion of Taxonomy-aligned activitiesSummary, KPI aligned proportion (A.1 / denominator)
(6) Climate change mitigationequal to column (5) while the library holds mitigation activities only; add other objectives' activities to the library to split it
(7) to (11) other objectivesblank unless you add activities under those objectives
(12) Proportion of enabling activitiesSummary, of which enabling (E)
(13) Proportion of transitional activitiesSummary, of which transitional (T)
(14) Not assessed, considered non-materialthe amounts you chose to leave out of the register under the 10% rule, divided by the denominator; keep the list on the Evidence column of the Activities sheet
(15) and (16) previous yearSummary, prior-year aligned proportion input, and the prior year's aligned amount

Template 2 for each KPI is the Activities sheet read row by row: the code is "CCM " plus the section code, the eligible and aligned proportions are the row's amount over the denominator, and column (14) is the aligned share of the eligible amount for that row. A version of the workbook with the KPI sheets rebuilt in the Template 1 and Template 2 layout, and a non-material line on the Summary, is the next update to this product; buyers get updates on Gumroad at no charge.

A worked case from the workbook's own test

The workbook ships verified against a six-activity register with a turnover denominator of 1,000m: aligned turnover 580m, so the KPI is 58%; eligible 75%; enabling 8%; transitional 20%; CapEx KPI 67.5%; OpEx KPI 56%. Two quantitative tests are in the case: a hydropower plant at 120 gCO2e/kWh fails the 100 gCO2e/kWh life-cycle threshold of section 4.5, and a cement plant at 0.70 tCO2e per tonne of clinker passes the 0.722 threshold of section 3.7. The DNSH and safeguards failures in the case each drop the row from A.1 to A.2 and the totals move accordingly. All of those figures were checked by hand before listing.

Activities sheet: one row per activity with the section code, amounts, quantitative test, DNSH answers and the aligned result
Activities: the register and the Article 3 screen, one row per activity.
Summary sheet with the three denominators, eligible and aligned amounts and the KPI proportions
Summary: denominators in, the three KPIs and the enabling and transitional shares out.
Criteria library listing 16 Climate Delegated Act activities with thresholds and DNSH applicability
Criteria library: 16 mitigation activities from Annex I of Delegated Regulation (EU) 2021/2139.

What it does not do

It screens climate change mitigation activities; the four environmental objectives and adaptation need rows you add from Delegated Regulation (EU) 2023/2486 and Annex II of 2021/2139. It does not decide materiality for you: the 10% rule is a choice you document, and the workbook only holds the amounts you leave out. It is not the financial-undertaking KPIs (green asset ratio, and the rest), which sit in Annexes III to XI and were simplified separately by the same regulation.

If the Taxonomy KPIs sit inside a CSRD sustainability statement, the double materiality template is the workbook that comes before this one, and the CSRD deadlines page says whether and when you report at all.

Sources

Last checked against the sources on 20 September 2026.

EU Taxonomy Alignment Screen and Article 8 KPI Workbook (16 Climate DA activities)Screen activities against Article 3 with 16 Climate Delegated Act criteria, then produce the turnover, CapEx and OpEx KPIs in the Annex II template.
See the workbook, $39

Search terms this page answers: eu taxonomy article 8 kpi template, taxonomy kpi template excel, taxonomy turnover capex opex kpi, taxonomy annex ii template 2026, taxonomy 10 percent materiality threshold, delegated regulation 2026/73, taxonomy alignment screen excel.

New workbooks and updates by email

One email when a new workbook ships or a regulation changes a template. No filler. Sent through Gumroad, unsubscribe in one click.

You can unsubscribe from any email.