---
title: "How to Track Expiry Dates in Inventory: Batch & Expiry Guide for Businesses"
slug: "track-expiry-dates-inventory"
published: "2026-08-27"
author: "Ravi Chandel"
---

# How to Track Expiry Dates in Inventory: Batch & Expiry Guide for Businesses

To track expiry dates in inventory, list each batch with its expiry date, remaining quantity and location, then sort the nearest dates first and decide the next dispatch, transfer, supplier conversation or hold with your team. This matters when the same biscuit, medicine or packaged food item is spread across a main godown and branches.

Expiry loss usually starts earlier than the date printed on the carton. Goods can come in with less usable life than expected, sit behind a newer batch, or remain in a godown where the next customer is elsewhere. By the time someone notices, the purchase has already used cash and the stock may no longer be fit for the planned sale.

This is a simple expiry check for Indian retailers, wholesalers, FMCG stockists, pharmacies and medical shops, food and pharma businesses, manufacturers, and merchants with stock across godowns or branches. It is not a promise that software will choose the right batch or replace your quality and regulatory checks.

Use this check while your business can still act:

- **Retailer or medical shop:** check the batch before putting it on the shelf or billing it to a customer.
- **Wholesaler, stockist or distributor:** compare remaining shelf life with the next retailer order, route and receiving day.
- **Food, pharma or other manufacturer:** verify the batch when finished goods are received into storage and before releasing them to a customer or branch.
- **Multi-location merchant:** compare the nearest expiry and usable quantity at each shop, branch or godown instead of relying only on the combined total.

The common job is the same—make the batch, date, quantity and location visible early enough for a named person to act. What the customer will take, the physical inspection and the final action depend on your product and your own rules.

If the batch has already crossed its date or cannot be sold, use the [damaged-stock and wastage guide](/blogs/damaged-stock-wastage-inventory) for the quantity change. If you need to see how much money is tied up in that batch, read the [stock value report guide](/blogs/stock-value-report-inventory).

## Build an expiry record your team can act on

An expiry date by itself is not enough. For every item with an expiry date, keep these six fields together:

- **Item and pack:** for example, 500 mg tablets, 1 kg biscuit carton or 1 litre sauce case.
- **Batch number:** the identifier printed on that batch, not a new name invented by the godown team.
- **Expiry date:** the full date, including day, month and year.
- **Remaining quantity:** cartons, strips, pieces, kilograms or the unit used for dispatch.
- **Location:** the exact godown, branch or shop holding the batch.
- **Next check:** the person and date responsible for deciding what happens.

This small record answers the questions that cause most last-minute calls: what is expiring, how much is left, where is it, and who owns the next action. If one field is missing, do not merge the batch into a single item total and assume the risk has disappeared.

## Give each expiry task to the right person

Expiry control fails when the purchase team, godown team and sales team each hold part of the answer. Use a clear handoff:

- **Purchase or receiving staff:** capture the batch and expiry date when the inward arrives, compare the offered shelf life with the intended route, and flag a short-date delivery before it is racked.
- **Godown supervisor:** locate the cartons, check the printed batch/date and physical condition, keep uncertain stock aside, and confirm the quantity at each godown.
- **Sales or route team:** check the retailer’s accepted remaining life, delivery date and order quantity before asking for a short-date dispatch.
- **Owner or operations lead:** choose whether the stock should be dispatched, transferred, discussed with the supplier or held, and record who will follow up.

This handoff is especially useful when one office takes the purchase call, a Faridabad or Panipat godown stores the cartons, and a salesperson promises the retailer. The person who knows the price is not always the person who can confirm the batch on the shelf.

## Start with the batch, not only the item

“Paracetamol stock” or “biscuit cartons” is too broad for an expiry check. Write down the item, batch number, manufacturing date if available, expiry date, remaining quantity, unit and godown. Keep batches of the same item separate when their dates differ.

Use one date convention across the team. If the carton says 30 September 2026, record the date clearly rather than writing only “September.” If the date or batch mark is unreadable, put that quantity aside for a physical check instead of guessing.

Stock Register’s **Add New Batch** screen has fields for Batch Number, Purchase Price, Selling Price, Opening Stock, Opening Stock Date, Manufacturing Date and Expiry Date. The **Reports → Batch & Expiry Date Report** shows Item Name, Batch No, Mfg Date, Exp Date, Purchase Price, Selling Price and Current Stock, with filters for All Exp Dates or batches expiring in 7, 14, 30, 60 or 90 days. These records show what your team entered; staff still have to inspect the carton and confirm that the product is fit to sell.

Use these steps to find and act on the batch:

- **At item setup or inward:** open the item’s **Add New Batch** action and record the printed batch and dates instead of folding the quantity into one item total.
- **For the monthly or weekly review:** open **Reports → Batch & Expiry Date Report**, choose the relevant expiry window, and use Current Stock to make the quantity visible.
- **Before billing:** where an item has multiple batches, the sales invoice flow shows Batch Name and Exp Date and lets the user select which batch to bill.

The app makes the batch record easier to find; it does not replace a physical label check, a quality person’s sign-off or the customer’s remaining-life rule.

## Find the nearest expiry across every godown

Run the check by location, not only by the combined business quantity. A batch with 18 days left in Faridabad may need a different action from the same item with 42 days left in Panipat. A total of 24 cartons across both locations does not tell the dispatch team where the short-date cartons are sitting.

For each godown or branch, collect five facts:

- item and batch number;
- expiry date and remaining days;
- remaining quantity and unit;
- physical condition and storage location; and
- likely demand before the date.

Stock Register supports separate stock views for each store or godown, and its item-level Batch Details can show Batch No, Remaining Stock, Mfg Date and Exp Date. Use the [multi-godown stock view](/features/multi-godown) to select the location, then inspect the batch record instead of treating every carton of the item as the same. If a batch was moved, the [stock transfer history](/features/stock-transfer) can show the batch name and expiry date on the recorded transfer entry.

### Use practical expiry bands

The bands below are simple labels for your team, not Stock Register’s automatic recommendation. Set them around your product shelf life, route time and what customers will take.

| Band | What it means | Team question |
| --- | --- | --- |
| More than 90 days | Normal shelf-life window | Is the batch recorded correctly and stored in the right place? |
| 31–90 days | Check again soon | Which route or branch can use it before the next purchase? |
| 8–30 days | Short-expiry stock | Can a named customer accept it and can dispatch happen in time? |
| 0–7 days | Immediate attention | Should it be held, returned, or sold only under your documented business and product rules? |

Do not copy these bands blindly to every medicine or food line. A product with a two-year life and a product with a 30-day life need different checking schedules. The useful habit is to make the nearest date visible and name the person who will act next.

## Apply the check to the way your business dispatches

The same expiry report leads to a different conversation in each distribution business.

### FMCG stockist or retailer: compare the date with the route

For biscuits, packaged drinks, snacks and household consumables, compare the batch’s remaining life with the next route, retailer acceptance and normal delivery time. A carton that can move on tomorrow’s route is a different problem from one sitting in a branch that will not dispatch for three weeks. Keep the item, batch and route together when the salesperson calls for stock. If the main godown supplies several towns, add the route cut-off and receiving day to the handoff so the team does not treat all customers as equally close.

### Pharma business or medical shop: keep the batch visible through billing

For medicines, the batch and expiry date must stay visible when the team prepares a customer, retailer or medical-shop order. Confirm the product, batch, quantity and what the customer will take before billing. A pharma wholesaler, distributor or medical shop should also keep the purchase bill and supplier messages with the batch record when a short-date inward needs follow-up. If the date, batch mark or storage condition is unclear, hold the stock for the named person rather than asking a picker to choose from memory.

### Food business or stockist: check date and condition at inward and storage

For food items, record the batch when cartons come in and check that the physical condition and storage location suit the product. A food stockist should separate a damaged or unclear carton from saleable stock while the receiving or quality person decides what to do. A recorded date cannot answer whether a seal is damaged, a carton was stored incorrectly or a customer will accept the remaining life. Those checks belong to the receiving and quality check.

## Calculate the usable dispatch buffer

Do not ask only, “How many days are left?” Ask, “How many days are left after the order can realistically reach the customer?”

Use this simple calculation:

**Usable dispatch buffer = days until expiry − days needed for picking, transport and customer receipt.**

For example, a Faridabad batch with 18 days left and a five-day route-and-receipt cycle has a 13-day buffer. That may fit one retailer’s requirement and fail another’s. The number is a prompt for a customer and route check, not an automatic clearance rule.

## What to do when the short-date batch is found

There are four common next actions. The owner or team chooses based on product condition, what the customer will take, supplier terms and local rules.

### Dispatch the right batch when demand is real

If a retailer order or route can use the batch within its accepted remaining life, make the batch visible to the person preparing the dispatch. Confirm the customer’s requirement and the physical carton before billing. In Stock Register, the sales invoice screen can show batch and expiry information and lets the user select a batch where multiple batches exist.

Do not treat “oldest first” as permission to dispatch a product that a customer will reject. Remaining shelf life, storage condition and customer policy still matter.

### Transfer only when the destination can use it

A short-date carton at a slow branch may be useful at another godown with a known order. Check the destination’s demand, travel time and receiving process before moving it. Record the inter-godown transfer when the move is approved; do not count an informal vehicle note as a completed stock record.

The [stock transfer record](/features/stock-transfer) records the source, destination, item, quantity, date and creator; batch name and expiry date are shown for batch-tracked items. It helps record the move, but it does not track goods while they are in transit or decide whether moving them is worth it.

### Discuss a return or replacement with the supplier

If the received shelf life is too short for the intended route, gather the purchase bill, batch details, receipt date, quantity and photographs your process requires. Ask the supplier what their return or replacement terms allow. Keep the batch separate while the discussion is open if your product and quality process requires it.

This is a supplier and quality decision. Stock Register records the purchase and batch information entered by your team; it does not negotiate a return or approve the batch.

### Hold when the date or condition is unclear

Do not dispatch a carton when the expiry mark, batch identity, seal or storage condition needs checking. Mark the quantity, location and person responsible for inspection. Release it only after your business process confirms that it is fit and acceptable.

## Six cartons with 18 days left at Faridabad

Take a biscuit batch at a Faridabad main godown, with a Panipat branch also carrying the item. The figures below are sample stock figures for showing the handoff: the owner can ask Faridabad to dispatch against an accepted order, check whether a recorded transfer will help, or start a supplier conversation. The same check works for a retailer with one back room, a wholesaler with several branches or a manufacturer holding finished goods.

| Location | Item and batch | Expiry window | Remaining stock | First question |
| --- | --- | ---: | ---: | --- |
| Faridabad main godown | Biscuits, B-104 | 18 days | 6 cartons | Is there a retailer route that accepts this life? |
| Faridabad main godown | Biscuits, B-118 | 74 days | 14 cartons | Keep in the normal monthly check |
| Panipat branch | Biscuits, B-117 | 42 days | 8 cartons | Can Panipat sell these before its next inward? |
| Panipat branch | Biscuits, B-121 | 112 days | 20 cartons | No short-date action yet |

The important handoff is six Faridabad cartons at 18 days, not “28 biscuit cartons.” The owner can ask Faridabad to dispatch against an accepted order, ask whether a documented transfer is useful, or start a supplier conversation. No automatic action follows from the table.

## Make the next inward safer

An expiry review is most valuable when it changes the next purchase conversation. Before accepting another inward of the same item, ask:

1. Which batch is already at each godown?
2. How much of it can the normal routes use before expiry?
3. Is the supplier’s offered shelf life suitable for the quantity and season?
4. Will the new inward sit behind an older batch?
5. Who will check the batch and date when the goods arrive?

Record the batch and expiry date at receipt, not after the cartons have been mixed into a rack. Review the batch-and-expiry report on a set schedule—weekly for short-life lines and at least before a large purchase for longer-life lines. Add the nearest-expiry batches to the team’s dispatch conversation, while keeping quality and customer acceptance checks separate.

The [batch and expiry date report](/features/batch-expiry-tracking) can filter batches by 7, 14, 30, 60 or 90 days and show Current Stock alongside the batch, date and price fields. Use it to see which batches need attention. The report does not tell you the discount to offer, purchase quantity, customer promise or return decision.

## Keep expiry control separate from dead-stock reporting

Stock that has not moved and stock that will expire are related but not identical. A fast-moving item can still have one short-date batch. A slow item can have a long expiry date. Do not use a generic dead-stock list as a substitute for checking batch dates.

For movement context, review the [item ledger and recorded stock history](/features/stock-tracking) for the item and location. It can show entries such as purchase, sale, transfer or adjustment, with the recorded quantities and running balance. It cannot prove that the carton is physically present, correctly labelled or fit for sale.

## Common expiry-control mistakes

### Treating the item as one pool

Combining all batches hides the nearest date. Keep batch, quantity and location visible together.

### Recording the date after inward

Once cartons are mixed, staff may not know which date belongs to which quantity. Capture the batch at receiving time.

### Sending short-date stock without customer confirmation

An older batch is not automatically acceptable. Confirm the retailer’s remaining-life requirement before dispatch.

### Assuming a transfer solves the risk

A transfer only helps if the receiving location can sell or use the stock in time. Check demand and travel time first.

### Treating a report as a physical inspection

The report reflects recorded information. Check the carton, seal, date, batch mark and storage condition before release.

## A simple weekly expiry checklist

- Filter the batch-and-expiry report for the next 7, 14, 30, 60 and 90 days as relevant to the product.
- Sort the list by nearest expiry and separate each godown’s quantities.
- Physically locate the short-date batch and verify its label and condition.
- Check known retailer orders and route plans that can use the stock in time.
- Decide dispatch, transfer, supplier conversation or hold, and name the person responsible.
- Record the next inward’s batch and expiry before putting cartons into the regular rack.
- Check the same item’s existing batches before accepting another purchase.

## Frequently asked questions

### What should I check first when stock is nearing expiry?

Check the batch number, expiry date, remaining quantity, physical condition, location and likely customer demand. Put the nearest date first, then decide the next action with your team.

### Can I see expiry stock by godown?

Stock Register supports stock views per store or godown, while batch records show the batch number, remaining stock and expiry details. Select the relevant godown and inspect the item’s Batch Details; the result depends on the batch and location entries your team has recorded.

### Does Stock Register automatically choose the batch to dispatch?

No. It shows batch and expiry information and lets the team select a batch during billing where supported; dispatch priority remains a business decision.

### How should I handle a short-expiry inward?

Record the batch and expiry date at receipt, check whether the remaining life fits your customers and planned route, and discuss a return or replacement with the supplier if it does not.