Days sales in inventory calculator
Enter your inventory value and cost of goods sold. You'll get how many days your inventory lasts, and how often it turns over.
76 days of inventory
At this pace your average inventory lasts about 76 days, or 2.5 months.
- Average inventory
- $20,000
- Inventory turnover
- 4.8 times
- Days sales in inventory
- 76 days
($18,000 + $22,000) ÷ 2 ÷ $96,000 × 365 = 76
Days sales in inventory (DSI) = average inventory ÷ cost of goods sold × days in the period. With $20,000 of stock on average and $96,000 of goods sold in a year, DSI is 76: your stock would last about 76 days at your current pace.
How the calculator works
Average inventory
(Inventory at the start + inventory at the end) ÷ 2, both valued at cost.
Days sales in inventory
Average inventory ÷ cost of goods sold × days in the period.
Inventory turnover
Cost of goods sold ÷ average inventory. DSI and turnover are the same idea: days in the period ÷ turnover = DSI. Inventory turnover calculator
Questions
What is days sales in inventory?
Days sales in inventory (DSI), also called days inventory outstanding or inventory days on hand, is how many days your inventory would last if you kept selling at your current pace. It's average inventory ÷ cost of goods sold × the days in the period.
What is a good DSI for an online store?
It depends on what you sell and how long your suppliers take. A lower number means cash sits in stock for less time, but too low means stockouts. Compare your own DSI month to month, and by product, more than against other stores.
Why use cost of goods sold and not revenue?
Inventory is valued at what you paid for it, so it's compared with what the goods you sold cost you. Using revenue would mix in your margin and make DSI look shorter than it is.
Where do I find these numbers in Shopify?
Shopify's reports show inventory value at a date and cost of goods sold when your products have a cost per item set. Without costs, use units instead: average units in stock ÷ units sold × days gives the same answer in days.
How is this different from days left per product?
DSI is one number for the whole store, from accounting values. Days left is per product, from its recent sales: what you need to decide what to reorder this week. How Shopify works out days of inventory remaining