Using the Cash Flow Forecast Dashboard

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.

By default, the filters panel is displayed in this dashboard. You can toggle between hiding and displaying the filters panel by clicking . To change a filter selection, ensure the filter panel is displayed in the dashboard.

Your filter selections determine the data displayed on the dashboard. To set or change your filters, use the following drop-down options:

  • Frequency: specify whether you want to see Quarter or Period.
  • Currency: select the currency you want to see data for. You can select Home or Dual.
  • Currency Code: select the currency ISO code you want to see data for. This selection affects the companies available in the following Company filter. For example, if in the previous drop-down you select Home and here you select GBP, only companies with a GBP Home currency are available for selection in the following Company filter.
  • Company: select the companies you want to see data for. You can also select All if you want to see data for all companies in your org.
  • Special Period 100: include or exclude Special Period 100 for the current year. Period 100 is added to period 12.
  • Account: use the Operator to select the accounts you want to see data for. You can also select All to view data from all accounts.
  • Dimension 1: use the Operator to select the Dimension 1 values you want to see data for. You can also select All to see data from all Dimension 1 values.
  • Dimension 2: use the Operator to select the Dimension 2 values you want to see data for. You can also select All to see data from all Dimension 2 values.

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:

  1. Select a line.
  2. 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:

  1. Select a line.
  2. Click Drill Selected Account >. Individual transactions are shown. To return to the previous view click < Payments.

For more information about dashboard functionality, see Using the Dashboards Charts.