Batch and expiry tracking for medical distributors: why it matters, and how to manage it
Every medical distributor tracks batches somewhere. The question is whether that somewhere is the system the invoices come out of, or a register that one person maintains and everybody else trusts.
Distributors whose stock has a date on it
This guide is for medical and pharma wholesalers, and for anyone else distributing goods with a shelf life — food, cosmetics, agricultural inputs. The mechanics are the same wherever a batch number and an expiry date have to follow the goods.
- Wholesalers holding the same item in several batches at different MRPs
- Businesses where goods often move before the supplier's bill is entered
- Distributors carrying stock in more than one godown
- Anyone reconciling a physical batch register against a software stock figure
Why a quantity is not enough
A stock figure of 480 units tells you almost nothing useful in this trade. Those 480 units are several batches, bought at different times, possibly at different MRPs, and some of them expire sooner than others. Four questions get asked constantly, and a plain quantity answers none of them.
First: what is going to expire, and how much is it worth? That is a write-off waiting to happen, and the only cheap moment to act on it is months in advance. Second: which batch do I ship? Without a rule, staff pick whatever is nearest the door. Third: at what MRP? The same item at two MRPs in the same godown is routine, and getting it wrong on an invoice is a credit note at best. Fourth: if a batch has to be traced, who did we sell it to?
A business can answer all four from a register kept alongside the software. Many do. The cost is that the register and the stock figure drift, and the drift is only ever discovered during a stock-take or an argument.
Six things worth insisting on
The batch is on the stock, not beside it
Batch and expiry belong on the stock record itself, so every movement carries them automatically rather than by somebody remembering.
Expiry visible at the point of sale
The person raising the invoice should see available quantity, expiry and MRP together, at the moment they choose — not in a report afterwards.
Expired batches flagged
Not hidden, not silently excluded — flagged, so the person can see what is there and why they cannot ship it.
A way to enter batch at sale
Goods regularly leave before the purchase bill is keyed. If the system cannot accept batch and expiry at the point of sale, the workaround becomes a spreadsheet.
Per-godown stock
Batch positions per location, because “we have it” is not useful if it is in the other godown.
A rule about what staff can do
Whether selling into negative stock is allowed, questioned or blocked should be a setting, not a habit that varies by who is on shift.
The same list, made concrete
Everything above is a general standard. For completeness, here is how it is handled in our own software — apply the same questions to whatever else you are looking at.
Stock is held by batch, and batches carry expiry dates and MRP. On a sale, a batch-wise picker shows available quantity, expiry and MRP together, and expired batches are flagged. Where goods go out before the supplier's bill has been entered, batch and expiry can be entered manually at the time of sale. Stock is held per warehouse, and negative stock control is set per branch to Allow, Ask and Continue, or Block.
Two related controls sit on the party rather than the stock: Drug Licence and Food Licence numbers are held with their expiry dates, and an expired licence blocks new invoices to that party. Narcotic items carry a flag on the Item Master, and one cannot leave the building to a party lacking either a GST number or a current Drug Licence.
What it does not do is produce statutory drug registers or handle regulatory filing. It holds the underlying data; your obligations remain yours.
Practical steps if you track this on the side today
Count what you actually have
Batch-wise, godown-wise, with expiry and MRP. This is the painful part and it only has to be done once properly.
Decide the rules before you load
Which items need batch tracking, which need serial, and what happens when stock would go negative.
Load stock with the detail intact
Loading plain quantities to save a week costs you the next several years of the same problem.
Retire the register deliberately
Run it alongside for a short, fixed period to build confidence, then stop. Two records maintained half-heartedly is worse than either alone.
Questions we get asked
Do we need batch tracking on every item?
No, and turning it on everywhere adds work at the counter for no benefit. Track batches where expiry, recall or MRP variation actually matter.
What is the difference between batch and serial tracking?
A batch covers many units produced together; a serial number identifies one unit. Distribution usually needs batches; high-value goods sometimes need serials.
How do we handle goods sold before the purchase bill arrives?
Make sure the system lets you enter batch and expiry at the point of sale. Otherwise that case becomes the reason a side spreadsheet exists.
Should expired stock be hidden from the sales screen?
Flagged rather than hidden. Staff need to know it is physically there, and somebody has to decide what happens to it.
Can batch tracking stop us selling to an unlicensed party?
That is a separate control, sitting on the party record rather than the stock — licence numbers with expiry dates, and a block on invoicing when one has lapsed.
Does this replace our statutory registers?
No. Good batch data supports whatever registers you are required to keep, but it does not produce them, and it is not regulatory advice.
Still tracking batches on the side?
Show us the spreadsheet on a demo call and we will tell you honestly how much of it the software can absorb.
Book a demo