EUDR check sheet for EU web shops selling coffee, chocolate, wooden furniture, paper and rubber goods: trader records under Article 5, the due diligence statement reference number and the 30 December 2026 date under Deforestation Regulation (EU) 2023/1115 as amended in 2025 and 2026, for accountants, bookkeepers and web agencies
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 EUDR check sheet for EU web shops, one row per product line made with cocoa, coffee, oil palm, rubber, soya, wood or cattle. You fill short answers from the shop's product list and purchase files, and the formulas return a scope note (Annex I), the shop's role (trader, downstream operator or operator), the date that applies with the days left (30 December 2026, 30 June 2027 or 30 December 2027), a records or due diligence status that names each missing item (Articles 4 and 5), the registration status for large shops (Article 5(2)), a to-do list with the Article behind each line and a result (OK, PREPARE BY [date], FIX, CHECK BY HAND or OUT OF SCOPE). Also included: a supplier request template and a client email. We tested the formulas in LibreOffice on fourteen made-up product lines, at two dates, before publishing.
Short answer: the main obligations of Regulation (EU) 2023/1115 apply from 30 December 2026 (Article 38(2), as replaced by Regulation (EU) 2025/2650), 50 days from 10 November 2026. A web shop that buys covered products from an EU supplier is a trader: it may sell them “only if” it holds the supplier's name, postal address, email and, where the supplier is the operator, “the reference numbers of the due diligence statements” (Article 5(1) and 5(3)(a)), and keeps them for at least five years (Article 5(4)). A shop that imports, or buys from a seller outside the EU, is the operator (Article 7) and must submit a due diligence statement before selling (Article 4(2)).
Why accountants, bookkeepers and web agencies should look at this now
- The trader rules are light but strict. No statement to file, but no sale without the supplier details on file (Article 5(1)). Most of these details already sit in the purchase ledger; the missing piece is usually the statement reference number, which operators must pass down the chain (Article 4(7)).
- Company size decides two things. Non-SME traders must register before selling (Article 5(2)); micro and small operators established by 31 December 2024 get until 30 June 2027 (Article 38(3)). You hold the balance sheet, turnover and headcount figures that decide the size (Directive 2013/34/EU, Article 3).
- Imports from outside the EU change the role. A small shop importing teak furniture or coffee beans becomes the operator, with full due diligence (Articles 4 and 8 to 11).
- Fines are serious. For legal persons, the maximum fine set by Member States must be at least 4% of total annual Union-wide turnover (Article 25(2)(a)).
- It pairs with our product safety page sheet and our supplier request sheet.
Step 1: find the covered product lines (scraper, free during launch)
- Run the Shopify & WooCommerce Product + Price Tracker on each client shop. It returns products, prices, variants and SKU/GTIN from independent Shopify, WooCommerce and schema.org shops, and skips shops whose robots.txt or terms forbid scraping. You pay only your own Apify usage costs.
- Filter the titles for words like coffee, Kaffee, café, espresso, cocoa, chocolate, Schokolade, wood, oak, teak, Holz, furniture, paper, notebook, charcoal, tyre, rubber, gloves, palm, soy. Copy each match to columns B and C.
- The scraper does not know the CN code or the supplier. Check each line against Annex I (the table below gives common shop items) and fill columns D to P from the purchase invoices and accounts.
- Need the suppliers' or shop owners' contacts to send the request below? The Website Contact Scraper returns emails (MX-checked), phones and social profiles from their websites, one de-duplicated row per site.
Common web-shop items in Annex I (as amended to 18 September 2026)
| Item | Annex I entry | Status |
|---|---|---|
| Coffee beans, roasted or ground coffee | 0901 | Listed |
| Instant (soluble) coffee | 2101 11 00 | Listed from 30 Dec 2027 |
| Chocolate and food preparations containing cocoa; cocoa powder; cocoa butter | 1806; 1805; 1804 | Listed |
| Soap made using oil palm (bars; other forms) | ex 3401 11 00; ex 3401 20 | Listed from 30 Dec 2027 |
| Palm oil; soya-bean oil | ex 1511; 1507 | Listed |
| New tyres; inner tubes; rubber gloves and clothing (natural rubber) | ex 4011; ex 4013; ex 4015 | Listed (4015: not used or second-hand) |
| Wooden kitchenware, frames, ornaments, other wood articles; firewood, charcoal | ex 4419; ex 4414; ex 4420; ex 4421; ex 4401; ex 4402 | Listed (most: not used or second-hand) |
| Paper and paperboard articles, e.g. notebooks | ex 48 | Listed (not recovered paper, not packing for another product) |
| Wooden furniture; wooden seats | ex 9403 30–60, 91; ex 9401 31, 41, 61, 69, 80, 91 90 | Listed (not used or second-hand) |
| Printed books | ex 49 | Not listed (deleted by Regulation (EU) 2025/2650) |
| Cattle leather | ex 4101, 4104, 4107 | Not listed (deleted by Delegated Regulation (EU) 2026/2102) |
| Bamboo and rattan products | Table note 4 | Not listed |
Annex I works by CN code. When the code of a product is not in the table, it is not covered. When in doubt, enter Not sure and ask the supplier for the CN code.
Step 2: the sheet, one row per product line (columns A to X)
Create a tab called Products. Row 1 holds the headers below; paste the formulas into R2 to X2 and fill down. Add a Settings tab: B1 today (=TODAY()), B2 = 2026-12-30, B3 = 2027-06-30, B4 = 2027-12-30, B5 = B2-B1, B6 = B3-B1, B7 = B4-B1 (days left). Type the answers exactly as shown. The formulas use only IF, AND, OR, LEFT, UPPER, ISNUMBER, SEARCH 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.
| Col | What goes in it | Based on |
|---|---|---|
| A | Shop website | You |
| B | Product page URL | Product scraper |
| C | Product title | Product scraper |
| D | Commodity: Cocoa, Coffee, Oil palm, Rubber, Soya, Wood, Cattle or None | Art 1(1), 2(1) |
| E | Annex I: Listed, Listed from 30 Dec 2027, Not listed or Not sure | Annex I |
| F | Used, second-hand or made only from waste? Y/N | Annex I notes |
| G | Where the shop gets it: EU supplier, Made from EU products, Imports or non-EU seller or Not sure | Art 2(15), (15b), (17), Art 7 |
| H | Shop size: Micro, Small, Medium or Large | Art 2(30); Dir 2013/34/EU Art 3 |
| I | Established as micro or small by 31 Dec 2024? Y/N (operators only) | Art 38(3) |
| J | Wood product in the Annex to Regulation (EU) No 995/2010? Y/N/Not sure (micro or small wood operators only) | Art 38(3) |
| K | Supplier name, trade name, postal address and email (and web address, if any) on file? Y/N | Art 5(3)(a) |
| L | Statement reference number or declaration identifier on file? Y, N or Supplier is not an operator | Art 4(7), 5(3)(a) |
| M | Business buyers' name, address and email on file? Y, N or Consumers only | Art 5(3)(b) |
| N | Records kept at least 5 years? Y/N | Art 5(4) |
| O | Registered in the EU information system? Y/N (large shops only) | Art 5(2), 33 |
| P | Due diligence done and statement submitted before selling? Y/N (operators only) | Art 4(1)–(2), 8 |
| Q | Notes | You |
| R | Scope note | Art 1, 2(2), Annex I |
| S | Role | Art 2, 7 |
| T | Date that applies, with days left | Art 38(2)–(3); Del Reg 2026/2102 |
| U | Records (traders, downstream operators) or due diligence (operators), naming each missing item | Art 4, 5 |
| V | Registration status | Art 5(2) |
| W | To-do list with Article cites | As cited |
| X | Result | Summary |
Size test (Directive 2013/34/EU, Article 3, amounts as amended by Delegated Directive (EU) 2023/2775): an undertaking is micro if on its balance sheet date it does not exceed two of: balance sheet total EUR 450,000, net turnover EUR 900,000, 10 employees on average; small: EUR 5,000,000, EUR 10,000,000, 50 employees (Member States may raise the money limits to EUR 7,500,000 and EUR 15,000,000); medium: EUR 25,000,000, EUR 50,000,000, 250 employees. Anything bigger is large, so not an SME.
Formulas (row 2; fill down). In Excel files saved by some tools TEXTJOIN shows as _xlfn.TEXTJOIN; that is the same function.
R2: =IF(A2="","",IF(OR(D2="None",E2="Not listed"),"OUT OF SCOPE: NOT IN ANNEX I TO REGULATION (EU) 2023/1115 - KEEP A NOTE OF THE CN CODE",IF(AND(D2<>"Cocoa",D2<>"Coffee",D2<>"Oil palm",D2<>"Rubber",D2<>"Soya",D2<>"Wood",D2<>"Cattle"),"CHECK BY HAND: FILL COLUMN D (COCOA / COFFEE / OIL PALM / RUBBER / SOYA / WOOD / CATTLE / NONE)",IF(AND(E2<>"Listed",E2<>"Listed from 30 Dec 2027"),"CHECK BY HAND: FIND THE CN CODE AND CHECK ANNEX I, THEN FILL COLUMN E",IF(F2="Y","CHECK BY HAND: USED, SECOND-HAND OR MADE ONLY FROM WASTE - MANY ANNEX I ENTRIES EXCLUDE THESE; CHECK THE ENTRY",IF(F2<>"N","CHECK BY HAND: FILL COLUMN F","IN SCOPE: "&UPPER(D2)&" PRODUCT LISTED IN ANNEX I (ART 1(1), 2(2))"))))))
S2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE"),"",IF(G2="EU supplier","TRADER (ART 2(17)): RECORDS UNDER ART 5",IF(G2="Made from EU products","DOWNSTREAM OPERATOR (ART 2(15b)): RECORDS UNDER ART 5",IF(G2="Imports or non-EU seller","OPERATOR (ART 2(15), ART 7): DUE DILIGENCE AND STATEMENT BEFORE SELLING (ART 4)","CHECK BY HAND: FILL COLUMN G (WHERE DOES THE SHOP GET THE PRODUCT?)"))))
T2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(E2="Listed from 30 Dec 2027","30 DEC 2027 ("&Settings!$B$7&" DAYS LEFT) - ENTRY ADDED BY DELEGATED REGULATION (EU) 2026/2102",IF(LEFT(S2,8)<>"OPERATOR","30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - ART 38(2)",IF(AND(H2<>"Micro",H2<>"Small",H2<>"Medium",H2<>"Large"),"CHECK BY HAND: FILL COLUMN H (SIZE)",IF(OR(H2="Medium",H2="Large",I2="N"),"30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - ART 38(2)",IF(I2<>"Y","CHECK BY HAND: FILL COLUMN I",IF(D2<>"Wood","30 JUN 2027 ("&Settings!$B$6&" DAYS LEFT) - MICRO OR SMALL OPERATOR ESTABLISHED BY 31 DEC 2024 (ART 38(3))",IF(J2="N","30 JUN 2027 ("&Settings!$B$6&" DAYS LEFT) - MICRO OR SMALL OPERATOR ESTABLISHED BY 31 DEC 2024 (ART 38(3))",IF(J2="Y","30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - WOOD PRODUCT UNDER THE OLD TIMBER REGULATION: NO DEFERRAL (ART 38(3))","CHECK BY HAND: FILL COLUMN J (WAS THE PRODUCT IN THE ANNEX TO REGULATION (EU) NO 995/2010?)")))))))))
U2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(LEFT(S2,8)="OPERATOR",IF(P2="Y","OK: DUE DILIGENCE DONE AND STATEMENT SUBMITTED BEFORE SELLING - KEEP 5 YEARS (ART 4(1)-(3))",IF(P2="N","MISSING - DUE DILIGENCE (ART 8-11) AND A DUE DILIGENCE STATEMENT IN THE EU INFORMATION SYSTEM BEFORE SELLING (ART 4(2), ANNEX II)","CHECK BY HAND: FILL COLUMN P")),IF(OR(K2="",N2="",AND(L2<>"Y",L2<>"N",L2<>"Supplier is not an operator"),AND(M2<>"Y",M2<>"N",M2<>"Consumers only")),"CHECK BY HAND: FILL COLUMNS K TO N",IF(AND(K2="Y",L2<>"N",M2<>"N",N2="Y"),"OK: SUPPLIER AND BUSINESS BUYER RECORDS KEPT (ART 5(1), 5(3)-(4))","MISSING -"&IF(K2<>"Y"," SUPPLIER NAME, ADDRESS AND EMAIL (ART 5(3)(a));","")&IF(L2="N"," STATEMENT REFERENCE NUMBER FROM THE SUPPLIER (ART 4(7), 5(3)(a));","")&IF(M2="N"," BUSINESS BUYERS' NAME, ADDRESS AND EMAIL (ART 5(3)(b));","")&IF(N2<>"Y"," 5-YEAR RECORD KEEPING (ART 5(4));","")))))
V2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(LEFT(S2,8)="OPERATOR","NOT APPLICABLE: OPERATORS SUBMIT DUE DILIGENCE STATEMENTS (ART 4(2))",IF(OR(H2="Micro",H2="Small",H2="Medium"),"NOT REQUIRED: SME (ART 2(30), 5(2))",IF(H2="Large",IF(O2="Y","OK: REGISTERED IN THE EU INFORMATION SYSTEM (ART 5(2))",IF(O2="N","MISSING - REGISTRATION IN THE EU INFORMATION SYSTEM BEFORE SELLING (ART 5(2), 33)","CHECK BY HAND: FILL COLUMN O")),"CHECK BY HAND: FILL COLUMN H (SIZE)"))))
W2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE"),"",TEXTJOIN("; ",TRUE,IF(ISNUMBER(SEARCH("SUPPLIER NAME",U2)),"Ask each supplier for name, trade name or mark, postal address, email and web address (Art 5(3)(a))",""),IF(ISNUMBER(SEARCH("REFERENCE NUMBER FROM",U2)),"Get the due diligence statement reference number or declaration identifier from the supplier (Art 4(7), 5(3)(a))",""),IF(ISNUMBER(SEARCH("BUSINESS BUYERS' NAME",U2)),"Record business buyers' name, address and email; consumers are not listed (Art 5(3)(b))",""),IF(ISNUMBER(SEARCH("5-YEAR",U2)),"Keep these records for at least 5 years (Art 5(4))",""),IF(ISNUMBER(SEARCH("ART 8-11",U2)),"Collect the Article 9 information, assess and mitigate risk, then submit the statement before selling (Art 4, 8-11)",""),IF(LEFT(S2,8)="OPERATOR","Give the statement reference number to business buyers (Art 4(7))",""),IF(LEFT(V2,7)="MISSING","Register in the EU information system before selling (Art 5(2))",""),IF(AND(H2="Large",LEFT(S2,8)<>"OPERATOR",LEFT(S2,5)<>"CHECK"),"On a substantiated concern, check due diligence was done before selling (Art 5(6))",""),IF(OR(LEFT(S2,5)="CHECK",LEFT(T2,5)="CHECK",LEFT(U2,5)="CHECK",LEFT(V2,5)="CHECK"),"Answer the CHECK BY HAND columns",""),"If you learn of a risk, tell the authorities and business buyers at once (Art 4(5), 5(5))"))
X2: =IF(A2="","",IF(LEFT(R2,3)="OUT","OUT OF SCOPE",IF(OR(LEFT(R2,5)="CHECK",LEFT(S2,5)="CHECK",LEFT(T2,5)="CHECK",LEFT(U2,5)="CHECK",LEFT(V2,5)="CHECK"),"CHECK BY HAND",IF(OR(LEFT(U2,7)="MISSING",LEFT(V2,7)="MISSING"),IF(IF(LEFT(T2,11)="30 DEC 2026",Settings!$B$5,IF(LEFT(T2,11)="30 JUN 2027",Settings!$B$6,Settings!$B$7))>0,"PREPARE BY "&LEFT(T2,11),"FIX"),"OK"))))
What we tested
Fourteen made-up product lines in LibreOffice (xlsx → ods → csv), first with today fixed at 10 Nov 2026 (50 days to 30 Dec 2026), then at 5 Jan 2027: a small shop's chocolate from an EU wholesaler with all records (OK); a micro shop's coffee beans with nothing on file (PREPARE BY 30 DEC 2026, then FIX); instant coffee without the reference number (PREPARE BY 30 DEC 2027 at both dates); a small importer of oak chairs established before 2025 (PREPARE BY 30 JUN 2027); a micro importer of teak tables that were under the old Timber Regulation (PREPARE BY 30 DEC 2026, then FIX); a large shop selling rubber gloves that is not registered (PREPARE, then FIX, Article 5(2)); a ceramic mug and a bamboo board (OUT OF SCOPE); a second-hand wooden chair (CHECK BY HAND); a medium shop's own palm oil soap with records (OK, 30 Dec 2027); a medium importer of notebooks with its statement filed (OK); and three half-filled rows (CHECK BY HAND). 14/14 gave the intended result at both dates, the empty row stayed blank, and no cell showed an error.
Supplier request (template)
Subject: EU Deforestation Regulation: details we need before 30 December 2026 Hello, From 30 December 2026 we may sell the products below only if we hold these details (Regulation (EU) 2023/1115, Article 5(3)(a)): 1. Your name, registered trade name or trade mark, postal address, email address and web address. 2. If you placed the products on the EU market yourself (you are the operator): the reference number of the due diligence statement for each product or delivery (Article 4(7)). 3. If you bought them from someone else in the EU: please confirm this. 4. The CN code of each product. Products: [list with SKU] Thank you, [Name], [Shop]
Client email
Subject: Your web shop and the EU Deforestation Regulation from 30 December 2026 Hello, We checked [number] product lines in your shop against Regulation (EU) 2023/1115: - [number] lines are covered (coffee, chocolate, wood, paper, rubber ...) - Your role: [trader / operator for imported lines] - [number] lines lack supplier details or the statement reference number (Article 5(3)); from 30 December 2026 they may not be sold without them - [Registration needed in the EU information system: yes/no (Article 5(2))] - [Imported lines: due diligence statement needed by 30 Dec 2026 / 30 Jun 2027] The attached sheet lists each line and the fix. We prepared a request you can send to your suppliers. Best regards, [Name]
Limits and our reading
- National law decides penalties and enforcement. We did not read national laws, Commission guidance, FAQs or the information system manuals. Check the Annex I CN codes against the Combined Nomenclature for each product.
- Our reading, flagged: Article 38(3) names only operators, so the sheet gives traders and downstream operators of every size 30 December 2026; the sheet treats used or second-hand items as CHECK BY HAND because only some Annex I entries exclude them; for products added from 30 December 2027 the sheet shows that date for all roles; and it asks larger shops to verify due diligence on a substantiated concern (Article 5(6)) as a reminder, not a finding.
- Not covered: the content of due diligence (Articles 9 to 11) and the statement fields (Annex II); the simplified declaration for micro or small primary operators (Article 4a), which concerns growers in low-risk countries; authorised representatives (Article 6); exports; products produced before 29 June 2023 (Article 1(2)) and the timber transition in Article 37; and customs steps (Article 26).
- The scraper gives dated product data only. It does not decide whether a product line complies.
FAQ
When does the EU Deforestation Regulation apply to web shops?
From 30 December 2026. Regulation (EU) 2025/2650 replaced Article 38: Articles 3 to 13, 16 to 24, 26, 31 and 32 of Regulation (EU) 2023/1115 apply from 30 December 2026 (Article 38(2)). Operators that are natural persons or micro or small undertakings established as such by 31 December 2024 get 30 June 2027, except for products covered by the Annex to the old Timber Regulation (EU) No 995/2010 (Article 38(3)).
Is a web shop that buys chocolate or coffee from an EU wholesaler an operator?
Usually not. A shop that only makes products available that someone else first placed on the EU market is a trader (Article 2(17)). Since the 2025 amendment, traders do not file due diligence statements. They must hold supplier and business buyer details before selling (Article 5(1) and (3)), keep them for at least five years (Article 5(4)) and, if they are not SMEs, register in the EU information system (Article 5(2)).
When is the web shop the operator?
When it is the first to make the product available on the EU market, for example by importing it, or by buying from a seller established outside the EU that places it on the EU market: Article 7 deems the first person established in the Union who makes such products available to be the operator. Operators must exercise due diligence (Articles 8 to 11) and submit a due diligence statement before selling (Article 4(2)).
Which shop products are covered?
Only products listed in Annex I that contain or are made using cattle, cocoa, coffee, oil palm, rubber, soya or wood, for example coffee (0901), chocolate (1806), cocoa powder (1805), new tyres (4011), rubber gloves (4015), many wood articles (4401 to 4421), paper and paperboard articles (ex 48) and wooden furniture (ex 9403). Bamboo and rattan products, many used or second-hand products and printed books (deleted by Regulation (EU) 2025/2650) are out.
What changed in September 2026?
Delegated Regulation (EU) 2026/2102 (OJ 17.9.2026) amended Annex I. It adds, from 30 December 2027, instant coffee (2101 11 00), soaps made using oil palm (3401 11 00, 3401 20) and several palm oil chemicals, and frozen cattle tongues. It removes cattle hides and leather (4101, 4104, 4107), rubber belts (4010) and other vulcanised rubber articles (4016), and clarifies that packing used to carry another product and used or second-hand products under many entries are not covered.
Does the scraper check deforestation compliance?
No. The product scraper lists products, titles and prices from a shop so you can find the covered lines quickly. Supplier records, statement reference numbers and the company size come from the client's purchase files and accounts.
Sources (read 10 Nov 2026 on EUR-Lex)
- Regulation (EU) 2023/1115 of the European Parliament and of the Council of 31 May 2023 on deforestation-free products, OJ L 150, 9.6.2023 (CELEX 32023R1115), consolidated text 02023R1115-20260918: Articles 1, 2, 3, 4, 4a, 5, 7, 8, 37, 38 and Annex I.
- Regulation (EU) 2025/2650 of 19 December 2025 amending Regulation (EU) 2023/1115 as regards certain obligations of operators and traders, OJ L, 2025/2650, 23.12.2025 (CELEX 32025R2650): Article 1 points (1) to (8), (16), (25), (26).
- Commission Delegated Regulation (EU) 2026/2102 of 13 July 2026 amending Regulation (EU) 2023/1115 as regards the list of relevant commodities and relevant products, OJ L, 2026/2102, 17.9.2026 (CELEX 32026R2102): recitals 2 to 16, Article 1 and the Annex.
- Directive 2013/34/EU, Article 3(1)–(4) (CELEX 32013L0034), and Commission Delegated Directive (EU) 2023/2775, Article 1 (CELEX 32023L2775).
- Product and contact scraper features: Apify Store pages and the public Apify API, read 10 Nov 2026.
Related
- Product safety product-page check sheet (GPSR Article 19)
- Battery check sheet for EU web shops
- Green claims check sheet
- Online food shop check sheet (FIC Article 14)
- Supplier quote request sheet
- Website legal notice check sheet
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.