Skip to content

How to find and deal with dead stock

Who can do this: Users whose role has the inventory analytics permission · Available on: Mobile · Web

Dead stock is stock you are holding that has never sold. The Dead Stock report lists those items, how long they've been sitting, and how much cash is tied up in them, and lets you act on each one.

Before you start

  • The report always reflects stock as it is right now. It has no date filter.
  • The action buttons open other screens (transfers, offers, stock adjustments, products). You need permission for those too.

Steps

  1. Go to More → Reports → Dead Stock. (On web: Reports → Dead Stock.)
  2. To find an item, type in Search by item name.
  3. If you have more than one branch, tap the branch button next to the search box and pick a branch, or All branches. (On web: use the branch chips.)

Screenshot coming soon: Dead Stock — summary and Items never sold list

  1. Read the summary:
Card What it tells you
Dead stock value The total cost value of stock that has never sold.
Items How many items are on the list.
Highest value The single item with the most cash tied up.
Avg days unsold The average number of days the listed items have gone unsold.
Total units Total quantity sitting in stock.
Items never sold Each item with its quantity, average cost and total value.
  1. Tap an item to open its action sheet. It shows the item's SKU, Category, Avg cost, Retail price, Wholesale price and Pack size, plus On hand, Days unsold and Tied-up value.
  2. Check the severity. Seroly rates each item:
Severity When Suggested action
Watch Fewer than 90 days unsold, and value under 15,000 Monitor. Consider a transfer or promotion if it still doesn't sell.
Elevate 90 days or more unsold, or value of 15,000 or more Act soon: transfer, mark down, or stop reordering.
Critical 180 days or more unsold, or value of 50,000 or more Cash tied up. Prioritise clearance or write-off.
  1. Choose an action:
Button What it does
Transfer to another branch Opens a new stock transfer.
Create markdown / offer Opens a new offer so you can discount the item.
Write off / adjust stock Opens the stock adjustment sheet for this item.
Stop reordering (edit product) Opens the product. Set its reorder level to 0 so Seroly stops suggesting you buy more.
View product Opens the product's details.

Screenshot coming soon: Dead stock item sheet — severity and actions

On web: the page also shows Most Cash Tied Up (a chart of the highest-value items) and a Risk Breakdown by severity. The Items Never Sold table has Item, Branch, Severity, Qty, Avg cost, Total value and Days unsold columns. Click a row for the actions.

Export the list

Tap the download icon (Export) in the top bar to export the list to Excel or PDF. See Export a report. (On web: click Export in the report header.)

Tips & common issues

  • "No dead stock. Every item has sold at least once.": good news. Nothing in stock is unsold.
  • "No dead stock in this branch.": try All branches.
  • "Product not available for this item": the product record can't be found, so the actions can't open. It may have been removed.
  • "Nothing to export": the list is empty, so there is nothing to export.