Skip to content
All posts
6 min readIMS Team

Pharmacy distribution inventory: a complete guide

How a pharma distributor manages stock, batch, expiry, returns and party credit across many retailers, with a weekly checks table you can run in your godown.

A pharma distributor manages stock by batch and expiry, not just by item. It dispatches the nearest-expiry batch that the retailer can still sell, and it tracks every retailer party's credit and returns next to the stock. The routine that holds this together is a weekly check of three things: stock by batch, near-expiry stock, and party outstanding. Everything below explains why each one matters and how to run it.

How is distributor stock different from a pharmacy counter?

A chemist shop sells over the counter. Most sales are small, many are for cash, and stock leaves only one way: to the customer. A distributor's godown works differently in four ways.

Many parties. You supply dozens or hundreds of retailers, and each one has its own order pattern, discount terms and payment habits. A single item can be on order from twenty parties in one day.

Credit. Most of your sales are on credit, so stock that has left the godown has not yet turned into cash. If you know your stock but not what each party owes, you have half the picture.

Batch and expiry. Every strip, bottle and vial carries a batch number and an expiry date. Two cartons of the same item can have very different value if one expires in three months and the other in eighteen.

Returns. Retailers send back near-expiry, expired, damaged and wrongly supplied goods. You then have to raise matching claims with the company or its stockist. Returns run in both directions, and each one has to be traced to a batch.

The general mechanics of running a multi-party godown are covered in our wholesale distributor inventory guide. The rest of this post looks at what pharma adds on top of that.

Why must stock be tracked by batch, not just by item?

Expiry, recalls and returns all happen at batch level. If your records show "Item X: 400 strips" but not how those 400 strips divide across batches, you cannot answer basic questions. Which strips expire first? Which party received a particular batch? Does a returned strip actually belong to a batch you supplied?

At receipt, enter the batch number, expiry date and MRP exactly as printed, for every line on the purchase bill. At dispatch, print the batch and expiry on the sale bill. That one habit makes returns, claims and recalls traceable. Our post on pharmacy batch and expiry with FEFO goes through receiving and shelving in detail.

Which batch should go out first?

As a default, the batch with the nearest expiry, which is first-expiry-first-out (FEFO). For medicines this is safer than first-in-first-out, because a later delivery can carry an earlier expiry. The differences between the methods are set out in FIFO, LIFO and FEFO explained.

A distributor adds one refinement: think about the receiving party's sell-through. A large retailer that moves an item quickly can take a shorter-dated batch and sell it in time. A small party that buys the same item once a month cannot. If you push short-dated stock to slow parties, it comes back as an expiry return. Match the batch to the party, not only to the date.

How should returns be handled?

Treat every return as a stock transaction with a reason, not as a credit note that sits on its own. For each return, record:

  • the party, the original bill and the batch
  • the reason: near-expiry, expired, damaged, short-supplied or wrongly supplied
  • whether the goods go back into saleable stock, into a separate expiry or damage location, or out for a claim with the company

Keep returned goods that cannot be sold in a separate location in your records and physically apart in the godown, so they never get picked by mistake. Then follow up the claims with the company on a fixed cycle. Unclaimed expiry returns are one of the quiet losses in pharma distribution.

What should a distributor check every week?

The routine below fits a small team. The point is to catch problems while there is still time to act.

CheckWhat to look atWhat to do if something is off
Stock by batchSystem quantity per batch against a physical count of a rotating set of fast moversFind the cause (wrong batch picked, entry error, unrecorded return) and correct it at batch level
Near-expiry stockBatches due to expire within your chosen window, sorted by expiry monthPush to fast-moving parties, ask the company about its return or replacement terms, stop reordering that item
Expired and damaged stockQuantity sitting in the expiry or damage locationMake sure it is kept apart, then raise or chase the claim with the company
Returns receivedReturns logged this week by party, batch and reasonCheck that each return matches a batch you supplied, and flag parties with frequent returns
Party outstandingAmount due per party and how long it has been dueCall the overdue parties, and hold or limit fresh dispatches beyond the agreed credit period
Pending ordersOrders taken but not billed, and items short against themReorder the short items, and tell parties about delays before they find out from an empty delivery

Set your near-expiry window to suit your parties' sell-through and your companies' return terms. Write it down so everyone in the godown uses the same one.

Can you show a worked example?

The figures below are illustrative.

A distributor holds 600 strips of one item in three batches:

  • Batch A: 120 strips, expires in 4 months
  • Batch B: 300 strips, expires in 14 months
  • Batch C: 180 strips, expires in 20 months

Two orders arrive. Party 1 is a busy retailer that sells about 100 strips a month and orders 100. Party 2 is a small shop that sells about 10 a month and orders 20.

Strict FEFO would send Batch A to both parties. Party 1 will sell its 100 strips well inside four months, so A suits it. Party 2 would take two months to sell 20 strips. That fits inside four months on paper, but leaves almost no margin, and small shops often hold stock longer than planned. Send Party 2 strips from Batch B.

That leaves 20 strips of Batch A. The weekly near-expiry check flags them, and they go out with Party 1's next order. Nothing comes back as an expiry return.

Before billing either party, check outstanding. If Party 2 is well past its credit period, the right move may be to hold the order until it pays, whichever batch it would get.

What are the common mistakes?

  • Entering stock by item only. If the batch is not captured at receipt, it cannot be traced at return or recall.
  • Dumping short-dated stock on small parties. The loss is not avoided. It comes back as a return a few weeks later.
  • Mixing returns into saleable stock. Expired goods end up on the dispatch table.
  • Not chasing claims. Expiry returns pile up in a corner and are never raised with the company.
  • Looking at stock and credit separately. Fresh stock goes out to a party whose last three bills are unpaid.
  • Counting once a year. Batch mismatches build up for months and nobody can explain them.

When does this not apply?

If you run a single retail counter and do not supply other businesses, the party-credit and outbound-returns parts of this routine matter less. The batch and expiry discipline still applies in full. Licensing, scheduled-drug record-keeping and other regulatory requirements are outside the scope of this post. Check those with the relevant authority or your advisor.

FAQ

How is a pharma distributor's inventory different from a chemist shop's? A chemist sells to walk-in customers, mostly for cash, one strip at a time. A distributor supplies many retailer parties on credit, in larger quantities, and takes back returns. So the distributor tracks stock by batch and expiry, and also tracks what every party owes and what it has sent back.

Which batch should a distributor dispatch first? Usually the batch with the nearest expiry that still leaves the retailer enough time to sell it. This is first-expiry-first-out. Do not send a short-dated batch to a slow-moving party just to clear it. It tends to come back as an expiry return, and you have only moved the loss.

How often should a distributor check near-expiry stock? Look at it every week, sorted by expiry month and batch, so short-dated stock is seen while there is still time to act. Every month, check the slow movers and pending expiry claims with the company. A check done only once a year finds expired stock when nothing can be done with it.

Should party outstanding affect what stock a distributor dispatches? Yes. Before billing, check each party's outstanding amount and how long it has been due. If a party is well past its agreed credit period, hold or reduce the order until it pays. Extra stock on credit to a slow payer ties up both your inventory and your cash.


Related reading: pharmacy inventory: batch and expiry with FEFO, wholesale distributor inventory and FIFO, LIFO and FEFO explained.

Get new posts by email

Occasional, practical, no spam.