Skip to main content

Consolidate KPIs

Roll up custom KPIs from underlying companies to use within a consolidated group

Updated over a month ago

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.

Access a consolidated group's KPI Settings

To access a consolidated group's KPI Settings:

  1. Hover over the group on the 'My Companies' page.
    ​
    ​

  2. Click the Cog/Gear icon that appears to the far right.
    ​
    ​

  3. In the grey banner at the top of the Settings, click KPIs.

Set up KPIs for a consolidation

To set up KPIs for a consolidated group:

  1. Look through the Default KPIs
    ​
    ​

  2. Consolidate Custom KPIs, if desired
    ​
    ​

  3. Decide which KPIs are active in the group
    ​
    ​

  4. Organise the group's KPIs

KPIs in a Consolidated Group

Default KPIs

When you create a consolidated group, Fathom will provide you with several Default Financial KPIs in the KPIs section of the consolidated group settings. We suggest looking through these before you decide if any custom KPIs need to be created for the group.

To see all of the KPIs available in the consolidated group:

  1. Go to KPIs in the group's Settings
    ​
    ​

  2. Click Show all KPIs at the top of the KPI list

If you want to know about the formulas used for Default KPIs, you can see our KPI Glossary.

Create consolidated custom KPIs

Whilst Default Financial KPIs are useful, you'll likely want to create and use some of your own custom KPIs in your consolidated group.

You are not able to create custom KPIs from a consolidated group. Custom KPIs must first be created in one of the underlying companies and then added to the KPI Library. They will then flow automatically into the consolidated group.

❗Notice: Only Admin-level users can add KPIs to the KPI Library.

To add a custom KPI to the KPI Library:

  1. Go to ‘KPIs’ in one of the underlying companies in the consolidated group. If the group has not yet been created, then go to one of the underlying companies that will be in the group.
    ​
    ​

  2. Has the custom KPI already been created in the underlying company?

    1. If not:

      1. Click Add a KPI

      2. Select + New custom KPI

      3. Choose to create a Non-financial, Account Watch, or Formula KPI

      4. While creating the KPI, check the box to ‘Add this KPI to your library’

      5. Finish creating the custom KPI

    2. If it has:

      1. Click the Three dots icon to the far right of the KPI

      2. Select Edit

      3. Check the box to ‘Add this KPI to your library’

      4. Update the KPI
        ​
        ​

  3. Sync the consolidated group or create the consolidated group

You’ll need to add the custom KPI to the KPI Library in at least one of the underlying companies of the consolidated group. Once the group is created or synced, the KPI will automatically flow through the underlying companies and into the consolidated group.

Where to find your custom KPIs in a consolidated group

Once your custom KPIs have been added to the KPI library in an underlying company, they will automatically flow through into the consolidated group and appear in 'KPIs' after updating the group.

You can find your custom KPIs at the bottom of your KPI list, under the heading 'Custom KPIs'.

I still can't find my KPIs in the consolidated group

It may be that you've followed all of the above steps and are still not seeing your custom KPIs in the KPI list for the consolidated group.

Ensure the KPI is active in at least one underlying company in the consolidated group.

A KPI will not appear in a consolidated group if it references divisions, also known as:

  • Tracking categories (Xero)

  • Classes/locations (QuickBooks)

  • Jobs/categories (MYOB)

Fathom is unable to drill down into divisional results from a consolidated group. As a result, any KPIs that reference divisional results will not be available in a consolidated group, regardless of whether they have been added to the KPI library.

Decide which KPIs are active in a consolidated group

Active KPIs appear in the KPI Summary, KPI Explorer, and Trend tools in the Analysis tools and Pro Reports.

Inactive KPIs can still be:

  • Used as variables in custom Formula KPIs

Fathom makes certain KPIs active for every business by default. We encourage you to tailor your active KPIs to your business.

You can have up to 60 active KPIs for a company or group, but we recommend starting with about 10 active KPIs to focus on the metrics that matter most to your business. More active KPIs will make those Analysis tools more overwhelming.

To make a KPI active or inactive:

  1. Go to KPIs in the group's Settings
    ​
    ​

  2. Click Show all KPIs at the top of the KPI list
    ​
    ​

  3. Check the box next to a KPI to make it active.
    ​
    ​

  4. Click Save Changes

Organise your consolidated KPIs

Set importance levels

Importance levels appear in the KPI Summary and KPI Explorer tools, and their corresponding reporting charts.

As you review which KPIs are or are not meeting targets, you can remind yourself of which KPIs are most critical to the business’s performance. They provide helpful context as you’re analysing and discussing results.

You can set importance levels for active KPIs:

  1. Go to KPIs in the group's Settings.
    ​
    ​

  2. Click on the stars in the 'Importance' column to set an importance level for the KPI.
    ​
    ​

  3. Save changes

Organise categories

KPI categories help you organise your KPIs and, like importance levels, provide additional context as you review results in the KPI Summary and KPI Explorer tools.

In consolidated groups, all custom KPIs consolidated from underlying companies will automatically appear in a 'Custom KPIs' category by default.

To move KPIs to another category in a consolidated group:

  1. Go to KPIs in the group's Settings
    ​
    ​

  2. Hover over a KPI name
    ​
    ​

  3. Click the Dotted Grid icon that appears to the left of the KPI name
    ​
    ​

  4. Drag and drop the KPI into another category
    ​
    ​

  5. Save changes

To rename a KPI category in a consolidated group:

  1. Go to KPIs in the group's Settings
    ​
    ​

  2. Hover over the category name
    ​
    ​

  3. Click Edit
    ​
    ​

  4. Type in a new name
    ​
    ​

  5. Click Update

Next steps

Congratulations on setting up and organising your KPIs! Any decisions you made in 'KPIs' can be changed anytime, if needed. Finish setting up your company 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:

Happy with your chosen KPIs and ready to set targets for your consolidated group?

Set Targets in a Consolidated Group

Good with your targets and ready to set up alerts?

Set Alerts in a Consolidated Group

Learn more

Did this answer your question?