Unadhi Guides

EU CBAM 50-tonne check sheet for SME importers of steel, aluminium, fertilisers and cement: the single mass-based threshold, authorised CBAM declarant status, indirect customs representatives and the first CBAM declaration due 30 September 2027 (Regulation (EU) 2023/956 as amended by Regulation (EU) 2025/2083), for accountants and tax advisers

Updated 10 Nov 2026 · Disclosure: the EURO AI Register mentioned below is an Unadhi product with a free edition. Legal facts come from Regulation (EU) 2023/956 establishing a carbon border adjustment mechanism (CBAM), in the EUR-Lex consolidated version of 20.10.2025, and from the amending Regulation (EU) 2025/2083 (OJ L, 17.10.2025), both read on EUR-Lex on 10 Nov 2026. This is a working sheet, not legal or customs advice.

Partner programme opening soon: join the free waitlist. Planned terms are 50% of each referred sale (75% once you have 5+ paying customers), single level, paid through Gumroad only from revenue received.

What you get: a finished, tested CBAM 50-tonne check sheet for accountants, tax advisers and bookkeepers whose SME clients import steel, aluminium, fertilisers or cement from outside the EU: metal traders, builders, machine shops, workshops, garden and farm suppliers, web shops selling screws, brackets or aluminium profiles. One row per customs declaration. Formulas read the CN code against Annex I, drop out-of-scope origins, add up each importer's tonnes per calendar year, compare them with the 50-tonne single mass-based threshold, check the authorised CBAM declarant status (including for an indirect customs representative) and show the 30 September declaration date with the days left. Each row ends in one result: EXEMPT UNDER 50 T, WATCH: NEAR 50 T, APPLY NOW, DECLARE BY [date], PROVISIONAL, PENALTY RISK, OVERDUE, DONE, FIX, FIX REPRESENTATIVE, CHECK BY HAND, NOT CBAM GOODS or OUT OF SCOPE.

Short answer: since 1 January 2026, CBAM goods may be imported "only by an authorised CBAM declarant" (Article 4, applying from 1 January 2026 under Article 36(2)(b)). The exception: an importer whose net mass of CBAM goods in a calendar year "does not cumulatively exceed" 50 tonnes, all CN codes added together, is exempt for that year and declares the exemption in the customs declaration (Article 2a(1), Annex VII point 1). Go above 50 tonnes and every obligation applies to all goods imported that year (Article 2a(2)). The first CBAM declaration and surrender of certificates, for 2026 imports, is due by 30 September 2027 (Articles 6(1) and 22(1)): 324 days from 10 November 2026.

What to tell a client in one minute

Why AI bookkeeping and customs tools matter here

Many firms now let AI invoice-capture or customs-data tools read purchase invoices and customs declarations. They give you CN codes and weights line by line, but they do not add up one importer's tonnes across a year, and they often read gross weight instead of net mass. Export the import lines (date, declaration number, CN code, origin, net mass), paste them into columns A to G, and let a person answer columns H to K. Check a sample of CN codes and net masses against the customs declarations before relying on the totals, and keep the tool itself on your AI tool list (see the end of this page).

The rules the sheet checks

RuleWhat the text says
Goods covered (Art 2(1), Annex I)Goods under the CN codes in Annex I originating in a third country: cement, electricity, fertilisers, iron and steel (chapter 72 with exceptions, 2601 12 00, 7301 to 7311, 7318, 7326), aluminium (7601, 7603 to 7614, 7616) and hydrogen (2804 10 00).
Origins outside scope (Art 2(4), Annex III)Iceland, Liechtenstein, Norway, Switzerland, and the territories Büsingen, Heligoland, Livigno, Ceuta and Melilla. Origin is non-preferential origin (Art 2(5)).
50-tonne exemption (Art 2a, Annex VII)Exempt where the importer's net mass in a calendar year does not cumulatively exceed 50 tonnes, all CN codes aggregated; not for electricity or hydrogen (Art 2a(4)). The Commission may change the figure by delegated act from 1 January of a following year (Art 2a(3)).
Who imports (Art 4, 5, 25(1))Goods are imported only by an authorised CBAM declarant; customs "shall not allow the importation of goods by any person other than an authorised CBAM declarant", without prejudice to Article 2a.
Provisional imports (Art 17(7a))An importer or indirect representative that applied by 31 March 2026 may provisionally continue to import until the authority decides; if refused, penalties under Art 26(2a).
Declaration and surrender (Art 6(1), 22(1))By 30 September each year, first in 2027 for 2026, via the CBAM registry.
Certificates (Art 20(1), 21(1a), 22(2), 22(2a))On sale from 1 February 2027; for 2026 emissions priced at the quarterly average of the EU ETS auction price of the quarter of import. From 2027, certificates for at least 50% of embedded emissions must be on account at the end of each quarter, by the end of the quarter after the one in which the threshold is exceeded.
Records (Art 7(5)-(6))Kept until the end of the fourth year after the year in which the declaration was or should have been submitted.

The sheet, one row per customs declaration (columns A to U)

Make three tabs. Imports: headers below in row 1, inputs from row 2, formulas M2 to U2 filled down. CN: the prefix table below, column A formatted as text. Settings: B1 today (=TODAY()), B2 = 50 (threshold in tonnes), B3 = 0.9 (warning share), B4 = 2027-09-30, B5 = =B4-B1 (days left), and in D2:D10 the codes IS, LI, NO, CH, XC (Ceuta), XL (Melilla), BUSINGEN, HELIGOLAND, LIVIGNO. The formulas use only IF, AND, OR, NOT, LEFT, LEN, SUBSTITUTE, VLOOKUP, IFERROR, COUNTIF, SUMIFS, DATE, YEAR, TEXT, ROUND and TEXTJOIN (Excel 2019 or later, Microsoft 365, Google Sheets, LibreOffice). The binary .xlsx is kept in our working copy only (we publish text files); rebuild it from the formulas below.

ColWhat goes in itBased on
AImport date (release for free circulation)Art 3(4)
BCustoms declaration numberDeclaration
CImporter (your client code; one code per importer)Art 3(15)
DCN code, 8 digits (spaces allowed)Annex I
EGoodsInvoice
FCountry of origin, ISO code (EU if Union origin)Art 2(4)-(5), Annex III
GNet mass in kgArt 2a(1)
HDeclared by: OWN NAME, DIRECT REPRESENTATIVE or INDIRECT REPRESENTATIVEArt 3(15), 5(1a), 5(2)
ISpecial case: NONE, RETURNED GOODS, INWARD PROCESSING, OUTWARD PROCESSING or MILITARYArt 2(1), 2(3), 6(3)-(5)
JAuthorised CBAM declarant for this import (the importer, or the indirect representative that declared it): Y, APPLIED BY 31 MAR 2026, APPLIED LATER or NArt 4, 5, 17, 17(7a)
KCBAM declaration and surrender for that year done? Y/NArt 6(1), 22(1)
LNotesYou
MCN group from the CN tab (longest matching prefix: 8, 6, 5, 4, then 2 digits)Annex I
NScope: IN SCOPE (counts towards 50 t, or no exemption for hydrogen and electricity), OUT OF SCOPE, NOT CBAM GOODS, CHECK BY HAND, FIXArt 2, 2a(4)
O–PTonnes counted on this row; the importer's total for that calendar year (SUMIFS by importer and year)Art 2a(1)
Q50 t threshold: UNDER, NEAR (90% or more, current or future year only) or ABOVEArt 2a(1)-(2), 25a(1)
RAuthorisation: OK, PROVISIONAL, NOT AUTHORISED, APPLY NOW, FIX (indirect representative), NO STATUS NEEDEDArt 4, 5, 17(7a), 25(1), 26
SDeclaration date and days left, OVERDUE or DONE; certificate notes for 2026 and for 2027 onwardsArt 6(1), 20(1), 21(1a), 22
TTo-do list with Article citesAs cited
UResultSummary

CN tab (column A as text, column B group). 72 IRON AND STEEL; 72022, 720230, 720250, 720270, 720280, 720291, 720292, 720293, 720299, 7204 NOT IN ANNEX I (EXCEPTION); 260112, 7301 to 7311, 7318, 7326 IRON AND STEEL; 7601, 7603 to 7614, 7616 ALUMINIUM; 25070080 CHECK BY HAND (EX 2507 00 80); 252310, 252321, 252329, 252330, 252390 CEMENT; 280800, 2814, 283421, 3102, 3105 FERTILISERS; 310560 NOT IN ANNEX I (EXCEPTION); 28041000 HYDROGEN; 27160000 ELECTRICITY. Anything else returns NOT IN ANNEX I. Note that 7602 (aluminium scrap) and 7615 (aluminium table and kitchen articles) are not in Annex I.

Formulas (row 2; fill down). In Excel files saved by some tools TEXTJOIN shows as _xlfn.TEXTJOIN; that is the same function.

M2: =IF(D2="","",IF(LEN(SUBSTITUTE(D2," ",""))<>8,"FIX: ENTER THE 8-DIGIT CN CODE",IFERROR(VLOOKUP(LEFT(SUBSTITUTE(D2," ",""),8),CN!$A$2:$B$60,2,0),IFERROR(VLOOKUP(LEFT(SUBSTITUTE(D2," ",""),6),CN!$A$2:$B$60,2,0),IFERROR(VLOOKUP(LEFT(SUBSTITUTE(D2," ",""),5),CN!$A$2:$B$60,2,0),IFERROR(VLOOKUP(LEFT(SUBSTITUTE(D2," ",""),4),CN!$A$2:$B$60,2,0),IFERROR(VLOOKUP(LEFT(SUBSTITUTE(D2," ",""),2),CN!$A$2:$B$60,2,0),"NOT IN ANNEX I")))))))
N2: =IF(A2="","",IF(LEFT(M2,3)="FIX",M2,IF(I2="MILITARY","OUT OF SCOPE: GOODS FOR MILITARY ACTIVITIES (ART 2(3))",IF(LEFT(M2,3)="NOT","NOT CBAM GOODS: CN CODE NOT IN ANNEX I",IF(F2="","FIX: ENTER THE COUNTRY OF ORIGIN (NON-PREFERENTIAL ORIGIN, ART 2(5))",IF(F2="EU","OUT OF SCOPE: GOODS DO NOT ORIGINATE IN A THIRD COUNTRY (ART 2(1))",IF(COUNTIF(Settings!$D$2:$D$12,F2)>0,"OUT OF SCOPE: ORIGIN LISTED IN ANNEX III POINT 1 (ART 2(4))",IF(LEFT(M2,5)="CHECK","CHECK BY HAND: ONLY CALCINED KAOLINIC CLAY IS LISTED (ANNEX I, EX 2507 00 80)",IF(OR(I2="RETURNED GOODS",I2="INWARD PROCESSING",I2="OUTWARD PROCESSING"),"CHECK BY HAND: SPECIAL CUSTOMS PROCEDURE (ART 2(1), 6(3)-(5)); ASK HOW IT IS TREATED FOR THE 50 T THRESHOLD",IF(OR(M2="HYDROGEN",M2="ELECTRICITY"),"IN SCOPE: NO 50 T EXEMPTION FOR "&M2&" (ART 2a(4))",IF(G2="","FIX: ENTER THE NET MASS IN KG","IN SCOPE: COUNTS TOWARDS THE 50 T THRESHOLD (ART 2a(1))")))))))))))
O2: =IF(LEFT(N2,17)="IN SCOPE: COUNTS ",ROUND(G2/1000,3),"")
P2: =IF(OR(A2="",C2="",O2=""),"",SUMIFS($O$2:$O$1000,$C$2:$C$1000,C2,$A$2:$A$1000,">="&DATE(YEAR(A2),1,1),$A$2:$A$1000,"<="&DATE(YEAR(A2),12,31)))
Q2: =IF(P2="","",IF(P2>Settings!$B$2,"ABOVE "&Settings!$B$2&" T IN "&YEAR(A2)&": "&TEXT(P2,"0.000")&" T, SO ALL CBAM GOODS IMPORTED THAT YEAR ARE COVERED (ART 2a(2))",IF(AND(P2>=Settings!$B$2*Settings!$B$3,YEAR(A2)>=YEAR(Settings!$B$1)),"NEAR: "&TEXT(P2,"0.000")&" T IN "&YEAR(A2)&", AT LEAST 90% OF "&Settings!$B$2&" T; EXEMPT SO FAR (ART 2a(1), 25a(1))","UNDER "&Settings!$B$2&" T IN "&YEAR(A2)&": "&TEXT(P2,"0.000")&" T; EXEMPT, DECLARE THE EXEMPTION IN THE CUSTOMS DECLARATION (ART 2a(1))")))
R2: =IF(OR(A2="",AND(Q2="",LEFT(N2,8)<>"IN SCOPE")),"",IF(NOT(OR(LEFT(Q2,5)="ABOVE",LEFT(N2,21)="IN SCOPE: NO 50 T EXE")),IF(AND(LEFT(Q2,4)="NEAR",J2<>"Y",YEAR(A2)>=YEAR(Settings!$B$1)),"APPLY NOW IF MORE IMPORTS ARE EXPECTED THIS YEAR: THE STATUS IS NEEDED BEFORE THE 50 T THRESHOLD IS EXCEEDED (ART 5(1b), REG 2025/2083 RECITAL 10)",IF(AND(H2="INDIRECT REPRESENTATIVE",J2<>"Y"),"FIX: AN INDIRECT CUSTOMS REPRESENTATIVE MUST HOLD THE STATUS OF AUTHORISED CBAM DECLARANT EVEN IF THE IMPORTER IS EXEMPT (ART 5(1a))",IF(J2="Y","OK: AUTHORISED CBAM DECLARANT","NO STATUS NEEDED WHILE UNDER 50 T (ART 2a(1))"))),IF(J2="Y","OK: AUTHORISED CBAM DECLARANT (ART 4, 17)",IF(AND(J2="APPLIED BY 31 MAR 2026",YEAR(A2)=2026),"PROVISIONAL: MAY CONTINUE TO IMPORT UNTIL THE AUTHORITY DECIDES; IF REFUSED, PENALTY UNDER ART 26(2a) (ART 17(7a))","NOT AUTHORISED: CUSTOMS SHALL NOT ALLOW THE IMPORT (ART 4, 25(1)); PENALTY OF 3 TO 5 TIMES THE ART 26(1) PENALTY PER CERTIFICATE NOT SURRENDERED (ART 26(2)); ABOVE 50 T THIS COVERS ALL EMISSIONS OF THE YEAR (ART 26(2a))"))))
S2: =IF(OR(A2="",NOT(OR(LEFT(Q2,5)="ABOVE",LEFT(N2,21)="IN SCOPE: NO 50 T EXE")),NOT(OR(J2="Y",AND(J2="APPLIED BY 31 MAR 2026",YEAR(A2)=2026)))),"",IF(K2="Y","DONE: DECLARATION AND SURRENDER FOR "&YEAR(A2)&" MARKED DONE",IF(DATE(YEAR(A2)+1,9,30)-Settings!$B$1<0,"OVERDUE: CBAM DECLARATION AND SURRENDER FOR "&YEAR(A2)&" WERE DUE "&TEXT(DATE(YEAR(A2)+1,9,30),"YYYY-MM-DD")&" (ART 6(1), 22(1), 26(1))","DUE "&TEXT(DATE(YEAR(A2)+1,9,30),"YYYY-MM-DD")&" ("&(DATE(YEAR(A2)+1,9,30)-Settings!$B$1)&" DAYS LEFT): CBAM DECLARATION AND SURRENDER OF CERTIFICATES FOR "&YEAR(A2)&" (ART 6(1), 22(1))"&IF(YEAR(A2)=2026,"; CERTIFICATES ON SALE FROM 1 FEB 2027, PRICED AT THE QUARTERLY EU ETS AVERAGE OF THE QUARTER OF IMPORT (ART 20(1), 21(1a))","; HOLD CERTIFICATES FOR AT LEAST 50% OF EMBEDDED EMISSIONS AT EACH QUARTER END (ART 22(2), 22(2a))"))))
T2: =IF(A2="","",TEXTJOIN("; ",TRUE,IF(LEFT(N2,3)="FIX","Enter the missing CN code, country of origin or net mass",""),IF(LEFT(N2,5)="CHECK","Ask the customs broker or the CBAM competent authority how this import is treated",""),IF(LEFT(Q2,5)="UNDER","Ask the broker to declare the CBAM exemption in the customs declaration (Art 2a(1))",""),IF(LEFT(Q2,4)="NEAR","Check planned imports for the rest of the year against the 50 t threshold",""),IF(LEFT(R2,5)="APPLY","Apply via the CBAM registry before the threshold is exceeded (Art 5(1b), 5(3))",""),IF(LEFT(R2,3)="FIX","Use an indirect representative with authorised CBAM declarant status, or another form of representation (Art 5(1a))",""),IF(LEFT(R2,3)="NOT","Stop further imports of CBAM goods until authorised, apply via the CBAM registry (Art 5(1), 5(3)) and get advice on the penalty",""),IF(AND(LEFT(R2,3)="NOT",P2<>"",P2<=Settings!$B$2*1.1),"Exceeded by no more than 10%: the authority may reduce the penalty, not below the Art 26(1) level (Art 26(2a))",""),IF(LEFT(R2,11)="PROVISIONAL","Follow up the pending application with the competent authority (Art 17(7a))",""),IF(OR(LEFT(S2,3)="DUE",LEFT(S2,7)="OVERDUE"),"Get embedded emissions data from the producer or use default values (Art 7(2)); keep records until the end of the fourth year after the declaration year (Art 7(5)-(6))",""),IF(LEFT(S2,7)="OVERDUE","Submit the declaration and surrender certificates now; ask the competent authority about the penalty (Art 26(1), 26(3))","")))
U2: =IF(A2="","",IF(LEFT(N2,3)="FIX","FIX",IF(LEFT(N2,5)="CHECK","CHECK BY HAND",IF(LEFT(N2,3)="OUT","OUT OF SCOPE",IF(LEFT(N2,3)="NOT","NOT CBAM GOODS",IF(LEFT(R2,3)="NOT","PENALTY RISK",IF(LEFT(S2,7)="OVERDUE","OVERDUE",IF(LEFT(S2,4)="DONE","DONE",IF(LEFT(R2,11)="PROVISIONAL","PROVISIONAL",IF(OR(LEFT(Q2,5)="ABOVE",LEFT(N2,21)="IN SCOPE: NO 50 T EXE"),"DECLARE BY "&TEXT(DATE(YEAR(A2)+1,9,30),"YYYY-MM-DD"),IF(LEFT(R2,5)="APPLY","APPLY NOW",IF(LEFT(R2,3)="FIX","FIX REPRESENTATIVE",IF(LEFT(Q2,4)="NEAR","WATCH: NEAR 50 T","EXEMPT UNDER 50 T")))))))))))))

What we tested

Sixteen made-up customs declarations for nine importers in LibreOffice (xlsx → ods → csv), in two runs. Run 1, today fixed at 10 Nov 2026: steel screws (2 t) and aluminium profiles (5 t) for the same importer (both EXEMPT UNDER 50 T, year total 7 t); 30 t of Swiss-origin steel coil (OUT OF SCOPE, Annex III); 30 t plus 25 t of steel plate for an importer that applied by 31 March 2026 (both PROVISIONAL, year total 55 t); 20 t for the same importer in 2027 (EXEMPT UNDER 50 T: a new year starts at zero); 40 t of steel brackets plus 12 t of aluminium parts without the status (both PENALTY RISK, with the 10% reduction note); 46 t of urea (APPLY NOW, near 50 t); ferro-silicon (NOT CBAM GOODS, Annex I exception); 0.5 t of hydrogen without the status (PENALTY RISK, no 50 t exemption); kaolinic clay (CHECK BY HAND); aluminium sheet with no net mass (FIX); 60 t of coated steel through an authorised indirect representative (DECLARE BY 2027-09-30); returned goods (CHECK BY HAND); 4 t of steel nuts through an indirect representative without the status (FIX REPRESENTATIVE). Run 2, today fixed at 5 Oct 2027 with no declarations marked done: the three rows due on 30 September 2027 became OVERDUE and the 46 t urea row became EXEMPT UNDER 50 T because 2026 has ended. Both runs: 16/16 intended results, the empty row stayed blank, no formula errors.

Client checklist

Limits and our reading

FAQ

Who is exempt under the CBAM 50-tonne rule?

An importer whose imports of CBAM goods (iron and steel, aluminium, fertilisers, cement) do not cumulatively exceed 50 tonnes of net mass in a calendar year, all CN codes added together, is exempt from the obligations of Regulation (EU) 2023/956 for that year and declares the exemption in the customs declaration (Article 2a(1), Annex VII point 1).

What happens if a client goes above 50 tonnes during the year?

All obligations then apply to all emissions embedded in all goods imported in that calendar year, not only the tonnes above 50 (Article 2a(2)). Imports may only be made by an authorised CBAM declarant (Article 4); an importer above the threshold without that status faces a penalty of three to five times the Article 26(1) penalty per certificate not surrendered (Article 26(2) and (2a)).

Does the 50 tonnes count per shipment or per year?

Per importer and per calendar year, adding up the net mass under all CN codes (Article 2a(1)). Splitting imports artificially to stay below the threshold is treated as circumvention (Article 27(2)(b)) and non-genuine arrangements are disregarded (Article 25a(4)).

Does the exemption apply to hydrogen and electricity?

No. Article 2a does not apply to imports of electricity or hydrogen (Article 2a(4)), so those imports need an authorised CBAM declarant whatever the quantity.

When is the first CBAM declaration due?

By 30 September 2027 for goods imported in 2026, and by 30 September every year after that; CBAM certificates for the same emissions are surrendered by the same date (Articles 6(1) and 22(1)). Certificates go on sale from 1 February 2027 (Article 20(1)).

Our client uses a customs broker. Who needs the status?

An indirect customs representative must hold the status of authorised CBAM declarant before importing CBAM goods, even if the importer is exempt (Article 5(1a)). Where it acts as authorised CBAM declarant, it carries the importer's obligations for those goods (Article 5(2a)). With a direct representative, on our reading of Article 3(15) the client itself is the importer.

Sources (read 10 Nov 2026)

Related

Keep the AI invoice-capture, customs-data and bookkeeping tools your firm and your clients use in one register: the EURO AI Register has a free edition.

← All guides

Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.