Using the Cash Flow Forecast Dashboard

ERP Cloud

When you open the dashboard all available data is shown. However if you prefer, you can add custom filtering which is automatically applied whenever you open the dashboard. For more information, see Setting up Cash Flow Forecast Dashboard.

The Cash Flow Forecast dashboard provides you with a detailed forecast of how cash is predicted to move in and out of your companies over a given quarter or period. Using a variety of charts, this information is divided across three tabs:

Summary
Collections
Payments

Note: To navigate between the different dashboards, either click the relevant tab in the top header or click

at the end of the dashboard title.

The Cash Flow Forecast dashboard displays data from the Financial Transactions dataset which includes data from the Transaction and Transaction Line objects in Accounting. By default, this dashboard displays data by period for the financial year greater than or equal to 2019.

This dashboard enables you to:

View the predicted total cash flow in and out separated into:
- Collections: cash in
- Payments cash out
- Summary difference between cash in and out
View your predicted collections and payments data using the filters provided.
Compare your predicted collections and payments by quarter or period.

For more details of the fields used by the Cash Flow Forecast dashboard, see Financial Transactions Output Fields.

If you want to edit the global filters which appear on this filter panel, click Edit to enter edit mode and click the global filters displayed under Filters. Click Manage Global Filters | Add Global Filter to add or remove fields from the Financial Transactions dataset. You can also add custom fields to your global filters.

Warning:

If your calendar is configured to contain more or less than 12 periods in a year, your dashboard data will be incorrect. With the exception of special periods, Analytics dashboards only support years with 12 periods. Also, you cannot compare data for companies with differing financial years.

Cash Flow Forecast Dashboard Charts

The Cash Flow Forecast dashboard contains the following charts:

Summary Charts
Chart	Type	Description
Collections This Month/Quarter	Donut chart	This displays the following: Total Collected - includes all receivable cash entry types (Receipt and Refund). Total Forecast - includes all receivable invoices (Sales Invoices and Sales Credit Notes) with a due date equal to or later than today's date. Total Overdue - includes all receivable invoices (Sales Invoices and Sales Credit Notes) with a due date earlier than today's date. By default, the total of all three is displayed in the center of the donut.
Payments This Month/Quarter	Donut chart	This displays the following: Total Paid - includes all payable cash entry types (Payment and Payment Refund). Total Forecast - includes all payable invoices (Payable Invoices and Payable Credit Notes) with a due date equal to or later than today's date. Total Overdue - includes all payable invoices (Payable Invoices and Payable Credit Notes) with a due date earlier than today's date. By default, the total of all three is displayed in the center of the donut.
Cash Flow Analytics	Combination of column and line chart	Displays the actual Collections and Payments. The columns display the Collections and Payments for the selected time range. The Free Cash Flow line displays the difference between Collections and Payments. A positive value indicates more cash being collected than being paid.
Forecast Analysis	Combination of column and line chart	Displays the forecast Collections and Payments. The columns display the Collections and Payments for the selected time range. The Free Cash Flow line displays the difference between Collections and Payments. A positive value indicates more cash being collected than being paid.

Collections Charts
Chart	Type	Description
Collections Outstanding	Stacked column	Displays the total overdue, total forecast and current collections as of today (includes all receivable invoices - Sales Invoices and Sales Credit Notes). Click any column to drill for more detailed information. The Outstanding By treemap and Forecast and Aged Analysis (Days) report update accordingly.
Outstanding by	Treemap	Displays multiple values according to your selection in the drop-down. For example, you might choose to select "Account Name" and "Top 10". You then see the top 10 accounts, and their corresponding total values for the selected range. Click any part of the treemap and the Collections Outstanding stacked column and Forecast and Aged Analysis (Days) report update accordingly.
Forecast and Aged Analysis (Days)	Report	Displays the collections information. This includes the following Sales Invoices and Sales Credit Notes: Overdue (shown in the corresponding day range) Due today (shown in the Current column) Not yet due (shown in the Total Forecast column) The Total Outstanding column is the sum of the Current, Total Forecast, and Total Overdue columns. Displays a list of transaction totals according to the filters that you select. Transactions are grouped by account and listed alphabetically. For a detailed view of an account: Select a line. Click Drill Selected Account >. Individual transactions are shown. To return to the previous view click < Collections.

Payments Charts
Chart	Type	Description
Payments Outstanding	Stacked column	Displays the total overdue, total forecast and current payments as of today (includes all payable invoices - Payable Invoices and Payable Credit Notes). Click any column to drill for more detailed information. The Outstanding By treemap and Forecast and Aged Analysis (Days) report update accordingly.
Outstanding by	Treemap	Displays multiple values according to your selection in the drop-down. For example, you might choose to select "Account Name" and "Top 10". You then see the top 10 accounts, and their corresponding total values for the selected range. Click any part of the treemap and the Outstanding Balances stacked column and Forecast and Aged Analysis (Days) report update accordingly.
Forecast and Aged Analysis (Days)	Report	Displays the payments information. This includes the following Payable Invoices and Payable Credit Notes: Overdue (shown in the corresponding day range) Due today (shown in the Current column) Not yet due (shown in the Total Forecast column) The Total Outstanding column is the sum of the Current, Total Forecast, and Total Overdue columns. Transactions are grouped by account and listed alphabetically. For a detailed view of an account: Select a line. Click Drill Selected Account >. Individual transactions are shown. To return to the previous view click < Payments.