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

SpreadsheetAccounts & CustomersFree

Renewal & Churn Tracker

Every contract up for renewal with its value, likelihood and outcome, plus gross and net revenue retention.

Shown with sample data

Colour

Renewal & Churn Tracker

Every contract up for renewal with its value, likelihood and outcome, plus gross and net revenue retention.

Gross revenue retention
85%
Closed renewals only
Net revenue retention
92%
Includes expansion
Open renewals
$184,000
Forecast for open
$129,600
Weighted by likelihood
Forecast value by segment
  • Enterprise$168,000
  • Mid-market$97,600
  • Small business$18,000
Share of forecast value by segment
  • Enterprise$168,00059%
  • Mid-market$97,60034%
  • Small business$18,0006%

How to use it

  1. 1List every contract with its renewal date.
  2. 2Update likelihood 90, 60 and 30 days out.
  3. 3Record the outcome and new value when it closes.
  4. 4Review churn reasons each quarter.

In this workbook

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

About this template

Know what is renewing, what is at risk and what you actually kept. Track each renewal with its current value, the renewed value and the outcome; the sheet calculates churned, contracted and expanded revenue and reports gross and net revenue retention.

Who it’s for

  • Subscription and retainer businesses
  • Monthly renewal forecast calls
  • Board reporting on retention

What’s included

  • Renewals sheet: One row per renewal.
  • Summary by Segment sheet: Forecast value and Current value and the number of entries for each segment, calculated from the Renewals sheet.

How to use it

  1. 1List every contract with its renewal date.
  2. 2Update likelihood 90, 60 and 30 days out.
  3. 3Record the outcome and new value when it closes.
  4. 4Review churn reasons each quarter.
Related searchesrenewal trackerchurn trackernet revenue retentionsubscription renewalscontract renewals

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Renewal & Churn Tracker

Every contract up for renewal with its value, likelihood and outcome, plus gross and net revenue retention.

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