Using the Trial Balance Dashboard

The Trial Balance dashboard enables you to run your trial balance reports in Financial Statements and view the resulting data within the dashboard. This dashboard uses the Financial Transactions dataset and contains:

  • Prompts: filter by company, currency, year, and period.
  • Subtotals: view subtotals and totals.
  • Drill down functionality: drill down on certain values within the report table. As this report has drill down functionality, negative values are not shown in parenthesis. The destination for this drill is the related transaction list.

To use the report:

  1. Use the Year drop-down to select the year you want to see data for.
  2. Use the Period drop-down to select the period of the year you want to see data for.
  3. Use the Special Period 100 drop-down to select "Include (for selected year)" or "Exclude (for selected year)". This includes or excludes special period 100. All other special periods up to the year and period selected are always included. For a definition of the special periods, see Financial Balances Fields.
  4.  The following three drop-downs have dependencies on each other:
    1. Currency: select "Home" or "Dual". This selection affects the currencies available in the following Currency Code filter. For example, if you select Home only the ISO codes that are Home currencies are displayed in the following Currency Code filter.
    2. 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.
    3. Company: select the companies you want to see data for.
    Note: If mixed currency is shown a warning appears. If you select different values in the Currency or Currency Code fields, any previously selected companies are not deselected, even if they are no longer valid for the new currency and currency code. To remedy this open the company filter picker, click Companies Selected and deselect any incorrectly selected companies. When the data is correct the warning disappears and the correct data is displayed.
  5. [Optional] To drill down, select a row and click Drill Selected GLA.
Note:

When you select a total or subtotal row in the table, the row is not highlighted.

Configuring Your Dashboard

The dashboards in Financial Statements are configured using the configuration wizard. For more information, see Creating an App from the Financial Analytics Template.