Your business has $20,000 invested in inventory. Products continue selling, but how long does that money typically remain tied up in stock?
An annual inventory turnover ratio of four tells you how frequently inventory moves relative to its average value. However, it doesn’t immediately show the result in days.
Inventory turnover in days converts that ratio into a more familiar measurement. It estimates how many days of inventory a business holds on average.
For ecommerce sellers, this metric can reveal purchasing inefficiencies, slow stock movement, and opportunities to improve working capital.
In this guide, you’ll learn how to calculate inventory days, interpret the results, and use the information to make better purchasing decisions.
What Does Inventory Turnover in Days Mean?
Inventory turnover in days measures the average amount of time inventory remains on hand relative to the cost of goods sold.
The metric is also known as:
- Days Inventory Outstanding (DIO)
- Days Sales of Inventory (DSI)
- Inventory Holding Period
- Inventory Days
These terms are commonly used in inventory and financial analysis.
For example, a DIO of 60 days suggests that a business holds approximately 60 days of inventory on average.
However, this doesn’t mean every product takes exactly 60 days to sell.
Instead, the calculation provides an overall estimate based on inventory values and the cost of goods sold.
Understanding the DIO Formula
There are two common methods for calculating inventory days.
Method 1: Using the Turnover Ratio
Inventory Days = Days in Period ÷ Inventory Turnover Ratio
For an annual calculation:
Inventory Days = 365 ÷ Inventory Turnover Ratio
Suppose a business has an annual turnover ratio of 5.
365 ÷ 5 = 73 days
Therefore, the estimated inventory holding period is 73 days.
Method 2: Using Average Inventory
You can also calculate the result directly from inventory values.
DIO = (Average Inventory ÷ Cost of Goods Sold) × Days in Period
First, calculate average inventory:
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
Both methods produce the same result when consistent figures are used.
However, the inventory values and COGS must refer to the same reporting period.
Step-by-Step Calculation Example
Consider an ecommerce business selling glass bottles and cosmetic packaging.
Its annual financial records show:
| Financial Data | Amount |
|---|---|
| Beginning Inventory | $15,000 |
| Ending Inventory | $25,000 |
| Annual COGS | $100,000 |
| Reporting Period | 365 days |
Step 1: Find Average Inventory
Add the beginning and ending inventory values.
$15,000 + $25,000 = $40,000
Next, divide the result by two.
$40,000 ÷ 2 = $20,000
Step 2: Calculate the Turnover Ratio
Divide annual COGS by average inventory.
$100,000 ÷ $20,000 = 5 times
The business has an annual inventory turnover ratio of 5.
Step 3: Convert the Result Into Days
Divide the number of days in the reporting period by the turnover ratio.
365 ÷ 5 = 73 days
Therefore, the business holds approximately 73 days of inventory on average.
This means its average inventory investment represents about 73 days of COGS.
Comparing Inventory Holding Periods
Different businesses may report different inventory holding periods, even when their annual COGS is identical.
Consider three businesses with annual COGS of $120,000.
| Business | Average Inventory | Turnover Ratio | Inventory Days |
|---|---|---|---|
| Business A | $10,000 | 12 | 30.4 |
| Business B | $20,000 | 6 | 60.8 |
| Business C | $40,000 | 3 | 121.7 |
Business A holds approximately 30 days of inventory.
Meanwhile, Business C holds about 122 days.
Although Business A moves inventory faster, this doesn’t automatically mean its inventory management is better.
For example, a business selling specialized equipment may naturally maintain longer inventory cycles than a retailer selling everyday consumables.
Therefore, the results should be interpreted within the relevant business context.
How to Interpret High and Low DIO
Understanding inventory days requires more than comparing numbers.
When Inventory Days Are Low
A lower DIO generally indicates faster inventory movement relative to COGS.
Potential advantages include reduced storage requirements and less working capital tied up in stock.
However, maintaining very little inventory may increase the risk of stockouts.
For example, a retailer holding only 10 days of inventory could face problems if suppliers require 30 days to deliver replacement products.
When Inventory Days Are High
A higher DIO suggests that inventory remains on hand longer relative to COGS.
Possible causes include:
- Slow-moving products
- Excessive purchasing quantities
- Declining customer demand
- Seasonal inventory accumulation
- Long replenishment cycles
Nevertheless, a longer holding period isn’t always a problem.
Some products require additional inventory coverage because of supplier limitations or unpredictable demand.
When DIO Increases Over Time
Suppose a business records these results:
| Year | Inventory Days |
|---|---|
| Year 1 | 45 |
| Year 2 | 60 |
| Year 3 | 85 |
The increasing figures suggest that inventory is moving more slowly relative to COGS.
However, the change may result from higher quantities, changes in unit costs, or weaker sales.
Therefore, investigate the underlying factors before adjusting purchasing decisions.
What Is a Good Inventory Holding Period?
There isn’t one ideal number for every business.
For example, grocery retailers often operate with relatively short inventory cycles.
Meanwhile, companies selling industrial equipment may hold inventory for longer periods.
A useful evaluation considers:
- Historical inventory performance
- Supplier lead times
- Seasonal demand patterns
- Product availability requirements
- Comparable businesses or product categories
Rather than targeting an arbitrary benchmark, businesses should evaluate whether inventory levels support their operational needs.
DIO vs. Inventory Turnover Ratio
Both metrics describe inventory efficiency, but they use different measurements.
| Metric | Measurement | Example |
|---|---|---|
| Inventory Turnover Ratio | Number of inventory turns | 5 times annually |
| Days Inventory Outstanding | Estimated inventory holding period | 73 days |
| Higher Value Means | Generally faster movement | Generally slower movement |
The relationship works in opposite directions.
When the turnover ratio increases, inventory days decrease.
Conversely, when the turnover ratio decreases, inventory days increase.
However, neither metric directly measures profitability or the exact age of individual products.
Calculate Inventory Days in Excel
Excel and Google Sheets can automate these calculations.
Start by creating the following table:
| Cell | Description | Example |
|---|---|---|
| B2 | Beginning Inventory | 15000 |
| B3 | Ending Inventory | 25000 |
| B4 | Cost of Goods Sold | 100000 |
| B5 | Days in Period | 365 |
Average Inventory
Enter this formula in B6:
=AVERAGE(B2:B3)Turnover Ratio
Next, enter this formula in B7:
=IFERROR(B4/B6,"")Days Inventory Outstanding
Finally, enter this formula in B8:
=IFERROR(B5/B7,"")The result is 73 days.
For quarterly calculations, replace 365 with the actual number of days in that quarter.
Additionally, use quarterly COGS rather than annual figures.
For seasonal businesses, averaging more frequent inventory balances may produce a more representative result.
Practical Ways to Reduce Inventory Days
Reducing inventory days requires balancing stock movement with product availability.
Improve Demand Forecasting
Review historical sales and identify recurring demand patterns.
Better forecasts can help prevent unnecessary purchasing.
However, historical sales should be adjusted when stockouts have limited recorded demand.
Reduce Excess Stock
Identify products with unusually high stock coverage.
Then, evaluate discounts, bundles, or alternative sales channels.
Before launching promotions, calculate the expected impact on margins.
Review Purchase Quantities
Large orders can increase inventory holding periods when demand doesn’t justify the additional stock.
Therefore, compare supplier discounts with storage costs and expected sales.
Improve Product Visibility
For ecommerce businesses, product listings can influence sales performance.
Review titles, photographs, descriptions, and pricing.
Clear product information may help customers make purchasing decisions.
Monitor Stock Performance Regularly
Calculate DIO monthly or quarterly using consistent reporting periods.
Additionally, review results by product category when reliable cost data is available.
This can reveal slow-moving inventory hidden within company-wide averages.
Why Inventory Days Matter for Working Capital
Inventory represents money invested in products that haven’t yet been sold.
Consequently, longer holding periods can increase working capital requirements.
For example, a business holding 120 days of inventory generally requires more inventory investment than a comparable business holding 60 days, assuming similar daily COGS and inventory costs.
However, reducing stock too aggressively may cause fulfillment problems.
The objective is to maintain enough inventory to support sales without tying up unnecessary capital.
Common Calculation Mistakes
Several mistakes can make inventory-days analysis unreliable.
Using sales revenue instead of COGS: The standard calculation uses inventory costs.
Mixing reporting periods: Annual COGS should not be combined with quarterly inventory averages.
Ignoring seasonal changes: Beginning and ending balances may not represent typical stock levels.
Using inaccurate inventory values: Incorrect quantities or costs distort the result.
Treating DIO as exact product age: Inventory days is an aggregate estimate, not a measurement of how long each SKU has been stored.
Therefore, businesses should review the underlying data before making operational decisions.
Final Thoughts
Days Inventory Outstanding helps businesses understand how long inventory investment remains tied up in stock.
By converting inventory turnover into days, companies can compare stock movement with purchasing cycles, supplier lead times, and working capital requirements.
However, the result should be interpreted alongside demand patterns, margins, and product availability.
For ecommerce businesses, regular inventory-days analysis can support more informed purchasing decisions.
The goal isn’t simply to reduce the number of days inventory remains on hand. It’s to maintain the right balance between efficient stock movement and reliable product availability.