The way to stop expiry losses and stock-outs in a hospital pharmacy is batch-wise, expiry-dated inventory with FEFO (first-expiry-first-out) dispensing, automatic reorder levels and near-expiry alerts. When every purchase, issue and return updates stock in real time, the pharmacist knows exactly what is on the shelf, what is about to expire and what to order — before a patient is turned away or a carton is written off.
Why Hospital Pharmacies Bleed Money
Pharmacy is often the largest inventory holder in a hospital, and losses hide in plain sight:
- Expired stock: slow movers bought in bulk for a scheme discount quietly age past their date.
- Stock-outs of fast movers: patients sent to outside chemists means lost revenue and lost trust.
- Untracked returns: IPD ward returns that never re-enter saleable stock.
- Free-schemes and bonus stock confusion: received quantities not matching invoiced quantities.
- Pilferage: without perpetual inventory, shrinkage is discovered only at annual stocktake.
The Inventory Controls That Fix It
Batch and expiry tracking on every unit
Record batch number, expiry date and MRP at goods receipt (GRN). Every sale then draws from a specific batch, so the system can enforce FEFO and block dispensing of expired stock entirely.
Near-expiry alerts and vendor returns
Configure alerts at 90, 60 and 30 days before expiry. Move near-expiry stock to the front counter, transfer it to high-consumption wards, or raise a purchase return to the supplier while it is still returnable under your credit terms.
Reorder levels based on real consumption
Set minimum, maximum and reorder quantities per item from actual consumption history, not guesswork. The system should generate a suggested purchase order daily, which the pharmacist reviews and sends to approved vendors.
Prescription-linked dispensing
When OPD and IPD prescriptions flow electronically into the pharmacy queue, dispensing errors drop and every issue is tied to a patient and a bill. Integration with the OPD and IPD modules also means ward indents and returns adjust both stock and the patient account automatically.
Scheduled drug compliance
Schedule H, H1 and narcotic items need prescription references and dedicated registers. Software should maintain these registers automatically from dispensing data, ready for drug inspector audits.
Cycle Counts Beat Annual Stocktakes
Instead of shutting the pharmacy once a year, count a small set of items every week — fast movers weekly, mid movers monthly, slow movers quarterly. Variances get caught within days, and the year-end audit becomes a formality. Your HMS should print count sheets and post adjustments with an audit trail.
Frequently Asked Questions
What is FEFO and why does it matter in pharmacy?
FEFO means first-expiry-first-out: the batch expiring soonest is dispensed first regardless of when it was purchased. It is the single most effective rule against expiry losses, and software can enforce it automatically at the billing counter.
How do I set reorder levels for medicines?
Start with average daily consumption multiplied by supplier lead time in days, plus a safety buffer for demand spikes. Review quarterly, because consumption patterns shift with seasons and doctor prescribing habits.
Can pharmacy software handle GST and multiple MRPs per item?
Yes. Because different batches of the same medicine carry different MRPs and GST applies at defined rates on pharmaceutical goods, batch-wise inventory with per-batch MRP and tax mapping is essential for correct billing and GST returns.
Take Control of Pharmacy Stock with Healthixio
Healthixio's medical store and pharmacy module delivers batch-wise stock, FEFO dispensing, expiry alerts, auto purchase suggestions and GST-ready billing, fully integrated with OPD, IPD and accounts. Request a demo or call 07513135857 to see it with your own formulary.