Medical Store Stock Register in Excel (Free): Medicine Inventory Sheet with Expiry Alerts and Reorder Level
By the Trumac Healthcare team, Panchkula · PCD pharma franchise company since 2007 · Updated 14 November 2026 · About us · WhatsApp +91 90416 77932
हिंदी में: मेडिकल स्टोर का स्टॉक रजिस्टर Excel में मुफ्त – बैच, एक्सपायरी, मात्रा, रेट; एक्सपायरी के दिन, नियर-एक्सपायरी और री-ऑर्डर अलर्ट और स्टॉक वैल्यू अपने-आप।
What the stock register contains
| Column | What it does |
|---|---|
| Medicine, composition, category | Brand, salt and strength; category drop-down (Schedule H, H1, G, X or other) |
| Batch no. and expiry date | One row per batch, so every expiry date is tracked |
| Qty, purchase rate, MRP | Units in stock and per-unit rates |
| Reorder level | The quantity at which you want to reorder |
| Days to expiry and status | Calculated from today’s date: Expired, Near expiry (within 90 days – you can change the window) or OK, colour-coded |
| Reorder? | Flags items at or below the reorder level |
| Stock value | At purchase rate and at MRP, with totals and the margin locked in stock |
| Summary | Number of batches, expired and near-expiry counts, value of stock at risk, items to reorder |
Using it to cut expiry losses
- Sort by days to expiry every week and move near-expiry batches to the front of the shelf (FEFO).
- Return batches before your supplier’s cut-off – free expiry return note.
- Reorder from the “Reorder” flags, not from memory – free purchase order format.
- Keep Schedule H1 sales in the separate register – H1 register format.
Frequently asked questions
How do I maintain medical store stock in Excel?
List every batch on its own row with medicine, composition, batch number, expiry date, quantity, purchase rate, MRP and reorder level. Update quantities after purchases and sales (or weekly from your billing software). The free sheet on this page then shows days to expiry, near-expiry and reorder flags and stock value automatically.
Why one row per batch?
Different batches of the same medicine have different expiry dates. Tracking them separately lets you sell the earliest-expiring stock first (FEFO) and return near-expiry batches in time.
How many days before expiry should stock be returned?
It depends on your supplier’s returns policy – many ask for returns a few months before expiry. The sheet flags batches within 90 days by default; change the window to match your supplier’s policy.
Can this replace billing software?
No. It is a simple stock and expiry register. Billing, GST invoices and the Schedule H1 register still need your billing software or registers; the sheet helps you review stock, expiry and reorders.
Is there a medicine list for a new medical store in Excel?
This register is blank so you can add the medicines you stock. For a ready list of brands and compositions, download our product list PDF – it includes 1,600+ products with compositions.
For chemists: medical store profit margin · medical store licence · product list · all guides.
Want higher-margin stock on your shelves? Add a PCD range – WhatsApp +91 90416 77932. 3000+ products, no franchise fee, first order from ₹25,000 (wholesale licence needed to supply others). Trumac Healthcare, Panchkula – since 2007.