What dead stock really costs
Why dead stock accumulates
The part your system probably gets wrong
What cleared ours: it is a people problem
How to define dead stock for your trade
What a useful ageing report looks like
Your five options for slow-moving stock
Talking to suppliers about returns
Using the annual stock take properly
Designing an incentive that works
Stopping slow lines from coming back
Putting a number on it
Dead stock inventory management in a Rawalpindi market
Dead stock across more than one branch
A monthly dead stock inventory management routine
Before you buy inventory software for this
The lesson, which cuts against my own trade
Where to start this month: five steps
Questions owners ask about dead stock
Related reading
If your stock is telling you nothing

What dead stock really costs

Any honest take on dead stock inventory management starts with the full bill. 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, which is why dead stock inventory management can't wait for year end.

Why dead stock accumulates

Never through one bad decision. Always through a hundred reasonable ones, which is why dead stock inventory management has to be a process, not a lecture about discipline.

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 dead stock inventory management can't rely on telling people to buy more carefully.

The part your system probably gets wrong

Most inventory setups can tell you current stock levels, which is the easy end of dead stock inventory management. 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.

Good dead stock inventory management 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 cleared ours: it is a people problem

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.

I think about that often when owners ask me for a better report. The report matters, and I'll happily build one. But dead stock inventory management lives or dies on the floor, with the person talking to the customer. If they've got no reason to mention the slow line, it stays on the shelf, however clearly the screen shows it in red.

How to define dead stock for your trade

There's no single rule. Ninety days without a sale means something very different for a mobile accessories shop than for a wholesaler of industrial switchgear. Before you build any report, decide what dead means in your business, because dead stock inventory management starts with that definition.

Fast-moving retail
For FMCG, mobile accessories or anything with fashion in it, 90 days without a sale is already a warning. Styles change, models get replaced, and the price someone will pay drops month by month.

Electrical and hardware
In electrical trading, some slow-moving stock is normal. A contractor might buy a particular breaker twice a year, and you need it on the shelf when he does. I'd treat 180 days as the warning line and 365 as dead, with exceptions agreed item by item rather than by feeling.

Seasonal lines
Heaters, fans, coolers, Ramadan and Eid lines. Judge these against last season, not the last 90 days. A fan that hasn't sold since September isn't dead in January. A fan that didn't sell last summer either probably is.

Write your definitions down. Good dead stock inventory management depends on everyone using the same words for the same thing.

What a useful ageing report looks like

I've seen ageing reports with forty columns that nobody reads. The one that works fits on a single screen and answers the owner's questions in the order he asks them.

Sort it by value, largest first. The top twenty lines usually hold most of the money, and that's where your dead stock inventory management time should go.

Item name and code, grouped by category.
Quantity on hand and its purchase value in rupees.
Date of the last sale and the last purchase.
Ageing band: 90, 180 or 365 days without a sale.
Supplier, so you know who to ring about a return.

Your five options for slow-moving stock

Once you know which lines have stopped selling, dead stock inventory management comes down to five choices. Every one of them is better than holding the stock another year.

Discount it
The obvious one. Price it to move, and be realistic about the price. A small discount on something nobody wants just delays the decision.

Bundle it
Pair a slow line with a fast one. A slow-moving fitting goes with a popular switch at a combined price. Customers feel they've got a deal and the shelf clears without a visible markdown.

Return it to the supplier
Some suppliers will take stock back or swap it against a new order, particularly if you're a regular buyer. You won't know until you ask, and most owners never ask.

Sell it to another trader
What doesn't move in Saddar might move in another city or another trade. Other dealers in your network may take it at cost or close to it. Getting your capital back at cost is a good result for anything that's sat that long.

Write it off
Sometimes the stock is obsolete or damaged and nobody will pay anything. Writing it off at least stops it distorting your stock value. Talk to your accountant before you do, because the tax treatment matters and the rules sit with the FBR, not with me.

Talking to suppliers about returns

Most owners never ask a supplier to take stock back, because it feels like admitting a mistake. In my experience it's a normal part of dead stock inventory management in the trade, as long as you handle it properly.

Not every supplier will agree. The ones who do are worth favouring when you place your next order.

Ask early. A line that's six months slow is easier to return than one that's three years old and out of the catalogue.
Offer something in return: a swap against a new order, or a slightly bigger order on a line that does move.
Bring the numbers. Show how long it's sat and what else you buy from them.
Keep the packaging. Returned stock needs to be resaleable.

Using the annual stock take properly

The stock take is the one day a year when every item gets looked at. Use it for dead stock inventory management, not just to count.

Give the counting teams a simple extra column: tick if the item looks old, damaged or dusty. Those ticks, checked against the ageing report, show you what's gone stale in ways the numbers alone won't. A box that's faded in the sun won't sell at full price, whatever the system says it's worth.

Designing an incentive that works

The incentive at Star Electric worked because it was simple and people could see it. I won't pretend there's one right design, but these principles held for us and I'd use them again.

An incentive nobody understands is just a cost. An incentive the whole floor talks about changes how people sell, and that's the part of dead stock inventory management no software can do.

Tie it to the specific lines you want cleared, not to sales in general.
Keep the rules short enough that a salesperson can explain them to a colleague.
Pay it quickly, so the link between effort and reward is obvious.
Make the list visible to everyone, so the team can see which items count.
Review the list regularly, because what counts as dead changes.

Stopping slow lines from coming back

Clearing it once is satisfying. Keeping it clear is the harder half of dead stock inventory management, and it comes down to buying.

None of that needs new software. Dead stock inventory management needs a habit, and someone whose job includes keeping it.

Set a reorder level and a maximum level for each regular line, and stick to them.
When a supplier offers a better rate for a larger quantity, work out how many months of sales that quantity represents before saying yes.
Take a deposit on special orders, so you're not left holding the second unit.
Review last season's seasonal lines before placing this season's order.
Give one person responsibility for the ageing report, with ten minutes on the agenda at every weekly meeting.

Putting a number on it

Owners nod along to all this talk of dead stock inventory management and then do nothing, because it doesn't feel urgent. A rough sum usually changes that. Here's an illustration, not anyone's real figures.

Say a shop has twenty lakh rupees tied up in lines that haven't sold in a year. That's twenty lakh not available to buy the fast-moving items that sell out every month. Add the share of rent those shelves take up. Then add the fall in resale value on anything electronic, which only goes one way.

Now compare it with the effort of clearing it: a discount, a few phone calls to suppliers and other dealers, a small incentive for the team. The sum isn't close.

Dead stock inventory management in a Rawalpindi market

Walk through Raja Bazaar on any afternoon and you'll see the same thing in shop after shop. Cartons stacked to the ceiling, the fast lines at the front, and a back room nobody's opened properly since last winter. That back room is where dead stock inventory management either happens or doesn't.

Space is tight in the old markets of Rawalpindi, and the rent isn't cheap. So a shelf of slow fittings isn't just idle capital. It's the shelf where this month's fast seller should be sitting. Owners here feel that pinch more than a warehouse on the edge of Islamabad ever will, which makes dead stock inventory management a daily concern, not a yearly one.

Neighbouring shops help too. Traders in the same bazaar swap and sell on stock between themselves, usually over tea and a phone call. Treat that network as part of your dead stock inventory management. A carton gathering dust in your back room might be exactly what the dealer three doors down is short of.

Keep it simple. Open the back room once a month, match what you see to the ageing report, and make one call about the worst line. That's dead stock inventory management done in a way a busy counter can keep up.

Dead stock across more than one branch

With two or three branches, the problem gets both worse and easier. Worse, because each branch hides its own slow lines and nobody sees the total. Easier, because an item dead in one branch is often selling in another.

If your current system can't show you all branches on one screen, that's a real gap in your dead stock inventory management, and it's worth fixing.

Run the ageing report for every branch together, not branch by branch.
Before discounting anything, check whether another branch sells it.
Transfer stock properly in the system, so the move doesn't show up as a sale and a purchase.
Give each branch manager the same definition of dead, and the same incentive.

A monthly dead stock inventory management routine

This is the routine I'd give any trading business owner. It takes about an hour a month once the report is automatic.

The last step is the one that stops the cycle. A routine that only looks backwards will be doing the same clear-out every year.

First week: run the ageing report and sort by value.
Take the top twenty lines and decide an action for each: discount, bundle, return, sell on, or write off.
Update the incentive list so the sales team knows what counts this month.
Check last month's actions. Which lines moved? Which didn't, and why?
Look at recent purchases. Did anything get bought in a quantity that'll be next month's problem?

Before you buy inventory software for this

If you're shopping for a system to handle dead stock inventory management, ask any vendor to show you these with your own data loaded, not a demo file.

If they can do all four, the software is fine for the job. The rest is up to you and your team.

An ageing report by value that runs in one click.
The date of last sale on every item, visible on the item screen.
Stock across all branches on one page.
A way to flag lines for an incentive and track what sold.

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 dead stock inventory management.

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: five steps

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.

Questions owners ask about dead stock

Four questions about dead stock inventory management come up on nearly every call, so here are the short answers.

How often should I run the ageing report?
Monthly. Quarterly is too slow for anything with a season in it, and weekly turns it into a chore nobody keeps up. An hour in the first week of the month is plenty once the report runs itself.

Do I discount first or ring the supplier first?
Ring the supplier. A return at full credit beats a discount every time, and once you have cut the price on the shop floor you have lost the argument for a swap.

Do I need new software for this?
Usually not at first. Most packages already store the date of the last sale somewhere. The job is getting it onto one screen beside the purchase value. We only build something new when the existing data cannot answer the ageing question at all, and we will say so rather than quote you for a rebuild.

Who should own it?
One named person, never a committee. In a single shop that is the owner. Past two branches it belongs to whoever runs purchasing, because clearing dead stock is really a buying discipline. Give that person ten minutes at the weekly meeting and the ageing report stops being an annual surprise.

If your stock is telling you nothing

If dead stock inventory management is a blind spot in your business, 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. You can read about our custom POS software and custom inventory and business software, and see how fixed-price quotes work on the pricing page.

Dead Stock Inventory Management: Your Most Expensive Problem

On this page