Fix Expired Stock Write-Offs: Pick by Expiry, Move Short-Dated Stock and Claim What You Can
For pharma, FMCG and food distributors: pick by expiry, move short-dated batches while they can still sell, and recover credit from suppliers before the window closes.
To fix expired stock write-offs, look at the batches that expire next quarter, not the ones that expired last month. By the time a batch has expired, the only choices left are a claim or a loss.
In many Indian distributors, the same item is dying in one depot while another depot is buying more of it. Nobody sees both at once, and near-expiry lists are made by hand when someone has time.
This page gives the direct fix, an illustrative example from Lucknow, and how Apragya puts expiry into every pick and every transfer.
Why stock expires, and the fix
Expired stock write-offs happen when batches reach their expiry date before they are sold or used. In pharma, FMCG and food, some loss is normal. Most of it is avoidable.
The common causes: pickers take the nearest carton instead of the earliest expiry; short-dated stock is sent to customers who refuse it; one godown holds a batch that another godown is selling fast; buying ignores shelf life; and supplier expiry claims are not raised before the supplier's window closes.
The fix is first-expiry-first-out picking, a regular near-expiry review, transfers, and claims raised on time.
- Record batch and expiry for every receipt.
- Pick by earliest expiry, not by position on the shelf.
- Set the minimum remaining shelf life each customer will accept.
- Review batches expiring in the next 60 to 90 days every week.
- Transfer short-dated stock to locations consuming it faster.
- Raise supplier expiry claims while they are still accepted.
- Block expired stock from leaving, and write off only after a count.
Near expiry stock management: what you see and what it means
What it means
- Picking ignores expiry dates.
- The customer's minimum shelf life is not applied.
- Near-expiry stock is not compared across locations.
- The claim was raised after the supplier's window.
- Nothing stops expired stock at dispatch.
An example: a Lucknow FMCG distributor
Take an illustrative distributor with two depots, writing off around 6 lakh a quarter in expired biscuits, juices and personal care. The team changed how a near-expiry batch was handled.
One short-dated batch, saved from write-off
Batch flagged
Juice batch with 45 days left and slow sales.
Agent suggests transfer
The second depot sells it three times faster.
Manager approves
Transfer agreed the same day.
Stock moved
Cartons transferred and picked first there.
Sold in time
Batch cleared before expiry.
The juice batch sold out with two weeks to spare. Over the next quarter, write-offs fell sharply as picks followed expiry dates and the remaining expired cartons were claimed from suppliers within their windows.
How Apragya supports FEFO inventory
Step 1 of 5
Batches and expiry
Every receipt carries its batch and expiry date.
- Batches and expiry: Every receipt carries its batch and expiry date.
- Pick by earliest expiry: Allocation picks the earliest expiry and skips batches too short for the customer.
- Expired stock stopped: When switched on, expired batches cannot leave on any outbound path.
- Expiry agent: For at-risk batches, an agent suggests an action such as a transfer, for review.
- Supplier expiry claims: Eligible batches inside a supplier's window are listed for claims.
Why FEFO needs more than a spreadsheet
A near-expiry list tells you what is at risk. It does not tell you where the item is selling, which customer will accept it, or which supplier will still take it back. That needs stock, sales and purchase on one record.
Manual expiry control, against Apragya
| Feature | Manual lists | Apragya |
|---|---|---|
| Picking | Nearest carton | Earliest expiry first |
| Customer shelf life | Known to the salesman | Applied at allocation |
| Across depots | Not compared | Compared by the expiry agent |
| Supplier claims | Raised late | Listed while still eligible |
| Expired goods | Can be shipped | Blocked at dispatch |
Checked against public information on 16 September 2026.
Getting started
- Make sure every receipt records batch and expiry.
- Set minimum shelf life for key customers.
- Switch on expiry enforcement.
- Review the next 90 days of expiries weekly.
- Raise claims on eligible batches.
The weekly 90-day review is where most write-offs are prevented.
What keeps write-offs low
One record
Batches are shared by stores, sales and purchase.
Human review
Agent suggestions wait for a manager.
Many depots
Each location's stock and sales are visible together.
Barcode and bins
The right batch is found and scanned.
Audit log
Overrides and write-offs are logged.
Access by role
Only named roles can release restricted stock.
See expiry and FEFO, batch tracking and expiry claims. For slow stock in general, read how to fix excess inventory and dead stock.
What it costs to start
FEFO inventory, answered
What is FEFO?
Can we still sell short-dated stock?
Is expiry blocking on by default?
What about GST on expired goods written off?
What does it cost to start?
Sell the batch before it expires
Switch on FEFO picking and see which batches expire in the next 90 days.