Skip to main content

Create a Multi Currency Consolidation

Combine entities of different currencies into a single presentational currency for a consolidated group

Updated today

This feature is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

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:

  1. The same name and

  2. 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:

  1. Click the green Add button in the upper-right corner of the My Companies page

  2. Select Consolidated group

  3. Type in the name of the group

  4. Choose the period range for the group’s financials


    ❗ Notice: Be sure to include all of the prior year data you need for financial analysis, reporting and forecasting for the group. You will not be able to add financial data prior to the date range you select after creating the consolidated group.

  5. From the list, select the companies to be added to the group

  6. Click the green Next button. This option will only appear if you have selected companies with different currencies or financial years.

  7. Choose the presentation currency for the group. This is the currency that will display for analysis, forecasts, and reports for the group. See this article for a full list of our ‘Supported Currencies’.

  8. If the chosen companies operate using different financial years, you will need to choose the first month of the financial year to use for the group as well.

  9. Once you are ready, click Create 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:

  1. Click the green + Add a company button

  2. Select the company(s) you would like to add to the group

To remove a company:

  1. Select the three dots icon located to the right of an individual company

  2. From the drop-down menu, click ‘Remove’.

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:

  1. On the My Companies page, click on a consolidated group’s name. This will take you to the consolidated group’s landing page.

  2. Click the group’s name in the upper left corner of the landing page

  3. Begin typing to update the name

  4. Press ‘Enter’


Change the presentation currency or financial year of a group

Consolidation _ Source Data - Work - Microsoft_ Edge & Knowledge _ Fathom _ Intercom and 4 more pages - Work - Microsoft_ Edge 2026-02-16 at 4.58.17 PM

To change the presentation currency or financial year of a group:

  1. Open the group’s Settings and navigate to the Source Data section

    🎉 Beta feature: Does your group's Settings look different? The updated Consolidated Group Settings are currently in beta. To enable this functionality, you must turn on the beta flag.

  2. Scroll down to ‘Presentation currency’ or ‘Financial year start

  3. To the right of each heading, click on the listed currency or month to open a drop-down menu

  4. Select the correct currency or starting month of the financial year for the group.

    1. This option will only be editable when companies in the group have different currencies or financial years.

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

Did this answer your question?