Slow-Moving Stock Report in Excel for Indian Businesses — Complete 2026 Guide

Walk into any warehouse in India and you'll find it — a corner, a back shelf, or an entire rack of stock that hasn't moved in months. It's not damaged. It's not expired. It's just sitting there, quietly tying up capital that could be funding your next purchase order, your GST payment, or your payroll run.

This is slow-moving stock, and most Indian traders only discover how much of it they're carrying when a physical stock count forces the issue — usually once a year, usually too late to act cheaply. A slow-moving stock report fixes that by giving you a running, numbers-based view of exactly which SKUs are underperforming, before the capital lock-in becomes a write-off.

This guide covers how to define slow-moving stock for your business, how to build the report in Excel with working formulas, the mistakes that quietly make these reports useless, and what to actually do once you've identified the problem — including the GST angle most guides skip entirely.

What Is a Slow-Moving Stock Report?

A slow-moving stock report identifies inventory items whose sales velocity has dropped below an acceptable threshold for your business — not zero sales, just slower than the rate that justifies the shelf space and capital they occupy. It's an early-warning report, not a post-mortem.

Slow-Moving vs Non-Moving vs Dead Stock — Key Differences

These three terms get used interchangeably, and that's where most reports go wrong. Slow-moving stock still sells, just below your target velocity — a fast-fashion item that used to sell 50 units a week now selling 8. Non-moving stock has had zero sales for a defined period, typically 90 or 180 days, but isn't necessarily unsellable. Dead stock is non-moving stock that's effectively unsellable at normal price — obsolete, out of season permanently, or discontinued by the manufacturer.

The reason this distinction matters: slow-moving stock needs a pricing or promotion response, non-moving stock needs an investigation, and dead stock needs a write-off decision. A report that lumps all three into one "old stock" list gives you no clear next action. If you've already built an aging-bucket report, our guide on inventory aging report format for Indian traders covers how to structure those buckets correctly — this report sits one layer above that, focused on what action each bucket actually needs.

Why This Report Matters More in India Than You'd Think

Working Capital Lock-In

For most Indian SMEs running on tight working capital cycles, every rupee in slow-moving stock is a rupee not available for the next purchase order, GST payment, or payroll cycle. Traders who don't track this systematically routinely discover 8-15% of their inventory value sitting in stock that hasn't moved in over six months — capital that's effectively earning zero return.

GST and Compliance Exposure on Written-Off Stock

This is the part most "how to track slow stock" content ignores entirely: under Section 17(5)(h) of the CGST Act, input tax credit originally claimed on goods is disallowed — and must be reversed — when those goods are written off, destroyed, lost, or disposed of without consideration. If your slow-moving stock eventually becomes a write-off and you don't reverse the ITC, you've created a compliance exposure on top of an inventory problem. We cover the mechanics of this further down

How to Identify Slow-Moving Stock — The Criteria

Method 1 — Days Sale of Inventory (DSI)

DSI tells you, on average, how many days it takes to sell through your current stock of an item at its recent sales rate.

DSI Formula and Worked Example

DSI = (Average Inventory ÷ Cost of Goods Sold for the period) × Number of days in the period

Example: if an item has average inventory of ₹1,20,000 and COGS of ₹40,000 over a 30-day period, DSI = (1,20,000 ÷ 40,000) × 30 = 90 days. If your category benchmark for that product line is 30-45 days, this item is running at double the acceptable velocity — a clear slow-mover.

Method 2 — Days Since Last Sale

Simpler and easier to automate in Excel: flag any SKU where today's date minus the last invoice date exceeds your threshold (commonly 60, 90, or 180 days depending on category). This method is less precise than DSI but far easier to maintain manually and is usually the right starting point for traders building their first report.

Method 3 — Industry-Specific Thresholds

A 90-day no-sale flag makes sense for FMCG; it's meaningless for spare parts or B2B capital goods that sell in low volume by design. Set your threshold by product category, not as one blanket rule.

Suggested Thresholds by Industry

Building a Slow-Moving Stock Report in Excel — Step by Step

Step 1 — Set Up the Required Columns

Core Columns Every Report Needs

SKU code, item description, category, quantity on hand, quantity sold in trailing 90 days, last sale date, stock value at cost, days since last sale, suggested action flag.

Optional Columns for Batch/Expiry-Based Industries

Pharma, food, and FMCG businesses should add batch number and expiry date columns, since a SKU might be moving fine overall while a specific old batch sits unsold and approaches expiry — a risk a SKU-level-only report will miss entirely.

Step 2 — Key Excel Formulas

Days Since Last Sale Formula

=TODAY()-[Last Sale Date Cell]

This single formula, copied down the column, automatically recalculates every time you open the file — no manual date math.

SUMIFS for Trailing Sales Window

=SUMIFS(SalesQty, SKU, [SKU Cell], SaleDate, ">="&TODAY()-90)

This pulls total units sold for that SKU in the last 90 days directly from your sales data tab, so the report updates itself as you paste in new sales exports.

Conditional Formatting to Auto-Flag Slow Movers

Apply a conditional formatting rule on the "Days Since Last Sale" column: highlight red if greater than 90, amber if 60-90, green if under 60. This turns a spreadsheet of numbers into something a warehouse manager can scan in seconds.

Suggested Color-Coding Logic

Red (90+ days, no movement) signals investigate-and-act-now. Amber (60-90 days) signals watch-list, consider a promotion before it tips into red. Green (under 60 days) signals normal velocity, no action needed. Keeping this three-tier logic consistent across every report you generate makes month-on-month comparison meaningful instead of just a fresh list each time.

Step 3 — Sample Report Layout

A clean layout sorts by "Days Since Last Sale" descending, with the flag column as the leftmost visible field after SKU, so the worst offenders are immediately visible without scrolling. If you'd rather start from a ready-built version than construct columns and formulas from scratch, our free stock aging report Excel template is set up with this exact structure pre-built.

Common Mistakes Indian Businesses Make With This Report

Mistake 1 — Measuring by Value Only, Not Units

A high-value item that sold one unit last week looks "active" by value but may be one slow-moving sale away from sitting idle for months. Track both units sold and value tied up — they tell different parts of the story.

Mistake 2 — Ignoring Batch and Expiry Data

For pharma, food, and cosmetics businesses, a SKU-level slow-moving report without batch-level detail can hide an expiring batch behind otherwise-healthy SKU sales numbers — a far more urgent problem than a generic slow mover.

Mistake 3 — Skipping the GST ITC Reversal Angle

Many traders treat the write-off decision as a pure inventory call and only think about GST when their CA flags it during return filing — by which point the reversal should already have been accounted for in the period the stock was actually written off.

Mistake 4 — Manual Excel Files That Break Across Branches

A single-location Excel file works fine for one warehouse. The moment you have two or three locations, you're either maintaining separate files that never get compared, or manually consolidating exports — and by the time the consolidated view is ready, the data is already a week old.

What to Do With Slow-Moving Stock Once You Find It

Liquidate Through Discounting or Bundling

Time-bound discounts or bundling slow movers with fast-moving items recovers more margin than letting stock sit until it becomes dead stock requiring a full write-off.

Transfer Between Branches Before Discounting

Stock that's slow at one location may sell normally at another — a transfer is free margin recovery compared to discounting, and should always be checked first if you operate more than one location.

Return to Vendor Where Agreements Allow

Many distribution agreements include return or exchange clauses for unsold stock within a defined window — a clause that's frequently forgotten until the return window has already closed.

Write Off Correctly — Don't Skip the GST Step

ITC Reversal Under Section 17(5)(h) — What Applies

When stock is formally written off in your books, the input tax credit originally claimed on that stock must be reversed in the GST return for the period of write-off, valued at the original ITC amount on those goods. This needs to happen in the same period as the accounting write-off, not whenever it's noticed later — getting the timing wrong creates an interest exposure on top of the reversal itself.

Why Spreadsheets Eventually Break Down for This Report

The Multi-Location Problem

Every additional warehouse or branch doubles the manual consolidation work, and doubles the chance of someone working off a stale export.

The Stale-Data Problem

A report is only as useful as its last update. If "days since last sale" is calculated from a sales export that's a week old, you're making liquidation decisions on data that's already wrong.

How ERP Group Automates Slow-Moving Stock Detection

Real-Time Aging Dashboards Across Every Warehouse

ERP Group's warehouse management system tracks days-since-last-sale and aging buckets automatically across every location from one dashboard — no manual exports, no version-control confusion between branches.

Last-Sale Data Captured Automatically at the Billing Counter

Every sale recorded through ERP Group's POS software updates the inventory aging calculation in real time, so the "days since last sale" figure is never based on a stale export.

Write-Offs and ITC Reversal Handled in the Books Automatically

ERP Group's accounting software links inventory write-offs directly to the GST module, computing and flagging the required ITC reversal in the same period as the write-off — removing the manual cross-check between warehouse and accounts that most businesses currently rely on.

Turn Slow Stock Into Sales With CRM-Led Clearance Campaigns

ERP Group's CRM software lets you push slow-moving SKU lists directly into targeted WhatsApp or email clearance campaigns to your existing B2B customer base, instead of discounting blind or relying on walk-in footfall alone.

Accountability Built Into Warehouse Staff Performance

ERP Group's HR & Payroll software lets you tie stock-audit accuracy and aging-report follow-through into warehouse staff performance tracking, so identifying slow stock isn't a report nobody acts on.

Conclusion

A slow-moving stock report is only useful if it leads to a decision — discount, transfer, return, or write off — within weeks of the flag, not months. Excel gets you there for a single location with disciplined upkeep; once you're managing multiple branches or want the write-off step to flow straight into compliant GST handling, that's where a connected system earns its place over a spreadsheet.

Build your free slow-moving stock report today, or see how ERP Group automates the entire cycle — from detection to clearance to compliant write-off.

👉 Book a Free Demo →
👉 Explore Warehouse Management Software →