Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersCustomer Referral Program Tracker

SpreadsheetAccounts & CustomersFree

Customer Referral Program Tracker

Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.

Shown with sample data

Colour

Customer Referral Program Tracker

Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.

Referrals
10
Conversion rate
70%
Purchases ÷ referrals
Referred revenue
$1,374
Rewards owed now
$93.20
Cost per new customer
$51.04
Rewards plus friend discounts
Referred revenue by referrer
  • Maya Chen$703.50
  • Priya Nair$420
  • Daniel Okafor$352
  • Luis Romero$38

How to use it

  1. 1Set your reward rules on the Settings sheet: flat reward, percentage of first order, cap, minimum order, refund window and friend discount.
  2. 2Add a row for each referral when the invite is sent or the code is first used.
  3. 3Update Status, First purchase and First order value when the friend buys.
  4. 4Pay every row showing an amount in Owed now and change its Payout status to Paid.
  5. 5Check the By referrer sheet monthly and thank your top referrers personally.

In this workbook

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

About this template

A refer-a-friend programme only works if rewards are fair and paid on time. Log each referral with the referrer, the new customer, status and first order; the sheet applies your rules from the Settings sheet (flat reward plus a percentage, a cap, a minimum order and a refund window), shows which rewards are eligible, what is owed now, conversion rate, referred revenue and the true cost per acquired customer.

Who it’s for

  • Refer-a-friend programmes for shops and services
  • Subscription and SaaS referral schemes
  • Checking a referral programme pays for itself
  • Paying rewards accurately without software

What’s included

  • Referrals sheet: One row per referred customer.
  • By referrer sheet: Referred revenue and Rewards earned and the number of entries for each referrer.
  • Settings sheet: Your programme rules.

How to use it

  1. 1Set your reward rules on the Settings sheet: flat reward, percentage of first order, cap, minimum order, refund window and friend discount.
  2. 2Add a row for each referral when the invite is sent or the code is first used.
  3. 3Update Status, First purchase and First order value when the friend buys.
  4. 4Pay every row showing an amount in Owed now and change its Payout status to Paid.
  5. 5Check the By referrer sheet monthly and thank your top referrers personally.

Tips

  • Waiting until the refund window has passed before paying rewards stops people gaming the programme with orders they return.
  • Two-sided rewards (something for the referrer and the friend) usually convert better than one-sided ones.
  • Compare cost per acquired customer with what you pay for a customer through ads; if referrals are cheaper, promote the programme harder.
  • Check local rules on incentives and disclosure: some regions require referred reviews or endorsements to be disclosed.

Questions

How much should a referral reward be?

Many businesses spend 10–25% of a customer’s first-year gross profit on the referral reward. Start with what a customer is worth to you and what you currently pay to acquire one through ads, then set a reward that is clearly cheaper but still motivating.

When should referral rewards be paid?

After the friend’s first order has passed your returns or refund window, so you are not paying for orders that are later refunded. The sheet holds rewards as In refund window until then.

How do I measure whether a referral programme is working?

Track the referral conversion rate (purchases ÷ referrals), referred revenue and cost per acquired customer (rewards plus friend discounts ÷ new customers). Compare that cost with your other acquisition channels.

Related searchesreferral program trackercustomer referral trackingreferral rewards spreadsheetrefer a friend programreferral marketing templatereferral commission calculator

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Customer Referral Program Tracker

Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.

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
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
Customer Health Scorecard2 sheets

Accounts

6

At risk

2

Revenue at risk

$134,000

Annual revenue by segment
$204k
$116k
$32k
EnterpriseMid-marketSmall business
SpreadsheetAccounts & Customers

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

10 min setupPreview
RFM Customer Segmentation3 sheets

Customers

14

Champions’ share of revenue

48%

Revenue from at-risk customers

$4,600

ABCD
1CustomerLast orderOrdersTotal spend
2Amelia TurnerNov 914$2,860
3Noah BennettOct 287$1,240
4Isla FraserNov 121$85.00
5Leo HughesApr 211$2,310
Customers
SpreadsheetAccounts & Customers

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

10 min setupPreview
Customer Contact List3 sheets

Customers

9

Lifetime revenue

$187,400

Revenue at risk

$37,100

ABCD
1CustomerContact personCityOwner
2Northwind RetailSara AliSeattleDana
3Blue Harbor CafeHana KimPortlandMia
4Oak & Pine StudioWill GrantDenverLeo
5Delta FoodsBen ColeChicagoLeo
Customers
SpreadsheetAccounts & Customers

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

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