Hospital Pharmacy Software: How to Stop Losses from Expired Stock
Expired medicines are one of the quietest losses in a hospital pharmacy. Nobody notices them going out of date until they are found at the back of a shelf. Here is where expiry losses come from in Pakistani hospitals, and how hospital pharmacy software prevents them.
The problem
Why hospital pharmacies lose money to expired medicines
Every hospital pharmacy in Pakistan writes off some expired stock. The real problem is that most cannot say how much, which items, or why. With a manual register, a medicine is just a name and a quantity. The register shows that 200 strips are on the shelf. It does not show that 80 of them expire next month, sitting behind a newer delivery.
Hospital pharmacy software fixes this by tracking every batch separately, from the day it is received to the day it is sold, issued to a ward or returned. Once the system knows each batch's expiry date, it can make sure older stock goes out first and warn you early about stock that will not sell in time.
The five usual causes of expiry losses
- Wrong shelf order. New deliveries are placed in front, so older batches stay at the back until they expire.
- Over-buying. Purchases are based on habit or a supplier's offer, not on real consumption, so slow items pile up.
- Hidden sub-store stock. Medicines issued to wards, OT and emergency are forgotten in cupboards and trolleys.
- Missed supplier returns. Many distributors accept near-expiry returns, but only within their deadline. Without a list, that deadline passes.
- No one is accountable. When expiry is only discovered during the yearly stock count, it is too late to act and too late to find out what went wrong.
The fix
How hospital pharmacy software controls expiry
1. Batch-wise stock from the moment it arrives
At goods receipt (GRN), the store enters the batch number, expiry date and purchase price for every item, or scans them. From then on, stock is never just one number. You can see exactly how many units of each batch you hold and where they are, in the main store, the OPD pharmacy, the IPD pharmacy or a ward sub-store.
2. First Expiry, First Out (FEFO) at the counter
When the pharmacist sells or issues a medicine, the software picks the batch that expires first, automatically. Staff do not have to remember which box is older. This one feature removes the most common cause of expiry: new stock being used before old stock.
3. Near-expiry alerts at 30, 60 and 90 days
A daily list shows every batch expiring in the next 30, 60 or 90 days, with quantity, value and location. That gives the pharmacy manager time to act:
- move slow stock to a busier store or branch,
- tell doctors which equivalent brands are available,
- return stock to the supplier while the return window is still open, or
- stop reordering an item that is not moving.
4. Expired stock is blocked
On the expiry date the batch is blocked. It cannot be sold or issued by mistake, and it moves to a quarantine list for write-off or return. This protects patients as much as it protects your money.
5. Reorder levels based on real consumption
Because every sale and issue is recorded, the software knows how fast each item really moves. Reorder levels and purchase suggestions come from that data, so the hospital buys what it uses instead of what a supplier is pushing this month.
6. Ward and OT sub-stores in the same system
Stock issued from the main store to a ward, OT or emergency stays visible as that sub-store's stock, with the same batch and expiry tracking. Sub-store consumption is recorded against patients, so nothing disappears into a cupboard.
Paper vs software
Manual register vs pharmacy software
| Task | Manual register / Excel | Hospital pharmacy software |
|---|---|---|
| Knowing what expires next month | Physical check of every shelf | Near-expiry list, ready every morning |
| Issuing the oldest batch first | Depends on staff memory | FEFO picks it automatically |
| Stopping sale of expired items | Not possible | Expired batches are blocked |
| Supplier returns | Often missed | Return list by supplier, before the deadline |
| Ward and OT stock | Unknown once issued | Live sub-store stock with expiry |
| Value of expired stock | Known only at year-end count | Write-off report any day |
Getting started
A simple plan for your first month
- Week 1: set up the item master. Link each brand to its generic, strength and unit, and set storage rules for controlled and high-alert drugs.
- Week 2: opening stock count. Count the main store and pharmacy batch by batch, entering expiry dates. Most hospitals find expired or near-expiry stock in this first count.
- Week 3: go live at the counter. Start barcode billing with FEFO, and record all new GRNs with batch and expiry.
- Week 4: add sub-stores and alerts. Bring wards, OT and emergency into the system, and make the near-expiry list part of the pharmacy manager's daily routine.
The same step-by-step approach works for the whole hospital. See our 4-week go-live plan for every department.
How Techohash helps
Techohash Pharmacy & Inventory Software
Our pharmacy and inventory management software includes batch-wise stock, FEFO issue, 30/60/90-day expiry alerts, blocked expired batches, barcode billing, multi-store transfers and full purchase-to-payment control. It runs on its own for a retail or hospital pharmacy, or as part of Techohash hospital management software. There, the doctor's prescription reaches the pharmacy counter directly and charges post to the patient's bill. The inventory, store and procurement module covers the main store and purchasing side.
Techohash has built healthcare software in Islamabad since 2017 and serves 200+ clients. Pricing is published and built for Pakistan, with clinic plans from Rs 1,999 per month and hospital plans from Rs 9,999 per month, plus annual and one-time options. See the pricing section for details. If your pharmacy stock never matches the register, read 5 signs your hospital has outgrown paper and Excel.
FAQ
Common questions
What is FEFO in a hospital pharmacy?
FEFO means First Expiry, First Out. When a medicine is sold or issued, the batch that expires first goes out first, so older stock is used before it expires. Pharmacy software applies FEFO automatically.
How does pharmacy software warn about expiring medicines?
It keeps the expiry date of every batch and produces near-expiry lists, usually at 30, 60 and 90 days, showing quantity, value and store location, so stock can be moved, used or returned in time.
Can the software stop expired medicines being sold?
Yes. On the expiry date the batch is blocked for sale and issue, and moved to a quarantine list for write-off or return to the supplier.
Does it track medicines issued to wards and OT?
Yes. Ward, OT and emergency sub-stores are part of the same system, with their own batch-wise stock, expiry alerts and patient-wise consumption.
Find out how much stock is expiring in your pharmacy
Book a free demo of Techohash Pharmacy & Inventory and get a clear price for your hospital or pharmacy.