Supplier Shelf Life at Delivery: Build a Scorecard

The carton that arrived with five weeks left

The delivery boy is in a hurry. You count the cartons, sign the challan, and he's gone. Three weeks later someone pulls a case of biscuits or cough syrup off the back shelf and it's two weeks from expiry. You check the bill. It was delivered like that.

You can't remember whether this keeps happening with one distributor or whether it's just bad luck. You have a feeling about it. A feeling won't get you anywhere with a sales rep who'll tell you "sir, the company sent that batch, what can I do."

This post is about turning that feeling into a record: one row per supplier, built from your own receiving entries, that you can put on the table next time the rep walks in.

Why short-dated stock lands on your shelf

Picture a distributor's godown at the end of the month. There are several batches of the same product. Some came in recently, some have been sitting for a while. Whoever packs the orders has a target to meet and a van to load. The oldest batch has to go somewhere, and it usually goes to the account least likely to check it.

That's the whole mechanism. Nobody has to be dishonest. Older stock simply drifts toward the stores that sign without looking at the dates. If you never record the date at receiving, you're one of those stores, and you can't tell this distributor's habits from that one's.

Picture the same thing with trade schemes. A scheme pushes extra cases into your store, and those cases tend to come from whatever the distributor has too much of. We cover that pattern in trade schemes and stock pushing. Bulk scheme stock is a common source of short dating.

Three numbers per supplier

You don't need a big dashboard. For each supplier, track three things:

• Remaining shelf life at delivery. Take the days left until expiry on the day the stock arrived and divide by the product's total shelf life (expiry date minus manufacturing date). Using the share of shelf life left, rather than raw days, lets you compare a 90-day product with a 3-year one.
• How often it was short. Count the deliveries, or lines, that came in below your own minimum. You set that threshold per category. Fast-moving dairy can live with less shelf life than a slow-moving syrup.
• How much of it expired. Out of that supplier's deliveries, how much stock reached expiry on your shelf, measured in units and at cost.

The first number shows what they send you. The second shows how reliably they send it. The third tells you whether it actually cost you money, and that's the one the conversation will turn on.

Building the scorecard from receiving records

All of this comes from data you already enter, or could enter, at receiving. For each line on each purchase bill you need the supplier, the item, the batch, the manufacturing date, the expiry date, the quantity, the cost and the date received.

If your billing software stores batch and expiry on purchase entries, export that to a spreadsheet once a month. If it doesn't, the expiry-tracking spreadsheet template has the columns ready. The hard part is getting dates captured at the dock without slowing everyone down. Our guide on capturing expiry dates at receiving covers the practical rules for that.

Once a month, do this:

• Add a column for shelf life left at receipt, worked out as described above.
• Add a column that flags any line below your threshold for its category.
• Pull your expiry or damage write-off entries for the month and match them back to supplier and batch.
• Pivot by supplier: average shelf life left, count of short lines, value expired at cost.

That's the scorecard. It's one sheet with one row per supplier, and it takes roughly an evening once the receiving data is clean.

Worked example: three distributors, one quarter

For example, say a mid-sized grocery store sets a minimum of 60% of shelf life remaining for packaged foods and runs the numbers over one quarter. These are illustrative figures:

• Distributor A: 40 delivery lines, average 78% shelf life left at receipt, 3 lines below threshold, ₹2,100 expired at cost.
• Distributor B: 35 lines, average 52% left, 16 lines below threshold, ₹11,400 expired at cost.
• Distributor C: 22 lines, average 71% left, 2 lines below threshold, ₹900 expired at cost.

Suppose you look closer at B. In this example, 16 short lines out of 35 is nearly half its deliveries. The ₹11,400 is more than A and C combined, even though B's volume sits between the two. And if 9 of those 16 short lines came during month-end weeks, you also know when it tends to happen.

That's no longer a feeling. It's a pattern with dates, batch numbers and a rupee figure attached.

Taking the record to the distributor

Don't open with the accusation. Open with the sheet. Something like: "These are the batches you delivered last quarter, with the expiry date on the day they arrived. These are the ones that expired on my shelf. Let's work out how to fix this."

Then ask for specific things, not general promises:

• A minimum shelf life at delivery, written down by category, so the delivery boy knows what you'll refuse.
• The right to reject at the gate anything below that line, with no argument and no re-billing hassle.
• Credit or replacement for the short batches that expired, backed by the batch numbers on your sheet.
• A named contact who handles expiry claims, so they don't disappear between rep visits.

Claims fail when the paperwork is thin, and distributors have a long list of reasons to reject them. Read why distributors reject expiry return claims before you file. Log every claim in the distributor expiry claim register. When you send the return itself, the expiry stock return letter format gives you wording that references batch, bill and date.

If you supply institutions or larger buyers yourself, notice that they already write minimum shelf life into their contracts. See remaining shelf life clauses in institutional supply. You're asking your distributor for the same discipline your own customers expect from you.

Keeping it going after the first month

The first scorecard is the hard one. After that, keep it honest with a few habits:

• Refuse at the gate. A rejected carton never turns into a claim. Put your thresholds on a card at the receiving point.
• Share the scorecard every quarter. A distributor who knows you're keeping count tends to pack your order more carefully.
• Watch the trend, not one bad delivery. One short batch can be a supply problem upstream. The same thing every month-end is a habit.
• Shift volume when you can. If two suppliers carry the same brand, the scorecard tells you who gets the bigger order.

What a spreadsheet can't do is watch the short batches already on your shelf. By the time the month-end pivot shows Distributor B sent you a tight batch, that batch has been selling, or not selling, for weeks.

Where a daily agent fits

The scorecard looks backward and helps you negotiate. Stock that already arrived short still has to be sold. That's the job ShelfSense does. It's a daily inventory agent that works alongside the system you already run. Once a day it reads your stock, batch, cost and expiry records, flags at-risk batches days ahead with a recommended markdown, and shows the units that won't clear and the projected loss. You approve or ignore each call. It never changes a price on its own. You can see how it reasons before you trust it.

You can start with a CSV export of your stock and expiry dates. ShelfSense's free audit reads one CSV export, no account needed. The Watch tier is free forever at 30 SKUs — a daily scan and a health report.

Build the scorecard either way. The next time the rep says "the company sent that batch," you'll have the dates in front of you.