Inventory turnover ratio tells you how many times you sold through and replaced your stock in a period. It is the single fastest read on whether your cash is working or sitting on a shelf.
The inventory turnover ratio measures how many times a business sells through and replaces its entire inventory over a period, usually a year. A turnover of 6 means you cycled your whole inventory six times in twelve months, roughly once every two months. A turnover of 2 means your stock sat for half a year on average before selling.
It is a measure of velocity, not profit. High turnover means inventory is moving and your cash is not trapped on shelves. Low turnover means capital is locked in stock that is not selling, which carries holding costs, ties up cash you could spend on ads or new SKUs, and raises your risk of markdowns and dead stock.
There are two common versions. Use the COGS-based one for accounting accuracy.
| METHOD | FORMULA | WHEN TO USE |
| COGS-based (preferred) | COGS / Average inventory at cost | Financial analysis, period close |
| Sales-based | Net sales / Average inventory | Quick estimate, retail context |
The COGS-based version is the correct one for bookkeeping because both the numerator and denominator are stated at cost, so you are comparing like to like. The sales-based version mixes a retail figure (sales) with a cost figure (inventory), which inflates the ratio and makes it useless for comparison.
Average inventory is the inventory value at the start of the period plus the value at the end, divided by two. Using a simple average smooths out the distortion you get from picking a single snapshot, which can land on an unusually high or low day.
Say your COGS for the year was $600,000. Your inventory was worth $120,000 in cost at the start of the year and $80,000 at the end.
Average inventory = ($120,000 + $80,000) / 2 = $100,000.
Inventory turnover = $600,000 / $100,000 = 6.0.
You turned your inventory six times. To translate that into days, divide 365 by the turnover: 365 / 6 = roughly 61 days. On average a unit sat about two months from arrival to sale. That figure, days inventory outstanding, is often more intuitive for operators than the raw ratio.
There is no universal target. The right number depends on your category, your margins, and your supply lead times. A few realistic ranges, as of 2026:
The trap is chasing a benchmark blindly. Very high turnover can signal you are understocking and losing sales to stockouts. Very low turnover signals trapped cash and markdown risk. The useful move is to track your own ratio over time and per SKU, then ask why the slow ones are slow.
Inventory turnover is really a cash flow metric in disguise. Every dollar sitting in unsold inventory is a dollar you cannot spend on advertising, a new product, or paying yourself. A seller turning inventory twice a year has roughly six months of cash locked up at any moment. A seller turning it eight times has about six weeks locked up. Same revenue, very different cash position.
This is why turnover pairs with the sell-through rate (/glossary/sell-through-rate) and reorder planning. Turnover tells you the overall velocity; sell-through tells you how a specific batch is moving within a window; reorder logic uses both to decide when to buy more without overbuying.
For a multi-channel seller, the ratio is only as good as the inventory figure feeding it. If your average inventory ignores stock at a 3PL or in transit, the denominator is understated and the ratio is overstated, making you look more efficient than you are. To compute turnover correctly you need total inventory at cost across every location, FBA, 3PL, your own warehouse, and in transit, valued under a consistent costing method like FIFO.
ConnectBooks computes this base for you. ConnectStock, its multi-location inventory feature, tracks units and FIFO cost across all locations and feeds the inventory asset and COGS into QuickBooks or Xero, so the turnover ratio you pull is built on a reconciled number rather than a partial one. ConnectStock is bundled with Platinum and available as an add-on on Gold and Diamond.
It depends on category and margin, but many general ecommerce sellers land between 4 and 8 as of 2026. Low-margin fast movers run higher; high-margin or seasonal goods can be healthy lower. Track your own trend rather than chasing an absolute number.
Use COGS divided by average inventory at cost. Both figures are then stated at cost, which makes the ratio accurate and comparable. The sales-based version mixes retail and cost values and overstates the result.
Divide 365 by the turnover ratio. A turnover of 6 equals about 61 days inventory outstanding, meaning a unit sat roughly two months on average before selling. Operators often find the days figure easier to act on.
It should. All inventory you own counts, no matter where it sits. Excluding 3PL or in-transit stock understates your average inventory and overstates turnover, flattering your efficiency. Use a total inventory figure across all locations.
Turnover measures how many times you cycle your entire inventory over a full period, usually a year. Sell-through rate measures the percentage of a specific batch sold within a shorter window, often a month. Turnover is the macro velocity; sell-through is the per-batch read.
Pull a reconciled turnover ratio without rebuilding the spreadsheet every month. See ConnectStock at /pricing.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
