Guide
How to calculate MRR in Stripe, step by step
To calculate MRR in Stripe, normalise every active and past-due subscription to a monthly amount, subtract discounts, and skip trials and one-time fees.
To calculate MRR in Stripe, take every active and past-due subscription, convert its price to a monthly amount (annual ÷ 12), multiply by quantity, subtract the discounts the customer actually pays, and add it all up. Trials, one-time fees, and canceled subscriptions count as zero. If you use Stripe Billing, the Billing overview in your Dashboard already does this for you, and you can configure how it treats discounts.
The formula is simple. The edge cases are where founders end up with three different MRR numbers in three different tools. This guide walks through how Stripe defines MRR, how to handle annual plans, coupons, trials, and churn, and a worked example you can check by hand.
What is MRR?
Monthly recurring revenue (MRR) is the predictable revenue your subscriptions generate each month, normalised to a single month. It isn't the cash you collected this month. A customer who paid $290 for a year in January is worth $24.17 of MRR in January, February, and every month until they cancel.
That normalisation is the whole point. MRR smooths out the lumpiness of annual billing so you can see whether the business is actually growing. ARR (annual recurring revenue) is simply MRR × 12.
How Stripe's Billing dashboard calculates MRR
Stripe's own definition, from its Billing Analytics metrics, is monthly recurring revenue from all active and past-due subscriptions. In practice that means:
- Active subscriptions count at their monthly-normalised value.
- Past-due subscriptions count too. The customer is still subscribed while Stripe retries the failed payment; they drop out of MRR when the subscription is actually canceled.
- Trialing, incomplete, and canceled subscriptions don't count. Trials have their own reporting under the Trials page.
- Non-monthly prices are normalised to a monthly amount.
You can find the number in the Stripe Dashboard under Billing → Overview, with deeper views on the Revenue, Subscribers, Trials, and Churn pages. Selecting a metric opens a details page where you can Export the summary or the underlying rows.
Configuring Stripe's MRR definition
On the Billing overview page, click Configure to change how Stripe calculates MRR, churn, and active subscribers. Stripe notes changes take 24–48 hours to show up. The two settings that move MRR most:
- Subtract recurring discounts from MRR — on means MRR reflects repeating coupons while they apply.
- Subtract one-time discounts from MRR — on means a single-invoice coupon also reduces MRR.
Permanent (forever) recurring discounts are always subtracted. Stripe calls subtracting discounts the more conservative approach, because it reflects what customers really pay. You can also choose whether a subscriber becomes active at the start of the subscription or only once the first payment arrives.
If you want MRR per customer over time, the Billing overview's Report downloads include "MRR per subscriber per month", "Subscription metrics per month", and "Customer MRR changes". One gotcha from Stripe's docs: these reports use UTC dates, while the charts use your account's time zone, so monthly totals can differ slightly.
How to calculate MRR in Stripe by hand
If you aren't on Stripe Billing, want to audit the dashboard, or are building your own report, here is the method.
- List subscriptions with status
activeorpast_due. Leave outtrialing,canceled,incomplete, andincomplete_expired. - Normalise each price to one month. Monthly stays as is. Yearly ÷ 12. Every 3 months ÷ 3. Weekly × 52 ÷ 12.
- Multiply by quantity. Five seats at $12 is $60.
- Apply discounts. 20% off $49 is $39.20. A fixed amount off an annual plan should be spread across the months it covers.
- Convert currencies. If you charge in USD and EUR, convert everything to your reporting currency before adding. Expect small daily movement from exchange rates.
- Add it up. That total is your MRR. Multiply by 12 for ARR.
Leave out one-time charges, setup fees, and tax added on top of the price. Metered or usage-based prices change every month, so most founders track them separately (Stripe currently lists usage-based MRR as a preview feature).
Worked example
Here's a small account with eight customers and every awkward case you're likely to hit:
| Customer | Plan | Status | Monthly MRR |
|---|---|---|---|
| A | $29/month | Active | $29.00 |
| B | $290/year | Active | $24.17 (290 ÷ 12) |
| C | $12/seat/month × 5 seats | Active | $60.00 |
| D | $49/month, 20% forever coupon | Active | $39.20 |
| E | $75 every 3 months | Active | $25.00 (75 ÷ 3) |
| F | $29/month, card declined | Past due | $29.00 |
| G | $29/month, 14-day trial | Trialing | $0.00 |
| H | $49/month | Canceled | $0.00 |
| — | $100 setup fee for C | One-time | $0.00 |
| Total | $206.37 |
So this account's MRR is $206.37 and its ARR is about $2,476. Note what happens next month: if customer G converts, MRR jumps by $29 with no new signup. If F's card keeps failing and the subscription cancels, MRR drops by $29 even though no one clicked "cancel".
How churn fits in
MRR on its own tells you where you are. Its movements tell you why. Most analytics tools, including Stripe's Billing overview, break the monthly change into:
- New MRR from first-time subscribers.
- Expansion MRR from upgrades and added seats.
- Reactivation MRR from customers who come back.
- Contraction MRR from downgrades.
- Churned MRR from cancellations.
Net new MRR = new + expansion + reactivation − contraction − churned.
Your MRR churn rate is churned (and usually contracted) MRR during the month divided by MRR at the start of the month. Lose $100 from a $2,000 starting MRR and that's 5%. Customer churn, by contrast, counts people rather than dollars, so a single big-account cancellation can make the two look very different.
Common mistakes when calculating Stripe MRR
- Counting annual payments as one month's revenue. This makes January look incredible and February look like a collapse.
- Including trials. Trials are pipeline, not revenue. Track trial conversion separately.
- Ignoring discounts, then wondering why cash doesn't match. Decide on a rule and stick with it. If you subtract discounts, remember MRR will rise when a coupon expires, without a new customer.
- Adding one-off charges. Setup fees and consulting invoices belong in revenue, not recurring revenue.
- Mixing currencies at face value. €100 and $100 are not the same number.
- Changing the definition mid-year. Every comparison before the change becomes apples to oranges.
Why your MRR differs between tools
If Stripe says $4,210 and your analytics tool says $4,050, both can be right. The usual culprits are past-due subscriptions (Stripe includes them; some tools drop them sooner), discount handling, trial treatment, exchange rates taken on different days, and whether history is rebuilt from subscription events or from invoices. What matters is consistency month to month. We cover dedicated analytics tools and their trade-offs in the best Stripe dashboard apps for Mac.
Keep your MRR visible without opening Stripe
Once you trust the number, the next problem is checking it forty times a day. Orbl's Stripe integration puts MRR, today's revenue, and new customers on your Mac wallpaper as separate widgets, using a restricted read-only key stored in your macOS Keychain and called straight from your Mac.
To be precise about how it counts: Orbl reads your active subscriptions, normalises yearly, weekly, and daily prices to a monthly amount, multiplies by quantity, applies each subscription's coupon, and converts other currencies into your account's primary currency. Because it reads active subscriptions only, it leaves out past-due ones, so if you have a lot of failed payments in retry, Orbl's figure can sit a little below Stripe's Billing overview. That's a deliberate, conservative read rather than a bug, and it's worth knowing when you compare the two.
The integration is part of Orbl Premium, a one-time purchase ($39 for the first 50 buyers, then $49) with no subscription. The app itself and its built-in widgets are free. If you sell through more than Stripe, the revenue dashboard shows how to combine sources like ChartMogul, Lemon Squeezy, and Polar on the same screen, and tracking MRR without opening Stripe covers the habit side of it.
Frequently asked questions
How does Stripe calculate MRR?+
Stripe sums the monthly-normalised value of all active and past-due subscriptions. Annual and other non-monthly prices are converted to a monthly amount, and you can choose in Billing → Overview → Configure whether recurring and one-time discounts are subtracted.
Does Stripe include free trials in MRR?+
No. A subscription in a trial isn't active or past due, so it adds nothing to MRR until it converts. Stripe reports trials separately on the Trials page of Billing Analytics.
How do I count an annual plan in MRR?+
Divide the annual price by 12. A $290-a-year plan contributes $24.17 of MRR every month, not $290 in the month it was paid.
Should MRR include one-time payments or setup fees?+
No. MRR only counts revenue that repeats on a schedule. Setup fees, one-off invoices, and taxes added on top of the price are left out.
Why doesn't my MRR match between Stripe and another tool?+
Usually because the tools treat discounts, past-due subscriptions, trials, or currency conversion differently. Pick one definition and use it every month so the trend is real.
How do I calculate MRR churn rate?+
Divide the MRR lost to cancellations and downgrades during a month by your MRR at the start of that month. Losing $100 from a $2,000 starting MRR is a 5% MRR churn rate.
Keep reading