Where the default rates come from
Fathom's default historical exchange rates are sourced from Open Exchange Rates. We use an inter-bank (without retail fluctuations), mid-market (average of buy/sell rates) rate which is calculated end-of-day using an average of rates from the preceding day.
For monthly data, Fathom uses the average exchange rate over the month to translate the Profit & Loss accounts and the month end exchange rate for translating Balance Sheet accounts.
Future periods will use the exchange rates from the most recently completed month.
For example, if the report is run in the middle of January, we will use the average exchange rate for December for the Profit & Loss and the end of month exchange rate for December for the Balance Sheet for January and all future periods.
For more detailed information on how exchange rates are applied in multi-currency consolidations, please see our 'Multi-currency Consolidation Methodology' article.
Using custom exchange rates
Fathom’s custom foreign exchange (FX) editor for multi-currency consolidated groups enables you to override Fathom’s default FX rates with your own custom exchange rates. This gives you flexibility and control in presenting your financial results in a multi-currency consolidated group.
❗Note: This feature is ONLY available in a multi-currency consolidated group. For more information on creating a multi-currency consolidation, please view our ‘Creating a Multi-currency Consolidation’ article.
Accessing the FX Editor
From the ‘My Companies’ screen, hover your mouse over a multi-currency consolidated group and click the ‘Cog/Gear’ icon that appears in the row for the consolidation. To customise exchange rates:
Understanding the FX Editor
Fathom will display each underlying currency in separate tables for the P&L and Balance Sheet. The P&L uses monthly average rates, whilst the Balance sheet uses month end rates.
The currencies that are shown for each table are taken from the currencies of your underlying companies. The direction of the conversion of each rate is:
Functional currency of individual company → Presentation currency of consolidated group
Example: One of the underlying companies is in Japanese Yen (JPY), and the consolidated group is in US dollars (USD). The exchange rates shown are JPY/USD ≅ 0.0093, meaning that .0093 Japanese Yen is equal to 1 US dollar.
❗Note: There is currently no option to reverse the direction of these rates.
Using the FX Editor
In the FX Editor, you’re able to:
Selecting the period range
At any time, you’re able to view 6 months of exchange rates for your consolidated group’s Profit & Loss (P&L) and Balance Sheet. This is based on the financial year of your consolidated group, specified in ‘Step 1 - Update Data’.
You can navigate between time periods by:
Selecting the financial year using the dropdown box and
Clicking on the left/right arrows at the top of the table to quickly navigate to the previous or next 6 month period
Manually adding custom exchange rates
To add your own custom FX rates, you can simply type them into the cells for the P&L and Balance sheet tables. This will override the default FX rates applied by Fathom.
After making changes to any default rate, a small blue triangle icon will appear in the top right corner of the cell. This will allow you to quickly identify any custom rates. You can also hover your mouse over this icon to see the initial default rate.
💡Pro-tip: When editing exchange rates within cells, press ‘TAB’ on your keyboard to quickly move to the next cell. You can also hit ‘ENTER (RETURN)’ to save any changes made.
Fix custom rates over a range
Fathom enables you to fix a single exchange rate across a custom period.
You can then choose to fix rates for all periods, or for a custom period.
View and edit exchange rates using Excel
In addition to manually customising FX rates within Fathom, you’re able to upload an Excel file with your custom FX rates. This is useful if you wish to add many custom exchange rates across multiple periods.
❗Note: Any cells that are left blank when uploading will use Fathom's default rate.
Once you have added your custom rates to the Excel file, upload it back into Fathom. You will see a summary of the changes made, as well as any potential issues with the upload file.
Troubleshooting issues in your Excel import
The first step to troubleshooting any issues in your Excel import is to review the upload modal screen after uploading your file.
Fathom will provide a detailed description of each specific issue, as well as the effect of this on your upload. You can also see the exact cells that the issue is located in by hovering your mouse over the information tooltip (the ‘?’ icon).
❗Note: You will be able to proceed with the upload despite any issues that are found.
We recommend that you download the import template directly from Fathom, rather than recreate it yourself. Potential issues can include:
Cells have been left empty, in which the default rate will be applied
Cells contain invalid values (special characters or text)
The Excel file is not in the correct import template
If you are unable to resolve the issue or have any questions about your Excel import, please reach out to our support team at firstname.lastname@example.org. In your message, please attach the custom rates Excel file that you are uploading.
Reset to default rates
At any time, you can reset any custom exchange rates back to the default rate provided by Fathom.
This can be done:
One cell at a time. Hover your mouse over the cell, and click ‘Overflow menu (3 dot icon). Then, select ‘Reset to default rate’.
For all periods, or for a custom period. Hover your mouse over the currency name in the table (left-most cell). Click on the option to ‘Reset’. You can then choose to reset rates to default for all periods, or for a custom period.