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.
| Group | Cost value | Share of stock |
|---|---|---|
| --- | --- | --- |
| Fast sellers | 90,000 | 60 percent |
| Normal | 24,000 | 16 percent |
| Slow, over 90 days | 36,000 | 24 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


