MRR Dashboard Mistakes: 5 Numbers Yours Is Missing
You open the spreadsheet. Numbers look good. You close the laptop satisfied.
Three months later, you're at the cash limit asking where the money went.
That's not bad luck. That's a dashboard problem.
What most people call MRR isn't MRR
Let me be direct: most business owners who say "my recurring revenue is X" are counting it wrong.
Not from lack of competence. Because nobody ever explained clearly what counts and what doesn't.
You're probably adding everything that came in during the month and calling it recurring. Contracts, one-off sales, that random project that landed by accident.
It's not recurring. And the difference matters more than you think.
Recurring revenue is only what you can expect to come in next month, with high predictability, regardless of you running around chasing deals.
Run every line of your spreadsheet through this filter:
| Is it recurring? | Honest answer | |
|---|---|---|
| One-off project of $1,500 | No | |
| Standalone consulting | No | |
| Customer who buys "every month" without a contract | No, that's hope | |
| Signed contract with fixed monthly value | Yes |
When you mix everything into one number, you create an illusion of stability that doesn't exist.
If the basic concept is still fuzzy, start with What is MRR: meaning, calculation, and why it matters.
The question that's going to bother you
If you stopped prospecting tomorrow, how long does your business survive?
If that answer made your stomach knot up, the problem isn't sales. It's that you don't have real visibility on your recurring revenue.
A well-built MRR dashboard answers questions most founders simply can't answer today:
- How much of this month's revenue was already locked in from last month?
- How many customers cancelled and how much did it cost me?
- How much did I really grow, after subtracting cancellations?
- If I close zero new deals, how long do I last?
If you can't answer this from memory, you don't have an MRR dashboard. You have a list of inflows.
The 5 numbers every MRR dashboard needs
Base MRR
New MRR
Expansion MRR
Churn MRR
Net MRR
$5,000 of new MRR with $4,800 of churn isn't growth. It's lying to yourself.
To avoid subtle calculation mistakes, read MRR: 5 calculation traps almost nobody catches. To understand the churn that's eating your dashboard, Churn: 5 real reasons your customers leave.
How illusory growth actually works
The example below uses fake numbers. But you've probably lived something like it.
Recurring service business. February:
| Movement | Value | |---|---| | Base MRR (January) | $5,000 | | New MRR (3 contracts closed) | + $750 | | Churn (2 customers cancelled) | - $700 | | Net MRR for February | $5,050 |
The owner looks and thinks they grew. Technically yes, $50.
But they worked the whole month, closed 3 contracts, got pumped about sales, and grew $50.
That's not growth. It's a treadmill.
Worse: without a structured dashboard, they thought they were growing $750 a month. They didn't know about the churn because they never measured it.
How to build the dashboard without an MBA
You don't need an expensive system. You need three habits:
Active, cancelled, paused, past-due. Each has a status. Don't mix them.
You sit down, look at what came in, what went out, what changed. You update the numbers. Takes 20 minutes. Those 20 minutes are worth more than any strategy meeting you'll have all month.
Two columns. Two separate worlds. One-time revenue is great, but it can't contaminate the clarity of what's predictable.
In 5 minutes, your dashboard should show you this
When you open your MRR dashboard, without doing any math in your head, you should see:
Does your dashboard show this?
Comece marcando os itens que já estão resolvidos no seu negócio.
Visibility
Risk
If answering any of these takes more than 5 minutes, you don't have a dashboard. You have scattered data.
The provocation I want to leave you with
How much of your current MRR would you lose if your 3 biggest customers cancelled tomorrow?
Calculate it. Now.
If the answer made you uncomfortable, welcome to the club. That revenue concentration is a real risk your dashboard should be showing you all the time, not when it's already too late.
Healthy businesses aren't the ones with the most revenue. They're the ones with the most predictable revenue.
18 indicators including MRR, churn, runway, and growth. Right in your browser, no account.
Calculate My KPIs Now →Recurring revenue isn't the money that came in. It's the money that's going to keep coming in. And only an honest dashboard shows you the difference.
Keep reading about KPIs
Gross Burn vs Net Burn: Which One to Use for Runway
Gross burn and net burn are two numbers — and both matter. Using the wrong one for runway distorts cash reality by months.
MRR vs ARR: The Real Difference and When to Use Each
MRR and ARR aren't the same metric viewed from different angles. They serve different functions — and using the wrong one distorts decisions.
SaaS Metrics Guide: The 8 Numbers That Actually Matter
MRR, churn, CAC, LTV, runway, burn rate. The 8 numbers that separate SaaS that survives from SaaS that dies — no fancy formulas, real numerical examples.
Frequently asked questions
What is an MRR dashboard?
An MRR dashboard is the organized snapshot of your monthly recurring revenue. It shows Base MRR, New MRR, Expansion MRR, Churn MRR, and Net MRR: the 5 numbers that separate real growth from illusory growth.
What are the 5 essential numbers in an MRR dashboard?
Base MRR (active contracts at start of month), New MRR (new customers this month), Expansion MRR (upgrades from existing customers), Churn MRR (cancellations and downgrades), and Net MRR (Base + New + Expansion minus Churn).
What's the difference between Gross MRR and Net MRR?
Gross MRR sums everything that came in. Net MRR subtracts cancellations and downgrades. It's the number that matters: it shows whether your recurring base actually grew or shrank during the month.
How do I know if my MRR is really growing?
Compare Net MRR month over month. If it climbs consistently, there's real growth. If it climbs slowly while New MRR is high, churn is masking the result and the business is running on a treadmill.
Do I need an expensive system to build an MRR dashboard?
No. You need three habits: log every contract with date, value, and status; close the books on the 1st of every month; never mix recurring revenue with one-time revenue in the same number. A well-built spreadsheet handles it. Atos Arena's KPI Dashboard calculates everything automatically from your data.