Days Inventory Outstanding (DIO)

Days Inventory Outstanding is the average number of days a business holds inventory before selling it. It measures how long cash stays locked in stock, and a rising DIO is a direct signal that working capital is accumulating on the shelf rather than moving through the business.

DIO = (Average Inventory / Cost of Goods Sold) × Number of Days

Average inventory is typically the mean of the opening and closing inventory balances for the period. Cost of goods sold is the total for the same period. The number of days matches the period: 30 for monthly, 90 for quarterly, 365 for annual.

Using average inventory rather than the closing balance produces a more representative result, particularly for businesses with seasonal stock patterns where the period-end balance may be atypically high or low. If monthly data is available, an average across all twelve monthly closing balances gives an even cleaner annual figure.

Some sources use total inventory purchases rather than cost of goods sold in the denominator. COGS is more widely used and is the standard for the cash conversion cycle calculation, so it is worth being consistent when DIO feeds into that broader metric.

A small kitchen equipment wholesaler wants to calculate its DIO for Q3. Opening inventory was $210,000 and closing inventory was $190,000, giving an average of $200,000. Cost of goods sold for the quarter was $600,000.

DIO = ($200,000 / $600,000) × 90 = 30 days

Inventory turns over every 30 days on average. For a wholesaler moving kitchen equipment, that is a reasonable cycle, products are not sitting for months, and the business is not under-stocked to the point of missing orders.

Now suppose Q4 brings a slowdown in orders. Average inventory rises to $270,000 as purchases continue at the same pace but sales soften, and COGS drops to $450,000.

DIO = ($270,000 / $450,000) × 90 = 54 days

DIO has climbed from 30 to 54 days. The business now holds stock for nearly twice as long before it sells. That extra $70,000 sitting in average inventory is cash that was paid to suppliers and is now waiting on a customer order before it can come back. The income statement may not yet show the problem clearly, but the cash position is already feeling it.

It makes the cash cost of slow stock visible

Inventory on the balance sheet looks like an asset, and technically it is. But it is an asset the business has already paid for that has not yet generated any return. Every day that stock sits unsold is a day the cash used to buy it is unavailable for anything else, payroll, supplier invoices, a tax payment that falls due on schedule regardless of what is on the shelves. DIO puts a number on how long that wait typically is, which makes the cash cost of carrying inventory concrete rather than abstract.

It distinguishes a stocking problem from a sales problem

A rising DIO can come from two different directions. The business may be buying too much stock relative to demand, or it may be buying at a normal rate while sales have softened. The DIO number does not separate the two on its own, but tracking it alongside purchase volumes and sales trends makes the cause visible. Overbuying calls for a change in procurement; a sales slowdown calls for a different response. Acting on the wrong diagnosis costs time and cash.

It feeds directly into the cash conversion cycle

DIO is one of the three components of the cash conversion cycle, alongside Days Sales Outstanding and Days Payable Outstanding. A long DIO lengthens the overall cycle and increases the amount of working capital the business needs to keep operating. Reducing DIO by even a week or two can free up meaningful cash without touching the revenue line, the cost structure, or supplier relationships, it comes entirely from moving existing stock faster.

Days Inventory Outstanding is cash sitting on shelves. The longer stock waits to sell, the longer your money is frozen in it.

That framing is literal. When a business buys inventory, cash leaves the account immediately or within the supplier credit period. It does not come back until the stock sells and the customer pays. Everything in between, the purchasing, the warehousing, the waiting, is a period during which the business has absorbed a cash outflow without receiving the corresponding inflow. A DIO of 54 days means the average dollar spent on stock takes 54 days to start its journey back. Add DSO on top of that and the full round-trip from cash-out to cash-in could be 70 or 80 days, depending on customer payment terms.

The cash flow forecast reflects this whether or not the business tracks DIO explicitly. Inventory purchases show up as outflows when they are paid. The corresponding inflows from sales arrive weeks later. When DIO is rising, that gap widens in the forecast: outflows group earlier in the timeline while inflows push out further. A business that only looks at the bank balance will see that pattern after the fact. One that monitors DIO alongside a rolling forecast sees it developing and has time to adjust purchasing before the gap becomes a shortfall.

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, and Sage Intacct and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

Inventory purchases and the cost of goods flow through the accounting system, which means they appear in the forecast as actual scheduled outflows rather than estimates. When purchasing patterns change, more stock going out, slower sales coming in, the forecast adjusts as the books update. If you want to understand what is driving a projected cash gap at a particular point, the tool drills down to the transaction level, so you can see specific purchase payments and their timing in context. For businesses with multiple entities or currencies, including those carrying inventory across different locations or markets, that forecast runs natively without a separate consolidation step. You can explore the forecasting features at cashflowfrog.com/features/forecast/.

Frequently Asked Questions

It depends entirely on the industry and the type of product. A food wholesaler dealing in perishables should have a DIO measured in single digits. A manufacturer of custom industrial equipment might carry a DIO of 60 days or more by necessity, because the production cycle simply takes that long. The most useful benchmark is your own trend over time: if DIO is rising quarter over quarter without a corresponding increase in sales, that is a signal worth investigating regardless of whether the absolute number looks high or low against an industry average.

Does DIO apply to service businesses?

No. DIO is specific to businesses that hold physical inventory. A pure service business, a consultancy, an accounting firm, a marketing agency, has no stock and no meaningful DIO. The cash conversion cycle for a service business is better understood through DSO and DPO alone, which capture the gap between billing clients and paying costs.

How is DIO different from inventory turnover?

Inventory turnover measures how many times inventory is sold and replaced over a period. DIO is the inverse expressed in days: DIO = Number of Days / Inventory Turnover. A turnover of 12 times per year corresponds to a DIO of roughly 30 days. The two convey the same information; DIO is often more intuitive for cash flow purposes because it maps directly to a number of days, which is the same unit used in DSO and DPO.

Can DIO be too low?

Yes. A DIO that is very low might indicate the business is carrying insufficient stock to meet demand reliably. Stockouts have a cost: lost sales, emergency procurement at higher prices, damage to customer relationships when orders cannot be fulfilled. The right DIO is the one that keeps the business well-stocked without tying up more cash than necessary. Finding that point requires looking at both the DIO trend and the fill rate, whether customer orders are being fulfilled on time and in full.

How do you reduce DIO without risking stockouts?

The main levers are purchasing frequency and order quantities. Buying in smaller amounts more often reduces the average inventory balance and therefore DIO, though it may increase per-unit costs if volume discounts are lost. Improving demand forecasting so purchases align more closely with expected sales also helps, since overbuying is one of the most common causes of a rising DIO. For businesses with a range of product lines, calculating DIO by SKU or category often reveals that a small number of slow-moving lines are pulling the overall number up while the rest of the range turns quickly.

What happens to DIO during seasonal peaks?

DIO typically rises in the build-up to a seasonal peak as the business stocks up ahead of demand, then falls sharply as that stock sells through. That pattern is normal and expected, but it has real cash flow consequences: the stocking-up phase represents a significant cash outflow before the sales inflows arrive. A forecast that accounts for seasonal DIO movement gives advance visibility of that gap, which is when decisions about credit facilities or payment timing with suppliers are most usefully made.

• Cash Conversion Cycle
• Days Sales Outstanding
• Days Payable Outstanding
• Working Capital
• Cost of Goods Sold
• Cash Flow Forecast