Pharmacy Inventory Management: How to Reduce Expiry Losses by 80%
Cutting expiry losses is not a software feature — it is a four-part program of buying discipline, supplier terms, pricing courage and one weekly dashboard habit. Pharmacies that run all four typically cut write-offs by 60–80% within two quarters.
Know Your Bleed: The One KPI
Expiry Loss % = Expired stock value ÷ Total stock purchased (rolling 12 months)
Most unmanaged chemists sit at 3–5%. Managed ones run under 1%. Track it monthly — what gets measured gets fixed.
Buy Less, More Often
- Set reorder levels per item from actual monthly movement, not distributor persuasion.
- Beware scheme traps: "buy 40 get 6 free" is a bargain only if 46 units sell inside the shelf life.
- Split large orders into two deliveries when the second half can arrive later.
- For slow movers, cap stock at 30–45 days of sales regardless of scheme economics.
Negotiate the Return Window
Most distributors accept near-expiry returns in the 3–6 month window before expiry. Put it in writing, then use it: the 60-day alert exists to trigger returns while the window is open. Pharmacies that skip this step are donating the full purchase value.
Kill Negative-Margin Stock Early
Free/bonus quantities change your effective cost — and sometimes a scheme leaves stock whose effective cost plus GST approaches MRP. Discount it out in month two, not month ten: cash today beats a write-off later.
The Owner Dashboard That Prevents Surprises
| Glance at weekly | Action trigger |
|---|---|
| Value at risk — critical (<30 days) | Discount or write off this week |
| Value at risk — warning (30–90 days) | Return to supplier now |
| Slowest 20 items by movement | Stop reordering |
| Expiry Loss % trend | Program is working — or not |
Set Targets by Category
| Category | Typical risk | Practical cap |
|---|---|---|
| Fast-moving generics | Low | Up to 30–45 days of sales |
| Slow-moving branded drugs | High | Order on demand or keep minimum stock |
| Refrigerated items | Very high | Small quantities; treat 90-day alerts as urgent |
| Seasonal (cough, cold, monsoon) | Medium | Stock up for the season, return before it ends |
Review the caps every quarter using your own sales data — the right numbers differ from shop to shop.
FAQ
- Should I run clearance offers? Yes, but prefer bundling slow stock with fast movers over flat discounting — margin impact is lower.
- What about refrigerated items? Their windows are tighter; treat the 90-day alert as critical for cold chain stock.
- Who owns this process? The owner reviews weekly; the counter team executes returns and write-offs with mandatory notes.
PharmaBill OS handles expiry loss control automatically.
Book a free live demo — 15–30 minutes, on your schedule.
About the Author
Compliance & product specialists at PharmaBill — building billing software for Indian pharmacies, hospitals and labs.
Related Articles
How to Track Medicine Expiry Dates in Your Pharmacy — Stop Losing Money
FEFO discipline, 30/60/90 day alert tiers and return-to-supplier windows that cut expiry write-offs by up to 80%.
FEFO vs FIFO: Which Stock Rotation Method Is Best for Pharmacy?
First-expiry-first-out beats first-in-first-out for medicines. Here is the math, the exceptions and how to enforce it.
How to File GSTR-1 for a Pharmacy: Complete Step-by-Step Guide (2026)
From daily invoice capture to uploading the b2cs, hsn and doc sheets on the GST portal — the exact monthly routine every chemist shop should follow.