Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Troubleshooting

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.

A depot manager checking a juice carton with a picker beside a trolley

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.

  1. Record batch and expiry for every receipt.
  2. Pick by earliest expiry, not by position on the shelf.
  3. Set the minimum remaining shelf life each customer will accept.
  4. Review batches expiring in the next 60 to 90 days every week.
  5. Transfer short-dated stock to locations consuming it faster.
  6. Raise supplier expiry claims while they are still accepted.
  7. 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

  1. Batch flagged

    Juice batch with 45 days left and slow sales.

  2. Agent suggests transfer

    The second depot sells it three times faster.

  3. Manager approves

    Transfer agreed the same day.

  4. Stock moved

    Cartons transferred and picked first there.

  5. Sold in time

    Batch cleared before expiry.

The transfer suggestion came from comparing both depots' sales for the same item.

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.

Juice cartons in a row with ribboned ones loaded on a toy truck
The short-dated juice batch moved to the depot selling it fastest, and sold out before expiry.

How Apragya supports FEFO inventory

Step 1 of 5

Batches and expiry

Every receipt carries its batch and expiry date.

  1. Batches and expiry: Every receipt carries its batch and expiry date.
  2. Pick by earliest expiry: Allocation picks the earliest expiry and skips batches too short for the customer.
  3. Expired stock stopped: When switched on, expired batches cannot leave on any outbound path.
  4. Expiry agent: For at-risk batches, an agent suggests an action such as a transfer, for review.
  5. 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

FeatureManual listsApragya
PickingNearest cartonEarliest expiry first
Customer shelf lifeKnown to the salesmanApplied at allocation
Across depotsNot comparedCompared by the expiry agent
Supplier claimsRaised lateListed while still eligible
Expired goodsCan be shippedBlocked at dispatch

Checked against public information on 16 September 2026.

Getting started

  1. Make sure every receipt records batch and expiry.
  2. Set minimum shelf life for key customers.
  3. Switch on expiry enforcement.
  4. Review the next 90 days of expiries weekly.
  5. 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

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Inventory and Warehousing
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

FEFO inventory, answered

What is FEFO?
First expiry, first out: the batch that expires soonest is picked first, whatever its arrival date.
Can we still sell short-dated stock?
Yes, to customers who accept that remaining shelf life. Their minimum is applied at allocation.
Is expiry blocking on by default?
No. It is a setting you switch on, so existing processes are not disturbed.
What about GST on expired goods written off?
Tax credit on goods written off generally has to be reversed. Check with your accountant.
What does it cost to start?
Inventory and Warehousing is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Sell the batch before it expires

Switch on FEFO picking and see which batches expire in the next 90 days.