Consolidating companies in Fathom
Fathom enables you to group related companies and easily perform consolidated analysis, generate forecasts, and create reports. These features enable you to create an aggregated view of both the financial and non-financial performance of a group of companies.
This is useful for organisations:
With multiple entities (up to 300 for single-currency consolidations, and up to 50 for multi-currency consolidations)
Seeking to consolidate financial (and/or non-financial) performance
Using different accounting systems
Reporting using either a consistent or inconsistent chart of accounts
Reporting in a single currency or multiple currencies (see this article for multi-currency consolidations)
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 or classifications, can be grouped in the Chart of Accounts with the use of headings. For a guide to creating headings see our Headings and Subheadings article.
KPIs and Budgets will ‘roll up’ from the underlying entities in the consolidated group for use within that group.
Creating a consolidated group
Before you create a consolidated group, you must first ensure that you have imported each entity into Fathom. After all companies are imported, you can create a consolidated group.
You will be taken to the consolidated group’s landing page. From here, you’ll be able to access the group’s Analysis, Reporting, Forecasting, and Settings as well as the Analysis, Reporting, Forecasting, and Settings for all of the underlying companies in the group.
Updating & editing a group
Updating the group’s financial and non-financial data
To update the financial data of the group, you’ll simply need to select the green ‘Update’ button in the upper right corner of the consolidated group’s landing page.
The consolidated group will update based on the underlying companies. This means that, if changes are made to an underlying company in its source accounting system or Excel and you want those changes reflected in the group, you’ll need to:
Adding companies to or removing them from the group
You can add companies to or remove them from a group on the consolidated’s group’s landing page. To add a company, select the green ‘+ Add company’ option. To remove a company, hover over the company and select the ‘three dot’ icon that appears on the right side of the screen. From the drop down menu, select ‘Remove’.
You can also add companies to and remove them from the group in ‘Step 1 - Update Data’ of the group’s Settings. You’ll find the options to add and remove companies by clicking the blue ‘manage group’ option that appears next to the list of member companies in the group.
Changing the name of the group
In the upper left corner of the consolidated group’s landing page, you’ll see the name of the group listed. You can click on the group’s name to edit or type in a new name for the group.
Changing the financial year of the group
To change the financial year of the group, go to the group’s Settings. In ‘Step 1 - Update Data’:
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 setup process:
Ready to begin setting up your Consolidated Group's Profile?
Happy with your profile and ready to set up the consolidated Chart of Accounts?
Additional knowledge & common questions