What is inventory turnover ratio? It is the cost of goods sold during a period divided by the average inventory value for the same period. If a shop sold goods that cost it $18,000 and held $6,000 of inventory on average, its inventory turned over three times in that period. The ratio gives an owner a way to compare how much stock the shop carries with how quickly it sells at cost. Start by choosing the period and the product group you want to understand.
What is inventory turnover ratio?
Inventory turnover compares the cost of stock sold with the cost of stock held on average. The result is expressed in turns for the period. A quarterly figure of three turns describes the quarter. Write the period beside the number so a reader can distinguish it from three turns in a month or year. The Shopify inventory turnover guide explains the calculation and why the context depends on what you sell.
You can calculate turnover for the whole shop or a group of products, as long as the numerator and denominator cover the same items. For example, if you are reviewing stationery, pull the cost of stationery sold and average inventory value for stationery. A total for the whole shop on one side of the division would make the answer hard to interpret. Keep the category name and date range on the worksheet so you can repeat the calculation later.
Why it works
Dividing cost of goods sold by average stock puts both amounts on the same cost basis. A shop can sell a product at a different price during a promotion while the unit cost stays the same. An inventory balance valued at cost should be compared with the cost of the goods sold. Using selling prices for one side and costs for the other would make a high markup look like faster stock movement in the calculation.
Average inventory approximates the amount of money tied up in merchandise. The simplest average uses the opening and closing values. Say a shop opens the quarter with $5,000 of inventory and closes with $7,000. The midpoint is $6,000. That works as a simple calculation, but consider whether those two dates describe the period fairly. If a large delivery arrived midquarter and most of it sold before closing, the two endpoint snapshots would miss that stock. When practical, use comparable values from more dates and record how you calculated the average.
Turnover is a period measure. It can tell you that one group of goods moved through the shop at a different rate from another group. To decide what to order today, you still need the quantity you have and how soon replacement stock can arrive. A shop can have high turnover in a category and still be short of a particular size, color or pack. The ratio helps you choose where to look. The individual stock records help you decide what to do there.
How to calculate inventory turnover step by step
1. Choose a period
Pick a month, quarter or year and mark the exact start and end dates. For the worked example, use a single quarter. If you want to track how the number changes, repeat it over another quarter of the same length. A month with a holiday rush and a slower month can both be worth measuring if you describe the difference in trading conditions.
2. Define the stock you will include
Choose the whole shop or a specific category. Write down whether the calculation includes items stored away from the floor. If the stock held at another location is included in the beginning and ending values, make sure the cost of goods sold reflects the corresponding sales. If a product moved between locations, check how your records represent the transfer before treating a disappearing quantity as a sale.
3. Find the cost of goods sold
In the example, the goods sold during the quarter cost the shop $18,000. Use the cost value from the records covering the quarter, taking account of returns as recorded in those records. A daily sales report gives you the transaction history to work from, while the inventory valuation or bookkeeping records can supply the cost information. If a product cost changed during the period, use the treatment already reflected in those records.
4. Calculate average inventory at cost
Add the opening inventory of $5,000 to the closing inventory of $7,000, then divide by two. The average is $6,000. Carry the cost basis into both values. For example, if there are ten notebooks costing $3 each, they contribute $30 to the stock value even if the shelf price is $5 each. The stock take guide explains the quantity check that can support an inventory snapshot.
5. Divide and label the result
Divide $18,000 by $6,000. The result is 3 turns for the quarter. Enter the original figures and the result in one row of a worksheet. If average inventory is zero, the ratio is undefined. Check whether a stock snapshot is missing, the category boundary is wrong or no inventory was held. A zero denominator needs an explanation in the worksheet.
6. Compare the result with shop records
Suppose the following quarter also shows $18,000 of goods sold at cost, but average stock rises to $9,000. The ratio falls to 2 turns. The two examples have the same cost of sales. The second shop period carried more stock on average. Check whether that was prompted by a large order, longer supplier lead time or poor sales in a subset of the category. If a single product is behind the extra stock, a whole-shop ratio can make the change appear smaller than it feels on the shelf.
One useful follow-up is to compare the stock value with a physical count for the products you plan to review. If several records are stale, update the snapshot first. Write down any adjustment so a later comparison of periods can use the corrected figures.
Common mistakes
Using sales revenue in the numerator. A till report might show $25,000 in revenue while your cost of goods sold is $18,000. Dividing the larger figure by inventory at cost produces a different number. Check what the field represents, label it on the worksheet and use the matching cost value before comparing quarters.
Treating every category like it should turn at the same speed. An item that customers need frequently may move differently from a seasonal item or an item the shop intentionally offers in many sizes. Begin with a comparison to that category's own earlier periods and review the changes in availability and sales. Ask what the owner was trying to achieve with the stock that was available.
Using a higher ratio as proof that stock levels are right. A category can turn quickly while its most popular items run out. For goods you intend to keep on the shelf, compare the turnover result with stockouts and replenishment records. The Cela retail blog has more examples of routines for reviewing sales and stock at the item level.
Changing the method between periods. A figure based on two month-end readings may differ from one based on weekly averages. Keep a note of the dates and method. If you change your averaging method, calculate both comparison periods on that basis where the records allow. The owner should be able to tell whether the difference comes from the business or the worksheet.
How Cela can help
Cela provides sales tracking, stock level management and low-stock alerts. Use your sales and stock records to identify the category you want to review and check whether the period includes a large stock movement. Calculate turnover from the cost figures in your own worksheet or bookkeeping records. If the figure changes, return to individual products to see whether some sold through quickly while others accumulated. For an item that keeps running out, write down how many were available and when a replacement delivery arrived so you can investigate the pattern.
Conclusion
Calculate turnover with the cost of goods sold divided by average inventory at cost for the same period and product group. Keep the figures, dates and averaging method with the result. A change can point to more stock on hand, a shift in sales or both. Check individual product records before using the result to change an order. That extra step tells you whether the category figure reflects many products or one item that needs attention.
Frequently asked questions
Is inventory turnover based on revenue or cost?
Use the cost of goods sold when the inventory balance is valued at cost. Revenue includes the selling price and may reflect different markups. Keeping both amounts on the same cost basis makes the ratio easier to compare.
How do you calculate average inventory?
Add beginning and ending inventory at cost, then divide by two. If these dates do not represent your typical inventory, average comparable snapshots from more dates. Use a consistent method when comparing periods for the same category.
What does three turns in a quarter mean?
The cost of goods sold during the quarter was three times the average amount of inventory held at cost. The result describes the period and group used for the calculation. Individual products can move much faster or slower.
What if average inventory is zero?
With a zero denominator, the ratio is undefined. Check that the inventory values and sales cover the same dates and products. Missing snapshots or category assignments can produce that result, so keep a note of what you find.



