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.