Home / Blog / How to Calculate MRR
How-to · 2026

How to Calculate MRR From Stripe: Annual Plans, Discounts and Pauses

MRR is a simple sum until a customer pays annually, uses a coupon or pauses. Then the number in the investor update and the number in the Stripe dashboard stop matching, and someone has to say which one is right.

By · Published November 17, 2026 · 7 min read

MRR is the sum of every active subscription, normalized to one month and net of recurring discounts. That is one sentence and four decisions: how annual plans are spread, which discounts count, which statuses are excluded, and what happens to other currencies. Get them wrong and MRR drifts from what the business earns each month. Below is a worked example and the spreadsheet version.

A worked example

The figures are illustrative. A small subscription business has 55 customers:

GroupCustomersPriceMRR
Monthly, list price34$50 a month$1,700.00
Monthly, 25% recurring discount4$37.50 a month$150.00
Monthly, paused this month2excluded$0.00
Annual at $60010$50 a month$500.00
Annual at $1,2005$100 a month$500.00
MRR53 paying$2,850.00

ARR is $2,850 × 12 = $34,200. Now compare cash. In this month 3 of the $600 customers and 1 of the $1,200 customers renewed, so the card charges were $1,850 from monthly plans + $1,800 + $1,200 = $4,850. Same business, same month, and the cash is 70% higher than MRR. Anyone who reads MRR off the payments list will overstate it in renewal months and understate it in the rest.

The four decisions

The spreadsheet version

Export subscriptions with interval, price, discount percent and status, one row each. Say column B is the interval ("month" or "year"), C the price, D the recurring discount as a fraction and F the status. Add a normalized column in E:

E2:  =IF(B2="year",C2/12,C2)*(1-D2)
MRR: =SUMIFS(E:E,F:F,"active")
ARR: =MRR*12

Add a branch for quarterly if you sell it. Check the total against a hand count of one customer from each group before you trust it.

Without the export and the formulas

The Stripe connector brings subscriptions, invoices and an MRR dataset in directly. Quiriz keeps the MRR definition, including how annual plans, discounts and pauses are treated, in Company Context, so the Monday number and the board-pack number come from the same rule. In Google Sheets, with the Sheets add-in:

=QUIRIZ("MRR by plan this month, annual plans divided by 12, recurring discounts applied, paused excluded", "table")

The answer lists the rule it used, so a reader can see what was excluded. Where this stops. If a coupon is configured in a way that the data does not describe as recurring or one-time, the definition has to say how to treat it. Quiriz follows the rule you set rather than guessing.

For what to do with MRR next, see net revenue retention and churn rate.

📚 Connector reference: every dataset and metric definition behind this, and how each is calculated, is in the Stripe connector. All connectors.

MRR you can explain to an investor

Try the questions on sample subscription data with no signup, then connect Stripe and ask for MRR by plan with your rules.

Try Quiriz free →

Frequently asked questions

How do you calculate MRR with annual plans?
Divide the annual price by 12 and count that amount every month the subscription is active. A customer who pays $600 once a year is $50 of MRR, not $600 in the month they pay and zero the rest of the year.
Should discounts reduce MRR?
Recurring discounts should, because the customer pays the lower amount every period. A one-time first-invoice coupon should not, because it ends. Check how each coupon is configured before you subtract it.
Does MRR include trials and paused subscriptions?
Usually not. A trial is not paying yet, and a paused subscription is not paying now. Pick a rule, apply it every month, and note it on the report, because the choice changes the figure and an investor will ask.
Why does my MRR not match the Stripe dashboard?
Most often the two use different rules for trials, past-due subscriptions, discounts or currency conversion. Neither is wrong. Write down which rules your number uses and compare the same rules on both sides.
What is the difference between MRR and revenue?
MRR is the normalized, recurring part of your subscriptions at a point in time. Revenue is what was recognized or collected in a period, and it includes one-off charges, usage and annual payments in full when they land.