How to Prepare the Monthly MRR Movement Report Showing New, Expansion, Churn, and Contraction
Summarizing monthly MRR movements by cohort (new, expansion, churned, contraction) for management reporting and investor KPI tracking.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| New MRR (New Customers) | Revenue (+) | - | 9,900.00 |
| Expansion MRR (Upgrades) | Revenue (+) | - | 2,000.00 |
| Churned MRR (Cancellations) | Revenue (-) | 1,500.00 | - |
| Contraction MRR (Downgrades) | Revenue (-) | 500.00 | - |
| Net New MRR | Revenue (+) | - | 9,900.00 |
💡 Accountant's Note
This management reporting entry breaks down MRR into its constituent movements — essential for understanding the growth engine of a SaaS business. Investors track New MRR, Expansion, Churn, and Contraction separately.
Practitioner & Systems Framework
💻 ERP Architecture
MRR movement reports are generated from the billing platform, not the financial ERP — Stripe, Chargebee, and Recurly all have built-in MRR analytics. Reconcile the billing platform's MRR report to the ERP's recognized subscription revenue monthly. Discrepancies arise from: timing differences (monthly vs. daily recognition), deferred revenue treatment, and exchange rate differences for multi-currency subscriptions.
⚠️ Audit Flags
Auditors do not typically audit MRR as a financial statement figure (it is a non-GAAP metric), but they will compare it to recognized revenue and Deferred Revenue movements for consistency. If MRR and GAAP revenue diverge significantly without explanation, it is a potential indicator of a revenue recognition problem. Net Revenue Retention (NRR) derived from MRR movements is also scrutinized in due diligence.
📄 Required Documentation
Billing platform MRR movement report, reconciliation of MRR to GAAP subscription revenue (bridge showing timing differences and deferred revenue), customer-level MRR change log (new, churned, expanded, contracted), and ARR (12 × closing MRR) cross-reference to investor reporting.
Automate this entry with the JEH Accounting Suite
Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.
No Subscriptions. Own your data.
Expert Analysis by Qusai Ahmad
General Accountant Supervisor & IFRS Specialist
Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.