Walk into the back corner of your warehouse right now. Past the neatly stacked fast-movers near the dispatch area. Past the medium-movers in the middle aisles. All the way to the shelves that nobody visits anymore.
That corner is where your dead stock lives.
It arrived with the same optimism as every other purchase — a supplier's recommendation, a market trend that seemed certain, a bulk order that made sense at the time. But something changed. The product did not sell. The market moved on. A competitor launched something better. And now those goods sit there, month after month, their value quietly eroding while the rent on the warehouse space they occupy keeps running.
Dead stock is every business owner's least favorite topic — because acknowledging it means accepting a loss that could have been avoided. But not analyzing it is far more expensive than the discomfort of facing it directly. Dead stock that is identified, quantified, and systematically actioned can be partially recovered. Dead stock that is ignored becomes a total write-off — plus, for GST-registered businesses in India, a mandatory ITC reversal on top of the cost loss.
This guide gives you a complete, practical dead stock analysis Excel template — with every column, formula, and decision rule explained — specifically designed for Indian businesses. We cover how to identify dead stock, how to value it correctly, what options are available for different types of dead stock, the GST implications of each option, and how ERP Group's warehouse management system makes dead stock analysis automatic rather than a periodic manual exercise.
What Exactly is Dead Stock? — The Precise Definition
Dead Stock vs Slow-Moving Stock — The Critical Distinction
Many businesses use "dead stock" and "slow-moving stock" interchangeably, but they are different categories requiring different responses:
Slow-Moving Stock
Stock that is selling, but at a rate below expected or below cost-of-holding viability. These items still have active demand — it is just insufficient. The primary response is demand stimulation — promotion, discounting, repositioning.
Dead Stock
Stock with no measurable sales movement in a defined extended period — typically 365 days or more — with no realistic commercial prospect of selling at any price that recovers even a fraction of holding cost. The primary response is not demand stimulation but recovery maximization — through liquidation, return, donation, or write-off.
The Three Conditions That Confirm Dead Stock
Condition 1 — Zero Movement for Extended Period
No sale, no transfer, no issue, no return movement for 365+ days (or a shorter period for perishable categories). The item has been completely static in inventory.
Condition 2 — No Realistic Sales Prospect
No pending customer order, no confirmed future demand, no upcoming promotion or season that would reasonably generate sales at cost or above.
Condition 3 — Market Value Below Storage Cost
The maximum achievable sale price — even through liquidation or clearance — is insufficient to cover continued holding costs, making ongoing storage economically irrational.
When all three conditions are met, stock is genuinely dead — not just slow. This distinction matters because the analysis template, the decisions it drives, and the accounting treatment all differ between slow-moving and dead stock.
For slow-moving stock analysis, see our detailed guide on slow moving stock report Excel India.
How Much Dead Stock is "Normal" for Indian Businesses?
There is no universal normal — but as a practical benchmark, most well-managed Indian trading and retail businesses target keeping dead stock (zero movement over 365 days) below 3-5% of total inventory value. When dead stock exceeds 10% of inventory value, it represents a systemic problem in purchasing, demand forecasting, or category management that requires structural intervention beyond clearance of existing dead stock.
The True Cost of Dead Stock for Indian Businesses
The Four-Layer Cost Framework
Layer 1 — The Obvious Cost: Book Value of Dead Stock
The original purchase cost of goods that are no longer sellable at cost. For ₹10 lakh of dead stock at cost price, this is the most visible layer of the loss.
Layer 2 — The Hidden Cost: Holding Costs Accumulated
Warehousing cost allocated to dead stock space (rent per square foot × space occupied), insurance, security, and inventory management costs that have accumulated during the dead stock period. For goods sitting for 18 months at ₹2 per unit per month holding cost, the accumulated holding cost could be significant relative to the original purchase price.
Layer 3 — The Tax Cost: GST ITC Reversal
For GST-registered businesses, writing off dead stock requires reversing the ITC originally claimed on those goods under Section 17(5)(h) of the CGST Act. This is an additional cash outflow on top of the cost write-off. For goods purchased at 18% GST, the ITC reversal adds 18% to the effective write-off cost. For a complete understanding of how GST ITC reversal works for aging and dead inventory, read our comprehensive guide on inventory aging report for GST business India.
Layer 4 — The Opportunity Cost: Capital Locked and Unavailable
Capital tied up in dead stock cannot be used to purchase fast-moving inventory, reduce supplier debt, or fund business growth. At a borrowing cost of 12% per annum, ₹10 lakh in dead stock has an implicit annual opportunity cost of ₹1.2 lakh — just in the cost of the borrowed capital it represents, before any other holding cost.
Dead Stock Cost Calculation — Worked Example
Total Cost of Dead Stock Position
Dead stock value at cost: ₹10,00,000
Accumulated holding cost (18 months × 2% monthly): ₹3,60,000
ITC reversal required (at 12% average GST rate): ₹1,20,000
Opportunity cost (18 months × 12% per annum × ₹10 lakh): ₹1,80,000
Total effective cost of this dead stock: ₹16,60,000
Yet the recovery through liquidation might be only: ₹2,00,000-3,00,000
The true dead stock loss: ₹13,60,000 - ₹14,60,000
This calculation — rarely done explicitly by businesses — reveals why dead stock analysis and early intervention is so much more valuable than the simple cost figure suggests.
The Dead Stock Analysis Excel Template — Complete Structure
Template Overview — Four Interconnected Sheets
The dead stock analysis template for Indian businesses is organized into four sheets — each building on the previous — creating a complete analytical and action-planning tool rather than just a static data list.
Sheet 1: Dead Stock Identification — Which items qualify as dead stock
Sheet 2: Dead Stock Valuation — The financial impact at all four cost layers
Sheet 3: Recovery Options Analysis — What can be done with each item
Sheet 4: GST Write-Off Tracker — Compliance documentation for ITC reversal
Sheet 1 — Dead Stock Identification
Purpose of Sheet 1
Sheet 1 is your identification engine — the data-driven, consistent process for determining which items meet the dead stock criteria. This removes subjectivity from the definition, ensuring the analysis is comparable across periods and credible to management, auditors, and lenders who review it.
Sheet 1 Column Structure
Column A — Item Code / SKU
Unique product identifier — consistent with your billing system and accounting software product master.
Column B — Item Description
Clear product name including brand, model, size, and variant as applicable.
Column C — Category
Product category for rollup analysis — Electronics, Hardware, FMCG, Garments, etc.
Column D — HSN Code
For GST compliance — essential for ITC reversal calculation on Sheet 4.
Column E — Current Stock Quantity
Units currently on hand per physical count or system balance.
Column F — Date Last Received
Date when this SKU was most recently received (from supplier).
Column G — Date Last Sold / Issued
Date of the most recent outward movement — sale, transfer, or issue.
Column H — Days Since Last Movement
=IF(G2="",TODAY()-F2,TODAY()-G2)
If the item has never sold (Column G blank), calculate days since receipt. If it has been sold at some point, use the last sale date.
Column I — Qualifying as Dead Stock? (Yes/No)
=IF(H2>=365,"YES","NO")
Apply your dead stock threshold — 365 days is standard for most wholesale and retail categories, though this can be adjusted based on your industry (shorter for FMCG, potentially longer for industrial spare parts).
Column J — Dead Stock Category Classification
=IF(H2>=730,"Category 1 - Completely Dead",
IF(H2>=365,"Category 2 - Newly Dead","Not Dead Stock"))
Category 1 — Completely Dead (730+ days): No movement in 2+ years. Maximum urgency for disposal or write-off.
Category 2 — Newly Dead (365-729 days): Just crossed the dead stock threshold. Some recovery options may still be viable.
Column K — Previous 12-Month Sales Quantity
Total quantity sold in the 12 months preceding the dead stock classification — providing context on whether this item was ever a good performer (historical demand existed but has ceased) versus never-moved (demand never materialized).
Column L — Original Reason for Purchase
A free-text field noting the original rationale — "seasonal demand anticipated," "supplier minimum order quantity," "new product launch," "customer specific order cancelled." This field is invaluable for root cause analysis and future prevention.
Column M — Auto-Filter Flag
=IF(I2="YES",1,0)
A binary flag enabling quick filtering to show only dead stock items — useful when the sheet contains your full product catalogue and you need to isolate dead stock for focused analysis.
Sheet 2 — Dead Stock Valuation and Financial Impact
Purpose of Sheet 2
Sheet 2 transforms the identification data from Sheet 1 into financial terms — showing exactly how much money is involved at each layer of the dead stock cost framework. This is the sheet that gets management attention and drives decision urgency.
Sheet 2 Column Structure
Column A — Item Code
Linked from Sheet 1 — only dead stock items (Sheet 1 Column I = "YES") should appear in Sheet 2.
Column B — Item Description
Carried from Sheet 1.
Column C — Dead Stock Category
Carried from Sheet 1 Column J (Category 1 or Category 2).
Column D — Current Stock Quantity
Carried from Sheet 1.
Column E — Unit Purchase Cost (₹)
The original cost per unit — used as the book value for write-off calculation. For items purchased at different prices in different batches, use weighted average cost.
Column F — Total Book Value at Cost (₹)
=D2*E2
The inventory asset value that would be written off the balance sheet.
Column G — Estimated Net Realizable Value Per Unit (₹)
Your best estimate of what each unit could actually be sold or recovered for through liquidation, secondary market sale, scrap, or any available recovery channel. This may be a fraction of original cost — sometimes zero for truly obsolete items.
Column H — Total Net Realizable Value (₹)
=D2*G2
The total recoverable amount from this dead stock — if all available recovery options are pursued.
Column I — Estimated Write-Off Loss (₹)
=F2-H2
The amount that would be recognized as a loss in your P&L — book value minus net realizable value.
Column J — GST Rate (%)
From HSN master — the GST rate applicable to this item at the time of purchase.
Column K — ITC Originally Claimed Per Unit (₹)
=E2*(J2/100)
The GST amount per unit that was claimed as ITC when these goods were purchased.
Column L — Total ITC at Risk (₹)
=D2*K2
The total ITC that would need to be reversed if these goods are written off — a critical figure for management decision-making.
Column M — Monthly Holding Cost (₹)
=F2*0.02
Estimated monthly holding cost as a percentage (2% is a reasonable general estimate) of book value — covering allocated warehouse space cost, insurance, and handling.
Column N — Months In Dead Stock
=MAX(0,ROUND((Sheet1!H2-365)/30,0))
Number of months beyond the 365-day threshold that this item has been sitting as dead stock.
Column O — Total Accumulated Holding Cost Since Death (₹)
=M2*N2
Total holding cost accumulated since the item crossed into dead stock territory.
Column P — True Total Cost of This Dead Stock Position (₹)
=I2+L2+O2
The complete financial impact — write-off loss + ITC reversal + accumulated holding cost. This is the number that should drive urgency in management conversations about dead stock.
Sheet 3 — Recovery Options Analysis
Sheet 3 is the action planning sheet — evaluating which recovery option is most appropriate and financially advantageous for each dead stock item, moving the analysis from a problem statement to a decision framework.
The Recovery Options Framework for Indian Businesses
Option A — Clearance Sale at Steep Discount
Best for: Items with some remaining demand, not physically deteriorated
GST treatment: No ITC reversal required — sale generates output tax on clearance price
Recovery rate: 20-60% of cost depending on demand and discount depth
Key advantage: Avoids ITC reversal, recovers some cash, clears warehouse space
Option B — Return to Supplier
Best for: Items within supplier return window, undamaged, with cooperative supplier relationship
GST treatment: Supplier credit note offsets original ITC — no separate reversal needed
Recovery rate: 70-100% of purchase price depending on return terms
Key advantage: Best financial outcome; completely avoids the write-off loss
Option C — Sell to Liquidator or Secondary Buyer
Best for: Items with some residual value but no viable direct customer demand
GST treatment: Sale generates output tax — no ITC reversal required
Recovery rate: 5-30% of cost through secondary/liquidation channels
Key advantage: Generates some cash, avoids ongoing holding cost, avoids ITC reversal
Option D — Transfer to Staff or Company Use
Best for: Items that could be used internally — office supplies, maintenance items, consumables
GST treatment: Internal consumption from business stock is not treated as a supply if used in business — however, if gifted to staff as personal use items, ITC reversal may be required under Section 17(5)(g) for gifts above ₹50,000 per recipient
Recovery rate: Zero cash recovery, but avoids waste
Option E — Donate to NGO or Charitable Organization
Best for: Items that retain functional value but have no commercial market
GST treatment: Donation without consideration is "supply without consideration" — ITC reversal under Section 17(5)(h) typically applies for donated goods
Recovery rate: Zero cash recovery, some brand/PR value, possible CSR benefit
Key disadvantage: ITC reversal still applies despite the charitable intent
Option F — Formal Write-Off and Disposal
Best for: Items with zero recoverable value — physically damaged, expired, technologically obsolete
GST treatment: ITC reversal mandatory under Section 17(5)(h)
Recovery rate: Zero to minimal scrap value
Key documentation requirement: Destruction evidence, management authorization, physical verification report
Sheet 3 Column Structure
Column A — Item Code
From Sheet 1.
Column B — Item Description
From Sheet 1.
Column C — Dead Stock Category
From Sheet 1.
Column D — True Total Cost (from Sheet 2 Column P)
The complete financial impact of this item's dead stock position — carried from Sheet 2.
Column E — Recovery Option Selected
Dropdown selection from the options above — A through F.
Column F — Recovery Option Description
The specific action planned — "Clearance sale to existing customers at 40% discount," "Return to Supplier X under their 12-month return policy," "Contact liquidator Y for bulk offer."
Column G — Expected Recovery Amount (₹)
The financial recovery expected from the selected option.
Column H — Net Loss After Recovery (₹)
=Sheet2!F2+Sheet2!L2-G2
Book value + ITC reversal (if applicable) minus expected recovery. This is the net financial impact after the best available recovery option is pursued.
Column I — ITC Reversal Required? (Yes/No)
Based on the recovery option selected — Options A, B, C result in "No" (sale or return occurs). Options D (partial), E, F result in "Yes."
Column J — Action Owner
The person responsible for executing this recovery option — purchase manager for supplier returns, sales manager for clearance, owner/director for write-off approval.
Column K — Target Completion Date
The deadline by which the recovery action should be completed — preventing dead stock items from remaining in "planned for action" status indefinitely.
Column L — Action Status
Current status of the recovery effort — "Not Started," "In Progress," "Completed," "Blocked."
Sheet 4 — GST Write-Off Tracker
Purpose of Sheet 4
Sheet 4 is your GST compliance documentation sheet — tracking every dead stock write-off that requires ITC reversal, the amount reversed, the GSTR-3B period in which it was reversed, and the supporting documentation reference. This sheet is your primary defense document if ITC reversals are questioned during a GST audit.
Sheet 4 Column Structure
Column A — Item Code
From Sheet 1.
Column B — Item Description
From Sheet 1.
Column C — HSN Code
From Sheet 1 — critical for tax head-wise ITC reversal calculation.
Column D — Quantity Written Off
The specific number of units formally written off — may be partial if some quantity was recovered through clearance before write-off of remaining units.
Column E — Write-Off Date
The date on which the formal management decision was made and documented.
Column F — Unit Cost at Write-Off (₹)
The book value per unit being written off.
Column G — Total Write-Off Value (₹)
=D2*F2
Column H — GST Rate (%)
The GST rate at which these goods were originally purchased and ITC claimed.
Column I — ITC Reversal Amount (₹)
=G2*(H2/100)
Total ITC to be reversed for this line item.
Column J — Tax Head for Reversal
IGST / CGST+SGST — based on whether original purchase was interstate (IGST) or intrastate (CGST/SGST). This determines which table in GSTR-3B the reversal is recorded in.
Column K — GSTR-3B Period of Reversal
The month and year in which the ITC reversal was recorded in GSTR-3B — for example, "March 2026."
Column L — GSTR-3B Table Reference
The specific GSTR-3B table where the reversal was recorded — typically Table 4(B)(2) "ITC Reversed — Others."
Column M — Management Authorization Reference
The document reference for the formal write-off authorization — board resolution number, management approval email reference, or authorization letter date.
Column N — Physical Verification Reference
Reference to the physical stock verification report confirming the goods existed in the condition warranting write-off.
Column O — Destruction/Disposal Evidence Reference
Reference to the destruction certificate, disposal receipt, or other evidence of final disposal.
Column P — Cumulative ITC Reversal Total (Running)
=SUM($I$2:I2)
A running cumulative total — useful for verifying the total ITC reversal amount when reconciling against GSTR-3B filings for the year.
Key Excel Formulas for Dead Stock Analysis
Formula 1 — Identifying Dead Stock From Full Inventory Data
=IF(AND(DAYS(TODAY(),G2)>=365, E2>0), "DEAD STOCK", "ACTIVE")
Where G2 is last movement date and E2 is current quantity — applied to a full inventory sheet to flag dead stock items automatically.
Formula 2 — Dead Stock Value as Percentage of Total Inventory
=SUMIF(Sheet1!I:I,"YES",Sheet2!F:F)/SUM(Sheet2!F:F)*100
Shows what percentage of your total inventory value is tied up in dead stock — the headline metric for management reporting.
Formula 3 — Total ITC at Risk From Dead Stock
=SUMIF(Sheet1!I:I,"YES",Sheet2!L:L)
Total ITC that would need to be reversed if all identified dead stock were written off — important for tax planning.
Formula 4 — Days Since Last Movement (Robust Version)
=IF(G2="", TODAY()-F2, MAX(TODAY()-G2, TODAY()-F2))
Takes the maximum of days since last sale and days since last receipt — ensuring items that were received but never sold are correctly flagged from receipt date.
Formula 5 — Recovery Rate by Option
=AVERAGEIF(Sheet3!E:E,"A",Sheet3!G:G)/AVERAGEIF(Sheet3!E:E,"A",Sheet3!F:F)*100
Shows the average recovery rate achieved through Option A clearance sales — useful for calibrating future recovery estimates.
Formula 6 — Conditional Formatting Rule (Dead Stock Heat Map)
Apply this rule to highlight dead stock items on the main inventory sheet:
- Green: Days Since Last Movement < 90
- Yellow: 90-365 days
- Red: 365+ days (dead stock)
Formula for red conditional formatting:
=$H2>=365
Formula 7 — Running Monthly ITC Reversal Summary
=SUMPRODUCT((Sheet4!K$2:K$1000="March 2026")*(Sheet4!I$2:I$1000))
Sums ITC reversals from a specific month — useful for verifying GSTR-3B table entries match the tracker for a given period.
The Dead Stock Decision Tree
Step 1 — Is the Item Physically Usable?
YES → Proceed to Step 2
NO (damaged, expired, deteriorated beyond use) → Go directly to Option F (formal write-off with ITC reversal) — no sale or recovery is possible at any price
Step 2 — Can it Be Returned to the Supplier?
YES, and within return terms → Pursue Option B first — best financial outcome, avoids write-off loss and ITC reversal entirely
NO → Proceed to Step 3
Step 3 — Is There Any Identifiable Customer Who Might Buy at a Discount?
YES → Pursue Option A (targeted clearance to specific customers) — avoids ITC reversal, recovers some value
NO → Proceed to Step 4
Step 4 — Is There a Liquidation or Secondary Market for This Item?
YES → Pursue Option C (liquidator) — recovers some value, avoids ITC reversal through sale
NO → Proceed to Step 5
Step 5 — Can the Item Be Used Internally by the Business?
YES → Pursue Option D (internal use) — zero cash recovery but avoids waste, ITC treatment depends on use context
NO → Proceed to Step 6
Step 6 — Is There a Charitable or Community Use?
YES → Evaluate Option E (donation) — zero cash recovery, ITC reversal typically applies, but CSR and disposal value
NO → Option F (write-off and disposal) — accept the loss, reverse ITC, document thoroughly
Industry-Specific Dead Stock Patterns in India
Dead Stock Patterns in FMCG and Food Trading
Primary Cause
Expiry dates drive FMCG dead stock more than demand failure — near-expiry and expired goods constitute the majority of dead stock in this category. Seasonal FMCG products (festive special packs, seasonal flavors) that do not sell within the season are another significant source.
Excel Template Adaptation
Add an "Expiry Date" column to Sheet 1 and create a secondary dead stock flag triggered by expiry:
=IF(OR(H2>=365, EXPIRY_DATE_COL
This catches goods that are chronologically recent but commercially dead due to expiry.
Dead Stock Patterns in Garment and Fashion Trading
Primary Cause
Season-end unsold stock, especially styles or colors that did not resonate with buyers. Fashion dead stock often has zero commercial value after one missed season — the same style that was worth ₹500 pre-season may be unsellable at ₹50 post-season.
Excel Template Adaptation
Add a "Season Year" column and track dead stock relative to season end rather than absolute days — items from more than one full season ago are effectively dead stock regardless of calendar days since last movement.
Dead Stock Patterns in Electronics and Technology Trading
Primary Cause
Technology obsolescence — a model that was current two years ago may have been replaced by two generations of newer versions, making the older model impossible to sell even at heavily discounted prices. Additionally, warranty provisions on electronics that have been in stock for extended periods may have expired, further reducing buyer willingness.
Excel Template Adaptation
Add a "Product Generation/Model Year" column and a "Known Successor Model" field — flagging items where a newer generation has been released as higher-priority dead stock candidates regardless of absolute aging days.
Dead Stock Patterns in Industrial Hardware and Spare Parts
Primary Cause
Over-specification of minimum order quantities — industrial traders buying MOQs that exceed actual customer demand for specialized items. In some cases, the specific machine or equipment the part was designed for may have been discontinued by the OEM, making the spare part permanently unsellable.
Excel Template Adaptation
Add a "Compatible Equipment/Machine" column — cross-referencing against a list of equipment known to be discontinued in the market. Items linked to discontinued equipment are automatically flagged as dead stock regardless of aging days.
How to Present Dead Stock Analysis to Management
The Executive Summary Page
For business owners and management who need the picture quickly, create a summary page with just six key numbers:
| Metric | Value |
| Total dead stock items (SKU count) | [Number] |
| Total dead stock value at cost (₹) | [Amount] |
| Dead stock as % of total inventory | [%] |
| Total ITC at risk from write-off | [Amount] |
| Maximum recoverable through all options | [Amount] |
| True net loss if not actioned | [Amount] |
The Category-Wise Breakdown
Show which categories have the highest dead stock concentration — both by value and by percentage of category inventory. This tells management where the problem is most acute and where recovery effort should be focused first.
The Recovery Options Summary
Show the total value of dead stock directed to each recovery option, the expected recovery amount from each, and the expected net loss after recovery. This demonstrates that the analysis has generated an action plan — not just a problem statement.
Preventing Dead Stock — From Analysis to Future Prevention
Root Cause Analysis — The Prevention Foundation
Every dead stock item in your analysis has a cause. Sheet 1's "Original Reason for Purchase" column, when reviewed in aggregate, reveals patterns:
If Most Dead Stock was "Supplier Minimum Order"
Consider negotiating lower MOQs with key suppliers, particularly for new or untested products. The cost savings from avoiding future dead stock may exceed the savings from MOQ discounts.
If Most Dead Stock was "New Product Launch"
Implement a trial order policy for new products — small quantities before full commitment, with first results informing full order decisions.
If Most Dead Stock was "Market Trend Anticipated"
Review your trend forecasting and buying decision process — perhaps involving sales teams (who have direct customer feedback) more actively in purchasing decisions.
Setting Reorder Rules That Account for Current Aging
Before any future reorder, cross-reference current inventory aging data for that SKU — if current stock already shows aging beyond your category benchmark, delay or cancel the reorder regardless of conventional reorder point triggers. ERP Group's warehouse management system integrates this check automatically into the purchase order creation workflow.
How ERP Group Automates Dead Stock Management
Automatic Dead Stock Identification
ERP Group's warehouse management system continuously monitors every SKU's movement date — automatically classifying items into dead stock categories when movement criteria are met, without requiring anyone to build or update a manual template.
Pre-Built GST Compliance Integration
The GST-specific columns (HSN code, GST rate, ITC at risk, ITC reversal amount) are automatically populated from ERP Group's product master and purchase history — connected directly to the accounting software for seamless write-off accounting and GSTR-3B ITC reversal recording.
Recovery Option Workflow Management
ERP Group supports structured recovery workflows — assigning recovery actions to specific team members, tracking progress, sending deadline alerts, and recording outcomes — transforming the Sheet 3 action planning template into a live task management system rather than a static spreadsheet.
Sales Team Engagement Through CRM
ERP Group's CRM software identifies customers who have previously purchased each dead stock item — enabling targeted clearance outreach to the most likely buyers, rather than generic discounting that reaches all customers regardless of relevance. This targeted approach maximizes recovery through Option A (clearance sale) before resorting to lower-recovery options.
POS Integration for Retail Dead Stock Clearance
For businesses with retail counters, ERP Group's POS software can be configured to apply automatic clearance pricing to dead stock items at the counter — flagging them to cashiers and displaying the discounted price — without requiring manual price changes for hundreds of individual items.
For the foundational stock aging report Excel structure that feeds into dead stock analysis, read our complete guide on stock aging report Excel template free download India.
For the complete inventory aging report format specifically designed for trading businesses, read our guide on inventory aging report format for traders India.
For the full analytical framework for stock aging in wholesale businesses, read our comprehensive guide on stock aging analysis for wholesale business.
Conclusion — Dead Stock Ignored is Dead Stock Compounding
Every month you do not analyze and action your dead stock, the true cost grows — the holding cost accumulates, the recovery options narrow (a liquidator's offer declines over time as goods age further), and the gap between what could have been recovered through early clearance and what remains recoverable through write-off widens.
The four-sheet dead stock analysis Excel template in this guide — identification, valuation, recovery options, and GST tracker — gives you a complete, immediately actionable framework for bringing your dead stock under control. The four-layer cost calculation makes the true financial impact visible. The decision tree removes subjectivity from recovery option selection. And the GST tracker ensures compliance actions are documented alongside commercial decisions.
For businesses ready to move beyond periodic manual Excel analysis to real-time, automated dead stock management, ERP Group's warehouse management system provides continuous dead stock monitoring, automatic GST compliance integration through accounting software, customer-targeted clearance through CRM software, retail counter clearance pricing through POS software, and complete business management through HR & Payroll software — so dead stock never quietly compounds in the back corner of your warehouse again.
Stop letting dead stock silently drain your working capital. Analyze it, action it, and prevent it — starting today.
Automate Your Dead Stock Analysis — Book Your Free Demo
👉 Book a Free Demo → — See ERP Group's automatic dead stock management in action. No credit card required.
👉 Explore Warehouse Management System → — View all dead stock management and inventory analytics features for Indian businesses.
