This retail KPI calculator takes the figures from your monthly POS report and shows where the store makes money and where it leaks: what a customer spends per visit, how many visitors buy, and how much each square metre of floor sells. Enter the month's sales, transactions, units, visitors, floor area and cost of goods, and six KPIs appear, each with a sentence explaining it in your own numbers. Advanced mode adds inventory and shrinkage, compares two months, and strips out the 15% VAT charged in Saudi Arabia when your till report shows sales including it.
How to calculate retail store KPIs
Every KPI here divides one figure from your reports by another, so both figures must cover the same period and the same branch. Sales are net of returns, and cost is at purchase price.
Sales per m² = sales ÷ selling area · GMROI = gross profit × 365 ÷ days in period ÷ average inventory at cost
Average transaction value and units per transaction
Average transaction value (ATV), also called average basket size, is what a customer pays at the till in one visit. It breaks into two numbers you can work on separately: units per transaction (UPT) and average unit price. If ATV rose because baskets got bigger, add-on displays near the counter and staff suggestions are working. If it rose because the unit price went up, the cause may be a price increase or a shift in what customers buy, and the item sales report tells you which.
Store conversion rate
Conversion rate is the share of visitors who leave with a receipt. You need a door counter or a camera that counts people coming in, with each person counted once. A family of five walking in and paying once pulls the rate down, so compare the store with itself rather than with other stores. If transactions exceed visitors, the counter is not working or the two figures come from different periods, and the calculator warns you.
Sales per square metre
Sales per square metre measures what the selling floor earns, and it helps when you decide whether to expand, take a smaller branch, or reset the shelves. Use only the area customers walk on, without the stockroom and offices. Compare a month with a similar month: in the Kingdom, Ramadan and the back-to-school season do not compare with an ordinary month.
Gross margin and GMROI
Gross margin is the share of sales left after the cost of goods, before salaries and rent. Gross margin return on inventory investment (GMROI) answers a different question: how many riyals of gross profit does each riyal sitting on the shelf earn in a year? The calculator annualises the period's gross profit by multiplying by 365 and dividing by the days in the period, then divides by average inventory at cost. Two stores with the same margin can have very different GMROI if one carries twice the stock. For stock turnover and days of cover, use the inventory KPI calculator.
Shrinkage rate from the stock count
Shrinkage is the gap between what the system says is on the shelf and what the count finds: theft, damage, or mistakes at receiving or at the till. The calculator shows it two ways, as a share of sales and as a share of gross profit. The second speaks more plainly to an owner, because it shows how much of the profit went missing. Value shrinkage the same way every time, at cost or at selling price, so the comparison holds.
Sales including or excluding VAT
Many POS reports show sales including VAT. VAT is collected for ZATCA, not earned by the store, so a margin calculated on VAT-inclusive sales looks better than it is. Tick "The sales I entered include VAT" in advanced mode and the calculator divides sales by 1.15 before every KPI: SAR 207,000 including VAT becomes SAR 180,000 net, and the average transaction value in Example 1 stays at SAR 120.00.
Common mistakes
- Calculating margin from VAT-inclusive sales against cost before VAT.
- Counting returns as separate transactions, which lowers ATV and inflates conversion.
- Comparing conversion with another store that counts visitors differently.
- Dividing sales by the whole floor area, stockroom included.
- Judging one month's GMROI without annualising it, so it looks far too low.
What to do with the result
Pick one KPI to work on next month, then come back with the new month's figures in the "Comparison period" column to see the effect. The PDF report suits the monthly meeting with the store manager, and the Excel file carries the same formulas so you can add months or branches. The first download asks for your name and mobile number once, in a short window; the dashboard works without it. To price a single item at a target margin, use the profit margin calculator.
When the figures sit in three different reports
The division is easy; the time goes into collecting the inputs: sales from the till, cost from the accountant, stock from the count, each up to a different date. At Microtec we offer O-Green, a cashier and point-of-sale system for retail stores in Saudi Arabia. Try it with your own store's numbers before you decide.