Start free

Home › Blog › Articles

Free food traceability template in Excel, updated for 2026

Record suppliers, storage areas, ingredients and every raw material movement with its lot. Ready for pastry shops, bakeries, central kitchens and catering. No sign-up and no email required.

✓ Reviewed on November 19, 2026 Reading time: 5 min By the Recipok team
Free · no sign-up

Excel template

Tabs for suppliers, storage areas and ingredients, plus a movement sheet with lot, document and date. It also works in Google Sheets.

XLSTrazabilidad-de-la-materia-prima.xlsx
Raw material traceability · template in Spanish
Download the template ↓

What food traceability is and why it is mandatory

Traceability means being able to answer two questions for any lot: what was it made with? and who has it reached? If a supplier warns you that a lot of flour is contaminated, or a customer reports an allergic reaction, traceability is what lets you withdraw only what is affected, not the whole week's production.

The obligation comes from Article 18 of Regulation (EC) 178/2002: every food business must identify who supplies each food or ingredient to it and which businesses it supplies its products to, and keep that information available to the authorities. For food of animal origin, Implementing Regulation (EU) 931/2011 sets out the minimum data: product description, quantity, details of the sender and the recipient, lot reference and dispatch date.

The five links your records have to join

1SupplierName, food business registration
2Goods-inDelivery note, lot, expiry
3ProductionWhich lots were used
4ProductNew lot and date
5CustomerOutgoing delivery note

The two ends (supplier and customer) are the “one step back and one step forward” the rule requires. The middle is internal traceability: which raw material lot ended up in which product lot. It is the link that breaks most often and the first one an inspector looks at.

How the template works

The template follows raw materials from the moment they come in until they are used: where each ingredient comes from (its lot, its supplier and the supplier's registration and tax details), where it is stored and what it goes into. It has two parts: the general data tabs, which you fill in once, and the movement sheet, which you repeat every time something comes in or goes out.

First: fill in the general data

  • Suppliers: name, tax number, food business registration number and contact details for each one.
  • Storage areas: cold rooms, freezers, dry store. In the notes, the type of area and, if you have several premises, the address.
  • Ingredients: one per supplier and per pack size. The same flour from two mills counts as two ingredients, because their lots and their movements never mix.

Second: one sheet per movement

Every time raw material comes in or goes out, duplicate the last movement sheet you used and fill in the new one: supplier, document number (the delivery note), date and the source lots. The rest (ingredient, supplier details, storage area) is filled in from what you already have in the other tabs. Duplicating the last one means you reuse the work already done.

Third: get three details right

The date, the document number and the source lot exactly as it appears on the supplier's packaging. They are the three you will be asked for in an inspection and the only ones that cannot be rebuilt afterwards.

In Google Drive

If you would rather fill it in from your phone or share it with your team, upload the file to your Google Drive and open it as a Google spreadsheet. It works just the same.

What if someone asks you for a lot tomorrow?In Recipok traceability comes straight from goods-in, production orders and delivery notes. A lot is traced both ways in seconds.
Try it free

The missing link: production orders

The template records what comes in well. But to close the chain, every production order has to say which raw material lots were used and which product lot came out. And every sales delivery note has to say which product lot it carries. Without that, faced with a suspect lot you will know where the flour came from, but not which cakes it ended up in.

In Excel that link is manual: writing down on the production order the lot of every pack opened and cross-checking it later against the movement sheets. It works with a few products and becomes very heavy with many. If you are just starting to set up the system, follow our food traceability tutorial with a template.

What you will be asked for in an inspection

The acid test of any traceability system is one specific lot. The inspector, the auditor or your customer picks one and asks you to show its path:

  1. Backwards: which raw material lots that product came from and which suppliers supplied them, with their delivery notes.
  2. Forwards: which customers it went out to, when and in what quantity.
  3. The balance: how much was produced, how much was sold, how much is left in stock and how much was thrown away. If the numbers do not add up, the chain has a hole in it.

With the template, prepare that answer before you are asked: keep the movement sheets in date order, the production orders with their lots and the outgoing delivery notes in the same folder. The time it takes you to rebuild a lot is exactly the time it would take you to withdraw a product from the market if there were an alert.

Good practice to make the template work

  • Record on receipt, not at the end of the week. A lot written down from memory is a doubtful lot.
  • Label opened packs with their lot and the date opened, especially if you decant them into another container.
  • Write the real lot on the production order: the one on the pack you opened, not the first one on the list.
  • Reconcile stock from time to time with what the template says. If it does not match, a movement is missing.
  • Run a mock recall every so often: pick a lot and rebuild its path. We explain how in how to run a food traceability mock recall.

Template or software?

Legally it makes no difference: traceability can be kept on paper, in Excel or in software. The difference lies in how much time it takes to keep up and how long it takes you to answer when someone asks you for a lot.

Excel templateRecipok
Goods-inOne sheet per movementThe delivery note creates a lot per line; Recipok can read it from a photo
ProductionLots written by hand on the orderThe production order deducts the lots and creates the product's lot
Goods outAnother separate recordEvery delivery note carries the product's lot
Tracing a lotOpening sheet after sheetForwards and backwards in seconds, as PDF or Excel
StockYou reconcile itStock by lot, with expiry dates
Mock recallA whole morningOne click, with its report for the inspection

In Recipok traceability is not written separately: it comes from what you already do. Every delivery note creates lots, every production order uses lots and creates a new one, and every delivery takes the lot to the customer. Labels with QR or GS1-128 carry the lot printed on them and can be scanned with a phone. It is included in the Integral plan, together with stock and customer orders. See how it works in food traceability with Recipok or in the help centre: how lot traceability works and set up traceability in your workshop in a week.

Frequently asked questions

Is my workshop required to keep traceability records?
Yes. Article 18 of Regulation (EC) 178/2002 requires every food business, small workshops included, to know who supplied each food or ingredient and which businesses it has supplied its products to.
What does “one step back, one step forward” mean?
It sums up what the rule requires: you do not have to rebuild the whole chain, but you must know who supplied each item to you and who you supplied it to. Internal traceability, which links what comes into your workshop with what goes out, is what joins the two ends.
Is Excel or paper good enough?
Yes, the format is up to you. The problem is not validity but upkeep: with a spreadsheet you have to link every goods-in record to the production orders and to the deliveries by hand, and that becomes unmanageable as you grow.
How long do the records have to be kept?
Regulation 178/2002 does not set a single period. In practice it is based on the shelf life of the product plus a margin. Check with the food safety authority that inspects you, which may set periods by type of product.
What will I be asked for in an inspection?
Usually to show the path of a specific lot: which supplier it came from, which products it went into and which customers it went out to. Practising with a mock recall beforehand is the best preparation.

Keep reading

Your workshop's traceability, ready for the inspection

Start free with 12 recipes and try traceability with a sample workshop. No card.