Anatomy of a filing-ready EPR package

Illustrative example based on observed patterns: “We’re basically done. It is all in the spreadsheet.”

Open that file and the pattern repeats. Hundreds of SKUs with no component tare weights. Three names for the same corrugated box. No record of which spec matches the current run.

While an internal spreadsheet is a natural place to begin, it rarely satisfies the standards of an audit-ready compliance filing. Under extended producer responsibility programs in California, Oregon, and Colorado, an authorized officer or manager must certify the numbers uploaded to the producer responsibility organization (PRO). If an agency or auditor questions the submission, the company needs to demonstrate the verified documentary trail behind each reported gram.

A filing-ready package bridges that gap. It transforms scattered product catalogs, supplier spec sheets, and shipment records into an auditable dataset organized around nine specific artifacts, dual reconciliations, and formal client sign-off.

The nine artifacts

1. Normalized packaging bill of materials: One master row per separable component per packaging configuration. Component tare weights are documented in grams, accompanied by source evidence citations and confidence ratings. Illustrative: 300 SKUs collapsed to 11 builds in the synthetic demo. Your count depends on shared boxes.

2. State-specific scope & producer assumptions: A formal record of reporting entities, distribution channels, and statutory exclusions, reviewed and confirmed by your team or legal counsel. We document every assumption with an assigned owner and review date.

3. Multi-state category mappings: Each component mapped to applicable reporting categories in California, Oregon, and Colorado. Mappings account for physical form, barrier laminates, resin types, closures, and product uses, with primary statutory citations and schedule versions recorded on every row.

4. State-supply aggregation: Annual sales volumes broken down by destination state and distribution channel, tied directly to warehouse extracts and sales reports with extraction dates documented. Returns, promotional samples, and e-commerce shipping materials are accounted for systematically.

5. Sourced fee estimates: Calculations derived from published state fee schedules. Every figure carries its regulatory status. Approved and in-force, or provisional planning range. Leadership sees which numbers are firm and which remain illustrative.

6. Unresolved exposure register: A central tracking log for any missing vendor specifications, conflicting tare weights, or unconfirmed sales channels. Every open item is assigned to a specific owner (client operations, legal counsel, or supplier) with target resolution dates.

7. Draft portal upload workbook: A populated workbook structured to match the active Circular Action Alliance portal template, properly maintaining the distinction between data reporting years and program payment years.

8. Client certification record: A formal sign-off package verifying that entities, volumes, assumptions, and exclusions are complete and accurate to the company’s knowledge. Reports are only finalized for portal upload after your leadership reviews and approves this dossier.

9. Evidence archive & change log: A secure repository where original supplier PDFs, drawings, and scale calibration logs are preserved with cryptographic hashes. Schedule changes and data revisions are tracked with clear version histories rather than editing past numbers in place.

The two reconciliations (both must tie)

Before any workbook is presented for internal review, it must clear two independent mathematical checks:

• Mass reconciliation: Total shipped product units multiplied by individual component tare weights must tie out exactly to aggregate reported category weights. If the numbers do not reconcile, we isolate the discrepancy and update the underlying records before proceeding.

• Commercial reconciliation: Reported state shipment figures are cross-checked against 3PL warehouse fulfillment logs, regional retail sales reports, returns logs, and packaging purchase orders to confirm that sales channels have been captured accurately.

In addition to these checks, we conduct secondary verification on the top five components by mass, the top five by fee impact, any manual category overrides, and all low-confidence items. This secondary review ensures that high-impact classifications receive appropriate scrutiny.

The acceptance rule

A package is ready for sign-off only when every SKU maps to a packaging configuration, every component has a tare weight and material classification, and counsel has reviewed the legal questions.

Missing or conflicting items remain open in the unresolved register until documented and approved. In packaging compliance, an honest “unavailable” backed by a transparent documentation trail is far more defensible than an unsubstantiated guess.

Where our scope ends

Producer Ledger specializes in packaging data engineering, inventory assembly, and mathematical reconciliation. We do not provide formal legal opinions on statutory producer status, nor do we make unilateral determinations regarding legal exemptions — those matters belong with your qualified legal counsel.

If your supplier documentation is incomplete, we will not guess or fabricate numbers to force a deadline. Instead, we clearly outline what is missing, explain how it impacts your fee calculations, and provide structured technical request templates so your procurement team can gather the required facts from vendors.

Messy data is the normal start. A diagnostic separates what is documented from what still needs gathering.

Sources (primary)

• CAA producer reporting (data year / report date / payment date / program year model, portal submission) — https://circularactionalliance.org/producer-reporting — retrieved 2026-09-22
• CAA Producer Resource Center (2026 planning tables, all-state May 31 matrix) — https://circularactionalliance.org/producer-resource-center — retrieved 2026-09-22
• CAA producer policies (registration, reporting, payment, delinquency, good standing) — https://circularactionalliance.org/producer-policies — retrieved 2026-09-22
• CAA registration (account form, PPA, state addenda, portal access) — https://circularactionalliance.org/registration — retrieved 2026-09-22
• CalRecycle producer guidance + PEPRS (via-PRO vs. self-report, source reduction) — https://calrecycle.ca.gov/packaging/packaging-epr/producerguidance/ — retrieved 2026-09-22
• CalRecycle covered material categories list (material type × form taxonomy, Jan 2026) — https://calrecycle.ca.gov/packaging/packaging-epr/cmclist/ — retrieved 2026-09-22

Data and compliance support only — not legal advice. Sources retrieved 2026-09-22. Recheck CAA portal templates if they change. If your records live across spreadsheets, request a 20-minute fit check at alex@producerledger.com with your SKU count and one sample spec.