Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceStore OperationsRetail Store KPI Scorecard

SpreadsheetStore OperationsFree

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

Shown with sample data

Colour

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

Sales
$308,840
Conversion rate
14%
Average transaction value
$33.42
Units per transaction
1.7
Sales by store
  • Riverside Mall$148,100
  • High Street$130,240
  • Station Kiosk$30,500

How to use it

  1. 1Enter one row per store per week.
  2. 2Take footfall from your door counter.
  3. 3Compare each ratio with the other stores.
  4. 4Pick one ratio per store to improve next week.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Sales tell you what happened; these three ratios tell you why. Enter footfall, transactions, units and sales for each store each week; the sheet calculates conversion rate, average transaction value and units per transaction, so you can see whether to work on traffic, selling or basket size.

Who it’s for

  • Weekly store reviews
  • Comparing stores fairly
  • Coaching teams on conversion and add-on sales

What’s included

  • Weekly sheet: One row per store per week.
  • By store sheet: Footfall and Transactions and Sales and the number of entries for each store.

How to use it

  1. 1Enter one row per store per week.
  2. 2Take footfall from your door counter.
  3. 3Compare each ratio with the other stores.
  4. 4Pick one ratio per store to improve next week.
Related searchesretail kpi scorecardstore performance reportconversion rate retailaverage transaction valueunits per transaction

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More store operations templates

View all
Retail Sales Tracker2 sheets

Net sales

$20,210

Avg transaction

$48

Conversion

24%

Net sales by day
SpreadsheetStore Operations

Retail Sales Tracker

Daily sales by channel with transactions, average basket and target progress.

10 min setupPreview
Store Staff Rota2 sheets

Total hours

150

Labour cost

$2,622

Labour % of sales

18%

ABCD
1StaffRoleContracted hrsMon
2HannahManager408
3OmarSupervisor320
4PriyaSales associate246
5TomSales associate160
Rota
SpreadsheetStore Operations

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

10 min setupPreview
Daily Cash Register Reconciliation4 sheets

Takings

$18,304

Net variance

-$29

Days to investigate

2

ABCD
1DateTillClosed byOpening float
2Nov 21Omar$200.00
3Nov 31Priya$200.00
4Nov 41Omar$200.00
5Nov 51Hannah$200.00
Cash-up
SpreadsheetStore Operations

Daily Cash Register Reconciliation

Close the till every day: cash, card and voucher takings against the POS, over and short against your tolerance, the bank deposit, a denomination count and variances by cashier.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ