Dead Stock in Your Shop: How to Find It, Measure It, and Clear It (2026)
A shop can have healthy sales and still be broke. The gap is almost always the same thing: money the owner can see on the shelf but can't spend, because it's sitting in stock nobody is buying.
Dead stock is inventory that has not sold at all in a set window, usually 90 days or more, and shows no sign of moving. Slow-moving stock is the milder version: it still sells, just far too slowly for how much of it is sitting there. Both tie up cash that could otherwise buy fast-moving products, pay a supplier on time, or cover rent. This guide covers how to find dead stock before it eats your margin, how to measure it in rupees rather than units, and what to do once you've found it.
What counts as dead stock, exactly
Most shop owners know dead stock when they see it: the shelf of phone covers nobody wants, the size that never sells, the brand a supplier pushed that never caught on. The harder part is seeing it before it's obvious. A useful working definition:
- Dead stock: no sale at all in the last 90 days, and the item is older than 90 days (new stock gets a grace period).
- Slow-moving (overstocked) stock: still selling, but at the current pace it would take more than six months to clear what's on the shelf.
- Healthy stock: everything else, moving at a pace that matches what's on hand.
Those exact thresholds, 90 days for dead and 180 days of cover for slow, are the ones Astra Atlas's Money Leaks report uses, and they are a reasonable starting point for most Indian kirana, clothing, electronics, and pharmacy stores. A boutique with a six-week fashion cycle might want tighter numbers; a hardware store with slow-turning tools might want looser ones. The point isn't the exact day count, it's having one at all instead of relying on a gut feeling every time stock is counted.
Why dead stock is worse than it looks on a shelf
Picture ₹40,000 of inventory sitting in boxes that haven't moved in four months. That money isn't idle, it is actively costing the shop three ways at once:
- It can't be spent on anything else. That's ₹40,000 that didn't go toward restocking a product that actually sells, or clearing a supplier bill on time for a discount.
- It keeps costing to store. Shelf space, insurance, and handling don't pause because an item stopped selling.
- It only gets worse with time. Seasonal stock goes out of season. Electronics get a newer model. Apparel goes out of trend. The longer dead stock sits, the less it's worth once it finally sells at a discount.
Add this up across every slow item in a shop and the number is usually bigger than owners expect, because no single item looks alarming on its own. A stock report that only shows quantity on hand hides this completely; it takes a report built specifically to flag non-moving stock to surface it. For the broader case on why a quantity-only report isn't enough, see the inventory management software guide.
How to find dead stock without a software report
If the shop runs on spreadsheets or a basic billing app with no dead-stock view, the check still has three steps:
- Pull a stock-on-hand list with the current quantity and cost price, not sale price, for every product.
- Pull a sales report for the last 90 days, matched to the same product list, to see which items sold zero units.
- Multiply quantity by cost price for every item that sold zero in that window. That total is the floor of what's trapped, before even counting the slower-but-not-dead items sitting on six months or more of stock.
Doing this by hand once a quarter is better than never doing it. Doing it from a system that already tracks stock movement and billing together means the same report takes seconds instead of an evening with two spreadsheets open.
What Astra Atlas's Money Leaks report actually checks
This is a case where a billing app and an inventory app with real intelligence genuinely diverge. Vyapar and Tally will show current stock quantity; neither flags which of that stock is trapped capital without the owner building a comparison manually. Astra Atlas's Money Leaks report runs the dead and slow check automatically against every product with stock and a cost price on file, and adds two things a manual check usually skips:
- A rupee total, not just a count. "7 dead products" doesn't tell an owner anything until it's "₹18,400 trapped in 7 products."
- Which supplier sold you the stock that's now dead. The report groups trapped value by supplier, so a shop can see which supplier's stock keeps not selling, and go back to that supplier first, either to ask for a return or to simply stop reordering from them at the same pace.
The same Money Leaks screen also checks something adjacent but different: whether a supplier has quietly raised prices, or whether another supplier is selling the same item cheaper. A price rise of 5% or more since the last bill, or a 5% cheaper option from a different supplier in the last six months, both get flagged with the rupee impact over the last 90 days of buying, so the alert isn't just "prices changed," it's "this specific change cost you this much." The same credit-signal logic behind this report is also what feeds Astra Atlas's Loan Readiness score, which looks at trapped capital as one input into whether a shop is ready for a working-capital loan.
Clearing dead stock once you've found it
Finding dead stock is the easy half. Clearing it takes a plan, not a one-time discount sale:
- Discount it in a way that still protects margin elsewhere. Bundle a dead item with a fast-moving one rather than discounting it alone; the bundle moves both, and the fast item's margin covers some of the loss on the dead one.
- Ask the supplier to take it back. Many Indian suppliers, especially for seasonal or trend-driven categories, will take back unsold stock against future orders rather than lose the relationship. This only works if you know which supplier to ask, which is exactly what a by-supplier breakdown is for.
- Stop reordering before the problem repeats. The most common failure after a dead-stock clearance isn't clearing it, it's reordering the same slow item at the same pace three months later because nobody checked the sales velocity before placing the next purchase order.
That last point is where a one-time spreadsheet audit loses to a system that checks this continuously. A quarterly dead-stock cleanup fixes a quarter's mistake; a report that runs every time stock is reviewed stops the mistake from compounding.
Bottom line
Dead stock doesn't announce itself. It looks like ordinary inventory on a shelf, and most billing software stops at showing quantity on hand, leaving an owner to notice the problem only when cash feels tight and nobody can say exactly why. The fix isn't a bigger discount sale, it's a report that converts "this hasn't sold in a while" into a specific rupee number, tied to a specific product and a specific supplier, checked automatically instead of once a year.
Astra Atlas's Money Leaks report does exactly that for shops already billing and tracking purchases through the app, free to try alongside the Loan Readiness score it was built next to. For a shop still deciding on billing software first, the POS software guide for retail stores and inventory management guide cover what to look for before dead-stock tracking becomes relevant at all.
Ready to try Astra Studio?
Astra Atlas is free to download — no credit card, no trial expiry. Start billing in minutes.