Build a SaaS MRR bridge for new, expansion, contraction, and churn
Classify each account's opening-to-closing recurring revenue movement once, then reconcile the signed movements exactly to closing MRR. Start with the what one row represents and definitions, calculate only from eligible records, and check the result against the source before using it.
From the field · SaaS finance manager
Classify each account's opening-to-closing recurring revenue movement once, then reconcile the signed movements exactly to closing MRR.
A finance manager receives billing invoices, contract changes, and CRM account exports. Upgrades can be backdated, credits appear as negative invoices, and one customer may hold several subscriptions, so summing invoice rows does not produce a reliable MRR bridge.
Columns used in the example
account_id · subscription_id · month · opening_mrr · closing_mrr · movement_type · contract_start · contract_end · currency
Follow it with your own file
- Create one month-end subscription snapshot and preserve account and subscription identifiers.
- Calculate signed MRR change and classify mutually exclusive new, expansion, contraction, churn, and reactivation movements.
- Convert currencies using one approved rate convention and reconcile opening MRR plus movements to closing MRR.
- Review backdated amendments and accounts with simultaneous expansion and contraction before publishing.
Check: Opening MRR plus every signed movement must equal closing MRR by subscription, account, currency, and consolidated total, with no unexplained residual.
What needs resolving first
A finance manager receives billing invoices, contract changes, and CRM account exports. Upgrades can be backdated, credits appear as negative invoices, and one customer may hold several subscriptions, so summing invoice rows does not produce a reliable MRR bridge.
Frame the decision before calculating
Classify each account's opening-to-closing recurring revenue movement once, then reconcile the signed movements exactly to closing MRR.
The exception that can reverse the conclusion
A cancelled subscription that restarts in the same month may be reactivation or a correction; the commercial definition must decide the classification.
What changes the answer
- Classify each account's opening-to-closing recurring revenue movement once, then reconcile the signed movements exactly to closing MRR.
- Opening MRR plus every signed movement must equal closing MRR by subscription, account, currency, and consolidated total, with no unexplained residual.
- A cancelled subscription that restarts in the same month may be reactivation or a correction; the commercial definition must decide the classification.
Build the result step by step
- Define the decision: Create one month-end subscription snapshot and preserve account and subscription identifiers.
- Prepare the evidence: Calculate signed MRR change and classify mutually exclusive new, expansion, contraction, churn, and reactivation movements.
- Calculate the result: Convert currencies using one approved rate convention and reconcile opening MRR plus movements to closing MRR.
- Review the exceptions: Review backdated amendments and accounts with simultaneous expansion and contraction before publishing.
Choose the depth of analysis the decision deserves
| Approach | What it answers | What remains at risk |
|---|---|---|
| Quick spreadsheet total | A narrow descriptive question | Definitions, duplicate rows, timing, and exceptions may be hidden |
| Reviewed analysis | The stated decision with reconciled evidence | Human judgment is still required for policy and action |
| Ongoing monitored workflow | The same decision across new periods | unexpected column changes and changed business rules still need review |
Warning signs in the file
- The source files do not share one documented what one row represents or cutoff.
- The decision owner cannot trace the headline result to eligible source records.
- A cancelled subscription that restarts in the same month may be reactivation or a correction; the commercial definition must decide the classification.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Build and reconcile a SaaS monthly recurring revenue bridge. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Data Profiling · Natural Language Analysis · Chart Export · Report Drafts
Make the output easy to check
- what one row represents and eligible population documented
- Dates, units, currencies, and identifiers validated
- Opening MRR plus every signed movement must equal closing MRR by subscription, account, currency, and consolidated total, with no unexplained residual.
- Exceptions retained for human review
- Published result links back to its evidence
A decision-ready result for “Build and reconcile a SaaS monthly recurring revenue bridge,” with its assumptions, exceptions, and source totals still visible.
Questions readers usually ask next
Can this saas finance manager analysis be done in Excel?
Yes for a small, stable file. Keep the source unchanged, document formulas and exclusions, and check outputs against the source.
What should not be automated?
Do not automate the final policy or business judgment. A cancelled subscription that restarts in the same month may be reactivation or a correction; the commercial definition must decide the classification.