Nothing on your profit and loss statement tells you about dead stock. It is not a loss. It sits in inventory as an asset, valued at what you paid for it, looking exactly as healthy as the items that sold last week. That is what makes it dangerous. Every other problem in a trading business announces itself. A bad debt shows up. A theft shows up eventually. Dead stock just sits there being an asset while quietly holding money you needed for something else.
What it actually costs
Three things at once, and owners usually only count the first. The capital, obviously. Money in a box on a shelf is money not buying the item that turns over four times a year. The space, which people forget because they already pay the rent. If your slow lines occupy a third of the floor, you are paying a third of your rent to store things nobody wants. And the value decay, which in electrical and electronics is brutal. A part that was current three years ago is not worth what you paid, whatever the ledger says. Every month you hold it, the gap between the book value and what someone would pay widens.
Why it accumulates
Never through one bad decision. Always through a hundred reasonable ones. A supplier offers a better rate on a larger quantity, so you take it. A customer asks for something unusual, you order two, they buy one. A line sells well for a season and then stops, and nobody notices for eight months because nobody was looking. A price rise is coming so you buy ahead, and demand shifts. Each one was defensible at the time. That is exactly why you cannot fix this by telling people to buy more carefully.
The part your system probably gets wrong
Most inventory setups can tell you current stock levels. Far fewer make it easy to ask the only question that matters here, which is: what has not moved, and for how long? If getting that answer requires an export and an afternoon of work in Excel, nobody will ask it. Not because your team is lazy, but because it is never the most urgent thing on any given day. A report that takes effort is a report that gets run once a year, usually during stock take, by which point the damage is done. The fix is unglamorous. Ageing bands on every line, visible without asking. Nothing sold in 90 days, 180 days, 365 days, with the capital value of each band shown as a number. When an owner sees that a specific figure in rupees has not moved in a year, the conversation changes immediately.
What actually cleared ours
Not the report. The report only told us the size of the problem. At Star Electric we introduced a staff incentive tied to clearing dead stock. That was the change that worked. Inventory turnover improved, and the part I had not predicted was that team morale improved with it. In hindsight it is obvious why. Before the incentive, slow lines were a nuisance to a salesperson. Harder to sell, no upside, and a customer who is happier with the popular item anyway. Every rational person on the floor avoided them. Once there was something in it for the person doing the selling, the same items became worth the effort of suggesting. The stock had not changed. The incentive had.
The lesson, which cuts against my own trade
I build software for a living and I am telling you that the software was the smaller half of this. The system made the problem visible. It could not make anyone care. Visibility without a reason to act produces a very well-documented problem, which is the most common outcome of an inventory project and the reason so many of them are judged a disappointment. If you are about to spend money on inventory software, decide first what will happen when it shows you something bad. Who sees the report, how often, and what are they expected to do about it? If you cannot answer that, the software will be an expensive mirror.
Where to start this month
- Pull a list of every line with no sales in the last 180 days, however painful it is to produce this once.
- Put the purchase value of that list next to your monthly working capital. That single comparison usually ends the debate about whether this matters.
- Pick the worst twenty lines and decide on each one: discount, bundle, return to supplier, or write off. All four are better than holding.
- Give whoever sells them a reason to sell them.
- Then make the report automatic so you never have to do step one by hand again.
Related reading
- Whether your existing package can already produce the ageing report, or whether it needs building: Busy, Tally, QuickBooks or custom.
- An itemised POS is what makes the ageing bands possible in the first place: what FBR POS integration really involves.
- Where the incentive idea came from: nine years in electrical trading and what it taught me about software.
If your stock is telling you nothing
Tell me what you are running and how you currently find slow lines. I will tell you whether this needs a build or whether your existing system can already do it with the right configuration, and I have no interest in selling you the first when it is the second. Free consultation at devsioservices.com/contact, or read about the inventory and POS work at devsioservices.com/services/pos-software-development.
