In retail pharmacy and chemist shop management, inventory control is not merely a financial question—it is a strict statutory legal liability. Under the Drugs and Cosmetics Rules, 1945, dispensing a single expired strip of antibiotic or injectable formulation carries severe criminal penalties, including the immediate suspension of your retail drug license (Form 20 and Form 21).
Simultaneously, expired medicines represent the single largest profit write-off for Indian dispensaries. The average retail chemist writes off 2.5% to 4% of their total annual inventory directly to expiry garbage simply because new stock cartons are carelessly stacked in front of older stock on rear dispensary shelves. By the time the older strips are discovered, the pharmaceutical distributor’s 60-day expiry return window has already passed.
Step-by-Step Batch & Expiry Management in KhataOS
Log Batch Number & Expiry During Wholesale Inward Intake
Execution Time: ~15 seconds per medicine lineWhen unpacking delivery boxes from your pharmaceutical C&F or wholesale distributor:
- In the KhataOS Medical Workspace, search for the formulation (e.g. Augmentin 625 Duo or Telma 40).
- Enter the Manufacturer Batch Number printed on the outer carton (e.g.
BT-2026A). - Select the Expiry Month & Year (e.g.
11/2027). - Input quantity received and landing cost. KhataOS stores each batch as an independent physical inventory lot in local SQLite storage.
Automated FIFO Batch Dispensing at Counter Checkout
Automatic Dispensing GuardWhen a patient hands you a doctor's prescription at the counter:
- Select the prescribed formulation. If you have multiple active batches in stock (e.g., Batch A expiring in 6 months and Batch B expiring in 24 months), KhataOS automatically selects Batch A.
- The batch number and expiry month/year are auto-appended to the line item. You never have to manually type 8-digit alphanumeric batch codes during counter rush.
Run the 90-Day Advance Expiry Audit Report
Monthly Routine (~2 minutes)On the first Sunday of every month, audit near-expiry formulations:
- Tap the Near-Expiry Audit tab inside KhataOS.
- Filter for all formulations expiring within the next 90 days.
- The screen presents a clean list sorted by distributor and value, showing exactly which strips must be pulled from the shelves.
Generate Distributor Expiry Return Statements
Execution Time: ~1 minuteMost Indian pharmaceutical distributors accept near-expiry returns for full credit if submitted 60 days prior to the expiration date:
- Select the pulled near-expiry items and tap Generate Return Challan.
- KhataOS formats an itemized statement with Manufacturer Name, Product, Batch, Expiry, and Purchase Rate.
- Hand the physical stock and printed challan to the distributor’s delivery agent to receive an immediate credit note against your next medicine invoice.
Statutory Pharmacy Record Requirements
| Statutory Parameter | Drugs & Cosmetics Rules Mandate | KhataOS Compliance Feature |
|---|---|---|
| Schedule H / H1 Register | Mandatory logging of patient name, prescriber doctor name, batch, and date. | Automated Schedule H audit report generated with 1 tap. |
| Expired Drug Separation | Expired stock must be physically segregated in a box labeled "Expired Drugs - Not for Sale". | Flagged near-expiry items are isolated digitally from active counter billing. |
| Invoice Retention | All purchase records and sale invoices must be preserved for minimum 3 years. | Encrypted local SQLite storage preserves immutable records indefinitely. |