You can view and change the rates being used for foreign exchange on the Load Data tab.

Actuals FX Rates

Rules used for historic figures in the Profit and Loss, Balance Sheet, and Cash Flow:

When translating from accounts in one currency to another (as from a foreign subsidiary to a consolidated parent account), IFRS guidelines are used.

Specifically:

• the P&L uses the average monthly exchange rate in the month being reported. This is calculated using the average daily rate for every day of the month divided by the number of days in the month.
• the Balance Sheet uses the average daily exchange rate on the last day of the month.

Rates are to four significant digits sourced from Open Exchange Rates, www.openexchangerates.org.

Budget FX Rates

Rules used for Budget:

• By default, the Budget uses the exchange rate from the first historical month loaded.  This is fixed for all months.  
• It can be easily changed on the Load Data page using "Budget FX Rates"
• When a rate it changes, it is automatically applied to all dates later than the one edited.

Invoice FX Rates

Rules used for Invoices and Bills generating revenue recognition, MRR and ARR in the Customer page reports

In a subsidiary or single entity, invoices issued use the rate from your accounting system to translate from issue currency to the currency of the accounting entity

• Invoices and bills are translated from issue currency into your accounting system's reporting system using rates generated by your accounting system.  
• These are generally the rates applicable on the date the bill or invoice was created.  
• See your accounting system for more details.

In a consolidated company, the ScaleXP Invoice FX Rates table is used to translate from the subsidiary currency to the parent currency.  On the consolidated Customers page, reports use the accounting system rate, then use "Invoice FX Rates" to translate invoices to the parent currency,.

• The table is based on issue month.  
• Note that, by default, these rates are the same as the P&L rates for actuals - that is, the average for the month.

Rules used for Pending Invoices:

• ScaleXP Invoicing customers: Invoices are converted from invoice currency to the accounting currency of the issuing entity using rates from the accounting system 
• Other CRM customers: You need to enter the future invoices in the rate of the billing subsidiary's accounting system
• For consolidated companies, this is then converted to the currency of the parent
  • These rates are found in the Invoice FX Rates table of the consolidated entity and are, by default, the most recent month end P&L rates
  • Rates for future months can be set in the Invoice FX Rates table at the consolidated company

Rules used for the Revenue Forecast tab data:

• Forecast invoices are converted using the same rules as above for Pending invoices
• Invoices are included in revenue recognition, invoice issued, and cash tabs using the invoiced rates described above

CRM Deals

Rules used for CRM deals:

• For converting from deal currency to your CRM currency, the rate provided by the CRM is used where available.  
  • HubSpot and Salesforce deals are translated from deal currency into your CRM's reporting currency using rates provided by the CRM;
  • For Pipedrive deals, ScaleXP uses “Actual P&L” rate (see above) for the month in which the deal entered the reported stage.

See this article for how to change the exchange rates being used in ScaleXP.