|
Report on a forecast
Once you’ve created your forecast in Fathom, you’re then able to integrate it (and any scenarios) into your custom reports and management packs to incorporate future-looking data with the actuals flowing through from your source system.
The additional forecast reporting components include:
Tables & Financial Statements
The tables & financials section of the report editor allows you to:
Financial Trends Tables
The Financial Trends tables in Fathom have been outfitted with additional capabilities for reporting on your main forecast and scenarios. You can customise a Financial Trends table to show a financial statement for:
Rolling 12-months
Calendar year
Financial year
Custom continuous period
You can customise the table to show actuals, forecast (main or scenarios), or budget data. You can also display a combination of actuals and forecast or actuals and budget data in a Financial Trends table.
To add forecast or budget values to a financial trends table from within a Fathom report:
|
💡Smart Tip: We suggest changing the page orientation to 'landscape' when adding a financial trends table to your report for the best spacing. To change from portrait to landscape mode, hover over the section title, and the option will appear on the right.
💡Smart Tip: If you check the ‘Allow report viewers to export to Excel’ option in the table’s ‘Properties’ menu, then anyone viewing the report will be able to download the table to Excel.
KPI Trends Tables
The KPI Trends tables enable you to add a table showing up to 12 months of actuals, forecast (main or scenarios), budget, or target data to a report. You can also display a combination of actuals, forecast, budget, or target in a KPI Trends table.
You can customise the periods of a KPI Trends table to show:
Rolling 12-months
Calendar year
Financial year
Custom continuous period
To add forecast values to a KPI trends table from within a Fathom report:
|
💡Smart Tip: We suggest changing the page orientation to 'landscape' when adding a financial trends table to your report for the best spacing. To change from portrait to landscape mode, hover over the section title and the option will appear on the right.
💡Smart Tip: If you check the ‘Allow report viewers to export to Excel’ option in the table’s ‘Properties’ menu, then anyone viewing the report will be able to download the table to Excel.
📝 Note: Non-financial KPIs will not display projected results or results beyond the actuals.
Forecasting tables
Fathom has several tables specifically for reporting on your forecast, microforecasts, and assumptions you’ve made when building your forecast.
To access these tables,
|
Balance Sheet Layer Detail Table
For any classification, heading, or account on the Balance Sheet, display the:
Opening balance
All inflows and outflows from the P&L, journals, schedules, and/or microforecasts
Closing balance
This table shows exactly how the forecast balance for any account was calculated.
This Year or Next Year table
Display this year’s or next year’s forecast for any:
Classification
Heading
Account from the P&L or Balance Sheet
The table will show baseline values (from value rules and timing profiles) and values from any microforecasts.
Microforecasts Table
Select a microforecast and view all of the financial impacts of that microforecast for a selected date range.
Assumptions Table
Displays any P&L, Balance Sheet, microforecast, and driver notes that have been selected to be included in the Assumptions report. A tax summary can also be displayed.
Learn more about documenting and reporting on forecast assumptions from our 'Document your forecast assumptions' article.
Forecast Drivers Table
Displays the values for all drivers or a specific category of drivers for the main forecast or any scenario to report on any non-financial metrics or data outside of the Chart of Accounts that underpin the forecast values.
Forecast Charts
The report editor allows you to add charts to your reports that:
Scenario Comparison Charts
The scenario comparison charts allow you to easily compare one metric across as many as 6 scenarios.
To add a scenario comparison chart to your report:
|
Trend Projection Charts
In addition to the scenario comparison trend charts, Trend Charts have capabilities for forecast reporting.
Once you have added a trend chart from the ‘Charts’ section of the content library, you can edit the chart to display a projection of your forecast or one of your scenarios.
To add a forecast projection to a trend chart:
|
Business Roadmap Chart
From the 'Forecasting' charts section, you can also select to include your Business Roadmap in your reports. You can select the roadmap for your main forecast or for your scenario views.
To add a Business Roadmap chart to your report:
|
📝 Note: To change the primary metric displayed on the Business Roadmap, you’ll need to edit your Quick Metrics bar in the ‘Forecast’ section of Fathom.
📝 Note: To change the colours of the microforecast bars in the Business Roadmap chart, you’ll need to edit the microforecast categories in the ‘Forecast’ section of Fathom.
Predefined Report Templates
If you prefer to build from or use a Predefined Template for your reporting needs, there are the 'Forecast Analysis' and 'Advanced Forecast Analysis' templates.
To access this template:
|
The Forecast Analysis report includes the following reporting elements:
|
The Advanced Forecast Analysis report includes all of the reporting elements in the Forecast Analysis report and:
|
Next steps
Congratulations on completing the 'Forecast Creation & Setup Workflow'! If you want to change any of the decisions you made while setting up your forecast or customising your report, simply return to the appropriate area in the Forecasting tool or Report Centre.
What you want to do: | Where to go: |
Share your reports with others or enable them to comment on reports | |
Invite others into your Fathom account to share insights | |
Audit the forecast you've created to ensure everything is set up and calculating as desired | |
Analyse the company's performance with the Analysis tools | |
Ready to consolidate your companies in Fathom or Benchmark them? | |
Need to add another company to your Fathom account? |
Learn more