MarginLab free inventory tool

Calculate your Days Inventory Outstanding.

Calculate how many days your inventory remains in stock before it is sold. Measure inventory efficiency, identify slow-moving stock and understand how much working capital may be tied up in products.

Your inventory numbers

Currency

Beginning Inventory

Enter the total inventory value at the beginning of the selected period.

Ending Inventory

Enter the total inventory value at the end of the selected period.

Cost of Goods Sold

Use COGS for the same accounting period as your inventory values.

Number of Days in Period

Use 365 for a year, 90 for a quarter or the exact number of days in your reporting period.

Days Inventory Outstanding 0days

Enter numbers

Average Inventory $0.00

↻

Inventory Turnover 0×

Daily COGS $0.00

Inventory / COGS 0%

AI Inventory Analysis

Enter your inventory values, COGS and reporting period to receive an instant inventory efficiency analysis.

AI Inventory Score —

Inventory Health —

Best Opportunity —

Capital Efficiency —

Overstock Risk —

Inventory should support profit, not trap cash.

MarginLab helps Shopify merchants connect inventory decisions with product costs, sales, discounts, refunds and real product-level profitability.

Start Free Trial →

How to use this Days Inventory Outstanding Calculator

Enter your beginning inventory, ending inventory, Cost of Goods Sold (COGS) and the number of days in the reporting period. The calculator instantly calculates your Days Inventory Outstanding (DIO), helping you understand how long inventory remains in stock before it is sold.

1. Enter inventory values

Provide your beginning inventory and ending inventory values for the selected reporting period.

2. Add COGS and period

Enter your Cost of Goods Sold and specify the number of days in the reporting period, such as 365 or 90 days.

3. Evaluate inventory efficiency

Review your DIO, inventory turnover and AI insights to identify opportunities to improve cash flow and inventory management.

Days Inventory Outstanding formula explained

Days Inventory Outstanding measures the average number of days inventory remains in stock before it is sold. It compares average inventory value with Cost of Goods Sold over a specific reporting period.

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

How to calculate average inventory

Average inventory is calculated by adding beginning inventory and ending inventory, then dividing the result by two:

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

Example calculation

If beginning inventory is $45,000, ending inventory is $55,000, annual COGS is $300,000, and the period contains 365 days:

Average Inventory = ($45,000 + $55,000) ÷ 2 = $50,000

DIO = ($50,000 ÷ $300,000) × 365 = 60.8 days

How to interpret your Days Inventory Outstanding

Days Inventory Outstanding (DIO) indicates how long inventory remains in stock before it is sold. A lower DIO generally means inventory moves quickly, while a higher DIO may indicate excess stock or slower sales. The ideal value depends on your industry, products and business model.

Low DIO (Under 30 Days)

Inventory is selling quickly and working capital is being used efficiently. Monitor stock levels carefully to avoid stockouts that could reduce revenue.

Healthy DIO (30–60 Days)

For many ecommerce businesses this represents a balanced inventory position, combining good product availability with efficient cash flow management.

Moderate DIO (60–90 Days)

Inventory turnover is slowing. Review purchasing quantities, seasonal demand and slow-moving products before inventory levels continue to increase.

High DIO (Over 90 Days)

A high DIO can indicate overstocking, weak demand or purchasing inefficiencies. Inventory may consume cash that could otherwise be invested in marketing, growth or faster-selling products.

Review DIO regularly as sales patterns and purchasing cycles change.
Compare DIO across product categories instead of relying only on a store-wide average.
Track DIO together with Inventory Turnover for a more complete view of inventory performance.
MarginLab combines inventory metrics with profitability to identify products that generate profit—not just sales.

Common Days Inventory Outstanding mistakes

Days Inventory Outstanding is a valuable inventory metric, but it must be calculated and interpreted correctly. These are some of the most common mistakes businesses make when analyzing DIO.

Using inconsistent reporting periods

Beginning inventory, ending inventory and Cost of Goods Sold must all refer to the same reporting period. Mixing monthly inventory with annual COGS produces misleading DIO values.

Looking only at the company average

A single DIO value can hide important differences between products. Analyze categories or individual SKUs to identify slow-moving inventory that requires action.

Ignoring seasonality

Many ecommerce businesses intentionally build inventory before peak sales periods. Temporary increases in DIO are not necessarily a problem if they support expected demand.

Focusing on inventory instead of profitability

A low DIO does not automatically mean a product is profitable. Combine inventory metrics with gross margin and product profitability to make better purchasing decisions.

Why Days Inventory Outstanding alone isn’t enough

Days Inventory Outstanding shows how long inventory remains in stock, but it does not explain whether that inventory is generating healthy profit or consuming working capital without sufficient return.

What DIO doesn’t show

A store-wide DIO result cannot reveal the complete financial performance of individual products.

Gross profit generated by each product
Products selling quickly but at weak margins
Inventory value tied up in unprofitable items
The impact of discounts and refunds
Which products deserve additional investment

How MarginLab helps

MarginLab connects Shopify sales and inventory activity with product costs, discounts, refunds and margins. This makes it easier to identify products that move efficiently, products that generate healthy profit and products that may be trapping cash.

Analyze profitability at product level
Identify slow-moving and low-margin products
Prioritize profitable replenishment decisions
Monitor margin deterioration over time
Find realistic profit recovery opportunities

A Days Inventory Outstanding Calculator shows how long your inventory remains in stock. MarginLab helps you understand whether that inventory is worth funding.

Related inventory calculators

Continue improving your inventory management with these free calculators for ecommerce businesses, Shopify merchants and inventory planning.

Inventory Turnover Calculator Measure how often your inventory is sold and replenished during a specific period. Economic Order Quantity Calculator Calculate the optimal order quantity that minimizes purchasing and inventory holding costs. Reorder Point Calculator Determine exactly when you should reorder inventory to avoid stock shortages. Safety Stock Calculator Estimate the inventory buffer needed to reduce the risk of stockouts caused by demand or supplier variability. Sell-Through Rate Calculator Analyze how efficiently inventory is converted into sales over a selected period. Shopify Profit Calculator Calculate your real Shopify profit after product costs, fees and operating expenses.

Days Inventory Outstanding Calculator FAQs

Find answers to common questions about DIO, average inventory, Cost of Goods Sold and inventory efficiency.

What is Days Inventory Outstanding?

Days Inventory Outstanding, or DIO, measures the average number of days a business holds inventory before selling it. It is also commonly called Days Sales of Inventory or inventory days.

How do you calculate Days Inventory Outstanding?

Use the formula: DIO = (Average Inventory ÷ Cost of Goods Sold) × Number of Days. Average inventory is usually calculated by adding beginning and ending inventory, then dividing by two.

What is a good Days Inventory Outstanding?

There is no universal ideal DIO because inventory cycles vary by industry and product type. A lower result generally indicates faster inventory movement, while a higher result may indicate slow-moving or excess stock. The most useful comparison is against your historical performance and similar businesses.

Is a low DIO always better?

Not necessarily. A low DIO can indicate efficient inventory management, but it may also mean the business is carrying too little stock and risks running out of popular products. DIO should be evaluated together with availability, supplier lead times and demand stability.

What does a high DIO mean?

A high DIO means inventory remains unsold for a longer period. This may indicate overstocking, weak demand, poor purchasing decisions or seasonal inventory accumulation. It can also increase storage costs and tie up working capital.

What is the difference between DIO and inventory turnover?

DIO expresses inventory efficiency as the average number of days products remain in stock. Inventory turnover expresses how many times inventory is sold and replaced during a period. They describe the same underlying activity from different perspectives.

Should I calculate DIO monthly or annually?

You can calculate DIO for any consistent reporting period. Use 365 days for annual analysis, approximately 90 days for a quarter or the exact number of days in a monthly reporting period. Beginning inventory, ending inventory and COGS must cover the same period.

How can Shopify merchants improve DIO?

Shopify merchants can improve DIO by reducing purchase quantities for slow-moving products, improving demand forecasting, creating targeted promotions and prioritizing faster-selling inventory. MarginLab adds product-level profitability data so these decisions are based on profit as well as sales speed.

📦 TURN INVENTORY SPEED INTO REAL PROFIT

DIO measures inventory speed.
Real inventory profitability is better.

This calculator helps you understand how long inventory remains in stock. MarginLab helps Shopify merchants connect inventory performance with product costs, margins, discounts and refunds across the entire store. Instead of measuring inventory days alone, you can understand which products use capital efficiently and which ones may be trapping cash.

Product-Level Profitability

See which products generate healthy profit and which products weaken margins despite continuing to sell.

Inventory Capital Visibility

Understand where cash may be tied up in slow-moving, low-margin or underperforming inventory.

Continuous Margin Monitoring

Move beyond one-time DIO calculations and monitor profitability changes across your Shopify store.