The following describes how to analyse the cash flow forecast from the Calendar view which is the main panel for the CFM role.
The Calendar views present expected incoming and outgoing payments summarised per expected payment date on a daily, weekly or monthly level.
All expected incoming payments are shown as positive (+) values and all expected outgoing payments are shown as negative (-) values in the columns. Five different views are available which makes it possible to view the cash flow forecast values in different currencies. These are:
- Cash flow forecast in system currency (Revaluated)
Displays the cash flow forecast values in system currency. The values are revaluated, i.e., the current exchange rates are reflected in the cash flow forecast. The transaction currency period and level defaults, set up in the G/L control file, and the date when the collection was run are used to pick up the currency exchange rate when calculating the revaluated system amount. - Cash flow forecast in system currency
Displays the cash flow forecast values in system currency. The values are not revaluated, i.e., the currency exchange rates used when the transaction was entered are reflected in the cash flow forecast. - Cash flow forecast in reporting currency (Revaluated)
Displays the cash flow forecast values in reporting currency. The values are revaluated, i.e., the current exchange rates are reflected in the cash flow forecast. The reporting currency period and level defaults, set up in the G/L control file, and the date when the collection was run are used to pick up the currency exchange rate when calculating the revaluated reporting amount. - Cash flow forecast in reporting currency
Displays the cash flow forecast values in reporting currency. The values are not revaluated, i.e., the currency exchange rates used when the transaction was entered are reflected in the cash flow forecast. - Cash flow forecast in transaction currency
Displays the cash flow forecast in transaction currency. The transaction currency is selected by the user from the top of the panel.
Note: The revaluation is performed when the expected payments are collected from DC1.
Caution: If an exchange rate for the reporting currency has not been set up correctly in DC1 all expected payments will be shown as zero in this Calendar view.
Caution: If an exchange rate for the reporting currency has not been set up correctly in DC1 all expected payments will be shown as zero in this Calendar view.
Tip: Panels which are not relevant for your line of business can be deleted from the Calendar view. You would define once which currency should be the working currency in your company. See Customise a perspective for instructions.
In this task, we will work with Cash flow forecast in system currency (Revaluated).
To analyse your cash flow forecast, do as follows:
- Click Panel types/Calendar view and select Cash flow forecast in system currency (Revaluated).
- The system opens the main panel of the Cash flow forecast Calendar view which is the lowest level for working with cash flow forecasting:
- The Cash flow forecast Calendar view expanded to a daily level is displayed:
- Expected Cash & Bank
- The starting value for the cash flow forecast is the actual closing balance of all Cash and Bank accounts which is displayed on the first line (up to and including yesterday’s date) in column Accumulated (see further information below). This actual opening balance is brought forward and shown as an opening balance the next day in column Expected Cash & Bank. This opening balance is used as the starting value for the calculation of column Accumulated.
- Which accounts to be included in the Cash and bank opening balance are defined in Collection view Cash and Bank accounts. See Select cash and bank accounts.
- Sales orders
- Displays all open sales orders including VAT amount. The expected payments are automatically retrieved from DC1. The expected payment date for sales orders is calculated according to the following:
- Accounts receivable
- Displays all open A/R transactions (including transactions in transfer from DC1 Distribution) including VAT amount. The expected payments are automatically retrieved from DC1. The expected payment date for A/R transactions is calculated according to the following:
- Purchase orders
- Displays all open purchase orders including VAT amount. The expected payments are automatically retrieved from DC1. The expected payment date for purchase orders is calculated according to the following:
- Accounts payable
- Displays all open A/P transactions including VAT amount. The expected payments are automatically retrieved from DC1. The expected payment date for A/P transactions is calculated according to the following:
- Personnel
- VAT
- Loans
- Interest
- Total
- Displays the total of all expected incoming and outgoing payments during the day.
- Accumulated
- Displays the total of all expected incoming and outgoing payments during the day including the opening balance for the cash and bank accounts.
Panel image
All expected payments are aggregated on a monthly level.
You can click on column 1 to expand the forecast to an aggregated weekly level (click 1 once again to collapse the calendar). Click on column 2 to expand the forecast to a daily level (click 2 once again to collapse the calendar).
Here, we will analyse the forecast on a daily level.
Note: The same information applies if you want to analyse the forecast on a weekly or monthly level.
Panel image
Several columns are displayed on this panel with the following information available:
| Dispatch date + number of credit days defined for the terms of payment + number of Expected payment deviation days for the business partner |
| Due date + number of Expected payment deviation days for the business partner |
| Dispatch date + number of credit days defined for the terms of payment + number of Expected payment deviation days for the business partner |
| Due date + number of Expected payment deviation days for the business partner |
The following columns show the expected payments for personnel, VAT, loans, and interest. These expected payments must be entered manually by the user. See Enter forecasted payments manually for further instructions.
Tip: To transpose (view columns to the left and the dates as columns) the Calendar view, do as follows; right-click in the toolbar and select View to display the Transpose icon. Click on it. Click Refresh. The system now displays a transposed Calendar view. This may be useful if not all columns fit on the panel and you want to get an overview of all expected payments on a daily level. To return to the original view, repeat the same steps.