Your Warehouse Is Either Making You Money or Quietly Draining It
Picture two stores with identical annual revenue of $1.2 million. Store A holds an average of $100,000 in inventory. Store B holds $400,000. On paper, they look the same size. In practice, Store B has $300,000 more cash sitting on shelves instead of earning interest, funding payroll, or paying down debt — and that gap is invisible until you run one calculation.
That calculation is the inventory turnover ratio, and it's one of the fastest ways to tell whether a business is running lean or slowly starving itself of cash by over-buying stock nobody's in a hurry to sell.
What the Inventory Turnover Ratio Actually Measures
Inventory turnover tells you how many times a business sold and replaced its entire inventory over a given period — usually a year. It's a proxy for a much more practical question: is the money tied up in your shelves, warehouse, or backroom moving, or is it stuck?
The formula is straightforward:
Inventory Turnover Ratio = Cost of Goods Sold ÷ Average Inventory
Two things matter here. First, the numerator is cost of goods sold (COGS), not revenue — you're comparing what it cost you to acquire or produce what you sold against what you're holding, both valued the same way. Mixing revenue into the formula inflates the ratio and makes it meaningless.
Second, use average inventory, not a single snapshot. A retailer measured on January 1 (post-holiday clearance) looks very different from the same retailer measured on November 1 (fully stocked for the season). Smoothing that out gives you a number you can actually trust:
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
For more precision — especially in a seasonal business — average the ending inventory balance from each month or quarter instead of just two year-end points.
A Worked Example
Say a hardware store had $80,000 in inventory at the start of the year and $120,000 at the end, with $600,000 in cost of goods sold for the year.
- Average Inventory = ($80,000 + $120,000) ÷ 2 = $100,000
- Inventory Turnover Ratio = $600,000 ÷ $100,000 = 6
That store turned over its entire inventory six times during the year — roughly once every two months.
Converting Turnover Into Days (Days Sales of Inventory)
A raw "6" is useful for comparing periods, but most owners find it easier to think in days. Days Sales of Inventory (DSI) — also called days inventory outstanding — converts the ratio into the average number of days inventory sits before it sells:
DSI = 365 ÷ Inventory Turnover Ratio
For the hardware store above: 365 ÷ 6 ≈ 61 days. On average, a dollar of inventory sits on the shelf for about two months before it converts to a sale.
DSI is the number to watch alongside days sales outstanding (how fast customers pay) and days payable outstanding (how fast you pay suppliers) — together they form the cash conversion cycle, which shows how long cash is locked up between paying for inventory and collecting on the sale.
What Counts as a "Good" Ratio
There's no universal target — a good ratio depends entirely on what you sell — but general benchmarks and industry patterns give a useful reference point:
- Most businesses land somewhere between 5 and 10 turns per year as a general middle ground.
- Grocery and convenience retail: often 10–20+, driven by perishables and constant replenishment.
- Apparel and footwear: typically 4–8, with wide swings by season and brand positioning.
- Wholesale distribution: commonly 4–7, though a mix of fast movers and slow-moving service parts can pull the blended number down.
- Electronics: roughly 4.5–8, reflecting how quickly new models make old stock less desirable.
- Furniture and home goods: often just 2.5–5, since big-ticket, low-frequency purchases naturally turn slower.
- Industrial parts and MRO supplies: can sit at 2–4 and still be perfectly healthy, provided service levels hold and nothing is quietly going obsolete.
The range from roughly 1–2 in slow-moving categories like aftermarket auto parts up to 15–20+ in perishables illustrates why comparing your ratio to a generic "good number" is far less useful than comparing it to your own history and your specific competitors.
Reading the Two Failure Modes
Too Low: Cash Is Trapped on the Shelf
A declining or persistently low ratio relative to your industry usually means one of a few things: demand has softened, purchasing has overshot actual sales, or a chunk of what's on the shelf simply isn't selling anymore. The financial consequence compounds quietly — carrying costs (storage, insurance, handling, and the opportunity cost of capital) typically run 20–30% of inventory value per year, according to supply-chain benchmarking data. Capital cost — the return that money could have earned elsewhere — is usually the single largest piece of that, often 40–60% of the total carrying cost.
That means $100,000 in slow-moving inventory isn't just $100,000 sitting still — it's realistically costing $20,000–$30,000 a year to hold, before accounting for the risk that some of it eventually gets marked down, written off, or scrapped entirely.
Too High: You're Turning Away Customers
It's tempting to treat "higher is better" as a rule, but an unusually high ratio compared to your industry peers can mean you're running so lean you're leaving money on the table. The warning signs: frequent stockouts, rush shipping fees to expedite replenishment, and customers who don't wait around for backordered items — they buy from whoever has it in stock today. Each stockout carries a cost beyond the missed sale: the customer who has a bad experience and starts checking a competitor first next time.
The right target sits in between — turning inventory fast enough that cash doesn't stagnate, but not so fast that you can't reliably fill an order.
Why the Ratio Can Mislead You
Inventory turnover is a useful signal, not a verdict, and it has real blind spots:
- It's a blended average. A single company-wide ratio can hide a bestseller that turns 20 times a year sitting next to a dead SKU that hasn't moved in eighteen months. Calculate turnover by product category or even by SKU when you can — the aggregate number often looks fine while specific items are quietly bleeding cash.
- Valuation method matters. FIFO, LIFO, and weighted-average costing all produce different COGS and ending inventory figures, especially during periods of price inflation. Comparing your ratio to a competitor using a different method isn't apples-to-apples.
- It says nothing about margin. A business can have excellent turnover and still be unprofitable if it's discounting heavily to move product. Pair turnover with gross margin to get the full picture — fast-but-thin and slow-but-fat are both real business models.
- Seasonality distorts single-period snapshots. A landscaping supply company measured only at year-end will look very different from one averaged across all twelve months. Use monthly or quarterly averages whenever the business has a real seasonal cycle.
How to Improve a Weak Ratio
If your turnover is trailing your industry, the fixes are usually operational rather than financial:
- Run an ABC analysis. Rank inventory by revenue contribution and apply different reorder discipline to your top sellers versus your long tail — don't manage a $50,000-a-year product the same way you manage a $500-a-year one.
- Clear dead stock deliberately. A markdown that recovers 60 cents on the dollar today is usually better than a write-off that recovers nothing next year, and it frees up cash and shelf space immediately.
- Tighten reorder points using actual sell-through data, not gut feel or last year's purchase order copied forward.
- Negotiate smaller, more frequent shipments with reliable suppliers instead of large infrequent ones — it raises turnover and lowers the amount of capital sitting in transit or storage at any moment.
- Track it monthly, not annually. A ratio computed once a year tells you what already happened. Monthly tracking catches a slowdown while there's still time to act on it.
Keep Your Books Ready to Answer the Question
Calculating inventory turnover accurately depends on having clean, consistent numbers for cost of goods sold and inventory value on hand — not a spreadsheet reconstructed from memory at tax time. Beancount.io gives you plain-text, version-controlled accounting where every inventory purchase and cost-of-goods-sold entry is fully auditable, so ratios like this one are a quick query away rather than a weekend project. Get started for free and see why developers and finance-minded owners are switching to plain-text accounting.