Days Inventory Outstanding: Formula, Example, Benchmarks

Days inventory outstanding (DIO) measures the average number of days a company holds inventory before selling it. You calculate it by dividing average inventory by cost of goods sold and multiplying by 365. A DIO of 45 means stock sits on the shelf for about a month and a half before it converts to a sale. Lower usually means faster cash conversion, but push it too low and you start missing sales because you have nothing to ship.

DIO is one of the three legs of the cash conversion cycle, alongside days sales outstanding and days payable outstanding. Controllers track it because it is the clearest single number for how much cash is frozen in the warehouse.

What is days inventory outstanding?

Days inventory outstanding is a working capital ratio that answers one question: how long does it take this business to turn inventory into a sale? It is sometimes called days inventory, days in inventory, or inventory days on hand, and the abbreviation DIO is used interchangeably with DSI (days sales of inventory). They all describe the same calculation.

The reason it matters is cash. Every dollar sitting in inventory is a dollar you already paid a supplier for and cannot spend on anything else. It is also a dollar exposed to shrinkage, obsolescence, storage cost, and insurance. A distributor carrying 120 days of stock has roughly four months of purchasing tied up in a building, and if demand shifts, a chunk of that becomes markdown material.

How do you calculate days inventory outstanding?

The standard formula uses average inventory and cost of goods sold over the same period.

Two details trip people up. First, use cost of goods sold in the denominator, not revenue. Inventory sits on the books at cost, so matching it against a number that includes your margin inflates the ratio and makes performance look better than it is. Second, use average inventory rather than the closing balance if your business is seasonal. A retailer measuring DIO on December 31, right after the holiday sell through, will report a flattering number that has nothing to do with how the year actually ran.

A worked example

A wholesale distributor reports cost of goods sold of $4,380,000 for the year. Inventory opened at $520,000 and closed at $680,000.

Average inventory is ($520,000 + $680,000) / 2, which is $600,000. Divide that by COGS of $4,380,000 to get 0.137, then multiply by 365. DIO is 50 days.

So this distributor holds about 50 days of stock. Cross check it against turnover: $4,380,000 / $600,000 gives an inventory turnover of 7.3 times a year, and 365 / 7.3 is 50. The two ratios are the same measurement expressed differently, which is a useful sanity check when a number looks wrong.

What is a good days inventory outstanding?

There is no universal target. A good DIO is one that is low relative to companies selling the same kind of product, and stable or improving over time. Comparing a grocery chain to an equipment manufacturer tells you nothing except that food spoils and excavators do not.

Treat those as directional. The number that actually matters is your own trend line and the spread between you and named competitors in your sector, which you can pull from public filings if they are listed.

Is a higher or lower DIO better?

Lower is generally better, up to the point where it starts costing you sales. Falling DIO means inventory is converting to revenue faster, less cash is trapped, and there is less exposure to obsolescence. That is why lean and just in time programs target it directly.

But a very low DIO can be a warning rather than an achievement. If stock is thin because you cannot fund purchases, or because a supplier is unreliable, you will hit stockouts, backorders, and lost customers that never show up as a line item. The right read is DIO next to fill rate and stockout frequency. Falling DIO with a steady fill rate is genuine improvement. Falling DIO with rising stockouts means you are starving the business.

DIO vs inventory turnover: what is the difference?

They measure the same thing on different scales, and each is easier to reason about in different situations.

Use turnover when you want a fast comparison across product lines. Use DIO when you are doing cash planning, because days are the same unit as your payment and collection terms, so the three numbers add and subtract cleanly.

How DIO fits the cash conversion cycle

The cash conversion cycle is the number of days between paying a supplier and collecting from a customer:

CCC = DIO + DSO - DPO

Inventory days plus collection days, minus the days your suppliers effectively finance you. Our distributor with a DIO of 50, a days sales outstanding of 38, and a days payable outstanding of 32 has a cash conversion cycle of 56 days. That is nearly two months of operations funded out of its own pocket before a customer's cash arrives.

This is why the three ratios have to be managed together. Cutting DIO by ten days frees the same cash as stretching supplier terms by ten days, but the second option damages vendor relationships and forfeits early payment discounts, while the first is pure operational gain. There is a fuller walkthrough in our guide to the cash conversion cycle and how each lever moves working capital.

How do you reduce days inventory outstanding?

Most of the durable gains come from better data rather than aggressive cost cutting.

• Segment the SKUs. Run an ABC analysis. A small share of items usually drives most of the value, and a long tail of slow movers quietly inflates the average. Set separate reorder policies rather than one blanket rule.
• Fix the demand forecast before the reorder points. Reorder quantities calculated from a bad forecast just automate the wrong decision. Start with clean sales history and a real seasonality view.
• Shorten supplier lead times. Safety stock exists to cover lead time variability. Cut the variability and you can cut the buffer without raising stockout risk. Reliability matters more than headline speed here.
• Clear the dead stock deliberately. Aged inventory suppresses DIO improvement forever if you never write it off or discount it. Take the hit once and stop paying to store it.
• Match receipts to what you were actually invoiced for. Quantity discrepancies between the purchase order, the packing slip, and the supplier invoice quietly distort inventory valuation. Three way matching keeps the recorded balance honest, and if those receiving documents arrive as scans, pulling the line item data off them automatically beats keying quantities by hand.

Where accounts payable comes into it

DIO is calculated from inventory and COGS, and both depend on supplier invoices being recorded accurately and on time. If bills sit in an inbox for three weeks before anyone enters them, your inventory balance and your cost of goods sold are both wrong at month end, and every ratio built on them is wrong too. Goods received but not invoiced is the classic version of this problem, and it distorts DIO in both directions depending on which side of the close the paperwork lands.

Getting invoices captured, coded, and matched quickly is not a glamorous fix, but it is the one that makes the ratio trustworthy. Accounts payable software that extracts invoice line items automatically and matches them against purchase orders and receipts keeps the inventory and COGS figures current, which means DIO reflects the business rather than the state of the paperwork. If you also want a cleaner inventory valuation method behind the number, that is worth reviewing at the same time.

Common questions

What does days inventory outstanding tell you? It tells you how many days of cash are tied up in stock. A DIO of 60 means you fund roughly two months of inventory before it converts to revenue, which sets a floor on how much working capital the business needs.

Can days inventory outstanding be negative? No. Inventory and COGS are both positive figures in normal operations, so DIO cannot go below zero. A business that holds no inventory, like a pure services firm, simply has a DIO of zero and drops the term from its cash cycle.

Should I use 365 or 360 days? Use 365 for reporting and comparison against published benchmarks. Some treasury teams use 360 for quick monthly math. Either is defensible as long as you apply it consistently, because switching mid year creates an apparent improvement that is not real.