How to Calculate Real MRR and Churn (When Stripe and HubSpot Disagree)

Stripe and HubSpot rarely agree on MRR and churn. Learn how to calculate real SaaS metrics and apply one logic to both with Glow Reports.

Glow Reports Team, 2 min read. Updated
  • SaaS Metrics
  • Finance
  • Revenue Operations
A comparison chart resolving conflicting revenue numbers into a clear, unified metric
On this page
  1. Why platforms calculate metrics differently
  2. Step 1: Standardise your definitions
  3. Step 2: Handle edge cases consistently
  4. Step 3: Separate gross churn from net churn
  5. Step 4: Centralise the calculation layer
  6. Common questions
  7. How Glow Reports applies one MRR logic

Stripe shows a five percent churn rate. HubSpot says you kept nearly every account this month. When your most important SaaS metrics disagree, planning for growth becomes guesswork.

Why platforms calculate metrics differently

Your billing tool and your CRM are built for different jobs. Stripe processes payments and handles compliance. HubSpot tracks the pipeline and the relationship. Same event, different logic.

A customer cancels on the second of the month. HubSpot may mark the account churned at once, because the relationship is over. Stripe often counts the revenue as active until the billing cycle ends. Both are right by their own rules. For a founder trying to state one monthly recurring revenue figure, the gap is maddening.

Step 1: Standardise your definitions

First, agree company-wide on when an event counts. Does a customer churn the day they click cancel, or the day their billing cycle ends?

For cash flow and financial planning, the billing-cycle date is usually more accurate. For product and customer success, the cancellation date better reflects sentiment. The choice matters less than the consistency. Every team uses the same rule.

Step 2: Handle edge cases consistently

SaaS billing is rarely clean. Upgrades, downgrades, pauses, and partial refunds all move your core metrics.

A customer downgrades from premium to basic mid-month and Stripe prorates the difference. Export that to a spreadsheet without reconciling it against your CRM, and it is easy to log one downgrade as both a churned account and a new signup. Your workflow has to separate expansion and contraction MRR from new acquisitions and full cancellations.

Step 3: Separate gross churn from net churn

Most teams quote a single churn number, and it hides more than it shows. Gross churn counts only the revenue you lost to cancellations and downgrades. Net churn subtracts that loss from the expansion revenue you gained through upgrades and seat increases.

A healthy account base can post high gross churn and still grow, because expansion outpaces the losses. Report only the net figure and you mask a retention problem. Report only gross and you ignore real growth. Track both, and label which one you mean every time you share it.

Step 4: Centralise the calculation layer

The fix is to stop trusting each tool's default dashboard. Instead of reading revenue in Stripe and retention in HubSpot, use one layer that ingests raw data from both and applies your agreed logic uniformly.

Pull the data into one place and you can map a HubSpot company to its Stripe customer ID. When an account changes status, the financial impact and the relationship status update together. You get one MRR figure you can defend.

Common questions

What is the difference between customer churn and revenue churn?

Customer churn counts the accounts you lost. Revenue churn counts the money those accounts represented. Stripe's own guide to revenue churn explains the calculation in detail. The two diverge sharply when your customers vary in size: losing ten small accounts can matter less than losing one large one.

Does Stripe's dashboard show my real MRR?

It shows MRR for the revenue that flows through Stripe, calculated with Stripe's own rules. If you bill some customers outside Stripe, or your CRM holds contract terms Stripe never sees, the dashboard figure is a partial view, not the company number.

Is annual contract revenue part of MRR?

Yes, normalised. A customer paying twelve hundred pounds a year contributes one hundred pounds to MRR. Counting the full annual payment in the month it lands inflates that month and starves the rest, which is exactly the inconsistency this article is trying to remove.


How Glow Reports applies one MRR logic

Glow Reports calculates MRR and churn with the rules you state. Export your Stripe subscriptions and your HubSpot companies as CSV files, upload both, and say how you count churn: on the cancel date or at the end of the billing cycle. The AI writes the SQL and builds the report.

Every figure shows the query behind it, so you can check how the AI counted a proration or a paused account. Change the rule in your question and the numbers follow.

Prefer a live link to Stripe and HubSpot over exports? Our team sets up the connection with you. Book a call and we scope it around your billing.

Glow Reports Team

Upload your Stripe and HubSpot exports, or let our team set up the connection to both. Every MRR and churn figure shows the SQL behind it.

Keep reading