Fix Excess Inventory and Dead Stock: Find It, Clear It and Stop Buying More
For owners, purchase heads and godown managers: find the stock that is not moving, turn it back into cash, and stop buying more than you sell.
To fix excess inventory and dead stock, start with an ageing report. Until you know which items have not moved in 90 days, and in which godown, every clearance effort is a guess.
In Indian trading and distribution, dead stock builds up quietly. A salesman's big order gets cancelled, a scheme discount tempts a bulk buy, or a variant stops selling. The stock sits, the cash is gone, and next month's purchase order repeats the same quantities.
This page gives the direct fix, an illustrative example from Kochi, and how Apragya keeps stock moving.
Why stock stops moving, and the fix
Dead stock is inventory that has not sold or been used for a long time, often 90 or 180 days depending on your trade. Excess stock is more than you need for the lead time and safety cover. Both tie up cash, godown space and staff time.
The usual causes are buying in bulk for a discount, reorder points set by feel, forecasts copied from last year, a product line that faded, returns never restocked or sent back, and the same item sitting idle in one godown while another runs short.
The fix is to age every item, decide what to do with each old bucket, and change the buying rules that created it.
- Run a stock ageing report by item and warehouse.
- Mark items with no movement in 90 days or more.
- Move stock to locations that are selling it.
- Return what suppliers will take back under their return terms.
- Sell the rest by discount, bundle or bulk buyer, and write off only what is truly unsaleable.
- Set reorder levels and quantities from actual consumption and lead time.
- Review the ageing report every month.
What dead stock costs
Cash tied up
Money sits on shelves instead of paying suppliers.
Space used
Godown space goes to items nobody buys.
Value lost
Items age, go out of fashion or expire.
Write-off effects
Written-off goods can mean reversing the tax credit taken on them.
An example: a Kochi hardware distributor
Take an illustrative distributor with 4,000 items across three godowns. The stock ageing report showed 38 lakh of stock older than 90 days.
What happened to 38 lakh of old stock
Stock over 90 days
Found on the ageing report.
Transferred
Paint and fittings moved to the branch selling them.
Returned
Unopened cartons sent back under supplier terms.
Sold at discount
Old variants offered to contractors.
Bundled
Slow items paired with fast sellers.
Written off
Only damaged goods, after a count.
Reorder reset
Levels set from real consumption.
Over three months, about two thirds of the old stock was transferred, returned or sold. Reorder levels were reset for the items that caused it, and the next quarter's purchase orders were noticeably smaller.
How Apragya tackles slow moving inventory
Step 1 of 5
Stock ageing
On-hand quantity bucketed by age, per item and warehouse.
- Stock ageing: On-hand quantity bucketed by age, per item and warehouse.
- Stock by location: See where each item sits and move it by stock transfer.
- AI reorder suggestions: An agent judges urgency and quantity for items near their reorder point.
- Reorder scan: A daily scan drafts purchase orders only for items below their level.
- Stock counts: Physical counts post variances to stock and accounts.
Using a stock ageing report to decide
Without ageing, dead stock looks like healthy stock on a balance sheet. With it, every old item has a location, a value and a decision.
Stock kept in registers, against Apragya
| Feature | Registers and spreadsheets | Apragya |
|---|---|---|
| Age of stock | Not known | Bucketed by 30, 60, 90 and older |
| Location | Asked by phone | Per warehouse and bin |
| Reorder | By feel | Levels plus AI suggestions |
| Purchase orders | Repeat last month | Drafted only for items below level |
| Counts | Once a year | Cycle counts with variances posted |
Checked against public information on 16 September 2026.
What stops the next pile of dead stock
One item record
Sales, purchase and stores see the same item and stock.
Human review
AI suggestions wait for a buyer to accept.
Barcodes and bins
Stock is found quickly, so nothing is forgotten on a shelf.
Access by role
Who can adjust stock is controlled.
Audit log
Adjustments and write-offs are logged.
Copilot
Ask which items have not moved this quarter.
See stock reports, stock levels and warehouses. If the old stock is perishable, read how to fix expired stock write-offs.
Getting started
- Run the stock ageing report.
- List items older than 90 days by value.
- Decide transfer, return, sale or write-off for each.
- Reset reorder levels for the worst offenders.
- Repeat the report every month.
Clearing the top twenty items by value usually frees most of the cash.
What it costs to start
Slow moving inventory, answered
When does stock count as dead?
Should we write off dead stock?
Will AI order less for us?
Can we move stock between branches?
What does it cost to start?
Turn old stock back into cash
Run a stock ageing report and see which items have not moved in 90 days.