For a typical Indian pharmacy, expired drugs are a fact of business life. A bottle of syrup gets pushed to the back of the shelf when new stock arrives. A slow-moving antibiotic sits untouched. A seasonal medication from last winter is still in the rack when the batch expires.
Every expired item is a direct financial loss — the cost of the drug absorbed by the pharmacy with zero revenue recovery. For most Indian pharmacies, this represents 2–5% of annual purchase value: somewhere between ₹1 lakh and ₹2.5 lakh every year on a ₹50 lakh purchase base, silently leaving the business.
What makes this loss particularly frustrating is that it's almost entirely preventable.
Why Drug Expiry Losses Keep Happening
Understanding why pharmacies lose money to expiry requires looking at how dispensing actually works in a manual or basic system.
The shelf placement problem: In most pharmacies, when new stock arrives, it's placed at the front of the shelf — because that's where there's accessible space. This means newer batches get dispensed before older ones. The older batch, with the earlier expiry date, sits behind the newer one until it expires. This is the exact opposite of what FEFO requires.
The visibility problem: Nobody in a busy pharmacy checks expiry dates batch by batch every morning. The systematic check happens during stock audits — which may happen monthly, quarterly, or less often. By the time a near-expiry batch is discovered in an audit, the distributor return window may have closed.
The slow-mover problem: Some medicines are stocked based on historical demand that no longer reflects current prescribing patterns. A molecule that was commonly prescribed two years ago sits in your stock as prescribing habits change. Without demand data per product, overordering slow movers is inevitable.
The return-tracking problem: Most pharmaceutical distributors in India accept near-expiry returns — typically batches with 30–90 days remaining. But claiming this requires knowing which batches qualify and initiating the return in time. Without a system, this intelligence doesn't exist.
What Is Batch Tracking in a Pharmacy?
Batch tracking means recording the batch number and expiry date for every purchase of every medicine — and maintaining this record through the entire life of that stock until it's either dispensed, returned, or written off.
In GoClixy's pharmacy module, every purchase entry requires the batch number and expiry date per item. When a strip of tablets arrives with batch number B2309 and expiry date March 2026, that's recorded against the product. When more strips arrive in a different batch with expiry June 2026, both batches coexist in the system with their individual quantities and expiry dates.
At any moment, you know:
- Which batches of each product are in stock
- The quantity remaining in each batch
- The expiry date of each batch
- The estimated value of near-expiry stock
This visibility is the foundation of all expiry management.
What Is FEFO — And Why It Matters More Than FIFO
FIFO (First In, First Out) is the standard inventory management principle — use the stock that arrived first before the stock that arrived later. FEFO (First Expired, First Out) is more precise for pharmacies: use the stock that expires soonest, regardless of when it arrived.
In practice, a batch received 6 months ago may have a later expiry than one received 3 months ago. FIFO would dispense the older batch (which expires later). FEFO dispenses the newer batch (which expires sooner) — exactly what the pharmacy needs to prevent expiry.
GoClixy implements FEFO automatically. When a pharmacist adds a medicine to a bill, the system selects the batch with the earliest expiry date. The pharmacist doesn't need to check. They don't need to know which batch is expiring soonest. The system handles it — reducing the possibility of human error or oversight to near zero.
For multi-pharmacist operations where different staff members serve different shifts, FEFO enforcement through the system is particularly valuable — because it works consistently regardless of who is at the counter.
The Expiry Alert Dashboard
Knowing that a batch expires in 45 days is only useful if you have 45 days to act. GoClixy's expiry alert dashboard shows all batches with expiry within a configurable threshold — typically 30, 60, and 90 days.
For each near-expiry batch, the dashboard shows:
- Medicine name and strength
- Batch number and exact expiry date
- Current quantity in stock
- Estimated value at purchase price
This view allows the pharmacy owner to prioritise actions:
Distributor returns for batches within the return window: Generate a return challan directly from the dashboard, send to the distributor, and recover most of the purchase cost.
Active dispensing push for batches approaching expiry: If a commonly prescribed medicine has a near-expiry batch, the pharmacist can be informed to prioritise that batch for the next few days.
Purchase adjustment for slow-moving products: If a product consistently appears on the near-expiry report, it's a signal to reduce future order quantities.
Preventing Overstock of Slow-Moving Items
Expiry losses from slow-movers are harder to eliminate through FEFO alone — because FEFO ensures the right batch is dispensed, but if the product doesn't sell at all, every batch will eventually expire.
The solution is purchase planning based on consumption data. GoClixy tracks monthly consumption per product. After a few months of operation, the system can show which medicines are selling at what rate — and what the maximum quantity you should hold at any time is (based on: monthly sales × reorder interval + safety stock).
Products that consistently show low consumption relative to purchase quantity are flagged for purchase quantity reduction. This addresses the root cause of slow-mover expiry rather than just managing the symptom.
Drug Schedule Compliance: The Other Side of Pharmacy Management
A complete pharmacy management system handles not just inventory but also the legal requirements around dispensing. GoClixy's pharmacy module tracks drug schedules:
- Schedule H drugs require a valid prescription — the system prompts for prescription details at billing
- Schedule H1 requires more detailed records — patient name, age, and prescriber details are captured
- Schedule X (habit-forming substances) has the strictest requirements
The digital dispensing register maintained by GoClixy is compliant with CDSCO requirements. In the event of an inspection, the register is complete, timestamped, and searchable — unlike a handwritten book that may have gaps.
The Financial Case: Numbers That Speak
For a pharmacy with ₹50 lakh in annual purchases:
| Current situation | With batch tracking + FEFO | |---|---| | Expiry write-off: ₹1–2.5 lakh/year | Expiry write-off: ₹10,000–25,000/year | | Distributor returns: minimal (batches missed) | Distributor returns: 70–80% of near-expiry stock | | Stock audit: 1 full day per month | Stock audit: 2–3 hours per month |
The reduction in write-offs alone — typically 70–90% within the first year — pays for pharmacy management software many times over.
→ Explore GoClixy's Pharmacy Module →
Frequently Asked Questions
What causes drug expiry losses in Indian pharmacies? No batch tracking, FIFO instead of FEFO dispensing, no proactive expiry alerts, overordering of slow-movers, and missing the distributor return window for near-expiry stock.
What is FEFO in pharmacy inventory? First Expired, First Out — automatically dispensing from the batch with the earliest expiry date. GoClixy implements this automatically at billing, requiring no manual batch selection.
How much can a pharmacy save with batch tracking? Typically 70–90% reduction in expiry write-offs. On ₹50 lakh annual purchases, this can mean saving ₹80,000–₹2 lakh annually.
Can near-expiry medicines be returned to distributors? Yes — most distributors accept returns with 30–90 days remaining. GoClixy's expiry dashboard identifies these batches in time to initiate returns before the window closes.
Does GoClixy track drug schedules too? Yes — Schedule H, H1, and X compliance is built in. The system prompts for prescription details and maintains the CDSCO-required dispensing register automatically.
Ready to Eliminate Expiry Losses at Your Pharmacy?
GoClixy's pharmacy module covers batch tracking, FEFO dispensing, expiry alerts, near-expiry return management, and Schedule H compliance — all in one system.
Start Free — No Credit Card Required →
Also read: Medical Store Software — Schedule H, GST, and Counter Billing · Diagnostic Lab Sample Tracking and WhatsApp Reports