Adding a forecast transaction

Use these different procedures to add a forecast transaction.
  1. Add directly in the Cash Forecast By Account form.
    1. From the Forecast By Account panel, double-click the cash account. The Cash Forecast Matrix is displayed.
    2. Click Add Forecast Transaction.
    3. Specify this information:
      Category

      Select from the list of defined categories.

      Transaction Details
      • 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 all 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.
    4. Click OK.
  2. Add from Finance Portal. Use this procedure to notify the treasury department of a pending purchase or income.
    Note: The finance portal is used by people outside of the Treasury department that needs to report items to be included into the forecast. These people do not have any access to the application.
    1. Access the Finance Portal.
    2. Specify this information:
      Description
      Describe the reason for the notification to Treasury.
      Category
      Type a category.
      Calculation Option
      Select Date, Date Range, Day of Week, or Day of Month. This indicates the estimated date this income or expense will occur.
      Forecast Amount
      Type the estimated income or expense amount.
    3. Save the form.
  3. Follow-up task: Processing Finance Portal transactions
    1. Access Treasury Manager > Manage Forecasts > Cash Forecast > Other Transactions tab.
    2. Select the transaction and click on the Add to Forecast button.
    3. Enter a Category, Cash Forecast and Account.
      The transaction will be removed from the Other Forecast Transactions tab and will be viewable on the Forecast Detail, matrix view.