Skip to main content
Early accessBeta, invite only since 1 Nov 2026. A person reads every application.Apply for an invite
Demystify OS

How do I track near-expiry medicine stock as a distributor?

Export stock with batch and expiry every week, group batches by months left, and act on each group: return to the supplier while the window is open, push-sell only unexpired stock, and decide the rest. Expired stock is outside this routine, so ask your licensed pharmacist about it. Keep party-wise records.

Who asks this: An owner or stock manager at a medicine distributorship in India who finds expired strips on the shelf only at the yearly stock check, and who wants a weekly routine that catches batches while a return or a sale is still possible.

The steps

  1. 1. Export stock with batch and expiry

    Every week, take the stock report from your billing software with item, batch, quantity and expiry date. If your system cannot print expiry, keep a sheet for new receipts and fill expiry at goods inward. Without the date, nothing downstream works.

  2. 2. Group batches into buckets

    Sort by months left: under three months, three to six months, six to nine months. Leave expired stock out of every list below; this page does not cover how it is handled. Pick limits that match your suppliers' return windows and your retailers' selling speed.

  3. 3. Check the supplier return terms

    For each bucket, look up each supplier's terms on returns: how many months before expiry they accept, and what paperwork they need. Write the last return date beside each batch. These windows are contractual terms with the supplier, not a legal safe-sale period. An unexpired batch past its return date becomes a push-sale or write-off decision; an expired one never joins a push list.

  4. 4. Draft the return and the push-sale lists

    Make two lists: batches to return, by supplier, and batches to push (unexpired stock only), by item with a suggested retailer group. The owner decides discounts, not the salesperson. Send the return list to each supplier's representative with the dates.

  5. 5. Keep party-wise records

    Record which retailer received which near-expiry batch, with the date and the agreed terms. If a retailer later returns stock, you can see what was sold as short-dated. This protects you from disputes in both directions.

  6. 6. Close the loop every week

    After a week, check what moved and what remains. Move the rest to the next bucket. For expired stock, ask your licensed pharmacist what to do, because this page does not cover it. Keep a short note of the loss, so the buying team can see which items expire repeatedly.

A worked example

illustrative

A distributor in Pune with a stock worth about two crore rupees runs the routine every Monday. The export shows forty-one batches under six months. Eleven belong to one supplier whose return window is three months before expiry, so those eleven, worth about one lakh sixty thousand rupees, go on a return list with a date. Fifteen are fast-moving and go to retailers with a small discount approved by the owner. The remaining fifteen go to the next Monday's bucket. Any expired batches are in neither list and go to the pharmacist. The sheet records who bought which batch, so a later query is answered in minutes.

What goes wrong

  • Expiry is not recorded at receipt, so the first time anyone sees it is at the yearly count.
  • The return window passes because nobody wrote the last date beside the batch.
  • Discounts are given by salespeople, and margins vanish on items that would have sold anyway.
  • Short-dated stock is sold to a retailer without a note, and a dispute follows.
  • Buckets are checked monthly, which is too slow for a three-month window.
  • The same fast-expiring item is bought again in bulk because the loss was never shown to the buyer.

How Demystify OS helps

  • Dispatch the nearest expiry ahead of the rest and watch near-expiry stockEarly access

    For manufacturers, this workflow picks the batch that expires soonest for a distributor invoice and lists finished stock close to its expiry date. The list covers a fixed window and sends no alert.

  • Watch near-expiry stockEarly access

    For retail counters, a near-expiry card lists items close to or past their date, for items that carry batches and dates. It is a retail counter view, not a distributor return planner.

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to read the stock and batch export you share, group batches by months to expiry and draft return and push-sale lists for your approval. It is not yet a standard catalogue entry.

What it does not do. Demystify OS does not advise on the use of any medicine, does not confirm compliance with licence conditions or the lawful way to return or dispose of expired stock, and does not decide discounts or write-offs; those stay with you and your licensed pharmacist.

Questions people ask

How early should I act on near-expiry medicine stock?

Act when a batch enters the bucket that matches your supplier's return window, often several months before expiry. Check each supplier's terms and write the last return date beside the batch. Acting late turns a return into a write-off.

Who should approve discounts on short-dated stock?

The owner or a named senior person, not the salesperson. Set a simple ladder by months left, such as a small discount at six months and a larger one at three, and review it quarterly against what actually sold.

What records should I keep for near-expiry sales?

Keep the retailer, the batch, the quantity, the date and the terms agreed. If the retailer returns stock later or a question arises, you can answer from the record. Keep these with your normal sales records.

Can I sell near-expiry stock at all?

Rules on selling short-dated stock depend on your licence conditions and vary by licence type and state, and this page states none. Ask your licensing authority or advisor. Leave expired stock out of every list on this page and ask your licensed pharmacist what to do with it.

How often should I run the expiry check?

Weekly is a good rhythm for a distributor, because return windows are measured in months and a week is a small slice. Daily checks add effort without much gain, and monthly checks let batches slip past a window.

Apply for the beta.

Demystify OS is invite only, and a person reads every application.

Apply for the beta