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

SpreadsheetStore OperationsFree

Retail Sales Tracker

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

Shown with sample data

Colour

Retail Sales Tracker

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

Net sales
$20,210
Avg transaction
$47.59
Conversion
24%
Target progress
31%
Net sales by day
Nov 2, 2026Nov 8, 2026

Latest: $3,000

How to use it

  1. 1Set your monthly target on the Settings sheet.
  2. 2Enter each day’s figures from your POS at close.
  3. 3Watch average transaction and conversion trends.
  4. 4Review progress weekly with your team.

In this workbook

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

About this template

Track store performance day by day: in-store and online sales, transactions, returns and footfall. Average transaction value, conversion and progress toward the monthly target calculate automatically.

Who it’s for

  • Independent shops and boutiques
  • Store managers reporting to owners
  • Pop-ups and markets

What’s included

  • Daily sheet: Daily store figures.
  • Settings sheet: Targets.

How to use it

  1. 1Set your monthly target on the Settings sheet.
  2. 2Enter each day’s figures from your POS at close.
  3. 3Watch average transaction and conversion trends.
  4. 4Review progress weekly with your team.
Related searchessales trackerdaily salesretail sales reportstore performance

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 Sales Tracker

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

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 Store KPI Scorecard2 sheets

Sales

$308,840

Conversion rate

14%

Average transaction value

$33

Sales by store
$148k
$130k
$31k
Riverside MallHigh StreetStation Kiosk
SpreadsheetStore Operations

Retail Store KPI Scorecard

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

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