How do I calculate ARR and MRR in Revenue Cloud
If you run a subscription-based business, knowing your Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR) is critical. These numbers help you track growth, forecast income, and make better business decisions.
Salesforce Revenue Cloud makes this easier—if you know where to look.
At SOLVD.cloud, we help mid-market SaaS teams automate revenue operations using Salesforce. In this post, we’ll walk you through how to track MRR and ARR using Revenue Cloud Advanced—even if you're not using the CPQ module.
What Do MRR and ARR Actually Mean?
Let’s start with the basics:
MRR (Monthly Recurring Revenue)
This is the predictable revenue you expect each month from active subscriptions.If a customer pays $500 per month, your MRR is $500.
ARR (Annual Recurring Revenue)
Simply your MRR multiplied by 12.If your MRR is $500, your ARR is $6,000.
These metrics give you real-time insight into the health and momentum of your business.
Where to Start in Revenue Cloud
In Salesforce, MRR and ARR are usually calculated using Quote Lines. Each Quote represents a customer agreement, and Quote Lines represent individual products or services.
Key fields on each quote line typically include:
- Price (SBQQ__NetTotal__c)
- Quantity
- Start Date and End Date
- Term (duration of the contract in months)
These fields are essential for calculating recurring revenue.
The Formula for MRR
The most common formula we use is:
MRR = Total Price ÷ Term (in months)
Important: It doesn’t matter how the customer is billed (monthly, quarterly, or annually). MRR is based on the total contract value spread evenly over the contract term.
Example:
If the total price is $12,000
And the term is 12 months
Then:
MRR = 12,000 ÷ 12 = $1,000
How to Set It Up in Salesforce
You’ll typically configure this in two main places:
1. On the Quote Line Object
Create a formula field (e.g., MRR__c) using:
MRR__c = SBQQ__NetTotal__c / Term_Months__c
If Term_Months__c doesn’t already exist, create a formula field:
Term_Months__c = (EndDate__c - StartDate__c) / 30
✅ Be sure to account for partial months if precise accuracy is needed for financial reporting.
2. On the Quote Object
Use Roll-Up Summary Fields to total the MRR from all quote lines:
- Total_MRR__c (sum of MRR__c)
- ARR__c (a formula field):
ARR__c = Total_MRR__c * 12“We typically roll up MRR from quote lines to the quote header using standard Salesforce roll-up summaries.” - Connor Sandstrom, SOLVD Consultant
Important Reminders
- Data integrity is key.
Ensure your Quote Lines have accurate pricing, dates, and durations.
- These numbers are projections.
Until the opportunity is closed-won and the revenue is recognized, MRR and ARR are estimates based on quote terms.
- For forecasting, consider adding quote-level fields like Probability or Validity Date to contextualize projected revenue.
“ARR and MRR derived from quotes are great for forecasting, but don’t reflect actual bookings until the deal closes.” - Connor Sandstrom, SOLVD Consultant
Real-World Example
A SaaS company signs a 1-year, $24,000 deal. The quote has:
- SBQQ__NetTotal__c = $24,000
- Start Date: Jan 1
- End Date: Dec 31
MRR = $2,000, ARR = $24,000
These numbers roll up to the quote object and can feed dashboards, forecasting reports, or be included in approval workflows.
Final Thoughts
Setting up MRR and ARR tracking in Revenue Cloud is straightforward once your fields and formulas are configured correctly. Once it’s running, it gives your team the visibility they need to forecast, grow, and plan with confidence.
“It’s easy to set up MRR and ARR when you know which fields to use—and what to look out for.”— Connor Sandstrom, SOLVD Consultant
Want Help Automating Revenue Reporting?
We help SaaS teams use Revenue Cloud to automate quoting, forecasting, and revenue reporting—so you always know where your numbers stand.
Let’s make your revenue engine smarter, faster, and easier to scale.