How can I create a consolidated forecast in Fathom?
There are two main options for forecasting for a consolidated group in Fathom. You can:
Option 1 - Forecasting at the consolidated level
If you want to simply forecast at the consolidated group level, then you can create a forecast like you would for any underlying company.
You will have full functionality at the group level and are able to set value rules, timing profiles and all other settings options on the consolidated Chart of Accounts. The Chart of Accounts will display according to how it is set up in the consolidated group’s Settings ‘Step 3 - Chart of Accounts’.
To get started with forecasting, please see our ‘Getting Started with Fathom Forecasting’ article.
Option 2 - Bringing the underlying forecasts into the group forecast
You can consolidate the forecasts of the underlying companies and bring them into the consolidated group’s forecasting tool.
To bring the underlying company forecasts into the consolidated forecast,
By linking the consolidated group’s forecast to the budget, you can bring the combined Profit & Loss figures from the underlying forecasts into the consolidated group's forecast.
📝Note: The Balance Sheet amounts for the group’s forecast will not be brought in with the ‘Link to Budget’ option. Only the Profit & Loss amounts will be brought in from the underlying companies. The Balance Sheet for the group is forecast according to the timing profiles, journals, and schedules set up in the consolidated group’s forecast. This also applies to Balance Sheet derived Profit & Loss accounts, such as depreciation and interest accounts, as they are forecast according to schedules and/or journals.
Consolidated forecast does not match underlying forecasts
If you have gone through the steps for Option 2 and your consolidated forecast does not reflect the forecast values of your underlying companies, then check the following:
Reporting on the consolidated forecast
Reports for a consolidated group will have the same forecast reporting options as an underlying company has for reporting on its forecast.
It is not possible to report on the forecast figures for a specific underlying company within the consolidated group report. You are only able to report on actuals or historical financial data for a specific underlying company in a consolidated group report.
For more detailed information, please see:
Additional knowledge & common questions
▶️ Want a general overview of the forecasting tool? Watch our Forecasting Overview video (19 min).