What it means
Capture the right data at receipt by recording lot or batch number, expiry or best-before date, quantity, supplier, location and applicable storage requirements. Verify labels against supplier documents and the accepted order, since an incorrect date in the system can make a safe lot look obsolete or a risky lot look available.
Estimate how quickly stock can move by comparing remaining usable life with recent sales, seasonality, known orders and lead time to transfer or return goods. A simple average can hide variation, since a slow month or a cancelled customer order may leave a large lot stranded, so segment by lot so that a fresh delivery does not mask older stock in a product-level report.
Set a rotation rule appropriate to the item, as first-expiry-first-out often fits dated goods better than first-in-first-out, but quality status, customer requirements and lot traceability still govern release. Train pickers and check whether physical storage makes the rule possible, because a near-expiry alert is only useful if someone can act in time to transfer, discount where permitted, return, rework or reduce new purchases.
Keep safety and quality decisions separate from margin pressure, and never relabel or extend a manufacturer date without a valid authorised process. Some products may remain usable after a best-before date under applicable rules while a strict expiry can mean they must not be supplied, and the precise distinction depends on product, jurisdiction and contract, so ask the qualified quality or regulatory owner before releasing borderline stock.
Measure the financial effect honestly, since potential write-down, return credit and disposal cost should be assessed under the applicable accounting policy, and moving a lot between warehouses does not remove its age. Track write-offs and causes such as excessive minimum order quantities, optimistic forecasts, promotions that ended, poor rotation, slow returns or storage damage, and compare the cost of more frequent small purchases with the cost of expiry, rather than focusing only on unit price.
For owners, shelf-life risk links buying decisions to cash and reputation. Early visibility creates lawful options, whereas discovering an expiring lot on the day it must ship forces rushed discounts or waste, and a reliable lot-level view supports both customer promises and financial planning.
In practice
Real-world examples.
Example
A cafe slows orders of a seasonal syrup when two existing batches will expire before the likely demand clears them.
Example
A distributor flags an apparently valid lot because its largest customer requires six months of life on receipt.
Example
A repair firm quarantines adhesive with an unreadable date rather than assigning it the expiry of the adjacent carton.
Formula
Calculation
Estimated at-risk units = Usable units in a lot - Forecast units that can be used or sold before its last acceptable date
Worked example. An invented lot has 600 usable packs. Demand that meets the customer and legal date rules is estimated at 420 packs before the final acceptable shipment date.
- Estimated at-risk units = 600 - 420 = 180 packs.
- If the forecast changes or an approved return is available, update the estimate and the financial exposure.
This is a planning estimate, not permission to sell goods that fail quality or date requirements.Case study
Seen in the real world.
This illustrative and entirely fictional example follows Maple Foods, an invented snack distributor. A supplier offered a large discount on 2,000 packs with a short remaining life. Purchasing accepted the price because the company's total sales rate suggested the packs could be sold. The stock system combined all lots, however, and a newer lot was picked first. A weekly lot report later showed 500 packs nearing the last date accepted by key customers.
Operations changed the pick sequence to first-expiry-first-out where the rules allowed, verified storage and packaging, and gave sales a list of suitable customers without hiding the remaining life. Purchasing paused another order and asked the supplier whether a contractual return credit applied. Quality decided that packs past the permitted window would not ship. Maple recovered part of the value but wrote down the rest. The owner changed approval rules for short-dated purchases: the buyer now checks lot-level demand and customer minimum-life terms before comparing unit prices.
Watch out
Common mistakes.
- Using a product's total stock balance instead of the dates and quantities of each lot.
- Assuming a discount or transfer makes noncompliant or unusable goods safe to sell.
- Buying extra units for a low unit price without checking demand before the last acceptable date.
Questions
People also ask.
Is best-before the same as an expiry date?
No. Their meaning depends on the product and applicable rules; a qualified owner should check what may be supplied.
Which lots should be picked first?
Often the earliest acceptable expiry first, subject to quality status, traceability and customer minimum-life requirements.
How often should risk be reviewed?
Often enough to leave time for a lawful, practical remedy; the right cadence depends on remaining life and demand volatility.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%