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.
