Monthly Recurring Revenue Calculator

Review starting revenue, sales, churn, and upgrades. See ending revenue, ARR, growth rate, and retention. Understand pipeline momentum with metrics, exports, charts, and examples.

Calculator Inputs

The page uses a single-column section flow, while the calculator inputs switch to 3 columns on large screens, 2 on medium screens, and 1 on mobile.

Customer Base

Active customers at the beginning of the month.
Average recurring monthly revenue per active account.
Optional revenue target for goal tracking.

Customer Changes

New monthly-billed customer wins.
Previously lost accounts that returned this month.
Accounts fully lost during the month.

Revenue Drivers

Annual deal value, converted into monthly recurring revenue.
Upsells, seat additions, add-ons, or plan upgrades.
Recurring usage revenue counted this month.
Downgrades or reduced recurring spend.
Recurring discounts, rebates, or credits.
Implementation, setup, or other non-recurring fees.

Example Data Table

Input Item Example Value
Starting Customers120
Average MRR Per Account$85.00
New Customers18
Reactivated Customers5
Churned Customers9
New Annual Contract Value$7,200.00
Expansion MRR$950.00
Usage-Based MRR$240.00
Contraction MRR$300.00
Discount/Credit MRR$180.00
One-Time Fees Excluded$1,200.00
Target MRR Goal$15,000.00
Example Output Result
Beginning MRR$10,200.00
Ending MRR$12,700.00
Net New MRR$2,500.00
ARR$152,400.00
Logo Churn Rate7.50%
Gross Revenue Churn Rate12.21%
Net Revenue Retention99.46%
Goal Attainment84.67%

Formula Used

Metric Formula
Beginning MRR Starting Customers × Average MRR Per Account
New Monthly MRR New Customers × Average MRR Per Account
Annual Contract MRR New Annual Contract Value ÷ 12
Reactivation MRR Reactivated Customers × Average MRR Per Account
Churned MRR Churned Customers × Average MRR Per Account
Ending MRR Beginning MRR + New Monthly MRR + Annual Contract MRR + Reactivation MRR + Expansion MRR + Usage-Based MRR − Churned MRR − Contraction MRR − Discount/Credit MRR
Net New MRR Ending MRR − Beginning MRR
ARR Ending MRR × 12
Growth Rate (Net New MRR ÷ Beginning MRR) × 100
Logo Churn Rate (Churned Customers ÷ Starting Customers) × 100
Gross Revenue Churn Rate ((Churned MRR + Contraction MRR + Discount/Credit MRR) ÷ Beginning MRR) × 100
Net Revenue Retention ((Beginning MRR + Expansion MRR + Usage-Based MRR − Contraction MRR − Churned MRR − Discount/Credit MRR) ÷ Beginning MRR) × 100
Ending ARPA Ending MRR ÷ Ending Customers

One-time fees are displayed separately and excluded from MRR because they do not repeat monthly.

How to Use This Calculator

  1. Enter your starting customer count and average MRR per account.
  2. Add customer movement for the month: new, reactivated, and churned accounts.
  3. Enter recurring revenue drivers such as expansion, usage, contraction, and discounts.
  4. Add annual contract value if you want it normalized into monthly recurring revenue.
  5. Optionally enter a target MRR goal and one-time fees for extra reporting.
  6. Click Calculate MRR to view the result block above the form.
  7. Use the CSV and PDF buttons to export the calculated metrics.
  8. Review the Plotly charts to see your MRR bridge and customer movement visually.

Frequently Asked Questions

1) What is monthly recurring revenue?

Monthly recurring revenue is the predictable subscription income expected each month. It excludes one-time setup charges, services, and non-recurring project revenue.

2) Why are annual contracts divided by 12?

Annual deals are normalized into monthly value so recurring revenue can be compared consistently across monthly-billed and annual-billed customers.

3) Should one-time onboarding fees be included in MRR?

No. One-time fees are not recurring, so they should be tracked separately. This calculator shows them outside the MRR total.

4) What is the difference between churn and contraction?

Churn is the full loss of a customer account. Contraction is reduced recurring spend from an existing customer who still remains active.

5) What does net revenue retention show?

Net revenue retention shows how well existing revenue holds up after expansion, usage growth, churn, downgrades, and recurring discounts are considered.

6) Can this calculator help pipeline forecasting?

Yes. It turns customer movement and revenue drivers into MRR metrics, making it easier to estimate short-term subscription growth and revenue quality.

7) What does ending ARPA mean?

Ending ARPA is average recurring revenue per active account at month-end. It helps reveal pricing quality, upsell impact, and account mix shifts.

8) When should I use gross revenue churn instead of logo churn?

Use gross revenue churn when revenue loss matters more than customer count. It captures the financial impact of churn, downgrades, and recurring credits.

Related Calculators

revenue retention calculator

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.