Build an MRR rollforward you can explain customer by customer

An MRR rollforward explains how monthly recurring revenue changes between two dates. Write down which subscriptions qualify, how annual contracts are normalized, how discounts are treated, and what happens to overdue accounts. Keep implementation fees, taxes, and other nonrecurring amounts outside the measure unless your definition explicitly says otherwise.

Billing platforms have their own definitions and settings. Stripe, for example, documents the subscription statuses and discount settings used in its analytics. Save the definition and configuration with each reporting process so a settings change does not appear to be a commercial improvement.

Join the opening and closing exports using a stable customer reference. A customer may hold multiple subscriptions or move between plans without becoming a new customer. If the identifier changes during a migration, retain a crosswalk rather than counting the old account as churn and the new account as an acquisition.

Calculate each customer's opening MRR, closing MRR, and change. Then classify the movement using consistent rules. Review customers with both expansion and contraction during the period; a month-end snapshot and an event-based movement report can tell different but valid stories.

Suppose opening MRR is $40,000. During the month the company adds $6,000 from new customers, $2,000 from expansion, and $1,000 from reactivation. Contraction removes $1,500 and churn removes $3,000. With no currency or other adjustment, closing MRR is $44,500.

Tie each movement category to a customer list and reconcile the sum to the closing export. Keep unexplained differences in an exception row while investigating them; do not label the residual expansion just to make the total agree.

MRR is an operating metric, not a substitute for recognized revenue or cash collections. Use a separate reconciliation to explain why the metric differs from the profit and loss statement. Annual prepayments, nonrecurring fees, service timing, and collection status can all matter.

Before sending the rollforward to investors, compare it with the prior report's closing figure and review unusual customer movements. Record definition changes explicitly. A stable calculation that reveals disappointing churn is more useful than a changing calculation that produces a smoother growth line.