Pharmacy Stock Management for Small Clinics: A Simple System That Works

A patient is sitting in front of you, the prescription is written, and your assistant comes back from the cupboard: "Sir, it's finished." The patient now has to find a chemist outside, the next patient waits, and you make a mental note to reorder that you will probably forget by evening. Most small clinics in India have lived this scene more than once.

You do not need hospital pharmacy software to stop it. A clinic that keeps a few dozen medicines for patient convenience needs a simple way to answer three questions: what do I have, what do I need to reorder, and what is about to expire. This guide shows how to set that up with a register, a spreadsheet or software, and how to keep it running on busy days.

What running out mid-consultation really costs

A stock-out looks like a small thing. It rarely is:

• The patient's time and trust. They came for a complete visit and now have to go to another pharmacy, sometimes delaying the first dose. It also makes the clinic look disorganised.
• Lost income. Every medicine the patient buys elsewhere is a sale you do not make. Small per patient, noticeable over a year.
• Staff time. Urgent orders, phone calls to suppliers and last-minute counts all come out of front desk hours that should go to patients.
• Emergency buying. An urgent order often means paying more, or accepting whatever brand is available that day.

Most stock-outs are predictable. The medicines you run out of are usually the ones you prescribe every day, which is exactly why they seem plentiful until the moment they are gone. Stock problems are one of the quiet places a clinic loses money every day.

Why pharmacy software built for hospitals is the wrong fit

Most pharmacy software in India is designed for retail chemists and hospital pharmacies. It comes with loyalty programmes, retail GST invoicing, distributor ordering portals and multi-location stock transfers. For a small clinic, that creates three problems:

• Too many screens. You spend more time in menus than on counting stock.
• Cost that does not match the job. Pricing built for businesses with large pharmacy sales, not a clinic dispensing basic medicines.
• Training burden. Front desk staff need hours of training for a system they touch a few times a day.

Meanwhile the real problems stay: you find you are out of amoxicillin when a patient needs it, or a strip of expired metformin behind newer stock. And when staff coordination happens in WhatsApp groups, "we need to reorder" messages get lost in the thread.

What a small clinic actually needs: the three-column system

Strip away the enterprise features, and stock management for a small clinic comes down to three columns for every medicine:

1. What do I have? The current quantity.
2. When do I reorder? A reorder level based on how fast you use it.
3. What is at risk? The nearest expiry date.

This works whether you stock 20 medicines or 100.

Column 1: Current stock

List every medicine you keep, with the quantity in units you actually dispense: tablets, vials, bottles. Not "boxes". The count goes down each time a medicine is handed over. The single most important habit is updating it at that moment, not from memory at the end of the day.

Column 2: Reorder level

For each medicine, set the quantity at which you place a new order. It is simple arithmetic:

Here is an illustration. Your own numbers will differ:

High-use medicines need higher reorder levels. Medicines you prescribe twice a month need low ones, and small orders.

Column 3: Expiry

Write the expiry date of the oldest batch next to each medicine. Once a month, list everything expiring in the next 60 days (90 days for syrups and suspensions) so you can use it first or return it to a supplier who accepts returns. Expired stock is money thrown away, and one of the easiest losses to prevent. For a full routine, see how to manage medicine expiry in your clinic. For background reading, see this study on pharmacy inventory control in Indian healthcare facilities.

Register, spreadsheet or software: choosing a method

Stock cards or a register

The traditional method. Each medicine gets a card or a page with the date, quantity received, quantity dispensed, running balance and expiry date. This works for very small dispensaries, under about 20 items with low daily use. Its weakness: every time a medicine is handed over, someone has to write it down. In practice, that happens once a day or once a week, so the counts are always a little out of date.

A spreadsheet

A shared sheet with the three columns is the usual first step up. It lets you sort by quantity to see what is low, and by date to see what is expiring. It fails for the same reason a register does: when the waiting room is full, the update gets skipped. The fix is not a better sheet, it is a routine that fits the moment of dispensing, and one named person who owns the list.

Inventory software

Dedicated clinic inventory tools can reduce the count automatically when a medicine is billed and warn you when an item drops below its reorder level. If you look at one, check these points:

• Low-stock and expiry warnings you can set per medicine.
• Link to billing, so dispensing and counting happen in one step instead of two.
• Simple screens your front desk can use without long training.
• Reports on what you use most, what moves slowly and what you spend each month.
• Export, so your stock history is not locked in if you ever switch clinic software.

Whatever you choose, the method matters less than the habit. A simple register updated every time beats software nobody opens.

An example: a 35-medicine clinic dispensary

This is an illustration, not a real clinic. Picture a general practice that keeps 35 essential medicines for patient convenience and restocks from memory. Every few weeks something common runs out, and an urgent order goes out at a higher price.

A spreadsheet is the first fix, and it lasts until the front desk stops updating it on busy days. The problem is not laziness, it is friction: every dispensing means opening the sheet, finding the medicine and changing the number.

What works better is a routine built around the moment of dispensing. The count is changed when the medicine is handed over. Reorder levels are checked every Monday morning. Items near expiry move to the front of the shelf. One person owns the list, and a second person covers on their day off. None of this needs barcode scanners, pharmacy staff or special training.

The four kinds of medicine to watch most closely

1. High-use, low-cost medicines

Paracetamol, antihistamines, antacids. You dispense these every day, so they run out most often. Give them the highest reorder levels and check them every week without fail.

2. Expensive, slow-moving medicines

Specialised antibiotics, branded formulations, injections. They lock up money and move slowly. If you prescribe a particular antibiotic twice a month, do not stock a hundred tablets. Stock a small quantity and reorder when only a few are left.

3. Scheduled and controlled medicines

If you stock Schedule H1 or narcotic medicines, careful records are not optional. Keep a register of each supply with the patient's name, the prescription and the quantity, keep it up to date, and have it ready for inspection. The exact requirements depend on the drug rules and your state, so check them with your state drug control department.

4. Short shelf-life items

Some syrups, suspensions and reconstituted medicines expire quickly. Watch these from 90 days before expiry rather than 60, which gives you time to use them or return them.

Common stock mistakes, and how to avoid them

Ordering because of a supplier offer

"Buy five strips, get one free" is only a saving if you would have used six strips anyway. If you rarely prescribe that medicine, you have just locked money in slow stock that may expire. Order from what you actually use each month, not from offers.

Skipping the physical count

Even with a good register or software, count everything by hand once a quarter. Medicines get handed over without being logged, patients return half strips, tablets get dropped. The written count and the shelf drift apart, and a quarterly count brings them back together and shows where logging is slipping.

Not knowing whether the dispensary pays for itself

Is your in-clinic dispensary profitable, or a convenience that costs you money? Many doctors do not know. Note what you spend on stock each month and what you collect for dispensed medicines, if you charge for them. Losing a little on the dispensary can be a deliberate choice for patient care, but it should be a conscious one. Some clinics find that stocking only their 15 most-prescribed medicines works well, while stocking 50 creates waste. Put the number in your one-page monthly report.

Nobody owning the list

When "everyone" updates the stock, nobody does. Name one person, give them a fixed time each week, and make the Monday reorder check part of their routine.

Let your prescriptions decide what you stock

Your own prescribing is the best guide to what you should keep. Look at what you prescribe most often and compare it with what is on the shelf:

• Medicines you prescribe often but do not stock are candidates to add.
• Medicines you stock but rarely prescribe are candidates to drop.
• Seasonal patterns matter: more antibiotics and antipyretics in the monsoon, more antihistamines in allergy season. Raise reorder levels before the season, not after the first stock-out.
• If more than one doctor works in the clinic, check whose prescriptions drive which medicines.

Knowing your most common diagnoses each month tells you which medicines you are likely to need next month. Digital prescriptions make this much easier than going through paper, because every prescription is already typed and saved. See how digital prescriptions work.

A simple stock routine to start this week

1. List your current stock: every medicine, with quantity and the nearest expiry date.
2. Set a reorder level for each, using the formula above.
3. Update the count at the moment of dispensing, not at the end of the day.
4. Every Monday: check which items are at or below their reorder level and place the orders.
5. First of every month: list items expiring in the next 60 days (90 for syrups) and move them to the front.
6. Every quarter: count everything by hand and correct the records.

Done by hand, this takes about ten to fifteen minutes a day plus a short weekly check. It is not perfect, but it is far better than finding out you are out of stock when a patient asks.

Setting up your stock list in one afternoon

The hardest part is the first list. Do it on a quiet afternoon, with two people: one counting, one writing.

1. Take everything off one shelf at a time. Count in dispensable units and note the nearest expiry date for each medicine.
2. Write each medicine once, by generic name and strength, with the brand you usually buy next to it. This avoids two entries for the same medicine.
3. Remove anything expired and set it aside for disposal or return, with a note of what it was worth. That number is your starting reason to keep the system going.
4. Estimate daily use for each medicine from last month's purchase bills, or from your best guess, and set reorder levels. Correct them after a month of real counts.
5. Put the shelf in order: older batches in front, newer ones behind, the same place for each medicine every time.

Suppliers, returns and storage

• Know your delivery times. Ask each supplier how long an order really takes, and use that number in your reorder levels. Keep a second supplier for your most-used medicines.
• Ask about returns before you buy. Some suppliers take back near-expiry stock or exchange it. Knowing this changes how much you order of slow-moving items.
• Order on a fixed day. One weekly order is easier to track than small urgent orders on random days, and suppliers get used to your pattern.
• Store medicines properly. Keep them away from sunlight and damp walls. Insulin, vaccines and other cold-chain items need a refrigerator with a thermometer you check daily. Heat-damaged stock is wasted stock even before its expiry date.

Records to keep for inspections

Stock records are not only for your own use. Your state drug control department can inspect a clinic dispensary. Keep these ready, on paper or digitally:

• Purchase bills from suppliers.
• A stock register showing opening stock, purchases, use and closing stock.
• Registers for scheduled and controlled medicines, if you stock them.
• Your expiry checks, showing that out-of-date stock is removed.

If your stock records include which patient received which medicine, treat them as health data: limit who can see them and keep them backed up.

When you need more than a simple system

The three-column system works for most small clinics indefinitely. You may need more if you run two or more branches and move stock between them, stock expensive injectables that need batch-level tracking, or bill insurers who need itemised medicine charges. Even then, you rarely need hospital-grade pharmacy software. Choose a tool that handles your specific need without the retail features you will never use.

The bottom line: simple systems win

You do not need barcode scanners, multi-warehouse management or supplier portal links. You need to know what you have, when to reorder and what is about to expire, and a habit that survives a full waiting room. A simple system used every day works better than a complex one used occasionally.

Where Vaidya OS fits

Vaidya OS is clinic software built for Indian clinics. It keeps your digital prescriptions and each patient's visit history in one place, and its dashboard shows your most common conditions, which helps you plan what to keep in stock. It also tracks medicine stock, with the batch and expiry date of each purchase and low-stock alerts. See the features page.