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

SpreadsheetStore OperationsFree

Customer Loyalty Program Tracker

Points earned with tier multipliers, balances, Bronze to Gold tiers from spend, lapsing members and your redemption liability.

Shown with sample data

Colour

Customer Loyalty Program Tracker

Points earned with tier multipliers, balances, Bronze to Gold tiers from spend, lapsing members and your redemption liability.

Members
10
Active rate
70%
Points outstanding
8,093
Redemption liability
$113.30
Expected cost of unredeemed points
Redemption rate
50%
Spend by tier
  • Gold$8,77075%
  • Silver$2,07018%
  • Bronze$7807%

How to use it

  1. 1Set points per $1, tier thresholds and multipliers, point value, expected redemption rate and lapse period on the Settings sheet.
  2. 2Add members with their last purchase date and 12-month spend from your POS or store.
  3. 3Update points redeemed and expired each month.
  4. 4Contact members marked Lapsing with a reason to come back.
  5. 5Review the Tiers sheet and the liability KPI each quarter.

In this workbook

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

About this template

Run a points-and-tiers loyalty programme from a spreadsheet and know what it costs you. Enter each member’s 12-month spend, points redeemed and points expired; the tracker assigns Bronze, Silver or Gold from spend thresholds, awards points with tier multipliers, calculates each balance and the redemption liability (outstanding points × value per point × expected redemption rate) and flags members who are lapsing. Rules live on the Settings sheet so you can model changes before you announce them.

Who it’s for

  • Small retailers and cafés running a points scheme
  • Modelling the cost of a loyalty programme before launch
  • Finding lapsing members to win back
  • Reporting the outstanding points liability to your accountant

What’s included

  • Members sheet: One row per member.
  • Tiers sheet: Members, spend and liability by tier.
  • Settings sheet: Programme rules.

How to use it

  1. 1Set points per $1, tier thresholds and multipliers, point value, expected redemption rate and lapse period on the Settings sheet.
  2. 2Add members with their last purchase date and 12-month spend from your POS or store.
  3. 3Update points redeemed and expired each month.
  4. 4Contact members marked Lapsing with a reason to come back.
  5. 5Review the Tiers sheet and the liability KPI each quarter.

Tips

  • Keep the reward rate simple and meaningful: 2–5% back in points value is common for retail.
  • Tiers work best when the next tier is within reach; show members how close they are.
  • Unredeemed points are a liability; your accountant may need the outstanding balance at year end. Check how your accounting standard treats loyalty points.
  • Check consumer law on points expiry and programme changes where you trade, and give members notice.

Questions

How do loyalty points work?

Customers earn points for each dollar spent (often more in higher tiers) and redeem them for discounts or rewards. Each point has a cash value, so the programme’s cost is points redeemed × value per point.

What is loyalty redemption liability?

The estimated value of points customers have earned but not yet used that you expect to be redeemed: outstanding points × value per point × expected redemption rate.

How should I set loyalty tiers?

Base thresholds on your spend distribution: for example, the top 10% of customers reach Gold and the next 25% reach Silver. Give each tier a benefit customers notice, such as a points multiplier, early access or free delivery.

Related searchesloyalty program trackercustomer loyalty spreadsheetreward points trackerloyalty tierspoints liability calculatorrewards program template

Details

Format
Spreadsheet
Category
Store Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Customer Loyalty Program Tracker

Points earned with tier multipliers, balances, Bronze to Gold tiers from spend, lapsing members and your redemption liability.

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
3
Setup
10 min
Level
Intermediate
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
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

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