Hospital Pharmacy Software: Batch, Expiry & GST Done Right

A hospital pharmacy loses money quietly. Not in one dramatic theft, but in a strip of tablets that expired on the middle rack, a batch sold below its purchase price because the MRP changed, an evening of counter sales billed at the wrong GST rate, and a purchase order raised for stock that was already in the store — just not where anyone could see it.

Pharmacy management software exists to stop those quiet losses. This article covers what a hospital pharmacy system should actually do, cycle by cycle, and the traps that separate software that pays for itself from software that merely prints bills.

The pharmacy is a loop, not a counter

Most pharmacy software gets bought for the visible part — billing at the counter. But the counter is the last step of a loop that starts weeks earlier:

1. Purchase — deciding what to order, from whom, and raising the purchase order.
2. Goods receipt (GRN) — receiving stock against that order, batch by batch, with expiry dates and purchase prices recorded at the door.
3. Placement — putting stock somewhere findable. Rack management means the system knows the shelf, so a new counter hand can locate a slow-moving item as fast as the owner can.
4. Dispensing and sales — issuing against doctors' prescriptions, and counter sales, both billed with HSN codes and GST built in.
5. Reconciliation — what the shelves hold versus what the system says, and what the day's cash and UPI actually add up to.

Software that only does step 4 leaves the losses exactly where they were. The system has to close the loop: what was received, where it sits, what went out, and what that means for the next purchase order.

Batch and expiry: where the money leaks

The single highest-value feature in pharmacy software is unglamorous: batch-wise stock with expiry intelligence.

Every batch received carries its own expiry date and purchase price. From that one discipline flows most of the pharmacy's financial hygiene:

• Near-expiry alerts surface stock while it can still be sold or returned to the supplier — before it becomes a write-off in a stock-taking six months later.
• Correct margins per batch, because the system knows what this specific stock cost, not an average from last year.
• Clean recalls and queries — when a batch is questioned, you can say precisely what came in and what went out.

In iHospital365's pharmacy module, batch and expiry tracking is wired into purchase, stock and billing rather than kept as a separate register — the alert is only useful if it arrives while the stock is still sellable.

GST at the counter, without arithmetic

Medicine billing in India is HSN-coded and GST-rated per item, and a busy counter cannot stop to think about tax. The system should carry each item's HSN and rate on the medicine master, so a counter sale or a prescription dispense produces a compliant invoice by default — cash or UPI, reconciled at day end. The purchase side should record input tax the same way. If your accountant's month-end still starts with a carton of supplier bills, the software is not doing its half of the GST job.

Inside the hospital system, not beside it

A standalone pharmacy package can run a chemist shop. A hospital pharmacy is different in one structural way: its customers are mostly upstairs. That is why pharmacy works best as a module of the hospital system rather than a separate island:

• Prescriptions arrive digitally. Doctors prescribe off the live medicine master during consultation, so the pharmacy dispenses against a legible, structured prescription — no transcription, no guessing a brand name.
• One patient record. What was dispensed appears on the same record as the consultation and the bill, which is what makes queries and follow-ups answerable.
• One financial picture. Pharmacy revenue and stock value land in the same financial reports as OPD and IPD, so the owner sees the whole facility, not three spreadsheets.

What to check before you buy

• Ask to receive a purchase. Watch a GRN entry: does the batch, expiry and price go in at the door, or is stock created loose and "adjusted later"? Later never comes.
• Ask where an item is. Rack management sounds trivial until the regular counter hand is on leave.
• Ask for the near-expiry report. If producing it takes effort, it will not be looked at.
• Check the prescription link. If prescriptions reach the counter on paper, you have bought a billing machine, not a pharmacy system.
• Check the pricing model. Per-user pricing punishes a pharmacy for staffing its counter. iHospital365 is flat per facility per year — pharmacy is included in the Professional plan at ₹24,000/yr or added to Lite for ₹12,000/yr, unlimited staff users, prices exclusive of 18% GST. Details are on the pricing page.

A pharmacy that knows its batches, its racks and its taxes stops leaking. Book a walkthrough and we will run your actual purchase-to-counter cycle on the system — with your medicines, not a demo list.