This chapter covers how to track Monthly Recurring Revenue (MRR) in Salesforce by automatically generating Monthly Revenue Event records. Instead of viewing revenue only at contract turnover, this approach provides a continuous, month-by-month view of recurring revenue trends.

By leveraging Apex automation and Flows, we can ensure that every Closed Won Opportunity generates MRR records, accurately reflecting revenue movement over time.

Data Model

First, introduce the Monthly Revenue Event (MRE) object to track recurring revenue. This object links to Accounts and Opportunities through Master-Detail relationships, ensuring data integrity. Key fields like Month, Type, and Amount provide the foundation for tracking and reporting revenue trends. This object provides the necessary structure for the Apex class to generate MRE records automatically when Opportunities are closed.

Figure 1: MRE Object Schema

Untitled

YouTube Series Embed:

https://www.youtube.com/watch?v=gtiy3X0xVIM