Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Troubleshooting

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.

A godown manager lifting down a dusty carton from a high rack

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.

  1. Run a stock ageing report by item and warehouse.
  2. Mark items with no movement in 90 days or more.
  3. Move stock to locations that are selling it.
  4. Return what suppliers will take back under their return terms.
  5. Sell the rest by discount, bundle or bulk buyer, and write off only what is truly unsaleable.
  6. Set reorder levels and quantities from actual consumption and lead time.
  7. 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.

Most of the old stock went back to cash; very little was written off.

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.

Cartons sorted into four groups with trolley, ribbon and tags
Most of the old stock was transferred, returned or sold; only a small pile was written off.

How Apragya tackles slow moving inventory

Step 1 of 5

Stock ageing

On-hand quantity bucketed by age, per item and warehouse.

  1. Stock ageing: On-hand quantity bucketed by age, per item and warehouse.
  2. Stock by location: See where each item sits and move it by stock transfer.
  3. AI reorder suggestions: An agent judges urgency and quantity for items near their reorder point.
  4. Reorder scan: A daily scan drafts purchase orders only for items below their level.
  5. 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

FeatureRegisters and spreadsheetsApragya
Age of stockNot knownBucketed by 30, 60, 90 and older
LocationAsked by phonePer warehouse and bin
ReorderBy feelLevels plus AI suggestions
Purchase ordersRepeat last monthDrafted only for items below level
CountsOnce a yearCycle 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

  1. Run the stock ageing report.
  2. List items older than 90 days by value.
  3. Decide transfer, return, sale or write-off for each.
  4. Reset reorder levels for the worst offenders.
  5. Repeat the report every month.

Clearing the top twenty items by value usually frees most of the cash.

What it costs to start

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Inventory and Warehousing
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

Slow moving inventory, answered

When does stock count as dead?
It depends on your trade. Many businesses use 90 or 180 days with no movement as the mark.
Should we write off dead stock?
Only what cannot be sold, returned or used. Written-off goods can require a reversal of input tax credit, so check with your accountant.
Will AI order less for us?
An agent suggests urgency and quantity from recent consumption. A buyer decides.
Can we move stock between branches?
Yes. Stock transfers move items between warehouses on the same record.
What does it cost to start?
Inventory and Warehousing is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Turn old stock back into cash

Run a stock ageing report and see which items have not moved in 90 days.