4 Performing Daily and Periodic Cash Forecasting

Depending on how your application is set up, you can perform cash forecasting at the daily, weekly, or monthly level.

After setting up driver assumptions and saving the form, (or after completing other methods for deriving cash forecast, such as predictions or manual input), you can review the cash flow forecast results in the Rolling Forecast form, and then perform additional analysis and make adjustments.

Line items forecasts are calculated based on the default forecast method for that line item.

Before beginning cash forecasting, make sure you or your administrator has run the Daily/Periodic Process Actuals and Daily/Periodic Process Forecast rules. . If you are using multiple currencies, there are additional rules the administrator must run.

Note:

If you are working with multiple currencies, review About Using Multiple Currencies in Forms.
  1. From the Home page, click Daily Cash Forecast or Periodic Cash Forecast. If you are a Cash Manager, then click Daily Rolling Forecast or Periodic Rolling Forecast from the vertical tabs.

  2. Review the Summary dashboard.

    The Cash Manager Summary dashboard provides a snapshot of the cashflow KPIs and an interactive chart for exploring cash flows. It includes several KPIs that indicates the cash health over the cash flow period. In addition, it also covers Operating and Non-operating Cash Flows, as well as cash positions. It also shows the Cash Buffer and Cash Over Buffer line items.

    The Controller Summary dashboard displays the snapshot at the regional level in the entity hierarchy and allows for a view of the cash flows by each of the entities in the region. The KPIs for the Controller are at the regional level. You can drill in to specific entities from there.

  3. Click the Rolling Forecast form to review the actuals, actuals versus daily/periodic forecast, and the rolling forecast for operating cash inflows, operating cash outflows, cash from investing activities, and cash from financing activities, along with the opening and closing balance. You will do most of your daily work from this form.
  4. If you are a Cash Manager, to perform additional analysis and make adjustments, right-click the form and then select from the following options.

    If you are a Controller, to perform additional analysis and make adjustments, right-click a line item 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 from the following options:

    • View by Line Item Details—Review details for each line item.
    • Forecast by Bank—Use this option to allocate forecasts by bank based on defined business rules. Once the forecast is finalized, you can allocate the forecast numbers by bank. See Forecasting By Bank.
    • View Actuals—Review any actuals that have been loaded to the Actual scenario. Select members from the POV to review different versions, entities, currencies, or line items. You see the Actual range specified by your administrator in Forecast Range Setup.
    • Customer Analysis Dashboard—Review an analysis of customer receipts for your entity on a dashboard, with KPIs, DSO trend, aging analysis, and actuals versus forecast.
    • View by Forecast Method—For daily forecasting only: Review and adjust the rolling forecast by reviewing line item values categorized by forecast method. You can do your planning and make adjustments from this dashboard. For more information, see Reviewing and Adjusting Your Forecast by Forecast Method.

      Note:

      To see the difference between a forecasted value and an adjusted value, in View by Forecast Method, review the Adjustments row.
    • Supplier Analysis Dashboard—Review an analysis of supplier payments for your entity on a dashboard, with KPIs, DPO trend, payables aging analysis, and so on.
  5. You can make any further adjustments directly on the Rolling Forecast form.
  6. Save the form when you are done with the forecast.