By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated October 19, 2026
Slow moving inventory is stock that sells much more slowly than you planned for the amount you hold. It usually isn’t a warehouse problem first. It’s a cash problem, because every unit on the shelf is money you can’t spend on payroll, ads or the products that actually sell. This guide shows you how to find these items, build a simple slow moving inventory report in Excel or Google Sheets, value the stock correctly and decide what to do with each SKU.
TL;DR
- Slow moving stock is defined by speed against expectation, not by one universal number. Many businesses use six months or more, but thresholds range from roughly 90 to 180 days by industry.
- Find it with three columns per SKU: days in stock, units sold in the last 90 days and months of supply on hand.
- Once evidence shows an item will sell below cost, US GAAP and IFRS both require a write-down. It isn’t optional.
- Fix the cause (reorder points, forecasts, pricing), not just the pile. Clearing stock without changing how you buy refills the shelf.
Table of Contents
- What counts as slow moving inventory
- Why it costs more than the shelf space
- How to identify slow moving inventory
- Worked example
- Find the cause before you pick the fix
- What to do with slow moving stock
- Valuing slow moving inventory and writing it down
- Connect inventory to cash and working capital
- Our perspective: slow stock is a forecasting problem in disguise
- Tools to build the report faster
- When you want help instead of a template
- A 30-day plan to get started
- FAQ
- Sources
What counts as slow moving inventory
There is no single cutoff. A grocery or dairy item can be slow after a few weeks. A spare part or a furniture piece can sit half a year and still be normal. NetSuite’s guide notes that a dairy retailer might flag a product after 80 days while others wait 180.
A useful working definition for a small business: an item is slow moving when your current stock would take far longer to sell than its normal replenishment cycle, based on recent sales.
Three related terms get mixed up:
| Term | What it means | Typical action |
|---|---|---|
| Slow moving | Still selling, but well below the pace you bought for | Adjust buying, promote, bundle |
| Non-moving | No sales for a long stretch (for example, 6 to 12 months) | Liquidate, return or write down |
| Obsolete | Cannot be sold at or above cost, often because of age, expiry or a product change | Write down or scrap |
The practical difference is the accounting. Slow moving stock is a planning issue. Obsolete stock is a financial statement issue.
Why it costs more than the shelf space
Slow inventory hurts in four places at once:
- Cash. The money is already spent. Research on intermittent demand suggests slow and irregular items can account for as much as 60% of total stock value in some businesses.
- Carrying costs. Storage, insurance, handling and, for e-commerce sellers, fulfillment storage fees keep accruing.
- Value. In fast-changing categories such as electronics, price declines and new releases turn unsold stock into a depreciating asset that eventually needs a write-off.
- Attention. Slow items rarely drive the bulk of sales, so they get ignored. One study of slow-moving stock points out that these products often make up most of the inventory physically on hand, even though they don’t produce most of the revenue.
That last point is why owners say the same thing in hindsight: the problem was visible for months, but nobody was looking at that report.
How to identify slow moving inventory
You don’t need inventory software to do this. If you already track stock in a spreadsheet, you have what you need. Export or list every SKU with these fields:
- SKU and description
- Units on hand
- Unit cost
- Date of last receipt (use the oldest open lot if you can)
- Date of last sale
- Units sold in the last 90 days
Calculate four simple metrics
- Days in stock:
=TODAY()-[receipt date] - Average daily sales: units sold in the last 90 days divided by 90
- Days of supply: units on hand divided by average daily sales
- Inventory value at cost: units on hand times unit cost
Days of supply is the most useful one. A SKU with 400 days of supply that you reorder every 60 days is a problem no matter how “new” it looks.
Group items into aging buckets
Use buckets that fit your category. A common starting point is 0 to 90 days, 91 to 180 days, 181 to 365 days and over 365 days. Add a column that assigns each SKU to a bucket using a nested IF, then summarize the dollar value per bucket with SUMIFS.

The summary is your slow moving inventory report. It should answer one question on a single screen: how many dollars are sitting in each age band, and which 20 SKUs account for most of the old dollars?
What a good slow moving inventory report contains
- Total inventory value and the share older than your threshold
- Top 20 SKUs by dollars at risk, sorted descending
- Days of supply for each
- Last sale date
- A decision column: keep, discount, bundle, return, liquidate or write down
- An owner and a date for each decision
Review it monthly. Quarterly is too slow for most small retailers and online sellers.
Worked example
Say you sell home goods online and hold 600 units of a ceramic planter that cost you $8 each. That is $4,800 at cost. Over the last 90 days you sold 45 units, which is 0.5 units per day.
- Days of supply: 600 divided by 0.5 equals 1,200 days
- Sales pace you planned for: 100 units per quarter
- Actual pace: 45 units per quarter
This isn’t dead stock, because it still sells. It is slow, and 1,200 days of supply means you should not reorder. If you also have a standing reorder point on that SKU, turn it off today.
Now compare it with a seasonal item, 300 units of a holiday mug with zero sales since January. If it’s October and the season is about to begin, this is not slow moving. It’s waiting. Context matters, which is why the decision column in your report needs a human reading it.
Find the cause before you pick the fix
Clearing the pile feels productive. But slow stock often hides intermittent demand, where many periods have zero sales, and discounting won’t change how you buy. The usual causes:
- Over-buying to hit a supplier minimum or a volume discount. The discount saved a few cents per unit and cost you a year of cash.
- Reorder points that ignore the trend. Replenishment keeps triggering for items that are effectively dead.
- Optimistic forecasts. Research on demand planning warns about heavy reliance on individual judgment calls, with forecasting and order quantities treated as separate decisions.
- Product life cycle. Items at the end of their life often show sporadic sales before stopping completely.
- Wrong price or wrong channel. Sometimes the product is fine and the listing is not.
What to do with slow moving stock
Match the action to the cause and to how much cash is at stake.
1. Stop the inflow
Freeze reorders on every SKU with more than your target days of supply. This costs nothing and has the biggest impact. Check open purchase orders too, and see whether any can be reduced or pushed out.
2. Reprice or promote
Temporary discounts, bundles with fast sellers and email promotions work for items that still have steady demand. Test on a small batch first. A permanent price cut is a better choice when the item is simply overpriced. If you’re unsure where your floor is, a pricing and break-even analysis shows how low you can go and still cover costs.
3. Sell through other channels
Marketplaces, wholesale buyers, liquidators and local resellers all take excess stock. Expect to recover less than cost, but you convert inventory back into cash.
4. Return or exchange
Some suppliers accept returns or swaps, often with a restocking fee. Ask before the items age further.
5. Donate or scrap
When stock can’t be sold, the cleanest answer may be to write it off. Donation may carry tax benefits, so confirm the treatment with your accountant.
Valuing slow moving inventory and writing it down
Owners often treat markdowns as a choice. Accounting treats them as an obligation. Under IAS 2, inventory is carried at the lower of cost and net realizable value, which is the estimated selling price less costs to complete and sell. US GAAP (Topic 330) follows the same principle, with its own measurement rules depending on the inventory method you use.
In practice:
- For each at-risk SKU, estimate the realistic selling price.
- Subtract selling costs such as fees, shipping and handling.
- If the result is below your cost, the difference is the write-down.
- Many companies also keep an inventory reserve for aged stock, based on historical loss rates by age bucket.
The write-down lowers profit now, but it gives you an accurate balance sheet. It also matters for lenders and investors, who will look at inventory quality. Your CPA should confirm the reserve method for tax and reporting. The calculation itself fits in a spreadsheet tab next to your aging report.
Connect inventory to cash and working capital
Slow stock is a working-capital issue first. The longer inventory sits, the longer your cash conversion cycle, and the more you rely on credit lines or delayed payables. For a wider view of how inventory age and turnover feed into cash, this overview of evaluating the supply chain for the retail sector is a useful companion read.
To quantify it in your own numbers, put three lines in one view: inventory dollars by age, upcoming purchase orders and expected cash receipts. Our Working Capital Optimizer and 13-week cash flow forecasts are built for exactly that kind of view. For retailers, an open-to-buy plan in Excel caps what you can purchase each month so new orders match what you actually sell.
Our perspective: slow stock is a forecasting problem in disguise
We work with owners who run their business in spreadsheets, and the pattern repeats. Inventory lives in one file, sales in another, purchase orders in a third, and cash in the bank app. Nobody sees all four at once, so a reorder gets approved without anyone asking what it does to cash in eight weeks.
Our view is simple:
- You don’t need new software to fix this. You need a clean tracker, an aging view and a monthly habit of reviewing it.
- Link inventory to the forecast. Purchases should come from expected sales, and expected sales should feed your cash forecast. A revenue forecast in Excel is the right starting point.
- Decide thresholds in advance. Pick your days-of-supply limit per category, so a reorder over the limit needs a conscious yes.
- Treat the write-down as information. It tells you which buying decisions to stop repeating.
Control matters too. When the model is in a file you understand, you can change an assumption in a minute and see the cash effect, without waiting on a vendor or a report builder.
Tools to build the report faster
If you’d rather start from a working structure than a blank sheet, these are good places to begin:
- Inventory & Orders Tracker: keeps stock levels and open orders in one place.
- Inventory & Budget Tracker Excel template: ties stock purchases to your budget.
- Browse all Excel templates, including the inventory tracker and purchase order collections.
When you want help instead of a template
If your inventory is large, your data is messy or you need the cash impact quantified fast, we can build it with you. Our one-time projects include a 13-week cash flow forecast, budget build, KPI dashboard, pricing analysis and profitability review, all in Excel or Google Sheets. For a fixed-scope start, the Launch Kit is $650 one-off.
For ongoing support, our fractional CFO plans are Starter at $600 per month ($7,200 per year), Growth at $1,750 per month ($21,000 per year) and Scale at $3,500 per month ($42,000 per year). Each includes hands-on onboarding and email support, and your numbers stay in the spreadsheets you already use.
A 30-day plan to get started
Week 1: Build the list. Export every SKU with quantity, cost, last receipt and last sale dates. Clean duplicates.
Week 2: Calculate and bucket. Add days in stock, days of supply and aging buckets. Sort by dollars at risk.
Week 3: Decide. For the top 20 SKUs, choose an action, an owner and a date. Freeze reorders on anything with excess supply.
Week 4: Value and forecast. Calculate net realizable value for the oldest items, discuss reserves with your accountant and add expected inventory sell-through to your cash forecast.
Then repeat monthly. The first review takes hours. By the third, it takes minutes.
FAQ
How do you deal with slow moving inventory?
Start by freezing reorders on affected SKUs, then match an action to each one: reprice, bundle, sell through another channel, return to the supplier or write it down. Work from the biggest dollar amounts first. Then fix the cause, usually reorder points or forecasts, so the pile doesn’t return.
What is the difference between slow moving and non-moving inventory?
Slow moving items still sell, just well below the pace you planned. Non-moving items have had no sales for an extended period, often six months or more. Non-moving stock is more likely to need liquidation or a write-down.
How do you value slow moving inventory?
Carry it at the lower of cost and net realizable value, which is the expected selling price minus the costs of selling it. If that figure is below cost, record the difference as a write-down. IAS 2 sets this rule for IFRS and Topic 330 covers US GAAP. Your CPA can confirm the right method for your books.
How long before inventory is considered slow moving?
It depends on your category. Common thresholds run from about 90 to 180 days, and shorter for perishables. Set yours from your normal sell-through and replenishment cycle, then review it each year.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- NetSuite: Slow-Moving Inventory
- IAS 2 Inventories, IFRS Foundation
- Intermittent demand and slow-moving stock value (Semantic Scholar)
- Improvement of Inventory Management and Demand Forecasting by Big Data Analytics in Supply Chain
- Reliable Prediction Intervals and Bayesian Estimation for Demand Rates of Slow-Moving Inventory
- Optimizing Inventory Management Through Advanced Forecasting Methods and Strategic Stocking
- Forecasting and inventory replacement decisions (Politechnika Lubelska)

2 Responses