Using the Cash Flow Analytics Dashboard
The Cash Flow Analytics dashboard provides you with a detailed analysis of how cash moves in and out of your companies over a given year, quarter, or period. Using column charts and flat gauges, this information is divided across three tabs:
- Summary
- Collections
- Payments
The Cash Flow Analytics 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 total cash flow in and out separated into Collections (cash in), Payments (cash out), and Summary (difference between cash in and out).
- View your collections and payments data for any range of time using the filters provided.
- Compare your collections and payments by year, quarter, or period.
For more details of the fields used by the Cash Flow Analytics dashboard, see Financial Transactions 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 Year, Quarter, or Period.
- Currency: select the currency you want to see data for. You can select Home, Dual, Home (Reversed), or Dual (Reversed).
- 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.
- Year: use the Operator to select the years you want to see data for.
- Period: use the Operator to select the periods you want to see data for. You can also select All to view data from all periods.
- Special Period 100: include or exclude Special Period 100 for the selected year. Period 100 is added to period 12.
- Bank Account: use the Operator to select the bank accounts you want to see data for. You can also select All to view data from all bank accounts.
- 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.
- General Ledger Account: use the Operator to select the general ledger accounts you want to see data for. You can also select All to see data from all general ledger 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 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.
Cash Flow Analytics Dashboard Charts
The Cash Flow Analytics dashboard contains the following charts:
Chart |
Type |
Description |
---|---|---|
Free Cash Flow | Flat gauge |
The Free Cash Flow value represents the difference between Collections and Payments for the selected time range. A positive value indicates that more cash is being collected than is being paid. The adjacent flat gauges display the collection and payment values separately for the same time range. |
Free Cash Flow Over Time | Combination of column and line chart |
The columns display the Collections and Payments for the selected time range. The line displays the difference between Collections and Payments. A positive value indicates that more cash is being collected than is being paid. |
Chart |
Type |
Description |
---|---|---|
Collections | Column comparison chart |
Displays the total of Receipt and Refund cash entry types, according to the filters that you select. Click any column to drill for more detailed information. The Collections By treemap and Transactions report update accordingly. |
Collections 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 collection values for the selected time range. The same information is displayed in an adjacent table. In the treemap click any account to include or exclude them. The Collections column comparison chart and Transactions report update accordingly. |
Transactions | Report |
Displays a list of Account transactions according to the filters that you select. Transactions are listed in date order, with the most recent transactions at the top of the report. Actions:
|
Chart |
Type |
Description |
---|---|---|
Payments | Column comparison chart |
Displays the total of Payment and Payment Refund cash entry types, according to the filters that you select. Click any column to drill for more detailed information. The Payments By treemap and Transactions report update accordingly. |
Payments 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 payment values for the selected time range. The same information is displayed in an adjacent table. In the treemap click any account to include or exclude them. The Payments column comparison chart and Transactions report update accordingly. |
Transactions | Report |
Displays a list of Account transactions according to the filters that you select. Transactions are listed in date order, with the most recent transactions at the top of the report. Actions:
|
For more information about dashboard functionality, see Using the Dashboards Charts.