Cash Book > Cash Flow Forecasting > Cash Flow Models

Cash Flow Models

You use this program to define the cash flow models you require for your company and to view your company's projected cash position into the future by applying various collectors and adding them to the current bank balances.

Toolbar and menu

Field Description
Edit  
Properties Maintains properties for the currently selected model.

You can indicate the currency of the model, whether you want to convert foreign values to local currency and the 12 period end dates on which to base the model.

New Model Adds a new cash flow model.
Model Indicate the model you want to use to project the cash flow.

Collector

This screen is displayed when you select the Insert collector Before, Insert Collector After or the Change Collector option from the Edit menu.

Field Description
Type  
Opening balance Adds an opening balance collector type to your model (only one opening balance collector can be added per model).
ValueDescription
MovementsAdds a movement collector type to your model.
Total inflow/outflowAdds a total inflow/outflow line to the model (i.e. the aggregate of all the movement collectors).

Only one total inflow/outflow collector type can be defined per model and because this calculation is based on the movements included, you cannot define any inclusions or selection criteria for this collector type.

Closing balanceAdds a closing balance line to the model.

Only one closing balance collector type can be defined per model and because this calculation is based on the opening balance and movements included, you cannot define any inclusions or selection criteria for this collector type.

SeparatorInserts a blank line either before or after the currently highlighted collector. It is used for formatting purposes only (i.e. you typically insert it for ease of readability of the model results).
Description Enter a description for the collector.
Inclusions Indicates the inclusions you want to accumulate into the collector type.
ColumnDescription
TypeIndicates the source of the inclusion.
FiltersIndicates the selection criteria defined for the inclusion type.
Add Indicates the source of the collector type you want to include.

The sources available depend on the type of collector you are adding.

Opening balance sources

The opening balance selected here is used for the first period of the model only. Opening balances for subsequent periods in the model are the closing balances of the relevant previous periods.

Value Description
Balance from CB Uses the Cash Book opening balance as the source when running the model.

Filters include the SYSPRO banks and currencies for which you want to include opening balances in the collector.

Balance from GL Uses the General Ledger opening balance as the source when running the model.

You would typically select this if you do not use the SYSPRO Cash Book module, or you want to include accounts from the General Ledger other than (or in addition to) your Cash Book control accounts.

Filters include the GL groups, asset accounts, liability accounts and ledger codes within the group for which you want to include opening balances in the collector.

Enter Balance at Run Time Prompts you for the opening balance (positive or negative) when you run the model.

You can indicate the text that must be displayed as the prompt wording.

Movement sources
Value Description
CB permanent entries Includes the Cash Book permanent entries in the relevant period as movements in the collector.

Filters include the bank and currency.

AP cash requirements Includes the supplier invoices, registered invoices, registered credit notes and registered debit notes due for payment in the relevant period as movements in the collector.

Filters include the supplier, branch, supplier class, bank and currency.

The Apply payment discounts option enables you to reduce the transaction totals by the settlement discounts applicable to the payment of the transactions.

AR payment projection

Includes customer invoices due for collection in the relevant period as movements in the collector.

The terms code against the customer is used to ascertain the due date of the invoice. The invoice due date is then used to ascertain the period range in which to include the invoice.

Filters include the customer, branch, customer class, geographic area and currency.

Settlement discount is ignored.

GL movements Includes ledger transactions in the relevant period as movements in the collector.

Filters include the group, account type, ledger code and period.

PO outstanding Includes outstanding purchase orders in the relevant period as movements in the collector.

Filters include the supplier, supplier class and currency.

The Apply payment discounts and Include tax value options enable you to include these in the purchase order values.

Ranges

This displays the period information for the periods defined against the model. This information is refreshed when you save the model properties.

Cash Flow Projection

This displays the value for each collector included in the model for each period. The values are displayed in the currency indicated against the Model Properties window, except if you specified a foreign currency and enabled the Convert to local option, in which case the values are displayed in your local currency.

You can maintain these collectors using the options from the Edit menu or typically using your right mouse button to select the options to maintain collectors.

Cash Book

This displays detailed information of Cash Book-related collectors included in the model, providing that you included Cash Book-related collectors and that data exists for the Inclusions criteria you indicated.

The Cash Book Graph pane displays a graphical representation of the currently highlighted line.

General Ledger

This displays detailed information of General Ledger-related collectors included in the model, providing that you included General Ledger-related collectors and that data exists for the Inclusions criteria you indicated.

The General Ledger Graph pane displays a graphical representation of the currently highlighted line.

Accounts Payable

This displays detailed information of Accounts Payable-related collectors included in the model, providing that you included Accounts Payable-related collectors and that data exists for the Inclusions criteria you indicated.

The Accounts Payable Graph pane displays a graphical representation of the currently highlighted line.

Accounts Receivable

This displays detailed information of Accounts Receivable-related collectors included in the model, providing that you included Accounts Receivable-related collectors and that data exists for the Inclusions criteria you indicated.

The Accounts Receivable Graph pane displays a graphical representation of the currently highlighted line.

Outstanding Purchase Orders

This displays detailed information of Outstanding Purchase Order-related collectors included in the model, providing that you included Outstanding Purchase Order-related collectors and that data exists for the Inclusions criteria you indicated.

The Outstanding PO Graph pane displays a graphical representation of the currently highlighted line.

Purchase order collection process

The Outstanding Purchase orders settings you select influence the values returned.

The following is the process for determining the values returned:

Process Description
Selection process
  1. The program reads the Purchase Order Master file and includes only non-completed orders and orders with an active status

    Orders are excluded if they do not conform to supplier, class and currency selections.

  2. The program reads the AP terms table using the invoice terms code from the Purchase Order Master as the key to establish the due days, discount days and discount percentage to apply.

  3. The program reads the Purchase Order Details file using the order number from the Purchase Order Master file as the key.

    If the order quantity is the same as the received quantity, the transaction is excluded (i.e. it is not an outstanding order).

    The program adds the due days to the purchase order latest promised due date and compares the dates against the dates in the range.

    Transactions that do not fall in the date range are excluded.

Order value calculation process

The discount value is subtracted from the price; the order quantity is subtracted from the original order quantity; and the two results are multiplied.

If you have enabled the Apply payment discounts option, then the program adds the due days to the purchase order detail latest promised due date. If the calculated due date is greater than or equal to the system date, then order value is adjusted by subtracting the discount percentage.

If you have enabled the Include tax value option, then the program reads the ADM Tax Master table with the purchase order tax code. The order value is adjusted by adding the tax percentage.

Display process

The program adds the due days to the purchase order latest promised due date. The calculated date is compared to the date range and when the range date is found, the value is included in that date entry.