Skip to content

Traceability Report Example: One Lot, on One Page

A traceability report example for one lot of a food product: what went into it, where it went, what's still on hand, and the sum that proves it's complete.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 20, 2026 · 6 min read

A traceability report is the answer to one question about one lot: where did it come from and where did it go? It has four sections. The lot: product, code, date, quantity made. What went into it: each ingredient and package, with its own lot, supplier and date received. Where it went: each customer, with the date and quantity. Still here: what's on the shelf, on hold, sampled or thrown away. Then one line that makes it trustworthy: shipped plus on hand plus the rest adds up to what was made. A buyer or inspector reads that last line first. Below is a full example for one batch of granola, how to read it, and a file.

The short version

  • One report, one lot.
  • Backward: every ingredient and package lot, with its supplier.
  • Forward: every customer, with date and quantity.
  • What hasn't left: on hand, held, sampled, destroyed.
  • It has to add up to what was made.
  • TaroStack produces this report for any lot, from the records you already keep. More below.

The example

A made-up granola maker. Suppliers and customers are invented.

The lot

Product Maple Pecan Granola, 12 oz pouch
Lot code MP-1012
Made October 12, 2026; best by January 10, 2027
Quantity One batch, 41.9 kg baked, 120 bags

What went into it

Ingredient or package Lot Supplier Received Used
Rolled oats OA-0930 Valley Mill Sep 30 18.9 kg
Maple syrup MS-0915 Northwoods Sugarhouse Sep 15 7.2 kg
Pecans PC-1002 Southern Nut Co. Oct 2 5.4 kg
Almonds, sliced AL-0921 Western Almond Sep 21 3.6 kg
Coconut oil CO-0818 Pacific Oils Aug 18 4.5 kg
Pouches, 12 oz PK-0705 Summit Packaging Jul 5 120
Labels, Maple Pecan LB-0902 Print run Sep 2 120

Where it went

Customer Order Date Quantity
Northside Co-op 1188 Oct 14 36 bags
Canyon Coffee 1191 Oct 15 24 bags
Saturday market Over the counter Oct 17 and 24 31 bags
Online orders 22 orders, list attached Oct 13 to Nov 2 18 bags

Still here

Where Quantity
On the shelf Stock room, shelf B2 8 bags
Samples and damaged 2 retained samples; 1 torn at packing 3 bags

Accounted for: 109 shipped + 8 on hand + 3 samples and damaged = 120 made. 100%.

How to read it

Backward is one step, to the supplier's lot. The report doesn't say which farm grew the oats. It says they were lot OA-0930 from Valley Mill, received September 30. Valley Mill's own records take it from there. That's the "one up" half of one up, one back traceability.

Packaging is on it. Pouches and labels have lots too. If a label print run left an allergen off, the label lot is how you find every batch it went on.

Forward is to the first customer. Northside Co-op got 36 bags on October 14. Who bought them from the co-op is the co-op's to know.

The market line is honest. Thirty-one bags went over a counter to people with no names. The report says so. That's better than pretending, and it tells the reader a public notice would be needed for those.

The sum. If it came to 114 of 120, six bags are somewhere nobody recorded: eaten by staff, given away, short filled. A report that doesn't add up isn't finished.

The same report, starting from an ingredient

Run it from the almonds and the first section changes. "What went into it" becomes "what it went into":

Almonds AL-0921, 12 kg received Batch Used
Maple Pecan Granola MP-0928 2.9 kg
Maple Pecan Granola MP-1012 3.6 kg
Honey Nut Granola HN-1015 2.2 kg
Still in the bin 3.3 kg

Then each of those batches gets its own "where it went". This is the direction a supplier's recall takes, and it's the harder one, because it fans out.

What makes the report possible

Four habits, each on a different piece of paper:

Habit Where it's recorded
The supplier's lot written down at receiving Receiving log
The lot of every ingredient written on the batch sheet Batch record
A lot code on every package The package
The lot code on every packing slip or invoice Sales records

Miss one and a section of the report is blank. The codes themselves are covered in how to create lot numbers, and what a buyer is really asking for in what buyers mean by lot tracking.

Get the example

Download the traceability report example. The report above as a sheet to type over, section by section, with a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A spreadsheet to keep the underlying records in is lot tracking spreadsheet, and a timed rehearsal of producing the report is in mock recall flow chart.

Where this stops working

The buyer wants it by end of day. Building this page by hand means the batch binder for the ingredients, the receiving log for the suppliers, three weeks of invoices for the customers, an export from the online shop, and a walk to shelf B2. For one lot that's an afternoon. If the question is about the almonds, it's three lots and three afternoons.

How TaroStack does it

In TaroStack this page isn't built. It's read.

Receiving records the supplier's lot and dates for every delivery.

Each batch notes the lots it consumed, automatically, as you record it. Nobody copies lot numbers onto a batch sheet.

Each order records the lot shipped, so the customers come with dates and quantities.

The lot's page shows both directions. What went into it, what it went into, where it is now, and who got it.

The recall report puts it on paper or in one file: which supplier lots went into which batches, which customers got them, what's still on your shelves, and who to call.

Section By hand In TaroStack
What went into it Batch binder and receiving log On the batch record
Where it went Invoices and an export Orders, by lot
Still here Walk to the shelf Stock on hand, by lot
Does it add up? A sum Made, shipped, on hand

Lots, batches and the recall report are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What is a traceability report?

A record for one lot showing what went into it, where it went, and what's still on hand, with quantities that add up to what was made.

What should a traceability report include?

The product, lot code and quantity; each ingredient and package lot with its supplier; each customer with date and quantity; and stock still on hand, sampled or destroyed.

How far back does a traceability report go?

One step: to the supplier's lot for each ingredient. The supplier's own records continue the trail.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.