Lightbridge ERP A Lightbridge company
JH Written by Jully Hayasaka with Robert LabardeeNetSuite Advanced Accounting Lead and Founder and CEO

Days Inventory Outstanding (DIO): Formula and Meaning

Lightbridge ERP defines days inventory outstanding (DIO) as the average number of days a company holds inventory before selling it. DIO equals average inventory divided by cost of goods sold per day. It measures how quickly inventory converts into sales, a core driver of working capital and the cash conversion cycle.

Days inventory outstanding measures how long stock sits before it is sold.

Days inventory outstanding, almost always shortened to DIO, is the average number of days a company holds inventory before selling it. It answers a question that sits at the center of working capital: once cash has been committed to stock, how long does that stock take to convert into a sale? A lower DIO means inventory turns over quickly and cash is freed sooner. A higher DIO means cash is tied up on the shelf, and the longer stock sits, the greater the carrying cost and the obsolescence risk. The metric is also called days sales of inventory or days inventory on hand.

DIO is a measure of inventory efficiency, not profitability. A company can show healthy margins and still run short of cash if its DIO is high and stock moves slowly. That is why finance and operations leaders watch DIO together as a leading indicator of how much working capital the business must hold. Like its sibling metric, days sales outstanding, DIO is most informative read as a trend over several periods and compared against industry peers, rather than judged against any single headline number.

This guide is general financial information, not accounting, tax, or legal advice. For decisions specific to your books, consult a qualified professional.

The DIO formula is average inventory divided by cost of goods sold per day.

Calculating DIO uses three inputs: average inventory, cost of goods sold, and the number of days in the period. The mechanics are straightforward, but two details decide whether the number is reliable: using COGS rather than revenue in the denominator, and being consistent about the averaging method and the day count.

The core DIO formula

DIO equals average inventory divided by cost of goods sold, multiplied by the number of days in the period. Written out: DIO = (Average Inventory / COGS) x Days. For a full year, Days is 365, so DIO = Average Inventory / (COGS / 365). The numerator is the average inventory balance over the period, usually (beginning inventory + ending inventory) / 2.

The inventory turnover identity

DIO is the inverse of inventory turnover expressed in days. Inventory turnover equals COGS divided by average inventory, the number of times stock is sold and replaced in a period. So DIO = 365 / inventory turnover for an annual period. A higher turnover means a lower DIO and faster-moving stock. The two metrics describe the same efficiency from opposite directions.

Why the denominator is COGS, not sales

DIO uses cost of goods sold, not revenue, because inventory is carried at cost on the balance sheet. Pairing inventory at cost against sales at price would mix two bases and distort the result. Use COGS for the period that matches the inventory window, and apply the same averaging method each period so trends stay comparable.

A worked DIO example

Suppose a company carries average inventory of 200,000 dollars and reports cost of goods sold of 1,460,000 dollars for the year. COGS per day is 1,460,000 / 365 = 4,000 dollars. DIO = 200,000 / 4,000 = 50 days. The same answer comes from the turnover route: inventory turnover = 1,460,000 / 200,000 = 7.3, and 365 / 7.3 = 50 days. A 50-day DIO means stock takes roughly seven weeks to sell on average, and whether that is healthy depends entirely on the industry and the product.

A good DIO depends on the industry and the product, not a universal number.

There is no universal good DIO. Interpreting the number starts with direction. A lower DIO frees cash and reduces carrying cost and obsolescence risk, but a DIO pushed too low can signal understocking, leading to stockouts and lost sales. A higher DIO ties up more cash, yet it can be entirely normal for a business that holds long-lead, seasonal, or made-to-stock inventory. The signal that matters most is the trend: a DIO rising over consecutive periods is a warning regardless of the absolute level, because it means cash is committed to stock for longer than it used to be.

Benchmarks vary widely by industry, so cross-industry comparison is rarely meaningful. Inventory-heavy sectors such as retail, distribution, and manufacturing tend to run materially higher DIO than service or digital businesses that hold little or no stock. Perishable-goods operators aim for very low DIO out of necessity, while companies with long procurement or production lead times may carry high DIO and still operate well. The honest reference points are your own history and close industry peers, not a single headline figure presented as a standard.

Reducing DIO frees cash without raising prices or cutting spend.

Lowering DIO releases cash a business has already committed to stock. The work splits into buying and making less of what does not sell, and moving faster on what does. Most durable gains come from planning and system design rather than from one-time stock clearances, though clearing aged inventory is a useful reset.

Sharpen demand planning

Most excess inventory traces back to forecasts that ran ahead of real demand. Tighter demand planning, informed by actual sell-through rather than optimism, keeps purchase and production volumes aligned with what the market absorbs. Better forecasts shrink the buffer a business must carry, which lowers DIO at the source rather than after stock has already aged.

Discipline safety stock and replenishment

Safety stock protects service levels, but carrying more than the demand variability requires turns into a permanent cash drag. Right-sizing safety stock per item and replenishing in smaller, faster cycles keeps less capital sitting on shelves. Faster, more frequent replenishment lowers average inventory without raising stockout risk when lead times are reliable.

Clear dead stock and rationalize SKUs

Slow-moving and dead stock inflate DIO and tie up cash with little prospect of sale. A standing process to identify, discount, or write down aged inventory keeps the number honest. SKU rationalization, retiring low-velocity items that dilute focus, reduces complexity and concentrates working capital on stock that actually turns.

The planning and replenishment workflow that drives DIO is configured inside the ERP. How NetSuite handles stock control, replenishment, and demand planning is covered in the NetSuite inventory management guide, but the lever itself, accurate demand-driven inventory, is platform-neutral. Lightbridge ERP designs that workflow on whichever platform fits.

DIO is one of the three drivers of the cash conversion cycle.

DIO does not work alone. It is one of three metrics that combine into the cash conversion cycle, the number of days cash stays locked in operations before it returns. Days inventory outstanding is typically the first leg, the time stock sits before it can be sold, and for inventory-heavy businesses it is often the largest single contributor to the cycle. It joins days sales outstanding (the collection leg) and days payable outstanding (the supplier-credit leg). A lower DIO shortens the cash conversion cycle directly and frees working capital.

We do not re-derive the full formula here. For how the three days metrics combine, including why days payable outstanding is subtracted, and for a worked cash conversion cycle calculation, see the cash conversion cycle guide. That page owns the full CCC formula; this page goes deep on DIO specifically.

Real-time ERP inventory visibility turns DIO from a report into a managed outcome.

A high DIO is usually a symptom of how inventory and procurement were designed, not a failure of effort. DIO is only as useful as the data behind it, and when stock lives in disconnected spreadsheets and point tools, aging inventory surfaces late and the inputs rarely agree. A modern ERP system records every inventory movement once and surfaces stock on hand, aging, and turns against the same general ledger, so finance and operations see slow-moving items in real time rather than at the next physical count.

That visibility is what makes the levers measurable: demand planning informed by actual sell-through, safety stock right-sized per item, and dead stock flagged before it becomes a write-down. Lightbridge ERP is an independent, vendor-neutral ERP advisory firm with in-house NetSuite and FP&A delivery, and because it accepts no vendor kickbacks, no reseller quotas, and no partner-tier incentives, any platform or process recommendation is driven by fit rather than commission. For organizations that want inventory metrics to actually move, ERP consulting and a structured look at the inventory and procurement process are the right starting point.

Days inventory outstanding: frequently asked questions

What is days inventory outstanding (DIO)?
Days inventory outstanding (DIO) is the average number of days a company holds inventory before it is sold. It is a working-capital metric that shows how efficiently a business converts stock into sales. A lower DIO means inventory moves quickly and less cash is tied up on the shelf; a higher DIO means cash is locked in stock for longer, which also raises the risk of obsolescence. DIO is most useful tracked as a trend over time and compared against industry peers, rather than read as a single absolute number. It is also called days sales of inventory or days inventory on hand.
How do you calculate DIO?
To calculate DIO, divide average inventory by cost of goods sold, then multiply by the number of days in the period. The formula is DIO = (Average Inventory / COGS) x Days, or equivalently Average Inventory / (COGS / 365) for a year. Average inventory is usually (beginning inventory + ending inventory) / 2. For example, average inventory of 200,000 dollars on annual COGS of 1,460,000 dollars gives COGS per day of 4,000 dollars, so DIO = 200,000 / 4,000 = 50 days. Equivalently, DIO = 365 / inventory turnover, where inventory turnover equals COGS divided by average inventory.
What does a high or low DIO mean?
A lower DIO means inventory converts to sales faster and less cash is tied up in stock, which is generally favorable for cash flow. A higher DIO means more cash is locked in inventory and the business faces greater carrying cost and obsolescence risk. But neither extreme is automatically good or bad. A DIO that is too low can signal understocking and lost sales from stockouts, while a high DIO can be normal for businesses that hold long-lead or seasonal inventory. The right read is directional: a DIO rising over consecutive periods warrants investigation regardless of the absolute level.
What is the difference between DIO and inventory turnover?
DIO and inventory turnover measure the same inventory efficiency from opposite directions. Inventory turnover counts how many times a company sells and replaces its average inventory in a period: COGS divided by average inventory. DIO converts that into a number of days: DIO = 365 / inventory turnover for an annual period. A higher turnover corresponds to a lower DIO and faster-moving stock. Turnover is convenient for ratio analysis, while DIO is intuitive because it is expressed in days, which makes it easy to compare against lead times and reorder cycles.
What is a good DIO?
A good DIO varies widely by industry, so there is no universal target number. Inventory-heavy sectors such as retail, distribution, and manufacturing tend to carry meaningfully higher DIO than service or digital businesses that hold little or no stock. Perishable-goods businesses aim for very low DIO out of necessity, while companies with long production or procurement lead times may run high DIO and still operate well. The honest benchmark is relative: compare your DIO to your own trend over time and to close industry peers, not to a single headline figure.
How can a company reduce DIO?
A company reduces DIO by holding less inventory for the same level of sales, without starving fulfillment. Practical levers include sharper demand planning so purchasing matches real sell-through, right-sized safety stock per item, faster and more frequent replenishment, and a standing process to discount or write down dead and slow-moving stock. SKU rationalization removes low-velocity items that dilute working capital. Real-time inventory visibility in an ERP system makes these moves measurable, surfacing aging stock before it becomes a cash drag rather than after a quarterly count.
How is DIO related to the cash conversion cycle?
DIO is one of the three components of the cash conversion cycle (CCC), which measures how long cash is locked in operations before it returns. The cash conversion cycle adds days inventory outstanding and days sales outstanding, then subtracts days payable outstanding. DIO is typically the first and often the largest leg for inventory-heavy businesses, because stock sits before it can be sold and then collected. A lower DIO shortens the cash conversion cycle and frees working capital. The dedicated cash conversion cycle guide explains how the three days metrics combine.
How does Lightbridge ERP use DIO in finance transformation?
Lightbridge ERP treats DIO as a measurable outcome of how inventory and procurement are designed in an ERP, not just a number on a dashboard. As an independent, vendor-neutral advisor with in-house NetSuite and FP&A delivery, Lightbridge maps where stock ages, tightens demand planning and replenishment, and builds the inventory and cash conversion cycle reporting that finance leaders use to manage working capital. The goal is faster inventory turns and freed cash. Lightbridge accepts no vendor kickbacks, so any platform or process recommendation is driven by fit rather than commission.

From measuring DIO to moving it.

When the question shifts from what DIO is to how to bring it down, Lightbridge ERP redesigns the inventory and procurement process and the reporting behind it, on whichever platform fits your business.