How to Track Medicine Expiry Dates Without Manual Registers

There's a pharmacist in every Indian hospital who spends an hour each morning checking expiry dates. They open the register, walk through the shelves, pull out anything expiring within 30 days, and note it down. Then they do the same thing tomorrow.

This isn't pharmacy management. This is a human being doing the job of a spreadsheet — badly.

Indian hospitals lose an estimated ₹2-5 lakhs per year to expired medicines, depending on their size and inventory volume. For a 50-bed hospital carrying ₹15-20 lakhs worth of pharmacy stock, that's a 10-15% annual loss that goes straight to the waste bin.

Let's talk about how to fix this properly.

The Problem with Manual Expiry Tracking

The Register Method

Most Indian hospital pharmacies maintain a physical register (sometimes called the "expiry register" or "near-expiry book") where staff manually record:

• Medicine name
• Batch number
• Expiry date
• Quantity
• Shelf location

This register is updated when new stock arrives and checked periodically. The problems are obvious:

• **Human error:** A batch number written incorrectly means the wrong stock gets pulled (or doesn't get pulled at all)
• **Time-consuming:** 30-60 minutes daily for a pharmacy with 800-1,200 SKUs
• **Not real-time:** Stock that arrived yesterday might not be in the register yet
• **No prioritisation:** Which expiring medicines are high-value? Which can be returned to the distributor? The register doesn't tell you.

The Excel Method

Some pharmacies have graduated to Excel. It's better than paper, but creates its own problems:

• Requires manual data entry (same human error risk)
• Sorting and filtering helps, but someone still has to update it
• No integration with dispensing — you can dispense an expiring batch without knowing it
• File corruption, version conflicts, "who deleted row 347?"

The Real Cost

Let's be specific about what expiry-related losses look like:

For a hospital running on thin margins, this is significant. And it's entirely preventable.

How Automated Expiry Tracking Works

Batch-Level Inventory

The foundation of expiry tracking is batch-level inventory management. Every time stock enters your pharmacy, you record:

• Medicine name (linked to drug master)
• Batch number
• Manufacturing date
• Expiry date
• Quantity received
• Purchase price
• Supplier/distributor

This happens at the point of goods receipt — either by scanning the invoice barcode or manual entry. The key difference from register-based tracking: this data is now in a system that can act on it.

FEFO: First Expiry, First Out

FEFO (First Expiry, First Out) is the dispensing logic that should govern every pharmacy. When a doctor prescribes Amoxicillin 500mg and you have three batches in stock:

• Batch A: Expires August 2026 (45 units)
• Batch B: Expires November 2026 (100 units)
• Batch C: Expires March 2027 (80 units)

The system should automatically suggest dispensing from Batch A first. Not the batch that's most accessible on the shelf. Not the batch the pharmacist grabs first. The batch that expires soonest.

Manual FEFO compliance in Indian hospital pharmacies is estimated at 40-60%. With automated batch selection, it jumps to 95%+.

Multi-Level Expiry Alerts

A good system doesn't just tell you something is expiring. It tells you with enough lead time to act:

Alert Level 1 — 90 days before expiry: - Flag for potential return to distributor - Check distributor return policy (most Indian distributors accept returns up to 60-90 days before expiry) - Generate return request if eligible

Alert Level 2 — 60 days before expiry: - Increase dispensing priority (FEFO enforcement) - Alert pharmacy manager for manual review - Check if nearby branch/department can use the stock

Alert Level 3 — 30 days before expiry: - Red flag on dispensing screen - Block auto-dispensing for IPD floor stock - Move to "near-expiry" shelf for accelerated use - Calculate write-off value for accounting

Alert Level 4 — On expiry date: - Block from dispensing entirely - Auto-generate write-off entry - Update inventory and accounting records - Record in Drug License compliance log

Automated Reports

Weekly and monthly reports that no one has to create manually:

• **Near-expiry report:** All items expiring in next 30/60/90 days with quantities and values
• **Expired stock report:** Items that expired, written-off value, responsible actions taken
• **FEFO compliance report:** Percentage of dispensing that followed FEFO logic
• **Distributor return report:** Items returned, credit notes received, items rejected
• **Expiry loss trend:** Monthly graph of expiry-related write-offs (should be declining)

Practical Implementation Guide

Phase 1: Set Up Your Drug Master (Week 1-2)

Before you can track batches, you need a clean drug master — a standardised list of every medicine you stock. This should include:

• Generic name
• Brand name
• Formulation (tablet, syrup, injection, etc.)
• Strength
• Category (antibiotic, analgesic, cardiac, etc.)
• Storage requirements (room temperature, refrigerated, controlled substance)
• Minimum stock level
• Reorder quantity

Most cloud HMS products come with a pre-loaded drug master based on commonly stocked hospital medicines. You'll need to add/modify based on your specific formulary.

If you stock Jan Aushadhi (PMBJK) generics, ensure your drug master includes both branded and generic versions with cross-references.

Phase 2: Enter Opening Stock with Batches (Week 2-3)

This is the most tedious part, and there's no shortcut. Every medicine currently in your pharmacy needs to be entered with batch number and expiry date.

Practical tips:

• Start with high-value items (₹500+ per unit) — these represent the biggest loss if expired
• Then cover emergency/critical medicines — these are the biggest patient safety risk
• Do common dispensing items next
• Low-value, slow-moving items last

For a pharmacy with 800 SKUs, opening stock entry typically takes 3-5 days with 2 staff members working on it.

Phase 3: Go Live with Batch Tracking (Week 3-4)

From this point forward, every goods receipt and every dispensing transaction captures batch information. The system builds the expiry profile automatically.

Train your pharmacists on: - Goods receipt with batch entry - FEFO-based dispensing (the system suggests, they confirm) - Handling expiry alerts - Processing distributor returns

Phase 4: Optimise (Month 2+)

Once you have 30+ days of batch data, start analysing:

• Which medicines consistently reach near-expiry? (You're over-ordering)
• Which distributors have the best return policies? (Favour them)
• Which departments/doctors prescribe slow-moving items? (Coordinate with them)
• What's your monthly expiry write-off value? (Track the trend)

Handling Distributor Returns

Indian pharmaceutical distributors generally accept returns with these conditions:

• Minimum 60-90 days remaining before expiry (varies by distributor)
• Original packaging intact
• Batch traceable to their supply
• Credit note issued (not cash refund)

Automated expiry tracking makes returns much easier because:

1. You catch near-expiry items at 90 days (not 15 days when it's too late) 2. You have documented batch-level purchase records 3. You can generate a return request with batch numbers, quantities, and invoice references 4. You can track credit notes received against returns made

A hospital in Jaipur reported recovering ₹1.8 lakhs in the first year just from timely distributor returns that they previously would have missed.

Controlled Substances: Extra Requirements

Schedule H, H1, and X drugs have additional tracking requirements under the Drugs and Cosmetics Act. For these medicines, expiry tracking must also maintain:

• Complete chain of custody (received from whom, dispensed to whom)
• Destruction records for expired controlled substances (requires two witnesses)
• Monthly reconciliation of physical stock vs system records
• Separate register as required by Drug Inspector

Automated batch tracking doesn't replace the controlled substance register (which is legally mandated in physical form in most states), but it does make reconciliation significantly faster.

The ROI Calculation

For a 50-bed hospital:

Against a pharmacy management module that costs ₹2,299/month (₹54,000/year), the ROI is 5-8x in the first year alone.

Common Questions

"What about medicines that don't have a batch number on the strip?"

Rare, but it happens with some local manufacturers. In these cases, assign an internal batch number based on the purchase date and supplier. The system tracks it the same way.

"Our staff won't enter batch numbers — it slows down dispensing."

It adds about 5-10 seconds per dispensing transaction. That's 8-15 minutes per day for a pharmacy doing 100 transactions. Compare that to the hour spent on manual register checking, and you're still ahead.

"We have multiple pharmacy locations (main pharmacy + floor stock rooms). How do we track?"

Each stock location should have independent batch tracking with inter-location transfer records. When you move 20 units of a medicine from the main pharmacy to the ICU floor stock, the batch number moves with it.

Start Today

You don't need to digitise your entire pharmacy at once. Start with expiry tracking for your top 100 medicines by value. That covers 70-80% of your financial risk. Expand from there.

MedOS Pharmacy Management includes batch-level inventory with FEFO dispensing, multi-level expiry alerts (90/60/30 days), automated distributor return requests, and Jan Aushadhi catalogue integration. Available in the Professional plan at ₹2,299/month.

Start your 14-day free trial at [med-os.in](https://med-os.in) — no credit card, no setup fee.