Free Pharma & Chemist Store Bill Format in Excel
Specialized Excel invoice template for retail chemist shops and wholesale pharmaceutical distributors with Batch Number, Expiry Date, MRP, and Drug License No columns.
100% Free instant download • No credit card or registration required • Auto-calculating formulas included
Interactive Spreadsheet Preview
| S.No | Medicine Name / Salt | Batch No | Exp Date | Packing | HSN | Qty | MRP (₹) | Rate (₹) | Dis % | GST % | Net Total (₹) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Augmentin 625 Duo Tablet | AG7892 | 11/27 | 10 Tab | 3004 | 5 | 223.5 | 178.8 | 5% | 12% | 947.64 |
| 2 | Pan-D Capsule | PD4410 | 03/28 | 15 Cap | 3004 | 10 | 199 | 159.2 | 10% | 12% | 1604.74 |
| 3 | Azithral 500mg Tablet | AZ1205 | 08/27 | 5 Tab | 3004 | 8 | 131 | 104.8 | 0% | 12% | 938.98 |
Form 20 / Form 21 (Retail) or Form 20B / Form 21B (Wholesale)
Selling expired drugs attracts severe penalties under D&C Act
Doctor Name and Patient Name required for prescription registers
Excel Sheet vs UdyogBill Automated Billing
Excel is great for starter lists, but dangerous for growing businesses. See what happens when you upgrade:
Manual Excel Spreadsheet Hazards
- ✕No near-expiry warning alerts (medicines expire on the shelf causing losses)
- ✕Cannot maintain digital Schedule H1 / Narcotic sales registers
- ✕Strip cutting calculations are difficult and error-prone in Excel
- ✕No automatic supplier purchase bill import via CSV or Excel
- ✕Cannot generate debit notes for expired stock return to distributors
UdyogBill 1-Click Automation Advantage
- Smart FEFO (First Expiry First Out) auto-batch selection during billing
- Automatic 30/60/90 days near-expiry stock dump alerts before loss occurs
- 1-Click Schedule H1, Narcotic & Doctor Prescription register generation
- Direct purchase sync: Import distributor invoices with batch & expiry automatically
- Loose tablet strip cutting support with automatic fractional price calculation
Stop Wasting Hours on Manual Spreadsheets
Join 5,000+ Indian shopkeepers and distributors billing in 5 seconds with automatic GST returns.
Frequently Asked Questions (FAQs)
Q:Does this template include Batch Number and Expiry Date columns?
Yes, it specifically includes Batch Number, Expiry Date (MM/YY), MRP, Packing, and Drug License numbers required by drug inspectors.
Q:Can I manage strip cutting (loose tablets) in Excel?
Excel requires tedious manual calculations for fractional quantities (e.g. 3 tablets from a 10-tablet strip). UdyogBill Pharma Edition natively handles strip cutting and loose tablets without math errors.
Explore Other Free Business Invoice Templates
GST Tax Invoice Format in Excel (Free Download)
Ready-to-use, fully automated GST invoice Excel template with built-in formulas for CGST, SGST, IGST, and Grand Total. Perfect for Indian MSMEs, traders, and service providers.
View Template & DownloadRetail & Kirana Store Cash Memo Bill Format in Excel
Clean, quick-entry cash memo format designed for Indian grocery stores, kirana shops, and mini-marts. Features auto-calculating item subtotals and discount fields.
View Template & DownloadGarment & Apparel Shop Invoice Format in Excel
Tailor-made invoice format for Indian clothing stores, saree showrooms, and textile wholesalers with Size (S/M/L/XL/XXL), Color, Brand, and Style Code columns.
View Template & DownloadDelivery Challan & Transport LR Format in Excel
Standard Delivery Challan format for goods sent for job work, exhibition, demo, stock transfer, or transportation where a tax invoice is not immediately required.
View Template & DownloadProforma Invoice & Quotation Format in Excel & Word
Professional Proforma Invoice template for sharing estimated pricing with clients before official dispatch. Includes bank payment details, validity terms, and delivery schedules.
View Template & Download