MRR Dashboard: How to Visualize Monthly Recurring Revenue (2026 Guide)

Written by Chartsy Team
April 5, 2026
Updated October 14, 2026
12 min read

Monthly Recurring Revenue is the most important number in any subscription business. It tells you whether the company is growing, flattening, or quietly declining - and it does so with a precision that one-time revenue figures never can.

Yet most SaaS founders look at MRR in the least useful way possible: a single number on a billing dashboard. No trend line. No breakdown by plan. No comparison to last month. No visibility into whether growth is coming from new customers, expansions, or recoveries - or whether it is being quietly eroded by churn.

An MRR dashboard fixes this. Instead of a number, you get a story. This guide explains exactly what belongs in a proper MRR dashboard, how to build one, and which tools make it fast - whether you bill through Stripe, Paddle, Polar.sh, Freemius, Creem.io or Lemon Squeezy.


What Is an MRR Dashboard?

An MRR dashboard is a visual analytics view that tracks your Monthly Recurring Revenue over time, broken down by the components that drive it. Rather than showing a single total, a good MRR dashboard shows:

  • MRR trend (current vs prior periods)
  • MRR movement: new, expansion, contraction, churned, and reactivation MRR
  • MRR by plan or product tier
  • Churn rate alongside MRR to show net revenue health
  • ARR (MRR × 12) for longer-horizon planning

A well-built MRR dashboard answers the questions every founder actually asks:

"Are we growing faster or slower than last month?" "Where is revenue growth coming from?" "How much revenue did we lose to churn?" "Which plan is the real revenue driver?"


The 6 Metrics Every MRR Dashboard Should Include

1. MRR Trend Over Time

A line chart of total MRR over the last 3, 6, or 12 months is the backbone of any revenue dashboard. The trend line gives you direction: are you accelerating, decelerating, or holding flat?

What to watch: A flattening MRR trend often signals that new revenue is being offset by churn - even if the total number looks healthy month to month.

2. MRR Movement (The Waterfall)

MRR movement breaks down the change in MRR into its components:

Component Definition
New MRR Revenue from brand-new subscribers
Expansion MRR Revenue from existing customers who upgraded or added seats
Contraction MRR Revenue lost from downgrades
Churned MRR Revenue lost from cancellations
Reactivation MRR Revenue recovered from previously churned customers

Net New MRR = New + Expansion + Reactivation − Contraction − Churned

This waterfall view is one of the most diagnostic charts in SaaS analytics. It tells you not just whether MRR grew, but how it grew and what is holding it back. If you only put one chart on your MRR dashboard besides the trend line, make it this one: a month where net new MRR looks fine can still hide a churn spike that new sales happened to cover.

3. MRR by Plan

Breaking MRR down by pricing tier reveals where your revenue actually comes from. In many SaaS businesses, the assumption is that the highest-volume plan drives the most revenue - but the data often surprises.

You might discover that a mid-tier plan customers upgrade to after trial converts much better and contributes more to MRR than the entry-level plan you spend the most time marketing.

4. Churn Rate

MRR growth that outpaces churn is sustainable. MRR growth that is masking high churn is a ticking clock.

Track both customer churn rate (percentage of customers lost) and revenue churn rate (percentage of MRR lost) alongside your total MRR. If MRR is growing but churn is also rising, you need to know.

5. Net Revenue Retention (NRR)

NRR measures how much of last month's revenue you retained this month from the same cohort of customers - including expansions and contractions.

NRR above 100% means your existing customer base is growing on its own, independent of new sales. This is the metric investors care about most because it signals true product-market fit and pricing power.

6. ARR Trend

ARR (Annual Recurring Revenue = MRR × 12) is primarily used for investor conversations, valuations, and strategic planning. Showing ARR trend alongside MRR on the same dashboard gives you both the operational view (MRR) and the long-term trajectory (ARR).


How to Build an MRR Dashboard

Option 1: Build it in a spreadsheet (slow, error-prone)

The classic approach: export CSVs from Stripe, Paddle or whichever billing platform you use, clean the data, write formulas in Excel or Google Sheets to calculate MRR, build charts manually.

This works, but it has real costs:

  • Takes 2–6 hours to set up correctly
  • Errors in formula logic lead to inaccurate MRR (especially around prorations, trials, and cancellations)
  • The spreadsheet goes stale immediately - you have to update it manually every month
  • Sharing requires emailing files or managing spreadsheet access

Option 2: Use Stripe's built-in Dashboard (too limited)

Stripe's Dashboard shows total revenue, subscription counts, and a few basic trend charts. It does not break MRR into movement components, does not segment by plan, and does not calculate NRR or cohort analysis. For anything beyond surface-level monitoring, it runs out of road quickly. Other billing platforms' built-in reports vary in depth, but none of them can combine revenue from more than one platform if you bill through two.

Option 3: Write SQL with Stripe Sigma (requires technical skill)

Stripe Sigma gives you direct SQL access to your Stripe data. A skilled analyst can build a comprehensive MRR dashboard in Sigma - but it requires knowing Stripe's data model, writing correct SQL for each metric, and then manually building charts from query results.

Total time to build a full MRR dashboard in Sigma: 4–10 hours for someone comfortable with SQL. Ongoing maintenance required every time your pricing model changes.

Option 4: Use a dedicated analytics tool (fastest, most accurate)

Chartsy is the revenue and growth dashboard built for SaaS founders. Connect Stripe, Paddle, Polar.sh, Freemius, Creem.io or Lemon Squeezy in a couple of minutes and see your MRR laid out plainly: what it is, what moved it, and where it came from. Add one script to your website and Chartsy follows every customer from first visit to signup to paying subscription, so you can see which channels actually grow your MRR. No spreadsheets, no setup project. When you want more, build custom dashboards around the numbers you care about.

Chartsy calculates MRR, movement, NRR, churn, and all other core SaaS metrics automatically - using invoice data, which is the most accurate source. Your billing history syncs as soon as you connect, so the dashboard covers past months from day one, and it's built around the waterfall above: every month split into new, expansion, contraction, churned and reactivated MRR, so you can see at a glance what moved your revenue.

From there, a custom dashboard can hold exactly the views you check every week:

MRR breakdown for the last 6 months New vs churned MRR for Q1 2026 MRR by pricing plan

You save them to one dashboard. The dashboard stays live - no manual updates, no exports, no SQL. If you bill through more than one platform, you can connect them all to the same account.


MRR Dashboard Best Practices

Use invoice data, not subscription state

The most common MRR calculation error is pulling from subscription records (what customers are "supposed" to pay) instead of invoice records (what they actually paid). Invoice data accounts for discounts, prorations, failed payments, and partial periods - giving you MRR that reflects reality.

Track 12 months of history by default

A 30-day window hides seasonal patterns. A 90-day window misses slow trends. A 12-month view reveals seasonality, the impact of pricing changes, and the long-term direction of growth.

Segment before you analyze

Aggregate MRR tells you what happened. Segmented MRR tells you why. Before drawing conclusions from an MRR trend, segment by plan, geography, acquisition channel, or signup cohort. The real story almost always lives inside a segment. (On Stripe and Paddle, Chartsy can also segment by your own customer and subscription metadata.)

Put the waterfall next to the trend line

MRR trend + MRR movement together tell the complete story. A growing trend with high churned MRR is a warning sign. A flat trend with high expansion MRR is actually encouraging. You need both charts to interpret either one correctly.

Read ARPU, customer count, and refunds together

These numbers mean more side by side than alone. If customers are growing but ARPU is flat, your pricing may not be capturing the value you deliver, or new customers are coming in on a lower tier than existing ones. If ARPU is growing but customer count is flat, you're expanding existing accounts, which is a very different growth story from acquiring new ones. If refunds are rising as a share of net revenue, something is wrong before it shows up in churn.

Keep your top customers one click away

Rank customers by what they pay you each month right now, not by lifetime value or signup date. That list tells you who to protect, who to call before renewal, and whose feedback carries the most weight in product decisions. When it lives on the MRR dashboard instead of in a customer table you have to filter, you check it as part of every review.


Example: A Two-Minute Weekly MRR Review

Here's what a review looks like once the dashboard is in place. You open it on Monday morning and see:

  • MRR is up 4.2% from last month
  • The movements chart shows strong new MRR, but higher churn than the previous two months
  • The plan breakdown shows churn concentrated in your entry-level tier
  • ARPU is up, so the customers you're keeping are higher-value
  • One of your top five customers renewed on a higher tier last week

From those five observations, the week's priorities are clear: the entry-level tier needs attention (is onboarding working? is the price right?), and your expansion motion is working for customers who stick around. That's an actionable conclusion from a two-minute review, not a two-hour analysis. Looking at the same numbers in the same format every week is also how you learn what normal month-over-month movement looks like for your business, which is what makes real anomalies stand out.


Common MRR Dashboard Mistakes

Counting free trials as MRR. Only count active paid subscriptions. Trials inflate MRR and mask your true revenue baseline.

Ignoring failed payments. Customers whose payments fail but whose subscriptions are not yet canceled are "churned in spirit." Keep an eye on delinquent subscriptions separately.

Not adjusting for discounts. A customer on a 50% discount is contributing half the MRR a sticker-price calculation would suggest. Always calculate MRR on what is actually collected.

Using MRR alone for investor reporting. Investors care about MRR growth rate, NRR, and churn rate alongside the absolute number. Presenting MRR in isolation misses the context that makes it meaningful.


Frequently Asked Questions

What is the difference between MRR and ARR?

MRR (Monthly Recurring Revenue) is your predictable monthly revenue from active subscriptions. ARR is MRR multiplied by 12, giving you an annualized view. Most early-stage SaaS companies track MRR day-to-day; ARR is used more in investor and strategic planning contexts.

What's the difference between MRR and revenue in Stripe or Paddle?

Stripe and Paddle report revenue as all cash collected in a period, including one-time charges, annual plans billed upfront, and usage-based fees. MRR is a normalized metric: the predictable monthly revenue from active subscriptions only, adjusted for prorations and discounts. The two are often different numbers, and MRR is the more useful one for tracking growth trends.

How do I calculate MRR from Stripe?

The most accurate way is to sum paid invoice amounts for recurring subscriptions in a given month, excluding one-time charges, trials, and failed payments. Stripe's built-in MRR calculation uses subscription plan prices, which can overstate revenue if discounts or prorations apply. Tools like Chartsy calculate MRR from invoices to avoid this, and do the same for Paddle, Polar.sh, Freemius, Creem.io and Lemon Squeezy.

What is a good MRR growth rate for SaaS?

Early-stage SaaS (under $1M ARR) typically targets 15–20% month-over-month MRR growth. At $1–10M ARR, 10–15% monthly is strong. Growth rates naturally slow as the business scales - investors care more about consistency and NRR than raw growth rate at larger scales.

What is net revenue retention and why does it matter?

NRR measures revenue retained from existing customers after accounting for expansions, contractions, and churn. An NRR above 100% means your existing customers are paying you more over time - a sign of strong product value. Best-in-class SaaS companies have NRR of 120%+.

What is the best free MRR dashboard tool?

Stripe's built-in Dashboard is free, but it doesn't break MRR into movements or segment by plan, and a spreadsheet is free but slow to build and keep accurate. Chartsy doesn't have a free tier, but it has a 14-day trial with no card required: connect Stripe, Paddle, Polar.sh, Freemius, Creem.io or Lemon Squeezy and you get an MRR dashboard with movement breakdown, plan segmentation, and trend visualization - all from your actual invoice data. Paid plans start at $9/month.

How often should I review my MRR dashboard?

Weekly is the most effective cadence for most SaaS founders. Daily reviews help during a high-growth period or while you're troubleshooting a churn spike. Monthly is the minimum: any less often and you miss early signals before they compound.


Build Your MRR Dashboard in Minutes

The most accurate, fastest way to build a complete MRR dashboard is to connect your billing account to Chartsy - Stripe, Paddle, Polar.sh, Freemius, Creem.io or Lemon Squeezy. It takes a couple of minutes, your history syncs automatically, and you skip the SQL and the spreadsheet formulas.

You get your MRR laid out plainly, with every month's movement split into new, expansion, contraction, churn and reactivation, so you always know what moved it. Then build a custom dashboard around the numbers you care about, and it updates automatically as new data comes in.

Connect your billing account and build your MRR dashboard →


Related reading: How Chartsy Calculates MRR · 10 Most Important Metrics Every Founder Should Track

Chartsy Team

Written by

Chartsy Team

Analytics 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
Ministry of Economy and Innovation
Startup Albania

The Chartsy program is realized with the financial support of the Albanian Government through the Ministry of Economy and Innovation, under the Grant 2026 scheme, and is implemented by the Innovation4Albania Agency.