Expiry risk

Expiry date tracking and shelf life inventory management

See which stock will pass its date before it sells, and which orders are too large to sell within shelf life. Built for food, beverage, chemical, cosmetics and other businesses whose products expire, on your own data.

The problem with expiry dates

Stock that expires is a loss you can see coming. The sales rate and the dates are already in your systems, but they are rarely put side by side, so a slow item quietly passes its date on the shelf and an order sized for the cheapest price arrives more than the market can use in time.

What the Expiry risk page shows

  • Stock that will expire unsold, in units and dollars at cost, at the forecast rate of sale.
  • Stock already past its date, to remove and write off so plans stop counting on it.
  • Lots expiring soon, within a number of days you set.
  • Suggested orders that are too large to sell before the order itself would expire, and how much of each would sell in time.
  • Every dated item in one table, by location, to download as a file.

Two ways to load your dates

What you loadWhat you get
A lot file: item, quantity and expiry date, with location and lot number if you have themExact results. Lots are sold first-expired, first-out, the way most food and pharmacy operations pick.
A shelf_life_days column on your item listAn estimate that treats today’s stock as freshly received, so it is the least that can expire. It also checks every new order against the shelf life.

Both can be loaded at once. Files from your ERP or warehouse system are recognized by their columns, such as Batch, Best Before or Expiration date. Read FEFO vs FIFO for why the picking rule matters, or test one item with the free expiring inventory calculator.

How the numbers are worked out

Each lot can sell for its days to expiry, after the lots that expire before it. Whatever it still holds on its last selling day expires unsold.

Demand is the Replenishment planner’s forecast for the item and location, so the two pages agree. If your customers need a minimum remaining life when they buy, set the days, and every date is moved earlier by that much.

What it is not. The Lab is not a lot traceability or recall system, and it does not replace your quality or regulatory records. It shows the money at risk and the orders to change, from the data you already keep.

Which plans include it

Expiry risk is on the Planner plan, $850 a month, and the Growth plan, $1,947 a month, with the Replenishment planner whose orders it checks. See the plans.

See expiry risk on sample data

The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.

Frequently asked questions

What is FEFO?

First expired, first out: the stock with the earliest expiry date is used or sold first, whatever order it arrived in. It is the usual rule for food, pharmaceuticals and other dated products.

Do I need lot data to use it?

No. A shelf life in days on your item list is enough for an estimate. A lot file with expiry dates gives exact results.

Does it track lots for recalls?

No. The Lab is a planning tool. Keep lot traceability in your ERP, warehouse or quality system.

How does it decide an order is too large?

A new order arrives with its full shelf life after the lead time, and sells after the stock already here. Anything that cannot sell before it would expire is flagged as too large.

Which plans include Expiry risk?

Planner and Growth, because it checks the Replenishment planner’s suggested orders.

Scroll to Top