Export Consolidation as a forecast

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 normal budget/forecast.

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 values.

Just as some examples

  1. Extend more years with the group totals only
  2. Enter actuals for the group, not individual forecast then reconsolidate
  3. What if the group.
  4. Run any reports.
  5. Access data through views into Excel, Graph and Power BI


  1. After importing you need to force a system record calculation by going to the Utilities tab and clicking System Record Recalc.
  2. “As % of records” are imported as values only as the relationships can not be determined enough to be certain.

    • Related Articles

    • 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 ...
    • 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
    • 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 ...
    • 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 ...