Expiry is the hardest part of running a pharmacy

Ask a pharmacy owner where their money goes and you will hear about rent, staff and distributor margins. Ask what keeps them up, and eventually you get to the shelf of stock that is about to become worthless.

Expired stock is a strange kind of loss. The money left the business months ago, when the purchase order was raised. Nothing goes wrong at the moment of expiry — no alarm, no missing cash. The loss is quiet, it is discovered late, and by then there is nothing to do about it.

Why it is hard to see coming

The obvious answer is that nobody is looking. That is almost never true. The people running a counter know their fast movers precisely. The problem is structural.

• The same product has many expiry dates. A box of paracetamol bought in Baisakh and another bought in Shrawan are the same product on the shelf and two completely different risks. A system that tracks “paracetamol: 240 units” cannot tell you which of those units is a problem.
• The risk is concentrated in slow movers. Fast movers rarely expire; they sell through. The stock that expires is the item you bought because a customer asked once, and which nobody has thought about since. It is invisible precisely because it is quiet.
• The warning window is long and then suddenly short. Six months out, a distributor will usually take stock back. Six weeks out, they will not. Most pharmacies discover the problem inside the window where the only options are discount or write-off.
• Nobody owns the check. Physically walking the shelves reading date panels is a half-day job. It gets scheduled, then it gets postponed, because there is always a customer at the counter.

What a system has to know

Warning someone in time is not a reporting problem. It is a data-modelling problem, and it is decided at the point of purchase entry, not at the point of the report.

The system has to record the batch and its expiry date when stock arrives, keep quantities against that batch rather than against the product, and decrement the right batch on sale. Without those three things, no amount of dashboard will produce a trustworthy warning — you will get an alert on a product you have already sold through, and silence on the one you have not.

Once the data is right, the useful output is not a list. It is a short, ranked answer to a specific question: what is expiring in the next 90 days, sorted by how much money is in it, that is not moving fast enough to sell through? Ten lines a manager can act on beats four hundred lines they will not read.

Acting on it early

The window matters more than the report. Ninety days out, a pharmacy has real options: return to the distributor under the terms already agreed, transfer to a branch that moves that item faster, bundle it, or discount it while a discount still leaves margin. Thirty days out, all of those are gone and the only remaining question is how much of the cost to eat.

This is why Stock Sewa Pharmacy tracks expiry at the batch level rather than treating it as a field on the product record. It is more work to enter and considerably more work to build. It is also the only version of the feature that tells the truth.