Performing Ongoing Administration Tasks

Perform these administrative tasks as needed on an ongoing basis.

  1. Load the bank balance on an ongoing basis to the OCF_Bank Balance member for the Actual scenario. For example, if you want to forecast starting from tomorrow, load the closing bank balance as of today as the bank balance.

    Predictive Cash Forecasting provides two methods for loading OCF_Bank Balance:

    • Forms
    • .csv templates

    You can use one of the following forms to load OCF_Bank Balance:

    • OCF_Periodic Bank Balance
    • OCF_Daily Bank Balance

    The rules associated with these forms convert the date entered in the form to the corresponding period in the Predictive Cash Forecasting application.

    Alternatively, you can use the provided templates to simplify loading the data:

    • DailyBankBalance.csv
    • WeeklyBankBalance.csv
    • MonthlyBankBalance.csv

    When you run OCF_Daily Process Forecast or OCF_Periodic Process Forecast, the rule converts the date entered in these templates to the corresponding period in the Predictive Cash Forecasting application.

    See Using the Sample Data Import Templates.

  2. Any time you change the current year in Forecast Range Setup, you must refresh the reporting hierarchy to fully populate the Period dimension hierarchies. From the Home page, click Application and then click Configure. From the Actions menu, select Refresh Reporting Hierarchy.
  3. As Cash Managers and Controllers make adjustments to forecast numbers, run the rules and data maps on a regular basis. If you are working with multiple currencies, make sure to run the currency-related conversion and rollup rules and data maps. (See Setting Up Currencies.)