Skip to main content
Updating a Consolidated Group

How to update data and change configuration for a consolidation

Updated over a month ago

Contents


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 AccountRight Live, or Sage Business Cloud Accounting) underlying companies in a consolidated group.

Companies not sourced from cloud systems must be updated manually.

📝 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:

🎉 Beta Feature: Bulk update is a beta feature! See our Beta Features article to learn how to turn beta features on & off.

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

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

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

  4. 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.

  5. 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 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.


Syncing the group with underlying companies

When results (financial or non-financial) for any member of a consolidated group are updated, Fathom will automatically sync the group with the underlying companies.

The data range of the consolidated group will automatically be extended to include new periods of financial or non-financial data if the ‘Automatically update data range to reflect latest underlying company results’ option is checked in the group’s Settings.

If not checked, the group’s data range will not automatically change to include new periods.

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

To turn on or off the automatic update data range option:

  1. Go to the Settings for the group

  2. Select the Update Data tab

  3. Check or uncheck the ‘Automatically update data range to reflect latest underlying company results’ box

Manually syncing the group

You can manually trigger a sync of the consolidated group with the underlying companies from the group's Settings:

  1. Click on the Settings for the group.

  2. In Update Data of the consolidated group, click Update Consolidated Group

  3. Select the data range of data 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.

    📝 Note: You can manually select and change the group’s data range when the ‘Automatically update data range’ checkbox is unchecked.

  4. Click Update Consolidated Group


Add or remove member 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.

  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 company option at the top of the list of underlying companies.

    2. Add a company to the group and select the green Save changes option to save your 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

To add or remove member companies via the group's 'Settings':

  1. Go to the Settings for the consolidated group

  2. Select the Update Data tab

  3. Select the manage group option next to the list of member companies

  4. Add companies to or remove them from the group

  5. Select the green Save changes option to save the changes you've made


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:


Additional knowledge & common questions

Did this answer your question?