How to Troubleshoot and Improve Reporting for MRR, ARR, and Revenue Forecasting in Pipedrive
Understanding and accurately reporting metrics like Monthly Recurring Revenue (MRR), Annual Recurring Revenue (ARR), and other revenue forecasts is vital for effective sales analysis. This article highlights common challenges in reporting, key updates to Pipedrive’s features, and best practices for maintaining accurate data.
General Troubleshooting for Reporting Errors
1. Addressing Currency Mismatches in Reports
If your MRR or other reports display incorrect values, consider the following:
Verify the default currency set in your Pipedrive personal preferences. Report values are calculated based on the user’s default currency, even if product values are stored in another currency.
Adjust the default currency under personal preferences to ensure consistency. For example, if deals are recorded in Canadian dollars but reports show U.S. dollars, matching the default currency to Canadian dollars should resolve the issue.
2. Limitations in Using Custom Fields for Revenue Forecasting
Custom fields added to deals are not directly reflected in revenue forecast reports. Here’s why:
Forecast reports display values based on open deals’ expected close dates and won deals’ won dates.
If deals lack these key dates within the selected filter period, they will not appear in the report.
Use the Deal Performance report instead to include custom monetary fields, regardless of close or won dates. This allows for greater flexibility in custom reporting.
3. Reporting Limitations Due to Permissions
If you notice discrepancies in funnel conversion reports, limited user permissions may be the cause:
Funnel conversion reports only display deals that you have permission to view. Typically, users can only see their own deals unless an admin has granted broader permissions.
Contact your account admin to adjust these settings if necessary.
Updates to MRR and ARR Reporting
Transition from Recurring Revenue to Recurring Products
Pipedrive is replacing the Recurring Revenue feature with the Recurring Products feature. This change impacts how users generate MRR and ARR reports moving forward.
The Recurring Revenue feature has been deprecated.
Use the Recurring Products feature to attach products to deals, set a billing start date, and establish recurring billing intervals such as monthly or annually.
To learn about Recurring Products, visit Recurring Products Documentation.
Adapting MRR Reports
Existing MRR reports will remain accessible, but transitioning to Recurring Products for future reports is necessary. To build new MRR reports:
Start using the Recurring Products feature to define recurring revenue streams for relevant deals.
Make use of resources like Revenue Forecast Insights for detailed instructions.
Best Practices for Revenue Forecasting
Breaking Down Monthly Revenue
For detailed analysis of monthly revenue, you have two primary options:
Using Recurring Products: Automatically calculate periodic revenue by adding recurring products to deals and specifying billing intervals.
Without Recurring Products: Use custom deal fields to estimate monthly revenue manually (e.g., dividing total deal value by contract term), or perform calculations externally and import results into Pipedrive Insights.
Both methods support generating accurate revenue forecasts in the Insights section.
Related Topics
By following these troubleshooting steps, adapting to feature updates, and leveraging best practices, you can ensure accurate and effective revenue reporting in Pipedrive.