Consolidated Group Reporting

Reporting for consolidations, including financial statements split by underlying company

Calen Olesen avatar
Written by Calen Olesen
Updated this week

Contents

👋 Haven't started a trial with Fathom yet? Learn more about Fathom's financial consolidation software & turn your consolidation into a powerful report with our financial reporting software.


Consolidated reporting

All the reports and reporting components you are familiar with in a single company are also available for a consolidated group.

There are also reporting options specific to consolidated groups:

    • Split out by underlying company

    • Filtered to an individual underlying company

    • Compare KPI results across companies

    • Compare KPI results across companies and to budget, target, or prior periods

    • Show KPI results for an underlying company

    • Breakdown chart

    • Company-by-company consolidated financial results

    • Company-by-company consolidated budget results

💡 Pro Tip: To change the terms used in the financial statements (e.g., 'Statement of Activities' instead of 'Profit & Loss', you'll want to change the terminology for the consolidated group.


Financials in a consolidated report

Financials and budgets by company

A Financials by Company table shows the financial or budget results for each underlying company in side-by-side columns. To add this financial statement to a custom consolidated report:

  1. On the left sidebar of the Report Editor, select ‘Tables & Financials

  2. In the menu that options, click the second bolded option at the top to reveal a dropdown menu.

  3. Select ‘Financials by Company’ from the drop-down menu

  4. Select to add a Profit & Loss or Balance Sheet to your report

Once you’ve added the table to your report, you can edit the table to customize it to your reporting needs.

To edit the table,

  1. Double-click the table or hover over it and click the green ‘Pencil’ icon that appears.

  2. In the menu on the right, some of the editing options you have include:

    • Selecting the drop-down menu, to change the table to a ‘Profit & Loss’, ‘Balance Sheet’, ‘Cash Flow Statement’ or a financial ‘Snippet’

    • Filtering the table to display the actuals or budget

    • Adding or removing columns or companies from display on the table

    • Showing results before or after eliminations

    • In the ‘Rows’ section, changing the level of detail or number of accounts shown in the financial statement

💡 Pro Tip: If eliminations and adjustments have been made in a consolidated group, these will be combined in an 'Other' column instead of an 'Eliminations' column.


Displaying underlying company financials

To display the results of individual, underlying companies in a consolidated report, you’ll need to edit a financial statement table:

  1. Select the ‘Tables & Financials’ option from the left side toolbar

  2. In the left-hand menu, click the second bolded option at the top to reveal a dropdown menu.

  3. Select ‘Financials’ from the dropdown menu

  4. Choose to add a statement to your report

  5. Once you’ve added the statement to your report, hover over it and select the green ‘Pencil’ icon that appears. This will open up the table’s ‘Properties’ menu.

  6. Under the ‘Company Filter’ section of the table, you can change the filter from ‘All companies’ to one of the underlying companies to display the financials for that individual company in the table.

  7. Other options for editing the table include:

    • Selecting the second filter option to change the table to a ‘Profit & Loss’, ‘Balance Sheet’, ‘Cash Flow Statement’ or a financial ‘Snippet’

    • Adding budget and variance columns (amongst others) to the table by selecting the ‘Add or remove’ columns option

    • In the ‘Rows’ section, change the level of detail or layout of the financial statement.

  8. Select ‘Apply changes


KPI Tables in a consolidated report

In addition to the typical KPI Tables, there are a few options for displaying KPI results in a consolidated group report.

Table Option

What it displays

  • Underlying companies' results for several KPIs (or their budgets or targets) in side-by-side columns

  • Can display consolidated group's results in total column

  • Underlying companies' results for one KPI

  • Can compare the results to the target, budget, or prior periods

  • Can display the consolidated group's result in a total row

  • Can display results for several KPIs for the total consolidated group or one underlying company

  • Can compare to target, budget, or prior periods


KPIs by Company Table

A KPIs by Company table shows the KPI, budget, or target results for each underlying company in side-by-side columns. To add this table to a custom consolidated report:

  1. On the left sidebar, select ‘Tables & Financials

  2. In the left-hand menu, click the second bolded option at the top to reveal a dropdown menu.

  3. Select ‘KPIs by Company’ from the drop-down menu

  4. Select to add a KPIs by Company table to your report

Once you’ve added the table to your report, you can edit the table to customise it to your reporting needs.

To edit the table,

  1. Double-click the table or hover over it and click the green ‘Pencil’ icon that appears.

  2. In the menu on the right, some of the editing options you have include:

    • Changing the title of the table

    • In the Columns section

      • Choose to display the KPI, budget, or target results

      • Add or remove companies from the table

    • In the Rows section

      • Add or remove metrics from the table (KPIs, account lines, financial subtotals)

      • Hide rows with nil values

    • Showing results before or after eliminations

    • Currency formatting options

📝 Note: The target results for the underlying companies are entered in the settings for each company.

The group's target results for the group's total columns are summed from the underlying companies' targets.


KPI Comparatives Table

A KPI Comparatives table shows the results for one metric split by the underlying companies. The results can be compared to prior period, budget, or target results, among other options.

To add this table to a custom consolidated report:

  1. On the left sidebar, select ‘Tables & Financials

  2. In the left-hand menu, click the second bolded option at the top to reveal a dropdown menu.

  3. Select ‘KPIs by Company’ from the drop-down menu

  4. Select to add a KPI Comparatives table to your report

Once you’ve added the table to your report, you can edit the table to customise it to your reporting needs.

To edit the table,

  1. Double-click the table or hover over it and click the green ‘Pencil’ icon that appears.

  2. In the menu on the right, some of the editing options you have include:

    • Change the metric displayed in the table

    • In the Columns section, choose to add or remove columns, such as:

      • Prior period

      • Budget

      • Target

      • Variance (difference between the results and the budget, target, or prior period)

    • In the Rows section

      • Add or remove companies from the table

      • Add or remove a total row to display the consolidated results

    • Currency formatting options

📝 Note: The target results for the underlying companies are entered in the settings for each company.

The group's target results for the KPI Comparatives total row are summed from the underlying companies' targets.


KPI Table filtered to the underlying company

A KPI Table can be added to a consolidated group report to display the KPI results for the consolidated group or an underlying company. Those results can be compared to target, budget, or period periods.

To add this table to a report:

  1. On the left sidebar, select ‘Tables & Financials

  2. In the left-hand menu, click the second bolded option at the top to reveal a dropdown menu.

  3. Select ‘KPIs’ from the drop-down menu

  4. Select to add a KPI table to your report

  5. Double-click the table or hover over it and click the green ‘Pencil’ icon that appears.

  6. In the table's Properties menu, you can use the Company Filter to display the results for the group or one of the underlying companies

📝 Note: The target results for the underlying companies are entered in the settings for each company.

The group's target results for a KPI Table are based on the target results entered in the group's Settings.


Charts in a consolidated report

Breakdown analysis chart

Because there is an additional breakdown analysis tool available in consolidated groups, you have an additional chart option in consolidated group reports.

To add a breakdown chart to your consolidated report:

  1. Select the ‘Charts’ option from the left sidebar

  2. In the left-hand menu, click the bolded option at the top to reveal a dropdown menu.

  3. Select ‘Revenue’, ‘Costs & Expenses’, ‘Profitability’, or ‘Efficiency’

  4. Scroll down to the bottom of the menu and choose a breakdown chart type.

  5. After adding the breakdown chart to your report, hover over the chart and select the green ‘Pencil’ icon to open the chart’s ‘Properties’ menu.

  6. This will allow you to edit or customise the chart as desired. Some editing option options for the breakdown chart include:

    • Filtering by company or account

    • Changing the metric or account classification being broken down in the chart

    • Compare with budget or prior period

    • Sorting the chart by result or alphabetically

    • Displaying all companies on the chart, or only the top or bottom companies

  7. Select 'Apply changes'

📝 Note: To display the budget or prior period comparison, the breakdown chart must be more than half the width of the reporting page.


Consolidated Excel Reports

Side-by-side consolidated financial results

The Excel consolidated financial results are additional valuable reports for consolidated groups.

This report provides a side-by-side view of your companies and the consolidated financials. It also includes the eliminations in your consolidated group and presents the exchange rates used (if applicable).

To access this report,

  1. Go to 'Reports' for your consolidated group

  2. Select 'Excel Reports' from the left sidebar

  3. Hover over the 'Consolidated Financial Results, including eliminations' or 'Multi-currency Consolidated Financial Results, including eliminations' report.

  4. Select the 'Cloud' icon to the right of the report name.

Inter-company eliminations and exchange rate adjustments (if applicable) are also displayed in the report.

The comments provide a helpful way to view the amounts before or after translation.


Side-by-side consolidated budget results

The same report can be downloaded to show the side-by-side view of the budgets coming from each underlying entity. The report is useful for auditing the consolidated budget figures and viewing the impact of any eliminations or translated amounts to the underlying budgets.


Next steps

Now that you’ve learned about the additional reporting options available for a consolidation, you may want to invite others to view reports for the group in Fathom or forecast for the group.

What you want to do:

Where to go next:

Invite others into your Fathom account to share insights

Analyse the group's performance with the Analysis tools

Begin forecasting in Fathom

Need to add another company to your Fathom account?


Additional knowledge & common questions

Did this answer your question?