How to Track Expiry Dates in a Grocery Store and Cut Waste

Every packet that expires on the shelf is money lost twice: you paid for it and you cannot sell it. In a grocery, a small number of items cause most of the waste: dairy, bread, snacks, packaged sweets, sauces and some oils. Managing expiry is mostly a matter of recording dates at the moment stock arrives and looking at them regularly. Here is a way to do it.

Step 1: record the batch and date on arrival

When a delivery comes in, the person receiving it should check the expiry or best-before date of each item and enter it in the purchase record. This is the single most important step, because everything else depends on it. Make it part of the receiving routine: a delivery is not accepted until the dates are entered. If an item arrives with very short remaining life, you can refuse it or negotiate a return at once, rather than discovering the problem weeks later.

Step 2: sell the oldest first

On the shelf, put the older stock at the front and the new stock behind it. In the system, sale from the oldest batch first. If your software does this automatically at billing, you avoid situations where the newer batch is sold while the older one quietly reaches its date. Train shelf staff to rotate stock whenever they refill, and not to push new packs in front.

Step 3: review the expiry report on a schedule

Choose a regular day, for example every Sunday, and print the report of items expiring in the next thirty days. For each item decide one of the following actions:

• Move it to a more visible shelf or near the counter.
• Offer a discount or bundle it with a popular item.
• Return it to the supplier, if your agreement allows.
• Donate or discard it when the date has passed, and record it as wastage.

Short-life items like bread and dairy might need a weekly or even daily check, while canned and dry goods can be checked monthly.

Step 4: use different windows for different goods

Type of item	Suggested review	Typical action
Bread, milk, curd	Daily	Reduce price near the date, remove on the date
Snacks, biscuits	Weekly	Bundle or discount
Sauces, oils, canned food	Monthly	Rotate stock, supplier return if allowed
Non-food items	As needed	No expiry tracking unless relevant

Step 5: write off properly

When an item is thrown away, record it as expired or damaged stock with the quantity and date. If you simply delete it, the stock report will not tally and your profit will look better than it is. A monthly wastage total by supplier and by category tells you which suppliers to question and which items to order in smaller quantities.

Step 6: learn from the pattern

If the same item keeps appearing on the expiry list, you are buying more than you sell. Reduce the order quantity or order more often in smaller amounts. If a supplier's goods often arrive with short dates, raise it with them. Your records give you the facts to make the conversation easy.

Where software helps and where it does not

Software keeps the dates, orders the batches and produces the list. It cannot look at the shelf for you. A system is only as good as the discipline of entering dates and checking the list. The shops that do this well treat the expiry report as a routine job and give one person responsibility for it.

Handling short-dated stock at delivery

Agree with suppliers in advance what remaining shelf life you will accept on delivery, for example a minimum number of weeks for packaged snacks. When something arrives below that line, refuse it or ask for a credit note on the spot. Suppliers adapt quickly when a store checks consistently, and your later waste falls as a result. Put the agreed rule in writing so the receiving staff can point to it without an argument.

Discounts that work and ones that do not

A discount on short-dated goods is better than a total loss, but it works best when it is planned. Use a modest reduction a few weeks ahead rather than a deep cut on the last day. Put the item where customers will see it and mark it clearly. Avoid selling goods past their date for any reason; it is bad for customers and for your reputation. Record the discounted sales so you can see which actions actually reduced waste.

Godown and cold storage habits

Expiry problems often begin in the godown, not on the shelf. Arrange the back store so that new deliveries go behind or below older stock, and label each shelf with the month of arrival. For items that need cool storage, such as dairy and some sauces, check the fridge temperature and avoid overloading it. Walk through the godown once a week with the expiry report in hand and compare what you see with what the list says. You will find boxes that were pushed behind others and forgotten, and recovering them in time is the cheapest saving in the shop.

During festivals the godown fills with bulk purchases. Write the expected sale period on the carton so that staff know which stock to move first, and avoid ordering more than you can sell before the date.

Next step

This week, pick one category, such as snacks, and write down the expiry dates on the shelf and in the godown. You will probably find items that should already have been moved. To see how batch and expiry tracking looks on screen, visit our grocery software page. If you also run a pharmacy counter, our pharmacy management software covers batch and expiry for medicines separately.

Get a demo and quote for Grocery and Supermarket 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 Grocery and Supermarket Software