Skip to main content

Frac CFO

By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 6, 2026

Days inventory outstanding (DIO) is the average number of days your business holds inventory before selling it. The formula is (average inventory ÷ cost of goods sold) × 365. A lower number means stock turns into cash faster. A higher number means cash is sitting on your shelves. This guide shows you how to calculate it, how to read the result, and how to track it in a spreadsheet you already use.

Fraccfo
Bring Inventory Metrics Into Focus
Frac CFO helps businesses use existing spreadsheets for financial modeling, forecasting, and clearer insight into cash flow and financial health.

Explore spreadsheet finance support

TL;DR

  • DIO = (average inventory ÷ COGS) × 365. Use cost of goods sold, never revenue, and keep both figures on the same time period.
  • It is the same metric as days sales of inventory (DSI) and days in inventory. It equals 365 ÷ inventory turnover.
  • There is no universal good number. Compare yourself to your own industry and your own trend, not to other sectors.
  • Lowering DIO frees working capital: cutting DIO from 60 to 40 days on $1M of annual COGS releases roughly $55,000 of cash.
  • A simple spreadsheet with separate cells for each input is enough to track DIO monthly.

Table of Contents

What days inventory outstanding means

DIO tells you how long, on average, a dollar of inventory stays in your business before it becomes a sale. Corporate Finance Institute describes it as a liquidity metric and an indicator of operational and financial efficiency, showing how quickly inventory can be turned into cash.

You will see the same idea under several names. Investopedia lists days sales of inventory (DSI), days in inventory (DII), days sales in inventory and simply days inventory as alternate labels for the same calculation. Some accountants also say “inventory period” or “inventory days of supply.” If a lender, investor or bookkeeper uses any of these, they mean this ratio.

DIO is not the same as days sales outstanding (DSO). DSO measures how long customers take to pay you after a sale. DIO measures how long product waits before the sale happens. Both matter for cash, and we put them side by side later in this guide.

The DIO formula

The standard formula, as laid out by Wall Street Prep, is:

DIO = (Average Inventory ÷ Cost of Goods Sold) × 365

where Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2.

You need only two numbers:

  • Inventory balance: from your balance sheet, at the start and end of the period.
  • COGS: from your income statement, the direct cost of the products you sold.

Both must cover the same period. If you measure a quarter, replace 365 with the number of days in that quarter, typically 90.

A simpler cousin of the formula appears in tax guidance. The UK tax authority’s enquiry manual uses value of stock × 365 ÷ value of purchases to estimate days of stock in hand. That version is a cross-check used by examiners, and the COGS-based version is the one most businesses and lenders use.

The most common mistake: using revenue

Revenue includes your margin. Inventory is recorded at cost. Divide cost by revenue and you compare unlike things, which makes DIO look shorter than it really is. Always pull COGS, not sales.

A worked example

Imagine an online home-goods store. Here are its numbers for the year:

Item Amount
Beginning inventory (Jan 1) $50,000
Ending inventory (Dec 31) $70,000
Cost of goods sold for the year $500,000

Step 1: average inventory. ($50,000 + $70,000) ÷ 2 = $60,000.

Step 2: divide by COGS. $60,000 ÷ $500,000 = 0.12.

Step 3: multiply by 365. 0.12 × 365 = 43.8 days.

The store takes about 44 days to sell through its stock. Put differently, its inventory turnover is $500,000 ÷ $60,000 = 8.33 times a year, and 365 ÷ 8.33 gives the same 43.8 days.

Using a shorter period

Say the same store wants a quarterly view. Q3 COGS is $140,000, inventory at the start of Q3 is $62,000 and at the end is $74,000. Average inventory is $68,000. DIO = ($68,000 ÷ $140,000) × 90 = 43.7 days. Quarterly numbers are useful because they show seasonal swings that an annual figure hides.

DIO versus inventory turnover

These two ratios describe the same behavior from different angles. Per Wall Street Prep, inventory turnover is COGS ÷ average inventory, and DIO equals 365 ÷ inventory turnover. Turnover answers “how many times a year do we cycle through stock?” DIO answers “how many days does one cycle take?”

Inventory turnover Days inventory outstanding
Formula COGS ÷ average inventory (Average inventory ÷ COGS) × 365
Unit Times per year Days
Higher means Faster sell-through Slower sell-through
Best for Comparing to peers Explaining cash tied up in stock

Most owners find days easier to act on. “We hold 44 days of stock” is easier to picture than “we turn 8.3 times.” If you want a second explanation of the turnover side, this inventory turnover ratio guide walks through it for managers.

What is a good days inventory outstanding number?

The honest answer is that it depends on what you sell. Corporate Finance Institute notes that food companies generally run around 6 days while steel companies average about 50, and that DIO should never be compared across industries. The UK tax authority’s guidance makes the same point: stock turnover is high for a food retailer and low for a jeweler or antiques dealer.

For general retail and e-commerce, Shopify says 30 to 60 days is generally considered optimal, while adding that it varies by industry and company size. Treat that as a starting zone, not a target.

Reading your own result

A falling DIO usually means you are selling stock faster or buying more tightly. That frees cash and lowers the risk of obsolete product.

A rising DIO is a warning. The OpenStax financial accounting text describes an increase in the ratio as an unfavorable change that alerts management that inventory is taking too long to sell. Causes include weak sales, over-ordering, or products that have gone out of favor.

A very low DIO is not automatically good. If you hold too little, you can run out of bestsellers and lose sales when demand jumps. The aim is the lowest DIO you can run without stockouts.

Three comparisons that matter more than any benchmark

  1. Your DIO against last year’s, same month. This removes seasonality.
  2. Your DIO by product category. A blended number can hide a fast-moving line and a dead one.
  3. Your DIO against peers in your niche, using published ratios for similar businesses.

Why DIO matters for cash

Inventory is cash you have already spent. Every extra day it sits, that money cannot pay suppliers, fund payroll or finance growth. Profit does not show this problem, because buying stock is not an expense until the stock sells. A business can look profitable on paper and still feel short of cash. If you want the lender’s view of that gap, this piece on cash flow versus profit explains why lenders look beyond profit.

The cash impact is easy to estimate. Daily COGS is annual COGS ÷ 365. Each day of DIO you remove frees about one day of COGS in cash.

Example: annual COGS of $1,000,000 is about $2,740 a day. Cutting DIO from 60 days to 40 days releases 20 days × $2,740, roughly $55,000, without borrowing a cent.

Why DIO matters for cash

DIO inside the cash conversion cycle

DIO inside the cash conversion cycle

DIO is one of three parts of the cash conversion cycle (CCC): CCC = DIO + DSO − DPO, as Taulia’s glossary sets out. DSO is days sales outstanding and DPO is days payable outstanding, meaning how long you take to pay suppliers.

Here is what that looks like for a small business:

Component Days
DIO (stock sits before sale) 44
DSO (customers take to pay) 12
DPO (you take to pay suppliers) 30
Cash conversion cycle 26

You fund 26 days of operations out of your own cash. Shorten DIO or DSO, or lengthen DPO within your supplier terms, and the gap narrows. Because DIO is often the largest of the three for product businesses, it is usually the first place to look.

How to improve days inventory outstanding

Every DIO improvement works the same way: reduce average inventory without reducing COGS. You still sell the same amount, with less capital parked on shelves. These are the levers that tend to work for small and midsize product businesses.

1. Forecast demand from your own sales history

Shopify recommends reviewing point-of-sale reports and historical sales to improve forecasting. Start with the last 12 months of units sold by SKU, note the seasonal peaks, and order to the pattern instead of to a hunch.

2. Set reorder points and safety stock deliberately

A reorder point is the stock level that triggers a new order. It equals daily units sold times supplier lead time, plus safety stock. Review it quarterly. If a supplier’s lead time shortens, your safety stock can shrink with it.

3. Rank products with an ABC analysis

Sort products by annual sales value. The top group (A items) deserves tight control and frequent review. The bottom group (C items) should not tie up much cash. This is the fastest way to see where your inventory dollars are actually working.

4. Move slow sellers

Shopify suggests promoting slow-moving products through displays and bundling, and clearing dead stock through donation, which can also bring a tax deduction. Talk to your accountant about how donations are treated in your situation. We cover this in more depth in our guide to slow moving inventory: how to find it, value it and fix it.

5. Negotiate smaller, more frequent orders

Smaller batches cost a little more per unit in some cases, but they lower average inventory. Run the math: if the extra unit cost is smaller than the cost of tying up cash, smaller batches win.

6. Watch both sides of the ratio

Do not cut stock so far that you lose sales. Track fill rate or stockout days beside DIO, so you can see if a lower number is costing you revenue.

How to calculate and track DIO in a spreadsheet

You do not need new software to monitor DIO. Excel or Google Sheets handles it well, provided the layout is clean. Keep each component in its own cell so you can troubleshoot a strange result quickly.

A simple monthly layout

Column What goes in it
A: Month Jan, Feb, Mar and so on
B: Beginning inventory Prior month’s ending balance
C: Ending inventory Balance sheet figure
D: Average inventory =(B2+C2)/2
E: COGS Income statement, same month
F: Days in period 31, 28, 30 and so on
G: DIO =D2/E2*F2

Copy row 2 down for each month and chart column G as a line. A rising line is your early warning.

Tips that prevent bad numbers

  • Match periods. Monthly inventory with annual COGS gives nonsense.
  • Use days in the actual month, or use 30 consistently and say so in a note.
  • Smooth with a trailing three-month DIO if one month swings widely.
  • Add a column per category so a slow line does not hide inside the blend.
  • Lock formula cells so nobody types over them.

If you would rather start from a ready layout, our inventory tracker and inventory dashboard templates are built for exactly this kind of monthly tracking in Excel and Google Sheets.

Common DIO mistakes to avoid

  • Using revenue instead of COGS. It understates DIO.
  • Using only year-end inventory. If you stock up before a peak season, year-end inventory misrepresents the year. Averaging beginning and ending, or using monthly balances, is better.
  • Comparing across industries. A 45-day DIO is excellent in one sector and alarming in another.
  • Ignoring product mix. One slow line can drag an otherwise healthy number.
  • Treating DIO as the whole story. Pair it with gross margin, DSO and DPO.

Our perspective

Most small business owners we meet do not need another system. They need their existing spreadsheet to answer one question clearly: how much cash is sitting in stock, and when does it come back?

DIO is one of the cleanest ways to answer it. It takes two numbers you already have, and once it is in a sheet with a trend line, the conversation changes. You stop guessing at reorders and start planning them against cash.

That is why we build around Excel and Google Sheets. You keep control and understanding of your own data, with tools you already use. We connect DIO to your cash flow forecast, your budget and your KPI dashboard, so the number tells you what to do next, not just what happened.

Our approach is to make the numbers tell a story: which products earn their shelf space, which ones tie up cash, and what a 10-day improvement is worth in dollars.

frac

Put DIO to work in your business

If you want DIO, cash flow and profitability in one spreadsheet you understand, we can help. Our Excel templates give you a ready structure, including the Inventory & Orders Tracker. Our Launch Kit is a one-off $650 package. For a custom build, such as a KPI dashboard or a 13-week cash flow forecast, see our one-time finance projects.

Inventory  Orders Tracker

If you want ongoing support, our fractional CFO plans start at $600 a month on the Starter plan, with hands-on onboarding and email support. To see how inventory fits your wider cash picture, explore our Working Capital Optimizer.

FAQ

What does days inventory outstanding mean?

It is the average number of days a company holds inventory before selling it. It is calculated as (average inventory ÷ COGS) × 365. A lower figure means you convert stock to sales, and then cash, faster.

Is days inventory outstanding the same as days sales of inventory?

Yes. DIO, DSI and days in inventory are different names for the same calculation, according to Investopedia. Days sales outstanding (DSO) is a different measure. It tracks how long customers take to pay you.

What is a good inventory days number?

It depends on your industry. Food businesses can run near 6 days, while steel averages about 50, according to Corporate Finance Institute. For general retail, 30 to 60 days is often cited as a healthy zone. Compare yourself to similar businesses and to your own trend.

What is the difference between DIO and inventory turnover?

Inventory turnover counts how many times you sell through your stock in a year. DIO counts how many days one cycle takes. They are linked by DIO = 365 ÷ inventory turnover.

How do I lower my DIO without running out of stock?

Improve forecasts using your sales history, set reorder points by SKU, and focus tight control on your top-selling products. Move slow sellers with bundles or promotions. Track stockout days next to DIO so you notice if a lower number starts costing sales.

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

One Response

Leave a Reply