Medicine Expiry Date Tracker Excel Sheet (केमिस्ट एक्सपायरी रजिस्टर)
Track pharmaceutical medicines, manufacturer batch numbers, expiry dates, rack locations, and purchase costs to eliminate expired stock losses.
| Medicine Name | Batch No | Expiry (MM/YY) | Packing | Purchase Cost (₹) | MRP (₹) | Stock |
|---|---|---|---|---|---|---|
| Dolo 650mg Tablet | DL-8821 | 08/2027 | 15 Tabs / Strip | 24.50 | 32.00 | 40 |
| Azithromycin 500mg | AZ-4109 | 11/2026 | 3 Tabs / Strip | 58.00 | 78.00 | 25 |
| Pantoprazole 40mg (Pan-40) | PN-1092 | 04/2027 | 10 Tabs / Strip | 88.00 | 118.00 | 30 |
| Cetirizine 10mg (Okacet) | CT-5534 | 12/2027 | 10 Tabs / Strip | 14.20 | 21.50 | 60 |
| Amoxicillin Clavulanate 625 | AM-9901 | 05/2026 | 6 Tabs / Strip | 112.00 | 154.00 | 15 |
| Betadine 10% Ointment 20g | BT-3320 | 09/2027 | Tube | 72.00 | 95.00 | 20 |
Why Indian Retailers Outgrow Excel Spreadsheets
Spreadsheets are designed for monthly accounting at a desk, not for serving 15 walk-in customers during evening rush hours.
Excel will not warn you when a customer brings an expiring medicine to the counter.
Sorting formulas fail to highlight batches expiring in 30, 60, or 90 days across 1,000+ SKUs.
Cannot enforce First-Expiry-First-Out (FEFO) dispensing order.
Drug inspectors require printed batch numbers on customer bills, which Excel requires manual typing for.
Karobari tracks batch numbers and expiry dates automatically. It warns you before billing expiring items, recommends older batches first, and prints batch details on every bill.
Frequently Asked Questions (अक्सर पूछे जाने वाले सवाल)
मेडिकल स्टोर में बैच नंबर और एक्सपायरी ट्रैक करना क्यों कानूनी रूप से ज़रूरी है?
ड्रग्स एंड कॉस्मेटिक्स रूल्स के तहत, किसी भी मरीज या ग्राहक को एक्सपायरी के करीब या एक्सपायर दवा बेचना गंभीर अपराध है। बिल पर बैच नंबर और एक्सपायरी तिथि छपना अनिवार्य है ताकि गुणवत्ता या रिकॉल की स्थिति में दवा की पहचान हो सके।
एक्सपायरी नुकसान (Expiry Losses) से कैसे बचें?
दवाइयों को FEFO (First-Expiry-First-Out) नियम से बेचें, यानी जिसकी एक्सपायरी पहले है उसे आगे रखें। Karobari में 60 दिन पहले अलर्ट मिल जाता है, जिससे आप वितरक (Stockist/Distributor) को समय रहते एक्सपायरी रिटर्न भेजकर पूरा क्रेडिट नोट ले सकते हैं।
Other Free Excel Billing & Stock Registers
Kaccha Bill Format in Excel and Word
Simple cash memo and rough estimate slip format for non-GST retailers, kirana stores, and contractors. Record ...
GST Tax Invoice Format in Excel with Formulas
Full GST Rule 46 compliant tax invoice format in Excel. Includes columns for HSN/SAC codes, taxable amounts, C...
Kirana Shop Stock Register Excel Format
Track grocery product names, barcode/SKU numbers, categories, purchase costs, MRP selling prices, and opening ...
Customer Udhaar Khata and Credit Ledger Excel Format
Manage customer credit, payment reminders, given amounts, received amounts, and running balance totals with ze...
Delivery Challan Format in Excel (GST Rule 55)
Compliant transport dispatch slip for goods movement between godowns, job work, and goods on approval without ...
Retail Cash Memo Format in Excel and Word
Simple cash memo format for non-GST retailers, kirana shops, and traders. Record serial numbers, customer deta...
Retail Barcode and Price Label Register
Master register for generating Code 128 and EAN-13 retail barcode stickers with item prices, size variations, ...
Hardware & Sanitary Quotation Format in Excel
Contractor and builder price estimate format with square feet, running feet, bags, and pieces. Ideal for hardw...