The sticker dots and the rota nobody follows
Somewhere there is a date checking rota. Section A in week one, section B in week two, and so on around the dispensary. There may be coloured dots on the boxes that expire soonest. For a month or two after someone new takes it on, it works.
Then a locum week happens, or a busy flu season, and the rota slips. Nobody is sure which sections were done. A checker picks up a pack during a final check and it has expired last month. Everyone goes quiet and somebody spends the evening working through the shelves.
The other version is quieter and costs more: a pack that could have been used in the next few weeks, or sent back for credit, is found only after its date. It goes into the waste bin.
Why a rota alone does not hold
The job is large and the progress is invisible. Checking a section properly means handling every pack, reading small print and moving the soonest dates forward. If you are interrupted halfway, there is no record of where you stopped.
The information about expiry dates is also collected once, at the point of delivery, and then lost. Many wholesalers now print or transmit expiry and batch details, and some packs carry a 2D barcode with the expiry encoded, but that information rarely makes it into anything the pharmacy can search.
So each check starts from nothing. The same packs are handled every few months whether they expire next year or next week.
What late-found stock costs
| Missed date | Cost to the pharmacy |
|---|---|
| Expired on the shelf | Stock written off and sent for disposal |
| Found at final check | Rework, delay and a near miss on the log |
| Found too late to return | Credit that was available is lost |
| Rota gaps | Nobody can show which sections were checked, and when |
| Slow movers | Packs ordered in a rush that never get used |
The waste itself is only part of it. The anxiety of not being sure the shelves are clean is what makes pharmacists stay late.
A date tracker that does the remembering
What we build is simple enough to use on a busy day. The parts:
- Expiry capture at goods-in. Where packs carry a 2D barcode, a scanner reads the expiry and batch as the tote is put away. Where they do not, the date can be typed or read from the wholesaler's data if they supply it.
- Shelf locations, set up once, so each pack is linked to a section of the dispensary.
- A short-dated list, refreshed daily, showing every pack expiring within your chosen window, where it is and how much is left. This is what you act on: use it first, move it to a branch that uses more, or check whether it can be returned.
- A rota in small pieces. Instead of a whole wall once a quarter, the tracker hands each shift a small section to check, and records who checked it and when. Sections with nothing short-dated can be checked less often, if your procedures allow.
- A dispensing prompt, optional, that flags a short-dated pack when it is scanned at labelling, so it goes out first where that is appropriate.
- A slow mover report showing packs that have sat on the shelf a long time, so ordering can be adjusted.
What is appropriate to supply, return or dispose of is your pharmacist's decision under your procedures. The tracker makes sure the question is asked early enough to have options.
What changes on the shelves
Short-dated packs stop being a surprise. They appear on a list weeks ahead, when there is still time to use them, transfer them or ask the wholesaler about a return. The rota becomes a few minutes a shift rather than a dreaded afternoon, and there is a record showing that it happened.
Over time the slow mover report changes your ordering. The lines that always end up short-dated are the ones you stop buying in bulk.
Is your date checking slipping?
- Your date checking rota exists but you are not sure it is followed
- Expired packs have been picked up at final check
- You find short-dated stock only after the return window has passed
- Nobody can say which shelf sections were checked last month
- Date checking is saved up for quiet days that never come