OneStream XF Foreign Exchange

Follow us on Twitter & LinkedIn for more tutorials, case studies, and articles.

Publication Date: 07/25/2019
Share This Article

With OneStream XF, you are able to complete foreign exchange and cash flow reporting. With this, you will be able to improve insight into the real FX impact of currency on every balance sheet account. FX Rates are stored in separate database tables from the financial model. With this, you can then define any FX Rate Types for multiple sets of FX Rates for combinations of time, source currency, and destination currency. It can also reverse rates(e.g. load rates for GBP and EUR to USD and system can figure out how to load rates the other way around as well).

For every balance sheet account, you can see the foreign exchange rates and activity related to it. You can also break it down to see the FX impact on any changes to the balance.


Loading FX rates can be done in the following ways:

  • Loading through a Flat XML File
  • Loading through a CSV File
  • Manually entering the data from the FXRates Page
  • Using the function (XFSetFXRate) in Excel, to retreive the data, use the function (XFGetFXRate)


Need help implementing OneStream XF? No worries - our consultants at Paradigm SES are well-versed in EPM software and can help your company successfully implement OneStream XF. Feel free to contact us for more information and details. A consultant will get back to you shortly.