Medicine Stock, Batches and Expiry: A Practical System for Clinics

Clinic pharmacies and dispensing counters tend to run on a mixture of memory and habit. Someone notices a box is nearly empty and mentions it. Someone else orders. A carton arrives and goes on a shelf. Occasionally a stock-take reveals four strips of something nobody remembers ordering, expiring next month, alongside an empty space where the item everyone actually uses should be.

None of that is negligence. Stock control is genuinely fiddly work with no immediate reward — nobody thanks you for the emergency drug that was in date when it was needed. But the cost of getting it wrong is real: money tied up in slow-moving items, money thrown away at expiry, and the occasional uncomfortable moment when a patient is sent to an outside chemist for something the clinic should have had. This article sets out a system a small practice can actually maintain.

Decide what you are actually tracking

The first mistake is trying to track everything. A clinic that attempts to maintain perpetual inventory on cotton, gloves, syringes, every sample pack and every consumable will abandon the effort within a month.

Start with the items where being wrong has consequences: injectables and emergency drugs, anything you dispense in volume, anything expensive, and anything with a short shelf life. Cheap high-turnover consumables can be managed with a simple visual system — two bins, reorder when the first empties — without individual record-keeping. Being deliberate about which items justify tracking is what makes the system survivable.

Batch and expiry are the whole point

Tracking a quantity alone tells you how much you have. It does not tell you how much of it will still be usable in three months, and that is usually the more important question.

Every inward entry should carry the batch number and expiry date from the pack. This matters for three reasons. It lets you dispense oldest-first rather than whatever is nearest the front of the shelf. It lets you see what is about to expire while there is still time to use it. And if a batch is ever recalled by the manufacturer or the regulator, you can answer the only question that matters — do we have any, and did we dispense any — in seconds rather than by emptying every drawer.

That third scenario is rare and is exactly why people skip the discipline. It is also the one where the absence of records is least forgivable.

First expiry, first out

The retail habit is first in, first out. For medicines the correct rule is first expiry, first out, and they are not always the same thing. A later-purchased batch may carry an earlier expiry, particularly with items bought from different suppliers or in a bulk offer.

In practice this means the person dispensing needs to know which batch to reach for, and shelves should be arranged so that the answer is obvious rather than something to be worked out. Physical arrangement and record-keeping have to agree; a system that says one thing while the shelf says another will be ignored within a week, and rightly so.

Reorder levels turn a memory task into a checklist

"We are running low on that" is a report that arrives too late roughly half the time. A reorder level is simply a number below which an item should be ordered, set once and then applied automatically.

Setting them is less scientific than it sounds. Take how much you use in a typical week, multiply by how long your supplier takes to deliver, and add a margin for the weeks that are not typical. For an item you use ten of a week with a three-day supplier, a reorder level somewhere around eight is sensible. For an emergency drug you use twice a year and cannot be without, the reorder level is one, and the point is that you are told the moment you drop to it.

What this changes is the nature of the work. Instead of somebody having to remember, the system produces a short list of what needs ordering. Ordering becomes a ten-minute weekly task performed against a list, which is a job that gets done, rather than a background worry, which is a job that does not.

The expiry review nobody schedules

Expiry losses are almost entirely preventable, and they are preventable at ninety days rather than at thirty. An item expiring in three months can often be used up, moved to a busier branch, or in some cases returned to the supplier under their terms. The same item with two weeks left is simply a loss.

A monthly review of everything expiring in the next quarter takes a few minutes if the data exists and is impossible if it does not. Clinics that adopt this habit are usually startled by the size of the first list and find it shrinks rapidly thereafter, because the ordering behaviour that produced it changes once it is visible.

Connect dispensing to the consultation

The gap that undoes most clinic stock systems is that dispensing happens in one place and recording happens in another, if at all. A doctor prescribes, a patient collects at the counter, and the stock record is updated later from memory or a slip — or not updated at all, so the recorded quantity drifts from the real one until nobody trusts it.

The closer dispensing sits to the consultation record, the more likely it is to be captured. If the medicines prescribed at a visit can be issued from stock in the same flow, the deduction happens as a by-product of work someone is doing anyway. That is the only kind of record-keeping that survives a busy Monday.

Stock and prescribing should not contradict each other

There is a related benefit that clinics often notice only after the fact. When the medicines you actually stock are the same list the doctor prescribes from, prescriptions stop containing items the clinic does not have. Patients are not sent away to find something elsewhere, and the front desk is not fielding calls asking for a substitute.

This does not mean restricting a doctor's prescribing to what is on the shelf — plenty of prescriptions should be filled outside, and clinical judgement comes first. It means that where the clinic does dispense, the two lists should be talking to each other rather than maintained separately by different people.

Storage conditions are part of stock control

A batch that has been kept badly is not usable stock, whatever the record says. Cold-chain items are the obvious case — vaccines and certain injectables have a defined temperature range, and a fridge that drifts overnight or loses power during a long cut can quietly compromise everything inside it.

The practical minimum is a thermometer in the fridge that someone reads and writes down twice a day, a note of what to do when the reading is out of range, and a rule that the vaccine fridge holds vaccines rather than lunch. It is unglamorous and it is the difference between a documented cold chain and an assumed one.

The wider point is that expiry is not the only way stock goes bad. Light-sensitive items in a sunny window, a store room that gets very hot in May, or a leaking cupboard will all shorten the real life of what is inside them, and none of that shows up in a quantity column.

Disposal is a separate obligation

Expired and unusable medicines cannot simply go in the general waste. Biomedical waste handling in India is governed by its own rules, and expired drugs, along with sharps and contaminated consumables, have defined disposal routes — typically through an authorised handler with the appropriate documentation.

For stock purposes, the thing to get right is that disposal is recorded as a movement rather than an item quietly vanishing. If ten strips expire and are removed, the record should show ten written off, when, and by whom. That closes the loop: the quantity drops for a reason you can point to, rather than an unexplained gap at the next count.

Worth stating plainly: clinic software is not a waste management system, and it does not discharge any obligation you have under the biomedical waste rules. Your disposal arrangements and paperwork sit with your authorised handler and the relevant pollution control board. What the stock record can do is tell you honestly what left your shelves and why.

Counting: less often, more honestly

Full physical stock-takes are exhausting and consequently rare, which makes them less useful than they appear — a count done twice a year tells you the position twice a year. Cycle counting is more sustainable: a handful of items checked every week, rotating through the list, with high-value and fast-moving items coming round more often.

The purpose of a count is not to prove the records right. It is to find where they are wrong while the reason is still recoverable. A discrepancy found this week usually has an explanation someone remembers. The same discrepancy found in April has no explanation at all, and quietly teaches everyone that the records do not mean anything.

What this looks like when it is working

A clinic with sound stock habits can answer a few questions without a search: what do we have of this item and in which batches, what expires in the next ninety days, what has fallen below its reorder level, and what did we dispense to this patient. The daily overhead of getting there is small — batch and expiry captured on receipt, issues recorded as they happen, a weekly ordering list, a monthly expiry review, and a rotating count.

None of it requires a pharmacist or dedicated stores staff in a small practice. It requires the recording to happen where the work happens, rather than in a separate register somebody has to remember to open.

Where to start

Pick your twenty most important items — the ones where running out or discovering an expiry matters — and set those up properly with batch, expiry and a reorder level. Ignore everything else initially. Run that for a month, get the counting and receiving habits established on a small list, and expand only once it is routine. A short list maintained accurately is worth far more than a complete list nobody updates.

How Healers Tab helps

Healers Tab includes inventory built for clinic dispensing rather than retail. Items carry batches with their own expiry dates, stock movements are recorded as goods come in and go out, and reorder levels flag what needs buying before you run out. Because inventory sits in the same system as consultations, medicines prescribed during a visit connect to the stock you hold, and dispensing is captured as part of the visit rather than in a separate register. Expiry and low-stock views give you the two lists that prevent most losses. For practices looking at clinic inventory management as part of a wider system rather than a standalone package, that integration is the difference between records that stay accurate and records that drift.

Frequently asked questions

Do we need to track batch numbers for everything?

No. Track batches for medicines and anything with an expiry that matters clinically or financially. General consumables can be managed with a simple reorder habit. Trying to batch-track everything is the most common reason clinics abandon stock control altogether.

How do we set a reorder level?

Typical weekly usage multiplied by supplier lead time in weeks, plus a margin for unusual weeks. Review the number after a couple of months against what actually happened — the first guess is usually a little low for fast movers.

How often should we do a physical count?

Rotate a few items every week rather than counting everything twice a year. Frequent small counts find discrepancies while someone can still explain them, which is the only way records stay trusted.

What should we do about items expiring soon?

Review at ninety days, not thirty. At three months an item can often be used, moved to a busier location, or returned under supplier terms. At two weeks the only remaining decision is how to dispose of it correctly.

Tired of finding expired stock at the back of a shelf? Start a free trial of Healers Tab and keep batches, expiry and reorder levels in one place.