FEFO Inventory Management: A Practical Guide for Small Manufacturers

FEFO inventory management means picking and consuming the lot with the earliest expiry date first, instead of the lot that arrived first. If you make food, beverages, supplements, cosmetics, candles, or soap, expiry dates decide what you can ship, and FEFO is the rule that keeps short-dated stock from quietly going to waste. This guide explains what FEFO is, how it differs from FIFO, why spreadsheets struggle with it, and how Evenbatch runs FEFO automatically alongside QuickBooks Online.

What FEFO means, and how it differs from FIFO

FEFO stands for first-expired-first-out. Under FEFO, when you pick stock for a sales order or pull components for a production run, you take the lot with the earliest expiry date first. The goal is simple: sell or use the stock that will go bad soonest, so less of it expires on your shelf.

FIFO stands for first-in-first-out. Under FIFO, you use stock in the order you received it: oldest receipt first. FIFO is the default habit in most stockrooms because receipt order is easy to observe. You put new boxes behind old boxes and pull from the front.

Here is the key insight: FIFO and FEFO usually agree, but not always. A later delivery can carry an earlier expiry date. Maybe your supplier shipped you stock from an older production batch, or a different supplier's lot has a shorter shelf life. When that happens, receipt order points you at the wrong lot. FIFO is a proxy for FEFO, and it fails exactly when it matters most: when a short-dated lot is sitting behind fresher stock.

There is also an accounting angle worth separating from the warehouse angle. QuickBooks Online Plus and Advanced track inventory quantities and cost using FIFO. That is a costing method, a rule for valuing what you sold. It is not a picking rule, and QuickBooks Online has no lot or expiry concept at all. A fefo inventory management system works at a different layer: it decides which physical lot leaves the building.

Why expiry-dated products need FEFO

If your products or ingredients have a shelf life, FEFO is not optional bookkeeping. It is how you protect margin and reputation at the same time.

• Less expired stock. Every lot that expires on the shelf is money you already spent, written off. FEFO systematically moves the shortest-dated stock out first, so fewer lots age past their date while fresher stock ships.
• Customer trust. Shipping short-dated or expired product is one of the fastest ways to lose a customer. A retailer that receives goods with barely any shelf life left will remember it. FEFO makes the freshness of what you ship a process, not a hope.
• Traceability expectations. Regulators and large buyers expect lot-level traceability. If you cannot say which lot went where, you are not ready for the questions that come with bigger accounts.

Shelf life shows up in more places than food labels. Supplement makers manage ingredient expiry and potency dates. Cosmetics and skincare have use-by periods. Even candle and soap makers deal with fragrance oils and botanical ingredients that degrade over time. The details differ by vertical, and we cover the specifics for food manufacturers and supplement manufacturers separately, but the underlying rule is the same everywhere: the lot that expires first should leave first.

Where spreadsheets and QuickBooks alone break down

Most small manufacturers start with a spreadsheet for lots and expiry dates. It works until it doesn't, and it usually fails in the same four ways:

• Expiry dates live in a column that nobody sorts by at pick time. The data exists; the discipline to check it under deadline pressure does not.
• Quantities drift from reality. The spreadsheet says 40 units remain in a lot, the shelf says 12, and nobody knows when they diverged.
• FEFO depends on whoever is packing that day remembering to check dates. One busy afternoon, one substitute packer, and the short-dated lot stays on the shelf.
• A recall question means hours of manual cross-referencing: which production runs used that lot, which orders shipped from those runs, which customers received them.

QuickBooks Online cannot fill this gap on its own. QuickBooks Online does not include lot or batch tracking on any plan; within Intuit's lineup, lot and serial tracking exist only in QuickBooks Desktop Enterprise with Advanced Inventory. QuickBooks Online tracks inventory cost using FIFO, but it has no concept of an expiry date, so it cannot warn you about aging stock or tell you which lot to pick. We cover this gap in depth in our guide to QuickBooks lot tracking.

How Evenbatch runs FEFO end to end

Evenbatch applies FEFO at every point where stock moves, so the rule holds without anyone having to remember it.

• At receiving. Purchase orders capture the lot number and expiry date the moment goods arrive. From then on, every unit belongs to a lot with a known date and a known remaining quantity.
• On sales orders. When you allocate stock to a sales order, Evenbatch picks FEFO automatically: the earliest-expiring lot with stock remaining goes first. Your packer follows the pick; the system supplies the judgment.
• In production. Production orders explode the bill of materials and consume components FEFO too, so your shortest-dated raw materials get used before they expire. The finished output becomes a new lot with its cost rolled up from the components consumed.
• Before it's too late. Expiry alerts flag lots approaching their dates while you still have time to sell, use, or discount them. Lot reports show remaining quantity, expiry, and cost for every lot in one place.

Units of measure carry through all of this: buy in cases, consume and sell in eaches, with per-item conversions applied across purchasing, BOMs, and sales. See our guide to units of measure with QuickBooks for the details.

Lot tracking and FEFO are included on every Evenbatch plan. There is no add-on tier, no upgrade required, and no per-user fee to give warehouse staff access.

FEFO plus traceability: ready for a recall question

FEFO and traceability come from the same data. Because every receipt, production run, and shipment in Evenbatch is tied to a lot, answering "where did lot 2417 go?" takes one click: the recall trace follows a lot through production runs to shipments and exports the whole trail to CSV. When a supplier flags a bad ingredient lot or a large buyer asks for your traceability process, you have an answer in minutes, not a weekend of spreadsheet archaeology. Regulators and large buyers expect lot-level traceability, and FEFO discipline is what keeps that data accurate day to day. For the full picture, see our guide to recall traceability with QuickBooks.

Getting started with FEFO in Evenbatch

Evenbatch is web-based inventory software built for small manufacturers of one to ten people who run their books in QuickBooks Online. It connects through Intuit's official API using OAuth 2.0, so Evenbatch never sees your QuickBooks password. The sync is designed to be trustworthy: a preview mode shows every change before anything is written to QuickBooks, a full sync log records what was sent and when, held changes wait for your explicit approval, and item sync is create-only, so Evenbatch never overwrites your existing QuickBooks records.

Moving in is free: CSV import brings over your items, BOMs, lots, and stock levels from spreadsheets or exports of other tools, and you can export all of your data to CSV anytime. Pricing is $49.99 per month flat, with unlimited users and every feature included, and the 14-day free trial requires no credit card. A practical path to going live with FEFO:

• Import your items, BOMs, and current lots with expiry dates via CSV.
• Connect QuickBooks Online and review the sync preview.
• Capture lot number and expiry on your next purchase order receipt.
• Let sales orders and production runs allocate stock FEFO from day one.

For a broader look at running manufacturing inventory alongside QuickBooks Online, see our guide to QuickBooks inventory for manufacturers.

See something outdated or incorrect on this page? Email support@evenbatch.com and we will correct it within 48 hours. Last updated: July 16, 2026.