5 Analyzing Cash Forecasts

Use the provided dashboards to analyze your cash forecasts.

In addition to the Summary dashboard, Predictive Cash Forecasting provides several dashboards to help in your cash analysis. You can analyze both daily and periodic data in one place using the provided dashboards.

Before you can see updated data in the dashboards, make sure you or your administrator has run the relevant currency conversion and rollup rules and the data maps to push data to the reporting cube.

  1. From the Home page, click Analysis.
  2. Select one of the dashboards for further analysis.

    You can select different entities in the POV to look at different data, and you can review the dashboards in any currency.

    For cash managers, view data for the forecast range in these dashboards:

    • Daily Overview—Different ways to look at the daily data, including Cash KPIs, net cash flow, total inflows and outflows by line item, and a cash walkthrough from opening balance to closing balance over the forecast range.
    • Periodic Overview—Same as the Daily Overview, but at the periodic level.
    • Daily Variance—Variance analysis at the daily level, comparing the historical actual versus forecast, using data from the entire actual period range, compared to the forecast. It includes a variance walkthrouth from opening balance to closing balance over the forecast range. In the Comparison by Period chart, you can select different line items from the list. All line items related to receipts are combined into Total Customer Receipts (forecast receipts and actual receipts), and all payments are combined into Total Supplier Payments (forecast payments and actual payments) so you can compare actual and forecast. The line item analysis shows the variance between forecast and actual at the rollup level.
    • Periodic Variance—Sames as the Daily Variance analysis, but at the periodic level.
    • Daily vs Periodic—Compare cash inflows and cash outflows from your daily and periodic forecasts.

    For controllers, view data for the forecast range in these dashboards:

    • Daily Analysis by Entity—Get a high-level analysis of your daily cash inflows and outflows for all entities, and a cash walkthrough from opening balance to closing balance over the forecast range. You can select different line items to review in the cash walkthrough. Review the cash position for different entities, and in the Forecast report, for each line item, from opening balance to closing balance, review the entity level data rolled up to parent entity.
    • Periodic Analysis by Entity—Same as the Daily Analysis, but at the periodic level.

The values shown in the charts and KPIs are for the forecast range defined Forecast Range Setup.