Short answer: Each month, Chartsy takes every subscription's monthly-normalized MRR, as billed on its latest invoice or order, and compares it with the month before. Higher is expansion, lower is contraction, zero is churn, and a subscription's first paying month is new MRR. Prorations and one-time charges are left out, so a mid-cycle upgrade shows up as expansion once the customer is billed at the new price, not as a spike from the proration charge.
Ask most billing dashboards "how much of my MRR growth came from existing customers paying more, versus new customers signing up," and you won't get a direct answer. Stripe, Paddle, Polar.sh, Freemius, Creem.io and Lemon Squeezy don't store an "upgrade" event. What they store is invoices or orders, and every movement has to be worked out from them.
What Is Expansion MRR (and Why It's Hard to Calculate)
Expansion MRR is the extra recurring revenue existing subscriptions bring in through upgrades, add-ons, extra seats or an expiring discount. It's different from new MRR (subscriptions paying for the first time) and reactivation MRR (subscriptions paying again after a gap). Strong expansion means your business grows even in a month with no new customers.
The difficulty is that billing data describes payments, not changes. Whether a given invoice is a renewal, an upgrade, a downgrade or a comeback has to be inferred by comparing what a subscription was billed this month with what it was billed last month.
The Core Technical Problem
Say a customer on a $49/month plan upgrades to $99/month on the 12th of their billing cycle. What lands in your billing data isn't an "upgrade" record. With Stripe's default settings it's:
- A proration credit for the unused part of the $49 plan
- A proration charge for the rest of the cycle on the $99 plan
- From the next renewal, a subscription line at $99
The proration lines are one-off adjustments. If you treat them as recurring revenue, MRR jumps oddly in the month of the change and then settles. The question a founder actually cares about is simpler: the subscription used to be worth $49 a month and is now worth $99, which is $50 of expansion.
Add seats, coupons that expire, pauses, and switches between monthly and annual billing, across providers that each model these differently, and you get the real engineering problem behind "just show me my MRR breakdown."
How Chartsy Classifies Each MRR Movement
For each subscription and each month, Chartsy finds the latest invoice or order whose billing period covers that month. It takes the subscription line on it, subtracts any discount, and normalizes it to a monthly amount. That's the subscription's MRR for the month. Then it compares each month with the one before:
| This month vs. last month | Classification |
|---|---|
| The subscription's first month with MRR | New MRR |
| Higher than last month | Expansion MRR (the difference) |
| Lower than last month, but above zero | Contraction MRR (the difference) |
| Zero this month, above zero last month | Churned MRR |
| Above zero again after a month at zero | Reactivation MRR |
| The same | No movement |
A few consequences of working per subscription:
- A second subscription is new MRR, not expansion. If an existing customer starts another subscription, that subscription's first month counts as new MRR.
- Coming back on a new subscription is new MRR. On most providers a cancelled subscription can't restart, so a customer who cancels and later subscribes again does so on a new subscription. Reactivation is when the same subscription starts paying again after a gap, for example after a pause.
- Bought and cancelled in the same month. A subscription that starts and churns in the same month is counted as both new and churned MRR in that month, so it nets to zero rather than vanishing from the breakdown.
- Discounts count. A coupon that ends shows up as expansion, and a new discount on an existing subscription shows up as contraction, because MRR is what's actually billed.
Handling Proration and Mid-Cycle Changes
Chartsy only reads subscription lines, the lines that bill a full billing period at the plan's price. Proration lines, usage charges and one-time purchases count as revenue but never as MRR, so they can't distort the comparison.
That means a plan change shows up as expansion or contraction in the month the subscription is first billed at its new price. With Stripe's default proration behaviour, the change and the proration both land on the next renewal invoice, so that's the month the movement appears. The amount is always the difference between the old and new monthly rates, wherever in the cycle the change happened.
Handling Billing-Interval Changes
A customer moving from a $49/month plan to a $470/year plan ($39.17/month) is a contraction in monthly terms, even though the annual invoice is larger. Chartsy normalizes every subscription line to a monthly amount before comparing: annual plans are divided by 12, quarterly plans by 3, and weekly plans multiplied by 52/12. Comparing raw invoice totals across intervals is one of the most common reasons two tools report different MRR movement for the same account.
Handling Differences Between Billing Providers
Every provider Chartsy connects has its own data model, and they're normalized into one schema before any classification runs:
- Cancel at period end. A subscription scheduled to cancel keeps its MRR until its paid access ends, and churns in that month. Counting it as churn the day the customer clicks cancel would report still-paying customers as gone. See How We Calculate MRR at Chartsy.
- Invoices vs. orders. Stripe and Paddle bill through invoices or transactions. Polar.sh, Creem.io and Lemon Squeezy bill through orders. Each is mapped so that only the part covering a subscription's billing period becomes MRR.
- Seats and usage. On Polar.sh, per-seat plans count every seat, and metered usage is kept out of MRR.
Because every provider ends up in the same shape, the breakdown adds up across accounts, so a business on Stripe and Paddle at once sees one combined set of movements.
Why This Level of Detail Matters
"MRR went up 4% this month" is enough for a report. It isn't enough to run a business. If MRR grew 4% but expansion was flat and all the growth came from new subscriptions, acquisition is working. If existing subscriptions are expanding, customers are finding enough value to pay you more. Net Revenue Retention, one of the metrics investors look at most closely, is built from expansion, contraction and churn, so getting those classifications right matters.
See Your Own MRR Breakdown
The MRR Breakdown dashboard shows new, expansion, contraction, churned and reactivated MRR month by month for every connected account, with the subscriptions behind each number. You can also ask in Chartsy's chat:
- "Break down this month's MRR into new, expansion, contraction and churned"
- "How much of my MRR growth came from existing customers vs new signups?"
- "Show me my expansion MRR trend for the last 6 months"
Connect your account and see your MRR breakdown →
Frequently Asked Questions
Why doesn't Stripe show expansion and contraction directly in its data?
Because Stripe stores invoices and subscriptions, not a log of plan changes. Stripe's Billing analytics does report expansion and contraction, but if you're working from the raw data or a tool of your own, you have to derive movements by comparing each subscription's monthly-normalized amount month over month.
What's the difference between expansion MRR and new MRR?
New MRR is a subscription's first paying month. Expansion MRR is an existing subscription paying more than last month, through an upgrade, extra seats, an add-on or an expiring discount. In Chartsy, an existing customer who starts a second subscription adds new MRR, not expansion.
When does a mid-cycle upgrade show up as expansion?
In the month the subscription is first billed at its new price. The proration charge counts as revenue, not MRR, so it doesn't inflate the month of the change. The expansion amount is the difference between the old and new monthly rates.
How does Chartsy handle a switch from monthly to annual billing?
By comparing monthly-normalized amounts, not invoice totals. A $470/year plan is about $39.17/month, so moving to it from a $49/month plan is contraction, even though the annual invoice is larger.
What counts as reactivation MRR?
The same subscription paying again after a month with no MRR, for example after a pause. A customer who cancels and later starts a new subscription is counted as new MRR, because it's a new subscription.
Does this work the same way for Paddle, Polar.sh and other providers as for Stripe?
Yes. Each provider's data is normalized into one schema first, and the same classification runs on all of them, so movements are comparable across providers and add up when you connect more than one.
Related: How We Calculate MRR at Chartsy · What Is Expansion MRR? · The MRR Waterfall Chart · What Is Net Revenue Retention (NRR)? · Combining Stripe and Paddle Data Into One Dashboard

Written by
Chartsy TeamAnalytics team at Chartsy
The Chartsy Team writes guides, product updates, and resources to help SaaS and eCommerce founders make sense of their metrics, without SQL or spreadsheets.
Chartsy
