Batch and expiry tracking for pharma distributors, and what it costs to get wrong

For a pharma distributor, batch and expiry are not inventory nice-to-haves. They are the difference between a recall you can execute and one you cannot, and between a near-expiry return you get credit for and one you eat.

Most distributors track them on the box and in their head. That works until the day it does not.

What batch tracking is actually for

Four things, in ascending order of how expensive it is to fail at them.

Knowing what to sell first. Stock does not expire evenly. The cartons at the back are older.

Getting expiry credit from your supplier. Most pharma supply agreements allow returns of near-expiry or expired stock within a window, at a stated rate. Claiming it needs batch number, expiry date, quantity and usually the original purchase invoice. No batch, no claim.

Answering a retailer's return. A chemist returns three strips. Which batch, bought when, at what rate, still within the return window? Without a record this becomes a negotiation instead of a lookup.

Executing a recall. When a batch is recalled you need to know which retailers received units from it. This is the one that is not about money. If you cannot answer it, you cannot comply.

FEFO, not FIFO

FIFO — first in, first out — sells the oldest purchase first. For pharma that is the wrong rule.

FEFO — first expired, first out — sells the batch that expires soonest first, regardless of when you bought it. These differ more often than you would think, because a supplier can ship you stock with a shorter remaining life than what is already on your shelf.

The practical version, at the point of picking: look at the expiry, not at the dust.

The near-expiry window

Expiry returns are governed by your agreement with the supplier, and the terms vary. What is common:

• A window before expiry when goods can be returned, often three to six months.
• A credit rate that may be less than what you paid.
• A requirement that goods are in saleable condition, in original packing.
• A cut-off after which nothing is accepted.

Two mistakes cost real money here.

Missing the window. Stock that goes past the return date is a total loss instead of a partial credit. This is the most common avoidable write-off in pharma distribution and it happens for one reason: nobody was watching the dates.

Returning goods that are still sellable. The opposite error. Something with four months left and steady demand should be sold, not returned at 80 per cent.

The decision needs two facts per batch: how long until expiry, and how fast that item is moving. Days of cover against days to expiry — the same cover figure used to find dead stock. If cover exceeds the time remaining, you will not sell it, so return it while you still can.

A system that survives a real godown

You are not going to run a warehouse management system with barcode scanners. Here is what actually holds up.

Capture batch and expiry at goods inward, from the bill. Not later. The supplier invoice has both printed on it. If they are not recorded when the stock arrives, they will never be recorded.

Record them on the sales invoice too. This is the half people skip, and it is the half a recall depends on. Without batch on the outward side you know what you received and not where it went.

Keep a near-expiry list and look at it monthly. Everything expiring in the next six months, sorted by value. This is a five-minute review that prevents four-figure write-offs.

Physically separate the returns shelf. Goods coming back from retailers should not go into saleable stock until someone has looked at the expiry.

What it costs to skip

A distributor holding ₹40 lakh of pharma stock, with 2 per cent going past its return window each year, is writing off ₹80,000 that was recoverable. That is a conservative figure and it recurs annually.

The recall case has no number attached. It is a regulatory obligation, and "we do not have those records" is not an answer that improves with explanation.

The awkward truth about data entry

Everything above depends on batch and expiry being captured on every purchase line, and there can be forty of them on a single bill.

Typing a batch code is the most error-prone data entry in distribution — alphanumeric, no meaning, no way to spot a mistake by eye. AZ4471K and AZ447IK look identical on a printed bill and one of them will not match anything when you try to claim.

This is why batch tracking is widely agreed to be essential and widely not done. It is not that distributors do not understand the value. It is that the cost of capture is paid every single day and the benefit shows up once a year.

Where Dhela fits

Dhela reads batch and expiry off the supplier bill along with everything else, so they are captured at goods inward without anyone typing an alphanumeric code from a faint carbon copy. They carry through to the sales invoice, so the outward side exists too.

From there the near-expiry list is a query rather than a stock take, and a batch can be traced from the bill it came in on to the retailers it went out to.

Free plan, no card. dhela.in