QuickBooks Online Batch Tracking: Lot Numbers and Expiry Dates Explained
QuickBooks Online batch tracking is not supported natively. Learn what QBO can't do for lot tracking and expiry dates — and what to do instead.
QuickBooks Online batch tracking is not available as a native feature — and for regulated, perishable, or compliance-sensitive businesses, that gap creates real operational and financial risk.
At a Glance: QBO vs Full Batch Traceability
| Capability | Native QBO | Full Batch Traceability |
|---|---|---|
| Inventory quantity tracking | Yes | Yes |
| Inventory valuation | Yes | Yes |
| Lot / batch number tracking | No | Yes |
| Expiry date management | No | Yes |
| FEFO (First Expired, First Out) | No | Yes |
| Recall reporting | No | Yes |
| Lot-level inventory history | No | Yes |
| Supplier batch traceability | No | Yes |
| Compliance audit trails | No | Yes |
What Is Batch Tracking?
Batch tracking (lot tracking) lets businesses identify and follow inventory from supplier to warehouse to customer. A complete record covers supplier, receipt date, storage, expiry, customer, and full recall history.
Does QBO Support Batch Tracking?
Short answer: no. QBO tracks inventory quantities and values, but not lot tracking, batch traceability, expiry dates, recall reporting, lot-level history, or FEFO workflows. Serial numbers, lot numbers, and expiration tracking are only in QuickBooks Desktop Enterprise.
Why Lot Tracking Matters — By Industry
- •Food distribution: recall traceability and expiry control
- •Cosmetics & personal care: batch and expiry quality control
- •Medical & healthcare supplies: regulatory audit trails
- •Chemical products: safety and compliance records
Common QBO Workarounds (and Why They Break)
- •Adding batch numbers to product names — unmanageable list, no reports
- •Notes on transaction lines — unstructured, no recall logic
- •External spreadsheets — risk grows with volume
The Connected App Architecture
QBO handles accounting, invoicing, purchasing, tax, reconciliation. A connected inventory platform handles batch and lot tracking, expiry, FEFO, recall reporting, warehouse control, and audit history. Sync keeps both layers aligned.
Frequently Asked Questions
Does QBO support lot tracking?
No. A connected inventory app is required.
Can QBO track expiry dates?
Not natively.
Can I use spreadsheets for batch tracking alongside QBO?
Yes, but risk scales with volume.
What industries typically need batch tracking?
Food, cosmetics, healthcare, and chemicals.
Should I replace QBO to get batch tracking?
No. Extend QBO with a connected inventory app.
Need help applying this to your business?
Talk to a QuickBooks specialist at Quick Focus Mauritius.