Most store owners have a feeling for how the business is doing. Retail KPIs (key performance indicators) replace that feeling with a small set of numbers that show what is improving, what is slipping, and where to act first.
This guide explains twelve KPIs every store owner should track, with the formula for each, a single worked example using one hypothetical store month, what to watch for, and how to build a simple weekly KPI report.
In this guide
How retail KPIs fit together
Revenue is the result of a few drivers you can influence separately: how many people come in, how many buy, and how much each buyer spends. Looking at the drivers tells you why sales moved.
Throughout this article we use one hypothetical store month: $84,000 net sales, 2,800 transactions, 7,000 units sold, $50,400 cost of goods sold, $42,000 average inventory at cost, 9,000 visitors and 1,200 staff hours. All figures exclude sales tax.
Sales KPIs
1. Net sales (revenue)
Formula: gross sales − returns − discounts (excluding tax). Example: $84,000. Compare with the same period last year and the same weekday last week, not just last month, to remove seasonal effects.
2. Average transaction value (ATV)
Formula: net sales ÷ number of transactions. Example: 84,000 ÷ 2,800 = $30.00. Raise it with bundles, better product placement near the till and well-trained staff.
3. Units per transaction (UPT)
Formula: units sold ÷ number of transactions. Example: 7,000 ÷ 2,800 = 2.5. Together with average unit price ($84,000 ÷ 7,000 = $12.00), it explains ATV: 2.5 × $12.00 = $30.00.
4. Conversion rate
Formula: transactions ÷ visitors × 100. Example: 2,800 ÷ 9,000 × 100 ≈ 31.1%. Requires a door counter or another reliable traffic count; without one, track transactions per hour instead.
Profitability KPIs
5. Gross margin %
Formula: (net sales − cost of goods sold) ÷ net sales × 100. Example: (84,000 − 50,400) ÷ 84,000 = 33,600 ÷ 84,000 = 40%. Track it by category; a mix shift towards low-margin products can hide behind growing sales. See margin vs markup for the formulas in detail.
6. GMROI (gross margin return on inventory investment)
Formula: gross margin ÷ average inventory at cost. Example (monthly): 33,600 ÷ 42,000 = 0.8 — each dollar of stock earned $0.80 of gross margin this month. If every month were similar, the annual figure would be 33,600 × 12 ÷ 42,000 = 9.6. GMROI is usually reported on an annual basis; above 1 means stock earns more than it costs.
7. Sales per labour hour
Formula: net sales ÷ staff hours worked. Example: 84,000 ÷ 1,200 = $70 per hour. Use it with hourly sales data to schedule staff for peaks rather than for habit.
Inventory KPIs
8. Inventory turnover
Formula: cost of goods sold ÷ average inventory at cost. Example (monthly): 50,400 ÷ 42,000 = 1.2 turns, or about 14.4 a year at the same pace. Higher turnover generally means less cash tied up in stock — see the retail inventory management guide.
9. Sell-through rate
Formula: units sold ÷ units received × 100 for a product, delivery or season. (Some retailers divide by beginning inventory instead — be consistent.) Example: 1,200 units of a seasonal line received, 780 sold by the end of the season: 780 ÷ 1,200 = 65%. Low sell-through flags products to discount early or stop reordering.
10. Stockout rate
Formula: SKUs at zero stock ÷ SKUs checked × 100 (or the share of days a key product was unavailable). Example: 37 of 1,000 active SKUs at zero during a weekly check = 3.7%. Focus on stockouts of class A items — see ABC analysis and the reorder point formula.
Returns and loss KPIs
11. Return rate
Formula: value of returns ÷ sales × 100 (or units returned ÷ units sold). Use either gross or net sales as the base, and state which. Example: $2,100 of returns on $84,000 of net sales = 2.5%. Break it down by product and reason: a single product with high returns usually signals a quality, sizing or description problem.
12. Shrinkage rate
Formula: (book inventory value − counted inventory value) ÷ net sales × 100 for the period. For context, the U.S. National Retail Federation’s 2023 survey reported an average of 1.6% of sales for fiscal 2022. Measure your own trend with regular cycle counts and act on it with the shrinkage prevention guide.
All 12 KPIs at a glance
| # | KPI | Formula | Example | Review |
|---|---|---|---|---|
| 1 | Net sales | Gross sales − returns − discounts | $84,000 | Daily / weekly |
| 2 | ATV | Net sales ÷ transactions | $30.00 | Weekly |
| 3 | UPT | Units ÷ transactions | 2.5 | Weekly |
| 4 | Conversion rate | Transactions ÷ visitors | 31.1% | Weekly |
| 5 | Gross margin % | (Sales − COGS) ÷ sales | 40% | Monthly |
| 6 | GMROI | Gross margin ÷ avg inventory at cost | 0.8 / month | Monthly / yearly |
| 7 | Sales per labour hour | Sales ÷ staff hours | $70 | Weekly |
| 8 | Inventory turnover | COGS ÷ avg inventory at cost | 1.2 / month | Monthly |
| 9 | Sell-through | Units sold ÷ units received | 65% | Per season / delivery |
| 10 | Stockout rate | SKUs at zero ÷ SKUs checked | 3.7% | Weekly |
| 11 | Return rate | Returns ÷ sales | 2.5% | Monthly |
| 12 | Shrinkage rate | (Book − counted) ÷ sales | Your trend | Monthly / quarterly |
Building a weekly KPI report
A useful KPI report fits on one page and compares each number with something meaningful.
| KPI | This week | Same week last year | Last 4 weeks avg | Target | Comment |
|---|---|---|---|---|---|
| Net sales | |||||
| Transactions | |||||
| ATV | |||||
| UPT | |||||
| Gross margin % | |||||
| Stockouts (class A) | |||||
| Cash over/short |
- Pull sales, transactions and units from your POS sales reports.
- Add cost data from recorded purchases for margin.
- Add the week’s cash differences from your daily reconciliations.
- Write one comment per number that moved significantly — and one action.
See which dashboards, exports and automated reports are available on the reports and analytics page.
Setting realistic targets
- Start from your own baseline: the last 12 weeks and the same period last year.
- Set targets for drivers, not only results: “raise UPT from 2.5 to 2.7” is something staff can influence directly; “raise sales 10%” is not.
- Make targets specific to the period: December and February are not comparable.
- Limit targets to two or three KPIs at a time so the team can focus.
- Review monthly and adjust when conditions change (a new competitor, roadworks, a supplier shortage).
Leading vs. lagging indicators
Some KPIs tell you what already happened (lagging); others warn you about what is likely to happen (leading). A balanced report contains both.
| Lagging (results) | Leading (early warning) |
|---|---|
| Net sales | Visitors and conversion rate |
| Gross margin % | Discount rate; supplier cost increases |
| Inventory turnover | Sell-through of new deliveries |
| Shrinkage rate | Cycle count accuracy; unexplained adjustments |
| Lost sales | Stockouts of class A products |
From KPI to action
| If this happens… | Look at… | Possible actions |
|---|---|---|
| Sales down, traffic stable | Conversion rate, stockouts | Fix availability of best sellers; staff coverage at peaks |
| ATV down | UPT and average unit price | Bundles, add-on displays near the till, staff suggestions |
| Margin down | Category mix, discounts, supplier costs | Reprice, renegotiate, reduce blanket discounts — see margin vs markup |
| Turnover down | Slow movers, over-ordering | Markdown old stock; adjust reorder points |
| Shrink up | Count variances by category | Receiving checks, permissions, counts — see shrinkage prevention |
Where the data comes from
Most of these KPIs come straight from your POS, provided the basics are recorded consistently. Sales, transactions, units, returns and payment methods come from the sales history. Cost of goods sold and margin need purchase prices recorded on deliveries. Turnover, sell-through and stockouts need reliable stock quantities, which depend on recording deliveries promptly and on regular cycle counts. Visitor numbers need a door counter, and staff hours come from your rota or payroll.
If one of these inputs is weak, fix it before relying on the KPI that uses it. A turnover figure built on inaccurate stock, for example, can send you in exactly the wrong direction.
Example: a 20-minute weekly review
Here is how a store owner might use the KPIs in practice, using the hypothetical store from this article. On Monday morning, the owner opens last week’s report. Net sales are slightly up on the same week last year, but ATV has dropped, while transactions are higher. UPT is down from 2.5 to 2.3, which explains most of the ATV change: customers are buying, but buying fewer items each.
The owner checks the stockout list and finds that two popular add-on products — the kind customers pick up at the counter — have been out of stock for five days. Gross margin by category is stable, so pricing is not the issue. The actions are clear: reorder the two add-ons with a higher reorder point, move them back to the counter display, and remind staff to suggest them. Next week’s report will show whether UPT recovers. The whole review took twenty minutes because the numbers pointed directly to a cause.
Common KPI mistakes
- Tracking too many numbers. Start with five or six and add more only when you act on them.
- Comparing with the wrong period. Compare with the same period last year, not just last week.
- Mixing tax-inclusive and tax-exclusive figures. Use net-of-tax sales everywhere.
- Ignoring data quality. Margin and turnover are only as reliable as your recorded costs and stock counts.
- Chasing generic benchmarks. Industry averages vary widely; your own trend is the most useful comparison.
Embedding KPI reviews in your weekly routine is covered in the retail store operations guide.
Start collecting the data behind these KPIs: the free edition records every sale, product and payment method, with a daily overview report.
Frequently asked questions
What are the most important retail KPIs?
For most small stores: net sales, average transaction value, units per transaction, gross margin, inventory turnover and stockouts of key products. Add conversion rate if you can count visitors.
How do I calculate average transaction value?
Divide net sales by the number of transactions. For example, $84,000 ÷ 2,800 transactions = $30.00.
What is a good GMROI?
Above 1 means inventory earns more gross margin than it costs on average. Targets vary by sector; track your own trend and compare categories within your store.
How is sell-through rate calculated?
Units sold divided by units received, multiplied by 100. Some retailers use beginning inventory as the denominator — choose one method and use it consistently.
How often should I review KPIs?
Sales and transactions daily or weekly; margin, turnover and returns monthly; shrinkage monthly or quarterly depending on how often you count.
Related guides
- Margin vs markup
- Retail store operations guide
- Retail inventory management guide
- Retail shrinkage prevention
