Lot Tracking for Food Manufacturers: FDA Compliance Made Simple

I've been in food manufacturing compliance for 12 years. I've sat through FDA audits. I've helped clients reconstruct traceability records at 11 PM before an inspector returns at 8 AM. And I've watched companies with genuinely good products get hammered by recalls that spread far wider than they needed to — because nobody had linked ingredient lots to finished goods batches.

A food recall without traceability is a company-ending event. The average Class I recall costs more than $10 million — and that figure doesn't account for the brand damage that follows. The FDA can request records within 24 hours of a complaint under 21 CFR Part 1, Subpart S. [Source: FDA.gov] If you're running on spreadsheets, you won't come close to meeting that standard.

This guide explains what lot tracking is, what FDA FSMA actually requires, and how to build a system that turns compliance from a headache into a competitive advantage.

What Is Lot Tracking?

A lot is a batch of product that shares the same origin, production date, and supplier. Every time you receive an ingredient or produce a finished good, that batch gets a lot number — a unique identifier that follows it through your entire operation.

For each lot, you should track:

• Lot number (your internal ID or the supplier's)
• Supplier name
• Receipt date
• Expiry or best-by date
• Quantity received
• Storage location
• Which finished goods it went into (the critical link)

That last point is where most small manufacturers fall short. Tracking lots in isolation is not enough. You need to link ingredient lots to the finished goods batches that consumed them. That link is what makes traceability possible.

Some consultants will tell you that capturing the lot number on receiving is enough to "have lot tracking." In practice, that's half the picture. Without the outbound link — ingredient lot to finished goods batch — you have records, not traceability.

What FDA FSMA Requires

The Food Safety Modernization Act (FSMA) Section 204 — the Food Traceability Final Rule — came into force in January 2026. [Source: FDA.gov] It applies to manufacturers of high-risk foods on the Food Traceability List (FTL), which includes most produce, eggs, nut butters, finfish, and ready-to-eat foods.

The rule requires businesses to capture Key Data Elements (KDEs) at each Critical Tracking Event (CTE). For food manufacturers, the key CTEs are:

1. Receiving — when ingredients arrive from a farm or supplier
2. Transformation — when you manufacture or process product
3. Shipping — when finished goods leave your facility

At each CTE, you must capture KDEs including lot codes, quantities, suppliers, dates, and locations. The FDA can request these records within 24 hours under 21 CFR Part 1, Subpart S. If you cannot produce them, you face:

• Product seizure
• Facility shutdown
• Civil monetary penalties

Here's the thing most people overlook until they're audited: the 24-hour clock starts when the FDA makes the request — not when you discover the issue. If a contamination event surfaces on a Thursday afternoon and an inspector contacts you Friday morning, you have until Saturday morning. If your records are spread across spreadsheets, email folders, and paper logs, you will fail that timeline.

Even if your products aren't on the FTL, state regulations and retailer requirements often impose equivalent standards. Major grocery chains (Whole Foods, Kroger, Costco) routinely require traceability documentation as a condition of supplier contracts.

The Spreadsheet Problem

Spreadsheets feel adequate — until they fail. They fail food manufacturers in four specific ways:

• Concurrent editing — Multiple people updating the same sheet simultaneously creates version conflicts and overwrites
• No automatic links — There's no built-in way to connect ingredient lot A to finished goods batch B. You create that link manually, or you don't create it at all
• Recall reconstruction — When a recall happens, you manually cross-reference dozens of tabs to find which products used the affected lot. This takes hours, not minutes
• No audit trail — Spreadsheets don't record who changed what and when. If a regulator asks, you have no log

A client of mine — a $1.8M sauce manufacturer — ran their lot tracking in Google Sheets for three years. Neat, organized, well-maintained. Then they had a recall event involving a specific batch of tomatoes. The ingredient lot was recorded on the receiving sheet. But the link between that lot and the finished goods batches it went into? That was done manually in a production log — by a team member who had left the company. The records existed. The link was gone. Their recall scope expanded from 400 cases to 2,200 cases.

The spreadsheet breaks the moment you need it most.

How a Dedicated System Works

With a proper lot tracking system, the workflow is straightforward:

Receiving: When an ingredient shipment arrives, you log the lot number, supplier, quantity, receipt date, and expiry. The system stores this against a unique lot record.

Production: When you run a batch, the system asks you which lots you're consuming. You select them, and the system creates an automatic, permanent link: Lot 4521 (Acme Flour) → Production Run 088 → Finished Goods Lot FG-2026-088.

Recall: If you ever get a call about contaminated flour from Lot 4521, you open the lot record and immediately see every finished goods batch that used it — with quantities and dates. You pull the affected products. You're done.

One click. Not four hours.

This bi-directional traceability — ingredient lot to finished goods, and finished goods back to ingredient lots — is exactly what FDA auditors look for. See how this works alongside Bills of Materials, which automate the ingredient-to-finished-goods link at the recipe level.

If you want to see real examples of manufacturers using lot tracking in practice, our case studies cover several food and beverage operations.

Implementation: 5 Steps

Getting lot tracking in place doesn't require a six-month ERP project. Here's a practical sequence:

Step 1: Assign lot numbers to every ingredient receipt

Every delivery gets a lot record before it goes into storage. The lot number can be the supplier's own code or an internal sequence number — just make sure it's unique and recorded consistently. Don't let materials touch the shelf before they're logged.

Step 2: Record expiry dates and storage locations

Capture the best-by date and physical location (shelf, fridge, freezer zone) for every lot. This enables FIFO rotation and expiry alerts. If you're in a fresh or dairy operation, this step is non-negotiable.

Step 3: Build BOMs linking recipes to components

A Bill of Materials defines exactly which ingredients — and what quantities — go into each finished product. Your BOM is the foundation of automated lot linking. Without it, lot tracking stays manual and the link between ingredient lots and finished goods depends entirely on a human remembering to make it.

Step 4: Run production from BOMs

When you trigger a production run from a BOM, the system knows which components are involved. It prompts you to select the lots being consumed, then automatically records the link to the finished goods batch. No manual cross-referencing. No relying on memory. The link is permanent and retrievable.

Step 5: Store CoA documents against each ingredient lot

Certificates of Analysis (CoA) from your suppliers are regulatory gold. Attach them directly to the lot record in your system so they're retrievable in seconds during an audit — not buried in an email folder from six months ago. A CoA is only one of several document types worth tracking this way — see the documents that travel with a material lot for the full set, from SDS sheets to allergen statements and certifications.

What I Tell Every Food Manufacturer I Work With

Get your team to understand why lot tracking exists, not just how to do it. When people understand that a missed link could mean recalling 2,000 extra cases — and the reputational damage that follows — they stop cutting corners on the receiving log.

The second thing: run a mock audit on yourself every quarter. Pick a finished goods lot at random. Try to reconstruct the full ingredient lot trace in under 15 minutes. If you can't do it, find out why and fix it before an FDA inspector does the same exercise and finds the same gap.

Beyond Compliance: Business Benefits

Lot tracking built for food and beverage manufacturers does more than satisfy regulators. It gives you operational intelligence you can't get from spreadsheets:

• Prevent spoilage before it happens — The system flags lots approaching expiry so you can prioritize them in production, not discover them after they've turned
• Calculate waste cost by lot — When you write off inventory, attach it to the specific lot. Over time, you see which suppliers or storage conditions drive the most waste
• Isolate quality problems quickly — A customer reports an off taste. You pull the finished goods lot, trace back to the ingredient lots, and identify the bad batch. You fix the sourcing issue before it affects the next run
• Win retailer contracts — Increasingly, buyers ask for traceability documentation before onboarding a supplier. Demonstrating a formal lot tracking system is a genuine sales advantage

Key Takeaways

• FDA FSMA Section 204 is not optional for manufacturers of high-risk foods — 24-hour record retrieval under 21 CFR Part 1, Subpart S is the standard [Source: FDA.gov]
• Lot tracking requires linking ingredient lots to finished goods; tracking them in isolation provides no traceability
• Spreadsheets fail at scale — concurrent edits, missing links, and no audit trail make them a liability in a recall
• Implementation takes five steps, not six months — start with receiving, build BOMs, run production automatically, and store CoAs against lots
• Run a mock audit on yourself every quarter — find the gaps before an inspector does

If you're ready to move beyond spreadsheets, explore Nstock's lot tracking and BOM features built specifically for food manufacturers. You can also view our pricing to see what fits your operation, or explore how Nstock serves the food and beverage industry.

— Marcus Reyes