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.
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
- The DIO formula
- A worked example
- DIO versus inventory turnover
- What is a good days inventory outstanding number?
- Why DIO matters for cash
- How to improve days inventory outstanding
- How to calculate and track DIO in a spreadsheet
- Common DIO mistakes to avoid
- Our perspective
- Put DIO to work in your business
- FAQ
- Sources
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
- Your DIO against last year’s, same month. This removes seasonality.
- Your DIO by product category. A blended number can hide a fast-moving line and a dead one.
- 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.

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.
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
- Days Inventory Outstanding, Corporate Finance Institute
- Days Inventory Outstanding (DIO) Formula and Calculator, Wall Street Prep
- Days Sales of Inventory (DSI), Investopedia
- What Is Days Inventory Outstanding?, Taulia
- EM3087 Examining Accounts: Business Ratios, GOV.UK
- Examine the Efficiency of Inventory Management Using Financial Ratios, OpenStax
- Days in Inventory Definition, Formula and Example, Shopify
- DIO Meaning Inventory: Formula and How to Improve It, Shopify
- Cash Flow vs. Profit for Owners
- What Does Inventory Turnover Ratio Mean: A Manager’s Guide

One Response