Manual vs Automated Packaging Tracking for EPR

Table of Contents

• The Tracking Challenge
• Manual Tracking (Spreadsheets)
• Automated Tracking (Software)
• When to Switch from Manual to Automated
• ROI of Automation
• Key Takeaways

---

Key Takeaways

• Manual spreadsheet tracking works for businesses with under 100 SKUs and simple packaging profiles.
• Automated systems pay for themselves when you exceed 200+ SKUs or have complex multi-material, multi-site operations.
• The main risk with manual tracking is human error — incorrect formulae, missed updates, and data entry mistakes cost money.
• Automation delivers accuracy, time savings, and audit readiness that spreadsheets cannot match at scale.
• Start manual, then upgrade — there is no need to invest in software before you understand your compliance requirements.

---

The Tracking Challenge

EPR compliance requires you to track packaging data continuously: materials, weights, volumes, categories, and nation splits. This data must be accurate, up-to-date, and submission-ready at each reporting deadline.

The fundamental question is whether to manage this in spreadsheets or invest in dedicated software.

For background on data collection, see how to set up packaging data collection.

Manual Tracking (Spreadsheets)

How It Works

• Create a master spreadsheet with packaging specifications
• Manually enter sales volumes each reporting period
• Use formulae to calculate tonnage per material
• Export data for RPD submission

Advantages

• Zero cost (using Excel or Google Sheets)
• Flexible — customise to your exact needs
• Quick to set up — start immediately
• No software training — most people know spreadsheets
• Full visibility — you can see every calculation

Disadvantages

• Error-prone — manual data entry leads to mistakes
• Time-consuming — at scale, updating takes hours
• No version control — easy to overwrite data
• No audit trail — hard to prove data integrity
• Formula breakage — one broken formula can cascade errors
• Difficult to scale — complexity grows exponentially with SKUs

When Manual Works Well

• Fewer than 100 SKUs
• Simple packaging (1-3 materials per product)
• Single site/warehouse
• Small producer (annual reporting only)
• One person managing compliance

Automated Tracking (Software)

How It Works

• Central database of packaging specifications
• Automatic import of sales/dispatch data from ERP
• Automatic tonnage calculation and material classification
• One-click generation of RPD submission files
• Dashboard with real-time compliance status

Advantages

• Accuracy — calculations are automated and consistent
• Time savings — hours of manual work eliminated
• Audit trail — every change is logged and traceable
• Scalability — handles thousands of SKUs without extra effort
• Error detection — built-in validation catches mistakes
• Fee modelling — scenario planning for packaging changes

Disadvantages

• Cost — £1,000-£10,000+ per year
• Setup time — initial data migration and configuration
• Learning curve — staff need training
• Dependency — you rely on the software provider
• Over-engineering — may be more than small businesses need

When Automation Pays Off

• 200+ SKUs
• Complex packaging (multi-material, multi-component)
• Multiple sites or warehouses
• Large producer (six-monthly reporting, nation data)
• Multiple people contributing data
• Frequent packaging changes

When to Switch from Manual to Automated

Signals That You Have Outgrown Spreadsheets

1. Submission preparation takes more than 2 days per reporting period
2. You have found errors in past submissions after the fact
3. Packaging changes are not being captured in a timely manner
4. Multiple people edit the spreadsheet and version conflicts occur
5. An auditor questioned your data integrity
6. Your SKU count has exceeded 200 and is growing
7. You are now a large producer with nation data requirements

Transition Approach

1. Keep your spreadsheet running during the transition
2. Set up the new system and import your existing data
3. Run both in parallel for one reporting period
4. Compare outputs — the automated system should match your manual calculations
5. Switch over once you are confident in the new system

ROI of Automation

Time Savings

Task	Manual (hours/year)	Automated (hours/year)	Saving
Data entry	40-80	5-10	75-90%
Tonnage calculation	10-20	1-2	80-90%
RPD file preparation	8-16	1-2	85-90%
Audit preparation	16-24	4-8	60-75%
Total	74-140	11-22	~80%

Error Reduction

Studies show manual data entry has a 1-3% error rate. For a business reporting 500 data points, that is 5-15 errors per submission. Each error could mean over-reporting (overpaying) or under-reporting (penalty risk).

Financial Impact

Factor	Value
Staff time saved (80 hours x £30/hour)	£2,400
Error cost avoided (estimated)	£1,000-£5,000
Total annual benefit	£3,400-£7,400
Typical software cost	£2,000-£5,000
Net ROI	Positive for most medium businesses

Getting Started

1. Assess your current tracking — is it working or struggling?
2. Count your SKUs and complexity — use the thresholds above
3. If staying manual, optimise your spreadsheet using best practices
4. If upgrading, evaluate EPR compliance software options
5. Plan a parallel run to validate the new system

Use the EPR fee calculator and visit our pricing page for compliance tools.