The inventory turnover ratio tells you how many times your shop sells through its average stock in a year. It is one of the simplest numbers a retailer can calculate, yet many shop owners in India never look at it. They watch daily sales and the cash drawer, but not how long money sits on the shelf as unsold goods. This guide explains the formula, how to convert it into “days of inventory”, how to read the result for different kinds of shops, and what to do about items that turn too slowly.
You do not need an accountant or a spreadsheet expert. If you know your opening stock, closing stock and cost of goods sold, you can work out the ratio in five minutes. If your billing software records purchases and sales item by item, you can go further and find the exact products that are slowing your business down.
What the inventory turnover ratio actually measures
Every rupee you spend on stock is a rupee that is not in your bank account. Until that stock is sold, it cannot pay rent, salaries or your supplier’s next bill. The turnover ratio measures the speed of this cycle: buy stock, sell it, buy again.
A higher ratio means stock moves quickly and your working capital is not stuck. A lower ratio means goods are sitting longer — sometimes because you are deliberately holding a wide range, and sometimes because you bought too much of the wrong thing. The ratio on its own is neither “good” nor “bad”; it becomes useful when you compare it with your own past months, with other categories in your shop, or with what your supplier credit period allows.
Why it matters more for small shops
A large chain can absorb slow stock for a while. A kirana in Thrissur or a hardware shop in Kozhikode usually cannot. If your distributor gives 21 days of credit but your stock takes 60 days to sell, you are paying the supplier from your own pocket for more than a month on every purchase. The turnover ratio shows that gap clearly.
Inventory turnover ratio formula (with a worked example)
The standard formula uses cost, not selling price:
Inventory turnover ratio = Cost of goods sold ÷ Average inventory at cost
Where:
- Cost of goods sold (COGS) = Opening stock + Purchases during the period − Closing stock (all at purchase cost, excluding GST you claim as input tax credit).
- Average inventory = (Opening stock + Closing stock) ÷ 2. If stock levels swing a lot during the year — for example before Onam or the wedding season — average the 12 month-end figures instead of just two.
Worked example: a grocery store
Take an illustrative grocery store (the numbers are made up for the example):
- Opening stock on 1 April, at cost: ₹4,00,000
- Purchases during the year, at cost: ₹48,40,000
- Closing stock on 31 March, at cost: ₹4,40,000
COGS = 4,00,000 + 48,40,000 − 4,40,000 = ₹48,00,000
Average inventory = (4,00,000 + 4,40,000) ÷ 2 = ₹4,20,000
Inventory turnover ratio = 48,00,000 ÷ 4,20,000 ≈ 11.4 times a year
In plain words, this store sold through its average stock a little more than 11 times during the year.
Why not use sales value?
Some people divide total sales by average stock. That inflates the ratio because sales include your margin while stock is valued at cost. Mixing the two makes comparisons between categories with different margins misleading. If cost data is not available, the sales-based version is better than nothing, but always use the same method month after month.
Converting turnover into days of inventory
Most shop owners find “days” easier to understand than “times per year”. The conversion is simple:
Days of inventory = 365 ÷ Inventory turnover ratio
For the grocery example: 365 ÷ 11.4 ≈ 32 days. On average, an item sits in the shop for about a month before it is billed.
Now compare that with your supplier terms. If most suppliers give 30 days of credit, stock is selling roughly as fast as you pay for it — healthy. If the days figure were 75, you would be funding about 45 days of stock from your own cash on every cycle.
Calculating it monthly
An annual figure arrives too late to act on. For a monthly check, use that month’s COGS and the average of the opening and closing stock for the month, then multiply by 12 to get an annualised ratio. Or skip the annualising and use 30 ÷ monthly turnover to get days directly. Watching this every month shows whether a festival purchase, a new supplier or a price change is helping or hurting.
How to read your number: benchmarks that actually help
You will find many “ideal ratio” figures online, but there is no single correct number for every shop. A supermarket selling milk, bread and vegetables naturally turns faster than a hardware store holding pipes, fittings and tools that sell a few pieces a month. The most reliable benchmarks are your own:
- Your previous year or the same month last year. If the ratio is falling while sales are flat, stock is building up.
- Category against category inside your shop. Calculate it separately for groceries, personal care, household, stationery and so on. A category that turns far slower than the rest deserves attention first.
- Your supplier credit period. Days of inventory longer than your credit days means your own cash is financing stock.
- Shelf life. For perishables and short-expiry items, days of inventory must stay comfortably below the shelf life, otherwise you will be writing off stock.
What different shops typically look out for
- Supermarkets and kirana stores: fresh and daily-use items should move fast; slow turnover in packaged foods often points to too many brands of the same product.
- Pharmacies: turnover has to be read together with batch and expiry. A slow-moving medicine is not just tied-up cash; it may expire before it sells.
- Textile and footwear shops: size-and-colour combinations are the trap. The style may be selling while the odd sizes stay on the rack.
- Hardware and building material stores: slower turnover is normal for a wide range, so focus on finding items that have not moved at all for months.
Turning the ratio into action: what to do about slow-moving items
The shop-level ratio tells you that something is wrong. The item-level view tells you what. Sort your items by days of inventory (or by “days since last sale”) and work through the slowest ones.
Step 1: Separate slow movers from dead stock
An item that sells slowly but steadily is different from one that has not sold in six months. Slow movers may just need a smaller reorder quantity. Dead stock needs a clearance decision. Our guide on dead stock management for retail shops covers the clearance options in detail.
Step 2: Fix the reorder quantity, not just the item
Most slow stock is created at the time of purchase. A salesman offers a scheme, you buy three months of stock to get a free case, and the extra cartons sit in the godown. Review the minimum stock and reorder quantity for each slow item so the next order is sized to actual sales. Setting a sensible reorder level for each product is the most direct way to raise turnover without hurting availability.
Step 3: Move stock while it can still sell
Place slow items near the billing counter, bundle them with fast movers, or offer them to regular customers first. For short-expiry goods, act early — a modest discount a month before expiry recovers far more than a write-off after it.
Step 4: Do not chase a high ratio blindly
Turnover can be pushed up by keeping very little stock, but then customers find empty shelves and go elsewhere. Pair the ratio with stock-out tracking. Good low-stock alerts let you run leaner without running out of the items customers come in for.
Getting accurate numbers from your billing software
The formula is only as good as the stock figures behind it. Common mistakes that distort the inventory turnover ratio:
- Closing stock taken from memory or a rough count. Do a physical count at least for high-value items and correct the system stock.
- Purchases entered late. If a bill is entered next month, this month’s COGS and stock both go wrong.
- Returns and damages not recorded. Expired or broken goods that are thrown away but not written off keep showing as stock.
- Mixing GST into cost. If you claim input tax credit, value stock without GST so that every month is calculated the same way.
When billing, purchases and stock live in one system, these figures update automatically with every sale and every purchase entry. Item-wise stock reports, category filters and reorder alerts then make it practical to check turnover every month instead of once a year. If you are evaluating tools, see what to expect from inventory management software with retail POS.
Caddayn Biller records barcode billing, GST invoices and purchases against the same item master, with low-stock and reorder alerts, so your stock value and cost of goods sold come from real transactions rather than estimates. It runs as a Windows app and a web app. You can download Caddayn Biller and try it with a few of your own items to see your stock reports before deciding.
Frequently asked questions
What is a good inventory turnover ratio for a retail shop?
There is no single figure that fits every shop. Fast-moving grocery and daily-use items should turn much faster than hardware or textiles. The practical test is to compare your ratio with your own previous periods, between categories in your shop, and against your supplier credit days.
Should I use cost price or selling price in the formula?
Use cost price for both cost of goods sold and inventory. Using sales value against stock at cost overstates the ratio. Whichever method you choose, keep it consistent so month-to-month comparisons remain meaningful.
How do I calculate days of inventory?
Divide 365 by the annual inventory turnover ratio. For a monthly view, divide 30 by the monthly turnover. The result is the average number of days an item stays in stock before it is sold.
Is a very high turnover ratio always good?
Not always. A very high ratio can mean you are understocked and losing sales to stock-outs. Check it together with how often popular items run out.
How often should I calculate the inventory turnover ratio?
Monthly is ideal for most shops, with a deeper category-wise review every quarter and before big festival purchases.