How Can Finance Teams Use Days Inventory Outstanding to Free Up Working Capital

Inventory can tie up more cash than most teams realize, especially when stock keeps sitting after purchase. Days inventory outstanding (DIO) is the average number of days a company holds inventory before selling it, making it a direct measure of how much of your cash is tied up in unsold goods.

In this guide, we cover what DIO is, how it differs from DSI and DSO, how to calculate it with a worked example, and four steps that reduce it without cutting into your service levels.

In brief:

• Days inventory outstanding (DIO) measures how many days on average a company holds inventory before selling it, calculated as (Average Inventory / COGS) × 365.
• DIO and DSI (days sales of inventory) are the same metric under different names. DSO is a separate measure that tracks how long it takes to collect payment after a sale.
• Cutting DIO from 60 to 40 on $1M in annual COGS frees approximately $55,000 in working capital without new financing.
• A rising DIO while sales are flat or declining signals inventory accumulating faster than demand, which typically points to a purchasing cadence problem.
• Lowering DIO starts with real-time inventory visibility that informs purchasing decisions, not by cutting safety stock below demand requirements.

What is days inventory outstanding (DIO)?

Days inventory outstanding is the average number of days a company holds its inventory before selling it. The metric measures how quickly a company converts inventory into cash, making it useful for cash flow forecasting and tracking operational efficiency.

DIO also goes by a few other names, including days of inventory on hand (DOH), days in inventory (DII), and inventory days, though all use the same calculation.

For a 75-person product company where finance landed on someone's desk alongside their actual job, every extra day of inventory holding time keeps cash frozen longer than it needs to be.

What are the differences between DIO, DSI, and DSO?

DIO and DSI use the same formula under different names: (Average Inventory / COGS) × 365. DSO measures something entirely different: how long it takes to collect payment from customers after a sale has already occurred, typically calculated as (Accounts Receivable / Net Credit Sales) × 365.

Let’s see how each metric works and where it fits in your financial picture:

Lower is generally better for all three measures because shorter holding or collection periods put less pressure on cash flow. When DIO or DSI rises, it signals an inventory problem. When DSO rises, it signals a collections problem.

The two require different diagnoses and different fixes, which is why knowing which metric you are looking at matters before drawing any conclusions.

Once that distinction is clear, we can move on to accurately calculating DIO from your financial statements.

How to calculate and report days inventory outstanding

The DIO formula uses three inputs pulled directly from your financial statements. Once each number is in place, the calculation itself takes about a minute.

1. Identify the components

DIO uses three variables, and pulling each from the right source is more important than the math itself:

• Average inventory: Add beginning inventory and ending inventory for the period, then divide by two. This number comes from the balance sheet.
• COGS: Pull cost of goods sold from the income statement, where it sits below revenue and above gross profit.
• Number of days: Use 365 for annual, 90 for quarterly, or 30 for monthly periods.

Using average inventory rather than just the ending balance mitigates distortions caused by seasonal swings or the timing of large purchases. One common mistake is plugging revenue into the formula instead of COGS.

Revenue includes markup, while inventory is recorded at cost, so mixing the two produces an artificially low DIO. If a company is a manufacturer, its average inventory should include raw materials, work in progress and finished goods.

2. Apply the formula

The primary DIO formula is:

• DIO = (Average Inventory / COGS) × 365

Where Average Inventory = (Beginning Inventory + Ending Inventory) / 2

If the inventory turnover ratio (COGS / Average Inventory) is already available, there is a shortcut: DIO = 365 / Inventory Turnover Ratio. Both approaches produce the same result. For quarterly analysis, swap 365 for 90 and use that quarter's COGS, because the time period must match the COGS figure. Mixing annual COGS with 90 days produces a nonsensical output.

3. Walk through a worked example

Imagine a retail business has $50,000 in beginning inventory, $70,000 in ending inventory, and $500,000 in annual COGS.

First, calculate average inventory: ($50,000 + $70,000) / 2 = $60,000.

Then divide by COGS: $60,000 / $500,000 = 0.12. Multiply by 365: 0.12 × 365 = 43.8 days.

This retailer takes approximately 44 days to sell through its inventory. To estimate how much cash is frozen at any given time, multiply daily COGS ($500,000 / 365 ≈ $1,370) by DIO (44), which gives roughly $60,000 tied up in unsold goods.

For a quarterly view, the same retailer with $55,000 in average inventory and $130,000 in Q1 COGS would calculate: ($55,000 / $130,000) × 90 = 38.1 days. Quarterly calculations can reveal seasonal patterns that annual figures smooth over, which is why many teams track DIO monthly or quarterly.

4. Interpret your DIO result

A good DIO depends on the industry and the kind of inventory a company carries. A perishable goods company turning inventory in 8 days and a specialty equipment manufacturer carrying 90 days of stock are both functioning normally for their respective businesses.

Comparing across sectors produces misleading benchmarks. Tracking DIO against your own historical trend and against direct competitors gives a much more useful signal.

Here are a few patterns worth monitoring closely:

• Rising DIO, flat or declining sales: Inventory is accumulating faster than demand, pointing to a purchasing cadence problem: the company is buying more than it is selling.
• Falling DIO, increasing stockouts: Safety stock may have been cut too deeply, improving the metric while hurting service levels and customer experience.
• One-quarter spike: May be seasonal, but compare it against the same period from the prior year before dismissing it. A spike that recurs in the same quarter warrants a structural review.

Those patterns are most useful when they trigger an operational review rather than merely explaining the number. Once you have a clear read on where your DIO stands and why, the next step is reducing it.

How to improve days inventory outstanding

Every improvement works by reducing average inventory without reducing COGS, which would mean lower sales. The goal is to hold less stock while still meeting customer demand. We cover the four most effective levers below.

Connect inventory to real-time spend data

Finance managers tracking inventory in weekly spreadsheets make purchasing decisions on data that is already out of date. By the time overstock shows up in a report, the buying that caused it happened weeks earlier. Moving to a platform that connects live stock movement to purchasing decisions removes most of that lag.

When evaluating systems, look for tools that automatically sync receiving, sales, and purchasing records, integrate directly with your accounting software, and surface spend patterns tied to specific vendors or SKUs.

Those features let your procurement team see overstock buildup before it locks up working capital, rather than after month-end close.

Liquidate slow-moving stock

Slow-moving SKUs pull overall DIO up even when the rest of the catalog turns quickly. Holding costs accumulate on goods that stopped generating revenue, compounding the working capital impact. Pull your aging report sorted by last sale date, then use targeted discounts or liquidation channels to clear the stock.

Clearing dead stock reduces average inventory in the same period your team acts, and it stops warehousing costs from building further on goods that have already stalled.

Set data-driven reorder points

Reordering based on intuition or last season's round numbers leads to over-purchasing and inflated DIO. For each SKU, multiply your average daily sales velocity by the supplier's lead time in days, then add a safety stock buffer based on demand variability.

Adjust reorder thresholds gradually rather than making large corrections all at once, since overcorrecting downward can cause stockouts that are just as costly as overstock.

Improve demand forecasting with historical data

Buying based on the previous year's round numbers or gut feel leads to both overstock and stockouts across seasons. Transaction history by product and sales channel is usually the most reliable forecast input a company already has available.

Layer in supplier lead times so purchasing quantities match what will actually sell before the next delivery arrives, and review forecast accuracy monthly by comparing projected sell-through against actual results for each product category.

Take control of your inventory spend

High DIO often occurs when inventory tracking, purchasing, and financial reporting use different data sources. When those systems do not line up, it is harder to see how much of your cash is tied up in unsold stock or where the buildup is happening, and harder to act before the problem grows.

Spend management platforms like Ramp give finance teams real-time visibility into inventory spend and vendor payments, connecting purchasing decisions to live stock data so overstock patterns surface before they drain working capital. Getting DIO down usually starts there, before changes to safety stock or supplier terms.

Frequently asked questions about days inventory outstanding

What is a good days inventory outstanding ratio?

There is no universal benchmark because a good DIO depends on the industry and the type of inventory a company carries. The most useful comparisons are against direct competitors and your own trend over time. A DIO that keeps rising without a clear operational reason is more concerning than an absolute number that looks high.

Is a high DIO good or bad?

A high DIO usually means more cash is frozen in unsold inventory, which puts pressure on working capital. There are situations where a company intentionally accepts a temporarily higher DIO, such as building stock ahead of a known supply disruption or a seasonal peak. The concern arises when DIO consistently rises without a clear operational explanation.

How does DIO relate to the cash conversion cycle?

DIO is one of three components in the cash conversion cycle formula: CCC = DIO + DSO - DPO. For most product-based businesses, DIO accounts for a large share of the total cycle because it measures how long cash remains tied up before a sale even happens. Improving DIO shortens the cycle more directly than improving DSO or extending DPO.

Can you calculate DIO for a single product line?

A company can calculate DIO for a single product line using that line's beginning and ending inventory and COGS for the period. That granularity often tells more than a company-wide figure. A furniture retailer calculating DIO by brand might find one line turns in 9 days and another in 34, which gives clearer targets for purchasing changes or markdowns than a blended average does.