The true cost of expired stock

For the average pharmacy in Kenya, expired stock represents 2–5% of annual inventory value. On a pharmacy turning over KES 5 million in stock per year, that's KES 100,000–250,000 simply written off. Not because of theft or bad purchasing decisions — just because nobody caught the expiry dates in time.

The problem compounds across branches. What's sitting at branch B might have expired while branch A ran out of the same item last month. The right item, wrong place, wrong time.

Strategy 1: Enforce FIFO (First In, First Out)

FIFO is the foundation of pharmacy stock management. Items that arrived first should be sold first. Sounds obvious, but it breaks down in practice — especially when new stock is placed in front of old stock on shelves, or when the POS doesn't enforce which batch gets dispensed.

Discipline is part of this, but so is your system. If your POS doesn't track batches, it can't enforce FIFO. An ERP with batch tracking means the system automatically selects the oldest batch for each sale.

Strategy 2: Set reorder levels intelligently

Over-ordering is one of the main causes of expired stock. If you're ordering 3 months of slow-moving drugs at a time, you're taking on unnecessary expiry risk.

Set reorder levels based on actual consumption rates — not gut feel. Review them quarterly as sales patterns change. For slow-moving items, order smaller quantities more frequently, even if the unit cost is slightly higher.

Strategy 3: Use expiry date alerts

Manual expiry checks — someone walking the shelves with a clipboard — are unreliable and time-consuming. They happen monthly at best, weekly if you're disciplined. But drugs can expire in the gap.

An automated alert system checks expiry dates every day. It notifies you 90, 60, and 30 days before expiry so you have time to act — return to the supplier, run a promotion, or transfer to a higher-volume branch.

Strategy 4: Negotiate return policies with suppliers

Many pharmacies don't realise that some suppliers will accept returns of near-expiry stock — especially for branded products. This isn't universal, but it's worth negotiating into your supplier agreements upfront, especially for slow-moving or seasonal items.

Having clear batch and purchase records (which an ERP provides automatically) makes these negotiations much easier. You can show exactly when stock was received and what the remaining shelf life was.

How SparkERP handles this automatically

SparkERP tracks batch numbers and expiry dates for every item received into the system. Here's what happens automatically:

Expiry alerts: You receive notifications at 90, 60, and 30 days before any batch expires.
FIFO enforcement: The POS and dispensing interface automatically selects the oldest available batch.
Near-expiry reports: One-click reports show everything expiring in the next 30, 60, or 90 days — across all branches.
Supplier return tracking: Log returns against specific batches for accurate financial records.

The bottom line

Reducing expired stock losses isn't just about discipline — it's about having systems that make the right behavior automatic. When your software tracks batches, enforces FIFO, and alerts you before expiry, the chance of stock being written off drops dramatically.

If you'd like to see how SparkERP's inventory and batch management works in practice, book a free walkthrough. We'll show you the expiry tracking and alert system with real sample data.

How to Reduce Expired Stock Losses in Your Pharmacy