Active subscriptions
Record grain: subscription
Date basis: As of latest refresh
Rules: One contributing record per typed ID
Recurring revenue · Google Sheets sample
GoHighLevel Subscription Overview report template
Review the current subscription mix, normalized recurring amounts, and billing-interval coverage. Use it to see which interval assumptions are supported.
Subscription Overview
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
Active subscriptions3As of latest refresh
Normalized active MRR$300.00As of latest refresh
Past-due subscriptions1As of latest refresh
Active subscriptions without interval1As of latest refresh
Subscriptions by current status
View chart data
| Group | Value |
|---|---|
| Active | 3 |
| Past due | 1 |
| Cancelled | 1 |
Normalized active MRR by plan
View chart data
| Group | Value |
|---|---|
| Monthly support | $100.00 |
| Annual service | $200.00 |
| Subscription | Customer | Status | Billing interval | Recurring amount | Normalized MRR |
|---|---|---|---|---|---|
| Monthly support | Olivia Bennett | Active | 1 month | $100 | $100 |
| Annual service | Ava Wilson | Active | 1 year | $2,400 | $200 |
| Quarterly coaching | Ethan Brooks | Past due | 3 month | $450 | Excluded |
| Cancelled plan | Noah Davis | Cancelled | 1 month | $80 | Excluded |
| Interval not recorded | Liam Carter | Active | Missing | $75 | Excluded |
What the metrics mean
Normalized active MRR
Record grain: subscription
Date basis: As of latest refresh
Rules: Monthly/yearly recurring amounts only; past-due and unknown intervals excluded
Past-due subscriptions
Record grain: subscription
Date basis: As of latest refresh
Rules: One contributing record per typed ID
Active subscriptions without interval
Record grain: subscription
Date basis: As of latest refresh
Rules: One contributing record per typed ID
Required data and boundaries
- Subscriptions with billing intervals
- Contacts
A current cancelled status does not reveal the date of churn. Unknown billing intervals are excluded from normalization rather than guessed.
MRR is a current normalized contract amount, not cash. Tax, discounts, trials, pauses and billing-price links require verified rules. Current cancelled status does not establish historical churn.
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
Recurring Revenue Changes
Recorded new, expansion, contraction and churn events.
Explore sample →Customer accounts
Customer Payments
Customer collections, current balances and linked payment records.
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.