Import Underlying Entities
Before creating a multi-currency consolidated group, import each underlying company into Fathom.
❗ Note: each company can have a different Chart of Accounts. Additionally, consolidated groups can include companies sourced from different accounting systems.
After importing, check that the currency assigned to each company is correct. You can verify this in ‘Step 2: Company Profile’ of the Settings for each company:
You can select up to 50 companies to include in a multi-currency consolidation in Fathom. To create a multi-currency consolidation,
On the ‘My Companies’ page, select ‘Add a Group’
Select ‘Consolidated Group’.
Type in a name for the consolidated group
Select the companies to include in the consolidation
Choose the date range of financial data to include for the consolidated group
Because companies from different regions often have different financial years, you will need to choose the starting month of the financial year for the group as a whole
Choose a presentation currency for the group. (For the full list of currencies, see this article).
Click 'Create Group'
The multi-currency consolidated group will appear as an entity on the ‘My Companies’ page. The financials for each company in the group, will have been translated to the selected presentation currency.
After consolidating, you should review the KPIs, targets and alerts and set them accordingly for the consolidated group. Only library KPIs will be included in the Consolidation Group analysis.
All of the reports that you are familiar with in a single company are also available for a consolidated group. You can now view profitability, cashflow, growth, trends and more for the group as a whole.
There are additional features to be aware of in a consolidated group.
Within the ‘Financials’ tool, you can click on any line item on the Profit & Loss or Balance Sheet to discover the breakdown across the consolidated group.
To view a detailed breakdown of your consolidated group with side-by-side Consolidated and Single-entity financials, go to the 'Reports' section to the Excel report titled ‘Multi-currency consolidated financial results, including eliminations’.
Inter-company eliminations and exchange rate adjustments are also displayed.
The eliminations feature in Fathom assists to remove the impact of transactions between companies in a group, and therefore provides a more accurate view of consolidated performance.
A typical use of an elimination would be to account for inter-company loans or inter-company management fees within a group.
Fathom also provides a more detailed approach for Multi-Currency eliminations, for more information please refer to this article: Multi-currency Eliminations.
Exchange Rates and Methodology
Fathom sources our default historical exchange rates from Open Exchange Rates.
Fathom uses 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. Fathom uses the month end exchange rate for translating Balance Sheet accounts.
For more information, see this detailed FAQ on our default Exchange Rates. You can also add your own custom exchange rates. For more information on this, view our dedicated article on Customising Foreign Exchange Rates.
Please see Multi-currency Consolidation Methodology, to learn more about our methodology for applying exchange rates and calculating values in multi-currency consolidations.