Days Inventory Outstanding Calculator: Turn Stock Into Cash Decisions

Days inventory outstanding (DIO) shows how many days, on average, inventory remains tied up before it is sold. The useful result is not “lower is always better”; it is whether DIO matches replenishment risk, margin, and the selling cycle. Source

Table of Contents

• What is DIO, and what does the calculator measure?
• Which inputs belong in the formula?
• How should an ecommerce operator read the result?
• Why can a healthy company-wide DIO hide bad SKUs?
• What should you do after calculating DIO?
• FAQ

What is DIO, and what does the calculator measure?

DIO converts average inventory at cost into days by comparing it with cost of goods sold for the same period.

The standard inventory days formula is:

DIO = (Average Inventory / COGS) × Days in Period

Average inventory commonly uses:

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

The Shopify explanation of days inventory outstanding uses this same structure. A result of 60 days means the business carries inventory equivalent to roughly 60 days of cost of sales; it does not mean every item has sat untouched for exactly 60 days.

Higher DIO can reflect excess inventory, weak demand, long supplier lead times, safety stock, or seasonal preparation. Lower DIO can indicate efficient movement, but also underbuying, fragile availability, or frequent stockouts.

DIO is a starting point for investigation, not an automatic purchasing target. Read it beside gross margin, lead time, minimum order quantities, sell-through, stockout frequency, and service levels.

Which inputs belong in the formula?

Use average inventory at cost, COGS for the matching period, and the exact number of days in that period.

Consistency matters more than false precision. Inventory should be valued at cost when compared with COGS at cost. Do not compare inventory at retail value with COGS at cost. The IRS guidance on inventory accounting explains why a consistent inventory method matters.

For a monthly calculation, use beginning and ending monthly balances, monthly COGS, and the actual number of days in that month. For an annual calculation, use annual balances and COGS, with 365 days or 366 days for a leap year when appropriate.

The calculation is:

($100,000 / $730,000) × 365 = 50 days

This is an illustration, not a benchmark. Healthy DIO can differ substantially among seasonal apparel, spare parts, and fast-moving beauty products.

Use COGS rather than sales revenue because DIO measures inventory held at cost. Sales include markup, while inventory is not measured at its future selling price. Keep the period, valuation basis, and inventory scope aligned. If COGS covers the entire business but inventory covers one warehouse, the result is not an apples-to-apples operating measure. Source

How should an ecommerce operator read the result?

Read DIO against the store’s season, category, lead time, and margin—not an internet-wide “good” number.

The practical question is whether inventory supports profitable availability without trapping unnecessary cash. A result becomes useful when it changes what you inspect next.

A DIO trend is more informative than a single result. Compare equivalent periods where possible, especially for seasonal stores. Holiday buying, launches, supplier delays, and planned forward purchases can temporarily change the number. Source

Margin matters too. Aggressive discounting may release cash while destroying contribution margin. The better decision is often to reduce the right inventory, not inventory indiscriminately.

Repeated measurement by SKU and location is where inventory software helps. SellerTrove’s inventory tools can support ongoing views of stock positions, while the stack builder and report can connect operational data to decisions behind the number. These tools improve visibility; no tool guarantees lower DIO.

Why can a healthy company-wide DIO hide bad SKUs?

An aggregate can look healthy while slow variants consume cash and fast variants stock out.

Company-wide DIO is an average. Fast-moving products can offset a large pool of aging products, particularly when the fast products carry high COGS or substantial sales volume. The total may look efficient even when the assortment is unbalanced.

A store may have bestsellers that move quickly and frequently run out, alongside slow colors, sizes, or older models occupying warehouse space. The average can remain acceptable while customers miss revenue opportunities and the business carries markdown or obsolescence risk. Source

SKU-level analysis should include:

• Units sold and COGS.
• Inventory age and last-sale date.
• Stockout frequency.
• Sell-through by size, color, or variant.
• Open purchase orders and supplier commitments.
• Location-specific demand.
• Gross margin after discounts and fulfillment costs.

Category analysis can reveal the same issue. Consumables may have healthy DIO while seasonal accessories carry excessive stock. One warehouse may be lean while another holds inventory that cannot move efficiently.

Match the response to the cause. Slow inventory may need a price action, bundle, channel transfer, purchase freeze, or assortment exit. Fast inventory may need better forecasting, supplier negotiation, or a revised reorder point. One company-wide target can hide both problems.

What should you do after calculating DIO?

Segment the result by SKU, category, and location before changing purchase orders or promotions.

1. Confirm the calculation basis. Verify that inventory, COGS, period, valuation basis, and business scope match.

2. Compare with the operating calendar. Mark promotions, launches, holidays, supplier delays, and planned forward buys. Investigate unexplained increases.

3. Find the items driving the average. Rank SKUs by inventory value, age, units sold, and margin. Look for cash-heavy slow movers and low-DIO products with repeated stockouts.

4. Choose an action by cause. Pause or reduce reorders when demand is weak. Reprice or bundle viable aging stock. Transfer inventory when demand differs by location. Increase coverage only when lost sales and lead-time risk justify it.

5. Recalculate after the action. Track DIO with stockout rate, sell-through, gross margin, and aging so improved DIO does not simply move risk elsewhere.

The goal is not to force every product toward one number. A slow-moving product may be acceptable if it has strong margin, reliable demand, and a strategic role. A fast-moving product may be unhealthy if cautious replenishment repeatedly loses sales. Source

For annual analysis, DIO also cross-checks inventory turnover. As described in Days in inventory, annual DIO is approximately:

Annual DIO ≈ 365 / Inventory Turnover

Use the calculator for a baseline, then use segmented reports to decide where cash is trapped and where availability is too thin.