Loading the Historical Opening Bank Balance

Load your historical bank balance bank to the OCF_Historical Opening Bank Balance member, for the Actual scenario.

Predictive Cash Forecasting provides two methods for loading the historical bank balance:

• Forms
• .csv templates

You can use one of the following forms to load OCF_Historical Opening Bank Balance:

• OCF_Periodic Historical Opening Bank Balance
• OCF_Daily Historical Opening 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:

• DailyHistoricalOpeningBankBalance.csv
• WeeklyHistoricalOpeningBankBalance.csv
• MonthlyHistoricalOpeningBankBalance.csv

When you run Daily Historical Opening Bank Balance or Periodic Historical Opening Bank Balance, 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.

When you run the Process Actuals rule, it looks for data in OCF_Historical Opening Bank Balance. If it finds data, the Opening Balance is set to this value. If it does not find data in OCF_Historical Opening Bank Balance, Predictive Cash Forecasting calculates the Opening Balance using the previous period's Closing Balance.