Zeneva Premium for ₦300,000/yrClaim offer

Dead Stock: How to Find the Cash Trapped in Your Inventory

Insights
14 min read

The loss that never appears on a report

Every other loss in retail announces itself. A stockout produces a customer walking out. Theft produces a discrepancy. A bad month produces a bad number.

Dead stock produces nothing. It sits on a shelf, appears on your balance sheet as an asset at full cost, and costs you money every single day without ever generating a line item you could look at and object to. Businesses run out of cash while holding a stockroom full of things they paid for, and the reports all look fine.

This is why dead stock has to be found deliberately. Nothing surfaces it for you.


Defining it for your business

Dead stock is inventory with stock on hand and zero sales over a window long enough to matter. The window depends on your turnover, so set it from your own data:

Business typeReasonable thresholdReasoning
Groceries, perishables30 daysAnything not moving monthly is a write-off risk
General retail, fashion60 to 90 daysA full season has passed without a buyer
Electronics, appliances90 to 180 daysGenuinely slow lines can still be profitable
Spare parts, specialist180 days or moreAvailability is the product; slow is expected

A useful cross-check that ignores the calendar entirely: if an item has not sold in the time your average product sells through three times, it is dead relative to your own business. That framing travels better than a fixed number of days, because it adapts to how you actually trade.


Finding it, and ranking it correctly

The list you want has two columns that matter: units on hand, and units on hand multiplied by cost price.

Almost everyone sorts by the first and gets a misleading answer. Two hundred cheap sachets and four expensive appliances can represent the same trapped cash, but sorting by unit count puts the sachets at the top and buries the appliances. Sort by capital tied up instead, and the list usually reorders dramatically — with the top ten lines accounting for most of the money.

This is also the reason cost price is worth entering on every product even when you think you know your margins. Without it, you can produce a list of what is not selling but not a list of where your cash is, and the second is the one that changes decisions. Our post on the inventory settings that change decisions covers getting that field populated.

In Zeneva, this is what the dead stock view answers directly: products with stock but no sales in a period you choose, with the capital tied up in each and a total across all of them. If you use Zen AI, asking it for products with no sales in the last ninety days returns the same list ranked that way. The number to write down is the total — it is usually larger than owners expect, and it is the number this whole exercise is about recovering.


What it genuinely costs you

Here is the arithmetic that changes how people feel about clearance pricing.

Suppose you have a meaningful sum tied up in dead stock. That money is not lost — it is immobilised. The question is what it would have earned somewhere else.

Put the same money in your fastest-moving lines. If those turn six times a year at a twenty-five percent margin, then over twelve months that cash generates roughly one and a half times its own value in gross profit — it recycles six times, earning a quarter of itself each time.

That forgone profit is what the dead shelf costs you per year, and it recurs every year you hold it.

Then add the costs that are easier to see once you look: the storage space, the handling every time someone moves it to reach something else, the counting time at every stocktake, and the slow erosion of the item's own sellability as it ages, dates, fades or is superseded.

Against all of that, the discount you have been resisting starts to look cheap.


The sunk cost trap

The single most common reason dead stock persists is a sentence that sounds like sound business sense:

"I paid a lot for this. I cannot sell it for a fraction of that."

The money you paid is gone. It left your account when you bought the stock, and no decision available to you now brings any of it back. It is not a factor in the decision, however strongly it feels like one.

The only live question is: what is this worth from today onward, and what is holding it costing me?

Selling at forty percent of cost recovers forty percent of the cash, today, and frees the shelf. Holding for eighteen months to protect the original price typically recovers less, much later, on an item that has aged in the meantime. The instinct to avoid "taking a loss" produces a larger loss quietly, which is precisely why it survives — the second loss never appears as a number anyone has to sign off.


The clearance ladder

Work down this, with a deadline on each step. The deadlines are the important part; without them stock sits at step one indefinitely.

Step 1 — Reposition, two weeks. Move it to eye level, to the counter, to the front. A genuine share of dead stock is not unwanted, it is unseen — buried behind other things, on a bottom shelf, in a back room. This step costs nothing and resolves more lines than people expect.

Step 2 — Modest discount, two weeks. Ten to fifteen percent, clearly signed. Enough to signal action without training customers to wait for markdowns.

Step 3 — Bundle, three weeks. Pair it with something that does sell. A slow item attached to a fast one moves at close to full value and does not advertise weakness. This is usually the highest-recovery step on the ladder and it is skipped most often.

Step 4 — Serious discount, three weeks. Twenty-five to forty percent, with an end date. Consider a staff incentive here: people sell what they are motivated to sell, and a small commission on clearance lines is cheaper than the stock sitting for another quarter.

Step 5 — Clear at or below cost, two weeks. Recovering half your cash beats recovering none. Take the arithmetic above seriously and stop protecting a price you already paid.

Step 6 — Exit. Sell as a job lot, return to the supplier if any arrangement exists, donate where that carries goodwill or a tax benefit, or write off. Write-offs are recorded with a reason on the day, not folded into a general shrinkage figure — an unsellable item left in the record inflates your stock value and becomes an unexplained discrepancy at your next count. Our post on why records stop matching the shelf covers why that distinction matters.

The whole ladder is about three months. Anything still present after it should not be in your stockroom.


The exception worth respecting

Seasonal stock is not dead stock, and treating it as such is an expensive mistake in the opposite direction.

Clearing winter goods at a heavy loss in March and repurchasing them in September is a round trip that costs you the discount plus the new margin, for no benefit. If the season reliably returns and your storage is genuinely cheap, holding is correct.

The judgement is whether the item will still be sellable next season. Staples usually will be. Anything fashion-led, dated, branded to a specific event, or subject to a newer model usually will not. Be honest about which one you are holding — the optimistic answer here is what creates the ex-bestseller pile that eventually clears at ten percent.


Not buying it again

Dead stock is a purchasing outcome. Reviewing it monthly without changing how you buy just produces a longer list next month.

Buy small, then reorder on evidence. A modest first order of anything new, and a decision informed by actual sales. This feels slower and is dramatically cheaper than committing to a full range on a supplier's recommendation.

Treat volume discounts with suspicion. They are the single largest source of dead stock in small retail. A discount requiring you to triple an order ties up months of cash in one line and transfers your risk to your own shelf. The saving is real only if you were going to sell that quantity anyway at that pace — which is a forecast, not a fact.

Review last quarter before each buying decision. The same categories disappoint repeatedly, and buyers reliably forget which ones. Five minutes with the previous quarter's worst sellers before you place an order prevents more dead stock than any amount of clearance skill recovers. Our guide to demand forecasting covers reading those signals earlier, and reorder points covers the separate question of how much to hold on the lines that do sell.


The fifteen-minute monthly review

  1. Pull the list of products with stock and no sales in your chosen window.
  2. Sort by capital tied up, not units.
  3. Write down the total. Watch it across months — that trend is the real measure of whether any of this is working.
  4. Take the top three lines and assign each an action and a deadline from the ladder.
  5. Check what reached step six last month and confirm it is actually gone rather than moved to a back shelf.

Three lines a month, acted on, beats a full list reviewed and admired. The mistake is producing the report and treating that as the work — most businesses with years of accumulated dead stock have been looking at it regularly the whole time.

If freeing trapped cash is the point of the exercise, our cash flow guide covers the other levers worth pulling alongside it, and ABC analysis covers how to decide which stock deserves your attention in the first place.

The dead stock and inventory valuation views need one thing from you: a cost price on each product. Once that is in, the ranking above is a report rather than an afternoon of spreadsheet work — see which plan fits.

The Four Kinds of Dead Stock and What to Do With Each

TypeHow to recognise itRight actionCommon mistake
Wrong buyNever sold well from day oneClear fast and hard; recover cashWaiting for the market to change its mind
Ex-bestsellerSold well, then stoppedClear at moderate discount while recognisableAssuming it will come back
Seasonal remainderSold in season, dead out of itHold if storage is cheap and season returnsClearing it at a loss two months early
Expiring or perishableHas a date attachedDiscount early on a schedule, not at the endDiscounting at the last week, when nobody wants it
Broken assortmentOnly odd sizes or colours leftBundle, or clear the remainder as a lotReordering the full range to complete it
Obsolete or supersededA newer model existsClear immediately; value only fallsHolding for the customer who wants the old one
Damaged or unsellableCannot be sold at any priceWrite off today, with a reasonLeaving it in stock to protect the valuation

Operational FAQ

Run this on Zeneva

Stock, sales, staff and receipts in one place — on the shop PC, on your phone, and offline when the network drops. Start free and move up only when the shop outgrows the caps.

Starter

Free forever

50 products, 1 user, 20 Zen AI questions a day. No trial clock, no card.

Pro

Most picked

₦10,000 / $10 a month

1,500 products, 5 staff accounts, 100 Zen AI questions a day.

Business

₦30,000 / $30 a month

Unlimited products, unlimited staff, 500 Zen AI questions a day.

Start freeCompare plans

No card needed for Starter.