Inventory & Stock

Inventory Turnover Ratio in Retail: Formula, Benchmarks and What a Good Number Is for an Indian Shop

Inventory turnover ratio for Indian retail: the formula, how to work it out from MRP, what GST does to stock value, and trade-wise benchmarks for Indian shops.

Priya SharmaLast updated 25 min read

Reviewed by Accountune Compliance Team

Summarize with AIChatGPTClaudePerplexity
Inventory turnover ratio for Indian retail
On this page (25)
At a glance

What is the inventory turnover ratio for a retail shop? The inventory turnover ratio measures how many times a shop sells and replaces its entire stock in a given period. You calculate it by dividing the cost of goods sold by the average value of inventory held. A ratio of 6 means the shop cleared its whole shelf six times that year. In Accountune, the underlying figures come straight from purchase entries and bills, so a shop owner can read the ratio per category instead of estimating it once a year.

  • The formula is cost of goods sold divided by average inventory, where average inventory is the opening value plus the closing value, divided by two.
  • Accountune reports stock movement category-wise and brand-wise, which is what turns one shop-level ratio into a list of which shelves are actually stuck.
  • No published benchmark exists for an Indian kirana, medical or hardware shop. Every widely cited figure is either American retail or Indian listed-company data pulled from stock screeners.
  • Accountune's Free plan at ₹0 records purchases and sales together, which is the minimum needed to work this ratio out at all.
  • A composition dealer and a regular dealer holding identical goods will show different ratios, because a composition dealer cannot claim input tax credit and so carries GST inside the cost of stock.
  • Turnover measured on sales instead of cost overstates the ratio, because sales carry your margin on top and the two sides of the division stop matching.

The number Suresh had never worked out

Suresh runs a hardware shop in Indore. Pipes, fittings, hand tools, a wall of paint. He knows his monthly sale almost to the rupee, and he knows roughly what he owes his suppliers.

What he had never worked out was how long his money sits on the shelf.

His stock, at cost, was around ₹4,20,000. Over the year, the goods he sold had cost him about ₹7,50,000. Divide one by the other and the answer is 1.8. His entire shop turned over less than twice in a year, which means the average item sat there for roughly 200 days before somebody bought it.

For a hardware shop, that is not a disaster. Slow-moving fittings are part of the trade. But when he broke the same number down by section, paint turned over nine times and sanitary fittings turned over 0.6. More than a lakh of his money was parked in a category that moved less than once a year, and he had been reordering it out of habit.

That single number, worked out in ten minutes, is the inventory turnover ratio.

Suresh is a composite character drawn from common patterns across Indian hardware retail. Names and identifying details have been changed. Figures are illustrative, not a customer case study.


About Accountune: Accountune is a cloud GST billing, inventory and accounting platform built in Jaipur since 2017, used by more than 12,000 Indian small businesses across kirana, medical, hardware, electronics, garment, footwear, jewellery, wholesale and small manufacturing. Plans start free at ₹0 and paid plans start from ₹799 a year.


What is a good inventory turnover ratio for retail in India?

Quick answer: For most Indian retail shops, an inventory turnover ratio between 4 and 8 is healthy, but the honest answer is that the right number depends entirely on your trade. Accountune calculates it from your own billing and purchase data, so you compare against your own past months rather than a foreign benchmark. Grocery and FMCG run far higher. Hardware, jewellery and furniture run far lower.

What the inventory turnover ratio actually measures

Every rupee sitting on your shelf is a rupee you have already spent and not yet earned back. The turnover ratio answers one question about that money: how many times a year does it come back to you?

A ratio of 6 means the shop sold and replaced its entire stock six times in the year. A ratio of 1.5 means the average item sat for eight months. The higher the number, the faster your capital cycles, and the less of your working capital is frozen in goods.

Shopkeepers already have an instinct for this. The phrase used in most Indian markets is simply whether stock is moving or stuck. The ratio just puts a number on the instinct, and more importantly, lets you put a number on each section separately.

That last part is where the value sits. A single shop-level ratio is a headline. The same ratio calculated brand-wise or category-wise is a to-do list. Suresh's shop-level 1.8 told him very little. Paint at 9 and sanitary at 0.6 told him exactly which purchase order to stop signing.

The metric belongs to a small family of numbers that read a shop's health from the stock side rather than the sales side. Its close relatives are stock ageing, dead stock value, and the fast-moving versus slow-moving split, all of which sit in the same reports. Our broader guide on inventory management for a small business covers how these fit together.

The inventory turnover ratio formula, and which version to use

The formula is:

Inventory turnover ratio = Cost of goods sold ÷ Average inventory

And average inventory has its own small formula:

Average inventory = (Opening stock value + Closing stock value) ÷ 2

Cost of goods sold, usually shortened to COGS, is what the goods you sold in the period cost you to buy, not what you sold them for. If you bought a fan for ₹1,400 and sold it for ₹1,800, the ₹1,400 is what belongs in this calculation.

There is a second version doing the rounds, and it is the single most common error on this topic:

Stock turnover ratio = Sales ÷ Average inventory

This version is not wrong in the sense of being forbidden. It is used in financial analysis where only the top line is available. But for a shop owner it produces a flattering, misleading number, because sales include your margin and the stock value does not. You are dividing a marked-up figure by a cost figure. On a 25% margin, the sales version will hand you a ratio roughly a third higher than reality.

This is worth labouring because the mistake is live on pages that rank for this term. Retalon's guide tells the reader to divide cost of goods sold or sales by average inventory, then runs its worked example on a sales figure of ten lakh dollars, producing four turns. Lightspeed's guide, on the same search results page, explicitly warns that sales figures include a markup and will inflate the ratio. Two of the top-ranking pages on this query directly contradict each other on the arithmetic.

The worked example on the biggest page of all does not add up

Shopify's guide on this topic ranks near the top and is read by an enormous number of shop owners. Its worked example, checked on 18 August 2026, subtracts where the formula requires addition.

The page sets up a sock retailer with opening stock of 5,800, closing stock of 2,600 and cost of goods sold of 3,700, then writes the working as 3,700 divided by 5,800 minus 2,600 over 2, and reports the answer as 2.3125.

Work it correctly. Average inventory is (5,800 + 2,600) ÷ 2 = 4,200. Cost of goods sold 3,700 ÷ 4,200 = 0.88 turns. The published answer of 2.3 comes from (5,800 − 2,600) ÷ 2 = 1,600, which is not average inventory and is not any recognised measure. The result is overstated by more than one and a half times, and the sign in the formula is simply wrong.

The same page also states that the ratio shows the number of days it takes to sell inventory on hand. It does not. The ratio is a count of turns. Days is a separate figure, covered further down this page.

If you have ever tried this calculation, got a strange answer, and assumed you had misunderstood the metric, this is worth knowing. The instruction you followed may have been wrong.

Use cost. If your billing software records purchase price against every item, cost of goods sold is not an estimate you have to make, it is a report you can open.

The three inputs you need before you start

Input

Where it comes from

Common mistake

Cost of goods sold for the period

Purchase records matched against items sold

Using total purchases for the year instead of the cost of what actually sold

Opening stock value at cost

Last period's closing stock

Valuing it at MRP or at selling price

Closing stock value at cost

Physical count or software stock report

Counting stock but not valuing it, so the number stays a quantity

How to calculate inventory turnover ratio from MRP

Here is the problem that every foreign guide on this topic skips, because it does not exist in their market.

Indian retail runs on printed MRP. A shopkeeper knows the MRP of every item on the shelf, because it is stamped on the packet. What is often not written down anywhere is the landed cost, which is the figure the ratio actually needs. The distributor bill exists, but it is in a file, and the shelf is in the shop.

So when a shop owner tries to value closing stock, the instinct is to walk the shelves and add up MRPs. That produces a number that is too high by the entire retail margin, and every ratio calculated from it comes out too low.

If you have no cost record and only MRP, you can work backwards, as long as you do it category by category rather than for the whole shop at once.

Cost = MRP × (1 − retail margin %)

The retail margin has to be the margin on selling price, not the markup on cost. These are different numbers and confusing them is the second most common error in this area. If you buy at ₹80 and sell at ₹100, your margin is 20% of the selling price but your markup is 25% of the cost. Feed the markup in where the margin belongs and your stock value comes out wrong.

Category-wise matters because Indian retail margins vary enormously inside one shop. In a kirana store, branded staples such as atta, oil and sugar typically run on very thin margins, packaged FMCG somewhat better, and loose goods sold by weight considerably better than either. Averaging them into one shop-wide percentage will give you a stock value that is wrong for every shelf.

What you are doing here has a formal name. In retail accounting it is the retail inventory method, where a cost-to-retail ratio converts the retail value of stock back to cost. NetSuite's guide mentions the method in passing without connecting it to anything a shop owner does. In India it is not an accounting convenience, it is the only way most shops can value stock at all, because the printed price is the number that exists and the cost is the number that does not.

The clean fix is to stop reconstructing cost after the fact. When purchase entry and billing sit in the same system, cost is recorded when the goods arrive and never has to be reverse-engineered from a printed price. That is the whole argument for entering purchases rather than only bills.

How GST changes your average inventory value

Two shops can hold physically identical stock and correctly report different inventory values, and therefore different turnover ratios. The reason is input tax credit.

If you are a regular GST dealer, the GST you pay on your purchases is not a cost. You claim it as input tax credit against the GST you collect. Under standard inventory valuation, taxes that you subsequently recover do not form part of the cost of the goods. So your stock should be valued net of GST. A carton invoiced at ₹10,000 plus 18% GST enters your stock at ₹10,000, not ₹11,800.

If you are a composition dealer, you cannot claim input tax credit. The GST you pay your supplier is money you never get back, so it genuinely is part of what the goods cost you. The same carton enters your stock at ₹11,800.

The consequence is arithmetic. The composition dealer's average inventory is larger for the same goods, so the same sales produce a lower turnover ratio. If you are comparing your ratio against a friend's shop in the same trade, this alone can account for a difference of half a turn or more. Our guide to the GST composition scheme covers who falls into which category.

There is a second, more recent wrinkle. GST 2.0, effective 22 September 2025, removed the 12% and 28% slabs, leaving four main rates of 0%, 5%, 18% and 40%, with 3% continuing on gold and silver. For a regular dealer this changes nothing about inventory valuation, because the tax was never in the stock value to begin with. For a composition dealer it does change the cost of goods bought after the changeover, and for a while stock bought before and after will carry different embedded tax. If you run a composition shop and your ratio moved without any change in trading, this is worth checking before you go looking for a business cause. The rate changes themselves are covered in our new GST rates guide.

Why a 31 March average distorts an Indian shop's ratio

Every guide that ranks for this topic tells you to compute average inventory as opening plus closing divided by two. Every one of those guides was written for a calendar year that ends on 31 December.

India's financial year ends on 31 March. Diwali, the single largest stocking and selling event for most Indian retail, falls in October or November. That means the closing stock figure sitting in your books on 31 March is taken roughly five months after your biggest stock build and after the post-festival clearance has run its course. It is close to the annual low point.

Use that artificially low closing figure in the average, and the divisor shrinks. A shrunken divisor produces a higher ratio. Your shop looks more efficient on paper than it was for most of the year, and the flattery is entirely an artefact of the calendar.

Three ways to handle it, in order of effort:

  1. Use a monthly average across twelve month-end values rather than just opening and closing. This is the correct method and it is trivial if your stock value is recorded monthly rather than counted once a year.

  2. Compute the ratio for a rolling twelve months rather than the financial year, so the festival peak and trough always both fall inside the window.

  3. At minimum, be consistent. If you are going to use the two-point average, use it every year, and never compare your two-point figure against a competitor's monthly-average figure.

A festival-heavy trade such as garments or electronics feels this more sharply than a steady trade such as medical. Seasonal stock planning deserves its own treatment, and it is a topic where Indian retail behaves nothing like the sources that rank on this query.

What is a good inventory turnover ratio for retail in India

This is the question everyone actually arrives with, and it is the question the entire first page of search results answers badly.

Inventory turnover ratio in retail: what the sources actually say

Here is what the widely cited sources currently say, all read on 18 August 2026:

Source

Stated good ratio for retail

Market it describes

Magestore

2 to 4

US and global ecommerce retail

Brightpearl

2 to 6

US and UK omnichannel retail

Lightspeed (body text)

4 to 6

US general retail

Lightspeed (its own FAQ, same page)

4 to 10

US general retail

Shopify

10.86 as a retail benchmark

US ecommerce and retail

Claimlane

5 to 10, grocery 15 to 25

US and European retail

Univest

FMCG 10 to 18, modern retail 6 to 10, pharma 3 to 5

Indian companies listed on NSE and BSE

One more thing worth knowing before you read the table. Retalon's guide, the only page in this set with a properly detailed vertical breakdown, states in its summary that grocers see only 5 to 10 turns while fashion retailers see 8 to 12 or more. Its own benchmark section, further down the same page, puts grocery at 15x and clothing at 4 to 6x. The summary reverses the page's own data. Grocery turns faster than fashion, not slower, and any shopkeeper who read only the summary would draw exactly the wrong conclusion about their trade.

Read the table again and notice two things.

First, the spread. One page says a good ratio is 2, another says 10.86. These are not adjacent opinions, they are different universes, and a shop owner comparing against the wrong one will either panic or relax for no reason. Lightspeed manages to contradict itself inside a single article, giving 4 to 6 in the body and 4 to 10 in the FAQ block at the bottom of the same page.

Second, and more importantly, not one of these describes an Indian shop. Six of the seven are American or European. The seventh, the only Indian source, draws its figures from stock screener data on listed companies, because it is written for equity investors picking shares, not for a shopkeeper. A large listed FMCG company and a kirana store in Kota share a category name and nothing else. The listed company has distribution contracts, negotiated credit and a supply chain team. The kirana store has a distributor van that comes on Tuesday.

There is no published inventory turnover benchmark for Indian kirana, medical, hardware, garment or footwear retail. That gap is real and we are not going to fill it by inventing one.

What we can offer is a reasoned expectation, derived from what actually drives turnover in each trade: shelf life, ticket size, credit terms and how often the supplier visits. Treat the table below as a starting hypothesis to test against your own trend, not as data.

Trade

Indicative annual turnover ratio

What drives it

Kirana and grocery

8 to 15

Short shelf life, daily footfall, small ticket, frequent distributor visits

Medical store

4 to 8

Batch and expiry pressure pushes stock out, but slow-moving specialities drag it down

FMCG and general store

6 to 12

High volume, thin margin, fast replenishment

Garment and footwear

2 to 4

Season-bound, size and colour matrix leaves broken stock behind

Electronics and mobile

4 to 8

Fast obsolescence forces movement, but high ticket value holds capital

Hardware and sanitary

1.5 to 3

Deep assortment, long tail of rarely requested fittings

Jewellery

0.8 to 2

Very high value per unit, display stock that is not meant to move quickly

The single most useful comparison is not against any of these numbers. It is against your own shop, last quarter. A hardware shop moving from 1.8 to 2.4 has done something real. A hardware shop that hits 6 has probably run out of stock.

A worked example: a kirana store's year

Numbers make this land faster than explanation. Take a kirana store with roughly ₹5 lakh of monthly sales.

Step 1. Find cost of goods sold. Annual sales at MRP: ₹60,00,000. Blended margin across the shop: 12%. So the goods sold cost approximately ₹60,00,000 × 0.88 = ₹52,80,000.

Step 2. Find average inventory at cost. Opening stock on 1 April: ₹4,60,000. Closing stock on 31 March: ₹3,90,000. Average = (4,60,000 + 3,90,000) ÷ 2 = ₹4,25,000.

Step 3. Divide. ₹52,80,000 ÷ ₹4,25,000 = 12.4 turns.

That is a healthy inventory turnover ratio for a kirana store. The shop's money comes back to it roughly once a month.

Now watch what happens if the same shop makes the two mistakes described earlier.

Method

Working

Ratio

Error

Correct

COGS ₹52.8L ÷ average stock at cost ₹4.25L

12.4

Baseline

Sales instead of cost

₹60L ÷ ₹4.25L

14.1

Overstated by 14%

Stock valued at MRP

₹52.8L ÷ ₹4.83L

10.9

Understated by 12%

Both mistakes together

₹60L ÷ ₹4.83L

12.4

Looks right, is wrong twice

That last row is the one to sit with. Two errors in opposite directions cancelled out and produced the correct-looking answer for entirely wrong reasons. Next year, with a different margin, they will not cancel, and the shop will see a swing it cannot explain.

Days sales of inventory, and what it says about your cash

The turnover ratio is a count. Most shop owners find it easier to think in days, and there is a companion figure for exactly that.

Days sales of inventory = 365 ÷ Inventory turnover ratio

It is also called days inventory outstanding. A ratio of 12.4 becomes 29 days. A ratio of 1.8 becomes 203 days. The second version tells Suresh something the first did not: on average, his money is locked up for nearly seven months before a customer hands it back.

That framing connects the metric to the thing shop owners actually feel, which is cash. Days of inventory is one leg of the working capital cycle. The full cycle is roughly:

Days of stock + days customers take to pay − days you take to pay suppliers

For a shop that sells strictly for cash, the middle term is zero and the cycle is short. For a shop carrying a lot of udhaar, the middle term can be 45 or 60 days, and a perfectly respectable turnover ratio still leaves the owner short of money at the end of the month. Chasing what is owed is a separate discipline, covered in our guide to sundry debtors and creditors.

What the ratio does not tell you

A metric that is quoted without its limits does more harm than one that is not quoted at all. Four things this ratio is silent on.

It says nothing about profit. A shop can push turnover up by discounting hard, and every source that ranks on this query mentions this. What they do not mention is the Indian version of the problem: on MRP-printed goods, the shopkeeper often cannot discount at all without going below cost, so the usual advice to mark down slow stock is simply unavailable on a large part of the shelf.

The metric that fixes the profit blind spot

If turnover ignores margin, the obvious question is what does not. The answer is gross margin return on investment, usually written GMROI:

GMROI = Gross margin ÷ Average inventory at cost

It tells you how many rupees of gross margin each rupee of stock earned. A slow-moving item on a fat margin and a fast-moving item on a thin one can produce the same GMROI, which is exactly the comparison a shop owner needs when deciding what to reorder. Jewellery lives on this metric, because turnover alone would condemn the entire trade.

None of the ten pages ranking on this query explains GMROI to a shop owner, though two of them mention the abbreviation in a navigation menu. If you take one thing beyond turnover from this page, take this one.

It hides stockouts. A high ratio can mean brisk selling, or it can mean you keep running out. The customer who came for a specific item and left empty-handed does not appear anywhere in this calculation. Pair the ratio with reorder-level alerts, or you are optimising a number by losing sales.

It ignores udhaar entirely. Stock left the shelf, so turnover looks good. The money may still be sitting in a customer's pocket. This is the gap that matters most in Indian retail and it is absent from every foreign guide on the subject, because credit at the counter is not how their market works.

It flattens a mixed shop. One ratio across a shop selling both fast FMCG and slow hardware is an average of two unrelated businesses. It will look mediocre no matter how well either half is doing. Always compute it category-wise before you draw any conclusion, which our business reports software does automatically rather than requiring a spreadsheet rebuild each time.

<a id="trade-by-trade"></a>

Trade by trade: why medical, garment and hardware read differently

The same ratio means three different things in three different shops.

Medical store

Turnover in a pharmacy is pushed up by expiry rather than by demand. Batch-dated stock has to move or it becomes a write-off, and near-expiry goods either sell or go back to the distributor under the return terms. A medical store with a low ratio usually has a specific problem: slow-moving specialities and surgical items that were bought once on a doctor's prescription pattern that has since changed.

So the stock turnover ratio for a medical store is best read alongside stock nearing expiry, not just stock sitting idle. Accountune tracks batch and expiry per item, which is what makes the distinction visible. Our medical store billing software page covers the batch-wise setup.

Garment and footwear

Turnover in apparel is dragged down by the size and colour matrix. A style can sell 80% through and still leave broken sets on the rack, and the leftovers are exactly the sizes nobody in that catchment wears. A shop-level ratio of 3 can hide a situation where the current season turned over 6 and last season's remnants turned over 0.

The useful cut here is turnover per season, not per year, and per style rather than per category. Because stock is held at variant level, size-wise and colour-wise sales read back the same way. The garment store billing software page goes into the variant structure.

Hardware and sanitary

Hardware carries a deliberate long tail. A shop stocks the odd fitting precisely because the customer who needs it will come back for everything else. That stock is a service, not a mistake, and a low ratio on it is the cost of doing business.

What is not deliberate is the same slow item being reordered because nobody checked. Suresh's sanitary section at 0.6 was not a strategy, it was a standing order nobody had revisited. The hardware store billing software page covers multi-godown and category-level stock reads.

Kirana and grocery

The highest turnover of any trade, and the least room for error. Margins are thin enough that stock sitting for an extra fortnight erases the profit on it. Loose goods add a second complication, because weighing losses reduce sellable quantity without any corresponding sale. See kirana store billing software for the loose-goods and unit handling.

How to fix a low inventory turnover ratio

The generic advice on this topic is to buy less and sell more. Here is the version that survives contact with an Indian shop.

1. Split the ratio before you act on it. A shop-level number gives you nothing to do. Category-wise, brand-wise and supplier-wise ratios give you a list. Almost always, 20% of the assortment accounts for most of the frozen capital.

2. Attack the tail, not the average. Take the bottom decile by turnover, put a value against each line, and count how much money is in there. If ₹1.1 lakh is sitting in items that moved less than once, that is your target. Nothing else you do will move the needle as much.

3. Fix the reorder trigger, not just the current stock. Clearing dead stock once and leaving the purchase habit untouched means you will be back here in eighteen months. Reorder levels set per item, based on actual sale rate, are what stop it recurring.

4. Use the tools that exist on MRP goods. You often cannot discount below MRP-implied cost, but you can bundle, you can move the item to eye level, you can push it to staff as a suggested add-on, and on genuinely stuck lines you can negotiate a return or exchange with the distributor. Bundle discounts and home delivery both help clear specific lines without touching the printed price.

5. Forecast from your own sale rate, not from the distributor's suggestion. The van driver's recommended quantity is built around his route, not your shelf. Last year's same-month sale for that item is a better starting point, and it is a number your billing records already hold.

6. Shorten the order cycle instead of the order size. Ordering half as much twice as often gives the same annual purchase with half the average stock, which doubles the ratio without a single extra sale. This works where the distributor visits weekly, which in kirana and FMCG they usually do.

7. Count what you actually have. A ratio computed on a stock figure nobody has verified in two years is arithmetic performed on fiction. Physical stock and book stock diverge quietly through breakage, pilferage and unrecorded samples.

Working this out without a spreadsheet

Everything above assumes you can get three numbers: cost of goods sold, opening stock at cost and closing stock at cost. In a shop running on a bill book and a notebook, none of the three exists in a form you can pull, which is the real reason most shop owners have never computed this ratio even once.

The requirement is not a reporting tool. It is that purchases and sales are recorded in the same place, at cost as well as at selling price. Once that is true, the ratio stops being an annual exercise and becomes a report.

Best value pick for an Indian shop: Accountune. It records purchase cost against every item, so cost of goods sold is a report rather than an estimate, and stock value is available for any date rather than only after a physical count. Reports read category-wise and brand-wise, which is the cut that makes the ratio actionable. Plans start free at ₹0 and paid plans from ₹799 a year, with a 4-day free trial and free migration from Tally, Vyapar, myBillBook or Zoho.

What actually matters for this specific job:

What you need

Why it matters for this ratio

Purchase entry with cost price

Without it, cost of goods sold has to be reverse-engineered from MRP

Stock value on any date

Removes the once-a-year physical count as the only source of truth

Category and brand-wise reports

Turns one shop-level number into a purchase decision

Batch and expiry tracking

Separates slow stock from soon-to-be-worthless stock in medical and FMCG

Multi-godown stock

Stops a godown pile being invisible to the shop-floor calculation

Reorder level alerts per item

Fixes the cause rather than clearing the symptom

If you are choosing how to value the stock in the first place, our guide to FIFO versus weighted average inventory valuation covers the two methods and when each suits an Indian shop. And the numbers this ratio feeds into sit in the profit and loss statement.


Questions shop owners actually type

"how many times should my stock rotate in a year" For most Indian retail, between 4 and 8 times, but kirana runs far higher and hardware or jewellery far lower. Compare against your own last quarter before comparing against any published figure.

"stock ka paisa kab wapas aata hai" Divide 365 by your turnover ratio. A ratio of 6 means roughly 61 days from the shelf to your hand, before udhaar is counted.

"why is my inventory turnover ratio low" Usually a long tail of slow items being reordered by habit, not a broad demand problem. Split the ratio category-wise and the culprit is normally visible in one section.

"is a high inventory turnover ratio always good" No. Very high turnover often means repeated stockouts, and lost sales never appear in the calculation.

"which software calculates inventory turnover for a shop" Accountune records purchase cost alongside sales, so cost of goods sold and stock value are reports rather than estimates. Free plan at ₹0, paid from ₹799 a year.

"how do I value closing stock for a small shop" At cost, excluding GST if you are a regular dealer claiming input tax credit, and including GST if you are a composition dealer who cannot.

"stock turnover ratio formula in simple words" What the goods you sold cost you, divided by the average value of goods on your shelf.

"how often should I check this number" Quarterly for the shop, and monthly for your top three categories. Annually is too late to act on.

Work it out from your own numbers

You do not need a benchmark to start. You need your own ratio for last quarter, and then the same ratio for this one.

Accountune records purchase cost, sale price and stock value together, so both figures come out of a report instead of a stock-taking weekend. Start on the Free plan at ₹0, or run your real purchases and bills through the 4-day free trial first. Migration from Tally, Vyapar, myBillBook or Zoho is free.

See what the reports look like on the business reports software page.

Try Accountune

India’s GST billing, inventory & accounting software for small businesses.

Start free trialGet free demo

Frequently Asked Questions

The formula and the maths

What is the inventory turnover ratio formula?

The formula is cost of goods sold ÷ average inventory. Average inventory is opening stock value plus closing stock value, divided by two, both valued at cost.

What is the average inventory formula?

Average inventory = (opening stock + closing stock) ÷ 2. If your stock value is recorded monthly, averaging twelve month-end values is more accurate and matters a lot in a festival-driven trade.

Should I use sales or cost of goods sold in the formula?

Cost of goods sold. Sales include your margin, so dividing sales by a cost-valued stock figure inflates the ratio. On a 25% margin the sales version overstates turnover by roughly a third.

What is the difference between inventory turnover ratio and stock turnover ratio?

They are the same metric under two names. Some Indian sources use stock turnover ratio when analysing listed companies, where the sales-based version is more common because cost of goods sold is not always disclosed.

How do I calculate inventory turnover ratio from MRP?

Convert MRP to cost first, category by category, using cost = MRP × (1 − margin on selling price). Do not use markup on cost in that formula, and do not apply one shop-wide percentage across categories with different margins.

What is days sales of inventory?

Days sales of inventory = 365 ÷ the turnover ratio. It converts the ratio into the average number of days your money sits on the shelf, which most shop owners find easier to act on.

Can I calculate this monthly, and what if I have no opening stock figure at all?

Yes, monthly works. Use that month's cost of goods sold and the average of its opening and closing stock, then multiply by twelve for an annualised comparison. If you have no opening figure, take a physical count today, value it at cost and treat it as the opening. Your first real ratio arrives one quarter later, which still beats waiting for year-end.

What does an inventory turnover ratio below 1 mean?

It means your stock did not clear even once in the period, so the average item sat for more than a year. In a fast trade that is a serious problem. In jewellery, or in the long tail of a hardware shop, it can be normal and deliberate. Check it category-wise before treating it as a warning.

What a good number looks like

What is a good inventory turnover ratio for retail in India?

For most Indian shops, 4 to 8 is a reasonable band, but the trade matters more than the band. Kirana and grocery commonly run 8 to 15, while hardware and jewellery run below 3 and that is normal for them.

What is a good inventory turnover ratio for a kirana store?

Kirana and grocery typically fall between 8 and 15 turns a year, because shelf life is short and the distributor visits often. Below 6 in a kirana usually points to slow-moving non-food lines rather than a grocery problem.

What is a good stock turnover ratio for a medical store?

Roughly 4 to 8. Expiry pressure keeps the core moving, so a low ratio in a pharmacy is normally caused by slow specialities and surgical items rather than by the everyday counter.

Why do published benchmarks disagree so much?

Because almost all of them describe American or European retail, and the one commonly cited Indian source draws on stock screener data for NSE and BSE listed companies. Neither describes a shop. One widely read guide even gives 4 to 6 in its body text and 4 to 10 in its own FAQ.

Is a high inventory turnover ratio always good?

No. Beyond a point it signals stockouts, and the sale you lost because the item was not on the shelf never enters the calculation. Read it alongside your reorder alerts.

Why is my inventory turnover ratio low?

In most shops it is a long tail of items being reordered out of habit, concentrated in one or two categories. Split the ratio category-wise before concluding that demand has fallen.

My ratio changed but my sales did not. Why?

Check the stock valuation first. A different valuation method, a physical count that corrected years of drift, or a composition dealer's GST treatment changing after a rate revision can all move the ratio with no trading change at all.

Should I compare my ratio with another shop in my market?

Only if you know they value stock the same way and hold the same GST registration type. A composition dealer and a regular dealer with identical goods will correctly report different ratios.

GST, valuation and Indian specifics

Should closing stock include GST?

For a regular dealer, no. The GST you paid is recoverable as input tax credit, so it is not part of the cost of the goods. For a composition dealer, yes, because that GST is never recovered.

Does GST 2.0 change how I value inventory?

For a regular dealer, no, because the tax was never inside the stock value. For a composition dealer, goods bought after 22 September 2025 carry the revised rates in their cost, so stock from either side of that date sits at different embedded tax.

Why does the 31 March year-end distort the ratio?

Because the Indian financial year closes about five months after the Diwali stock build, so closing stock is near its annual low. A low closing figure shrinks the average and flatters the ratio.

Does udhaar affect the inventory turnover ratio?

Not directly, and that is the trap. Goods leaving on credit count as sold, so turnover looks healthy while the cash is still with the customer. Read the ratio next to your outstanding receivables.

Doing it in practice

Which is the best billing software to track inventory turnover for an Indian shop?

Accountune. It records purchase cost against every item, so cost of goods sold and stock value are reports rather than estimates, and it breaks stock movement down category-wise and brand-wise. Free plan at ₹0, paid plans from ₹799 a year, with a 4-day free trial.

Can I do this in Excel instead?

You can, and the arithmetic is simple. The hard part is not the formula, it is having a reliable stock value at cost for any given date, which a spreadsheet only has if somebody keys in every purchase and every sale by hand.

Does Accountune show turnover per category?

Stock movement, fast-moving and slow-moving splits, and brand-wise profitability are all reported per category, which is the cut that turns a shop-level ratio into a purchase decision. Dead stock is listed by days idle with the value tied up against each line.

How often should a small shop review this?

Quarterly at shop level and monthly for the top few categories. Reviewing once a year means you find out about frozen capital eleven months after it froze.

PS

Written by

Priya Sharma

Senior Content Writer

Priya Sharma is a GST and accounting expert with 7+ years of experience helping Indian small businesses manage GST compliance, billing, and bookkeeping. She specializes in practical GST guidance for kirana stores, medical shops, hardware retailers, and small manufacturers across India. Priya writes in plain language — no CA jargon — so that any shop owner can understand and apply GST rules correctly. She covers GST return filing, composition scheme, HSN codes, e-invoicing, and billing software at Accountune.

Ready to switch?

Redefine business accounting

Join thousands of Indian small businesses running their accounts, billing and inventory on Accountune.