Days sales in inventory is calculated as: formula and example

Days sales in inventory is calculated as (Average inventory ÷ Cost of goods sold) × number of days in the period. A common alternative is DSI = Days in period ÷ Inventory turnover (typically 365 ÷ inventory turnover). Both versions produce the same figure: the average number of days it takes a business to convert its inventory into sales.

DSI tells you how long stock sits on the shelf before it sells. A lower figure usually means faster turnover; a higher one means capital is tied up in inventory for longer.

Primary formula: Average inventory ÷ COGS × days in period
Alternate formula: Days in period ÷ Inventory turnover

Principais conclusões

Days sales in inventory is calculated as average inventory divided by cost of goods sold, multiplied by the number of days in the period, and validated against the inventory turnover method.

Ponto	Detalhes
Primary formula	DSI = (Average inventory ÷ COGS) × days in period; average inventory smooths out single-point balances.
Cross-check method	DSI = Days in period ÷ Inventory turnover should always match the primary formula’s result.
Matching periods matters most	Inventory and COGS figures must come from the same reporting window to avoid distortion.
Context beats a single benchmark	A 30 to 60 day range is illustrative only; track trend and compare within your own industry.
Software reduces reconciliation errors	Platforms like Fullyops link stock movements to COGS automatically, keeping DSI reporting auditable.

Índice

What days sales in inventory actually measures
How is DSI calculated, step by step?
A worked example of the DSI calculation
Common pitfalls when calculating DSI
Is a high or low DSI better?
Quick checklist before you trust the number
How software turns DSI into an operational decision
Sources
FAQ

What days sales in inventory actually measures

DSI measures the average number of days a company holds inventory before it sells. You will also see it called days inventory outstanding (DIO), days in inventory (DII), or average age of inventory. All three refer to the same calculation, just under different labels depending on which textbook or software vendor you’re reading.

Analysts use DSI for three main jobs:

Assessing liquidity and how quickly stock converts to cash
Judging working capital efficiency alongside days payable and days receivable
Flagging operational issues, such as overstocking or slow-moving product lines

Dica profissional: A single DSI figure tells you very little. Track it monthly or quarterly and watch the trend. A rising line usually flags a build-up problem well before it shows up in cash flow.

How is DSI calculated, step by step?

The two formulas you need are:

DSI = (Average inventory ÷ COGS) × Number of days in the period
DSI = Number of days in the period ÷ Inventory turnover

Both require the same underlying components, defined precisely:

Inventory covers raw materials, work in progress (WIP), and finished goods. Leaving out WIP understates the figure for manufacturers holding a lot of unfinished stock.
Cost of goods sold (COGS) is the direct cost of producing what was sold in the period, taken from the income statement, not revenue.
Average inventory is (beginning inventory + ending inventory) ÷ 2, smoothing out a single snapshot that might not reflect typical stock levels.
Days in period is usually 365 for a full year, though 360 or 90 are common shortcuts for quarterly reporting.

The most frequent calculation error isn’t the maths. It’s pulling inventory from one reporting window and COGS from another, which silently distorts the result.

Follow this sequence every time:

Pull beginning and ending inventory from the balance sheet for the same period as your income statement.
Calculate average inventory.
Pull COGS for that identical period.
Apply the primary formula and confirm the period length you used (365, 360, or 90 days).
Cross-check using inventory turnover as a sanity test.

A worked example of the DSI calculation

Take a mid-sized distributor reporting annually.

Beginning inventory: $180,000. Ending inventory: $220,000. COGS for the year: $1,500,000.
Average inventory = (180,000 + 220,000) ÷ 2 = $200,000.
DSI = (200,000 ÷ 1,500,000) × 365 = 48.7 days.
Validation via turnover: Inventory turnover = COGS ÷ Average inventory = 1,500,000 ÷ 200,000 = 7.5. Then DSI = 365 ÷ 7.5 = 48.7 days.

Both routes land on the same number, which is exactly the point of running the alternate formula: if they disagree, one of your inputs is wrong.

Common pitfalls when calculating DSI

Matching periods is non-negotiable. Inventory sits on the balance sheet at a point in time, while COGS accumulates over a period on the income statement, so mixing a full year’s COGS with one month’s closing inventory will badly skew the result.

Several other errors crop up regularly:

Using ending inventory alone when stock levels swing significantly during the period, rather than averaging.
Blending units and monetary value, especially when a business sells multiple product lines at different price points.
Switching inventory valuation methods (FIFO, LIFO, weighted average) between periods, which makes trend comparisons meaningless.
Ignoring seasonality, so a retailer’s post-holiday inventory snapshot looks nothing like its pre-holiday build-up.

For businesses with sharp seasonal swings or a deliberate one-off stock build, monthly or rolling averages give a more honest picture than a single beginning-to-ending average.

Dica profissional: Treat consigned stock, obsolete inventory, and WIP consistently across periods. If you exclude obsolete stock one quarter and include it the next, your DSI trend will look like an operational problem when it’s really an accounting inconsistency.

Is a high or low DSI better?

Neither figure is automatically good news. A low DSI often signals efficient turnover, but taken in isolation it can also point to stockouts and lost sales. A high DSI might mean overstocking and tied-up cash, or it could reflect a deliberate buffer built to protect fulfilment rates during demand spikes.

Illustrative guidance often cites a range of roughly 30 to 60 days as reasonable for many businesses, but that band is a rough starting point, not a rule.

Comparing DSI across different industries is usually misleading, since a grocery chain and an aerospace parts supplier have entirely different stock-holding realities.
DSI is most reliable as an internal trend line, or benchmarked against close industry peers rather than the market broadly.
Low DSI: check whether it reflects genuine efficiency or a stockout risk building underneath a healthy-looking number.
High DSI: check whether it’s a deliberate strategic buffer or the early sign of overstocking.

Quick checklist before you trust the number

Confirm the day count (365, 360, or 90) and keep it consistent across comparisons.
Verify inventory includes raw materials, WIP, and finished goods, and that you used the average, not a single snapshot.
Check COGS covers the identical period as the inventory figures.
Recompute using the inventory turnover method to confirm both formulas agree.

How software turns DSI into an operational decision

Calculating DSI accurately depends on clean, well-tagged data, and that’s where most manual spreadsheets fall over. A platform that centralises inventory balances, separates WIP from finished goods, and links stock movements directly to COGS removes the guesswork behind reliable DSI reporting.

Dashboards can surface DSI trends automatically rather than waiting for a quarterly spreadsheet exercise.
Alerts triggered by rising DSI can prompt reordering reviews or preventive maintenance scheduling before stock problems compound.
ERP and purchasing integrations reduce the manual reconciliation that causes mismatched periods in the first place.

Dica profissional: If your inventory system and your accounting system don’t talk to each other automatically, you’re recalculating DSI by hand every reporting cycle, and that’s exactly where period-matching errors creep in.

A practical note on using DSI in analysis

DSI earns its place when read alongside inventory turnover and days payable outstanding, not on its own. I’ve found it most useful as a trend line reviewed monthly, flagging direction of travel long before a single bad quarter shows up in cash flow.

Make DSI a live number, not a quarterly surprise

Manually reconciling inventory ledgers against COGS every period is slow, and it’s exactly where the period-mismatch errors covered above creep in. Totalmenteops centralises inventory tracking, tags work in progress separately from finished goods, and feeds stock movements straight into your reporting, so DSI updates automatically rather than requiring a spreadsheet rebuild each month. Dashboards flag a rising trend before it becomes a cash flow problem, and reordering triggers connect directly to what your DSI figure is telling you. If overstocked lines or slow-moving parts are quietly eating into working capital, explore how análise de operações can turn that number into a scheduled action rather than a quarterly conversation.

Sources

FAQ

How are days sales in inventory calculated?

DSI is calculated as average inventory divided by cost of goods sold, multiplied by the number of days in the reporting period, typically 365.

How do we calculate inventory days?

Inventory days (another name for DSI) uses the same formula: average inventory ÷ COGS × days in period, or alternatively, days in period ÷ inventory turnover.

How do I calculate day sales in inventory from turnover?

Divide the number of days in your period by inventory turnover (COGS ÷ average inventory). A turnover of 7.5 over 365 days gives a DSI of roughly 48.7 days.

Is a higher days sales in inventory better?

Not automatically. A high DSI can mean overstocking and tied-up cash, or a deliberate buffer for fulfilment; a low DSI can mean efficiency or hidden stockout risk.

What’s the difference between DSI, DIO, and DII?

Nothing substantive. Days sales in inventory, days inventory outstanding, and days in inventory all describe the same calculation under different naming conventions.