Recurring revenue bridge · Calculation guide

Reconcile opening monthly recurring revenue to its closing balance.

Calculation guide

Enter all movements as positive magnitudes for the same month and currency. One-off sales, taxes and exchange-rate effects are excluded. Use one line per movement to avoid double counting.

closing = opening+new_mrr+reactivation+expansion-contraction-churn; change = closing-opening; adds = new_mrr+reactivation+expansion; losses = contraction+churn

Inputs

Opening MRR

Example entry 10000 (in the selected currency).

New business MRR

Example entry 1500 (in the selected currency).

Reactivated MRR

Example entry 200 (in the selected currency).

Expansion MRR

Example entry 800 (in the selected currency).

Contraction MRR

Example entry 300 (in the selected currency).

Churned MRR

Example entry 400 (in the selected currency).

Worked example

InputValue
Opening MRR10,000
New business MRR1,500
Reactivated MRR200
Expansion MRR800
Contraction MRR300
Churned MRR400
ResultValue
Closing MRR11,800
Net MRR movement1,800
Positive movements2,500
Negative movements700

Calculation steps

Closing MRR = (((((Opening MRR + New business MRR) + Reactivated MRR) + Expansion MRR) − Contraction MRR) − Churned MRR)

(((((10,000 + 1,500) + 200) + 800) − 300) − 400) = 11,800

Net MRR movement = (Closing MRR − Opening MRR)

(11,800 − 10,000) = 1,800

Positive movements = ((New business MRR + Reactivated MRR) + Expansion MRR)

((1,500 + 200) + 800) = 2,500

Negative movements = (Contraction MRR + Churned MRR)

(300 + 400) = 700

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening MRR10,00011,000Closing MRR11,80012,800
New business MRR1,5001,650Closing MRR11,80011,950
Reactivated MRR200220Closing MRR11,80011,820
Expansion MRR800880Closing MRR11,80011,880
Contraction MRR300330Closing MRR11,80011,770
Churned MRR400440Closing MRR11,80011,760
Recurring revenue bridge →

Sources