Lot tracking in QuickBooks is one of the first hard limits that businesses in food and beverage, dietary supplements, pharmaceuticals, and chemicals run into. The need is straightforward: lot numbers tied to every transaction, expiration dates that actually drive how product gets picked, and full traceability from the supplier batch to the customer shipment. QuickBooks does not provide any of that in a way that holds up under real operational pressure or regulatory scrutiny.
Most teams discover this after they have already committed. They added the lot number fields, built a spreadsheet to track expiration dates, and told themselves it was good enough. Then a quality event happened, or an auditor asked for a forward trace, and the gaps became impossible to ignore.
This page covers what QuickBooks actually offers, why the workaround approaches fail, and what a system built for this problem looks like.
What QuickBooks actually offers
QuickBooks Enterprise includes a lot and serial number tracking feature inside its Advanced Inventory module. That feature exists. But it is not what most regulated businesses mean when they say lot tracking, and the difference matters.
Here is what the QuickBooks lot feature actually gives you:
- The ability to assign a lot number to an inventory item when entering a transaction
- A prompt to select or enter a lot number at the time of invoicing or receiving
- Basic reporting that shows which lot numbers are currently on hand
Here is what it does not give you:
- No expiration date field linked to a lot at the time of receiving
- No first-expired-first-out logic that uses expiration dates to guide which lot gets picked
- No automatic carry-through of the lot from the purchase order receipt to every downstream transaction, without manual selection at each step
- No full forward trace showing every customer who received product from a specific lot
- No full backward trace linking a finished shipment back to the supplier batch and receiving event
- No connection between a lot and supporting documents like a supplier certificate of analysis or batch record
Custom fields are the other common attempt. Teams add a text field called "Expiration Date" to the item or transaction record and enter it manually. The field stores what you type. It does not validate format, enforce entry, connect to picking decisions, or roll into any traceability report. It is a note, not a system.
Why the spreadsheet workaround fails
These are the four failure points that businesses using manual lot logs in QuickBooks hit first.
Manual lot logs drift from actual inventory
Every time a transaction is not recorded promptly, every time someone forgets to update the spreadsheet, and every time a partial shipment or return is logged in QuickBooks but not in the lot log, the two records diverge. Over weeks, the spreadsheet stops reflecting reality.
No link between the lot and the sale
QuickBooks can record that you shipped 100 units of a product on a given date. It cannot reliably tell you which lot those 100 units came from unless someone manually recorded that in a separate field and that field was entered correctly every single time. In practice, it rarely is.
Recall traceability becomes near impossible
When a recall or quality hold hits, you need to identify every customer who received product from a specific lot within hours. If the answer lives across QuickBooks transaction records, a spreadsheet lot log, and someone's memory about which batches were used on which days, you are piecing together a puzzle under pressure with missing pieces.
Audit and compliance risk compounds over time
Every manual entry point is an opportunity for error. Over months and years of operation, those errors accumulate. An auditor or inspector who asks for lot-level records and receives a collection of spreadsheets with inconsistent formats and missing entries is going to ask harder questions than one who receives a clean, system-generated trace report.
What this means if you are regulated
For businesses subject to FDA oversight under the Food Safety Modernization Act, lot traceability is not a best practice. It is a legal requirement. FSMA's traceability rule describes two specific capabilities that regulated businesses must be able to demonstrate: forward traceability and backward traceability.
Forward traceability means starting from a lot number and immediately identifying every customer and shipment that included product from that lot. Backward traceability means starting from a finished product or shipment and tracing it back to the source lot, the receiving event, and the supplier batch.
Pharmaceutical and supplement businesses face similar requirements from FDA's Current Good Manufacturing Practice regulations. Chemical companies working with customers in regulated industries face audit requests from those customers that require the same forward and backward traceability capability.
In all of these cases, the compliance exposure is not theoretical. It is the direct consequence of running a regulated product business on a system that was built for general accounting, not for lot-level supply chain traceability.
What real lot tracking requires
Businesses that solve this problem are not patching QuickBooks with add-ons and custom fields. They are moving to systems where lot traceability is a first-class feature built into every transaction, not an afterthought layered on top.
What genuine lot tracking looks like in practice:
- Lot number captured automatically at receiving when a purchase order is completed, with no separate manual entry required
- Expiration date recorded against the specific lot at the time of receipt, tied to that lot permanently
- Lot number carried through every internal movement automatically: from receiving, through any production step or quality hold, to the outbound shipment
- First-expired-first-out picking logic that prompts fulfillment staff to select the lot with the nearest expiration date, not just whichever lot is easiest to grab
- Forward trace available on demand: starting from any lot number, instantly see every sales order and shipment that drew from that lot
- Backward trace available on demand: starting from a shipment, instantly see the lot, the receiving date, the supplier, and every other order that used the same lot
- Quality holds that can be applied to a specific lot and that prevent that lot from being picked or shipped until the hold is released
These capabilities require a system where lot is a core data attribute attached to every inventory transaction, not an optional label that someone types into a field. The difference between those two approaches is the difference between a usable recall process and a manual investigation.
Questions we hear most often
Does QuickBooks have lot tracking?
QuickBooks Enterprise has a serial and lot number feature in its Advanced Inventory module, but this is not genuine lot tracking. It lets you assign a number to a unit of inventory and select that number when entering certain transactions. It does not capture expiration dates at receiving, carry the lot automatically through every transaction, or generate a traceability report linking a lot to every sale that used it.
Can you track expiration dates in QuickBooks?
No, not in any meaningful operational way. QuickBooks has no expiration date field linked to a received lot in its inventory module. Custom fields can be added to item records, but a custom field on an item applies to the item master as a whole, not to a specific batch received on a specific date. There is no way to capture an expiration date at receiving and have the system use that date to drive first-expired-first-out picking decisions.
What do food and supplement companies need instead of QuickBooks for lot traceability?
Businesses with genuine lot traceability requirements need a system where the lot number is captured once at receiving and follows the product automatically through every movement: from the purchase order receipt, through any production or transformation, and out on the sales order shipment. The system should also carry the expiration date with the lot and use it to prioritize picking. Those are system-level capabilities, not workarounds built on top of a general accounting tool.
Is a spreadsheet system enough for FDA lot traceability compliance?
No. FDA requirements under the Food Safety Modernization Act describe forward and backward traceability: the ability to identify every customer who received product from a given lot, and the ability to trace a finished product back to its source ingredients and supplier batch. A spreadsheet-based approach can attempt to replicate this, but manual entry creates gaps. Under a recall scenario, those gaps are the difference between an effective recall response and a compliance failure.
Related problems
- Why your inventory is always wrongThe systems reasons counts drift, and why counting more often does not fix it.
- Why your inventory never matches the systemWhere the drift between physical counts and system records comes from.
- Why your QuickBooks inventory shows negativeWhat a negative quantity on hand is really telling you.
- Signs you have outgrown QuickBooksHow to tell when your accounting software is holding the business back.
Find out where your traceability gaps are most urgent
The free ERP Readiness Calculator covers lot tracking, expiration management, and the other operational gaps that come with regulated product businesses. Takes under 2 minutes.
No sales pitch. No vendor push. Just a clear picture of where your systems stand.