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.
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. |
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).
|
||||||||||||
Description | Enter a description for the collector. | ||||||||||||
Inclusions | Indicates the inclusions you want to accumulate into
the collector 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.
|
||||||||||||
Movement sources |
|
This displays the period information for the periods defined against the model. This information is refreshed when you save the model properties.
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.
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.
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.
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.
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.
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.
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 |
|
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. |