How to change historic FX rates; how do I input my own foreign exchange rates? How do I change the way ScaleXP translates between currencies?

Learn the step-by-step process for changing FX rates within ScaleXP

Written By ScaleXP Customer Success (Super Administrator)

Updated at July 17th, 2025

To change the historic foreign exchange rates used by ScaleXP reporting across all accounts in the P&L or balance sheet, go to the consolidated entity (if relevant), Load Data (top bar)>Actuals FX Rates (left sidebar) and select the rates you wish to change.

  • Select Average (dropdown menu, top right) for P&L
  • Select Last day (dropdown menu, top right) for Balance Sheet
  • Make changes to the currency rates and dates you wish to adjust and press enter
  • Once changed, these rates will replace the default rates used by ScaleXP, which are sourced from Open Exchange Rates with 4 significant digits

To change the exchange rates on the balance sheet only see FX Rates: What foreign exchange rate is being used? 

Consolidated customer page reports:  Note that FX rates for invoices and Customer page reporting at consolidated level are shown separately in the table "Invoice FX Rates".  This is only visible at the consolidated entity and only applies to FX rates between the subsidiary currency and the parent currency.   By default, it is the same as the P&L rate (that is, average for the month).

Translations from the invoice currency to the subsidiary currency are taken from your accounting system and can not be adjusted within ScaleXP.  Similarly, invoices FX rates can not be adjusted individually; all rates apply to any invoices issued in that month.

Remember: changes made at subsidiary level will not be picked up in Consolidated reporting.  To change FX rates used in Consolidated reporting, enter the rates at that entity.

Hint: if your data is not saving, be sure to press the Enter key after each entry.