# CBAM Embedded Emissions Worksheet for Imports into the EU

> Source: https://netray.co/tools/cbam-embedded-emissions-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track each CBAM good by CN code with mass and specific embedded emissions, and total the direct, indirect and overall tCO2e for the report.

## Category

compliance-legal

## Region

European Union

## Industry

Steel, Aluminium, Cement, Fertilisers

## Audience

- Import compliance manager
- Customs specialist
- Exporter to EU

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### CN code

**Key:** cn

**Type:** text

#### Goods description

**Key:** goods

**Type:** text

#### Country of origin

**Key:** origin

**Type:** text

#### CBAM sector

**Key:** sector

**Type:** select

**Options:**

- Iron and steel
- Aluminium
- Cement
- Fertilisers
- Hydrogen
- Electricity

#### Net mass imported (tonnes)

**Key:** mass

**Type:** number

**Format:** decimal

#### Direct SEE (tCO2e per tonne)

**Key:** direct

**Type:** number

**Format:** decimal

**Help:** Specific embedded emissions from the production process.

#### Indirect SEE (tCO2e per tonne)

**Key:** indirect

**Type:** number

**Format:** decimal

**Help:** Only where the goods category requires it.

#### Direct tCO2e

**Key:** direct_t

**Type:** number

**Expr:** mass * direct

**Format:** decimal

#### Indirect tCO2e

**Key:** indirect_t

**Type:** number

**Expr:** mass * indirect

**Format:** decimal

#### Total tCO2e

**Key:** total_t

**Type:** number

**Expr:** direct_t + indirect_t

**Format:** decimal

**Rows:**

**Cn:** 7208

**Goods:** Hot rolled flat steel coil

**Origin:** India

**Sector:** Iron and steel

**Mass:** 240

**Direct:** 2.1

**Indirect:** 0

**Cn:** 7213

**Goods:** Wire rod in coils

**Origin:** Turkey

**Sector:** Iron and steel

**Mass:** 85

**Direct:** 1.6

**Indirect:** 0

**Cn:** 7601

**Goods:** Unwrought aluminium

**Origin:** United Arab Emirates

**Sector:** Aluminium

**Mass:** 60

**Direct:** 7.4

**Indirect:** 0

**Cn:** 2523

**Goods:** Portland cement

**Origin:** Egypt

**Sector:** Cement

**Mass:** 500

**Direct:** 0.82

**Indirect:** 0.06

**Cn:** 3102

**Goods:** Nitrogenous fertiliser

**Origin:** Algeria

**Sector:** Fertilisers

**Mass:** 150

**Direct:** 2.4

**Indirect:** 0.1

**Totals:**

#### Total tonnes imported

**Key:** mass

**Agg:** sum

**Format:** decimal

#### Total direct tCO2e

**Key:** direct_t

**Agg:** sum

**Format:** decimal

#### Total indirect tCO2e

**Key:** indirect_t

**Agg:** sum

**Format:** decimal

#### Total embedded tCO2e

**Key:** total_t

**Agg:** sum

**Format:** decimal

**Summary:**

#### Average embedded emissions (tCO2e per tonne)

**Key:** avg_see

**Expr:** if(gt(sum_mass,0), sum_total_t / sum_mass, 0)

**Format:** decimal

#### Largest single line (tCO2e)

**Key:** max_line

**Expr:** max_total_t

**Format:** decimal

**Notes:** Example emissions values are placeholders, not default values from the EU. Use verified installation data from your supplier, or the default values published by the European Commission where allowed. Which goods need indirect emissions, the reporting period and the certificate rules are set in Regulation (EU) 2023/956 and its implementing acts, so check the current text before filing.

## Content

**Intro:** The EU Carbon Border Adjustment Mechanism charges importers of certain carbon-intensive goods for the emissions embedded in them. After the transitional reporting phase ended in 2025, the definitive period requires importers to track embedded emissions per consignment. This worksheet keeps that data in one auditable table.

**Sections:**

#### How to use it

**Body:** Add one row per CN code and installation or origin. Enter the net mass in tonnes, then the direct specific embedded emissions in tCO2e per tonne obtained from your supplier's emissions report, and the indirect figure only if the goods category requires it. The sheet multiplies mass by each factor and totals the result. Export the table to Excel to support your annual CBAM declaration and your supplier correspondence.

**Bullets:**

- Group by CN code and production installation
- Request installation-level data from each supplier
- Keep supplier reports and verification evidence on file
- Reconcile mass against customs entries

#### The method behind it

**Body:** Embedded emissions are the direct emissions from producing the goods, plus indirect emissions from electricity consumed in production where the regulation requires them, divided by output. CBAM covers iron and steel, aluminium, cement, fertilisers, hydrogen and electricity, with some downstream products added in scope reviews. Total embedded emissions for a consignment equal mass times specific embedded emissions, and the certificate obligation is then reduced by the free allocation phase-out and any carbon price already paid in the origin country.

#### Reading the result

**Body:** The average tCO2e per tonne shows how carbon-intensive your import mix is, and the largest line shows where supplier data quality matters most. A blast furnace route steel coil carries a very different figure from an electric arc furnace coil, so ask each supplier for their actual route. Default values are usually conservative, so verified supplier data often lowers the number.

#### Common mistakes

**Body:** Common faults include using the wrong CN code, including indirect emissions for goods where they are not counted, mixing gross and net mass, using one supplier figure for several installations, and reporting data that was never verified. Check the latest guidance on precursors, because the embedded emissions of an input material can add to the final product.

**Cta:** Netray can extract imported tonnage, CN codes and supplier data from your ERP purchasing and receiving records into a CBAM report, read-only and with the query visible.

**Faq:**

#### What is CBAM?

**Answer:** The Carbon Border Adjustment Mechanism is an EU measure that prices the carbon embedded in selected imported goods so they face a cost comparable to EU producers under the Emissions Trading System. Importers report emissions and surrender certificates.

#### Which goods are covered?

**Answer:** Cement, electricity, fertilisers, iron and steel, aluminium and hydrogen are covered, identified by CN code, plus certain downstream articles. Always check the annex in the current regulation for the exact list.

#### What is specific embedded emissions?

**Answer:** It is the tonnes of CO2e emitted per tonne of goods produced, split into direct emissions from the process and indirect emissions from electricity where applicable. Supplier installations calculate it using the monitoring rules in the implementing acts.

#### Do exporters outside the EU need this?

**Answer:** The legal obligation falls on the EU importer, but they will ask non-EU suppliers for installation emissions data, so exporters benefit from having verified numbers ready for each CN code they ship.

## Search terms

cbam embedded emissions worksheet, cbam calculation excel, cbam emissions calculator, cbam specific embedded emissions, cbam cn code list steel aluminium, cbam importer template, carbon border adjustment mechanism excel, cbam declaration data

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json