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

Notes:

  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

    • 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

    • Forecast 5 Essentials Guide - the basics of Forecast 5

      This guide will walk you through the steps of setting up and using Forecast 5. Introduction to Forecast 5 Forecast 5 is a purpose-built forecast and budgeting tool that uses a pre-built metric template and contains an integrated report set (P&L, ...

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

    • My Balance Sheet is out of balance / my reports are wrong

      Issue: My balance sheet is out of balance or my reports are not showing the correct figures. This can also be for consolidations. Cause: Sometimes this can occur with the calculations have not been properly refreshed. Solution: 1. Under Utilities, ...

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