Get the latest perspectives on Microsoft Dynamics 365 software selection process from industry experts

How to Calculate Multicurrency Sales Forecasts in Dynamics CRM

Visit Website View Our Posts

Updated · Originally published

As a global company, do you have the ability to see a forecast of all your sales opportunities in a single currency?

Let’s say you are a US-based company with sales offices across the globe. One office is entering sales leads and forecasting revenue in Yuan, another in Euros, another in Pesos.

But management needs to be able to see the total forecasted revenue in a single master currency.

With the Sales Pipeline Management add-on for Microsoft Dynamics CRM, sales reps can see a list of opportunities based on local currency, but you can also roll them up to see calculated totals in US dollars or the currency of your choice.

This allows you to see a master forecast of all predicted revenue in a single currency. You can choose to group, sort and calculate based on currency, region, sales rep or other criteria.

For example, in this screenshot below, a sales leader for a global company headquartered in Europe wants to look at the pipeline for North America. He can see individual opportunities in US dollars, but the sub-total and totals in Euros.

This tool eliminates the need to export Dynamics CRM opportunities into Microsoft Excel with a currency conversion formula. That Excel document will soon be outdated and is difficult to share across the organization. When all the information is entered and stays within Dynamics CRM, it is more accurate, more available, and allows you and your team across the globe to make better decisions.

This is just one feature of the Sales Pipeline Management tool for Microsoft Dynamics CRM from ForgeXRM.

To discuss other ways we have helped global sales organizations be more productive with Microsoft Dynamics CRM, contact ForgeXRM.

ForgeXRM + Microsoft

ForgeXRM develops innovative solutions that drive productivity and empower businesses to achieve more with the Microsoft Power Platform and Dynamics 365.

With our deep specialization, industry-leading CRM solutions for Insurance and Wealth Management, and Add-Ons for Project Management and our configurable XRM Grid Control, we accelerate innovation and empower businesses to maximize their CRM investments.

Contact ForgeXRM today. We’d love to connect and learn more about your goals and explore how ForgeXRM + Microsoft can support your organization’s needs.

By Ryan Plourde, ForgeXRM, www.forgexrm.com

Ryan Plourde

By Ryan Plourde, Principle and Owner, ForgeXRM

As Founder of ForgeXRM, I bring 30+ years of experience helping businesses streamline operations and strengthen relationships through CRM/XRM solutions built on Microsoft Dynamics 365 and Power Platform. My focus is on delivering tailored software solutions that solve real business problems, whether you're managing people, products, or processes. Previously, I founded AbleBridge, a leading Microsoft Partner/CRM solutions provider acquired by Crowe LLP, where I led the firm’s Microsoft practice.