Skip to main content

Frac CFO

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.

Fraccfo
Turn Inventory Data Into Clearer Decisions
Frac CFO helps businesses use existing spreadsheets for customized financial modeling, forecasting and dashboards that clarify cash flow and support decisions.

Visit Frac CFO

TL;DR

Table of Contents

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:

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:

  1. SKU and description
  2. Units on hand
  3. Unit cost
  4. Date of last receipt (use the oldest open lot if you can)
  5. Date of last sale
  6. 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.

Four inventory age buckets from new to oldest

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:

  1. For each at-risk SKU, estimate the realistic selling price.
  2. Subtract selling costs such as fees, shipping and handling.
  3. If the result is below your cost, the difference is the write-down.
  4. 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:

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.

Inventory  Orders Tracker

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

2 Responses

Leave a Reply