Which retail KPIs (key performance indicators) should a shop owner track? Track 12 numbers in three groups (sales, stock and money), and start with five. Together they show what you sell, how fast your stock moves, and how much money you keep.
For Indian retailers, what makes one KPI matter more than another is the trade. A garment shop lives or dies by how fast new stock sells. A hardware shop that sells on credit has to watch customer dues closely.
Almost every one of these 12 can be worked out from the bills and stock records most shops already keep.
For each one, you get the formula and a one-line example. You also see where the inputs sit in billing software, how often to check them and what a bad reading tells you. Then come the five to start with.
Key Takeaways
- Start with five retail KPIs, not all 12. They can show a sales, stock or cash problem while it is still small.
- Work out margin on the price before GST, or every margin you read will look better than it is.
- A KPI only means something against your own past months, so keep the same formula every time.
What Is a Retail KPI?
A retail KPI is one number that tells a shop owner how one part of the business is doing. It is a formula on your own data, like sales divided by bills, checked on a fixed cycle.
The point is the trend, not the single reading. An average bill of ₹385 says little on its own. Set against ₹410 last month (an example), it tells you something changed at the counter.
12 Critical Retail KPIs Explained With Examples
The 12 retail KPIs below fall into three groups: sales, stock and money. Almost every one can be worked out from billing and stock data a small shop already has.
Sales per square foot, shrinkage and footfall conversion are left out on purpose. They need floor area, footfall or physical count data that billing software does not hold.
The 12 KPIs:
- Sales: net sales, number of bills, average transaction value, units per transaction, sales growth
- Stock: inventory turnover, sell-through rate, days of stock cover, dead stock %
- Money: gross margin %, gross margin return on investment, days sales outstanding
1. Net Sales
Net sales is the money your shop actually earned from selling, after returns, and before GST.
Formula: Net sales = billed sales before GST − returns before GST
Example: a footwear shop in Nashik bills ₹4,86,300 before GST in October 2026. It takes back ₹8,900 in returns, so its net sales are ₹4,77,400 (an example).
Open your sales report for the billed figure. Returns show up as credit notes, so take them from the same report or the credit note list. A daily look catches a bad day, and a weekly comparison shows the trend. Our daily sales report template gives you a simple place to log it.
A bad reading is a net figure that keeps falling while billed sales stay flat. That points to rising returns, which is worth checking by item.
2. Number of Bills
How many customers bought something? The bill count is the closest a small shop gets to that answer without a footfall counter at the door.
Formula: Number of bills = count of sales bills in the period
Example: the same Nashik footwear shop printed 1,240 bills in October 2026 (an example).
Your sales report gives the count for any date range. Look at it every day, and once a month break it down by hour to plan staff at the counter. A falling bill count with steady sales means fewer customers are each spending more. That can hide a loss of regular buyers.
3. Average Transaction Value (ATV)
Average transaction value (ATV) is the amount a customer spends on one bill, on average. Some people call it average bill value or average order value.
Formula: ATV = net sales ÷ number of bills
Example: for the Nashik footwear shop from KPI 1, ₹4,77,400 ÷ 1,240 bills = ₹385 per bill (an example).
Sales summary October 2026 (an example) Net sales before GST ₹4,77,400 Number of bills 1,240 ₹4,77,400 ÷ 1,240 ATV ₹385 per bill Average transaction value from a monthly sales summary (an example). Green: the two inputs from your sales report. Amber: the KPI you work out from them.Both inputs sit on the same sales report, so ATV takes seconds once the report is open. Check it weekly. A falling ATV often means customers are buying one item and leaving, so look at your counter displays and combo offers.
4. Units per Transaction (UPT)
Units per transaction (UPT) counts how many items go into one bill. Where ATV tracks rupees, UPT tracks pieces, and the two together show whether a bigger bill came from more items or dearer ones.
Formula: UPT = units sold ÷ number of bills
Example: a stationery shop in Vadodara sells 2,900 units across 1,160 bills in a month, so its UPT is 2.5 (an example).
Units sold come from an item-wise sales report. Check UPT monthly. If ATV rises but UPT falls, it often means prices went up while customers picked up fewer things, or that add-on sales at the counter are slipping.
5. Sales Growth
Sales growth compares one period with the same period a year ago. Use the same month last year, not last month, because festivals and school terms move sales up and down through the year.
Formula: Sales growth % = (this period’s net sales − same period last year) ÷ same period last year × 100
Example: the Nashik footwear shop from KPI 1 had net sales of ₹4,12,500 in August 2026, against ₹3,75,000 in August 2025. That is (₹37,500 ÷ ₹3,75,000) × 100 = 10% growth (an example).
This one needs a full year of sales data in your software, and a monthly reading is enough. Diwali does not fall in the same month every year, so when it moves, compare October and November together.
A bad reading is growth below the rise in your own purchase prices. If supplier prices rose 8% and sales grew 5% (an example), you are shrinking in real terms.
6. Inventory Turnover
Inventory turnover tells you how many times you sold and replaced your stock in a period.
Formula: Inventory turnover = cost of goods sold (COGS) ÷ average stock at cost
Take a kitchenware shop in Vijayawada. In a quarter, its COGS (what it paid for the goods it sold) is ₹9,60,000. Opening stock was ₹3,10,000 and closing stock ₹2,90,000, so average stock is ₹3,00,000 and turnover is 3.2 for the quarter (an example).
COGS comes from your purchase and stock reports, or your profit and loss report. Check it monthly or quarterly. If you want the average-stock method step by step, our inventory turnover ratio post covers it. A falling figure means stock is sitting longer before it sells.
7. Sell-Through Rate
Sell-through rate is the share of a new lot that sold in a set time. It suits shops that buy by the season or the lot, like garments and footwear.
Formula: Sell-through rate % = units sold ÷ units received × 100
Example: a garment shop in Surat receives 240 kurtis on 1 October 2026 and sells 156 by the end of the month. Its sell-through is 156 ÷ 240 × 100 = 65% (an example).
240 kurtis received (an example) 156 sold 84 left Sell-through 65% Selling 6 a day 84 left ÷ 6 a day 14 days of cover One lot of 240 kurtis, drawn to scale (an example). Green: units sold. Amber: units still on the shelf, and the days of cover (KPI 8 below) they give at the current selling pace.Where do the inputs sit? Units received are on the purchase entry for that lot, and units sold are on an item-wise sales report for the same dates.
In a new season, work it out every two weeks. A low sell-through halfway through the season is your signal to act. Move the lot to the front, or plan a markdown before it turns into dead stock.
8. Days of Stock Cover
How long will the stock on your shelf last at today’s selling pace? Days of stock cover answers that in days, which is easier to act on than a ratio.
Formula: Days of stock cover = units in stock ÷ average units sold per day
Example: the Surat garment shop from KPI 7 sold 156 kurtis over 26 selling days, which is 6 a day. Its 84 left will last 84 ÷ 6 = 14 days (an example).
Work it out every week for fast sellers, and again before every purchase order. Stock on hand is in your stock report, and daily sales are in the item-wise sales report. Too few days means you are about to run out. Too many means cash is sitting on the shelf.
9. Dead Stock %
Dead stock is stock that has not sold for a long time. Dead stock % is its share of all the stock you hold. You choose the cut-off, like 90 days, and keep it the same each time.
Formula: Dead stock % = cost value of items with no sale in 90 days ÷ total stock at cost × 100
Picture an electrical shop in Indore that finds 37 items with no sale in the last 90 days. Together they cost it ₹68,450, out of ₹6,84,500 of stock, so 10% of its stock money is stuck (an example).
An inventory report that shows the last sale date gives you the list. So does a stock report filtered to items with no sale in 90 days. Check it monthly. A rising figure means you are buying ahead of demand. Our post on retail inventory mistakes covers how stock ends up like this.
10. Gross Margin %
Gross margin % is the share of each sale you keep after paying for the goods. It is the easiest one to get wrong, because GST gets mixed in.
Formula: Gross margin % = (net sales − COGS) ÷ net sales × 100, with both figures before GST
GST is not part of the value of a sale under Section 15(2)(a) of the Central GST Act. The GST you collect is not your money, so it stays out of the margin.
Say a speaker sells for ₹1,180 including 18% GST (an example). The price before GST is ₹1,180 ÷ 1.18 = ₹1,000. If it cost you ₹700 before GST, the margin is ₹300 ÷ ₹1,000 = 30%. Worked on ₹1,180, the same sale would look like a margin of almost 41%.
Read it monthly from the profit and loss report, which gives sales and COGS for the month. Split it by category every quarter. A falling margin often points to more discounts. It can also mean your supplier raised prices and you have not raised yours yet.
11. Gross Margin Return on Investment (GMROI)
Gross margin return on investment (GMROI) shows how many rupees of gross margin each rupee of stock earned you. It joins the money KPIs to the stock KPIs.
Formula: GMROI = gross margin in rupees ÷ average stock at cost
Example: a shop earns ₹11,52,000 of gross margin in a year on average stock of ₹4,80,000, so its GMROI is 2.4 (an example). Each rupee sitting in stock earned ₹2.40 of margin that year.
Your profit and loss report has the gross margin, and your stock reports at the start and end of the period give the average stock. GMROI is a quarterly number, with a category split once a year. A category with a low GMROI is taking shelf space and cash that another category would use better.
12. Days Sales Outstanding (DSO)
Many Indian shops sell on credit to regular buyers, contractors or other shops. Days sales outstanding (DSO) tells you how many days, on average, it takes to get that money in.
Formula: DSO = customer dues outstanding ÷ credit sales in the period × days in the period
Example: a cosmetics shop in Guwahati that supplies salons on credit has ₹1,42,800 due on 30 September 2026. Its credit sales in September were ₹1,90,400, so DSO is ₹1,42,800 ÷ ₹1,90,400 × 30 = 22.5 days (an example).
Customer dues come from a receivables report or a due list in your billing software. Check it weekly. A rising DSO means you are funding your customers, and the money for next month’s stock has to come from somewhere else.
All 12 Retail KPI Formulas in One Table
To calculate any retail KPI, take the formula from this table and the inputs from your sales, stock and dues reports. All 12 formulas sit in one place here, with how often to check each one. Keep it next to your weekly review.
| Retail KPI | Formula | How Often to Check |
|---|---|---|
| Net sales | Billed sales before GST − returns before GST | Daily |
| Number of bills | Count of sales bills | Daily |
| Average transaction value (ATV) | Net sales ÷ number of bills | Weekly |
| Units per transaction (UPT) | Units sold ÷ number of bills | Monthly |
| Sales growth % | (This period − same period last year) ÷ same period last year × 100 | Monthly |
| Inventory turnover | COGS ÷ average stock at cost | Monthly or quarterly |
| Sell-through rate % | Units sold ÷ units received × 100 | Every two weeks in season |
| Days of stock cover | Units in stock ÷ average units sold per day | Weekly |
| Dead stock % | Cost of items with no sale in 90 days ÷ total stock at cost × 100 | Monthly |
| Gross margin % | (Net sales − COGS) ÷ net sales × 100, before GST | Monthly |
| GMROI | Gross margin ÷ average stock at cost | Quarterly |
| Days sales outstanding (DSO) | Dues ÷ credit sales × days in period | Weekly |
There is no single “good” figure for most of these. A garment shop and a hardware shop will read very different numbers, so compare each one with your own past months.
Twelve is a lot to start with, so the next section picks the five that matter first.
Which 5 Retail KPIs Should a Shop Owner Track First?
Most small Indian retailers should start with five retail KPIs. They are net sales, average transaction value, gross margin %, days of stock cover and days sales outstanding. Together they cover what you sell, what you keep and where your cash is sitting.
- Net sales, because every other KPI is built on it.
- Average transaction value, because it shows changes at the counter within a week.
- Gross margin %, before GST, because sales without margin can still lose money.
- Days of stock cover, because it tells you when to reorder and when to stop.
- Days sales outstanding, if you sell on credit. If you do not, use sell-through rate instead.
Add the other seven once these five are a habit.
What I could recommend from my end. Set up your item master with categories before you track any KPI. Then every report can be split by category from day one.
Pick one fixed day each week, export the sales, stock and dues reports, and paste them into the same sheet. The formulas stay the same, so the only thing that changes is the data.
Even with only five KPIs, a few habits can quietly throw the numbers off.
Critical Retail KPI Tracking Mistakes Shop Owners Make
Most retail KPI tracking mistakes come from how the numbers are collected and compared, not from the formulas. These are the ones that change the answer the most.
- Mixing GST into sales or margin. Keep every rupee figure before GST, as the gross margin section shows.
- Valuing stock at selling price. Turnover, dead stock and GMROI all need stock at cost. Selling price makes your stock look bigger than the money you put into it.
- Comparing a festival month with a normal one. Compare with the same festival period last year instead, because festivals shift between months.
- Changing the formula halfway. If dead stock meant 90 days in July, it means 90 days in December too.
- Unscanned or wrongly scanned sales. If items are billed under a general code, item-wise KPIs stop meaning anything.
To keep the stock side honest, count a few items each week in rotation. Our guide to cycle counting stock shows how, and our stock management template gives you a format for it.
Which Billing Software Reports Track Retail KPIs?
Retail KPIs run on four kinds of billing software report. Each one feeds a different group of the 12:
- Sales report: net sales, number of bills, ATV, UPT and sales growth
- Stock report: inventory turnover and dead stock %, plus sell-through and days of stock cover with the item-wise sales report
- Profit and loss report: gross margin %, plus GMROI with the stock report
- Accounts receivable report: days sales outstanding
In Petpooja Invoice, sales, stock, profit and loss, purchase and accounts receivable and payable (AR/AP) reports sit in one place. Its product page says the AI Inventory Agent updates inventory levels “without the need for manual entry”. That keeps the stock figure behind stock cover and turnover current, as long as every sale, purchase and return is entered.
Barcode scanning at the counter keeps item-wise sales accurate, so sell-through and stock cover start from current figures.
If you would rather start in a spreadsheet, our retail profitability template gives you a ready layout for margin by category.
Conclusion
These 12 retail KPIs cover sales, stock and money, and almost every one runs on data your bills and stock records already hold. You do not need all of them on day one.
Start with the five: net sales, ATV, gross margin % before GST, days of stock cover and DSO. Use sell-through instead of DSO if you do not sell on credit. Check each one on the schedule in the formula table, and compare it only with your own past months.
For small Indian business owners and shop owners, the hard part of tracking retail KPIs is getting clean numbers out of the counter. Petpooja Invoice keeps your sales, stock and dues reports in one place, so each KPI starts from the same records.
Frequently Asked Questions
Is There a Retail KPI Formulas PDF or Sheet?
We do not offer a separate PDF of these formulas. The quickest route is your own sheet with three columns: KPI, formula and your number. Add a fresh number column each time you check, so the trend for each KPI sits on one row. For margin by category, the retail profitability template linked earlier gives you a ready layout.
What KPIs Should a Retail Store Manager Track?
A store manager usually tracks what they can change on the floor: bills per hour, ATV, UPT and stock cover for fast sellers. The owner keeps an eye on the money KPIs, like gross margin, GMROI and DSO. If you set targets for a manager, tie each one to a number the manager controls.
What Is the Difference Between Markup and Margin?
Markup is profit as a share of cost, and margin is profit as a share of the selling price. On a speaker that costs you ₹700 and sells for ₹1,000 before GST, the markup is 300 ÷ 700, about 43%, but the margin is 30% (an example). Our profit margin calculator works out both.
Should I Read Retail KPIs Weekly or Monthly?
A weekly figure can jump because of one large bill, a holiday or a slow rainy week. A monthly figure smooths most of that out. So read counter KPIs like ATV weekly, but act only when the same direction holds for three or four weeks. If your bills are still on paper, even weekly readings are slow to get, which is one reason shops move to GST billing software.
Thanks. This helps us make the next article better.






Comments
Loading comments…