Pharmacy inventory management: keep the right stock without overbuying

Inventory ties service quality to working capital

Too little stock means missed sales and repeat visits for customers. Too much stock ties up money, uses shelf space and increases the amount exposed to expiry. Inventory management is the routine of balancing availability with the cash your business can afford to keep on the shelf.

Start with trustworthy data rather than a large opening order. An inventory report is only as useful as the receiving records, sales units and physical counts behind it.

Create a clean product master

Keep product names, strength, dosage form, pack size and barcode consistent. Avoid duplicate entries that divide the same physical stock across several records. Separate products when they differ in strength or form; similar names do not make items interchangeable.

Define purchase, storage and sale units explicitly. If a box contains ten strips, test that selling two strips deducts exactly the intended quantity. Confirm how costs and rounding behave when partial packs are sold. A small conversion mistake becomes a large discrepancy after many transactions.

Receive stock at batch level

Check deliveries against the supplier invoice and the actual items. Record batch number, expiry, received quantity and cost as applicable. Keep questionable, damaged or discrepant stock apart until someone resolves it; do not make it available for sale just to balance the paperwork.

Store products according to their labeled conditions. Software records do not prove that storage conditions were maintained. Make the physical shelving and monitoring process part of the same receiving checklist.

Set reorder points with a simple calculation

A starting reorder point is expected demand during the supplier’s lead time plus a safety buffer. If an item sells about four units a day, delivery usually takes three days and you choose a six-unit buffer, the illustrative reorder point is 18 units. Adjust for actual demand and unreliable deliveries rather than treating the number as permanent.

Before ordering, consider saleable stock, incoming confirmed orders and committed demand. Review fast-moving products more frequently. New or slow-moving items need a cautious approach because their sales history may not support a reliable forecast.

Use expiry and slow-moving reviews together

Where appropriate for the product and workflow, first-expiry-first-out helps staff select the earliest suitable expiry. Keep different batches identifiable on the shelf. Review near-expiry lists routinely and contact suppliers before any agreed return deadline.

Slow-moving stock may still have a distant expiry while consuming valuable cash. Review both sales movement and remaining shelf life before reordering. Do not resolve excess stock by encouraging inappropriate medicine use or bypassing dispensing requirements.

Count little and often

Cycle counts check a manageable group of items regularly instead of waiting for one annual count. Prioritize high-value items, frequent sellers and products with recurring differences. Count in the same units used by the system and record who checked and approved any adjustment.

Investigate a discrepancy before changing the balance. Common causes include duplicate products, missed receiving, unit conversion errors, unrecorded returns and transactions during the count. Repeated unexplained changes should trigger a process review.

A routine your team can maintain

• Every delivery: verify quantity, batch, expiry, cost and shelf placement.
• Every day: investigate unusual stock changes and urgent shortages.
• Every week: review reorder candidates, slow movers and near-expiry items.
• On a rotating schedule: count selected products and resolve differences.
• Before supplier payment: reconcile returns and credit notes.

RunMyPharmacy’s inventory, expiry, shelf and purchase-order pages explain the tools available for these routines. Trial the workflow with a small set of real products before relying on it for the full store.

See medicine inventory and pack-unit workflows