
Medicine Batch and Expiry Tracking: How Pakistani Pharmacies Can Cut Expired Stock
In short: Expired stock in a pharmacy is rarely bad luck. It builds up when batch numbers and expiry dates are not recorded at receiving, when older stock is not sold first, and when nobody reviews near-expiry items while they can still be returned or sold. A simple routine of recording every batch, selling first-expiry-first-out, reviewing near-expiry stock every week and acting on it early can cut this loss sharply, whether you work on a register or in software.
Every medical store owner knows the feeling of finding a carton of tablets that expired two months ago at the back of a shelf. That money is gone, and in Pakistan an expired medicine cannot simply be sold off at a discount. This guide explains why expired stock builds up, what the law says, and a practical 10-step routine that independent pharmacies and small chains can start this week.
Why expired stock builds up in a pharmacy
The causes are usually the same in every store:
- Batch and expiry are not recorded when stock arrives. If the purchase entry only says “Panadol 20 boxes”, nobody can later find out which boxes expire first.
- New stock is placed in front of old stock. Staff fill the shelf from the front, so the older batch sits at the back until it expires.
- Over-buying on schemes and bonuses. A distributor’s bonus offer looks good until half the quantity is still on the shelf near its expiry date.
- Slow movers are nobody’s job. Fast-selling items are watched every day, but slow items are only noticed during the yearly count.
- Return windows are missed. Many distributors accept near-expiry returns only within terms they set, and those terms pass quietly when nobody is checking.
- Branches do not talk to each other. One branch has excess of a medicine that another branch is short of, but neither knows.
- Pharmacy reorder level and min-max stock
What the law says about expired medicines
Under Section 23(1)(a)(vi) of the Drugs Act, 1976, no person may sell any drug after its expiry date. In practice this means expired stock must be taken off the shelf and kept away from saleable stock, and it cannot be cleared by discounting it. Provinces also have their own drug rules and inspectors, and the Drug Regulatory Authority of Pakistan (DRAP) has issued guidance on storing and disposing of recalled and substandard products. Before you dispose of expired or recalled medicines, check the current requirements with your distributor and your local drug inspector. (Law reference checked on 7 November 2026.)
FEFO, not just FIFO
Most shops know FIFO: first in, first out. For medicines the better rule is FEFO: first expiry, first out. A batch that arrived last week can expire earlier than a batch that arrived last month, for example when a distributor sends older stock. FEFO means you always sell the batch with the nearest expiry date first, regardless of when it arrived. If you want to understand how this relates to stock valuation in your books, see our guide on FIFO vs weighted average in Pakistan.
A 10-step routine to reduce expired stock
- Record batch and expiry at receiving. Every purchase entry should carry the batch number and expiry date for each line, checked against the box, not just the distributor’s bill.
- Set a minimum shelf life you will accept. Decide how much remaining life a medicine must have when it arrives, and refuse or question short-dated deliveries before you sign for them.
- Get return terms in writing. For each distributor, note whether they take back near-expiry or expired stock, how close to expiry, and in what form (credit note, replacement or nothing).
- Arrange shelves by FEFO. Put the nearest-expiry batch at the front and new stock behind it. Make this part of every restocking job, not a one-time clean-up.
- Sell by batch at the counter. When the bill records which batch was sold, your stock record matches the shelf, and a recall can be traced in minutes.
- Use near-expiry warning windows. Choose warning points that suit your returns terms and sales speed, for example 90, 60 and 30 days before expiry, so every item gets a chance to be sold, returned or moved.
- Review near-expiry stock every week. Fix one day a week when the owner or manager looks at the list and decides what happens to each item.
- Act early: return, transfer or stop reordering. Return what the distributor will accept, move stock to a branch that sells it faster, and stop buying that item until the old batch is cleared.
- Quarantine expired stock. Remove it from the shelf on the day it expires, keep it in a clearly marked “not for sale” area, and record it so it cannot be billed by mistake.
- Measure the loss every month. Record the value of every expired or written-off item. Seeing the monthly figure, and which items and suppliers cause it, is what changes buying habits.
Register or Excel vs pharmacy software
All of these steps can be done on paper. The question is how much time they take and how often they get skipped on a busy day.
| Task | Register or Excel | Pharmacy software |
|---|---|---|
| Recording batch and expiry | Written by hand or typed separately, often skipped | Entered once with the purchase and kept with the stock |
| Selling the right batch | Depends on staff memory | The bill deducts a specific batch |
| Finding near-expiry items | Someone walks the shelves | A near-expiry report or alert |
| Recall of a batch | Search through bills and registers | Search the batch number |
| Monthly expiry loss | Rarely calculated | Taken from write-off records |
If you are comparing options, look for pharmacy POS software that stores stock at batch level, lets you set your own expiry warning periods, records returns to distributors against the original batch, and works across branches. Ask the vendor to show you these screens in a demo using your own medicines, not just a sample list.
Monthly expiry checklist
- Every purchase this month has batch and expiry entered for each line.
- Shelves were rearranged by FEFO when new stock arrived.
- The near-expiry list was reviewed every week, with a decision for each item.
- Returns to distributors were sent before their deadlines, and credit notes were received and recorded.
- Expired stock is out of the saleable area and recorded.
- The month’s expiry loss is totalled, with the top five items and suppliers noted.
- Reorder quantities for slow-moving items were reduced where needed.
Want to see batch and expiry tracking on your own stock?
Switcher Techno’s pharmacy software records batch numbers and expiry dates at purchase, deducts the right batch at billing and gives you near-expiry reports, with local support from Karachi and Lahore. Book a free demo and bring a list of your slow-moving medicines.
Frequently asked questions
Can a pharmacy in Pakistan sell expired medicine at a discount?
No. Section 23(1)(a)(vi) of the Drugs Act, 1976 prohibits selling any drug after its expiry date. Expired stock should be removed from the shelf, kept separately and handled according to your distributor’s terms and local drug rules.
What is the difference between FIFO and FEFO?
FIFO sells the stock that arrived first. FEFO sells the batch with the nearest expiry date first. For medicines FEFO is safer, because a newer delivery can sometimes expire earlier than older stock.
How often should a pharmacy check near-expiry stock?
A weekly review works well for most medical stores. Use warning windows such as 90, 60 and 30 days before expiry, adjusted to your distributors’ return terms and how fast each item sells.
Will distributors take back near-expiry medicines?
It depends on the distributor and the company. Some give credit or replacement within set terms, others do not. Agree the terms in writing when you open the account and track deadlines so returns are not missed.
Can I track batch and expiry in Excel?
Yes, if every purchase line is entered with batch and expiry and someone filters the sheet every week. The weakness is that sales are not deducted by batch, so the sheet drifts away from what is on the shelf.
What should I look for in pharmacy software for expiry control?
Batch-level stock, batch selection at billing, near-expiry reports with warning periods you can set, distributor returns linked to the batch, and stock visibility across branches. Ask to see these in a demo with your own items.
This article is general business guidance for pharmacy owners. It is not legal or medical advice. Drug rules can change and differ by province, so confirm current requirements with DRAP, your provincial drug authority or a qualified adviser. Law reference checked and published 7 November 2026.
