Stock
What is dead stock and how do you find it?
Dead stock is stock you still hold that has not sold or been used for a long time, commonly 90 days or more, a limit each business sets for itself. To find it, list every item with stock on hand, find the date it last went out, and keep the ones idle past your limit. Its value at cost is money tied up on the shelf.
Finding dead stock in five steps
This works the same for a clothing shop, a hardware store or a pharmacy. Only the limit changes.
- Pick a limit
- Ninety days suits most fast trades. A hardware or furniture shop with slow but steady items may use 180 or 365 days.
- List items with stock
- Take every item whose quantity on hand is above zero.
- Find the last sale, not the last receipt
- Use the date the item last went out. An item you keep buying but never sell is the worst dead stock there is, and counting receipts as movement hides it.
- Value it at cost
- Multiply the quantity by its cost rate. This is the money that is not working.
- Sort by value
- Start with the items that tie up the most money, not the ones idle longest.
A clothing shop's dead stock on 1 November
The shop uses a 90-day limit. Three items qualify, and together they hold ₹20,650 at cost.
| Days since last sale | Value at cost | |
|---|---|---|
| Woollen caps, 40 pieces at ₹120 | 210 | ₹4,800 |
| Formal trousers in size 44, 12 pieces at ₹800 | 150 | ₹9,600 |
| Children's raincoats, 25 pieces at ₹250 | 120 | ₹6,250 |
| Total dead stock | Over 90 | ₹20,650 |
What to do with dead stock
Dead stock does not get better with time. Decide item by item, and fix the buying that caused it.
Sell it off
A discount, a bundle with a fast seller, or a sale to another shop or a wholesaler. Some money now beats full price never.
Return or exchange
Many suppliers take back or exchange slow goods, especially within the first few months. Ask before it ages further.
Write it down
Under AS 2, stock is shown at the lower of cost and net realisable value. If it can only sell at a loss, the books should show the lower value.
Write it off
Stock that is destroyed or written off loses its input tax credit: section 17(5)(h) of the CGST Act requires the credit taken on it to be reversed.
How Dhaaga finds dead stock
Dead stock uses one rule across the app, so the dead stock screen and the movement report always agree.
One rule
An item is dead when it has stock on hand and nothing has been sold or issued within the limit. For an item never sold, the clock starts at its first receipt.
Your own limit
The dead stock screen starts at 90 days, has ready views for 180 and 365, and takes any other number of days.
Value in rupees
Each dead item is valued at cost under its own valuation method, and the total shows what is tied up.
Fast, slow and non-moving
A movement report classes every item as fast, slow or non-moving by how many times its stock turned over.
Questions people ask first.
Slow-moving stock still sells, just rarely. Dead stock has not sold at all within your limit, such as 90 days.
There is no legal figure. Ninety days is common for fast trades; slow trades such as furniture or spare parts often use 180 or 365 days.
Not by itself. It becomes a loss when it is written down below cost or written off, or sold for less than it cost.
Only when it is written off, destroyed, lost or given away. Stock that is simply unsold keeps its credit.
Buying too much of a new or seasonal line, reorder levels set too high, wrong sizes or colours, and items bought for one customer who never collected them.
Sorting items into fast-moving, slow-moving and non-moving by how often they sell. The non-moving class is your dead stock.
Put one real day through it.
Not a sandbox with sample data — your own bills, your own items, your own customers. By evening you will know whether this runs your business.
