Use this form to set up ledger or budget accounts that are used in cash flow forecasts. In the cash flow forecast, future ledger transactions are estimated on the basis of information that is already registered, such as invoices that are not yet paid, expected sales tax payments, and budget transactions.

To include the entire ledger budget transaction in the cash flow forecast, set up the fields as follows:

  • = 100%

  • = Blank (no value)

  • = Account number for the budget account

For a sales or purchase forecast, select a value that is typical of most customers or vendors.

Open the form

  1. Click > Common Forms> .

  2. Select the sales account.

  3. Click > .

Tasks that use this form

Example

Set up a cash flow forecast for a sales account.

  1. Click > Common Forms> .

  2. Select the sales account.

  3. Click > .

  4. In the field, enter 100.

  5. In the list, select M15 Current Month + 15 days.

  6. In the list, select the cash account to which the sales account is linked for the cash flow forecast.

  7. Click > Common Forms> and create a sales order of 1,000 for a customer whose value is the same as in step 5.

  8. Click > > > , and run the forecast.

  9. Click > Common Forms> , and select the cash account that you selected in step 6.

  10. Click > .

Data used to calculate cash flow

Area

Description

Sales order

Sales orders that are not yet invoiced and that result in physical or financial sales.

Purchase order

Purchase orders that are not yet invoiced and that result in physical or financial purchases.

Accounts receivable

Open customer transactions (invoices that are not yet paid).

Accounts payable

Open vendor transactions (invoices that are not yet paid).

Ledger transactions

Transactions where it is specified that a future posting will take place, such as sales tax payments.

Note Note

For sales taxes, sales tax payment periods might not yet be created for the future. You still can calculate cash flow forecasts, but the sales tax payment date cannot be defined.

Ledger budget

Budget transactions that are marked for cash flow forecast.

Customer sales budget

Budget transactions that are marked for cash flow forecast.

Vendor purchase budget

Budget transactions that are marked for cash flow forecast.

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview tab

Set up the criteria for a cash flow forecast for the selected ledger or budget account, according to the posting type and terms of payment of current and expected transactions.

General tab

For the selected terms of payment and posting type line, view the tab information for the selected terms of payment and posting type line.

Fields

Field

Description

The percentage to include in the cash flow forecast.

The terms of payment for the current budget line.

The expected posting type relating to the cash flow forecast.

Select the account that the share of the amount is posted to.

Select the account that the share of the amount is posted from.

Specifies whether the forecast is a budget or a transaction.

See Also