Blog · Finance metrics and formulas · Supply chain
The inventory-to-sales ratio divides an inventory balance by net sales for a stated period. Work the ratio and its reciprocal by category, check the totals, and understand why valuation and seasonal timing change the interpretation.
The inventory to sales ratio is inventory divided by net sales for a stated period, usually closing inventory divided by one month's sales. A higher ratio means more inventory value relative to sales revenue. It does not, by itself, tell you how many months the physical stock will last.
Inventory-to-sales ratio = Closing inventory value / Net sales for the period
Sales-to-inventory ratio = Net sales for the period / Closing inventory value
For positive values, sales to inventory = 1 / Inventory to sales
The Federal Reserve's notes on the Census inventory-to-sales series use end-of-month inventory and monthly sales. A company can use another clearly labeled convention, but it should not mix a monthly denominator with an annual benchmark or switch from closing to average inventory without explanation.
The reciprocal tells you revenue generated relative to the specified stock balance. It is not standard inventory turnover, which uses cost of goods sold and average inventory. Retain both labels when sharing the calculation so a sales-based figure cannot be mistaken for cost-based turns.
Take a month-end inventory valuation export with snapshot date, SKU, category, site, quantity, and inventory value. Then take the month's sales lines with transaction date, SKU, site, gross sales, returns, allowances, and net sales. Use the same category and site definitions in both files.
The numerator is a balance at one date; the denominator is activity during a period. Sum the month-end inventory rows once. Sum sales transactions through the month rather than summing repeated copies of the inventory snapshot attached to each transaction.
Net sales must reflect returns and allowances. The IRS explains that customer credits for returns and allowances reduce gross sales when determining net sales. If the export already contains net amounts, do not deduct the same credits again.
Keep currency, inventory valuation, and stock status explicit. Inventory held for another company, damaged stock, and goods awaiting receipt may require different treatment under your company's policies. Ask finance to approve the inclusion rules before comparing sites.
An illustrative US distributor compares three categories for March 2026. Inventory is the March 31 carrying value at cost. Sales cover March 1 through March 31, and the returns column includes all sales deductions assumed in this example.
| Category | Closing inventory (USD) | Gross sales (USD) | Returns and allowances (USD) | Net sales calculation (USD) |
|---|---|---|---|---|
| Hardware | 420,000 | 370,000 | 20,000 | 370,000 - 20,000 = 350,000 |
| Lighting | 300,000 | 155,000 | 5,000 | 155,000 - 5,000 = 150,000 |
| Safety | 180,000 | 325,000 | 25,000 | 325,000 - 25,000 = 300,000 |
| Total | 900,000 | 850,000 | 50,000 | 850,000 - 50,000 = 800,000 |
The calculation table divides those same values both ways. Displayed ratios are rounded to two decimals; reconciliation uses the unrounded amounts.
| Category | Inventory / net sales | Inventory-to-sales ratio | Net sales / inventory | Sales-to-inventory ratio |
|---|---|---|---|---|
| Hardware | 420,000 / 350,000 | 1.20 | 350,000 / 420,000 | 0.83 |
| Lighting | 300,000 / 150,000 | 2.00 | 150,000 / 300,000 | 0.50 |
| Safety | 180,000 / 300,000 | 0.60 | 300,000 / 180,000 | 1.67 |
| Total | 900,000 / 800,000 | 1.13 | 800,000 / 900,000 | 0.89 |
Lighting holds $2.00 of inventory at cost for each dollar of March net sales. Safety holds $0.60. That makes Lighting a candidate for investigation, but a deliberate seasonal purchase or a different gross margin could explain part of the gap.
First reconcile the input totals. Inventory is 420,000 + 300,000 + 180,000 = 900,000. Net sales are 350,000 + 150,000 + 300,000 = 800,000, also equal to gross sales of $850,000 less deductions of $50,000.
Then check the company ratio against the company amounts. Its exact value is 900,000 / 800,000 = 1.125; multiplying 1.125 by $800,000 returns $900,000. The exact reciprocal is 800,000 / 900,000, and multiplying the two unrounded ratios gives one.
Use the ratio of summed amounts, not the simple average of the displayed category ratios. Each category has a different sales denominator. Finally, tie closing inventory to the valuation report and net sales to the same month's sales ledger, recording exclusions separately.
Inventory at cost and sales at selling prices are intentionally different measures here. That relationship is useful for a consistent trend, but it is not cost-based months of coverage. Consider the Lighting category with the following additional cost information:
| Lighting input or calculation | Amount (USD) or result |
|---|---|
| Closing inventory at cost | 300,000 |
| March net sales | 150,000 |
| March COGS | 90,000 |
| Gross profit: 150,000 - 90,000 | 60,000 |
| Gross margin: 60,000 / 150,000 | 40.0% |
| Inventory / monthly sales: 300,000 / 150,000 | 2.00 |
| Inventory / monthly COGS: 300,000 / 90,000 | 3.33 |
The cost-based closing balance covers more historical cost than the sales-based ratio suggests. Neither result is a forecast of future unit demand. For historical average cost coverage expressed in days, use days inventory outstanding.
Suppose Lighting's April net sales rise to $300,000 while closing inventory stays at $300,000. Its ratio becomes 300,000 / 300,000 = 1.00, down from 2.00. Inventory has not fallen; sales have increased. A lower ratio therefore does not necessarily mean cash was released from stock.
Separate changes in purchasing, inventory value, realized selling prices, returns, and demand. Compare equivalent selling months when the business is seasonal. The Census manufacturing and trade release identifies its published headline ratio as seasonally adjusted; an unadjusted company month should not be treated as a directly equivalent observation.
For choosing among related measures, see inventory ratios. A margin question belongs with return on inventory, while the separate sales coverage ratio requires its own clearly stated denominator.
Upload your inventory snapshot and monthly sales export to Covirage with their dates and category columns. Covirage maps the columns, its tools compute and check the category ratios and totals, and the external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for supply chain teams for the business context.
There is no universal target. A useful comparison matches the category, business format, selling season, inventory valuation, and sales period. Review your own trend alongside stockouts and aging, then investigate changes in purchases, sales, returns, or prices before changing the stock target.
No. The sales-based ratio usually divides closing inventory by period revenue. Standard inventory turnover divides period cost of goods sold by average inventory at cost. The balance convention and valuation differ, so taking a reciprocal does not convert one into the other.
Yes, but a decimal ratio is often clearer for monthly comparisons. Label whichever format you use and keep it consistent. The percentage expresses inventory relative to sales; it is neither a gross margin percentage nor the share of individual products still unsold.
Report the ratio as undefined and retain the inventory amount as an exception. Do not replace zero sales with an arbitrary small denominator. Investigate whether the category is new, inactive, seasonal, or incorrectly mapped before deciding whether a longer comparison period is appropriate.