Inventory turnover is cost of goods sold divided by average inventory at cost, measured over one fixed window. Six steps get you there: set the window, pull cost of goods sold, then record beginning and ending inventory. Average those two, divide, and convert the result to days sales of inventory.
That last conversion is the step most retailers skip, and it's the only one that changes what you do on Monday.
Key Takeaways
- Inventory turnover equals cost of goods sold divided by average inventory at cost, over the same window for both inputs.
- Average inventory equals beginning inventory plus ending inventory divided by two, with both figures valued at cost.
- Days sales of inventory equals 365 divided by the turnover ratio, the days an average dollar of inventory sits unsold.
- Using sales revenue instead of cost of goods sold inflates the ratio by the size of your gross margin.
- Clothing and clothing accessory stores carried an inventories to sales ratio of 2.11 in May 2026, per U.S. Census Bureau data.
- Blended store turnover hides category problems, so calculate turnover per category before you place the next buy.
- A turnover ratio becomes useful the moment you compare days sales of inventory against your vendor payment terms.
What You Need Before You Start Calculating Inventory Turnover
You need four numbers and one habit. The numbers are cost of goods sold for a window, plus inventory value at cost on the window's first and last days. The fourth is a unit cost recorded on every SKU you sell.
The habit is picking one valuation method and holding it. If beginning inventory uses average cost and ending inventory uses last invoice price, the ratio spans two different books. Our guide to 7 Best Inventory Valuation Methods for Independent Retailers covers which one fits which store.
Turnover measures how fast cash moves through the back room, the space between the receiving door and the register where inventory waits. Everything you buy passes through it. Some of it never leaves.
Where the four numbers live in a typical store
Shopify stores find inventory value in the month-end inventory value report. It totals available inventory on products carrying a Cost per item value. Products missing that field drop out of the total, which is where most bad turnover numbers begin.
Square sellers on the Retail Plus and Premium plans get a Cost of goods sold report under Inventory Reports. That report shows cost of goods sold, total revenue, profit, and profit margin together. Lightspeed Retail X-Series users pull the equivalent from inventory valuation reporting.
Everyone else uses a spreadsheet, and a spreadsheet is fine. Two exports contain every input in this article: an item-level catalog with unit costs, and a sales export for the window.
If you'd rather see the answer than build the sheet, start with the free inventory cash calculator. It asks a few questions about your store and returns a directional range. No card, no clock.
The 6 Steps to Calculate Inventory Turnover
Work these in order. Each step produces a figure the next step consumes. Skip ahead and you get a ratio you can't defend to your accountant.
Step 1. Lock the measurement window before you pull a single number
Pick a start date and an end date, write them down, and use them for every input that follows. Twelve months gives you an annual turnover figure that compares cleanly to last year.
A season gives you something better: a figure you can act on while the buy is still open. For the worked example below, the window runs August 1, 2025 to July 31, 2026.
The common failure here is a mismatch nobody notices. A twelve-month cost of goods sold figure paired with today's inventory count produces a ratio that describes no period at all.
Step 2. Pull cost of goods sold for that exact window
Cost of goods sold is what you paid vendors for the units that sold inside the window, freight in, before any markup. It's a cost figure, and it belongs in the numerator.
Revenue overstates turnover by exactly the size of your gross margin. A store at 52% gross margin that uses revenue will report roughly double its real turn, then buy accordingly.
Worked figure: the example boutique's cost of goods sold for the twelve-month window is $412,000.
Operator Tip: Audit the cost field before you trust the report
Sort your product list by unit cost and filter for blanks. Every SKU with an empty cost field drops out of inventory value totals. That shrinks your denominator and flatters your ratio.
Fixing 40 blank cost fields takes an afternoon. It changes the number more than any formula refinement will.
Step 3. Record beginning and ending inventory at cost
Beginning inventory is the value of on-hand stock at cost on day one of the window. Ending inventory is the same measurement on the final day.
Count the ending figure physically where you can. A system count reflects what the software believes, and a physical count reflects what's on the shelf. The gap between them is shrinkage plus receiving errors.
Worked figures: beginning inventory $138,000, ending inventory $166,000.
That $28,000 increase is the first real signal in the calculation. The store bought more than it sold, and the difference went into the back room.
Step 4. Calculate average inventory for the window
Add beginning and ending inventory, then divide by two. For the example: ($138,000 + $166,000) / 2 = $152,000.
The two-point average is standard and it's what your accountant will expect. It also has a known weakness, which is blindness to anything that happened between the endpoints.
A store that peaked at $240,000 in November and bottomed at $110,000 in February averages $152,000. A store that sat flat all year reports the same figure. Those are different businesses with different cash problems.
| Averaging method | Inputs required | When to use it |
|---|---|---|
| Two-point average | Beginning and ending inventory at cost | Annual reporting, first calculation, reconciling with an accountant |
| Thirteen-point average | Twelve month-end snapshots plus the opening value | Seasonal stores, any window containing a holiday peak |
| Weekly average | 52 weekly inventory values at cost | Category-level analysis during an active buying season |
If your point of sale keeps month-end snapshots, use the thirteen-point average. Shopify's month-end inventory value report generates exactly those values with no extra work.
Step 5. Divide cost of goods sold by average inventory
Inventory turnover = cost of goods sold / average inventory at cost. For the example: $412,000 / $152,000 = 2.71.
The ratio means the store's average inventory position cycled through the building 2.71 times in twelve months. Sell-through answers a different question, namely the share of units received that sold in a period.
Both matter. Turnover tells you how hard your cash is working, and sell-through tells you how well a specific buy performed.
Step 6. Convert the ratio to days sales of inventory and attach a cash decision
Days sales of inventory is 365 divided by the turnover ratio. It's the average number of days a dollar of inventory sits before selling. For the example: 365 / 2.71 = 135 days.
Now the number does work. Compare 135 days against your vendor payment terms.
If you pay net 30 and hold stock for 135 days, your own bank account covers the other 105. Rent, payroll, and next season's deposit all come out of that account during those 105 days.
That comparison is the whole point of the exercise. A ratio you record and file is a number. A ratio you set against your terms is a buying decision.
Your Turnover Ratio Says 2.71. Your Outerwear Rack Says 384 Days.
Take an illustrative example: a 1,400-square-foot women's apparel boutique on a main street, single location, $9,200 in monthly rent. The figures below are constructed to demonstrate the method, and no real client store appears in them.
| Input | Value | Source in the store |
|---|---|---|
| Window | Aug 1, 2025 to Jul 31, 2026 | Fiscal year, set in Step 1 |
| Cost of goods sold | $412,000 | Point of sale cost report |
| Beginning inventory at cost | $138,000 | Physical count, Aug 1, 2025 |
| Ending inventory at cost | $166,000 | Physical count, Jul 31, 2026 |
| Average inventory at cost | $152,000 | Step 4 calculation |
| Inventory turnover | 2.71 | $412,000 / $152,000 |
| Days sales of inventory | 135 days | 365 / 2.71 |
An owner looking at 2.71 turns and 135 days would call that unremarkable for apparel and move on. Then you split it by category.
| Category | Cost of goods sold | Average inventory | Turnover | Days sales of inventory |
|---|---|---|---|---|
| Tops | $154,000 | $34,000 | 4.53 | 81 days |
| Denim | $96,000 | $22,000 | 4.36 | 84 days |
| Accessories | $104,000 | $35,000 | 2.97 | 123 days |
| Outerwear | $58,000 | $61,000 | 0.95 | 384 days |
| Store total | $412,000 | $152,000 | 2.71 | 135 days |
Outerwear turns 0.95 times a year. The store holds $61,000 at cost in a category that consumes $58,000 of cost of goods sold across twelve months.
Against $9,200 in monthly rent, that outerwear position equals about six and a half months of rent, parked on a rack. Tops and denim funded it the entire time, and the blended ratio of 2.71 said nothing.
Key Data Point: $61,000 held, 384 days to move
A category turning 0.95 times a year holds its own cost of goods sold in stock at any moment. In the example above, that's $61,000, or roughly six and a half months of a $9,200 rent payment.
You can size the same figure for your own store without building a spreadsheet. The free Cash Margin Partners workspace can return an eligible-SKU view after a successful supported import with sufficient sales and cost evidence. Direct-connection timing and history vary by provider, production launch status, and workspace eligibility; compatible item-level uploads remain available after column review.
What Counts as Good Inventory Turnover for Retail
Good inventory turnover for retail is category-specific, and any single benchmark quoted without a category attached is noise. Grocery turns dozens of times a year and furniture turns two or three.
The most defensible public benchmark comes from the U.S. Census Bureau. Total retail trade carried a seasonally adjusted inventories to sales ratio of 1.25 in May 2026, against $832.4 billion in retail inventories.
For apparel specifically, clothing and clothing accessory stores sat at 2.11 in the same month, seasonally adjusted. Divide 12 by that ratio and you get roughly 5.7 implied turns a year.
Why the Census ratio runs higher than your own turnover number
The Census figure divides inventories held at cost by sales measured at retail. Your turnover ratio divides cost by cost, so the two comparisons run on different scales.
To translate, multiply the implied Census turns by your cost of goods as a share of revenue. A boutique running 52% gross margin has a 48% cost share, so 5.7 becomes about 2.7 comparable turns.
The example store at 2.71 sits right at the national apparel line. Its outerwear rack at 0.95 sits nowhere near it, and that gap is the comparison that should change a buy.
Key Insight: Compare against yourself before you compare against the country
The most useful benchmark for an independent store is the same category, same window, last year. National ratios blend chains with 40 years of allocation systems into the same average as a single-location boutique.
Year-over-year category turnover answers the question you can act on. Is this category getting faster or slower with the money you've given it?
Common Mistakes at Each Step
Every step in this calculation has one characteristic failure. The table below names each one and the direction it pushes your ratio.
| Step | Common mistake | Effect on the ratio | Fix |
|---|---|---|---|
| 1. Set the window | Annual cost of goods sold paired with today's inventory count | Unpredictable, often overstated | Write the two dates down first and pull every input inside them |
| 2. Pull cost of goods sold | Using sales revenue in the numerator | Overstated by the full gross margin | Pull the cost report, then confirm the total against vendor invoices |
| 3. Record inventory | Blank unit cost fields excluded from the value total | Overstated turnover, understated inventory | Filter for missing costs and backfill before running the report |
| 4. Average inventory | Two-point average across a heavy seasonal peak | Understated inventory, overstated turnover | Use thirteen month-end snapshots for any window with a holiday |
| 5. Divide | Reporting only the blended store figure | Accurate but unusable | Repeat the division for every category and every vendor |
| 6. Convert to days | Recording days sales of inventory with no comparison | No effect on the math, no effect on the store | Set the day count against vendor terms and your rent |
The two mistakes that cost real money
Blank cost fields are the most expensive error in this list because they're invisible. The report runs, returns a clean total, and leaves out every SKU that has no cost attached.
Reporting only the blended figure is the second. A store average of 2.71 turns is a fact about arithmetic. A category at 0.95 turns is a fact about $61,000.
Both errors point toward a ratio that looks healthier than the bank balance suggests. Our Definitive Guide to Excess Inventory: Causes, Costs, and Recovery covers what happens after you find the slow category.
How to Check Your Work
Four checks will catch nearly every error in a hand-built turnover calculation. Run them before you show the number to anyone.
Check 1: Multiply turnover by days sales of inventory
Turnover multiplied by days sales of inventory should return 365 for an annual window. In the example, 2.71 x 135 = 365.9, which is rounding and nothing more.
A result far from 365 means one of the two figures used a different period length than the other.
Check 2: Reconcile category totals against the store total
Your category cost of goods sold figures must sum to the store figure, and the same holds for average inventory. In the worked example, $154,000 plus $96,000 plus $104,000 plus $58,000 equals $412,000.
When categories fail to sum, the usual cause is SKUs with no category assigned. Those items exist in your cost totals and vanish from your category view.
Check 3: Test the ratio against the national line
Take the Census implied turns for your category and multiply by your cost of goods share of revenue. Check whether your figure lands in the same neighborhood. A store reporting 11 turns in apparel has a numerator problem.
Direction is what this check provides. Treat it as a smell test rather than a grade.
Check 4: Ask whether the number changed a decision
A turnover calculation that produced no change to a buy, a markdown, or a reorder quantity was an accounting exercise. The purpose of the ratio is to redirect cash toward categories that return it faster.
The 2026 Report on Employer Firms from the Federal Reserve Banks found that 56% of firms seeking financing did so to meet operating expenses. That finding rests on 6,525 responses collected between September and November 2025. Turnover is one of the few metrics that speaks to that pressure.
Where the Calculation Goes After the Spreadsheet
Cash Margin Partners is an inventory cash-recovery practice for independent, owner-operated retailers. CMP shows you how much cash is trapped in unsold inventory, then gives you a prioritized plan to get it back. Turnover is one input into that analysis.
The manual method in this article works. It stops working around the point where you want category turnover refreshed weekly across 900 SKUs. That's a maintenance job, and maintenance jobs lose to store hours every time.
"So you want me to connect my point of sale when I can compute turnover by hand?" The formula remains yours. The connected workspace supplies SKU classifications, category and vendor breakdowns, and stalled-inventory dollars that help you decide where to apply it.
Where production launch status and workspace eligibility permit, Cash Margin Partners reads catalog, inventory, and sales data through Shopify, Square, and Lightspeed Retail X-Series. Shopify supplies unit cost when available; Square and Lightspeed analyses add costs through CMP's prefilled template. Compatible item-level exports support other systems after column review.
After a recent successful supported live connection has supplied sufficient usable history and cost evidence, the predictive layer can add 30-, 60-, and 90-day cash-at-risk forecasts. The model projects those from the imported evidence. Forecasts are forecasts, and no appraisal of your stock is involved.
Start Here: Your First Turnover Calculation This Week
- Today: open your product list, sort by unit cost, and count the SKUs with a blank cost field. That count caps how good any turnover number can be.
- Today: run the free inventory cash calculator for a directional questionnaire-based read on trapped cash before you build anything.
- This week: pull cost of goods sold and both inventory values for a twelve-month window, then complete Steps 4 through 6 by hand.
- This week: repeat Steps 2 through 6 for your four largest categories and rank them by days sales of inventory.
- Before the next buy: take the slowest category and decide on markdown, bundling, or exit. 6 Established Places to Sell Excess Inventory and One Proposed CMP Option covers the exit routes.
Frequently Asked Questions
What is the inventory turnover formula?
The inventory turnover formula is cost of goods sold divided by average inventory at cost, over one fixed window. Average inventory is beginning inventory plus ending inventory divided by two. A store with $412,000 in cost of goods sold and $152,000 in average inventory turns 2.71 times.
What is a good inventory turnover ratio for an independent retailer?
A good inventory turnover ratio depends on the category, and apparel sits far below grocery. Clothing and clothing accessory stores carried an inventories to sales ratio of 2.11 in May 2026, per U.S. Census Bureau data. That implies roughly 5.7 sales-based turns a year before markup adjustment.
The comparison that matters most is your own store measured against the same window last year.
Should I use cost of goods sold or sales revenue in the inventory turnover formula?
Use cost of goods sold. Sales revenue includes your markup while inventory is carried at cost. A revenue-based ratio inflates the result by the size of your gross margin.
How do I calculate days sales of inventory from turnover?
Divide 365 by the inventory turnover ratio to get days sales of inventory. A turnover of 2.71 becomes 135 days, or about four and a half months per dollar of inventory. For a seasonal window, divide the number of days in that window instead of 365.
How often should an independent retailer calculate inventory turnover?
Calculate blended store turnover once a quarter and category turnover monthly during the buying season. Category turnover is the figure that changes buying decisions. A healthy store average can hide a category sitting below one turn a year.
Can I calculate inventory turnover without a point of sale integration?
Yes, with a spreadsheet. Inventory turnover needs cost of goods sold for a window plus inventory at cost on the first and last days. Cash Margin Partners accepts compatible item-level uploads after column review. Direct Shopify, Square, and Lightspeed availability depends on production launch status and workspace eligibility.
Does a high inventory turnover ratio always mean the store is healthy?
No. Turnover rises when inventory falls, and a store that stopped buying posts a strong ratio while running out of best sellers. Read turnover alongside stockout frequency and gross margin return on investment before you draw a conclusion.
Shopify stores can compare reporting options in 7 Best Shopify Inventory Report Apps.
Run the Six Steps, Then Look at the Slowest Category
The six steps take an afternoon and give you a defensible ratio. The category split takes another hour and gives you a dollar figure with a rack attached to it.
The back room sends no invoice. It holds your money until you go get it.
Start with the free trapped-cash workspace. Use an eligible production connection or a compatible item-level upload, then review the result after the import succeeds with sufficient history and cost evidence.