Hospital Pharmacy Management Software: Inventory, Batch & FEFO Explained

A hospital pharmacy is not a retail chemist. It serves OPD patients, wards and operation theatres, handles controlled drugs, and must connect every dispensed item to a patient and a bill. Hospital pharmacy management software is the module that manages purchase, stock, batches, expiry, dispensing and billing for all of that, inside a Hospital Management System.

The central ideas are the batch and the expiry date. The same medicine arrives in different batches with different expiry dates and prices. The software must know exactly which batch left the shelf.

• Expiry write-offs: Stock that expires on the shelf is pure loss. Batch-aware software shows what will expire before it does.
• Stock-outs: Running out of a critical medicine in a ward is a clinical risk, not just an inconvenience.
• Unbilled medicines: Medicines issued to wards or OT without entry never reach the bill.
• Compliance: Schedule H and Schedule X drugs require records of patient, doctor and batch.

1. Purchase order: Re-order thresholds trigger requisitions to suppliers from the supplier catalogue.
2. Goods receipt (GRN): Received stock is entered with batch number, manufacture and expiry dates, MRP and cost price.
3. Storage and tracking: Each batch is a separate stock line with quantity on hand.
4. Prescription arrives: The pharmacist sees the doctor's digital prescription in a worklist.
5. FEFO dispense: The system proposes the batch with the nearest expiry that is still safe to dispense.
6. Billing link: The dispensed items post to the patient's bill automatically.
7. Reports: Near-expiry lists, fast and slow movers and reorder suggestions.

FEFO matters because arrival order and expiry order often differ. For a deeper treatment of the mechanics, read our guide on mastering FEFO inventory, and see how FEFO prevents inventory losses.

• Batch, expiry, MRP and purchase cost per stock line
• FEFO-sorted dispensing worklist with real-time stock locking
• Re-order levels and low-stock alerts
• Purchase orders, requisitions and GRN
• Schedule H and Schedule X register with doctor, patient and batch details
• Return to supplier and expiry-return handling
• Direct posting of dispensed items to OPD and IPD bills
• Ward and OT issue tracking, not just counter sales

Track these before and after go-live: value of stock expired per month, number of stock-outs reported by wards, medicines dispensed vs medicines billed, and time taken to answer an audit query about a controlled drug. Each is easy to measure and does not rely on vendor claims.

1. Tracking stock by product, not batch. You will never know what is about to expire.
2. Separate retail pharmacy software. Sales do not reach the hospital bill.
3. No ward or OT issue process. Items leave pharmacy with a verbal promise to bill later.
4. Manual controlled-drug registers. Easy to miss and hard to audit.
5. Ignoring return windows. Many suppliers accept near-expiry stock only before a deadline; software should surface that list early.

The heaviest task is the opening stock: every product with its batch, expiry and quantity must be entered or imported correctly. Do a physical count before migration. Agree the reorder levels with the pharmacy head, and assign who may issue stock to wards. Pharmacy is usually part of a module bundle; see HMS pricing.

QureSetu's FEFO dispensing worklist automatically sorts batches by nearest expiry and locks stock in real-time transactions. Purchase orders, requisitions and GRN feed a batch-level stock ledger, and the Schedule H and X register records the doctor, patient and batch for every controlled sale. Every dispense posts to the patient's bill. See the hospital pharmacy management page for more.

How does HMS manage pharmacy inventory? It records stock by batch with expiry dates, deducts stock when items are dispensed, alerts on low stock and near-expiry items, and posts each dispense to the patient's bill.

What is FEFO in hospital pharmacy? FEFO stands for first expiry, first out. The batch closest to expiry is dispensed first, regardless of when it arrived, to reduce expired stock.

Can pharmacy software work with the doctor's prescription? Yes. In a connected HMS, a prescription written in OPD or on ward rounds appears in the pharmacy worklist without printing or re-typing.

Does it support Schedule H and Schedule X records? It should keep a register capturing the doctor, patient and batch for each controlled sale. Ask to see the report in the demo.

Want your pharmacy stock and bills in one system? Book a Free HMS Demo and watch a prescription flow from the doctor to FEFO dispensing to the bill.