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