End-to-end traceability without spreadsheets

ISO 9001:2015 clause 8.5.2 requires identifying process outputs and their inspection status where needed. Regulated sectors (automotive, pharma, food, medical) add lot-by-lot traceability requirements. Excel is still common in SMBs, but it no longer scales or passes a serious audit.

What clause 8.5.2 actually requires

Three auditable elements:

• Identify appropriate outputs to ensure conformity
• Identify status (released, pending, nonconforming) throughout the process
• When traceability is required, control it and keep documented information

Traceability levels

Four levels by regulation or customer:

1. Basic identification. Knowing what product it is. Applicable for simple products with no regulatory requirements.
2. Lot-level traceability. Knowing which lot each unit belongs to. Standard in manufacturing.
3. Unit traceability (serialization). Each piece has a unique ID. Required in Tier 1 automotive, pharma and medical devices.
4. Full forward and backward traceability. From raw material to end customer with every intermediate process documented. Required in FSSC 22000, GMP pharma.

Why Excel fails starting at level 2

Three concrete problems:

• Error-prone manual entry. An operator getting 1 in 1000 lots wrong produces one traceability incident per year in typical operations.
• Sync issues. Two people editing at once break the file.
• Slow search. A customer claim requiring tracing a lot across 5 processes can take days in Excel.

Alternatives that work

Three paths by budget:

ERP with traceability module. SAP, Odoo, Tantia and others have native modules. Medium-high cost but integrates with the rest of the business.

Dedicated MES. If the ERP doesn't cover manufacturing, a specialized MES (Rockwell FactoryTalk, Siemens Opcenter, or SaaS platforms) captures each event.

Lightweight platform with barcodes/QR. For small SMBs, a mobile app with code scanning and simple backend solves it without SAP-level cost.

Traceability indicators

Two useful KPIs for the QMS:

• Claim response time with traceability: hours or days becomes minutes with a real system
• Traceability coverage: percentage of lots with full documented traceability

Both should be in the management review when the sector requires it.

Recall: the fire test

A quarterly simulated recall exercise reveals real traceability. Pick a random lot from 6 months ago and ask to identify: receiving customer, raw materials used, processing operators, equipment involved. If it takes more than 30 minutes, the system doesn't work.

What to do this week

If your sector requires lot-by-lot traceability and you still use Excel, run a simulated recall on Friday. The results convince the CEO more than any presentation. Migrating to a real system takes 2 to 4 months and the ROI shows up with the first demanding customer.