Stripe Recurring Revenue Reporting: How to Track MRR, ARR & Churn

Stripe processes billions in recurring payments, but it doesn’t provide a native recurring revenue report. If you’re running a SaaS, membership site, or subscription box business, you need to know your MRR, ARR, and churn rate — not just how many dollars hit your account last month.

This guide explains how to build a Stripe recurring revenue reporting system that gives you the subscription metrics you actually need to run your business.

What Is Recurring Revenue Reporting?

Recurring revenue reporting tracks the predictable, repeating income from subscriptions. Unlike one-time sales, recurring revenue is the foundation of SaaS and subscription business models. The key metrics include:

• MRR (Monthly Recurring Revenue) — the total predictable revenue per month from all active subscriptions, normalized to a monthly value
• ARR (Annual Recurring Revenue) — MRR × 12, used for annual planning and investor reporting
• Churn Rate — the percentage of subscribers who cancel each month
• Net Revenue Retention — whether your existing customers are spending more or less over time
• ARPU (Average Revenue Per User) — MRR divided by active subscriber count

Why Stripe Doesn’t Provide a Recurring Revenue Report

Stripe is a payments infrastructure company, not a SaaS analytics platform. Its reporting focuses on what payment processors care about:

• Transaction volume and success rates
• Payout timing and reconciliation
• Dispute and refund tracking
• Tax reporting (1099s, VAT)

Stripe stores all the data you need to calculate recurring revenue metrics — subscription amounts, intervals, statuses, cancellation dates — but it doesn’t compute MRR, churn, or projections for you. As Stripe’s own SaaS guide notes, understanding these metrics is essential for subscription businesses.

How to Calculate MRR from Stripe Data

MRR is calculated by summing the normalized monthly value of every active, revenue-contributing subscription. The normalization step is crucial because your customers may be on different billing intervals:

• Monthly plan ($49/mo) → $49 MRR
• Annual plan ($468/yr) → $39 MRR ($468 ÷ 12)
• Quarterly plan ($120/quarter) → $40 MRR ($120 ÷ 3)
• Weekly plan ($15/week) → $65.22 MRR ($15 × 52 ÷ 12)

You also need to exclude subscriptions that are trialing (no revenue yet), canceled, or incomplete. Only subscriptions with statuses active or past_due should be counted.

How to Track Churn from Stripe

Churn rate is typically calculated as:

Churn Rate = (Subscriptions canceled this month) ÷ (Total active subscriptions at start of month) × 100

In Stripe, canceled subscriptions have status: "canceled" and a canceled_at timestamp. To calculate monthly churn, you need to:

1. Count subscriptions that transitioned to “canceled” during the month
2. Divide by the total active subscription count at the start of the month

Industry benchmarks from ProfitWell’s researchsuggest that median SaaS churn is around 5% monthly for SMB-focused products and 1–2% for enterprise.

Building an MRR History Chart

One of the most valuable recurring revenue reports is a 12-month MRR trend chart. This shows whether your business is growing, flat, or shrinking. To build one from Stripe data, you need to:

1. For each of the last 12 months, determine which subscriptions were active during that month
2. Sum the normalized monthly revenue of those subscriptions
3. Plot the monthly totals as a line or bar chart

This requires checking each subscription’s created date, canceled_at date, and statusto determine if it was contributing revenue during a given month. It’s doable but tedious with raw API calls.

The Easy Way: Automated Recurring Revenue Reporting

StripeReport automates all of this. Connect your Stripe account with a read-only API key and you instantly get:

• Live MRR & ARR — calculated from your actual subscriptions, updated in real-time
• 12-month MRR history — see the trend at a glance
• Churn rate tracking — know your monthly churn percentage and how it’s trending
• Revenue forecasting — projected revenue for the next 7, 30, 90, or 365 days based on actual renewal dates
• Revenue at risk — dollar amount tied to pending cancellations and past-due invoices
• Business health score — a 0–100 score combining churn, growth, and revenue trends
• Daily email reports — yesterday’s revenue, MRR, projections, and churn delivered every morning

No spreadsheets, no SQL, no custom code. Just connect and go.

Recurring Revenue Reporting Best Practices

1. Track MRR movements, not just the total — break MRR changes into new MRR, expansion MRR, churned MRR, and contraction MRR to understand what’s driving growth
2. Monitor churn by cohort — customers who signed up 3 months ago may churn at different rates than those from last year
3. Set churn alerts — know immediately when a customer cancels or goes past due, so you have a chance to save the account
4. Use projections for hiring and spending — revenue forecasts based on actual renewal dates are more reliable than multiplying current MRR by months
5. Review weekly, not just monthly — monthly reviews miss mid-month problems. Weekly check-ins catch issues earlier.

Frequently Asked Questions

Does Stripe calculate MRR?

No. Stripe tracks subscription amounts and billing intervals, but does not calculate MRR as an aggregate metric. You need to compute it yourself using the API or a third-party tool like StripeReport.

What’s the difference between MRR and gross volume in Stripe?

Gross volume includes everything — one-time charges, subscription payments, fees, and refunds. MRR only counts the predictable, recurring portion of your revenue, normalized to a monthly figure. For a subscription business, MRR is the more meaningful metric.

How often should I review my recurring revenue report?

At minimum, weekly. Better yet, get a daily email summary so you can spot trends and issues in real-time. StripeReport sends daily reports at 7 AM ET with your key metrics.