One inventory record, one truth

In many clinic pharmacies there are two versions of the stock. One lives in the register or spreadsheet. The other lives on the shelf. Every dispensing, return, delivery and expiry is a chance for them to drift apart, and they usually do.

The result is familiar: a medicine shows in stock but cannot be found, a batch expires unnoticed, or an order is placed for something already on the shelf. None of these is caused by carelessness. They are caused by recording stock in a different place from where it moves.

Where the drift comes from

Dispensing is recorded later. Medicines leave the shelf during a busy session and are written up afterwards, if at all.

Batches are not tracked at the counter. The register knows a medicine’s total but not which batch was given, so expiry dates become guesses.

Returns and damages go unrecorded. Small corrections are made on the shelf and never reach the register.

Deliveries are booked in bulk. A delivery is added as one number without its batches and expiry dates.

Make dispensing the record

The fix is to make the act of dispensing update the stock at the same moment. When a prescription arrives from the doctor, the pharmacist selects the batch, dispenses and the stock is reduced in one step. There is no second place to update later, so there is nothing to forget.

This works best when the prescription arrives electronically from the signed consultation. The pharmacist is not retyping the prescription, so the quantity, strength and form match what was prescribed.

Track the batch, not just the item

Expiry is a property of a batch, not of a medicine. Record each delivery with its batch number and expiry date, and dispense from a named batch. With that in place, the system can tell you which batches expire this month and suggest dispensing the earliest-expiring stock first.

Let status be calculated

Statuses such as in stock, low stock, out of stock and expiring soon should be calculated from the numbers, not typed in by hand. A manually set status is accurate only until the next dispensing. Set thresholds per medicine, based on how quickly each one moves.

Check safety at the same time

A single record also makes safety checks reliable. When the pharmacy sees the same patient record as the doctor, allergy and interaction checks use current information rather than whatever was written on the prescription slip.

Count less often, trust more

Physical counts never disappear, but with one record they become a check rather than a rescue. Count a few high-value or fast-moving items each week instead of everything once a quarter. When the count and the record disagree, the difference is small and easy to trace.

Getting there

Record batch and expiry for every new delivery from now on.

Dispense from the record at the moment of dispensing, not afterwards.

Set reorder thresholds for your twenty fastest-moving medicines first.

Replace the full quarterly count with small weekly counts.

One record does not make a pharmacy perfect. It makes its mistakes visible while they are still small.