1 min read

Adaptive Tips & Tricks: Consistent Currency Reporting

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. 

adaptivetip11

 


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

adaptivetip12


  •  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...

Loving Linked Accounts

Loving Linked Accounts

Imagine this scenario if you will. You have a slick way of planning for Dues & Subscriptions by vendor dimension in a modeled sheet where you can...

Read More
Five Reasons To Switch From FRx Replacement or Management Reporter To Adaptive Insights

Five Reasons To Switch From FRx Replacement or Management Reporter To Adaptive Insights

If you use Management Reporter for your financial reporting it’s time for a change. While Management Reporter has been recently developed and is the...

Read More
Four Steps to Streamlined Financial Reporting

Four Steps to Streamlined Financial Reporting

Does this sound familiar? Your finance team has endless spreadsheets to update and there are multiple users working on countless versions that are...

Read More