# WEEE and Battery Producer Registration Tracker Worksheet > Source: https://netray.co/tools/weee-and-battery-producer-registration-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track producer registrations, authorised representatives, reporting dates and tonnage placed on the market for WEEE and battery rules by country. ## Category compliance-legal ## Region European Union ## Audience - Compliance engineer - Export manager - Finance controller ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Country **Key:** country **Type:** select **Options:** - Germany - France - Italy - Spain - Netherlands - Poland - Sweden - Ireland - Austria - Belgium - Czech Republic #### Stream **Key:** stream **Type:** select **Options:** - WEEE - Batteries - Packaging #### Registration number **Key:** reg_no **Type:** text #### Authorised representative **Key:** rep **Type:** text #### Reporting frequency **Key:** freq **Type:** select **Options:** - Monthly - Quarterly - Annual #### Next report due **Key:** next_due **Type:** date #### Units placed on market **Key:** units **Type:** number **Format:** integer #### Weight per unit (kg) **Key:** kg_unit **Type:** number **Unit:** kg #### Tonnes placed on market **Key:** tonnes **Type:** number **Expr:** units * kg_unit / 1000 **Format:** decimal #### Fee per tonne **Key:** fee_rate **Type:** number **Format:** currency #### Estimated fee **Key:** fee **Type:** number **Expr:** tonnes * fee_rate **Format:** currency **Rows:** **Country:** Germany **Stream:** WEEE **Reg no:** DE 12345678 **Rep:** Appointed rep GmbH **Freq:** Annual **Next due:** 2027-01-31 **Units:** 6200 **Kg unit:** 1.8 **Fee rate:** 450 **Country:** France **Stream:** WEEE **Reg no:** FR000000_00ABCD **Rep:** Appointed rep SAS **Freq:** Quarterly **Next due:** 2026-11-15 **Units:** 3100 **Kg unit:** 1.8 **Fee rate:** 380 **Country:** Netherlands **Stream:** Batteries **Freq:** Annual **Next due:** 2027-03-31 **Units:** 5400 **Kg unit:** 0.35 **Fee rate:** 900 **Country:** Italy **Stream:** WEEE **Reg no:** IT00000000 **Rep:** Appointed rep Srl **Freq:** Annual **Next due:** 2027-02-28 **Units:** 1800 **Kg unit:** 1.8 **Fee rate:** 420 **Totals:** #### Total tonnes **Key:** tonnes **Agg:** sum **Format:** decimal #### Total estimated fees **Key:** fee **Agg:** sum **Format:** currency **Summary:** #### Average fee per tonne **Key:** avg_rate **Expr:** sum_fee / sum_tonnes **Format:** currency **Currency:** EUR **Notes:** All numbers shown are examples, not real registration numbers or fee rates. Rules and fee models differ by member state, and the EU Batteries Regulation changes producer duties over time, so confirm the current obligations with each national register or your authorised representative. ## Content **Intro:** Producer responsibility rules for electrical equipment and batteries are national in practice, even when the underlying EU law is shared. This tracker keeps each country registration, reporting date and tonnage in one editable table so nothing lapses. **Sections:** #### How to use the worksheet **Body:** Add one row per country and stream where you are obliged to register. Enter the registration number when issued, the authorised representative if you are not established in that country, and the reporting frequency. Fill in units sold and weight per unit, and the sheet calculates tonnes and an estimated fee. Export to Excel for finance, who need the fee estimate, and to CSV for the sales data team who provide the unit counts. #### Why tonnage matters **Body:** Most schemes charge or report by weight placed on the market. Your ERP likely knows units shipped per country but not always the net weight per unit, so item master weights need to be accurate. The tonnage column is units multiplied by the unit weight in kilograms, divided by 1,000. Inaccurate item weights lead directly to under- or over-reporting, and authorities do audit this. Aligning net weight, gross weight and packaging weight in the item master is a worthwhile cleanup. **Bullets:** - Reports are usually per country, not per EU - Distance sellers into a country often need a local representative - Packaging has its own producer registration rules - Batteries inside products are often reported separately #### Reading the fee estimate **Body:** The fee estimate multiplies tonnes by the rate you enter. It is a budgeting figure only, because many schemes use category-specific rates, minimum fees or flat registration fees. Use it to compare the cost of selling into different countries and to accrue a provision. Replace the fee rate with the figure from your compliance scheme invoice as soon as you have one. #### Common mistakes **Body:** The costly error is selling into a country before registering, since some jurisdictions can block listings on marketplaces or issue fines. Another is registering once and forgetting the reporting dates. Use the next-due column to build reminders. Finally, check that the producer named on the registration is the legal entity that actually places the goods on that market. **Cta:** If shipment data by country is already in your ERP, we can help produce the tonnage report directly from sales and item weight data. **Faq:** #### Do I need to register in every EU country? **Answer:** If you place covered products on a national market as the producer, including distance sales to consumers there, you generally need to register in that country or appoint an authorised representative. Rules differ, so check each national register. #### What is an authorised representative? **Answer:** A person or company established in the country who takes on the producer duties for a foreign seller. Many countries require one for non-established producers. They typically handle registration, reporting and take-back obligations on your behalf for a fee. #### Are batteries inside equipment counted twice? **Answer:** Often they are reported under both streams, because the equipment falls under WEEE and the battery under battery rules. The details depend on the country and on whether the battery is removable, so check the national guidance. #### How do I get weight data? **Answer:** Use the net unit weight from your item master, ideally verified by weighing a sample. If the ERP only holds gross shipping weight, you will overstate tonnage. Cleaning up weights is usually the first step in getting a reliable report. ## Search terms weee registration tracker, battery producer registration worksheet, epr registration tracker excel, extended producer responsibility tracker, weee reporting template, weee tonnage report worksheet, battery regulation producer obligations --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json