Business

Pharmacy Stock: Batches, Expiry and the Money on the Shelf

K By Kev 5 November 2026 Updated 7 November 2026 12 min read
Share
Business guide

Pharmacy stock is not retail stock with different labels on it. The same product arrives repeatedly in batches with different expiry dates, some of it cannot be sold without a prescription, and the records have to show not just how much you hold but which batch, received when, expiring when, dispensed by whom. A system that tracks quantity alone will tell you that you have forty units and nothing about whether twelve of them are worthless next month.

Key takeaways
  • The same product arrives in batches with different dates; one expiry per product is wrong immediately.
  • Expiry is not a risk, it is a certainty on a known date — the question is whether you see it in time.
  • Set the warning window by your supplier's return terms, not by a default.
  • First-expiry-first-out only holds if the system puts the right batch in front of the server.
  • Dispensing records are cheapest to produce as a by-product of individual staff logins.
On this page▾
  1. Quantity is the wrong unit
  2. What to put in place
  3. Where pharmacy stock control fails
  4. A worked example: the twelve units nobody saw
  5. How Veira handles it
  6. Frequently asked questions

Quantity is the wrong unit

Track a product and you know a number. Track a batch and you know a number with a date and an origin attached, which is the only form in which the number is useful. Forty units expiring across three different months is four different commercial situations depending on how they are distributed.

Expiry is the loss that makes this concrete. It is not a risk; it is a certainty on a known date, and the only question is whether you see it in time to sell the stock, return it or move it. Seen three months out it is a decision. Seen at the counter it is a write-off.

Then there is the part retail does not have at all: dispensing records. What was dispensed, against what, by which member of staff. That is a record the Pharmacy and Poisons Board expects, and it is far easier to produce as a by-product of serving customers than to assemble afterwards.

Want to see it running in your own business first?

Sign Up

What to put in place

Five things, in the order they pay back.

  1. 1

    Capture the batch and expiry at receiving

    This is the step everything else depends on and the one most often skipped because it slows the delivery down. Stock received without its batch cannot be tracked by batch later, no matter what the system is capable of.

  2. 2

    Deduct on the sale, automatically

    A figure typed in by a person is right on the day it was typed. A figure that moves with each sale is right continuously, which is what makes the expiry warning meaningful: what stock software has to do.

  3. 3

    Set the warning window to your return terms

    If a supplier takes returns up to three months before expiry, a warning at four weeks is a warning that arrives after the option has closed. The window should be set by what you can still do about it.

  4. 4

    Sell the oldest batch first, and make it the default

    First-expiry-first-out is the rule, and it only holds if the system puts the right batch in front of the person serving. Left to the shelf, the newest delivery goes at the front.

  5. 5

    Count in sections, while trading

    A full annual count tells you something went wrong in twelve months. A section counted weekly tells you what went wrong in a week, to someone who still remembers it: pharmacy POS.

Where pharmacy stock control fails

Running expiry on a spreadsheet beside the POS

It is accurate for as long as someone maintains it, which is until the shop gets busy. That is the same weakness as counting by hand, moved to a different file.

Tracking the product, not the batch

A single expiry date per product is wrong the moment the second delivery arrives, and it is wrong in the direction that lets stock expire quietly.

Receiving stock without checking it in

Goods on the shelf that were never received are stock the system does not know about, and the variance they create looks exactly like theft.

Treating a variance as a typing error

The gap is the finding. A recurring variance on one line is breakage, mis-receiving, a pricing error or theft, and correcting the number discards the only evidence of which.

Ordering by looking at the shelf

Gaps show you what ran out, including lines that ran out because you only ever had two. Order from what sells, not from what is missing.

A worked example: the twelve units nobody saw

Worked example

A pharmacy in Mombasa held a slow-moving but valuable line, reordered occasionally, with stock usually sitting several months. The system tracked quantity and the owner knew roughly what was there.

Three deliveries across a year meant three batches on the shelf, with expiry dates five months apart. Staff served from the front, which is where the most recent delivery had been put.

Twelve units from the oldest batch expired on the shelf behind the newer stock. The system had shown a healthy quantity throughout and had been correct about it. What it could not show was that part of that quantity had a date on it, and by the time anyone looked, the supplier return window had closed months earlier.

Business impact

Stock you cannot see is stock you lose: dead capital sitting on slow shelves, empty shelves on your fast movers, and shrinkage no one can explain.

Veira tracks every item in and out with reorder alerts, so you hold the right stock and losses surface early.

How Veira handles it

Veira holds stock by batch with expiry dates captured at receiving, and deducts on the sale, so the count stays current without anyone maintaining it. Lines approaching expiry surface as a warning rather than as a discovery.

Each member of staff signs in as themselves, so dispensing records name a person as a by-product of serving customers rather than as a separate log.

And selling continues when the connection does not, which for a pharmacy is not a convenience: you cannot stop dispensing while a network comes back, and the eTIMS invoices queue and transmit on reconnect rather than being skipped.

Frequently asked questions

Why track by batch rather than by product?
Because the same product arrives repeatedly with different expiry dates, so a single date per product is wrong from the second delivery onwards. Batch-level tracking is what lets the system warn you while the stock is still sellable or returnable.
How far ahead should the expiry warning be?
Set it by what you can still do about it. If a supplier accepts returns up to three months before expiry, a four-week warning arrives after the useful option has closed. The window should match your return terms, not a default.
How often should a pharmacy count?
In sections, weekly or fortnightly, while trading. The point is that a variance is still explainable by someone who was there. An annual count establishes that something went wrong over a year without telling you what or when.
Can I manage expiry on a spreadsheet?
Until the shop is busy. A spreadsheet is accurate for exactly as long as somebody maintains it, which makes it the same weakness as counting by hand in a different file. The figure has to move with the sale to stay true.
What dispensing records are expected?
What was dispensed, against what, and by whom. The practical point is that this is far easier to produce as a by-product of serving customers, through individual staff logins, than to assemble afterwards from memory and paper.
What should I do about a recurring variance?
Investigate the line rather than correct the number. A gap that repeats on one product is breakage, mis-receiving, a pricing error or theft, and the number is the only evidence you have of which one.

A pharmacy's stock problem is a dates problem wearing a quantities costume. Capture the batch at receiving, let the figure move with the sale, set the warning window to what you can still act on, and count in sections while the answers are still findable.

Need help, or want to talk it through first? Chat with us on WhatsApp

Keep reading

See all Business guides

Veira for your business

Want the full picture for this trade? Veira for pharmacies and chemists covers the counter, the stock and the KRA side together.

Browse Veira by business type · Who we serve