# FSMA 204 Traceability Lot Code (TLC) Worksheet > Source: https://netray.co/tools/fsma-204-traceability-lot-code-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet for critical tracking events, traceability lot codes and key data elements under the FDA Food Traceability Rule. ## Category compliance-legal ## Industry Food and Beverage ## Region United States ## Audience - Food safety manager - Supply chain manager - Quality manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Critical tracking event **Key:** cte **Type:** select **Options:** - Harvesting - Cooling - Initial packing - First land-based receiving - Shipping - Receiving - Transformation #### Food and variety **Key:** food **Type:** text #### Traceability lot code **Key:** tlc **Type:** text #### TLC source (location or reference) **Key:** tlc_source **Type:** text #### Cases **Key:** cases **Type:** number #### Units per case **Key:** upc **Type:** number #### Total units **Key:** units **Type:** number **Expr:** cases * upc **Format:** integer #### Event location **Key:** location **Type:** text #### Event date **Key:** date **Type:** date #### Reference document **Key:** ref **Type:** text **Rows:** **Cte:** Receiving **Food:** Fresh-cut romaine, 24 ct **Tlc:** RM-2026-1019-A7 **Tlc source:** Green Valley Farms, Salinas **Cases:** 120 **Upc:** 24 **Location:** Plant 2 dock 3 **Date:** 2026-10-19 **Ref:** BOL 88213 **Cte:** Transformation **Food:** Chopped salad kit, 12 oz **Tlc:** SK-2026-1020-L2 **Tlc source:** Plant 2, Dayton **Cases:** 300 **Upc:** 12 **Location:** Line 2 **Date:** 2026-10-20 **Ref:** WO 440192 **Cte:** Shipping **Food:** Chopped salad kit, 12 oz **Tlc:** SK-2026-1020-L2 **Tlc source:** Plant 2, Dayton **Cases:** 150 **Upc:** 12 **Location:** Plant 2 outbound dock **Date:** 2026-10-21 **Ref:** BOL 90471 **Cte:** Shipping **Food:** Chopped salad kit, 12 oz **Tlc:** SK-2026-1020-L2 **Tlc source:** Plant 2, Dayton **Cases:** 150 **Upc:** 12 **Location:** Plant 2 outbound dock **Date:** 2026-10-21 **Ref:** BOL 90472 **Cte:** Receiving **Food:** Fresh spinach, 4 lb bag **Tlc:** SP-2026-1018-C1 **Tlc source:** Sunrise Growers, Yuma **Cases:** 80 **Upc:** 6 **Location:** Plant 2 dock 1 **Date:** 2026-10-18 **Ref:** BOL 88190 **Totals:** #### Total cases **Key:** cases **Agg:** sum **Format:** integer #### Total units **Key:** units **Agg:** sum **Format:** integer **Summary:** #### Average units per event **Key:** avg_units **Expr:** sum_units / count **Format:** integer **Notes:** Which events and data elements apply depends on your role (grower, packer, shipper, receiver, transformer, retail) and on whether the food is on the FDA Food Traceability List. FDA has extended the compliance date to July 2028, so confirm the current date and exemptions in the rule text. Records must be producible within 24 hours of a request, as an electronic sortable spreadsheet. ## Content **Intro:** FSMA Section 204 requires certain businesses that handle foods on the FDA Food Traceability List to keep records at critical tracking events, tied together by a traceability lot code. This worksheet gives you the rows and columns to practise the discipline now. **Sections:** #### How to use the worksheet **Body:** Add one row per event per lot. Pick the critical tracking event, enter the food and variety, the traceability lot code, the location or reference that identifies where the code was assigned, the quantity and unit of measure, the event location and date, and the document that proves it. Receiving rows should repeat the supplier lot code, and transformation rows should show the new lot code. Export to Excel or CSV and sort by lot code to see a lot's journey, which is the same exercise FDA will ask you to do on request. #### What the rule asks for **Body:** The Food Traceability Rule (21 CFR Part 1, Subpart S) requires key data elements linked to critical tracking events for foods on the Food Traceability List, such as leafy greens, fresh-cut fruits and vegetables, soft cheeses, finfish, shell eggs, fresh herbs and some others. The traceability lot code identifies a lot at the point it is initially packed, received first from a fishing vessel or transformed. It must be passed on to the next customer. Covered entities also need a traceability plan and must supply an electronic sortable spreadsheet within 24 hours when FDA requests it during an outbreak. #### Reading your data **Body:** Sort by TLC and check that every lot has a source event and that quantities reconcile: cases received should explain cases transformed, shipped and held. In the example, 300 cases of salad kit were made and 300 shipped in two loads, which reconciles. Gaps show up as a lot that was shipped but never received, a transformation row with no input lot, or a shipping row with no reference document. Those are the same holes a mock recall exposes. **Bullets:** - Every lot needs a source event - Quantities should reconcile across events - Every row needs a reference document - New lot codes at transformation must link to input lots #### Common mistakes **Body:** Teams confuse the TLC with the supplier's lot or a best-before date, and reuse the same code for different production runs. Others record the ship-to location but not the TLC source, or store records across email, paper and the ERP so nothing can be produced in 24 hours. The practical fix is to generate TLCs inside the ERP, print them on the label and carry them on the ship notice, so the spreadsheet is a report rather than a manual task. **Cta:** If your ERP already holds lot, work order and shipment data, we can help generate this traceability spreadsheet directly from it so you are not rekeying events. **Faq:** #### What is a traceability lot code? **Answer:** It is a descriptor, often alphanumeric, that identifies a traceability lot. It is assigned when a food is initially packed, first received from a fishing vessel, or transformed, and it must be provided to the next recipient. #### Does FSMA 204 apply to my product? **Answer:** It applies to foods on the FDA Food Traceability List, plus foods that contain them as ingredients when specific conditions apply. Some exemptions exist for small producers, certain retail transactions and some other cases. Check the rule and the list on the FDA site. #### What is the compliance date? **Answer:** FDA extended the original January 2026 date to July 2028. Dates and enforcement positions can change, so verify on the FDA website before planning a rollout. #### Do I need special software? **Answer:** The rule does not require specific software. You must keep the records and be able to give FDA an electronic sortable spreadsheet within 24 hours. An ERP lot tracking module or a well kept spreadsheet can both work at small scale. ## Search terms fsma 204 traceability lot code, fsma 204 worksheet, fsma 204 key data elements template, food traceability list spreadsheet, traceability lot code template, fsma 204 critical tracking events, fda food traceability rule excel, fsma 204 record template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json