Stock control

How do I find and clear dead stock?

By the Ceazr team · Published · Reviewed

Short answer

Dead stock is stock that hasn't sold or been used for a long time and isn't likely to soon. Find it by listing products with no sales in a set period, such as 90 or 180 days, at each location. Clear it by moving it to a branch where it sells, bundling it, discounting it, returning it to the supplier or writing it off, then adjust your ordering so it doesn't build up again.

What counts as dead stock

There is no single cut-off. A product with no sales for 60 days might be normal for spare parts but a warning sign for snacks. Pick a period that suits each category, based on how often it normally sells. It also helps to use a softer slow-moving label for items that still sell, but far below what you hold. See dead stock in the glossary.

Look at dead stock per location, not just in total. A product can be dead in one branch and selling well in another. That is often the easiest kind to fix.

How to spot it

  1. Export or list every product at each location with its stock on hand and the date of its last sale or use.
  2. Flag anything with no sales in your chosen period for that category.
  3. For items that still sell, work out months of cover: stock on hand divided by average monthly sales. An item with far more cover than its supplier lead time needs is a slow mover.
  4. Compare the same product across branches. Stock sitting still in one place while another place keeps running out is a transfer waiting to happen.
  5. Check for anything near its expiry date, because slow stock with a shelf life becomes a loss fast.
Illustrative example: one product across three branches
BranchOn handSold in last 90 daysStatus
Branch 1600Dead here
Branch 2545Selling, often short
Branch 3206Slow

What dead stock costs you

  • Cash. Money paid for stock that isn't selling can't pay suppliers, staff or rent.
  • Space. Shelves and storage used by dead lines can't hold the products that sell.
  • Value. Products expire, go out of fashion, get damaged or are replaced by newer models.
  • Time. Staff still count, move and look after it.
  • Clarity. A large dead tail makes your stock value look healthier than it is.

Five ways to clear it

  1. Transfer it to a location where it sells. This recovers full value, so try it first. Record the transfer so both branches' counts stay right.
  2. Bundle it with a product that sells well, or offer it as an add-on.
  3. Discount it. A smaller margin now usually beats no sale later. Set an end date and stop if it doesn't move.
  4. Return it to the supplier. Some suppliers accept returns or swaps, especially if you keep buying from them. Ask before you assume they won't.
  5. Write it off when nothing else works: donate, recycle or dispose of it. Record the write-off with a reason so your counts and your losses are accurate.

Stop it building up again

  • Order to demand, per location. Set reorder points from each branch's own sales, not a business-wide guess.
  • Test new lines in small quantities, ideally in one or two branches first.
  • Review slow movers on a schedule, such as monthly, so you act while the stock still has value.
  • Watch bulk-buy deals. A discount on a quantity you can't sell isn't a saving.
  • Archive discontinued products once they are cleared, so they stop cluttering reports and counts.

How Ceazr helps you deal with dead stock

Questions people also ask

How many days without a sale makes stock dead?
It depends on the product. Choose a period for each category based on how often it normally sells, such as 90 or 180 days, and check it per location.
Is it better to discount dead stock or write it off?
Try transferring or discounting it first, because both recover some value. Write it off when it can't be sold, for example if it has expired or is damaged.
Is dead stock the same as obsolete stock?
They overlap. Obsolete stock can no longer be sold at all, for example because it has been replaced or has expired. Dead stock has stopped selling but may still be sellable somewhere else or at a lower price.

Try Ceazr free for 14 days. No card needed.