Using the Cash Flow Analytics Dashboard

Note: Your version of Accounting must be Fall 2020 or later.

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
Note:

To navigate between the different dashboards, either click the relevant tab in the top header or click Select Asset Menu at the end of the dashboard title.

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 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 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.
    Note: By default all "Unknown" are excluded.
  • 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 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 Analytics Dashboard Charts

The Cash Flow Analytics dashboard contains the following charts:

Summary 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.
Collections Charts

Chart

Type

Description
Collections Column comparison chart

Displays the total of Receipt and Refund cash entry types, according to the filters that you select.

Note: Values from journals are not included.
Note: If you have Accounting Fall 2020 or later, you can exclude bank account journal lines which do not represent cash in or cash out using the Exclude from Cash Flow checkbox. The excluded lines are not displayed in the Cash Flow Analytics dashboard. For more information see the Accounting Help.

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.

Note: If you see "Unknown" in the Account Name column, this is because the cash entry has multiple line items.

Actions:

  • To open a record, hover over any Transaction Document Number or Transaction Name and click | Open Record.
  • To exclude a journal transaction line item from Cash Flow Analytics:
    Note: This bulk action requires the Cash Flow Analytics permission set in Business Analytics and the Edit permission for the Transaction Line Item object in Accounting.
    1. In the upper-right corner of the report click | Exclude Journals from Cash Flow Analytics.
    2. In the new window select the checkbox of the lines you want to exclude.
    3. [Optional] To see the transaction line items in detail click Show Selected. To return to the previous view click Back to Results.
    4. [Optional] If necessary use the search box above the table to find transaction line items.
    5. Click Exclude. If the server takes a long time to respond, deselect some records and try again.
    6. You must run the dataflow to update the Cash Flow Analytics dashboard. Go to the Analytics Studio app | Data Manager | Connect. Next to Not Scheduled click | Run Now.
    7. Go to Monitor and wait until the status of Dataflow is "Successful". Click to refresh the page content and update the status.
    8. Go to Dataflows & Recipes. For the relevant app click | Run Now.
    9. Go to Monitor and wait until the status of Dataflow is "Successful". Click to refresh the page content and update the status.
      Note: The corresponding journal lines are not updated. If in the future you upgrade from your current version of Accounting, there will be journal lines with no value in the Exclude Journals from Cash Flow Analytics field. However, the transaction line item is still excluded.

Payments Charts

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.

Note: Values from journals are not included.
Note: If you have Accounting Fall 2020 or later, you can exclude bank account journal lines which do not represent cash in or cash out using the Exclude from Cash Flow checkbox. The excluded lines are not displayed in the Cash Flow Analytics dashboard. For more information see the Accounting Help.

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.

Note: If you see "Unknown" in the Account Name column, this is because the cash entry has multiple line items.

Actions:

  • To open a record, hover over any Transaction Document Number or Transaction Name and click | Open Record.
  • To exclude a journal transaction line item from Cash Flow Analytics:
    Note: This bulk action requires the Cash Flow Analytics permission set in Business Analytics and the Edit permission for the Transaction Line Item object in Accounting.
    1. In the upper-right corner of the report click | Exclude Journals from Cash Flow Analytics.
    2. In the new window select the checkbox of the line you want to exclude.
    3. Click Exclude. If the server takes a long time to respond, deselect some records and try again.
    4. You must run the dataflow to update the Cash Flow Analytics dashboard. Go to the Analytics Studio app | Data Manager | Connect. Next to Not Scheduled click | Run Now.
    5. Go to Monitor and wait until the status of Dataflow is "Successful". Click to refresh the page content and update the status.
    6. Go to Dataflows & Recipes. For the relevant app click | Run Now.

    7. Go to Monitor and wait until the status of Dataflow is "Successful". Click to refresh the page content and update the status.

      Note: The corresponding journal lines are not updated. If in the future you upgrade from your current version of Accounting, there will be journal lines with no value in the Exclude Journals from Cash Flow Analytics field. However, the transaction line item is still excluded.

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