Export Consolidation as a forecast
The purpose of this function is to take the consolidation and
save it as a forecast. Then you can import this forecast and treat it like a
The idea being if you have number
of subsidiaries in your consolidation, you may find it time consuming to update
all of them to get a new group position.
With the saved forecast from
consolidation, you can do all the things you would at the base forecast level but on the group
Just as some examples
more years with the group totals only
actuals for the group, not individual forecast then reconsolidate
if the group.
data through views into Excel, Graph and Power BI
- After importing you need to force a system record calculation by going to the Utilities tab and clicking System Record Recalc.
- “As % of records” are imported as values only as the relationships can not be determined enough to be certain.
Consolidation Rules for Forecast 5
In order to successfully create a consolidation in Forecast 5, there are some rules and tips to be followed: Rules The forecasts must all have the same start date and number of years. The forecasts must be in the same state e.g. budget, actuals or ...
Consolidation: Why are there two records with the same name?
Question: Why are there two records with the same name in my consolidation? Answer: If you have two records of the same name in two different forecasts but they are different record types, they will not be able to be consolidated and Forecast 5 will ...
Forecast Data Export Guide
The Data Export allows you to export multiple existing forecasts from Forecast 5 into a formatted spreadsheet to be imported into an external product, e.g., Spotlight, Fathom. Please see the attachment tab for the guide
Consolidations: An error has occurred while creating/opening the forecast.
Issue: When trying to complete a consolidation, you are receiving the following error: "An error has occured while creating/opening the forecast. If this is a consolidation, please check that all records are named correctly to avoid duplicate record ...
Import and Export Forecasts
You may use this function to save your forecast as an external file or to send the forecast to support or a client. Export Forecast 1. Highlight the Forecast you wish to export. Click Export Forecast. 2. Select where to save forecast. Import ...