Ahead In The Cloud

The Business Solution Partners Blog

Posted by Martin Begley | Feb 14, 2018 8:41:00 AM

Adaptive Tips & Tricks: Consistent Currency Reporting

The problem with exchange rates is thay they fluctuate and affect variances between plans and versions.  Find out below how to fix this problem! 

Exchange rate fluctuations can make analysis of data variances look better or worse based on the change in rates instead of the actual variances of the metrics reviewed. Utilizing a "Consistent Currency" methodology removes the effects of exchange rates to give you an accurate view of your business' performance. With virtual versions, you can use the exchange rates of one plan with the data of another. 

A virtual version is a read only version that uses the data of one version and the exchange rates of another version, or a different time frame. In the virtual version you see the data modified by the exchange rate you choose. 

To report variances of budget to actuals with consistent currency, build the report with the new virtual version and the version you chose for the exchange rate of the new virtual version. 

To create a virtual version:

  • Go to Modeling -> Model Management -> Versions 
  • Click on the 'Create New Virtual Version' icon. Give the new version a name, and select 'Actuals' as the base version. 



  • Then click the 'Edit' link to select the exchange rates of the budget version. 


  •  Next create a matrix report using the virtual version and compare that to your budget version. 

This report will now display data from the actual version that is modified by the exchange rates of the budget version. In doing so, exchange rate fluctuations of different versions do not impact the variances on the report, instead, the variances are compared using consistent currency.


Want to learn more about Adaptive Insights?
Business Solution Partners provides a wealth of Adaptive services, from onboarding to training, designed to help businesses unlock the potential of the CPM platform to realize new efficiences, financial transparency, and overall operational success.

A Modern Approach To Finance, Budget & Reporting. Learn More About Adaptive Insights Today...

Written by Martin Begley

Martin Begley, CISA, is the Director of Business Solution Partner's Adaptive Insights Practice. As a Certified Information Systems Auditor (CISA), he specializes in helping businesses meet strategic goals through the design, implementation and execution of performance management strategies, technology solutions, and corporate policies and procedures.

Leave a Comment