A consolidated forecast brings together the information from individual forecasts you've created, so before you begin, ensure you've set up all of the individual forecasts you need.
Next, you need to add the entities you want to use in the consolidation.
Once you've added the individual entities, you can proceed to the Customise Data and Customise Layout tabs to view the data for the consolidation and set up the pages for your report.
If your consolidation uses more than one currency, you can view and change the exchange rate used to convert to the currency of the group report. There are two ways to do this:
When working in the Manage Group window, in the Base Currency column click the abbreviation for any currency. This opens the Foreign Exchange options. You can return to the Manage Group option at any time by clicking the Manage Group button.
From the main Spotlight Forecasting screen, click the Settings link under the name of the consolidation, then click the Foreign Exchange tab.
By default, the consolidation uses exchange rates from XE.com, however you can amend these if needed. Further information about this is available in our Exchange Rate Settings article.
When you access the Customise Data tab for your consolidated forecast, similarly to an individual forecast the data appears over three tabs - Profit and Loss, Balance Sheet and Cashflow Forecast.
In the Profit and Loss and Balance Sheet tabs, you can drill into each section to view the accounts. If an account has values for more than one entity, you can also click the plus sign to the left of the account name to drill into the values for the individual entities.
Note: The Cashflow Forecast tab does not display entity-level data.
As the values come from the individual forecasts, the cells in the data grid are locked - if you need to make any changes, return to the individual forecast and make the change there, then use the Sync option in the Manage Group tab to sync the updated data to your consolidation.
If required, you can click the Show details link to view the read-only report code and view or edit the group Spotlight Display Name for the accounts.
When you add the individual entities to the consolidation, the data from each of the forecasts is copied into the consolidated forecast. If further changes are made to the individual forecasts, these do not automatically copy across. To update your consolidated forecast with the changes made, in the Manage Group tab click the Sync button alongside the relevant entity.