|
Multi-currency Consolidated Groups
In addition to standard consolidated reporting, Fathom enables consolidated group analysis, forecasting, and reporting for entities with different currencies. Please view this article for a full list of supported currencies. These features enable you to create an aggregated view of both the financial and non-financial performance of a group of companies.
For multi-currency consolidations in Fathom, you’re able to:
Combine up to 50 companies in a single consolidated group
Consolidate financial (and/or non-financial) performance
Consolidate companies using different accounting systems
Produce consolidated reports regardless of whether companies have consistent or inconsistent chart of accounts
📝Note: Multi-currency consolidations can only be created from underlying companies with monthly financial data. Companies with quarterly or annual data only cannot be added to multi-currency consolidations.
Methodology
Fathom will consolidate financial results by unifying accounts that have:
The same name and
The same Fathom classification.
Accounts from different companies that have these two elements in common will appear as a single account in the consolidated group, and any associated amounts will be summed accordingly. Fathom does not consolidate accounts based on Account Code.
Accounts with different names can be grouped by creating headings within the Chart of Accounts section of group Settings. Enabling you to view aggregated totals for these accounts within financial statements. See this article for a guide to creating headings.
Exchange Rates
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.
To learn more about our methodology for applying exchange rates and calculating values in multi-currency consolidations, please see our 'Multi-currency Consolidation Methodology' article.
You can also add your own custom exchange rates. For more information on this, view our dedicated article on 'Using Exchange Rates in Fathom'.
Create a multi-currency consolidated group
Before you create a consolidated group, you must first ensure that you have imported each entity into Fathom.
💡Smart Tip: If you're an Advisor or Admin-level user on a Fathom account, you can follow and complete the Consolidation Checklist steps within Fathom. Launch the Consolidation Checklist
To create a multi-currency consolidated group:
|
You will then be taken to the Consolidated Group’s landing page. From here, you can access Analysis, Reports, Forecasts, and Settings for the group and for each underlying company.
💡Smart Tip: If you've set up the Chart of Accounts, KPIs, Targets, and Alerts in another company or group, you can copy these over to quickly set up your new consolidated group.
Update & edit a consolidated group
Update a group's data
Please see our Update a Consolidated Group article for more details.
Add or remove companies
From the consolidated group’s landing page, you can add or remove companies.
To add a company:
|
To remove a company:
|
You can also add companies to and remove them from a group within the Source Data section of group Settings, by selecting the underlined ‘Manage group’ option to the right of the ‘Group members’ heading.
📝 Note: You must have more than two companies in a group to be able to remove a company from the group.
Edit the name of the group
To update a group’s name:
|
Change the presentation currency or financial year of a group
To change the presentation currency or financial year of a group:
|
If you need to change the financial year for an underlying company in the group, see our ‘Managing date ranges and your financial year’ article.
Next steps
Congratulations on creating your consolidated group!
Continue the 'Consolidation Creation Workflow' and finish setting up your consolidated group for analysis, reporting, and forecasting by choosing from one of the next steps below:
What you want to do: | Next step in the setup process: |
Looking to add a group logo or set custom terminology? | |
Ready to check and amend your consolidated group's Chart of Accounts? |
Learn more




