BuiltByEstradaBook a call

FSMA 204 Traceability Lot Log

Produce and Cold Chain line

A log of the key data elements the FDA Food Traceability Rule (21 CFR Part 1 Subpart S) asks for when you receive, ship, pack or transform produce on the list. It builds unique lot codes and pulls every record for a lot, product or date range into one sortable table for a 24 hour FDA request.

Excel and Google Sheets workbook, English and Spanish

Fare

$29

founding price until January 31, 2027 · then $47

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

FSMA-204-Lot-Log.zipSCREENSHOTS · full version
FSMA 204 Traceability Lot Log: the Rule guide tab, with EXAMPLE data
Rule guide: tab with EXAMPLE data See the whole tab
FSMA 204 Traceability Lot Log: the Initial packing tab, with EXAMPLE data
Initial packing: tab with EXAMPLE data See the whole tab
FSMA 204 Traceability Lot Log: the FDA request tab, with EXAMPLE data
FDA request: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

Download the free version (.xlsx) ↓

Free file: the Landed Cost per Carton calculator. This product comes as a full version only. See what each one has

What you do, what the sheet does

YOUTHE SHEET
You pick a location, date and productIt builds a unique traceability lot code
You log a receipt or shipmentIt checks every key data element is there
You type the lot FDA asked aboutIt lists every record for that lot in one table
You copy the tableYou have the sortable spreadsheet the rule asks for

What the full version has

  • Rule guide: what to record for each event, with the CFR section
  • Locations and Products tabs with full location descriptions and list categories
  • Lot code builder with a duplicate check
  • Receiving, Shipping, Initial packing and Transformation logs
  • A completeness check on every row
  • FDA request tab: one sortable table for a lot, product or date range
  • English and Spanish versions

Who it is for

Produce importers, packers, repackers and distributors handling tomatoes, peppers, cucumbers, leafy greens, melons, herbs or tropical fruit who need FDA traceability records.

Example prices say EXAMPLE. You enter your own once on the prices tab.

Free version and full version

The free file is the Landed Cost per Carton calculator, a small workbook that shows how BuiltByEstrada sheets work. This product is the full version, in English and Spanish.

FREE FILE (.XLSX)

  • Landed cost per carton for one item
  • A table to compare up to 5 items
  • English and Spanish files
Download the free version (.xlsx) ↓

FULL VERSION · $29

  • 9 tabs plus a Start here page
  • Room for 100 records per event and 120 lot codes
  • English and Spanish files
Buy the full version →

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.