Automate EPR reporting instead of managing Excel chaos

EPR reporting describes the process by which companies collect, verify, calculate, and report EPR-relevant data on products, quantities, materials, packaging, batteries, or equipment to the relevant registers, authorities, producer responsibility organizations (PROs), take-back systems, or compliance partners. EPR stands for Extended Producer Responsibility. The starting point is generally the products and quantities placed on the market. Depending on the product stream, the relevant material, packaging, battery, or equipment information is then derived. The reports often form the basis for EPR fees, registrations, take-back obligations, financial contributions, and documentation requirements.

EPR reporting affects companies that place EPR-relevant products, packaging, electrical and electronic equipment, batteries, textiles or other regulated product flows on the market. Depending on the country and sales channel, these include manufacturers, importers, retailers, distributors, marketplace players, fulfillment structures or e-commerce companies. Within a company, the following areas are usually involved in the processes relating to EPR reporting, quantity notifications, registrations and verifications:

• Legal

• Compliance

• Finance, Controlling

• Sustainability

• Operations

• Supply Chain

• IT

• Product management

• Purchasing and local country organizations

Differentiation between EPR compliance and EPR reporting
EPR compliance describes whether a company correctly fulfills its obligations under extended producer responsibility. This includes, for example, registration, system participation, take-back, financing, deadlines, evidence and communication with authorities.

EPR reporting describes the data process behind it: Which products were placed on the market in which countries? Which quantities, materials, packaging, batteries or device types are relevant? What data needs to be reported, calculated, checked and documented?

The difference is essential: compliance is the goal. Reporting is the basis for reliably achieving this goal. Without proper EPR reporting, EPR compliance remains blurred. Companies only know that they have obligations. However, they cannot reliably prove which quantities were reported, why charges were incurred, which database was used and whether reports are complete, correct and auditable. EPR reporting therefore makes compliance controllable: it combines product, quantity, material, registration and process data into a traceable basis for reporting, costs, evidence and risk assessment.

Typical data for EPR reporting include

• Product numbers and product categories

• Countries, companies and sales channels

• Sales volumes and quantities placed on the market

• Packaging types, material types and material weights

• Battery types, chemical systems and installation contexts

• Device types, WEEE categories and usage contexts

• Supplier data and material information

• Registration numbers, EPR numbers, WEEE numbers or LUCID data

• Reporting periods, deadlines and fee logic

• Evidence, approvals and audit trails

For audit-capable reporting, it is not enough to collect this data once. Companies must also document the source of the data, which calculation logic was used, which version was valid and who checked or approved the report.

EPR reporting cannot be automated by digitally moving Excel files or transferring existing workarounds to a new tool. The prerequisite is a clean data and process architecture.

The first step is to define a leading system for each relevant data type. Product data, quantities, material information, packaging data, battery data, device classifications, countries, companies, sales channels, registrations and deadlines must each have a clear origin. This is the only way to determine which source is binding for which information. Based on this, the data sources are structured in such a way that they can be logically merged. Products must be consistently linked to quantities, materials, packaging, batteries, device types, countries, companies and sales channels. It is not only crucial that data is available, but that it fits together and can be logically linked correctly.

Only when this basis is in place can EPR-relevant data be automatically transferred to ForSURE. ForSURE processes this data further, maps country-specific categories, reporting formats, deadlines, fee logic and compliance status and prepares the information for reporting, verification and submission. Automation therefore does not mean digitizing an inadequate process. It means setting up company data in such a way that regulatory requirements can be mapped in a repeatable, auditable and scalable way.

A resilient automation approach therefore includes:

• Definition of a system of record for each relevant data type

• Cleansing and harmonization of product, quantity, material, packaging, battery and device data

• Development of a logical data model for merging by product, country, company, sales channel and product flow

• Validation of data before transfer to ForSURE

• Automated transfer of structured EPR data to ForSURE

• Application of country-specific reporting, fee and compliance logic in ForSURE

• Documented releases, versioning and audit trails

• Feedback of errors, deviations and findings into the internal data and process structures

The result is not a digitized Excel process, but a resilient EPR operating model: internal data sources provide consistent information, ForSURE processes it according to the respective local requirements. The company retains control over data quality, obligations, deadlines, costs and evidence.

The first step is not automation, but transparency. Companies must first understand which EPR obligations actually exist, which registrations are in place, which data is used, who makes decisions and where manual rework is currently carried out. This involves systematically recording countries, companies, product flows, registrations, reporting processes, data sources, agencies, fees, deadlines, workarounds and risks.

The decisive factor is not only whether reports are submitted. The decisive factor is whether the company can explain the data basis used for reporting, why certain fees are incurred, which assumptions were used and whether registrations, deadlines and evidence are fully checked.

A company should be able to answer at least these questions:

• Which countries, companies and product flows are affected?

• Which registrations, EPR numbers, WEEE numbers or other proofs are already available?

• Which data sources are leading for products, quantities, materials, packaging, batteries, device types and registrations?

• Where do manual work, Excel workarounds or media breaks occur today?

• Which deadlines, portals, PROs, take-back systems or agencies are involved?

• Where do the highest fees or contributions arise?

• Which costs can be clearly attributed to countries, product groups, materials, packaging or business units?

• Where is there a risk of overreporting or underreporting?

• Who checks, corrects and releases reports?

• Which messages must be auditable and reproducible?

• Which service providers deliver genuine transparency and where do black box dependencies arise?

• Which product, material, battery or packaging decisions influence EPR costs?

• Which processes need to be stabilized or rebuilt before automation makes sense?

These answers show where to start first: with the determination of obligations, with registrations, with the data model, with responsibilities, with service provider control, with process logic or with automation.

In some cases, a clearly defined pilot may make sense, for example for a country, a product flow or a particularly cost- or risk-relevant data flow. In other cases, the basic process must first be rebuilt before automation can take effect.

The aim is not another special EPR project, but a resilient operating model: clear data sources, traceable decisions, controlled service providers, auditable reports and a process that can scale with additional countries, companies and product flows.

Excel is not a reliable operating system for EPR reporting. It is the typical place where data from ERP, PIM, PLM, store systems, supplier sources, agency templates and country portals are manually thrown together. This is precisely the problem: as soon as EPR data is copied, reformatted, overwritten, supplemented or forwarded by email, the company loses control over data origin, versions, assumptions, calculations and approvals. Manual tables create media breaks, shadow logic, version conflicts and dependence on individual knowledge. In the end, often only one person knows which file is current, which column has been adjusted and why a certain quantity has been reported.

Excel may work for a one-off ad hoc problem. It is structurally unsuitable for recurring, international and auditable EPR reporting. The more countries, product flows, materials, deadlines, registers, PROs, take-back systems and agencies are involved, the greater the loss of control. The effort not only increases, it shifts to manual coordination, troubleshooting and subsequent reconstruction. With today’s technical possibilities, permanent EPR reporting in Excel is no longer a pragmatic solution, but a sign that the data model, process logic and system integration are missing. Clean automation replaces this manual throwing together with a repeatable process: data sources are connected, rules are versioned, checks are documented, approvals are made traceable and reports are prepared on a reliable basis.

The result is not just less effort. Above all, it is more control over data, obligations, costs, risks and evidence.

Automating EPR reporting is not only worthwhile once a company reaches a certain size. Manual processes with hand-drafted reports are generally prone to errors, additional work and loss of control in the case of recurring, country-specific and audit-relevant reporting obligations.

It becomes particularly critical if one or more of the following points apply:

• Notifications are made in several countries or for several product categories.
• EPR-relevant data is distributed across ERP, PIM, PLM, store systems, Excel files and supplier sources without centralized data governance.
• Reporting regularly leads to peak loads before deadlines and depends on a small number of employees.
• Fees increase without the cost drivers being clearly comprehensible or the pricing logic being known.
• Overreporting or underreporting cannot be ruled out with certainty.
• Registration status, deadlines cannot be tracked ad-hoc.
• The check for compliance with all requirements for proper market access is not recorded in a structured manner.
• Agencies or compliance service providers are involved, but internal data preparation remains time-consuming.
• There are no parameters for monitoring the work of the service providers.
• Product development, packaging design or purchasing take EPR costs into account too late, if at all.
• Inquiries from authorities, PROs, auditors or internal control functions can only be answered with manual research and a lot of lead time.

The more of these points apply, the greater the effort involved and, in particular, the greater the risk that companies will misjudge EPR obligations, fail to manage fees, miss deadlines or be unable to track notifications at a later date.

Auditability is achieved through a traceable data and process chain.

Each EPR message should be able to explain later:

• which data was used

• from which systems this data originates

• which version was valid

• which calculation logic was used

• which assumptions were made

• who has checked

• when the release took place

• what was actually reported

Versioned rules, documented corrections, clear roles, plausibility checks, approval workflows and an audit trail are also important.

Summarized

EPR reporting is auditable if a report can later be reproduced and explained to authorities, PROs, auditors, investors or management in a comprehensible manner without major effort.

Bordmittel® is the implementation and integration partner for EPR automation and translates regulatory requirements into resilient data flows, system connections, roles, controls and control processes.

The focus is not on additional reporting, but on operationally integrating EPR into customer systems such as ERP, PIM, store and CRM systems. Bordmittel® takes care of the methodical inventory, identifies manual workarounds and decides which tasks should be solved by ForSURE, DeZeTo® or compliance agencies.

Learn more about Bordmittel®

The main benefits of Bordmittel® are

EPR operating model

Define systems, data flows, roles, responsibilities, approvals and escalation paths.

System integration

Connect customer systems and make them EPR-reportable.

Data quality & control logics

Single source of truth, validation logics, plausibility checks, error lists and checkpoints.

DeZeTo® is the structuring and optimization partner for EPR-relevant product, material and value stream logics.

DeZeTo® comes into play when EPR costs, data quality or compliance risks arise not only from reporting processes, but also from product structures, variant diversity, packaging design, material data, supply chains or go-to-market decisions. The focus is not on managing EPR retrospectively, but on anchoring it early on in product development, purchasing, packaging design and portfolio decisions.

Learn more about DeZeTo®

The main services of DeZeTo® are:

Product & variant logic

Structure and standardize product definitions, modules, parts lists, variant and configuration logics and reduce unnecessary variant, material, packaging and process complexity.

Material & sustainability data architecture

Develop robust data architectures for product, material, packaging and sustainability information.

EPR readiness by design

Integrate EPR requirements into product development, packaging design, purchasing and go-to-market processes.

Supplier & partner data logic

Structure supplier and partner data, responsibilities and data requirements along the supply chain.

ForSure provides a platform for EPR reporting, fee logic, compliance status and operational control for companies that no longer want to manage their producer responsibility manually via Excel, local special processes and scattered data. In particular, the platform supports retailers, e-commerce companies, importers and manufacturers in fulfilling EPR obligations for packaging, WEEE, batteries and textiles in an automated, auditable and scalable way.

Learn more about ForSURE

The main advantages of using ForSURE are:

Automated reporting

Create and validate EPR notifications automatically and prepare them for authorities, PROs or agencies.

Regulatory country logic

Map country-specific obligations, categories, deadlines, registrations and reporting logics centrally.

Data integration

Merge product, material, quantity and packaging data from source systems and make it reportable.

EPR control & analysis

Make fees, deviations, cost anomalies, savings potential, countries, materials and compliance status controllable.

Compliance agencies are involved where EPR obligations cannot be solved by software, integration or process optimization alone. This applies in particular to national registrations, local formal obligations, special regulatory cases, communication with authorities, technical audits and final notification submissions.

ForSURE, Bordmittel® and DeZeTo® support the client in selecting the right agency and integrating it neatly into the overall model. The aim is not to create additional dependency or unnecessary consulting costs, but to find an agency that delivers genuine local expertise, works in a cleanly documented manner and reliably closes the gap between system, process, value stream and national implementation.

Clear selection criteria, defined handovers and verifiable quality standards are needed precisely because agency services vary greatly. This prevents customers from paying for non-transparent, manual or poorly documented services without actually gaining more compliance security.

Learn more about compliance agencies

The main services provided by compliance agencies are

Registration, verification & submission

Registration with national registers, authorities, PROs or systems and support with local formalities. Checking, release support and final submission of EPR notifications.

Regulatory classification

Technical assessment of national requirements, special cases, quantity definitions, roles and reporting obligations.

Authorities & PRO communication

Communication with authorities, registers, PROs and national system operators.

Verification & audit support

Support with verifications, queries, checks, corrections and local documentation requirements.

An EPR number is a registration, identification or verification number that shows in certain countries or systems that a company is registered for an area subject to EPR. Which number is required depends on the country, the product group and the market role. Examples are registration numbers in the context of packaging, WEEE, batteries or national EPR registers. An EPR number does not replace reporting. It is usually only part of the overall EPR compliance.

WEEE stands for Waste Electrical and Electronic Equipment. In the EU, the WEEE Directive 2012/19/EU forms the regulatory framework for waste electrical and electronic equipment. In Germany, this directive is transposed into national law by the ElektroG. For companies, this means that before placing electrical and electronic equipment on the market, it must be checked which type of equipment, brand, manufacturer role, registration, quantity notification, take-back, financing or verification obligation applies in the respective country.

In Germany, Stiftung ear is the competent body for central enforcement tasks under the ElektroG. These include, in particular, the registration of manufacturers, the allocation of WEEE registration numbers, the receipt of quantity notifications, the maintenance of the list of manufacturers and the coordination of certain manufacturer obligations. Stiftung ear also plays a central role in coordinating the collection of waste electrical and electronic equipment. Based on the reported quantities and market shares, it issues, among other things, collection and provision orders to obligated producers. They must then collect the waste electrical and electronic equipment collected from public waste management authorities and dispose of it properly.

The financial guarantee is also relevant for B2C devices. Manufacturers must provide proof of insolvency-proof financing for the subsequent take-back and disposal of certain electrical appliances. This proof is also relevant in the registration and compliance process vis-à-vis Stiftung ear. In EPR reporting, companies therefore not only have to report quantities of appliances. They must also clearly record and consistently document device types, brands, registration numbers, sales channels, B2C/B2B allocations, warranty requirements, take-back obligations, reporting periods and evidence. The challenge lies in cleanly linking the operational ElektroG logic in Germany – registration, quantity reporting, financial guarantee, collection coordination and verification management – with product, quantity, sales and master data in the company.

Batteries have their own EPR obligations and are not automatically covered by WEEE or electrical equipment obligations. At European level, the EU Battery Regulation (EU) 2023/1542 forms the central legal framework for batteries and waste batteries. Among other things, it regulates requirements for:

• Sustainability

• Labeling

• Duties of care

• Collection

• Treatment and utilization.

In Germany, the previous Batteries Act (BattG) was replaced by the Batterierecht-Durchführungsgesetz (BattDG). The BattDG supplements the directly applicable EU Battery Regulation and creates national regulations for enforcement, registration, take-back organization and other operational obligations.

The decisive factor for EPR reporting is how a battery is classified in regulatory terms.

For example as:

• Device battery

• Battery for light transportation

• Starter battery

• Industrial battery or electric vehicle battery.

The distinction to WEEE is important: For electrical appliances, the focus is on the classification of the appliance. In the case of batteries, the focus is on the battery itself as a separate regulated product stream. A product can therefore be subject to WEEE and trigger separate battery obligations at the same time.

A compliance agency can be useful if local registration, regulatory interpretation, communication with authorities, formal submission or special national cases require special expertise. Especially in international EPR structures, local support can be crucial. Many countries have their own registers, portals, PROs, deadlines, documentation requirements and formal processes. Without local experience, it is often difficult to implement these requirements efficiently.

However, it becomes critical when companies effectively outsource responsibility to external service providers without retaining control over data, decisions and costs themselves. An agency cannot replace a clean database, internal management capability and clear responsibility.

Choosing the wrong agency can create significant risks:

• Unnecessary or incorrectly prioritized registrations

• Excessive or difficult to understand service fees

• non-transparent fee and PRO structures

• Inadequate documentation of acceptances, notifications and approvals

• Lack of traceability of the data submitted

• late or incomplete reports

• Dependence on individuals or local service providers

• Switching providers is made more difficult because the knowledge and documents are not handed over properly

• Additional coordination loops are created instead of real relief

• Black box costs without a reliable basis for decision-making

Service providers who do not reduce regulatory complexity but use it as a business model are particularly problematic. The company then pays for supposed security, but loses transparency regarding obligations, data, deadlines, fees and evidence. The liability still remains with the obligated company. If registrations are missing, quantities are reported incorrectly, deadlines are missed or evidence cannot be provided, it is usually not the agency that bears the actual risk, but the manufacturer, importer, distributor or marketer.

Compliance agencies should therefore not be integrated as a black box. They should be integrated into a clear data, review and approval process. Data sources, assumptions, fee logic, registrations, reports and deadlines must remain transparent for the company. When properly integrated, agencies reduce local implementation risks. Incorrectly selected or poorly managed, they increase costs, dependency and compliance and liability risks.

In Europe, EPR obligations arise from different legal acts, national implementation systems and country-specific requirements.

Packaging, WEEE, batteries and textiles do not follow the same regulatory mechanics:

• For packaging, Regulation (EU) 2025/40 on packaging and packaging waste establishes the new European framework. It replaces the previous Packaging Directive 94/62/EC. 89

• For electrical and electronic equipment, the WEEE Directive 2012/19/EU provides the European framework, which is implemented at national level, for example in Germany through the Electrical and Electronic Equipment Act (ElektroG). 12

• For batteries, Regulation (EU) 2023/1542 serves as the central European legal framework. In Germany, the Battery Act (BattDG) complements this framework at the national level. 46

• For textiles, the revised Waste Framework Directive introduces mandatory EPR systems for textile and footwear products across the EU. 1011

The challenge lies in the fact that countries use different categories, reporting formats, deadlines, portals, fee models, definitions and operational systems.

Companies with several markets therefore need a cross-border EPR data model and clear process control.

Overreporting means that companies report more quantities, higher weights or incorrect material classes than are actually required. This not only results in excessively high EPR costs. Overreporting also leads to inconsistencies in the database. Reported quantities then no longer match sales figures, parts lists, material data, packaging data or inventories. Such inconsistencies often become apparent during audits, due diligence checks, internal reconciliations or cost analyses at the latest. Overreporting is therefore not a harmless safety margin. It is an indication that data, processes or classifications are not sufficiently controlled.

Important note
Just like underreporting, overreporting is a violation of applicable compliance guidelines.

Underreporting means that companies report insufficient quantities, incomplete product flows or incorrect material, country or role assignments. In the short term, this can result in lower fees. In the long term, however, compliance risks arise. Possible consequences include additional payments, correction costs, sanctions, sales stops, audit problems or reputational damage. Underreporting is often caused by unclear data sources, missing responsibilities, incorrect product classifications, manual workarounds or country and sales channels that are not taken into account.

Short answer: No. There is no central, EU-wide WEEE registration that is applied for once and is then automatically valid in all EU member states.

Although the WEEE Directive is a European directive, it is transposed into national law in each member state. In Germany, this is done via the Electrical and Electronic Equipment Act ( ElektroG).

In practice, this means that anyone selling electrical and electronic equipment in several EU countries must check for each destination country whether there is a registration, an authorized representative, quantity reports, take-back systems, fees or other national obligations.

Example:
A company sells an electric luminaire in Germany, France and Italy. A German WEEE registration with the EAR Foundation is not automatically sufficient for France or Italy. Each country has its own registers, deadlines, reporting formats, fee models and compliance requirements.

Why is this different from CE?
CE conformity refers to the product and its compliance with EU-wide safety, health or environmental requirements. WEEE compliance, on the other hand, relates to product responsibility under waste legislation, financing, take-back and disposal in the respective national waste management systems. These systems are not fully standardized across the EU.

EPR stands for Extended Producer Responsibility.

This refers to the principle that manufacturers are not only responsible for the production and sale of a product, but also for its subsequent collection, return, treatment, recycling and disposal.

In the area of electrical appliances, EPR means

• Manufacturers must register.
• Manufacturers must label their products correctly.
• Manufacturers must report quantities.
• Manufacturers must finance take-back and disposal structures.
• Manufacturers must ensure that waste electrical and electronic equipment is properly collected, treated and recycled.

The basic idea is that those who place products on the market should also take responsibility for the environmental consequences that arise at the end of the product’s life.

EPR is not only available for electrical appliances. Typical EPR areas include

• Electrical and electronic appliances
• Batteries and accumulators
• Packaging
• Other product groups in some cases, depending on the respective country and legal framework

The objectives of extended producer responsibility are in particular

• Waste avoidance
• Higher collection and recycling rates
• Conservation of resources
• Fair financing of disposal
• Avoidance of free riders
• Promotion of recycling-friendly product design

WEEE stands for Waste Electrical and Electronic Equipment.

The WEEE Directive 2012/19/EU is the central European basis for dealing with waste electrical and electronic equipment. It sets out requirements for the collection, return, treatment, recycling, recovery and financing of waste electrical and electronic equipment.

The WEEE Directive is based on the principle of producer responsibility. Manufacturers should ensure that electrical and electronic equipment does not end up in residual waste at the end of its life, but is collected separately, treated properly and recycled to the highest possible quality.

Why is WEEE important?

Waste electrical and electronic equipment is relevant for several reasons:

1. Growing volume of waste
   The volume of electrical and electronic waste has been rising sharply for years.
2. Valuable raw materials
   Electrical appliances contain metals, plastics and sometimes critical raw materials that can be recovered.
3. Hazardous substances
   Some old appliances contain substances that can harm the environment and health if disposed of incorrectly.
4. Circular economy
   Resources are conserved by reusing, repairing, recycling and recovering raw materials.
5. Consumer protection and transparency
   Consumers should know that old electrical appliances must be collected separately and not disposed of with household waste.

WEEE is therefore not just a disposal issue, but a central element of the circular economy.