Pharmacy Inventory Software India: GST Billing & Batch-Wise Stock

Pharmacy is the most profitable department in most Indian hospitals — and the leakiest. Expired stock, untracked batches, wrong GST rates, and unbilled IPD indents quietly eat 5–10% of pharmacy revenue every year. A proper pharmacy inventory management software fixes this in weeks, not years.

The 5 Real Problems in Indian Hospital Pharmacies

1. Expiry losses — stock sitting behind newer batches on the same shelf
2. No batch traceability — recall or return becomes guesswork
3. GST errors — manual rate selection leads to notices and rework
4. IPD indents not billed — medicines issued to wards never reach the final bill
5. Duplicate medicine masters — the same drug entered four ways, breaking stock reports

Must-Have Features in 2026

• Batch-wise stock with FEFO dispensing (First Expiry First Out)
• Expiry alerts at 90 / 60 / 30 days with return-to-supplier workflow
• GST 2.0 compliant billing with HSN-driven automatic tax mapping
• Barcode scanning at purchase and sale
• Master medicine catalogue with composition and substitute search
• Purchase order & supplier ledger with payment mode and reference tracking
• Schedule H / H1 flags and prescription capture
• Auto-posting of IPD indents into the patient's admission bill

Compliance Checklist for Indian Medical Stores

• Drug licence number printed on every invoice
• Pharmacist name and registration number on the bill
• Schedule H1 register maintained and retained for 3 years
• Batch number and expiry printed on the customer invoice
• GSTIN, HSN code and tax breakup on every taxable sale

Why a 2.5 Lakh Drug Master Changes Day-to-Day Work

Most stock reports in Indian pharmacies break for one boring reason: the same medicine is typed four different ways at four different counters. SmartHospital India ships a pre-loaded master catalogue of over 2.5 lakh (250,000) Indian drug SKUs with brand name, composition, manufacturer, pack size and HSN code, so staff pick an existing item instead of creating a new one.

• No duplicate masters — one item code per brand and pack, so purchase, sale and closing stock always reconcile
• HSN comes with the drug — GST rate is derived from the catalogue, not chosen manually at billing
• Composition-based substitute search — when a brand is out of stock, the counter can offer an in-stock alternative with the same salt and strength
• Schedule H / H1 already tagged — the software knows which item needs a prescription record before the bill can be saved
• Faster billing — typing three letters pulls the correct pack instead of a free-text entry

Schedule H and H1 Record-Keeping: What the Rules Actually Require

Under the Drugs and Cosmetics Rules, Schedule H drugs may be sold only against a registered practitioner's prescription, and Schedule H1 drugs (most third and fourth generation antibiotics, anti-TB drugs, and several sedatives such as tramadol and alprazolam) carry a stricter obligation: every sale must be entered in a separate bound H1 register that is retained for three years and produced on demand during a drug inspector's visit.

Columns a Schedule H1 register must contain

1. Serial number and date of supply
2. Patient name and address
3. Prescriber name and registration number
4. Drug name, strength and quantity supplied
5. Batch number and expiry date
6. Signature of the supplying registered pharmacist

The other registers and retention periods

• Prescription copies / records — retained 2 years for Schedule H
• Schedule H1 register — retained 3 years
• Purchase bills and credit notes — retained 3 years (and 6 years under GST rules)
• Cold-chain / temperature log — for vaccines, insulin and biologicals
• Expiry and breakage destruction record — with witness signature

What usually goes wrong in a manual register

Handwritten H1 registers fail inspection for predictable reasons: missing prescriber registration numbers, batch numbers that do not match the invoice, gaps on busy days, and pages that cannot be reconciled with stock. Software that flags an H1 drug at the billing screen, forces prescriber and batch capture before the bill saves, and can print a date-range H1 register on demand removes all four failure points — and the same batch data already sits on the invoice, so nothing is entered twice.

How to Cut Expiry Loss to Under 1%

1. Switch dispensing from FIFO to FEFO.
2. Review the 90-day expiry report every Monday — no exceptions.
3. Return near-expiry stock to the distributor while it is still returnable.
4. Stop reordering slow-moving SKUs flagged by the stock movement report.
5. Clean duplicate medicine masters once, then lock master creation to admins.

Pharmacy 2.0 in SmartHospital India

SmartHospital India ships a full Pharmacy 2.0 module — a 2.5 lakh+ drug master catalogue, batch-wise stock with FEFO, expiry and return handling, GST 2.0 invoicing with configurable print layouts, barcode support, supplier ledger with payment references, substitute medicine search, and AI OCR for distributor purchase bills. Hospital pharmacy and retail counters run on the same stock ledger with separate billing series.

"Expiry write-off dropped from ₹90,000 a quarter to under ₹12,000 after we moved to batch-wise FEFO." — Hospital pharmacy, Bhopal

Start With One Audit

Run a physical stock audit against your current system this week. Whatever gap you find is what software will recover for you every single month. Start your free trial of SmartHospital India and set up your pharmacy in a day.