Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
What is inventory turnover?
inventory management

What is inventory turnover?

Tracking your inventory is the first step to understanding your business trends.

You can’t get a complete pulse on your inventory, though, without knowing the rate at which your products are sold during any given month, quarter or year. This is your inventory turnover. By knowing this metric, you can better determine when it’s time to order new items and develop a stronger picture of the way items move through your business.

What does your inventory turnover mean?

Turnover is the rate at which you need to replace your inventory. Return on assets (ROA) is the money you receive in exchange for the items you sell. Your inventory ratio can help you figure out your ROA and give you an idea of the profitability.

Simply sell your inventory at a good rate, make a profit and then see a good return.

When you have items on hand for a lower number of days, it’s usually an indication that you have strong sales, or that you’ve priced items with a huge discount to sell them quickly.

When your inventory turnover is low, it usually means weak sales. If you can pinpoint the reason your sales are weak and your turnover is low, it can help you make adjustments. Maybe a product is out-of-date, flawed or not in trend. Take steps to liquidate the asset so you can replace it with something else.

How to determine inventory turnover

There are two main methods used to figure out the inventory turnover ratio. Both approaches can provide you with insight, though they have different purposes.

How to calculate:

Method 1:

Sales ➗ your average inventory.


Method 2:

Cost of goods sold ➗ your average inventory.

To calculate the average inventory, combine your beginning and ending inventory amounts for a given time period. Then divide that figure by two.

Inventory Turnover Calculator 


QuickBooks' Inventory Turnover Calculator can be used to calculate the ratio of inventory turnover. This ultimately gives you a measure of your company's success in converting inventory to sales. 


There are four main values you must enter into the calculator:


  • Input the cost of goods sold - multiply the cost of goods produced by the number of units sold in the preceding accounting period. You can also use the QuickBooks COGS calculator to determine this value. 
  • Enter the beginning inventory value for the selected accounting period. 
  • Input the ending inventory value at the end of the preceding accounting period. 
  • Lastly, input the number of days in your financial year.


Based on the above inputs, the QuickBooks online calculator will give you the ratio of inventory turnover in seconds. Our calculator is simple, and self-explanatory – giving you accurate calculations effortlessly. This valuable online tool is guaranteed to save you time and effort, which is something every business needs. 

Grow Your Business with QuickBooks

Applying the formulas

Let’s say you are a company with $2 million in sales for the year, and your cost of goods sold is $700,000. You have an average inventory of $50,000. Using this information, you can use both inventory turnover formulas to get an idea of where you stand.

Method 1:

$2,000,000 ➗ $50,000 = 40

This means your inventory turnover is about 40 times per year. If you want to break it down to see how many days you have the inventory on hand, divide that by 365. You’ll come up with a little more than nine days—meaning products sit on the shelf for about nine days before they are purchased.

Pros:

  • Easy to calculate.
  • Gives an overall picture of the inventory and turnover.

Cons:

  • Includes your sales, which means the markup is counted into the calculation.
  • Doesn’t account for seasonal cycles.

Method 2:

$700,000 ➗ $50,000 = 14

This means you’ll see an inventory turnover 14 times a year. If you want to determine what that means in days, divide by 365. You’ll discover you have inventory on hand for about 26 days.

Pros:

  • More accurate.
  • Better accounts for seasonality.
  • Does not include markup.

Cons:

  • Requires more details to calculate.

What does this mean?

If you have items on hand for a long period of time, it might be an indication that you need to change your approach. On the other hand, if you have a high turnover, that is often an indication that your products are in demand. If your turnover seems unusually high, this could be a clue that you are pricing your products too low and need to adjust the price so that you can increase your profit margins.

As you pay attention to your turnover, you will eventually get a feel for what the numbers tell you and be able to adjust your business accordingly.


Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Stay up-to-date with the latest small business insights and trends!


Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A happy small business owner signing up for the QuickBooks newsletter on laptop