Finance tools
Days inventory outstanding (DIO) calculator
Free DIO calculator (days inventory outstanding / days sales of inventory) for US finance and operations teams. Enter COGS and average inventory — or beginning and ending balances — to compute DIO = (average inventory ÷ COGS) × days in period, see inventory turnover, and export CSV or PDF. Live results, no sign-up.
What is days inventory outstanding (DIO)?
Days inventory outstanding (DIO) — also called days sales of inventory (DSI), days inventory on hand (DOH), or inventory days — measures how long inventory sits before it is sold. It answers: how many days of COGS are tied up in stock on average?
DIO is a working-capital efficiency metric: finance uses it on monthly closes; operators use it to spot slow movers and cash trapped in warehouses.
Lower DIO usually means faster inventory turnover — but the right level depends on your industry, season, and product shelf life, not a single benchmark number.
Days inventory outstanding formula
Formula
Average inventory = (Beginning inventory + Ending inventory) ÷ 2
DIO = (Average inventory ÷ COGS) × Days in period
DIO = Days in period ÷ Inventory turnover
How to use this DIO calculator
Gather COGS and inventory
Pull cost of goods sold from the income statement and inventory from the balance sheet for the same period.
Enter beginning and ending inventory
Use beginning and ending balances, or switch to average inventory mode if you already computed the average.
Set days in the period
Use 365 for a fiscal year, or 90 / 180 for a quarter or half year — keep COGS aligned to that period.
Read DIO and export
Review days inventory outstanding, inventory turnover, and the breakdown — then download CSV or PDF if needed.
DIO vs inventory turnover
Inventory turnover = COGS ÷ average inventory (how many times stock cycles in the period). DIO converts that speed into calendar days. Example: turnover of 10× with a 365-day year ≈ 36.5 days of inventory on hand.
See our inventory turnover ratio glossary for benchmarks and retail context. This calculator shows both metrics on the results panel.
How to calculate DIO in Excel
| Cell | Input |
|---|---|
| A1 | Beginning inventory |
| A2 | Ending inventory |
| A3 | =(A1+A2)/2 average inventory |
| B1 | COGS for the period |
| B2 | Days in period (e.g. 365) |
| B3 | =(A3/B1)*B2 DIO in days |
DIO vs DSO vs DPO
Days sales outstanding (DSO) tracks how long receivables stay open after a sale — use our days sales outstanding calculator for the receivables leg. Days payable outstanding (DPO) tracks how long you take to pay suppliers. DIO is the inventory leg — all three are working-capital days metrics with different inputs.
The cash conversion cycle combines them: CCC = DIO + DSO − DPO. This calculator outputs DIO only; pair it with the DSO tool when you need receivables days for a full CCC.
Retail and hospitality context
Perishable-heavy operators often run lower DIO than furniture or specialty retail — compare to your own trend, not a single industry headline. When inventory days and foot traffic move together, labor plans stay aligned with what the shelf is actually selling; see our inventory turnover ratio glossary for retail and hospitality benchmarks.
What is a good days inventory outstanding?
There is no universal “good” DIO. A number that looks healthy for a grocery operator can be dangerously low for a custom manufacturer with long lead times. Compare your trend and peers with similar products before treating a headline ratio as pass or fail.
| Industry (orientation) | Typical DIO direction | Why it varies |
|---|---|---|
| Grocery / food service | Often lower | Perishables, frequent replenishment |
| General retail | Moderate | Seasonal assortments, markdown cycles |
| Furniture / specialty | Often higher | Slower SKU velocity, longer shelf life |
| Distribution / wholesale | Moderate to lower | Contract mix, turnover targets |
Some finance references cite wide bands (for example 30–60 days) for generic “inventory days” — treat those as orientation only, not a target for every business model.
How to interpret days inventory outstanding
Lower DIO generally means inventory converts to sales faster — less cash tied up, often less spoilage risk. Watch for stockouts if DIO drops because purchasing cut too deep, not because demand improved.
Higher DIO can signal overstock, obsolete SKUs, or weak demand. Seasonal build-ups (for example pre-holiday inventory) can temporarily raise DIO without a structural problem.
DIO alone does not explain why inventory is slow — pair it with turnover by category, shrink, and your own prior-year same quarter before changing purchasing or labor plans.
Where to find COGS and inventory
On the income statement, cost of goods sold (COGS) usually sits below revenue (sometimes labeled cost of sales). On the balance sheet, inventory is a current asset — use beginning and ending balances for the same period as COGS when you compute average inventory.
Public companies report these lines in quarterly and annual filings; private operators can pull the same fields from bookkeeping exports. Keep retail-valued POS inventory separate from cost-based ledger figures — mixing bases skews DIO.
Worked example
Average inventory $625,000, annual COGS $6,500,000, 365 days:
($625,000 ÷ $6,500,000) × 365 = 35.10 days. Load the Regional manufacturer (~35 days) preset to reproduce this result.
SMB example: average inventory about $16,670, COGS $137,780, 365 days → 44.16 days DIO. Use the Plant nursery (~44 days) preset to check the math.
More free tools
Discover more calculators for time tracking, payroll, and HR.
Frequently asked questions
How do you calculate days inventory outstanding?
Divide average inventory by COGS, then multiply by the number of days in the period. If you only have year-start and year-end inventory, average inventory = (beginning + ending) ÷ 2.
What is the DIO formula?
DIO = (Average inventory ÷ COGS) × Days in period. Equivalently, DIO = Days in period ÷ Inventory turnover.
Is days inventory outstanding the same as days inventory on hand?
In practice, yes — DIO, days sales of inventory (DSI), and inventory days usually refer to the same idea: how long inventory sits before sale, using COGS and average inventory.
What is the difference between DIO and days sales outstanding (DSO)?
DIO measures inventory efficiency (stock on hand). DSO measures how long it takes to collect receivables after a sale. They are both working-capital metrics but use different inputs. Calculate DSO with our days sales outstanding calculator.
What is a good days inventory outstanding ratio?
There is no universal good DIO. Grocery and food service often run lower DIO than furniture or specialty retail. Compare to your own trend and to businesses with similar products and shelf life.
How do I calculate DIO for a quarter?
Use that quarter’s COGS and average inventory for the same quarter, and set days in period to 90 (or the actual calendar days in the quarter). Do not mix quarterly COGS with annual inventory without adjusting the period.
Can I use ending inventory instead of average inventory?
Some models use ending inventory for convenience when the period is short or inventory is stable. For seasonal businesses, the two-point average is more accurate — this calculator defaults to beginning and ending balances.
What is the difference between days inventory outstanding and inventory turnover?
Inventory turnover = COGS ÷ average inventory (how many times stock cycles in the period). DIO expresses the same speed in calendar days: DIO = days in period ÷ turnover (or average inventory ÷ COGS × days). This calculator shows both metrics on the results panel.
Is DIO the same as employee turnover?
No. Employee turnover is an HR metric (separations ÷ headcount). DIO is a stock and COGS metric. English uses “turnover” for both — check which formula you need.
How do I improve days inventory outstanding?
Common levers: reduce slow-moving SKUs, tighten purchasing to demand, cut spoilage and shrink, improve forecasting, and segment metrics by store or category instead of one company-wide average.
What is the cash conversion cycle?
The cash conversion cycle combines DIO with days sales outstanding (DSO) and days payable outstanding (DPO): CCC = DIO + DSO − DPO. This tool calculates DIO only — use our DSO calculator for receivables days.
How is DIO different from the safety stock calculator?
DIO uses balance-sheet inventory and COGS for a period. The safety stock calculator focuses on reorder points and buffer units from demand variability — a different operational question.
What is DSO, DOH, and DPO?
DSO (days sales outstanding) measures how long receivables stay open. DPO (days payable outstanding) measures how long you take to pay suppliers. DOH (days on hand) is often used interchangeably with DIO/DSI for inventory days. Together with DIO they feed the cash conversion cycle: CCC = DIO + DSO − DPO.
How do I calculate days inventory outstanding in Excel?
Average inventory in cell A3: =(A1+A2)/2 from beginning and ending inventory. With COGS in B1 and days in B2, DIO in B3: =(A3/B1)*B2. Use the same period for COGS, inventory, and days — see the Excel table above the FAQ.
Do you want a high or low days inventory outstanding?
Usually lower DIO is better for working capital — inventory turns faster and ties up less cash. Extremely low DIO can mean stockouts; very high DIO can mean dead stock. Optimize for steady turns without lost sales, not the lowest possible number on every close.