Why Pharma Inventory Is Different From Other Stock

Running a pharmacy distribution business is not like running a kirana. A kirana owner writes off stale chips. You write off Rs. 40,000 worth of cephalosporins that nobody flagged until the batch was already two weeks from expiry. The stakes are different, and the paper trail the law requires makes it even more complicated.

Three things make pharma inventory genuinely hard:

• Every batch has an expiry date, and that date changes what the stock is worth
• Regulators want batch-level records, not just SKU-level counts
• Your customers, the retail pharmacies you supply, can return near-expiry stock. And they will.

Get any of these wrong and you're either losing money to write-offs or losing sleep before a CDSCO inspection.

The Batch Number Problem

Most small distributors track stock by product. You know you have 40 boxes of Azithromycin 500mg. Fine. But which batch? When does each batch expire? Did the short-dated batch come in last week or six months ago?

When you're receiving stock from a C&F agent or a manufacturer's depot, invoices come with batch numbers and expiry dates printed on them. The moment that information doesn't make it into your records, you've lost the ability to do anything useful with it.

Picture a distributor running 600 SKUs across 15 manufacturers. A retailer calls to say a batch of a Schedule H1 antibiotic is expiring in 45 days and they want to return it. Without batch-wise records, you have no idea if the stock came from a single lot or three different ones, how much of that batch is still sitting in your godown, or whether you're within the return window your supplier agreed to.

That's a problem you can't solve by counting boxes harder.

Receiving Stock the Right Way

The cheapest place to fix an inventory problem is at the gate, when the delivery truck is still there.

When a consignment arrives, a two-minute check should cover:

• Does the batch number on the cartons match the challan?
• What is the expiry date on this batch, and is it acceptable for your customers?
• Does the physical count match the invoice quantity?
• Are any cartons visibly damaged or showing temperature damage (swollen blisters, discoloured tablets)?

If you're receiving a Schedule H1 antibiotic batch, the batch number goes into your records before anything else. That's not optional. An inspector asking for batch records during a visit expects to trace every unit back to when it came in.

Short-dated stock refused at the gate is a phone call to your supplier. Short-dated stock discovered at month-end is a negotiation you've already lost, because the product is yours now.

Expiry Management: The First-Expiry, First-Out Rule

FEFO, first-expiry first-out, is the standard in pharma for a reason. It sounds obvious. In practice, most godowns don't follow it because physically rotating stock is inconvenient when space is tight. (If you're still running FIFO, here's why Indian pharmacies are switching.)

The result is a predictable pattern. New stock goes in front because it's easy to reach. Older batches sit at the back. Six months later you find four cases of a product expiring in three weeks, buried behind the fresh stock you've been selling all along.

A few things that make FEFO actually work in practice:

• When new stock arrives, record the expiry date before it goes onto the shelf
• Pick from the oldest batch first when fulfilling orders, even if it means an extra step
• Set a review date. If you check expiry status once a month, you catch problems when there's still time to act. A 90-day expiry is a problem you can move. A 15-day expiry is a loss.

Some distributors do a weekly sweep of anything expiring in the next 60 days and contact the retailers who bought that batch. It takes an hour. It avoids a much larger conversation later.

What Compliance Actually Requires

For Schedule H drugs, the law requires that storage is separate from OTC stock, that temperature conditions match label requirements, and that you maintain batch-level records.

For Schedule H1, the bar is higher. Every sale needs to be logged with the batch number, the retailer's details, and the prescription reference. Monthly summaries should be maintained. If an inspector asks you to trace a particular batch of ciprofloxacin that went to retail, you should be able to show exactly which invoices it appeared on and when it left your godown. The register format itself, and what inspectors actually check, is covered in our Schedule H1 drug register compliance guide.

For Schedule X, the requirements are stricter still, but most small distributors don't handle narcotics.

The practical gap most distributors face is not that they don't know the rules. It's that the record-keeping system they use doesn't capture batch numbers and expiry dates in a way that's actually searchable. A handwritten stock register works until an inspector asks for all movement records on a specific batch across the last six months. Then it becomes a manual hunt through pages.

Returns and Near-Expiry Stock

Returns are where pharma distribution gets expensive if you're not organised.

A retailer returning stock has three things you need to verify: the batch number matches your original invoice, the product is intact and unadulterated, and the return is within whatever window your supplier will honour for credit. If your records don't have the original sale date and batch number, you can't verify any of that quickly.

Near-expiry stock that comes back and can still be returned to the manufacturer is a recoverable situation. Near-expiry stock that comes back after the manufacturer's return window has closed is a write-off. The difference is often just whether you acted on the information in time.

Building a simple alert system, even a spreadsheet flag, for stock hitting 90 days from expiry means you're making decisions when there are still options. Waiting until month-end physical stock counts means the options are gone.

Organising Your Godown for Inspection

An inspector walking into your storage area is looking for a few basic things: Schedule H and H1 drugs stored separately from general OTC stock, expired stock physically separated and clearly marked, temperature-sensitive products stored appropriately, and records that can be traced.

The storage piece is mostly about physical organisation. Label your shelving. Keep a dedicated section for Schedule H products. Keep a clearly marked quarantine area for expired or damaged stock, and make sure nothing from that area ever gets dispatched.

The records piece is harder, because it has to be done consistently, not just cleaned up before an inspection. Batch records maintained only during inspection prep are a liability. If an inspector asks for records from eight months ago, you need to actually have them.

Getting Your Records Under Control

If you're managing 400 or more SKUs across multiple manufacturers, doing this manually becomes a real time cost. The options are not complicated: a well-structured spreadsheet updated daily, or software built for pharma distribution that captures batch numbers and expiry dates at the point of entry.

ShelfLifePro lets you track stock with batch numbers and expiry dates, and flags items approaching expiry before they become a problem. It's not a substitute for good habits at receiving, but it does mean the information you capture actually gets used. If you're a small distributor who wants to move off the notebook-and-tally setup, every plan starts with a 14-day free trial, no credit card required.

The records you keep today are either the evidence you need during an inspection or the paperwork you wish you had during a supplier dispute. Either way, the time to build the habit is before you need it.