Expiry
How do I reduce expired stock write-offs?
By the Ceazr team · Published · Reviewed
Short answer
Most expired stock comes from three things: not knowing what expires when, selling newer stock before older stock, and ordering more than you can sell before the date. Fix them by recording a batch and expiry date at receiving, picking first-expiry, first-out (FEFO), reviewing near-expiry stock on a fixed schedule, moving it to branches that sell faster, and ordering no more than you can sell within the shelf life.
Record batch and expiry at receiving
You can't manage dates you don't know. Every delivery of a product with a shelf life should be recorded as a batch, with its batch number, expiry date and quantity.
- Check dates on several cartons, not just the top one. Mixed lots are common.
- Agree a minimum remaining shelf life with each supplier and refuse or query deliveries below it.
- Record short-dated deliveries straight away so they get sold first.
Pick first-expiry, first-out
FEFO means the batch with the earliest expiry date goes out first, even if it arrived later than other stock. On the shelf, put the earliest dates at the front. In your records, make sure sales and transfers come out of the right batch so the system matches the shelf. Our guide on FEFO explains how it differs from FIFO.
Review near-expiry stock on a schedule
A regular review turns surprises into decisions. Choose a warning window that suits each category: a few days for fresh food, a few months for long-life products. Then check everything inside that window on a fixed day, weekly for short-dated lines and monthly for the rest.
For each near-expiry batch, decide one action: move it, promote it, return it or plan to write it off. Write the decision down and check it was done.
Move stock to where it will sell
If you have several branches, near-expiry stock in a slow branch may sell in time at a busy one. Transfer it early, while there is still enough life left for the receiving branch to sell it. Record every transfer so both branches' counts stay right.
| Branch | On hand | Sells per day | Days to sell through | Action |
|---|---|---|---|---|
| Branch 1 | 90 | 1 | 90 | Send 70 units to Branch 2 |
| Branch 2 | 10 | 4 | 3 | Receive and sell within about 20 days |
Branch 1 would have written off around 60 units. After the transfer, both branches can sell what they hold well before the date.
Order to shelf life, and use your suppliers
The cheapest write-off is the stock you never ordered. Before each order, check that you can sell it before it expires. A simple test: maximum sensible order = average daily sales × usable shelf life in days − stock on hand. For example, if you sell 10 units a day, a delivery arrives with 30 days of usable life and you hold 50, ordering more than 250 risks expiry.
- Set reorder points per location so slow branches aren't overstocked.
- Order short-life lines in smaller, more frequent deliveries, even at a slightly higher unit price.
- Ask suppliers about returns, swaps or credit for near-expiry stock, and get the terms in writing.
- Record every write-off with a reason. Over time, the pattern shows which products, branches and suppliers need attention.
How Ceazr helps you cut expiry losses
Questions people also ask
- What is the quickest way to cut expiry write-offs?
- Start picking first-expiry, first-out and run a weekly review of short-dated stock. Both work with the stock you already have.
- Can Ceazr stop staff selling expired stock?
- Yes. In Ceazr, expired batches can't be sold or transferred. They can still be written off or corrected in a count.
- Should I write off expired stock straight away?
- Separate it from sellable stock straight away. Check whether your supplier will take it back, then record the write-off with a reason and dispose of it according to local rules.
Try Ceazr free for 14 days. No card needed.