New recurring amount
Record grain: subscriptionEvent
Date basis: Effective event date
Rules: One contributing record per typed ID
Recurring revenue · Google Sheets sample
GoHighLevel Recurring Revenue Changes report template
Inspect recorded new, expansion, contraction, and churn events in a recurring-revenue waterfall. Each movement needs a real effective-dated event.
Recurring Revenue Changes
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
New recurring amount$300.00Effective event date
Expansion amount$20.00Effective event date
Churned recurring amount$80.00Effective event date
Net recurring movement$240.00Effective event date
Recorded recurring revenue changes
View chart data
| Group | Value |
|---|---|
| New | $300.00 |
| Expansion | $20.00 |
| Contraction | $0.00 |
| Churn | -$80.00 |
| Net change | $240.00 |
Recorded lifecycle events
View chart data
| Group | Value |
|---|---|
| New | 2 |
| Expansion | 1 |
| Contraction | 0 |
| Churn | 1 |
| Subscription | Event | Effective date | Monthly amount change |
|---|---|---|---|
| su1 | New | 2026-10-02 | $100 |
| su2 | New | 2026-10-03 | $200 |
| su4 | Churn | 2026-10-08 | -$80 |
| su1 | Expansion | 2026-10-10 | $20 |
What the metrics mean
Expansion amount
Record grain: subscriptionEvent
Date basis: Effective event date
Rules: One contributing record per typed ID
Churned recurring amount
Record grain: subscriptionEvent
Date basis: Effective event date
Rules: One contributing record per typed ID
Net recurring movement
Record grain: subscriptionEvent
Date basis: Effective event date
Rules: One contributing record per typed ID
Required data and boundaries
- Effective-dated lifecycle events
- Subscriptions with billing intervals
- Validated subscription history
The sample includes an invented event ledger. Live reporting requires accepted lifecycle history; current subscription flags cannot substitute for it.
Synthetic effective-dated events only, observed from 2026-10-01. Changes do not establish an opening MRR balance, churn rate or NRR. No historical outcome is inferred from latest subscription status.
CRM coverage only · USD; other currencies excluded. Financial units and relationship namespaces are simulated, not provider-validated.
Early access · These public previews use invented records. Join early access to discuss connecting your own GoHighLevel account.
From this sample to a connected report
Choose the template
Use the report whose definitions match the decision you need to make.
Check required inputs
Confirm source access, relevant mappings, history, and any configured goals.
Create the worksheet
The early-access design reuses compatible imports and creates a report worksheet.
Choose freshness
Select source refreshes deliberately. New executions transferring records add usage.
Related report samples
Recurring revenue
Subscription Overview
Active subscriptions, normalized recurring amounts and interval coverage.
Explore sample →Payments & invoices
Payment Collections
Successful collections, transaction counts and payment types.
Explore sample →Bring your own reporting question.
Make this your reporting workflow.
Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.