Pharmacy inventory management means knowing what is on your shelves, what it cost, when it expires and when to order more, so you never turn a customer away and never pay for stock that ends up in the returns bin. For a small or independent pharmacy it comes down to five habits: reorder points, a counting rota, an expiry check, clean unit sales and the controlled substance count the law asks for.
This guide turns those habits into a weekly routine you can run with one pharmacist and one technician. You'll get the numbers to set, a sample count rota, and a plain note on where a till ends and a dispensing system begins.
What does pharmacy inventory management cover?
Pharmacy inventory management covers every product you sell, prescription and over the counter, from the moment it arrives until it is sold, returned or written off. In practice that is four records: how many you have, where they sit, what each one cost, and when each batch expires.
Most small pharmacies split the work between two systems:
| Area | Usually lives in | Why |
|---|---|---|
| Prescription stock, patient records, claims | Your pharmacy dispensing system | It ties stock to prescriptions, insurers and clinical checks |
| Front of store: OTC medicines, vitamins, baby care, cosmetics | A point of sale till with a stock count | It is retail selling: barcodes, prices, receipts |
| Controlled substances | Dispensing system plus a paper or electronic register | Federal and state record rules apply |
| Expired and returned stock | A hold area plus a reverse distributor's paperwork | It must never go back on the shelf by mistake |
Decide which system owns which shelf, or the same item ends up counted in two places and right in neither.
How do you set reorder points for a pharmacy?
A reorder point is the stock level at which you order again, and it is simple to work out: average daily sales times the days your wholesaler takes to deliver, plus a small safety stock for busy weeks.
Take a cough syrup that sells 4 bottles a day with next day delivery:
- Daily sales: 4 bottles.
- Lead time: 1 day, so 4 bottles cover the wait.
- Safety stock: 2 days of sales, 8 bottles, for flu season and late trucks.
- Reorder point: 4 + 8 = 12 bottles. When the shelf count reaches 12, it goes on the order.
Redo the sum each season. A reorder point set in July will run out in January for anything cold and flu related, and it will overstock sunscreen in November.
One tip that saves money: order less of slow movers, even if the per unit price is better by the case. A case that expires before it sells was never cheaper.
A counting rota you can keep up
A full physical count once a year, with smaller cycle counts in between, is the pattern most pharmacy guides recommend, and it is the one we'd pick. Counting everything every month burns out the team; counting nothing until year end means you find a shortfall six months after it started.
Split the shop by value and risk:
| Group | What goes in it | How often to count |
|---|---|---|
| A | High value items and anything that walks out the door | Every week |
| B | Steady sellers, mid price | Every month |
| C | Low value, slow movers | Every quarter |
| Full count | Everything | Once a year, out of hours |
When a count differs from the record, look into it the same day. A gap found this week has a short list of causes: a delivery not received, a refund not put back, a damaged pack thrown out. A gap found next quarter has no story left.
Count one shelf at a time and write the shelf on the count sheet, so the counter walks a route instead of searching the shop.
How do you stop medicines from expiring on the shelf?
You stop expiry losses by putting the shortest date at the front, checking dates on a fixed day, and pulling anything inside its last few months while you can still return it for credit.
- First expiry, first out. New stock goes behind the old. This one habit does more than any software.
- A monthly date check. Pick one day a month and check every item due to expire in the next 90 days. Mark them, move them forward, or set them aside for return.
- Know your return window. Reverse distributors and wholesalers have their own rules on how close to expiry a product can be returned. Read your agreement once and put the window on the wall.
- Separate expired stock at once. A labelled hold box, away from the shelves, so an expired pack never gets sold by accident.
Record the batch number and expiry date when you receive stock that has them. If a batch is ever recalled, those two fields tell you whether it touched your shelves.
Selling strips and single tablets without losing money
Many pharmacies sell a full box, a single strip or a few loose tablets of the same item. That is where small pricing mistakes add up, because the strip price is often worked out by hand at the counter.
The safe rule is to divide the box price by the number of strips and round up, never down, so buying a whole box one strip at a time never costs less than the box. We ran our own till's pricing rule on three real shelf prices to show the effect:
| Box price | Pack | Strip price | Tablet price |
|---|---|---|---|
| $10.00 | 3 strips of 10 | $3.34 | $0.34 |
| $12.99 | 3 strips of 10 | $4.33 | $0.44 |
| $8.50 | 10 strips of 10 | $0.85 | $0.09 |
The $10.00 box shows why rounding matters: three strips at $3.33 would sell the box for $9.99, a cent short every time. If you want a round strip price, set one yourself; otherwise let the till work it out from the box.
Controlled substances: the count the DEA expects
In the United States, a pharmacy registered with the DEA must take a full inventory of its controlled substances at least every two years, known as the biennial inventory. The rule is in 21 CFR 1304.11.
The main points:
- Schedule I and II substances need an exact count.
- Schedule III, IV and V substances can be estimated, unless the container holds more than 1,000 tablets or capsules, which then needs an exact count.
- The record shows the date, whether the count was done at the start or the close of business, and is kept for at least two years.
Your state board of pharmacy may ask for more, so check its rules too. In Canada, controlled drugs fall under Health Canada and the provincial college, and the record rules differ by province. This is the one area where we'd never rely on a front of store till: keep it in your dispensing system or the register your regulator accepts.
Where a POS fits, and where it does not
A point of sale app handles the retail side of pharmacy inventory management well: barcodes, prices, a stock count per place, shelf locations, labels and the day's sales report. The Point of Sale app does that, and with the shop set to Pharmacy the till sells a box, a strip or a tablet, asks for the prescription number on items that need one, and prints a pick list beside the receipt.
Here is the honest limit. It is not a dispensing system. It keeps no patient history, checks no drug interactions and sends no insurance claims. Batch and expiry can be noted on the sale line and print on the receipt, but stock is a count per place, not per batch, so there are no expiry alerts. Your monthly date check stays a person's job.
If that split suits your shop, the page on pharmacy POS software walks through the counter step by step, and the general guide to inventory management for small business covers receiving and stock moves in more depth. You can start on the free plan and see the pricing before you add a second till.
A weekly routine on one page
- Monday: place orders from the reorder list; note what you chose not to order.
- Wednesday: count group A items; look into any gap the same day.
- Friday: receive deliveries with the oldest stock moved to the front; record batch and expiry.
- First Monday of the month: count group B; check every date due in 90 days.
- Each quarter: count group C and reset reorder points for the season.
- Every two years (US): the DEA biennial inventory, on a date you put in the calendar now.
FAQ
What is the best way to manage pharmacy inventory?
Set a reorder point for each item, count your high value items weekly and the rest on a rota, check expiry dates monthly, and keep prescription and controlled stock in your dispensing system. Small, regular counts beat one big count a year.
Can I manage pharmacy inventory in Excel?
You can for a small front of store range, with one row per item and columns for count, cost, reorder point, shelf and expiry. It breaks down once two people edit it or the till and the sheet disagree, which is when a POS with its own stock count pays off.
How often should a pharmacy do a full inventory count?
At least once a year for the whole shop, with cycle counts in between. Controlled substances in the US also need the DEA biennial inventory every two years, and some states ask for more.
What should I do with expired medicines?
Move them to a labelled hold area away from the shelves at once, record the item, batch, expiry and quantity, and return them through your wholesaler or a reverse distributor for credit where your agreement allows.

