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.
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:
| Group | Customers | Price | MRR |
|---|---|---|---|
| Monthly, list price | 34 | $50 a month | $1,700.00 |
| Monthly, 25% recurring discount | 4 | $37.50 a month | $150.00 |
| Monthly, paused this month | 2 | excluded | $0.00 |
| Annual at $600 | 10 | $50 a month | $500.00 |
| Annual at $1,200 | 5 | $100 a month | $500.00 |
| MRR | 53 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
- Annual and quarterly plans. Spread them across the months they cover. Never count the full amount in the month it is charged.
- Discounts. A coupon that repeats each period lowers MRR. A one-time coupon does not.
- Status. Active counts. Canceled does not. Trials, paused and past-due are the ones to decide on, once, and write down.
- Currency. If you bill in more than one currency, convert at a rate you fix for the month, or your MRR moves with the exchange rate.
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.
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 →