Can you consolidate divisions in Fathom?

Fathom's consolidation features allow you to group multiple entities together, to easily view their combined performance from an overall view.

You can also use these consolidation features with your divisions if you wish to group similar divisions from different companies. Please note that this will require you to import your divisions as separate entities in Fathom.

You are able to consolidate divisions where the parent companies originate from different source accounting systems.

Example: A business operates in 3 locations (single company entities), and each location is comprised of 2 divisions ('Division A - Overhead' & 'Division B - Retail'). The finance team wants to combine all of the Retail divisions into one entity or consolidated group.

❗Notice: Importing standalones to consolidate divisions is only available for companies imported from Xero, QuickBooks Online, and MYOB AccountRight Live. If importing via Excel, you can create an Excel import file for each division and import them as separate companies in Fathom.

How to consolidate divisions

Use the following workflow to consolidate divisions in Fathom.

Import the parent companies that contain the divisions you would like to consolidate.
Once the parent companies have been imported, ensure you have imported the divisions for the companies. They should be listed next to ‘Tracking’ in ‘Step 1 - Update Data’ of each company’s Settings.
Import each division to be consolidated as a standalone entity within Fathom
Create a consolidated group from the standalone entities

QuickBooks Online standalones with class and location hierarchy

If you are importing parent and child divisions as standalone entities, the standalone parent divisions will include the child amounts as well as the parent amounts.

Example: A plant nursery has a 'Flowers' parent class. The child class amounts under the parent class will roll up into the parent class for the standalone parent class entity. If the child classes are imported as standalone entities, they will reflect the child class amounts in QuickBooks.

Division	QuickBooks Online	Fathom Standalone
Flowers	100*	550**
Roses	175	175
Violets	125	125
Tulips	150	150

*The parent class has data allocated to it in QuickBooks

**The parent class imported as a standalone in Fathom includes the parent class amounts, and the child class amounts imported from QuickBooks

If you are importing divisions as standalone entities and planning on consolidating the standalones, we recommend importing only the child divisions (If amounts are not assigned to the parent divisions in QuickBooks) or only the parent divisions as standalone entities. This will prevent double-counting when consolidating the standalone entities.

What if I have unclassified data?

If you have data that is unclassified, or not assigned to a division in your source accounting system, then you will not be able to import that data as a standalone division to consolidate. To consolidate the unclassified data, there are a few options:

Option A: Assign the data to a division in your source accounting system so that it is no longer unclassified or
Option B: Create an 'Unclassified' division in your source accounting system (e.g. create an 'Unclassified' class in QuickBooks) and assign all unclassified data to that division. You will then be able to import the 'Unclassified' division as a standalone entity into Fathom and include it in the consolidated group. Or
Option C: Import the unclassified data into Fathom via Excel as an Excel-based company. You will then be able to include the Excel-based company, made up of the unclassified data, in the consolidated group.

Next steps

Now that you've consolidated your standalone divisions continue setting up the consolidated group you've created by choosing from the options below.

What you want to do:	Next step in the process:
Begin setting up your Consolidated Group's Profile	Setup your Consolidated Group Profile
Set up the consolidated Chart of Accounts	Customise the Consolidated Chart of Accounts

Additional knowledge & common questions