MANNIN SYSTEMS

Mannin Systems / Free templates

Free batch traceability log for Excel

Link every supplier batch to the jobs it went into and the customers who received the result, then trace any batch forwards or backwards in seconds.

For any factory. No sign-up and no email address needed. Works in Excel, Google Sheets and LibreOffice.

The Trace tab of the free batch traceability log template, filled in with example data
The Trace tab, with the example data it comes with. Blue cells are for typing; grey cells calculate.

What’s inside

Start Here
What it does, how to use it, and the key to which cells to type in.
Trace
Type a finished lot to see its materials, supplier batches, certificates and customers, or a supplier lot to see everywhere it went.
Goods In
Every delivery with your lot number, the supplier’s batch or heat number, and the certificate reference. Stock remaining calculates automatically.
Production
One row per material lot used on each job, against the finished lot number.
Dispatch
Which finished lot went to which customer, on which order and delivery note.

How to use it

  1. Give every delivery its own lot number in Goods In, with the supplier’s batch number and cert.

  2. For each job, record the material lots used against the finished lot number.

  3. Record every dispatch against its finished lot.

  4. When a question comes in, type the lot into the Trace tab.

Tracing forwards and backwards

Traceability means answering two questions quickly. Backwards: a customer reports a problem, so what went into their batch and where did it come from? Forwards: a supplier tells you a batch was faulty, so which of your jobs used it and which customers have them?

This log answers both from the Trace tab. Everything hangs on lot numbers: one for every delivery you receive, and one for every batch you make.

Tips for traceability that holds up

  • Number every delivery as it arrives, and write the number on the material itself.
  • Keep the supplier’s batch or heat number and cert reference alongside your own lot number; auditors will ask for them.
  • Record material by lot at the point of use, not at the end of the week from memory.
  • Test it: pick a finished batch at random and time how long it takes to trace. That’s your mock recall.

When the spreadsheet stops being enough

Mannin Systems does all of this as part of the day’s work: booked at the station as it happens, checked automatically, and linked to the jobs, stock and people involved. No retyping, and no Friday afternoon catching up.

Trace a batch in the demo

Questions about this template

Will this make us ISO 9001 compliant?

It gives you the traceability records auditors ask for, but compliance depends on your whole quality system. Use it as part of your procedures, not instead of them.

What if a job uses several material lots?

Add one Production row per material lot, all with the same finished lot number. The Trace tab lists them all.

Does it work in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets. It also works in Excel and LibreOffice.

Tell us what you're running on now

A few lines about what you make and how you plan production today is plenty to start with, or simply ask for an introductory call. You'll get a personal reply.