Using the Cash Flow Forecast - Intelligence Dashboard

The Cash Flow Forecast - Intelligence 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 four tabs:

  • Summary
  • Collections
  • Payments

The Cash Flow Forecast - Intelligence dashboard displays data from the Financial Transactions - Intelligence dataset which includes data from the Transaction and Transaction Line objects in Accounting.

The dashboard uses the following options to display transaction data:

  • Quarter. Identifies all transaction line items with a due date or predicted date a quarter before or a quarter after the current quarter.
  • Period. Identifies all transaction line items with a due date or predicted date five months before or three months after the current period. This option is set by default.

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.
  • View your data according to the due date or the predicted payment date.

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.

Due Date and Predicted Date

You can select whether to display your data according to the due date or the predicted payment date with the options located above the Filters section:

  • Click Due Date to display your data using the due date of the transactions.
  • Click Predicted Date to display your data using the predicted payment date for the transactions. The predicted payment date is retrieved from the Predicted Payment Date field calculated in the Intelligence Analytics recipe.

Your selection applies to all the charts of the dashboard.

Managing Filters

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: specify an operator and a value to select the accounts you want to display data for. You can also select All to view data from all accounts.
  • Dimension 1: specify an operator and a value to select the Dimension 1 values you want to display data for. You can also select All to see data from all Dimension 1 values.
  • Dimension 2: specify an operator and a value to select the Dimension 2 values you want to display 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 - Intelligence Dashboard Charts

The Cash Flow Forecast - Intelligence dashboard contains the following charts:

Summary Tab

Collections This Month/Quarter

This donut chart displays the following:

  • Total Collected - includes all receivable cash entry types for receipts and refunds.
  • Total Forecast - includes all sales invoices and sales credit notes with a due date equal to or later than today's date.
  • Total Overdue - includes all 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

This donut chart displays the following:

  • Total Paid - includes all payable cash entry types for payments and payment refunds.
  • Total Forecast - includes all payable invoices and payable credit notes with a due date equal to or later than today's date.
  • Total Overdue - includes all 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

This 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

This 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 Tab

Collections Outstanding

This stacked column chart displays the total overdue, total forecast, and current collections as of today. It includes all 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

This treemap chart displays multiple values according to your selection in the drop-down lists. 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)

This table displays the information about collections. 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 the accounts, click Drill All Accounts >. Individual transactions are shown. To return to the previous view click < Collections.

Transaction Details

This table displays the transaction information grouped by account.

This table contains the following columns:

  • Account Name
  • Transaction Document Number
  • Transaction Line Name
  • Transaction Date
  • Payment Date - this column shows the due date or the predicted payment date depending on whether you select Due Date or Predicted Date.
  • Age in Days
  • As of Document Value
  • Line Value
  • As of Value

Payments Tab

Payments Outstanding

This stacked column chart 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

This treemap chart 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)

This table displays the information about payments. 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 the accounts, click Drill All Accounts >. Individual transactions are shown. To return to the previous view click < Payments.

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

Transaction Details

This table displays the transaction information grouped by account.

This table contains the following columns:

  • Account Name
  • Transaction Document Number
  • Transaction Line Name
  • Transaction Date
  • Payment Date - this column shows the due date or the predicted payment date depending on whether you select Due Date or Predicted Date.
  • Age in Days
  • As of Document Value
  • Line Value
  • As of Value

Grouping, Sorting, and Ordering the Data

The Transaction Details tables enables you to customize the data displayed using the following selectors:

Selector

Description
Sort by

Select the column used to sort the data displayed. The following options are available:

  • "Aged in Days"
  • "Payment Date"
  • "Line Value"
  • "Transaction Date"
Order by Select whether to order the data ascending or descending.

Drilling Through to Records

You can drill through to view details of records displayed in the dashboard. The table below provides more information about the drillable fields.

To view details of a selected record:

  1. Click the field that you want to drill.
  2. Click , then click Open Record.
Drillable Fields in the Cash Flow Forecast - Intelligence Dashboard
Tab Chart Field Object Required License
Collections Transaction Details Transaction Document Number Sales invoice and sales credit note Accounting
Transaction Line Name
Payments Transaction Details Transaction Document Number Payable invoice and payable credit note

 
Transaction Line Name