Set up cash flow forecast line items

A cash flow forecast projects your cash flow based on rules and variables you specify. You can set up line items for the cash flow forecast.

Before you do this, you must define the cash flow forecast and set cash flow forecast rules. See **.

To set up a cash flow forecast line item

Open the Cash Flow Projections (CFP1) page.

a. Select Financial Management > Master Data > Cash Flow Projections.

Or

b. Search for CFP1 or Cash Flow Projections in the Navigation box and then select Cash Flow Projections.

The Cash Flow Projections (CFP1) page appears.

2. Click the Calculations/SetUp tab.

3. To add a line item:

a. On the grid toolbar, click New.

b. In the Line Item Description box, enter the line item description.

c. In the Cash Type list, select the cash type.

d. In the Forecast Using area, select to base the calculation on a Recurring Amount you select, or Annualize GL Amounts.

4. If you’re using a recurring amount, specify the details:

a. In the Recurring Amount box, enter the amount.

Or, click the icon at the end of the Recurring Amount box to display the calculator. Enter the required value.

b. In the Frequency list, select a frequency for adding the amount.

c. In the Begin After Start Date box, enter the number of days after the start of the forecast to begin adding the amount.

d. To incrementally change the amount:

• In the Change Project Amount box, enter a percentage value to increase or decrease the amount by a percentage.

Or, click the calculator icon to display the calculator. Enter the required value.

Made2Manage compounds the increase or decrease.

• If you indicated a change percentage, select the Frequency for applying it.

• In the Step Forecast By box, enter a value to increase or decrease the recurring amount by a fixed value.

Or, click the icon at the end of the Step Forecast By box to display the calculator. Enter the required value.

Made2Manage compounds the increase or decrease.

• If you indicate a fixed change amount, select the Frequency for applying it.

• In the End Projection On box, enter the date to stop the line item’s calculations.

Or, click the calendar icon to display the calendar. Select the required date.

Or, double-click in the box to enter the current date.

5. To change a line item:

a. Select a row.

b. In the Line Item Description box, make the required changes.

c. If you do not forecast the line item using a recurring amount or if the line item is the beginning cash balance, you can add or remove accounts used in the calculation:

i. On the Toolbar, click More Actions. The More Actions panel appears on the left side of the page.

ii. Select More Actions > Actions > GL Accounts.

The GL Accounts (CFP5) window appears.

You can either manually select the account of your choice or select the Select check box in the grid toolbar to select all the accounts.

iii. Select the check box in the Select column.

Or, select the Select check box on the child toolbar to select all the account numbers.

Click the Select check box again on the child toolbar to clear all the selected check boxes.

iv. On the header, click Save.

Or, click Cancel to exit from the GL Accounts (CFP5) window.

6. To remove a line item:

a. On the Toolbar, click More Actions. The More Actions panel appears on the left side of the page

b. Select More Actions > Actions > GL Accounts.

The GL Accounts (CFP5) window appears.

c. Select a row.

d. On the header, click Delete.

A message, Preparing to delete this information. Are you sure? appears.

e. Click OK to remove the line item.

Or, click Cancel to retain the line item.

The next step is to run the forecast.