Managing a medical store in India is more challenging than it looks from the outside. You're juggling hundreds — sometimes thousands — of medicines, each with its own batch number, expiry date, MRP, and reorder level. A small mistake — an expired medicine missed on the shelf, a batch number recorded wrong, or a supplier return forgotten — can cost you thousands of rupees and damage your reputation.
This guide covers everything an Indian pharmacy owner needs to know about managing inventory the right way: from the basics of batch tracking to advanced topics like dead stock identification and returning medicines to suppliers.
Why Pharmacy Inventory Is Uniquely Difficult in India
Unlike a grocery store or a clothing shop, a medical store has to track inventory at the batch level — not just the product level. Two boxes of the same medicine from two different batches can have different expiry dates, different MRPs (because of price revisions), and different purchase rates. You cannot treat them as the same item.
On top of that, Indian pharmacies deal with:
- Hundreds of SKUs: A mid-size pharmacy in Delhi or Noida stocks 800–2,000 different medicines.
- Frequent new invoices: 5–10 purchase invoices per week from different distributors, each with 20–100 line items.
- Handwritten or printed paper bills: Many distributors still send physical invoices that need to be entered manually — or scanned with AI.
- Drug licensing compliance: Schedule H and H1 medicines need extra records.
- GST complexity: Different medicines have different GST slabs (0%, 5%, 12%, 18%).
The result? Most small pharmacies still manage inventory in notebooks or Excel sheets — and those approaches break down the moment you hit more than a few hundred SKUs.
Step-by-Step: Batch Number Tracking
A batch number (also called a lot number) is a unique identifier printed on every medicine pack that tells you when and where it was manufactured. It's linked to the expiry date, and it's critical for two reasons: expiry management and product recalls.
How to set up batch tracking in your pharmacy
Record batch number at the time of purchase
Every time a new invoice arrives, record the batch number for each medicine. Don't wait to do it later — batch numbers get mixed up on the shelf very quickly.
Keep each batch as a separate inventory record
If you receive Paracetamol 500mg in batch B2401 and batch B2402, keep them as two separate stock entries — not combined. They have different expiry dates and possibly different purchase rates.
Use FEFO — First Expiry, First Out
Always dispense from the batch that expires earliest. This is the most important rule in pharmacy inventory. If you're doing FIFO (first in, first out) instead of FEFO, you may be selling newer stock while older stock expires.
Record the batch number on every retail bill
When you sell, note which batch number you sold from. This is essential for recalls — if a manufacturer recalls a batch, you need to know which customers received it and which stock to pull from your shelf.
Managing Medicine Expiry Dates
Expired medicines on your shelf are not just a loss — they are a legal liability. The Drugs and Cosmetics Act makes it an offence to sell expired medicines, and inspections by drug authorities are common in Indian pharmacies.
Best practices for expiry management
- Check expiry 90 days ahead: That gives you time to return the stock to your distributor before it expires. Most distributors accept returns 60–90 days before expiry.
- Physical shelf check once a month: Walk through your racks and pull any medicine expiring in the next 60 days for review.
- Red-yellow-green labelling: Some pharmacies use coloured stickers on racks — red for <30 days, yellow for 30–90 days, green for safe stock.
- Don't mix batches on the same shelf position: Keep each batch in a separate physical location so dispensing from the oldest batch first is easy.
Good pharmacy management software should alert you automatically — not just when something expires, but 30, 60, and 90 days before expiry, so you have time to act. Manual Excel tracking almost always misses expiry alerts because someone forgets to check the sheet.
Identifying and Managing Dead Stock
Dead stock refers to medicines that have been sitting in your inventory for a long time without being sold. They tie up your working capital and will eventually expire if not dealt with. For a typical Indian pharmacy, dead stock can represent 5–15% of total inventory value.
What causes dead stock?
- Over-ordering when buying at a discount ("bonus" schemes from distributors)
- A doctor in your area stopping a particular prescription
- A medicine being replaced by a newer equivalent
- Seasonal medicines bought in excess (cold/flu medicines bought for winter)
- New brands stocked based on sales rep pressure that never moved
Returning Medicines to Your Supplier
Returning medicines to your supplier — also called a return challan or debit note — is a normal part of pharmacy operations in India. You have the right to return medicines that are expired (or near-expiry), damaged, wrongly supplied, or in excess of what you need.
When can you return medicines to a supplier?
- The medicine is expiring within 60–90 days and you cannot sell it before then
- The medicine arrived damaged or with a broken seal
- The supplier sent the wrong product, strength, or pack size
- You received excess quantity compared to your purchase order
- There is a manufacturer recall on that batch
Identify the items to return
Check your near-expiry list and dead stock list. For each item, note the medicine name, batch number, expiry date, quantity, and purchase rate.
Contact your distributor/supplier
Call or WhatsApp your distributor to inform them of the return. Most distributors prefer advance notice so they can send a salesperson to pick up the stock and process a credit note.
Generate a return challan
This is a document listing every medicine being returned, with batch number, quantity, and value. Keep a copy for your records. Good pharmacy software generates this automatically and adjusts your stock simultaneously.
Track the return status
Follow up until you receive a credit note from your distributor. Keep the challan number and follow up if you don't get a credit within 2–4 weeks.
Setting Up Reorder Levels and Low-Stock Alerts
A reorder level is the minimum quantity at which you should place a new order for a medicine. If your stock falls below this number, you risk running out before the next delivery arrives.
The formula is: Reorder Level = Average Daily Sales × Lead Time (days)
For example, if you sell 5 strips of Metformin 500mg per day and your distributor takes 3 days to deliver, your reorder level should be at least 15 strips. Add a safety buffer of 30–50% for high-demand medicines.
Practical tips for Indian pharmacies
- Set higher reorder levels for chronic disease medicines (diabetes, hypertension, thyroid) because demand is predictable and a stockout will directly lose you loyal customers.
- Set lower reorder levels for seasonal medicines outside their season.
- Review and update reorder levels every 3–6 months — prescription trends change.
Managing Purchase Invoices — The Old Way vs The AI Way
The biggest source of inventory errors in Indian pharmacies is manual invoice entry. When a distributor drops off a physical bill with 50 medicines, someone has to type all 50 lines into the software. Mistakes happen — a quantity read as 21 instead of 1, a batch number with a typo, an expiry date in the wrong format.
| What you track | Manual / Excel / ERP | AI-powered (PharmaStok) |
|---|---|---|
| Time to enter one invoice | 2–3 hours per day | Under 2 minutes |
| Batch number tracking | Often skipped | Automatic from invoice scan |
| Expiry date alerts | Manual check required | Automatic, daily alerts |
| Dead stock report | Manual calculation | One-click report |
| Return to supplier tracking | Paper challan only | Digital, stock auto-deducted |
| WhatsApp integration | ✗ Not available | ✓ Upload invoice via WhatsApp |
Pro tip for best accuracy: Upload invoices as PDF files (via web or WhatsApp) for 95–98% accuracy. Photos work too, but clear, flat PDFs give the highest extraction accuracy for batch numbers and expiry dates.
Monthly Inventory Management Checklist for Indian Pharmacies
- ☑ Review near-expiry list — flag all medicines expiring in <90 days
- ☑ Initiate supplier returns — for anything expiring in <60 days that you can't sell
- ☑ Check dead stock report — medicines with zero sales in 90+ days
- ☑ Review low-stock alerts — place reorder for anything below reorder level
- ☑ Physical spot check — count 10–20% of your SKUs physically against the system
- ☑ Reconcile purchase invoices — verify all invoices from last month are in your system
- ☑ Follow up on open returns — chase credit notes for returns sent in previous month
- ☑ Check GST compliance — ensure all retail bills have correct GST applied
The Bottom Line
Pharmacy inventory management in India requires discipline, systems, and the right tools. The old way — notebooks, Excel, and manual bill entry — worked when pharmacies stocked fewer than 200 medicines. Today's pharmacies are too complex for manual management.
The right approach is to automate the time-consuming parts (invoice entry, expiry tracking, low-stock alerts) so you and your staff can focus on patients and sales rather than paperwork.