1. Home
  2. Blog
  3. Stock ageing and expiry
Inventory

Stock ageing and expiry tracking: stop old stock eating your profit

Stock that sits too long costs money twice: the cash you paid for it, and the space it takes from something that would sell. For anything with an expiry date, the cost can be total. Stock ageing and expiry tracking make the problem visible early.

  • Published
  • Updated
  • 3 min read
  • Milaan ERP team

Key points

  • Stock age shows how long items have been sitting.
  • Expiry tracking needs batch and expiry dates on every purchase.
  • Sell first-expiry-first-out (FEFO).
  • Check near-expiry lists every week, and return in time.
  • Act on dead stock: discount, bundle or return.

Stock ageing: how long is too long?

Age bucketWhat to do
0–30 daysNormal
31–60 daysWatch; check if sales have slowed
61–90 daysStop reordering; consider promoting
90+ daysClear: discount, bundle or return

The right buckets depend on your trade. Fresh food moves in days; hardware may sit for months without harm.

Expiry tracking

For medicines, food, FMCG, cosmetics and chemicals, record the batch and expiry date on every purchase. The software can then:

  • Pick the earliest-expiring batch at billing (FEFO).
  • List items expiring in the next 30, 60 or 90 days.
  • Block the sale of expired stock.
  • Group near-expiry stock by supplier for returns.

A weekly expiry routine

  1. Monday Print the 90-day expiry list.
  2. Move to the front Place near-expiry items where they sell first.
  3. Offer or bundle Short-dated items at a small discount.
  4. Return Send items within the supplier’s return window.

Dead stock: getting your money back

  • Return it, if your supplier allows.
  • Bundle slow items with fast sellers.
  • Offer it to other shops or wholesalers.
  • Discount it and use the cash for items that sell.

Trade-specific guides

For medical stores, see expiry management for pharmacies. For groceries, see our supermarket software.

FAQ

Common questions, answered.

Short answers to the questions we hear most about this topic.

Have a question we didn’t answer?

Message us and a real person from our team will reply.

What is stock ageing?

A view of how long each item has been in stock, grouped into buckets like 0–30, 31–60 and 90+ days.

What is FEFO?

First-expiry-first-out: selling the batch that expires soonest first.

What do I need for expiry tracking?

Batch numbers and expiry dates recorded on every purchase.

How do I clear dead stock?

Return it, bundle it, sell it to other traders or discount it.

How often should I check expiry lists?

Weekly, so items can be sold or returned in time.

Catch old stock before it costs you

Milaan ERP tracks batch, expiry and stock age. Ask us which plan fits.