Reviewing and Adjusting Your Forecast by Forecast Method

Review and adjust the rolling forecast by reviewing line item forecasts categorized by forecast method. You can do your forecasting and make adjustments from this dashboard.

  1. From the Home page, click Daily Cash Forecast. If you are a Cash Manager, then click Daily Rolling Forecast from the vertical tabs.

  2. Click the Rolling Forecast form.
  3. Right-click a line item in the Rolling Forecast form and then click View by Forecast Method.

    If you are a Controller, right-click the form and then select Forecast by Entity. Select the entity and currency you want to plan for from the POV, right-click a line item, and then select View by Forecast Method.

    The View by Forecast Method dashboard opens, which includes Forecast Methods by Periods (in grid form and in chart form) and Forecast Method Assumptions.

  4. In Forecast Methods by Periods, review the values at the total level for each forecast method. Select members from the POV to review the line item forecast for different versions, entities, or currencies. You can also change to a different line item.

    You can make line item adjustments directly in the Forecast Methods by Periods grid in the Adjustments row. This makes it easy to make adjustments to future periods. The changes you make are reflected in the chart and in the Rolling Forecast form.

  5. You can right-click in the Forecast Methods by Periods grid and select a driver to make adjustments to your assumptions. For example, right-click and select Salary Payments, then right-click the Salary Payments form, and then select Salary Pay Terms. Make changes as needed to the driver assumptions.

    For more information, see Setting Up Cash Inflow Driver Assumptions for Driver-Based Planning and Setting Up Cash Outflow Driver Assumptions for Driver-Based Planning.

  6. You can perform what-if analysis by modifying and blending forecast methods for the selected line item directly in the Forecast Method Assumptions form in the View by Forecast Method dashboard.

    Tip:

    You can run the Daily Set Color on View Forecast rule to set the color to the forecast method that has been selected for the period range.
  7. Save the dashboard. You see the impact of your changes on the forecast right away.
  8. When you are satisfied with the forecast, return to the Rolling Forecast form.

  9. Review adjusted values.

    The adjustments are the difference between what was loaded or calculated and what you have adjusted.

    For traceability, adjustment values are saved in the Adjustments member and updated values are saved in a parent member, Forecasted Cash+ Adj.