Days Sales in Inventory Calculator

Use this calculator to estimate how many days your inventory sits on hand before being sold. Essential for inventory management, cash flow planning, identifying slow-moving stock, and benchmarking supply chain efficiency.

What this calculator does

The days sales in inventory calculator helps you measure how long, on average, your inventory remains unsold before being converted into revenue.

It uses:

• average inventory value
• cost of goods sold

This gives you DSI - days sales in inventory - a key efficiency metric for any product-based business managing stock levels and working capital.

How to use the days sales in inventory calculator

1. Enter your average inventory - the average value of inventory held during the period, typically calculated as opening inventory plus closing inventory divided by two
2. Enter your cost of goods sold - the total cost of goods sold during the same period
3. The calculator instantly shows your days sales in inventory

Make sure both figures cover the same time period for an accurate result - typically a full financial year or a consistent quarter.

Days Sales in Inventory Formula

Days Sales in Inventory = (Average Inventory / Cost of Goods Sold) x 365

Where:

• Average Inventory = average inventory value during the period
• Cost of Goods Sold = total cost of goods sold in the same period
• 365 = days in a year
• DSI = average number of days inventory remains unsold

Example calculation

If:

• Average inventory = 50,000
• Cost of goods sold = 250,000

Then:

• DSI = (50,000 / 250,000) x 365
• DSI = 0.20 x 365
• DSI = 73 days

On average, inventory sits on hand for 73 days before being sold. Whether that is efficient depends on the product category, supply chain lead times, and industry benchmarks.

What is days sales in inventory?

Days sales in inventory - also known as days inventory outstanding or DIO - is a metric that measures the average number of days a business holds inventory before selling it. It represents the time inventory is tied up as working capital before converting into revenue.

A lower DSI means inventory moves quickly - the business sells stock faster and requires less capital tied up in unsold goods. A higher DSI means inventory moves slowly - which may indicate overstocking, slow-moving products, or supply chain inefficiencies.

What is a good days sales in inventory figure?

Benchmarks vary significantly by industry and product type:

• Grocery and fast-moving consumer goods - typically 5 to 20 days
• Fashion and apparel - typically 30 to 90 days
• Electronics - typically 20 to 60 days
• Industrial and manufacturing - typically 60 to 120 days
• Luxury goods - often 90 to 180 days or more

A DSI that is declining over time indicates improving inventory efficiency. A rising DSI may signal accumulating excess stock, slowing sales, or supply chain issues that need attention.

Why days sales in inventory matters for business efficiency

Tracking DSI helps you:

• measure how efficiently inventory is converting into sales and revenue
• identify slow-moving stock categories that are tying up working capital
• benchmark inventory performance across different periods, product lines, or suppliers
• improve cash flow by reducing the time capital is locked up in unsold stock
• plan reorder quantities and timing more accurately based on actual sales velocity

The relationship between DSI and working capital

Inventory sitting on shelves represents cash that has already been spent but not yet recovered through sales. The longer inventory sits - the higher the DSI - the more working capital is tied up in unsold stock.

Reducing DSI frees up working capital that can be used for other purposes - paying suppliers, investing in growth, or reducing debt. A 10-day reduction in DSI can release significant cash depending on the scale of inventory investment.

How to reduce days sales in inventory

Practical strategies for improving inventory turnover and reducing DSI:

• Improve demand forecasting - more accurate forecasting reduces over-ordering and prevents excess stock accumulation
• Implement just-in-time ordering - order closer to when stock is needed rather than maintaining large safety buffers
• Identify and act on slow-moving SKUs - run promotions, bundle, or discontinue products with persistently high DSI
• Negotiate shorter lead times with suppliers - faster replenishment allows lower safety stock levels
• Use inventory management software - better visibility into stock levels and sales velocity enables more precise reorder decisions

When to use this calculator

Use this calculator when you want to:

• review inventory efficiency at the end of a quarter or financial year
• identify whether inventory is accumulating faster than it is being sold
• benchmark DSI against industry averages or prior periods
• calculate DSI as an input into cash conversion cycle analysis
• assess the working capital impact of current inventory levels

Common mistakes when calculating days sales in inventory

Common mistakes include:

• using end-of-period inventory rather than average inventory - end-of-period figures can be distorted by seasonal peaks or troughs
• using revenue instead of cost of goods sold - DSI should be calculated on cost, not selling price
• comparing DSI across very different product categories without adjusting for category-specific norms
• ignoring seasonal patterns - DSI naturally fluctuates through the year for seasonal businesses and should be compared to the same period in prior years

Days sales in inventory vs inventory turnover

These two metrics measure inventory efficiency from different perspectives and are mathematically related.

• Days sales in inventory expresses efficiency in days - how long inventory sits before selling
• Inventory turnover expresses efficiency as a ratio - how many times inventory is sold and replaced in a period

DSI = 365 / Inventory Turnover. A business with an inventory turnover of 5 has a DSI of 73 days. Use the Inventory Turnover Calculator alongside this one for a complete view of inventory efficiency.

Days sales in inventory vs reorder point

These metrics serve different operational purposes.

• DSI measures how long current inventory lasts - a backward-looking efficiency measure
• Reorder point determines when to place the next order - a forward-looking operational trigger

Use the Reorder Point Calculator to set reorder triggers based on your DSI and lead time data.

Related calculations

Once you know your days sales in inventory, you may also want to:

• Use the Inventory Turnover Calculator for the ratio-based equivalent of DSI
• Use the Inventory Carrying Cost Calculator to quantify the cost of holding inventory over time
• Use the Reorder Point Calculator to set optimal reorder triggers based on sales velocity
• Use the Safety Stock Calculator to calculate appropriate buffer stock levels

Useful resources

• Shopify - ecommerce platform with built-in inventory tracking and sales velocity reporting
• QuickBooks - accounting software with inventory cost tracking and COGS reporting for DSI calculation
• Cin7 - inventory management software with DSI and turnover analysis across multiple locations and channels
• Linnworks - multi-channel inventory management platform with stock efficiency and performance reporting

FAQs

What is days sales in inventory?

Days sales in inventory - DSI - measures the average number of days inventory remains on hand before being sold. It is a key efficiency metric for any business managing physical stock.

How do you calculate days sales in inventory?

DSI = (Average Inventory / Cost of Goods Sold) x 365.

What is a good DSI?

It depends heavily on the product category. Grocery businesses aim for under 20 days. Fashion businesses often see 30 to 90 days. Industrial businesses may see 60 to 120 days. The most useful benchmark is your own historical DSI trend.

Why use cost of goods sold rather than revenue?

Cost of goods sold represents the actual cost of inventory, which matches the inventory valuation on the balance sheet. Using revenue would mix cost and selling price, producing a distorted result.

How does DSI relate to inventory turnover?

They are mathematically inverse: DSI = 365 / Inventory Turnover. A business turning inventory 5 times per year has a DSI of 73 days. Both measure the same underlying efficiency from different angles.

Can DSI be too low?

Yes. A very low DSI might indicate that inventory levels are too lean - risking stockouts, lost sales, and customer dissatisfaction. The right DSI balances efficiency with adequate stock availability.

How does DSI affect cash flow?

Higher DSI means more cash is tied up in unsold inventory for longer. Reducing DSI frees up working capital. For businesses with thin margins or high inventory values, even small DSI improvements can release meaningful cash.

How often should I calculate DSI?

Quarterly is standard for most businesses. For fast-moving product categories or businesses with seasonal demand patterns, monthly tracking gives better visibility into emerging inventory efficiency issues.

Interpreting your result

Your days sales in inventory result should always be interpreted in context:

• compare it against your historical baseline
• review it alongside the main commercial or operational drivers behind the metric
• compare it across products, channels, periods, or segments where relevant
• avoid interpreting the result in isolation without checking the underlying input values

A single period can be noisy, so trend direction over several periods is usually more useful than one standalone result.

Data quality checklist

Before acting on this result, verify:

• the inputs use the same time period and reporting basis
• one-off anomalies are identified separately from steady-state performance
• discounts, refunds, taxes, or fees are handled consistently where relevant
• the underlying values are complete enough to support a meaningful conclusion

Small input inconsistencies can materially change the result.

How to improve this metric

Practical ways to improve this metric depend on the underlying business model, but often include:

• identify the main driver behind the result before making changes
• test one variable at a time so the impact is easier to measure
• compare performance by segment rather than only at an overall level
• review the metric regularly so changes can be caught early

Improvement is most reliable when measurement definitions remain stable over time.

Benchmarks and target setting

A good target depends on your industry, business model, and stage of growth.

When setting targets:

• compare against your own historical trend before relying on outside benchmarks
• define both minimum acceptable and aspirational target ranges
• review targets whenever pricing, cost, demand, or channel mix changes materially
• pair benchmark review with the underlying commercial context, not just the final number

Your own historical performance is usually the most practical benchmark.

Reporting cadence and decision workflow

For most teams, a simple cadence works best:

• Weekly: monitor the metric when trading conditions or campaign activity change quickly
• Monthly: compare the result against target and prior periods
• Quarterly: reassess assumptions, targets, and the main drivers behind the metric

A practical workflow is to calculate the metric, identify the primary driver of change, test one improvement, and then review the next comparable period before scaling.

Common analysis scenarios

You can use this metric in several practical scenarios:

• monthly performance reviews
• pricing, margin, or cost analysis
• planning and forecasting discussions
• investor, lender, or management reporting

In each scenario, pair the result with the underlying business context so decisions are not made on one number alone.

FAQ extensions

Should I compare this metric across channels?

Yes, but only when definitions and attribution rules are consistent.

How many periods should I review before making changes?

At least 3 comparable periods is a good baseline unless there is a clear data issue or one-off event.

What should I do if this metric improves but profit declines?

Check whether costs, discounts, conversion quality, or downstream profitability changed at the same time.