How to Track MRR in Stripe (2026): Free Tracker + the Numbers That Matter

Where to find MRR in Stripe (Billing to Analytics), how to read the four components, gross vs net churn math with a worked example, the gotchas Stripe hides, Google Sheets automation, and a free MRR tracker spreadsheet.
Bright line chart trending up and to the right, illustrating monthly recurring revenue (MRR) growth over time
The short version: Stripe already calculates your MRR - it's under Billing → Analytics. But the number on the dashboard hides four moving parts (new, expansion, churned, net) and quietly makes choices about discounts, annual plans, and proration. This guide shows you where to find it, how to read it correctly, the churn math, and gives you a free MRR tracker spreadsheet so you own the number yourself.

From the team at Flowjam · Last updated July 2026

Every SaaS founder lives by MRR. Most report it wrong. Stripe hands you one headline figure, but hidden inside it are four moving parts and a set of quiet accounting choices - and if you don't know them, you'll overstate growth to investors and miss churn until it's already a fire. Here's how to find it, read it, and track it properly.

📥 Download the free MRR tracker (.xlsx) - fill in three numbers a month and it auto-calculates net new MRR, MoM growth, and gross + net revenue churn. Works in Excel and Google Sheets. No signup.
MRR Tracker · preview
Metric     Jan   Feb
New       $12K  $14K
Churned   $5K   $4K
Net new   $11K  $14K
Growth   11%   13%
Net churn -3%  -4%

Where to find MRR in Stripe

You don't need to build anything to see MRR - Stripe computes it natively:

  1. Log in and go to Billing → Analytics.
  2. The top card shows Monthly recurring revenue. Click Explore to open the interactive report.
  3. In Explore you can filter by product, price, currency, coupon, or custom metadata - useful for seeing MRR by plan or segment.

One setting matters before you trust the number. From the Billing overview, click Configure to control how Stripe calculates MRR, churn, and active subscribers - including whether to subtract recurring discounts. Subtracting discounts is the more conservative choice: it reflects what customers actually pay, not list price. Pick one approach and keep it consistent, or your MRR will jump the day you change it.

The four numbers hiding inside MRR

"MRR went up" is not a story. These four components are:

Component
What it is
New MRR
Recurring revenue from brand-new customers this month.
Expansion MRR
Upgrades, seats, and add-ons from existing customers.
Churned MRR
Revenue lost to downgrades and cancellations.
Net new MRR
New + Expansion − Churned. The real growth number.

Two companies can both add "$20K MRR" and be in completely different shape: one built it on $22K new minus $2K churn, the other on $40K new minus $20K churn. Same headline, very different health. That's why you track the components, not just the total.

Churn math: gross vs net

Churn is where founders fool themselves. There are two numbers and they tell different stories.

Metric
Formula
Reads
Gross revenue churn
Churned MRR ÷ MRR at start of month
How much you leak, ignoring upsells. Lower is better.
Net revenue churn
(Churned − Expansion) ÷ MRR at start
Leak after upsells. Can go negative - the elite signal.

Worked example: you start the month at $100K MRR, lose $5K to cancellations, and gain $8K in upgrades. Gross churn is $5K / $100K = 5%. Net churn is ($5K − $8K) / $100K = −3%. That negative number is the one investors love: it means your existing customers grow your revenue faster than churn shrinks it, so you'd grow even if you never signed another new logo.

The gotchas: why Stripe's MRR won't match your napkin math

If your own calculation disagrees with Stripe's, it's almost always one of these:

Gotcha
What happens
Annual plans
A $1,200/yr plan is $100 of MRR, not $1,200. Stripe normalizes annual to monthly; make sure your spreadsheet divides by 12 too.
Proration
Mid-cycle upgrades create partial charges that aren't recurring - don't count the one-time proration as MRR.
Refunds
A refund reduces cash but isn't necessarily churn; a cancellation is. Keep them separate.
Trials
A subscriber on a free trial is not MRR yet - it counts only when they start paying.
Discounts
List price vs discounted price is a choice (the Configure setting above). Whichever you pick, be consistent everywhere.

Automate it: MRR in Google Sheets

The Stripe dashboard is great for a glance, but founders want a live tracker they control. The fastest route: install the free Stripe add-on for Google Sheets, then pull MRR with a formula like:

=STRIPE_MRR("2026-01-01", "2026-06-30", "price_id")

That gives you a self-updating number you can chart and drop into a monthly investor update. Prefer to start from a clean structure? The free MRR tracker above already has the components, growth, and churn formulas wired up - paste your numbers in and it does the rest.

Turn your MRR into the story investors remember

Once you are tracking MRR reliably, the next lever is how you present it. Tracking MRR is step one; the number only matters when you present it well. On an investor update or a Demo Day slide, one clean line - "$120K MRR, growing 30% month over month, net churn negative" - does more than a wall of charts. For how to frame that on stage, see our YC Demo Day pitch guide.

Frequently asked questions

Where is MRR in Stripe?
Billing → Analytics. The top card shows monthly recurring revenue; click Explore for the interactive report and Configure to control how it's calculated.

Does Stripe calculate MRR automatically?
Yes. Stripe computes MRR, churn, and active subscribers natively, and lets you choose whether to subtract recurring discounts. You don't need code to see it - only to automate a custom tracker.

What's the difference between gross and net revenue churn?
Gross churn is Churned MRR divided by starting MRR - your raw leak. Net churn subtracts expansion (upgrades) first, so it can go negative when upsells outweigh losses.

Why doesn't my MRR match Stripe's?
Usually annual plans (normalize to monthly), proration (one-time, not recurring), trials (not MRR until paid), or a different discount setting. The gotchas table above covers each.

How do I track MRR in Google Sheets?
Install the free Stripe add-on for Sheets and use =STRIPE_MRR(start, end, price_id), or start from our free MRR tracker spreadsheet and paste your monthly numbers in.

What's a good MRR growth rate?
Early-stage benchmarks vary, but sustained double-digit month-over-month growth is strong, and negative net revenue churn (expansion beating churn) is the signal investors prize most.

Sources: Stripe Billing Analytics docs and Stripe's revenue-churn guide. MRR configuration and the discount setting reflect Stripe's current Billing dashboard.

Related reads: YC Demo Day Pitch Guide · Seed Round Valuation Guide · Paddle vs Stripe Billing