Business

Dead stock: tracking items that stopped selling

Goods that no longer sell tie up money and space. A regular check identifies them early enough to discount, bundle or clear them sensibly.

Editorial illustration for Dead stock: tracking items that stopped selling

The shelf that does not move

Every shop and workshop eventually holds items that stopped selling: a colour that went out of favour, a model replaced by a newer one, a seasonal line that missed its season. They sit in the back, quietly holding cash that could have been put to better use.

The longer they sit, the less they are worth. Recognising them sooner gives more choices.

Define “slow” in your own terms

Pick a rule that suits the trade. A common approach is to flag any item with no sale for a set period, such as ninety days for goods that normally sell weekly. Perishables need a much shorter window; durable goods may need longer.

Then go through the stock list and mark every item that qualifies. Record the quantity and what it cost.

Measure what is tied up

Add up the cost value of flagged stock and set it beside the monthly purchases and the cash held. If 36,000 units are tied in slow items while the shop buys 50,000 a month, that is most of a month’s buying sitting idle.

GroupCost valueShare of stock
---------
Fast sellers90,00060 percent
Normal24,00016 percent
Slow, over 90 days36,00024 percent

A quarter of the stock is not working. That number alone prompts action.

Options for clearing it

Several approaches can free the money.

  • Discount the items, enough to move them without losing the sense of value.
  • Bundle a slow item with a popular one.
  • Return unsold goods to the supplier, if terms allow.
  • Sell through another channel, such as an online listing or a clearance sale.
  • Donate or write off what is truly unsellable.

Choose based on the cost, the remaining shelf life and how much space the item occupies. Selling at cost, or even a modest loss, can still be better than holding the item for another year.

Record the write-down honestly

If an item will be sold below cost or not at all, reflect that in the records. Reduce the stock value to what is realistically recoverable and record the difference as a loss in a suitable category. This keeps profit honest: pretending that stuck goods are worth full cost flatters the numbers for a while, and then surprises later.

Prevent the next pile

Order smaller quantities of untested items, track sell-through for the first month and reorder only when the product proves itself. A weekly glance at what has not sold in the last thirty days spots drifting items before they become dead.

Tracking it in the app

In SpendixAI, a category for stock write-offs shows the annual cost of misjudged buying. Compare it with the savings from bulk deals or optimistic orders. If the write-offs cancel out the bargains, buying habits need adjusting.

Putting a number on the lesson

At year end, total the write-offs and discounts given on slow items, and divide by total purchases. If the figure is, say, 8 percent, then for every 100 units spent on stock, 8 were lost to misjudged buying. Whether that is acceptable depends on the trade; fashion and seasonal lines usually run higher than staples.

Setting a target for the next year, such as bringing the loss to 5 percent, gives the buying decisions a concrete aim. Progress can then be checked quarterly instead of being discovered when the shelves are cleared.

Deciding the cost of holding stock

Slow stock has a carrying cost beyond its purchase price: space, insurance, handling and the interest or opportunity cost of the cash tied up. A rough yearly figure of around a fifth of the stock value is often used as a starting point in discussion, though the real number depends on the business. Seeing that holding a dead item for a year may cost a fifth of its price makes it easier to discount it sooner rather than later.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports