Why a Broken MRR Schedule Can Kill Your SaaS Funding Round

If you run a software business, your MRR schedule is the single most scrutinised document in any fundraise or exit process. Not the P&L. Not the financial model. The MRR schedule.

Investors value SaaS companies on recurring revenue because it is predictable, scalable, and has near-zero marginal cost per additional subscription. That predictability is what justifies premium valuations. But if your MRR schedule is inaccurate, incomplete, or cannot be reconciled to your accounting records, you are handing investors a reason to walk away.

I have seen funding rounds collapse in due diligence because the MRR schedule did not match the P&L. I have seen exit valuations reduced by 20% because one-off revenue was mixed in with recurring. These are avoidable problems, but only if you get the MRR schedule right from the start.

What an MRR schedule must contain

An MRR schedule is a customer-level record of every active subscription, showing the monthly recurring revenue for each customer for each month. At minimum, it must include:

• Customer name
• Product or licence type
• Contract start and end dates
• Monthly recurring revenue (MRR) per month
• Status (active, churned, paused)

From this data, you derive the metrics that investors care about: ARR, growth rate, churn rate, net revenue retention, and unit economics. Without a clean MRR schedule, none of these metrics are reliable.

MRR movement categories

A static list of customers and their MRR is useful but insufficient. Investors want to see how your MRR changes month to month, broken down into five movement categories:

New MRR: Revenue from customers who subscribed for the first time this month. This is your new logo acquisition -- the direct output of your sales and marketing efforts.

Expansion MRR: Additional revenue from existing customers. This includes upsells (moving to a higher plan), cross-sells (buying additional products), and seat-based expansion. Expansion MRR is the strongest signal that customers find increasing value in your product.

Contraction MRR: Revenue lost from existing customers who downgraded but did not leave entirely. A customer moving from a £2,000/month plan to a £1,200/month plan generates £800 of contraction MRR.

Churn MRR: Revenue lost from customers who cancelled completely. This is the number that keeps SaaS founders awake at night. Monthly logo churn above 3% (or annual gross revenue churn above 15%) is a serious concern for investors.

Reactivation MRR: Revenue from customers who previously churned and have now returned. This is typically small but worth tracking separately -- it shows your product has lasting value.

The MRR waterfall

These movements combine into a waterfall that shows exactly how your recurring revenue evolves:

Closing MRR = Opening MRR + New + Expansion - Contraction - Churn + Reactivation

For example:

This waterfall is what investors use to assess the health of your business. They are looking at the balance between new business and losses. If churn consistently exceeds new plus expansion, the business is shrinking regardless of what the top line says.

Gross vs Net Revenue Retention

Two retention metrics matter above all others:

Gross Revenue Retention (GRR) measures how much revenue you keep from existing customers, excluding expansion. It answers: of the revenue you had 12 months ago, how much is still here?

GRR = (Opening ARR - Contraction - Churn) / Opening ARR

GRR is always 100% or below. For B2B SaaS, investors expect GRR above 85%. Below 80% and you have a product-market fit problem.

Net Revenue Retention (NRR) includes expansion. It answers: of the revenue you had 12 months ago, how much do those same customers generate today?

NRR = (Opening ARR + Expansion - Contraction - Churn) / Opening ARR

NRR can exceed 100%, and the best SaaS companies achieve 110% to 130%. An NRR above 100% means your existing customer base grows on its own, even without new logos. This is the metric that gets investors genuinely excited because it demonstrates compounding revenue growth.

How to reconcile MRR to the P&L

The cross-check that investors always perform -- and where most SaaS companies fail -- is reconciling the MRR schedule to the profit and loss statement.

The principle is simple: the total MRR from your schedule, when multiplied by the number of months, should approximately equal the recurring revenue in your P&L. They will not match exactly (timing differences, credit notes, FX adjustments), but they should be within 5%.

Here is the process:

1. Take closing MRR from your schedule for each month.
2. Sum the 12 monthly MRR figures to get total recognised recurring revenue for the year.
3. Compare that sum to the recurring revenue lines in your P&L.
4. Investigate and document every variance above 1%.

Common causes of variance:

• Revenue recognised before or after the subscription starts. Under FRS 102, revenue is recognised when the performance obligation is satisfied -- not when invoiced.
• One-off revenue mixed into recurring lines. Setup fees, implementation charges, and professional services must sit in separate P&L lines.
• Credit notes and refunds not reflected in the MRR schedule. If you issue a credit note in the accounting system but do not update the MRR schedule, the two will diverge.
• Multi-currency customers. If you invoice in USD but report in GBP, exchange rate differences create variances unless you use consistent rates.

What happens when MRR does not reconcile

During due diligence, the investor’s financial adviser will request your MRR schedule and your management accounts. They will perform the reconciliation above. If it does not work:

First, they ask questions. Can you explain the £15,000 variance in March? Why is the MRR schedule showing £92,000 but the P&L shows £107,000?

Then, they lose confidence. If you cannot explain the variances quickly and clearly, the investor starts questioning every other number you have presented. The financial model, the growth projections, the unit economics -- all come under suspicion.

Finally, they reprice or walk away. I have seen a Series A round repriced downward by 15% because the MRR schedule had never been reconciled to the P&L. The numbers were not fraudulent -- they were just sloppy. But sloppy financials at the point of investment signal sloppy financials going forward, and investors price that risk in.

How to structure your P&L for clean reconciliation

Your P&L revenue section should separate recurring from non-recurring income at a minimum:

• Revenue -- Licence (New): First-year revenue from new customers
• Revenue -- Licence (Recurring): Revenue from customers in year two and beyond
• Revenue -- Professional Services: Implementation, training, consulting
• Revenue -- Other: One-off fees, setup charges

This structure lets you calculate customer acquisition cost accurately (by comparing S&M costs against new revenue) and makes the MRR-to-P&L reconciliation straightforward.

Getting your MRR schedule right

If your MRR schedule is broken, incomplete, or has never been reconciled, fix it before your next investor conversation. A fractional CFO can build or rebuild your MRR schedule, establish the movement categories, set up the P&L reconciliation, and calculate your retention metrics -- typically within two to three weeks.

The cost of getting this wrong is not a few hours of extra due diligence. It is a lower valuation, delayed funding, or a deal that falls apart entirely.