Skip to main content

Inventory Turnover Ratio for Small Retailers: How to Calculate Days Sales in Inventory, Spot Dead Stock, and Free Cash Trapped on Shelves

Published 11 min readMike ThriftMike Thrift
Inventory Turnover Ratio for Small Retailers: How to Calculate Days Sales in Inventory, Spot Dead Stock, and Free Cash Trapped on Shelves
On this page

Look at your shelves, your stockroom, or your warehouse bins. Every item sitting there is cash you already spent that has not come back yet — and it charges you rent every month it waits. Between the capital tied up, storage, insurance, shrinkage, and markdowns, carrying unsold inventory typically costs 20 to 35 percent of its value per year, with 25 percent a widely used rule of thumb. A retailer holding $80,000 of slow-moving stock is quietly spending around $20,000 a year for the privilege of owning it.

The inventory turnover ratio is the number that tells you how fast your stock earns its keep. It measures how many times you sell through and replace your inventory in a given period — and its companion metric, days sales in inventory (DSI), translates that into plain calendar days. This guide shows how to calculate both, what counts as good for a small retailer, how to use them to hunt down dead stock, and which levers actually move the number.

What the Inventory Turnover Ratio Measures​

The inventory turnover ratio answers one question: for every dollar of inventory you carry, how many dollars of goods did you sell through in the period? The formula is simple:

Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory

Two details in that formula matter more than they look:

Use COGS, not sales revenue. Inventory on your balance sheet is valued at cost, while your sales figure includes markup. Dividing retail sales by cost-basis inventory mixes two different valuations and inflates the ratio, making your efficiency look better than it is. COGS matches cost to cost, so the comparison is honest.

Use average inventory, not a single snapshot. Inventory swings with seasons, promotions, and delivery cycles. Averaging smooths that out:

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

For a full year, beginning inventory is the value on January 1 and ending inventory is the value on December 31. If your business is strongly seasonal — a holiday gift shop, a swimwear boutique — a two-point average can still mislead, and averaging quarterly or monthly balances gives a truer picture.

A higher ratio generally signals strong sales, lean purchasing, or both. A lower ratio suggests overstocking, weak demand, or buying inefficiencies. But the number means little in isolation: its power comes from tracking it over time and comparing it against similar retailers.

How to Calculate It: A Worked Example​

Say you run a small home-goods shop. On January 1 your inventory is valued at $60,000. On December 31 it is $40,000. Your cost of goods sold for the year — the wholesale cost of everything you sold — is $300,000.

Step 1: Average inventory. ($60,000 + $40,000) ÷ 2 = $50,000.

Step 2: Turnover. $300,000 ÷ $50,000 = 6.0.

Your shop turned its inventory six times during the year — roughly once every two months. Is that good? For home furnishings, where turns of 3 to 5 are typical, six is healthy. For a grocery store, six would be alarmingly slow. Context is everything, which is why benchmarks matter (more on those below).

Run this calculation at least quarterly, not just at year-end. Annual math hides a multitude of sins: a great holiday quarter can mask nine months of overstocking. Quarterly turns show you the trend while there is still time to act on it.

Days Sales in Inventory: The Same Number in Calendar Days​

"6.0 turns" is abstract. "61 days" hits differently. Days sales in inventory (DSI) converts turnover into the average number of days an item sits before it sells:

DSI = (Average Inventory ÷ COGS) × 365

Or, equivalently:

DSI = 365 ÷ Inventory Turnover

For the home-goods shop above: 365 ÷ 6.0 ≈ 61 days. On average, each dollar of inventory waits two months before converting back into cash.

DSI is the more intuitive management number because it speaks the language of cash flow. Cutting DSI from 90 days to 60 days is a one-third reduction in the stock you carry, so on $50,000 of average inventory it frees roughly $17,000 of cash — money that can pay down a credit line, fund a winning product expansion, or simply sit in your account instead of on your shelves. Lower DSI is generally better, but only down to the point where leanness starts causing stockouts.

What Counts as Good? Retail Benchmarks​

There is no universal "good" turnover — inexpensive, fast-moving goods turn far faster than big-ticket items. But sector benchmarks give you a starting target:

Retail sectorTypical annual turnsImplied DSI
Grocery and FMCG12–1524–30 days
Consumer electronics6–846–61 days
Sporting goods5–752–73 days
Apparel and fashion4–661–91 days
Home furnishings3–573–122 days

Broader surveys tell a consistent story. A widely cited healthy range for retail overall is roughly 5 to 10 turns per year, and Netstock's 2026 supply-chain benchmark found top-quartile businesses ("Stars") turning inventory 7.9 times a year against 2.5 turns for the laggards ("Stragglers") — more than a threefold gap in how hard each inventory dollar works.

Three rules for using benchmarks well:

  1. Compare within your sector. A furniture store turning 4 times a year is fine; a grocer turning 4 times a year is in trouble.
  2. Trend yourself first. Your own ratio rising from 3.5 to 5 over two years tells you more than any industry table.
  3. Adjust for your model. Made-to-order, consignment, and dropship retailers carry little or no inventory, so their "turnover" is not comparable to a stocked shop's.

When High Turnover Is a Warning, Not a Win​

Faster is not always better. A turnover ratio climbing past your sector's range can mean you are running too lean:

  • Stockouts and lost sales. If popular items are frequently out of stock, your high turns come from empty shelves, not efficiency. Customers who walk out twice rarely come back a third time.
  • Rush-order premiums. Chronic understocking pushes you into expedited freight and emergency supplier orders that quietly erase the margin your leanness was supposed to protect.
  • Fragile service levels. A single late delivery or demand spike wipes out a store with no buffer stock.

The healthy target is a balanced ratio: fast enough to keep cash moving and carrying costs down, with enough buffer to cover lead times and demand spikes. If turns are rising while customer complaints about availability rise with them, you have overshot.

Using Turnover to Hunt Dead Stock​

The ratio's most practical use is per-SKU, not store-wide. A healthy overall turnover can hide a long tail of products that never move. Here is the hunt:

1. Calculate turnover by product or category. Divide each SKU's annual COGS by its average on-hand value. Anything turning near zero is a suspect.

2. Apply the 12-month rule. A common textbook definition of dead stock is product with no sales in twelve months. Flag every SKU that qualifies, and treat anything with no sales in six months as slow-moving stock on probation.

3. Run an ABC analysis. Rank every SKU by annual consumption value (units sold × unit cost) and split the list into three bands: A items are roughly the top 10 to 20 percent of SKUs driving 70 to 80 percent of value, B items are the middle, and C items are the long tail — often around 70 percent of SKUs contributing around 10 percent of value. Most of your dead stock lives in the C band. That is where to focus exit decisions rather than spreading attention evenly across thousands of SKUs.

4. Do the hold-vs-exit math honestly. Remember the carrying-cost rule of thumb: every $1,000 of dead stock costs you roughly $250 a year to keep owning. A 40-percent-off clearance sale that recovers $600 today beats holding out for full price while the goods quietly cost you $250 a year and occupy space your winners could use. Markdowns feel like losses; indefinite storage is the bigger one.

Exit routes beyond discounting include bundling slow SKUs with bestsellers, returning stock under supplier agreements, selling lots to liquidators, and — for genuinely unsellable goods — writing the inventory off so your books stop pretending the value exists.

Five Levers That Actually Improve Your Turns​

Tighten reorder points and safety stock. Most small retailers reorder by gut feel, which means over-ordering "just in case." Set explicit reorder points from actual lead times and average daily sales, plus a modest safety buffer for variability — then let the numbers trigger the purchase order.

Order smaller, more often. Large bulk orders earn quantity discounts but inflate average inventory and DSI. Price the trade-off: a 5 percent bulk discount is a bad deal if it doubles the months of stock you carry at a 25-percent annual carrying cost. Negotiate smaller minimums or split deliveries with suppliers.

Run clearance on a cadence, not in a panic. Schedule quarterly reviews of slow movers and mark them down early, when a 20 percent discount still moves them. Annual panic clearances at 70 percent off recover less cash and train customers to wait for the fire sale.

Forecast from history, not hope. Your point-of-sale history already knows which SKUs accelerate in which months. Even a simple spreadsheet comparing this quarter to the same quarter last year beats ordering from optimism — and it is the cheapest demand-planning tool you own.

Align purchasing with promotions. Every sale, ad campaign, or seasonal push should have an inventory plan attached: enough depth to avoid stockouts on promoted winners, and no depth at all on items the promotion is designed to clear.

Mistakes That Corrupt the Number​

  • Using sales instead of COGS. The single most common error, and it always flatters the result. Pull COGS from your profit and loss statement, not the top revenue line.
  • Measuring inventory once. An ending balance taken right after a big delivery — or right after the holiday sell-through — is not your average. Average at least beginning and end; monthly is better.
  • Ignoring seasonality. Comparing a toy shop's December quarter against its July quarter proves nothing. Compare quarter to same quarter last year.
  • Averaging across unlike categories. Blending fast-turning consumables with slow-turning equipment into one number hides both stories. Track categories separately, then roll up.
  • Never going below store level. The headline ratio tells you whether you have a problem; only per-SKU math tells you where it lives.

Keep the Inputs Honest in Your Books​

Every ratio in this article is only as trustworthy as two bookkeeping inputs: COGS and inventory value. If COGS is a year-end plug figure and inventory is a guess between physical counts, your turnover ratio is fiction with decimal places.

Perpetual tracking — recording each sale's cost as it happens, whether through point-of-sale integration or disciplined purchase-and-sale entries — keeps both numbers live all year instead of reconstructed at tax time. A monthly reconciliation of book inventory against a cycle count of a few shelves catches shrinkage, damage, and data-entry drift before they compound into a year-end surprise. And keeping inventory purchases cleanly separated from supplies and equipment means your COGS actually reflects what you sold, not what your store consumed. If you keep your books in plain text, the Beancount documentation shows how inventory lots and cost-basis tracking work in a version-controlled ledger you can audit line by line.

Free the Cash on Your Shelves​

Start this week with three numbers: your trailing-twelve-month COGS, your beginning inventory, and your ending inventory. Compute your turns and your DSI, compare them against your sector's range, and then drill one level down to find the five slowest SKUs. Clearing just those five — through markdowns, bundles, or a supplier return — often frees more cash than months of squeezing other expenses.

As your turns improve, maintaining clear financial records becomes even more important: accurate COGS and inventory balances are what keep the ratio honest month after month. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.

Source: https://beancount.io/blog/2026/10/09/inventory-turnover-ratio-days-sales-inventory-dead-stock-retailer-guide

Published: October 9, 2026