Batch and Expiry Tracking for Pharmacy Stock: How It Works

Batch and expiry tracking means recording, for every medicine you receive, the batch number and the expiry date, then using that record to sell older stock first and to flag anything close to its date. It is the single most useful control in a pharmacy because it turns a surprise loss into a manageable list. This article explains the process step by step. It covers stock records only and offers no medical guidance.

Why batch matters, not only expiry

Two boxes of the same product can have different expiry dates and different batch numbers. If a company announces a problem with a specific batch or asks for a return, you need to know whether you hold that batch and how many units. Without batch records you must search the shelf by hand. With them, you answer from the screen.

Step 1: Record at the time of purchase

Do this while the delivery is in front of you. For every line on the supplier bill:

1. Check the product name and pack size against the bill.
2. Read the batch number on the carton or strip.
3. Read the expiry date, and record it as month and year in a consistent format.
4. Count the quantity received and note any damage.
5. Enter the purchase rate and the selling rate or MRP as per your practice.

If a bill contains two batches of the same product, enter two lines. Never merge them, or the earliest expiry will be hidden.

Step 2: Shelve in order

Place newer stock behind older stock so the oldest is picked first. This is often called first-expiry-first-out. Label shelves by product or company so staff can find the right box. If you use rack codes in the software, keep them current.

Step 3: Sell the earliest batch first

At the counter, staff pick from the front of the shelf. The bill should reflect the batch that was handed over. A system that suggests the earliest batch speeds this up and reduces mistakes, because staff do not have to remember which is which. If the batch on the bill differs from what is in your hand, your stock will drift out of sync over time.

Step 4: Review near-expiry stock on a schedule

Decide a rhythm and follow it. Many shops use a monthly review with three windows:

Window	Action
Six months to expiry	Watch. Push through normal sales and avoid reordering
Three months to expiry	Contact the supplier about return or exchange if their policy allows
One month to expiry	Decide whether to sell at a lower margin or prepare a return
Expired	Remove from the shelf and record the write-off or return

The right windows depend on the product and the supplier's return policy, so agree these with your distributors in advance. Some will accept returns only within a set period before expiry.

Step 5: Handle expired and damaged stock

Expired medicines must leave sale immediately. Keep them physically separate and label the box. Record them as either a return to the supplier or a write-off, with date and reason. Follow the disposal requirements that apply to you; ask the regulator or your association about the correct procedure rather than guessing.

Recording the loss also lets you analyse it. If most expiry losses come from one company or one category, you know where to order less.

Step 6: Keep returns to suppliers tidy

• Prepare a list of items with batch, expiry, quantity and purchase bill reference.
• Give a copy to the company representative and keep your own.
• Record the return so the supplier ledger shows a credit once accepted.
• Follow up if an accepted return does not appear on your account.

What to do when batch details are missing

Real life is untidy. Some deliveries arrive with a damaged label, a smudged expiry or a loose strip with no carton. Decide a rule in advance: no entry without batch and expiry, with the item set aside until it is resolved. If you must enter it, mark it with a temporary note and fix it within the day. Allowing blank dates teaches staff to leave them blank, and the whole control weakens.

The same applies to stock you already hold when you begin. Count it once, record batch and expiry for each box and enter these as opening stock. It takes effort on day one but means every report is usable from the first week. If this is too heavy, start with the highest-value items and the ones with the shortest shelf life, then add the rest over a month.

Paper versus software

On paper, you can record batch and expiry in a register, but searching it is slow and a monthly review means reading pages. Software makes near-expiry lists instant and enforces entry at purchase. WebsNP Pharmacy Management Software keeps batch and expiry on the stock record, sells earliest-first and prints expiry reports by month and supplier. For wholesale and distribution businesses carrying cartons, wholesale and distribution software may also be relevant.

Common mistakes

• Merging batches in one stock line.
• Skipping expiry entry on busy delivery days.
• Buying large quantities of slow items because the discount looked good.
• Failing to check returned goods from customers for date and condition before returning them to the shelf; follow your own policy and the regulator's guidance.
• Not recording opening stock with its dates when you start a new system.

Next step

Start with one category this week. Count it, write batch and expiry for each box and see what you learn. Then decide whether to scale it. If you would like to see it handled automatically, message WebsNP on WhatsApp at +977 9846280400 and ask for a pharmacy demo.

Get a demo and quote for Pharmacy Management Software

Tell us about your business and we will reply the same working day with a demo and a clear quote. No obligation.

Chat on WhatsApp

Or call / WhatsApp +977 9846280400

Your name Phone / WhatsApp Email (optional) Business / organisation What do you need?

Request demo

More guides on Pharmacy Management Software