How to Calculate Days Sales in Inventory

Days sales in inventory tells you how many days it would take to sell everything currently sitting in your warehouse at your current rate of sales. It is typically calculated as average inventory divided by cost of goods sold, multiplied by 365, so it turns inventory into a time measure you can use. A distributor at 30 days is holding about a month of stock. One at 90 days has three months of cash on pallets.

For wholesale distributors, inventory managers, finance teams, and operations planners, that number is a practical way to see how much working capital is tied up in stock, whether you are drifting toward overstock or risking stockouts, and how purchasing decisions affect cash flow.

The formula takes ten seconds. What almost nobody publishes is the number you should be comparing yourself against, and the pages that do quote a benchmark tend to give one round figure with no source attached.

This guide gives you the formula, the two places it commonly goes wrong, and real DSI figures for wholesale food and beverage distribution derived from US Census Bureau data, with the arithmetic shown so you can check it. It also shows how average inventory methods change the result, how DSI relates to inventory turnover and the cash cycle, what high or low DSI usually signals, where the data comes from in practice, and what to do if you need to bring your inventory days down.

What Days Sales in Inventory Measures

DSI converts an inventory balance into time. Instead of telling you that you hold $200,000 of product, it tells you that $200,000 is 30 days of supply, which is the form the number needs to be in before anyone can act on it.

The question it answers is about cash, not about warehouse space. Every day of inventory is a day your money is committed to product you have already paid for and not yet been paid for.

Two other names describe roughly the same thing. Days inventory outstanding, or DIO, is the accounting term and uses this exact formula. “Days of supply” is the operations term, and planners usually run it forward off a demand forecast in units rather than backward off last year’s cost.

The Formula, and the One Choice You Have to Make

The standard calculation divides inventory by the cost of what you sold, then scales it to a year: DSI is calculated as (Average Inventory / COGS) x 365.

Most pages ranking for this metric use that form, with average inventory in the numerator and 365 in the multiplier. The choice you have to make is whether to use an average or just the closing balance, and the answer changes your result by several days.

Use the average unless you have a reason not to, because average inventory provides a truer picture of stock investment. The closing balance alone systematically overstates DSI for any business whose inventory grew during the year, because it pairs a year-end number with a full year of cost. That choice also affects cash flow and purchasing decisions. On the real industry figures later in this guide, that difference is about a day and a half in grocery distribution and nearly five days in beverage alcohol.

One thing to keep straight: the denominator is cost of goods sold, not revenue. Sales is the bigger number, so putting it in the denominator quietly understates your inventory days by whatever your gross margin is. On the grocery figures later in this guide it turns 26.5 days into 22.2, a 16% flattery that exactly matches the 16.2% margin.

Cost of goods sold is calculated in your accounting system rather than your warehouse, which is why a QuickBooks inventory sync beats a spreadsheet export as the place to read it from.

How to Calculate Average Inventory

Working out how to calculate average inventory is the simple part, and there are two accepted forms depending on how much data you have.

The two-point version uses the average inventory formula: opening balance plus closing balance, divided by two. If you began the year with $180,000 of stock and ended with $220,000, your average inventory is $200,000.

The multi-period version sums several readings and divides by their count, which is what you want if your stock swings seasonally. Multi-period averages improve accuracy for seasonal inventory fluctuations. A distributor that builds inventory ahead of a summer peak gets a misleading two-point average, because a January and a December reading can both miss a June balance that was twice as high. Twelve month-end readings divided by twelve is the honest answer there. Better average inventory figures also help identify slow-moving products and stockouts.

Pull both balances from the same place, ideally your accounting system rather than a warehouse report, so the valuation method behind them is consistent. A count valued at cost in one period and at a landed cost including freight in the next will move your DSI without anything physical changing, and average inventory is also essential for calculating the inventory turnover ratio.

A Note on Ending Inventory

Ending inventory is the value of goods available for sale at the end of the accounting period, calculated as beginning inventory plus net purchases minus cost of goods sold, and it is the figure the average above depends on. It is recorded as a current asset on the balance sheet and also affects the income statement through COGS. Learning how to calculate ending inventory properly matters because inventory valuation methods such as FIFO and LIFO change DSI calculations, and accurate inventory valuation supports reliable financial statements.

Anyone working out how to calculate ending inventory for the first time should know that the method choice is a decision you make once and then apply consistently, since switching mid-year makes two periods incomparable. Which method you pick changes the closing balance and therefore your DSI, and the ending inventory formula carries the worked figures for FIFO, LIFO and weighted average side by side to show how ending inventory affects inventory value, helps assess COGS, and influences gross profit margin, gross profit, and tax liability.

Two Worked Examples, and Why the Second One Matters

A calculation you cannot sanity-check is worse than no calculation, so here are two, both reconciled against real industry data afterwards.

A shelf-stable grocery distributor. Opening inventory $180,000, closing inventory $220,000, so average inventory is $200,000. Cost of goods sold for the year was $2,400,000.

DSI = ($200,000 ÷ $2,400,000) × 365 = 30.4 days. That is 12 inventory turns a year. A lower DSI here indicates efficient inventory management and strong sales performance for that category.

Run the same figures on the closing balance alone and you get ($220,000 ÷ $2,400,000) × 365 = 33.5 days. Three days of apparent inventory that exists only because the business grew.

A wine and spirits distributor. Average inventory $500,000, cost of goods sold $3,200,000.

DSI = ($500,000 ÷ $3,200,000) × 365 = 57 days, or 6.4 turns.

Both answers should look different, and the reason is category rather than competence. Perishable and near-perishable grocery product has to move fast. A wine and spirits book carries more SKUs, deeper brand ranges, supplier purchase minimums and allocated or vintage buys, so it sits on more days by design, and comparing the two would tell you nothing.

What Good Actually Looks Like in Wholesale Distribution

Here is the part the search results are missing. These figures are derived from the Census annual wholesale data for 2022, benchmarked to the 2022 Economic Census, using merchant wholesalers excluding manufacturers’ sales branches, which is the population an independent distributor belongs to, and DSI varies significantly across different industries.

Cost of goods sold is sales minus gross margin, and average inventory is the mean of the two year-end balances. Both year-end figures are in the table so you can reproduce the average, and every row cross-checks against the accounting identity, opening inventory plus purchases minus closing inventory, to the dollar.

A grocery store typically posts a very low DSI because goods are perishable, while an automotive manufacturer usually carries a much higher DSI because its products are complex and costly.

Read against those figures, the grocery worked example above at 30.4 days runs about four days heavier than its own category figure, which is what you would expect from a smaller operation with less buying power and thinner supplier terms. The beverage example at 57 days lands close to its category figure too. Neither is a red flag, and that reconciliation is the step worth doing on your own number before acting on it for the company’s inventory, especially in retail businesses, against industry norms and trends over time rather than a universal target.

Two guardrails follow, and these are our judgment rather than Census data. For shelf-stable grocery-type product a workable band is roughly 25 to 45 days, and anything past 60 should prompt a look at code dates.

For beverage alcohol, 45 to 75 days is normal rather than alarming, though that Census category blends fast-turning beer with slower wine and spirits, so a beer-led book should sit well under it. Below about 15 days in either category you are likely trading stockouts for a flattering metric.

Checking That the Benchmark Is Still Current

The annual figures describe 2022, and the benchmarked version of them only came out on August 31, 2026, so the data is four years old even though the publication is weeks old. That is worth testing against something monthly. The Census Bureau’s monthly wholesale trade report carries an inventories-to-sales ratio for the same categories and the same population, and for July 2026 it stood at 0.73 for groceries and 1.66 for beverage alcohol.

Each ratio is months of inventory measured against sales rather than against cost, so converting one needs the gross margin. Applying the 2022 margins to the grocery ratio gives about 26.5 days on a cost basis, within a day and a half of the annual figure on either inventory basis, so grocery has held roughly steady.

Beverage alcohol converts to roughly 72 days, well above its 2022 level on any basis, so the alcohol band is the one to treat as moving.

DSI and Inventory Turnover Are the Same Number

Inventory turnover is cost of goods sold divided by average inventory, and DSI is 365 divided by turnover. They are two views of one measurement, so there is no point tracking both as though they were separate signals.

Turns are easier to compare across a peer group, and days are easier to explain to anyone thinking about cash, which is why finance tends to use days and buyers tend to use turns. If your figure is 12 turns it is 30 days; 6 turns is 61. Turns diverge by category even more sharply than days do, a comparison the inventory turnover formula settles with benchmarks.

Use whichever one your team already argues in, and convert rather than recalculating.

How DSI Fits the Rest of Your Cash Cycle

On its own the number is only a third of the picture. DSI is a key component of the cash conversion cycle: add the days your customers take to pay and subtract the days you take to pay suppliers, and inventory days become a financing question.

A distributor holding 30 days of stock, collecting in 35 days and paying suppliers in 30 is funding 35 days of trading out of its own pocket, so changes in DSI directly affect cash flow and working capital. Cut inventory to 20 days and the gap closes to 25 without a single change to pricing or terms, which can improve cash flow and, when service levels are preserved, improve working capital efficiency.

That is the argument for treating DSI as a working-capital measure rather than a warehouse statistic. It is also why the metric belongs in the same monthly review as receivables, not in a separate operations report nobody in finance reads, and why the inventory management reporting it comes from has to be current enough to act on, since DSI also influences liquidity and operational efficiency.

What a High DSI Is Actually Costing You

A rising DSI may suggest excess inventory or slow sales performance, not just storage costs. It is working capital committed to product that is not selling, and in food distribution it is also a clock.

The costs stack in a specific order. Cash comes first, since stock you bought 60 days ago was funded by something. Then code-date risk, because a slow-moving case in a food warehouse eventually becomes unsellable rather than merely late. Then the holding costs of touching the same pallet repeatedly. Last is the opportunity cost, the SKU you could not buy because the money was already spent.

A rising DSI can also indicate slower sales or excess purchasing, which often leaves excess stock or simply too much inventory on hand. The endpoint of a DSI that keeps climbing is dead stock, and the useful thing about tracking days rather than dollars is that days give you warning before a write-off does.

Watch it by SKU rather than only in aggregate. A company-level figure of 30 days can hide twenty SKUs at 8 days and five at 200, and the aggregate will look healthy right up to the write-down.

When a Low DSI Is the Worse Problem

Driving the number down looks like good management until the phone starts ringing. A falling DSI may indicate faster inventory movement and better inventory management, but only if service levels remain intact. A DSI below your category band usually means you are out of stock somewhere, and in our experience a stockout costs more than the carrying cost it saved, because the store buys a competitor’s product and may not switch back, creating lost sales.

The number that protects against that is not DSI but safety stock, calculated per SKU from demand variability and supplier lead time. A fast-moving SKU with an unreliable supplier needs cover a company-wide inventory target will never give it, which is what the safety stock calculation sizes per SKU.

The honest framing is that DSI is a constraint to stay inside, not a number to minimize. Below the band, you are buying a metric with service.

How to Bring DSI Down Without Creating Stockouts

Four moves do most of the work, and only one of them is about buying less.

1. Cut order quantities on slow movers rather than across the board, since the same case count spread over more frequent orders lowers average inventory without touching service, as long as the smaller drop still clears your freight break.
2. Set reorder points per SKU from actual lead times instead of a shared rule of thumb.
3. Review the bottom of your SKU list quarterly and discontinue or clear what has not moved, because a long tail is what quietly inflates the average.
4. Shorten the gap between a sale happening and the system knowing about it, so reorder decisions run on this week’s demand rather than last month’s.

The first two are an order-sizing question, and the trade-off between ordering frequently and ordering in bulk has a formal answer in economic order quantity, worth running on your top SKUs by value before adjusting anything by feel.

The fourth is usually the biggest and the least discussed, because it is not an inventory decision at all.

Where the Number Comes From in Practice

DSI is only as good as its two inputs, and in most small distributors both are stale. The inventory balance is a warehouse count from a while ago, and cost of goods sold arrives with the month-end close, which means the metric describes a business that existed weeks ago.

Fixing the reporting lag usually means fixing order capture. Empire Snack Distributors, a New York snack distributor supplying independent grocers, convenience stores and specialty markets, had no real-time inventory visibility and was re-entering orders by hand into QuickBooks, delaying fulfillment by up to 12 hours per cycle and producing frequent stockouts.

After moving to one system, stock visibility became live for reps and warehouse staff alike, order processing dropped to minutes, and the company came in about 50% below the $15,000 to $18,000 a year the alternatives it looked at were quoting.

SimplyDepo supports the inventory half of the calculation rather than the accounting half. It carries a live count per SKU showing what is on hand, what is committed to open orders and what is genuinely available to sell, draws stock down as orders are fulfilled, and raises an alert at a reorder threshold.

Cost of goods sold is still produced by your books, which the platform syncs with through QuickBooks Online rather than replacing. The Desktop edition is not supported.

Get the inventory figure current first, because a DSI computed from a count that is three weeks old is a description of history. Once the stock number is live, the reporting behind it can be read weekly instead of monthly, and per-SKU drift becomes visible while there is still time to act.

Days sales in inventory is worth tracking because it turns a balance-sheet figure into a number with a deadline attached. The formula is simple and the convention question is worth deciding once.

The part that genuinely takes effort is comparing your result against your own category rather than against a round number from a blog. At 26.5 days for grocery wholesalers and 57.6 for beverage alcohol, the real spread inside wholesale distribution is wide enough that a generic target would mislead almost everyone who used it.

If your inventory figure lags your actual stock by weeks, the metric will keep describing a business you no longer run. Holding stock, orders and per-account pricing together is what makes the number behind this calculation current rather than reconstructed, with the month-end close still happening in your books. To see how that would work against your own SKU list, you can book a demo.