MANAGE CASH FORECAST TEMPLATES

Use the Manage Cash Forecast Templates screen to define a template to use on the Create Preliminary Cash Forecasts screen.

The setup process is similar to the setup on the Manage Financial Statements screen. You use a group heading to define each section of the cash forecast. Below the heading, the details display which accounts are assigned to the Line Titles detail lines.

You must first set up the cash forecast template before you link cash forecast accounts to the template and create the cash forecast.

Deltek recommends that you develop a comprehensive plan that describes which accounts to include and link to the lines on the cash forecast that you set the cash forecast template.

For more information, see the Cash Forecasting Overview.

Cash forecasting in general, as well as the decisions involved with linking balance sheet or income statement accounts to the different lines on the cash forecast, require some advanced accounting knowledge. Deltek recommends that this functionality not be accessed by anyone who is not familiar with these accounting procedures.

Location

Identification

Template Code

Enter a code to identify a cash forecast template. This is a required field.

Template Description

Enter a description for the cash forecast template. This is a required field.

Table Window

Major Subtotal Titles

Enter a major subtotal break description. For example, you can describe the accounting operations terms that your company uses for its subsystems (Accounts Payable, Accounts Receivable, General Ledger), such as Total Forecasted Payments or Total Forecasted Cash Receipts. This is a required field.

Group Headings

Enter a description for breaks at the group level. For example, you can describe the accounting operations terms that your company uses for its subsystems, such as Total AP Expense or Total Payroll Expense. This is a required field.

Line Titles

Enter a description for breaks at the line level. For example, you can describe the accounting operations terms your company uses for its subsystems, such as Weekly EFT Upload or Check Run. This is a required field.

PO Commitments

Select this check box to include outstanding PO commitments in the cash forecast. When you select this check box, all outstanding purchase order information is calculated and included in the cash forecast.

If you are not licensed for the Costpoint Materials domain, this check box is not visible in this column, and this functionality is disabled.

Accounts cannot be linked to the PO Commitment Line due to the cost distribution features on the PO line.

Subtask

Subtask

Description

Link to Accounts

Click the Link to Accounts link to open the Link to Accounts subtask.

Use this subtask to assign one or more accounts to each line of the cash forecast template.

Before you click this subtask link, select (highlight) a cash forecast line to which you want to link accounts.