Setting up Cash Flow Forecast - Intelligence 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. You can amend the following:

  • Bank Account. Select the bank account to include in the Cash Flow Forecast - Intelligence dashboard.
  • General Ledger Accounts for Collections.
    • Select the Accounts Receivable (AR) general ledger accounts to include as collections.
    • For all journal line items where Line Type is "Account - Customer", select the Accounts Receivable (AR) general ledger accounts to include as collections.
      Note: We recommend that you configure this to ensure that data from journals is included and saved. If not, data from journals is not included and you would need to configure the general ledger accounts used in journals each time you open the dashboard.
  • General Ledger Accounts for Payments.
    • Select the Accounts Payable (AP) general ledger accounts to include as payments.
    • For all journal line items where Line Type is "Account - Vendor", select the Accounts Payable (AP) general ledger accounts to include as payments.
      Note: We recommend that you configure this to ensure that data from journals is included and saved. If not, data from journals is not included and you would need to configure the general ledger accounts used in journals each time you open the dashboard.
  • Aging Ranges. Specify the aging ranges in days for the aging table.
Note: The default selection for all the options above is "All".

Adding Custom Filtering

Note: To perform these steps, ensure that you:
  • Have the CRM Analytics Platform Admin permission set (if not, you can only make local settings changes for your current session).
  • Are using the Analytics Studio app (not the Analytics app). This is required to make changes that apply to all users.

To add custom filtering to your dashboard:

  1. Open the Cash Flow Forecast - Intelligence dashboard.
  2. Click .
  3. Configure the options described above.
  4. Click to return to your dashboard.

Each time you open the Cash Flow Forecast - Intelligence dashboard, data is shown according to the selections you made above.

Tip: To return to the default settings change the selections you made back to "All".

For information about how to use the dashboard, see Using the Cash Flow Forecast Dashboard.