Guide · 11 min read

Pharmacy inventory management: a practical guide.

A practical method for pharmacy stock control: product setup, receiving, FEFO, reorder levels, counting and the monthly review.

By the poso team · Updated

Short answer

Pharmacy inventory management means knowing what you have, what is expiring and what to reorder, at all times. In practice: set up every product with its unit, pack sizes, cost and whether it is batch-tracked; record batch numbers and expiry dates when stock arrives; sell first-expiry-first-out; set a reorder level for each product; count stock regularly; and review near-expiry stock, slow movers and margins every month.

Stock is usually the largest asset in a pharmacy, and the one most likely to quietly lose value through expiry, theft, damage and errors. Good inventory management is less about software and more about a few habits done consistently. Software makes those habits fast. This guide gives you the method, then shows where tools help.

The four goals

GoalWhat it looks likeWhat goes wrong without it
AvailabilityCustomers find what they came forLost sales, customers going elsewhere
FreshnessNothing past (or near) expiry on the shelfWrite-offs, safety and compliance risk
AccuracyThe system matches the shelfWrong orders, hidden theft, bad decisions
Lean stockCash not tied up in slow moversCash-flow problems, more expiry

Step 1: Set up products properly

Most stock problems start with messy product records. For each product, decide:

  • One base unit to count stock in (tablet, capsule, ml, bottle, piece).
  • Pack sizes with their own barcodes (strip of 10, box of 100, carton of 20 boxes).
  • Batch tracking on for anything with an expiry date: medicines, supplements, diagnostics, cosmetics.
  • Cost and selling price, or a margin rule by category.
  • Category (for example antibiotics, analgesics, vitamins, first aid) for reporting and counts.
  • Supplier and supplier code for fast reordering.
  • Storage area if it matters (cold chain, controlled storage, front shelf).

Avoid duplicate products for the same item (such as "Paracetamol 500mg" and "PCM 500 TABS"). Duplicates split stock and break reorder levels.

Step 2: Receive stock properly

The moment stock arrives is the moment to capture information you can't easily get later.

  1. Check against the orderCompare what arrived with the purchase order: products, quantities, pack sizes.
  2. Record batches and expiry datesFor every batch-tracked line. One line can contain several batches.
  3. Note short, damaged or wrong itemsSo the supplier credits you and the bill is corrected.
  4. Check the billPay only for what was received, at the agreed price.
  5. Shelve oldest at the frontNew stock goes behind existing stock with earlier expiry dates.

Step 3: Sell first-expiry-first-out

FEFO means the batch that expires first is sold first. It is not the same as first-in-first-out, because deliveries don't always arrive in expiry order. Shelving and software should both follow FEFO. Read FEFO vs FIFO for examples.

Step 4: Set reorder levels

A reorder level is the stock quantity at which you place a new order. A simple formula:

Reorder level = average daily sales × supplier lead time (days) + safety stock

Set a maximum too, so you don't overbuy. Review levels every quarter and before seasonal peaks such as cold and flu or malaria seasons. Worked examples: the reorder level formula.

Step 5: Count regularly

Two kinds of count work together:

Count typeHow oftenWhat to count
Full stock takeOnce or twice a yearEverything, with the shop closed or quiet
Cycle countsWeekly or monthlyA slice: high-value items, fast movers, controlled storage, one category
Spot checksWhenever something looks wrongThe product in question

Investigate every significant difference: was it a receiving error, an unrecorded write-off, a sale scanned as the wrong product, or theft? See how to do a stock take.

Step 6: Review every month

  • Near-expiry stock (next 60–90 days): discount, move to a faster branch, or return to the supplier.
  • Expired stock: remove from the shelf, quarantine and write off or return, with a reason.
  • Slow movers (no sales in 60–90 days): stop reordering, reduce the maximum.
  • Stock-outs last month: raise the reorder level or find a faster supplier.
  • Margins by category: catch supplier price increases you didn't pass on.

Key numbers to track

MeasureHow to calculateUse
Stock turnoverCost of goods sold ÷ average stock value (per year)Higher means stock sells faster. Track the trend.
Days of stock365 ÷ stock turnoverHow long current stock would last.
Expiry write-off rateValue written off for expiry ÷ cost of goods soldAim to push it down every quarter.
Stock-out rateProducts out of stock ÷ products that should be stockedLost-sales indicator.
Count varianceValue of count differences ÷ stock valueAccuracy and shrinkage indicator.

Where software helps

Every step above can be done on paper, but software removes the slow parts: stock updates with each sale, batches are chosen automatically, near-expiry stock and reorder lists appear by themselves, and count differences are calculated for you. poso does all of this; see pharmacy inventory software.

Pharmacy inventory questions

What is pharmacy inventory management?

The process of buying, receiving, storing, selling and counting medicines and other products so that the right items are available, nothing expires on the shelf, records match reality and cash isn't tied up in slow stock.

What is the best inventory method for a pharmacy?

First-expiry-first-out (FEFO) rotation, batch and expiry tracking, reorder levels with a maximum, regular cycle counts and a monthly review of near-expiry and slow-moving stock.

How can a pharmacy reduce expired stock?

Capture expiry dates on receipt, sell first-expiry-first-out, review stock expiring in the next 90 days every month and act early: discount, transfer or return. See how to track medicine expiry dates.

How often should a pharmacy do a stock take?

A full stock take once or twice a year, plus cycle counts of high-value and fast-moving products weekly or monthly.

What is a good stock turnover for a pharmacy?

It varies by country, size and product mix. Rather than chasing a benchmark, track your own turnover by category and work to improve it while keeping stock-outs low.

Last updated by the poso team.