Skip to main content

Update a Consolidated Group

How to update data and manage a consolidated group’s data

Updated this week

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.

Update underlying companies

A consolidated group will be as up-to-date as its underlying companies.

If you've made any changes to the financials in the source accounting system of the underlying companies, you'll need to ensure the underlying companies are updated for the group to reflect the latest results.

You can bulk update the financials for any cloud-sourced (Xero, QuickBooks Online, MYOB Business, FreeAgent, or Sage Business Cloud Accounting), Sage 50 Accounts, or Excel-based underlying companies in a consolidated group.

Companies sourced from QuickBooks Desktop or MYOB Desktop must be updated individually.

📝 Note: Budget and non-financial data for underlying companies must be updated manually and then synced with the consolidated group.

To bulk update the companies in a consolidated group:

  1. On the My Companies page, select the group’s name.
    ​
    ​

  2. Click on the Revolving Arrows icon in the lower left corner
    ​
    ​

  3. Click either Cloud companies or Desktop companies. If your group includes a mix of cloud and desktop companies, you must bulk-update them separately.

    1. For cloud companies:

      1. The cloud-sourced underlying companies in the group will be automatically listed in the modal.

      2. Select all the companies by checking the box at the top of the list
        ​
        📝 Note: You will not be able to select companies currently being updated.
        ​

    2. For desktop companies:

      1. Click to upload.

      2. Select your files.

        1. You can have one file per Excel company you're updating. Update file details can be found here: Excel

        2. You must have two files per Sage 50 Accounts company you're updating. Update file details can be found here: ​Sage 50 Accounts
          ​
          🎉 Beta feature: Bulk update for Sage 50 Accounts and Excel companies is currently in beta. To ​access this feature, you must turn on the beta flag.
          ​
          ​

  4. Click Update companies.

During the bulk update, you can close the progress modal and continue working in the other areas of Fathom.

You can track the progress of bulk updates at any time by selecting the Update Companies icon on the black bar at the top of the page.

For more information about bulk updating companies, please see our Bulk Updating Financials article.

Sync the group with the underlying companies

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

Fathom will sync the group with the underlying companies when:

  • A scheduled report for the group is to be created
    ​

  • You access the group (go to the group's Settings, Analysis, Reports, or Forecast)

The data range of the consolidated group will automatically be extended to include new period(s) of financial or non-financial data if the ‘Automatically sync data range to reflect latest underlying company results’ option is toggled on in the Source Data section of group Settings.

If the option is 'off’, the group’s data range will not automatically change to include new periods.

This option is turned on by default for a consolidated group.

Consolidation _ Source Data and 11 more pages - Work - Microsoft_ Edge 2026-02-18 at 3.12.43 PM

To turn on or off the 'automatically sync data range' option:

  1. Go to the Source Data section of group Settings
    ​
    ​

  2. Toggle on or off the ‘Automatically sync data range to reflect latest underlying company results’ option

Manually sync the group

Consolidation _ Source Data and 12 more pages - Work - Microsoft_ Edge 2026-02-18 at 3.14.01 PM

To manually sync a consolidated group’s data:

  1. Go to the Source Data section of group Settings
    ​
    ​

  2. Click Sync results
    ​
    ​

  3. Select the data range to include for the group


    ​
    ❗Notice: Once you change the start date for the group, you will not be able to add prior periods back to the group. Do not change the group's starting period unless you no longer want to include that data in the group and will not want to include it in the future. ​


    ​

  4. Click Update data

Add or remove underlying companies

You can add companies to or remove them from a group in the consolidated group's Settings or from the consolidated group's landing page.

You must have at least two companies in the group to remove a company from the group.

Anacott Group _ Fathom and 1 more page - Work - Microsoft_ Edge 2026-02-16 at 4.16.41 PM

To add or remove a company from a group:

  1. From the My Companies page, click on the consolidated group's name
    ​
    ​

  2. To add a company to the group:

    1. Select the green + Add a company button in the upper right corner

    2. In the list of available entities, hover over the company you would like to add and click the green Plus icon

    3. Save changes
      ​
      ​

  3. To remove a company from the group:

    1. Click on the Three dots icon to the right of the company's name for the company you want to remove

    2. Select Remove

Consolidation _ Source Data and 13 more pages - Work - Microsoft_ Edge 2026-02-18 at 3.17.15 PM

To add or remove member companies from group Settings:

  1. Open the Source Data section of group Settings
    ​
    ​

  2. Click the Manage group option to the right of the Group members heading
    ​
    ​

  3. Select the companies you would like to add or remove from the group
    ​
    ​

  4. Save changes

Want to create and set up a consolidated group?

We recommend going through our 'Consolidation Creation & Set Up Workflow'.

You can access the beginning of this workflow using the option below:
​

Create & set up a Consolidated Group in Fathom

Learn more

Did this answer your question?