Consolidation Rules for Forecast 5

Consolidation Rules for Forecast 5

In order to successfully create a consolidation in Forecast 5, there are some rules and tips to be followed:


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 what if.

If the forecasts contain different records in their record lists, the lists are merged into a consolidated record list. Record names and types that are the same will be combined. Variations of the same name, e.g. "Sales" and "Sale" will not consolidate.


During consolidation, for each record of each forecast, the record type, name and position in the list of records are compared with records already in the Consolidation to determine if it should be added to an existing record or treated as new.


Naming Conventions - Do not use numerals at the end of records as Forecast 5 looks to rename records when consolidating, of the same name but different record type by appending a 1, 2 or 3 etc, if there is already a 1 then this can cause problems.

Record names should not have the following symbols as SQL does not like them:  ‘ & 



Use a template for each forecast (copy no values)


The Main Bank Account Interest, Business Taxes and Dividends can be recalculated for the consolidated forecast.  


You can consolidate actuals and compare them against budget. You canalso compare projections against an original budget.

If figures in the consolidation do not look correct, check that each forecast is in balance. If they are not, run the Budget and System Recalcs (Found under utilities), then reopen the consolidation.

    • Related Articles

    • 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 ...
    • Using Forecast Status

      We have recently introduced a forecast status for Admin Pack users. This allows the owner of a forecast to define the status of a forecast;  Editable = Anything can be changed in the forecast.  Budget Entry = Only numbers can be entered (settings and ...
    • Forecast 5 User Guide

      Contents Activating Your Forecast 5 License ........................................................................................................3 Having Trouble Activating Your Forecast 5 License? ...
    • Activating Forecast 5

      Activating Your Forecast 5 License Once your copy of Forecast 5 has been installed, you will then need to activate your license. 1)Open Forecast 5. You should be prompted to license Forecast 5 upon opening. 2)If not, go to Help > Licensing. 3)Upon ...