Days Sales in Inventory (DSI): Formula, Example and How to Lower It

How to Compute Days in Inventory
Table of Contents

Manage your inventory and business easier

Get started for free

Days sales in inventory (DSI) is the average number of days it takes a business to sell its inventory. To calculate it, divide average inventory by cost of goods sold for the period, then multiply by the number of days in that period. A store with $50,000 of average inventory and $600,000 of annual cost of goods sold has a DSI of about 30 days.

You will also see this metric called days inventory outstanding (DIO), days in inventory (DII) or simply inventory days. They all measure the same thing and use the same formula. This guide covers the formula, a step-by-step example, how to read the result, and practical ways to bring the number down.

What is days sales in inventory (DSI)?

DSI tells you how long, on average, a dollar of inventory sits on your shelves or in your warehouse before it is sold. It turns two numbers from your financial statements into a figure that is easy to act on: days.

A lower DSI means stock moves quickly and less cash is tied up in it. A higher DSI means goods sit longer, which raises holding costs and the risk that products expire, go out of style or become obsolete. For retailers and wholesalers, DSI is one of the clearest signs of whether purchasing is in step with demand.

DSI, DIO and days in inventory: one metric, three names

Accountants and analysts tend to say days inventory outstanding because it sits alongside days sales outstanding (DSO) and days payable outstanding (DPO) in working capital analysis. Operations teams and textbooks more often say days sales in inventory or days in inventory. Inventory planners shorten it to inventory days. The calculation does not change with the name.

Days sales in inventory formula

The standard DSI formula uses cost of goods sold (COGS), because inventory is carried on the balance sheet at cost:

DSI = (Average inventory รท Cost of goods sold) ร— Number of days in the period

Each input has a specific meaning:

  • Average inventory: the typical value of stock on hand during the period, at cost. The simplest version is (beginning inventory + ending inventory) รท 2. See our guide to calculating average inventory for more precise methods.
  • Cost of goods sold: what you paid for the goods you sold in the same period, taken from your income statement. If you need a refresher, here is the cost of goods sold formula.
  • Number of days: 365 for a year, 90 or 91 for a quarter, 30 or 31 for a month. Some analysts use 360 for a year. Either is fine as long as you stay consistent.

Days inventory outstanding formula using inventory turnover

If you already know your inventory turnover ratio, you can get the same answer in one step:

DIO = Number of days in the period รท Inventory turnover ratio

Inventory turnover is COGS รท average inventory, so this is simply the first formula rearranged. Our article on inventory turnover explains that ratio in detail.

Should you use average or ending inventory?

Average inventory is the better choice in most cases. It smooths out the swings that happen when a big shipment lands just before the period ends or when stock is run down for a seasonal clearance. Some analysts use ending inventory because it is quicker to pull from a single balance sheet. That shortcut works only when inventory levels are fairly stable. If stock is growing or shrinking, ending inventory will distort the result, as the example below shows.

Days sales in inventory calculator

Enter your cost of goods sold and your beginning and ending inventory for the same period. The calculator shows your DSI and the turnover behind it.

Loading the days sales in inventory calculatorโ€ฆ

Need your ending inventory value first? The free inventory valuation template totals your stock at average cost.

How to calculate days in inventory: step-by-step example

Take a fruit and produce retailer reviewing its last fiscal year.

  1. Find COGS for the period. The income statement shows cost of goods sold of $600,000.
  2. Find beginning and ending inventory. Inventory was $40,000 at the start of the year and $60,000 at the end.
  3. Calculate average inventory. ($40,000 + $60,000) รท 2 = $50,000.
  4. Apply the DSI formula. ($50,000 รท $600,000) ร— 365 = 30.4 days.

You can check the answer with the turnover method. Inventory turnover is $600,000 รท $50,000 = 12 times a year, and 365 รท 12 = 30.4 days. Both routes give the same result: on average, this retailer holds its stock for about a month before it sells.

Calculating inventory days for a quarter or a month

DSI works for shorter periods too. Match the COGS and the day count to the period you are measuring.

Say the same retailer looks at one 90-day quarter. COGS for the quarter was $135,000 and average inventory was $45,000.

DSI = ($45,000 รท $135,000) ร— 90 = 30 days

Quarterly or monthly DSI is useful for seasonal businesses, where an annual figure can hide a slow quarter.

What happens if you use ending inventory instead

Using the year-end balance of $60,000 instead of the $50,000 average gives ($60,000 รท $600,000) ร— 365 = 36.5 days. That is six days longer than the average-based result, only because inventory grew during the year. When you compare DSI across periods, use the same method each time.

How to interpret days sales in inventory

A DSI figure only means something in context. The table below shows what high and low values can signal and what to check next.

DSI resultWhat it can signalWhat to check
Low or fallingStrong sell-through, lean stock levels, less cash tied upStockouts, missed sales, rush orders at higher cost
High or risingOverbuying, slow-moving or obsolete items, weaker demandAging stock by SKU, expiry dates, open purchase orders
StablePurchasing is in step with salesWhether the level suits your lead times and margins

What is a good days sales in inventory?

There is no single “good” number. A produce seller may turn stock in days, while a furniture or hardware wholesaler can reasonably hold goods for months. The most useful comparisons are:

  • Your own history. Track DSI by month or quarter and look at the trend.
  • Your product categories. Fast and slow lines blended together can hide problems, so calculate DSI by category or SKU.
  • Your supplier lead times. If a supplier takes three weeks to deliver, a DSI well below that leaves little room for error.
  • Similar businesses. If you compare with peers, use companies with the same business model and product mix.

DSI vs inventory turnover

DSI and inventory turnover describe the same performance from two angles. Turnover counts how many times you sell through your stock in a period; DSI converts that into days.

Days sales in inventory (DSI)Inventory turnover
What it measuresAverage days stock is held before it sellsTimes stock is sold and replaced in a period
Formula(Average inventory รท COGS) ร— daysCOGS รท average inventory
Better directionLower, within reasonHigher, within reason
RelationshipDays รท turnoverDays รท DSI

Many owners find days easier to act on. “Our stock sits for 45 days” is more intuitive than “we turn inventory eight times a year.”

Where DIO fits in the cash conversion cycle

Finance teams use DIO as one of three parts of the cash conversion cycle (CCC), which measures how long cash is tied up between paying suppliers and collecting from customers:

CCC = DIO + DSO โˆ’ DPO

DSO is days sales outstanding (how long customers take to pay) and DPO is days payable outstanding (how long you take to pay suppliers). With a DIO of 30 days, a DSO of 25 days and a DPO of 35 days, the cycle is 30 + 25 โˆ’ 35 = 20 days. Cutting inventory days is often the fastest way to shorten that cycle, because it is the part you control most directly.

Common mistakes when calculating inventory days

  • Using sales revenue instead of COGS. Revenue includes your markup while inventory is valued at cost, so this mismatch makes DSI look shorter than it really is.
  • Mixing periods. Annual COGS divided into a single month’s inventory, or a 365-day count with quarterly figures, produces meaningless results.
  • Measuring at a seasonal peak. One inventory snapshot taken right before the holidays can overstate DSI for the whole year. Averaging more data points helps.
  • Looking only at the total. A healthy overall DSI can hide dead stock in one category. Break it down by SKU or product line.
  • Relying on inaccurate stock records. If your books show more inventory than is really on hand, DSI will be inflated. Regular counts and a check for inventory shrinkage keep the inputs honest.

How to lower days in inventory

Bringing DSI down means buying closer to actual demand and clearing stock that is not moving.

  • Set reorder points by item. A reorder point based on daily sales and lead time stops you from ordering too early or too much.
  • Right-size safety stock. Keep a buffer for demand spikes, but review it regularly. Our guide on how to calculate safety stock shows the math.
  • Order smaller quantities more often where supplier minimums and shipping costs allow it.
  • Clear slow movers. Bundle, discount or return aging items before they lose more value.
  • Review DSI by SKU every month and cut reorder quantities on items whose days keep climbing.
  • Negotiate shorter lead times with key suppliers so you can hold less stock without risking stockouts.

Lowering DSI should not come at the cost of empty shelves. Watch stockouts and lost sales alongside it.

How Vencru helps you keep inventory days under control

DSI depends on two numbers being right: inventory value and cost of goods sold. Vencru’s inventory and accounting software keeps both in one place.

  • Stock updates as you sell and receive, so inventory levels reflect what actually moved.
  • COGS and inventory value are recorded at average cost, ready for the DSI formula.
  • Double-entry accounting reports, including the income statement and balance sheet, give you COGS and inventory balances for any period.
  • Reorder points and low-stock alerts in the app and by email help you reorder at the right time instead of overbuying.
  • Purchase orders with partial receiving (Growth plan and up) keep incoming stock accurate.
  • Barcode scanning with your phone camera on iOS or Android, or a USB or Bluetooth scanner, makes stock counts faster, and stock adjustments fix any differences.

Try Vencru free for 14 days. No credit card required.

Frequently asked questions

What is the formula for days sales in inventory?

DSI = (Average inventory รท Cost of goods sold) ร— Number of days in the period. For a full year, use 365 days. Average inventory is usually (beginning inventory + ending inventory) รท 2.

Is days inventory outstanding the same as days sales in inventory?

Yes. Days inventory outstanding (DIO), days sales in inventory (DSI), days in inventory and inventory days are different names for the same metric. They all use the same formula and give the same result.

How do you calculate inventory days from inventory turnover?

Divide the number of days in the period by the inventory turnover ratio. If inventory turns 12 times a year, inventory days are 365 รท 12, or about 30.4 days.

Is a higher or lower DSI better?

Lower is usually better, because stock sells faster and less cash is tied up. A DSI that is too low can mean you are running out of stock and losing sales, so the goal is a level that fits your lead times and demand.

What is a good days inventory outstanding?

It depends on what you sell. Perishable goods turn in days, while durable goods can reasonably sit for months. Compare DIO with your own past results and with businesses that sell similar products.

Should I use 365 or 360 days in the DSI formula?

Either works. 365 matches the calendar year, while some analysts use 360 for simpler math. Use the same convention every time so your results stay comparable.

Latest blog posts

Subscribe To Our Newsletter

Get updates and learn from the best

Manage your inventory and bookkeeping easier

Track sales, inventory, and expenses easier with Vencru. Get real-time accurate reports and insights from anywhere.

Vencru inventory management software