The verdict in three sentences
Losses from expired medication are a significantly underestimated cost line for independent pharmacies, often invisible until a full physical stocktake happens. Manual tracking detects expiry on the day itself — too late to act — while software with automated alerts flags the problem 90 days ahead. The 2026 result: an annual loss rate that drops from 4-7% to 1-2% of stock value, with an average payback period of 5 to 8 months.
The real cost of undetected expiry
A neighborhood pharmacy in Kenya or Nigeria typically manages stock worth the equivalent of 15 to 40 million FCFA, spread across several hundred SKUs. Without an alert system, expiry is usually only caught during a physical stocktake — often quarterly or annual — well past the optimal window to move the product.
| Tracking method | Expiry detection | Annual loss rate | Monthly stocktake time |
|---|---|---|---|
| Paper ledger | At day-0 (expiry day or after) | 6-7% of stock | 8-10 hours |
| Manual Excel sheet | Day-15 to day-0 | 4-5% of stock | 6-8 hours |
| Software with day-90/day-30 alerts | Day-90 (early warning) | 1-2% of stock | 1-2 hours |
The loss is not limited to the destroyed product's value: it also includes opportunity cost (shelf space occupied by a product that will never sell) and regulatory risk (accidentally dispensing an expired product, with possible penalties).
What a day-90 alert actually changes
A day-90 alert window leaves three months to act: targeted discounting, supplier return where the contract allows it, or transfer to a faster-turnover branch.
| Alert window | Possible actions | Value recovery rate |
|---|---|---|
| Day-90 | Discount, supplier return, transfer | 70-85% of product value |
| Day-30 | Aggressive discount only | 30-50% of product value |
| Day-0 (expired) | Mandatory destruction | 0% |
Mini case study
Chidinma, a pharmacy owner in Lagos, manages stock valued at the equivalent of 22,000,000 FCFA. On a paper ledger, her annual stocktake reveals a 6% loss to unsold expired products — the equivalent of 1,320,000 FCFA in destroyed medication. After investing the equivalent of 900,000 FCFA in inventory software with automated alerts, she now gets day-90 notifications for every batch approaching its expiry date, letting her run targeted discounts or return certain batches to the wholesaler. Her annual loss rate drops to 1.5%, or 330,000 FCFA — a saving of 990,000 FCFA a year, paying back the initial investment in just under 11 months in year one, then generating a net saving every year after.
FAQ
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Does pharmacy software replace a pharmacist for quality control?
No — it remains a decision-support tool: it flags at-risk batches, but physical verification and the removal decision remain the licensed pharmacist's responsibility.
How long does initial setup take?
Entering existing stock with expiry dates typically takes 2-4 weeks for an average pharmacy, often done gradually during order receiving rather than all at once.
Does the software work without a stable internet connection?
The best 2026 solutions work offline with deferred sync, suited to areas with intermittent 3G/4G coverage.
What's the real time saving on monthly stocktakes?
An average of 6 hours saved per month compared to manual tracking, thanks to automatic stock-movement counting instead of a full physical recount.
Does the 600,000-1,500,000 FCFA-equivalent cost include staff training?
It depends on the vendor; it is recommended to require initial training in the quote, since team adoption largely determines the real return on investment.
Let's talk about your project. We can run a free assessment of the savings potential of inventory software tailored to your pharmacy. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.

