---
title: "Inventory Turnover Explained: Formula and Examples | MCC"
description: "How to calculate inventory turnover and days on hand, what the numbers say about cash and stockouts, and how to use them without false comparisons."
url: "https://mcc-solutionsnj.com/bookkeeping/guides/inventory-turnover-explained"
---

Bookkeeping guide · Updated October 23, 2026

# Inventory Turnover Explained: Formula and Examples

Inventory ties up cash. Turnover shows how fast that cash comes back, by measuring how many times you sell through your stock in a period. This guide explains the formula, walks through an example, and shows how to read the result without being misled.

By [Matthew Coleman](/about), MCC Solutions

**Quick answer.** Inventory turnover equals cost of goods sold divided by average inventory. With $60,000 of cost of goods sold and inventory going from $10,000 to $14,000, average inventory is $12,000 and turnover is five.

Want this handled for you?

Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books.

[Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest)

**Related:** [Trial balance explained](/bookkeeping/guides/trial-balance-explained) · [Owner contribution or loan](/bookkeeping/guides/owner-equity-and-capital-contributions) · [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings)

**Free tools:** [Price per unit calculator](/bookkeeping/price-per-unit-calculator) · [How many sales do I need to break even?](/bookkeeping/break-even-calculator)

[Calculate yours with the inventory turnover calculator](/bookkeeping/inventory-turnover-calculator).

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software)

## The formula

Inventory turnover equals cost of goods sold divided by average inventory. Average inventory is the value at the start of the period plus the value at the end, divided by two. If your cost of goods sold for the year is $60,000 and your inventory went from $10,000 to $14,000, the average is $12,000 and turnover is five.

That means you sold through your stock about five times in the year.

## Days of inventory on hand

Divide the days in the period by the turnover to see how long a typical item sits before it sells. Using 365 days and a turnover of five gives about 73 days.

Days on hand is often easier to act on than a ratio. It translates directly into how much cash is sitting on shelves and how far ahead you are buying.

## Why use cost, not sales

Inventory is recorded at cost, so cost of goods sold is the matching figure. Using sales instead would mix in your markup and overstate turnover. Make sure your cost of goods sold includes only what you actually sold, and that your inventory count is accurate, since a miscounted shelf distorts everything.

If your books record inventory only at year end, calculate with year-end values, and use a physical count for the number.

## Reading the number

Higher is not always better. A high turnover can mean efficient buying, or it can mean you often run out of popular items and lose sales. A low turnover ties up cash and risks items going stale, damaged or out of style.

There is no single right answer. Compare your number to your own past periods and to businesses that sell similar goods, and look at it by product category when you can, because a few slow items often hide behind a healthy average.

## A worked example by category

Suppose a shop sells three kinds of goods. Seasonal gifts turn four times a year, everyday supplies turn twelve times, and a line of specialty items turns only once. The blended average looks fine, but the specialty line holds a large share of the cash for a full year.

Looking at turnover by category shows where to cut buying, where to reorder sooner and where a higher margin justifies the slower pace. Check each line on a regular schedule, and recount stock before making big decisions.

## What to do with it

If days on hand is growing, check for overbuying, slow sellers and items bought in bulk for a discount that never paid off. Consider clearance pricing, bundles or smaller, more frequent orders.

If stockouts are the problem, look at reorder points for your fastest sellers. Pair turnover with gross margin, because a slow item with a high margin can still be worth carrying. A free calculator can speed up these comparisons across periods.

## Common questions

**Can service businesses use inventory turnover?**

Not usually. It applies to businesses that hold goods for sale. Service businesses can look at receivables and billable time instead.

**Which inventory method should I use?**

Use the method your books and tax filings already follow, and keep it consistent. Ask your tax preparer before changing it.

**How often should I calculate it?**

Monthly or quarterly is common, and it matters most before big buying seasons.

This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation.

Let us handle it

 [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/)
 [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online)[### Square, Stripe and payment processors How sales from Square, Stripe, PayPal and other processors should flow into your accounting software, and why deposits never match sales. Square & Stripe →](/bookkeeping/software/square-and-stripe)

More guides

- [How to Calculate Sales Commission: Flat and Tiered](/bookkeeping/guides/how-to-calculate-sales-commission)
- [How to Calculate a Business Loan Payment and Interest](/bookkeeping/guides/how-to-calculate-a-business-loan-payment)
- [How to Add or Remove Sales Tax From a Price](/bookkeeping/guides/how-to-add-or-remove-sales-tax-from-a-price)
- [Working Capital Explained: Formula, Example and Uses](/bookkeeping/guides/working-capital-explained)

Free tool

- [Bookkeeping health check](/bookkeeping/health-check)

 [All guides](/bookkeeping/guides)

Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping).

Do it yourself

### Inventory Tracker and Reorder Workbook

Log what comes in and goes out and see what you have, what it is worth, what to reorder and what has not sold.

[See what's inside ($34)](/toolkits/inventory-tracker-reorder-workbook)14-day full refund

[![Cover of Bookkeeping Fundamentals (ebook) by Matthew Colt](/img/toolkits/bookkeeping-fundamentals-ebook/cover.webp)](/toolkits/bookkeeping-fundamentals-ebook)

From the bookshelf

### Bookkeeping Fundamentals

A college-level bookkeeping course, without the tuition. By Matthew Colt, $9.99 as an ebook (EPUB and PDF).

[See the book](/toolkits/bookkeeping-fundamentals-ebook) [Read the first pages free](/toolkits/bookkeeping-fundamentals-ebook#free-starter)

Excel workbook

### Inventory Tracker and Reorder Workbook

Log what comes in and goes out and see what you have, what it is worth, what to reorder and what has not sold.

[See what is inside ($34)](/toolkits/inventory-tracker-reorder-workbook)

Also in the [Product Seller Bundle](/toolkits/product-seller-bundle): 3 products for $65 instead of $82 separately.

Tallyfinch

### Books you keep on your own computer

Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries.

[See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software)

## Rather have us keep the books? Ask for a quote.

[Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)
