Creating a cash forecast

  1. Access Treasury Manager > Manage Forecasts > Cash Forecast.
  2. On the Cash Forecasts tab, click Create.

    Use the following guidelines to enter field values:

    Cash Forecast

    Name of the cash forecast

    Description

    Description of the cash forecast

    Forecast Date Range

    Dates of the cash forecast

    Approval Code

    This Approval Code field will only appear if you have selected Cash Forecast Approval Required in the finance group. This approval code will determine how your forecast is routed for approval.

    Forecast Selections

    • Include All Operating Accounts: select this box to include all operating accounts.

    • Include All Categories: select this box to include all categories.

    Note: 

    If you do not select All Operating Accounts, you will be prompted to select one or more accounts. If you do not select All Categories, you will be prompted to select categories.

    Forecast Calculation

    • If you select Manual, you will have to enter all the forecast amounts manually.

    • If you select Historical, you also need to enter the following information:

      • Actual Date Range: The date range for which historical amounts will be pulled from the accounts and categories you select.

      • Calculation Option: The type of calculation that will be performed on the original amounts (Actual, Daily Average, Weekly Average, or monthly Average).

      • Calculation Adjustment (optional): The percentage by which you want to increase the original amounts.

    • If you select Calculated, you must select a calculation option (Date, Date Range, Day of Week, Day of Month) and enter a forecast amount.

      • If you select Date, you must select a calculation method (Whole or Spread).

        Whole means the forecast amount is entered by default for all the dates that you select.

        Spread means that the forecast amount will be divided equally over all the dates you select.

        You must also enter up to four forecast dates and a forecast amount.

      • If you select Date Range, you must enter a calculation method of Whole or Spread (see above), a date range for the forecast, and a forecast amount.

      • If you select Day of Week, you must also select a specific day (for example, Friday), a calculation method of Whole or Spread (see above), a date range for the forecast, and a forecast amount.

      • If you select Day of Month, you must also enter a specific day (for example, 15), a calculation method of Whole or Spread (see above), a date range for the forecast, and a forecast amount.

  3. Click Next.
  4. On the Accounts tab, click Select Account to choose from a list of defined bank accounts.

    The Cash Management Accounts form appears. Once the account is added, the Cash Forecast Account Completed message appears on the lower left-side of the form. Click Close to close the form.

  5. Click Next.
  6. On the Categories tab, click Select Category to choose from a list of defined categories and click OK.
    Note: 

    On the Cash Transactions Category form, use the Search field to assist in locating the Category. The wildcard (*) can be used in front of or behind partial search criteria.

    Continue to add additional Categories to the Cash Forecast. The Categories entered at this time are included in the building of the Cash Forecast display. As you select categories, you will be prompted to either select the default calculation method, or override it with a different one.

    Note: 

    In the Transaction Details section, the Forecast Calculation from the first wizard form is the default selection. It can be overridden here.

  7. On the Summary tab, you can access defined cash accounts and categories. Once satisfied with the selections, click Build Cash Forecast.
  8. Once the Build Forecast Completed message appears, click Exit.

    The Forecast Detail tab now shows the cash account in the right panel.

  9. Create cash forecast with currency.
    1. Repeat steps 1-3 in Creating a cash forecast.
    2. Click Select Account and select the cash account with a different currency or the cash account with a Company Location that has a different currency.

      The cash account will display the message: Required forecast currency rates not entered. This message indicates that there has not been a currency rate entered in the Currency Rates link in the wizard.

      Note: 

      The currency rate on the CurrExchangeRate will not be used in this process. This is a forecast (or budget) exchange rate, not an existing exchange rate.

    3. Click on the Currency Rates link and enter a rate, click Save.

      Once a Currency Rate is entered and saved, close the form and the red alert on the Accounts tab will be removed. Click Next.

    4. On the Categories tab, click Select Category. Select one or more categories and click Create Forecast Category. Close the select list and return to the Categories tab. Click Next.
    5. On the Summary tab, click Build Cash Forecast button. If the Currency Rate was entered, the cash forecast will be built. If the Currency Rate was not entered, then a message will display: Forecast currency rates are required for account (account number).
    6. Click Exit to end the Cash Forecast wizard.
  10. Activate the cash forecast.
    1. Select the bank account forecast.
    2. Select Activate.

      If approval is required, the forecast will be routed for approval and be in Awaiting Approval status. Once the last approver approves, the status will be Active.

      If no approval is required, the Cash Forecast Has Been Activated message appears.

      Note: 

      There can only be one active cash forecast per cash account at a time. In order to activate a new forecast, the existing active forecast must be closed.

  11. View cash forecast details.
    1. From the Forecast By Account panel, double-click the cash account.

      The Cash forecast Matrix appears.

    2. To fill in the amounts, click the field for the corresponding category and date.
    3. Type the amount.
    4. Click Save.