Page Comparison

A forecast is always based on a budget workbook that has been published to a stream, which could be a budget or a previous forecast stream. You convert a budget workbook save a budget as a forecast. In other words, you convert the budget into a forecast workbook. If the budget workbook includes a Balance Sheet, Cash Flow budget or any driver tabs, they are also converted into a forecast.

1. Ensure In the budget workbook, ensure the Main budget tab is published to a stream. If your budget includes and any driver tabs or a and Balance Sheet tab , ensure they you want for the forecast are published alsoto a stream.       From within the budget workbook, click the Menu button, then click

2. Click Menu > Save as forecast. If you don’t see this option, it means you don’t have permission to manage Budgets and Forecasts.

3. In the Create Forecast Workbook window, enter a name for the forecast. For example, Forecast 3+9. 

4. (Optional) Select a different budget stream on which to base the forecast. 

   • A default stream, which is your last published stream, is selected for you. If no stream is selected, it means the budget workbook has not been published to a stream.

   • You might want to select a different stream from the default stream. For example, you might have another budget with exactly the same structure, such as a stretch or worst-case scenario budget, and that is what you have been using recently, so you prefer to base your forecast on that budget.

5. (Optional) Change the default actual stream and actual measure.

6. Select the Actual + Forecast periods you want in your workbook.

   • This is the period that you want to forecast. For example, suppose your budget runs from July 2022 through to June 2023 and you have just completed the month of October (the fourth month in the budget). You want to bring in your actual data from July to October (four months) and forecast from November onwards. Therefore, you select the 4+8 option.

   • You can amend this period selection later, as time progresses.

7. (If applicable) Select the items you want to bring across from the budget workbook into the forecast period. . This step displays if your budget workbook has any other tabs.

   • By default, all the budget worksheet tabs are selected, and therefore, included in the forecast workbook. If you do not want any of them, click the Filter button and clear the checkboxes of those you do not want.

   • All cell comments are included by default, so if you do not want them, clear the Cell comments checkbox.

     

8. Click Create Forecast Save and finish or Next, as applicable.                     

9. (If applicable) Select the Budget Stream, Actual Stream and Actual Measure for the Balance Sheet and each driver. This step displays if your budget workbook has any database driver tabs or a Balance Sheet budgetother tabs, in which case, you need to provide additional information to bring in data for the corresponding stream(s).

   

10. (If applicable) Click Create Forecast Save and finish.

11. Proceed to explore your forecast workbook.