Every retail and trading business has dead stock. The tile design that stopped moving, the fixture model that got superseded, the bulk buy that never sold through. Individually, each pile looks small. Added up, it is common for 15 to 25 percent of a store's inventory value to be sitting in items that have not sold a single unit in six months. On ₱10 million of stock, that can be ₱2 million of trapped cash. Not lost. Trapped, and slowly shrinking.
Why is dead stock invisible?
Dead stock hides in plain sight because nothing about it demands attention. It does not run out, so it never triggers a reorder panic. It does not appear on the sales report, because it does not sell, and the sales report only shows what moved. The human eye normalizes it: that shelf has always looked like that. Without a report that specifically hunts for non movement, dead stock is invisible by construction. It also survives management attention because dealing with it feels like admitting a mistake. Marking down stock crystallizes a loss that was previously deniable. But the loss already happened the moment demand died; the markdown just stops it from growing.
What does an aging stock report show?
The tool is the mirror image of your receivables aging. For every SKU at every branch: quantity on hand, its cost value, and days since the last sale. Sort by value, descending, and bucket it: 90 days, 180 days, 365 days without a sale. The first time an owner runs this report is usually a bad afternoon. It is also frequently the single most profitable report the system ever produces, because everything on it is recoverable money. Run it per branch, not just company wide. Dead stock is a local disease, and the company total hides the branch where a third of the backroom stopped moving last year.
Flush strategies, in order of preference
Once dead stock is visible, work down the list:
- Transfer it. Dead in one branch is sometimes alive in another. Check cross branch sales before discounting anything.
- Bundle it. Attach slow movers to fast movers: the paint that sells, packaged with the brush line that does not.
- Discount it in steps. 20 percent off at 180 days, 40 at 270, cost at 365. Decided by rule, not by mood, so nobody has to feel bad about each markdown.
- Return or swap it. Suppliers you pay well on Net 30 will often take back stock or credit a swap to keep the relationship. This is one more thing a clean supplier ledger buys you.
- Liquidate the remainder. Below cost hurts, but pesos today beat objects forever. The shelf space and the cash both have better jobs waiting.
Stop refilling the trap
Flushing dead stock once is a cleanup. The lasting win is upstream: connect the aging report to purchasing. A PO reviewer who can see that this SKU has 140 days of supply on hand will not approve another case of it, no matter what the supplier's agent is offering. Review the aging report monthly, ten minutes, top twenty lines. Businesses that do this stop accumulating dead stock almost entirely, not through discipline of character but through visibility. You cannot manage what you cannot see, and dead stock is the most literal proof of that in retail.
One caution: do not swing to the opposite extreme and starve genuinely seasonal items. The report measures days since last sale, so rainy season SKUs will look dead in April. Tag seasonal lines and judge them against their season, not the calendar. The goal is honest visibility, and honesty includes context.
Find the cash hiding on your shelves
We build aging stock reports into every retail system we ship, so dead stock surfaces automatically instead of at the five year renovation.
See the ERP We Built Tell Us About Your Branches