Report menu options

These menus are available in all the reports:

Menu Options Description
Rows Zero Suppress Rows If all the columns for the row is zero value, that row is suppressed in the report.
Note: This option is only applicable to the ADB Balance Sheet by Dimension report and is disabled by default.

No Suppress

Suppress Empty

Suppress Zero & Empty

 If the selected row suppression is set to No Suppress, it shows all accounts, including those with zero balances. Suppress Empty hides accounts with no data for the selected parameter/calendar. Suppress Zero and Empty hides accounts with either zero balances or no data.
Note: 
There is an exception in the Statistics by Dimension report:
  • When No Suppress is enabled, the Show Posting Accounts and Begin Expense on Level options are disabled.
  • When Begin Expense on Level is set to ALL, No Suppress is disabled.
  • When Show Posting Accounts is enabled, both No Suppress and Begin Expense on Level are disabled.
Show Hierarchy If selected, the row dimension is displayed with correct indentation of parent and child to present the hierarchy relation.
Note: This option is not applicable in these reports:
  • Statement of Capital Expenditures
  • Department (Cost Center) Profit and Loss
  • Cash Flow (Indirect Method)
  • Projects - Remaining Budget Evaluation
  • Statement of Net Position
  • Governmental Funds - Balance Sheet
  • Governmental Funds - Statement of Revenues , Expenditures, and Changes in Fund Basis
  • Budget and Actual - Statement of Revenues , Expenditures, and Changes in Fund Basis
  • Proprietary Funds - Statement of Net Position
  • Proprietary Funds - Statement of Revenues , Expenditures, and Changes in Net Position
  • Fiduciary Funds - Statement of Net Position
  • Fiduciary Fund - Statement of Changes in Net Position
  • Reconciliation of Statement of Revenues , Expenditures, and Changes in Fund Basis to Statement of Activities
  • ADB Trial Balance
  • ADB Balance Sheet by Dimension
Display Totals on Top

Totals are positioned at the bottom by default. When enabled, they appear at the top of each account in the report.

Note: This option is only applicable in these reports:
  • ADB Balance Sheet
  • Comparative Financial Statement
  • Consolidated Financial Statement
  • Income Statement Budget versus Actual
  • Summary Trial Balance
  • Consolidated Ledger Balance Sheet
  • Trial Balance Summary Totals
  • Finance Structure and Account Analysis
  • Remaining Budget Evaluation
  • Project Analysis
  • Project Contracts - Revenue and Expense Comparison
  • Operating Expenses and Revenues by Dimension
  • Long Term Plan Overview
Note: The option is enabled by default for the Finance Structure and Account Analysis report. You have the option to disable this feature.
Pagination If selected, it sets the view of the current report to a paged format.
Note: This option is only applicable in these reports:
  • Statement of Capital Expenditures
  • ADB Trial Balance

Show Posting Accounts

Show Posting Projects

Show Posting <set dimension>

 Displays posting accounts/projects of the report.
Note: 

Show Posting Projects only applies to the Project Analysis report, while Show Posting Accounts applies to all other reports except the ADB Trial Balance.

If this option is selected, Show Hierarchy, Display Totals on Top, and Begin Expanse On Level are disabled.

Additionally, in the Finance Structure and Account Analysis report, the Show Posting option depends on the selected dimension, displaying the posting level or base element in the report.

Note: Show Posting Accounts is not applicable to Cash Flow (Indirect Method).
Show Row Total

Select Row Total to display a totals row at the bottom of the report, summing values down each visible column.

Note: This option is only applicable in the Financial Structure and Account Analysis report.
No. of Visible Projects

Select this option to display the number of projects to display in the report.

Note: This is only applicable in Projects - Remaining Budget Evaluation and Project Comparative Financial Statement.
Row Height Select this option to change the cell size for better visibility. These are the available options:
  • Extra Small
  • Small
  • Medium
  • Large
Begin Expanse on Level Select any of the Expansion All or Level 1 - 12 options on what expansion level you can set in the report.
Note: This option is not applicable in the Statement of Capital Expenditures report.
Group Separator Enable this to separate sections visually.
Note: This is not applicable in these reports:
  • Comparative Financial Statement
  • Consolidated Financial Statement
  • Income Statement – Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures
  • Project Analysis
  • Remaining Budget Evaluation
  • Consolidated Ledger Balance Sheet
  • Department (Cost Center) Profit and Loss
  • ADB Balance Sheet
  • ADB Trial Balance
  • Financial Structure and Account Analysis
Jump To Selected Account Select this option to return to the selected account used to display the graph or chart when pagination is used.

This option is only applicable in the Statement of Capital Expenditures report.
Columns Zero Suppress Column If all the rows for the column is zero value, that column is suppressed in the report.
Note: This option is not applicable in these reports:
  • Comparative Financial Statement
  • Income Statement-Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures
  • Government Wide - Statement of Activities
  • Budget and Actual - Statement of Revenues, Expenditures, and Changes in Fund Balance
  • Department (Cost Center) Profit and Loss
  • Reconciliation of Balance Sheet of Governmental Funds to Statement of Net Position
  • Reconciliation of Statement of Revenues, Expenses, and Changes in Fund Balance to Statement of Activities
  • ADB Balance Sheet
  • ADB Trial Balance
  • Project Analysis
  • Remaining Budget Evaluation
  • Project Comparative Financial Statement
  • Project Contracts - Revenue and Expense Comparison
  • Long Term Plan Overview
Note: This option is enabled by default.
Note: 

For Revenue Trends (with Statistics and Ratios) and Statistics by Dimension, the option is disabled by default.

For Finance Structure and Account Analysis, this option is only available if the Column Dimension is not set to Calendar Period.
Select Accounting Entities You can select individual entities to show in the report.
Note: This option is only applicable in Consolidated Ledger Balance Sheet.
Pagination of Columns Select any of these options to show how many column entities are shown per page:
  • 5
  • 10
  • 15
  • All
Note: This option is not applicable in these reports:
  • Government Wide - Statement of Net Position
  • Governmental Funds - Balance Sheet
  • Governmental Funds - Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds - Statement of Net Position
  • Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position
  • Fiduciary Funds - Statement of Net Position
  • Fiduciary Funds - Statement of Changes in Net Position
Begin Expanse on Level

Select any of the Expansion All or Level 1 - 12 options on what expansion level you can set in the report.

Note: This option is only applicable for Operating Revenues and Expense by Dimension and Long Term Overview Plan.
Show Columns

Select any of these options to display Entities Parent. This is the sum of all entities, the calculated sum of the selected accounting entities, and sum of other accounting entities:

  • Entities Parent
  • Σ (calculated)
  • Sum of others
Note: This option is only applicable in Consolidated Financial Statement and Consolidated Ledger Balance Sheet.

For header settings, Wrap Headers is activated by default, except in Remaining Budget Evaluation report. This is to save space in the report display. You can deactivate the option any time.

Note: This option is only applicable in these reports:
  • Consolidated Financial Statement
  • Government Wide-Statement of Net Position
  • Governmental Funds-Balance Sheet
  • Governmental Funds-Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds-Statement of Net Position
  • Proprietary Funds-Statement of Revenues, Expenditures, and Changes in Net Position
  • Fiduciary Funds-Statement of Net Position
  • Fiduciary Funds-Statement of Changes in Net Position
  • Government Wide - Statement of Activities
  • Remaining Budget Evaluation
  • Consolidated Ledger Balance Sheet
  • Department (Cost Center) Profit and Loss
  • Finance Structure and Account Analysis
Note: 

For the Financial Structure and Account Analysis report, the Wrap Headers option is displayed only when the Column Dimension in the Select Dimension report menu is not set to Calendar Period.

Select this option to add funds to:
  • Total Enterprise (Governmental) Funds - calculates overall total enterprise (governmental) funds
  • Calculated Total Funds - calculates only the total funds that are currently shown or selected in the report
  • Other Enterprise (Governmental) Funds - calculates only the remaining total funds that are not shown or selected in the report

This only applicable in these reports:

  • Governmental Funds – Balance Sheet
  • Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds – Statement of Net Position
  • Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position
  • Fiduciary Funds – Statement of Net Position
  • Fiduciary Funds – Statement of Changes in Net Position

Show Columns: ID – Name

Show Columns: ID

Show Columns: Name

You can choose from the display options for an account:

  • ID – Name - displays both the ID and Description in a single column
  • ID - displays only the ID in the column
  • Name - displays only the description in the column
Note: If both ID and Name are enabled, they appear in separate columns.

This option is not applicable in the Government Wide – Statement of Activities report.
Show Columns: Show Column Total Select Column Total to display a totals column at the right side of the report, summing values across each visible row.
Note: This option is only applicable in the Financial Structure and Account Analysis report.
Analysis The options available are:
  • Show Analysis - activated by default, you can deactivate the option any time. If deactivated, the Variance and Variance% columns are not displayed.

    For the Budget and Actual – Statement of Revenues, Expenditures, and Changes in Fund Basis reports, this option displays the additional budget set configured in Manage Analysis.

  • Show Variance - activated by default, you can deactivate the option any time. If deactivated, the Variance column is not displayed.
  • Show Variance% - activated by default, you can deactivate the option any time. If deactivated, the Variance% column is not displayed.
  • Add Analysis - use the option to add more periods in the report. A period is added after the delta percentage column.

    Periods are added as current period -2, -3, and so on.

  • Manage Analysis - use the option to change, delete, or add more periods.

    For the Budget and Actual – Statement of Revenues, Expenditures, and Changes in Fund Basis reports, this option allows you to modify the columns or add additional budget sets.

    Prior Period: Period -1, Periods -2, Periods -3, and Same Period Prior Year: Year -1, Years -2, Years -3 is available to compare:

    • Prior Period -1, -2, -3, and Same Period Prior Year -1, -2, -3 is available to compare:
    • For Period -1, -2, -3:

      For example, if you select 2023, -1 shows November 2023, -2 shows October 2023, and so on.

    • For Year -1, -2, -3:

      For example, if you select 2023, -1 shows 2022, -2 shows 2021, and so on.

Note: This option is only applicable in Comparative Financial Statement and Project Comparative Financial Statement.
Note: The analysis option is also available in the Finance Structure and Account Analysis report; however, the options for Show Analysis, Show Variance, and Show Variance% are hidden. The analysis option is only visible when the column dimension is set to Calendar Period.
Select Funds You can select individual funds to show in the report.

This option is only applicable in these reports:

  • Governmental Funds – Balance Sheet
  • Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds – Statement of Net Position
  • Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position
  • Fiduciary Funds – Statement of Net Position
  • Fiduciary Funds – Statement of Changes in Net Position
Total Position to Left When enabled, the Total Enterprise (Governmental) Funds, Calculated Total Funds, and Other Enterprise (Governmental) Funds columns if selected to display, is moved in the most left column of the report.

This option is only applicable in these reports:

  • Governmental Funds – Balance Sheet
  • Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances
  • Proprietary Funds – Statement of Net Position
  • Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position
  • Fiduciary Funds – Statement of Net Position
  • Fiduciary Funds – Statement of Changes in Net Position
Select Actuals
Use this option to change Scenario (Actual) displayed in the report.
Note:  This is only applicable in Project Analysis report.
Select Budgets

Use this option to change Scenario (Budget) displayed in the report.

Note: This is only applicable in these reports:
  • Project Analysis
  • Remaining Budget Evaluation
  • Department (Cost Center) Profit and Loss
Totals
The Actual Budget to Left option is activated by default. If deactivated, the scenarios (Actual and Budget) columns are moved after the Period values column of the report.
Note:  This is only applicable in Project Analysis report.
Show Columns

The options available are:

  • Show Variance – activated by default, you can deactivate the option any time. If deactivated, the column displays change to Variance Percentage.
  • Show Variance Percentage – if activated, it replaces the column display for Variance.
Note: This is only applicable in Project Analysis report.
  • Show Remaining - activated by default, you can deactivate the option any time. If deactivated, the column displays change to Remaining Percentage.
  • Show Remaining Percentage - if activated, it replaces the column display for Remaining.
Note: This is only applicable in Remaining Budget Evaluation report.
Show Calendar - enable this option within Show Columns so that the calendar period displays both the selected current period and the previous year. The option is available for all column dimensions except the Calendar Period column, where it does not apply.
Note: Applicable only in the Finance Structure and Account Analysis report.
Total Expenses - if enabled, the total expenses in the selected dimensions displays as a summed total.
Note: This is only applicable in Salary and Benefits by Dimension report.
Data Scaling Use this to represent data in different number notations such as thousands and millions scaling. The options available are:
  • No Scaling
  • 1,000 Scaling
  • 1,000,000 Scaling
Decimals Select this option to display values with decimals in the report.
Balance Type The options available are:
  • Financial Reporting Balance - data displayed as per the ledger entry method
  • Natural Balance - data displayed according to the sign of the data.
Note: This option is not applicable in these reports:
  • Summary Trial Balance
  • Statement of Capital Expenditures
  • ADB Trial Balance
  • Project Analysis
  • Projects - Remaining Budget Evaluation
  • Trial Balance - Summary Totals
  • Finance Structure and Account Analysis
  • Projects Contracts - Revenue and Expense Comparison
  • Cash Flow (Indirect Method)
  • Statistics by Dimension Report
Export
  • Export to Excel
    • <Report Name>
    • <Report Name> Standard
  • Export to Excel (ADB Balance Sheet report)
    • Standard
    • Entity
  • Export to PDF
    • <Report Name>
    • <Report Name> Standard
    • <Report Name> Formatted
      Note: Configure IDM in FSM reports with data model and templates to use this option. Go to Configuring IDM Enablement in FSM Reports for instructions.

      There is a limit set for report file names when you run Export to PDF > <Report Name> (Formatted). Long file names are automatically cut to 46 characters.

      This does not affect favorite name and report title inside PDF. Only the file name.

  • Store to IDM
  • Export to PDF > ADB Balance Sheet
    • ADB Balance Sheet (Standard)
    • ADB Balance Sheet (Per Entity)
 Select any of the options to get a better view of the reports.
Note: 
  • Export to Excel ignores the Wrap Headers option. The column names in the report are always in wrap headers.
  • You can export reports to the IDM repository in PDF format using the Store to IDM option.

    Use this feature to select a specific folder within IDM to save their formatted reports. By default, reports are saved to the default repository unless an alternative location is specified.

    For instructions on creating or adding a new folder to the available options, refer to KB 3507302.

  • Export PDF Formatted is not available in the Finance Structure and Account Analysis report
For Per Entity, all entities are in one workbook but separate worksheets. Use VSTACK command to combine all sheets into one.
Note: ADB Balance Sheet per Entity are exported based on the top level entity or selected entities.

This is only applicable in ADB Balance Sheet.

For ADB Balance Sheet (Per Entity), the generated report is in a consolidated format, combining all entities into one PDF file.
Note: 

The <Report Name> Standard option in Excel and PDF export includes manually expanded accounts as displayed in the report.

This option is only applicable to these reports:

  • Comparative Financial Statement
  • Consolidated Financial Statement
  • Income Statement - Budget vs Actual Report
  • Summary Trial Balance
  • Long Term Plan Overview
Print Mode Switches the style of the data grid to Print Style. Everything else stays the same.
View
  • Balance Sheet account
  • Income Statement account
  • ADB Balance Sheet
  • ADB Balance Sheet by Dimension
  • Operating Expense by Dimension
  • Operating Revenues by Dimension
 If selected, the report can be run for Balance Sheet or Income Statement accounts.
Note: This option is only applicable in these reports:
  • Comparative Financial Statement
  • Consolidated Financial Statement

Use the ADB Balance Sheet and ADB Balance Sheet by Dimension options to switch reports and define or select dimensions in the ADB Balance Sheet by Dimension view.

Use the Operating Expense by Dimension and Operating Revenues by Dimension to switch between reports to compare and analyze financial data at departmental and entity levels.
Calendar Period

Use this to switch calendar hierarchy. The options available are:

  • Year to Date Calendar
  • Life to Date Calendar
  • Standard Calendar
Note: This is only applicable in these reports:
  • Project Analysis
  • Project Comparative Financial Statement
  • Projects Remaining Budget Evaluation
  • Projects Contracts Revenue and Expense Comparison
  • Remaining Budget Evaluation
  • Revenue Trends (with Statistics and Ratios)
  • Financial Structure and Account Analysis
  • Long Term Plan Overview
Note: The three-calendar option is only available in Finance Structure and Account Analysis. Both Revenue Trends (with Statistics and Ratios) and Long Term Plan Overview support Standard and Year-to-Date options, while all other reports support Life-to-Date and Year-to-Date options.
Standard or Expanded
  • Summary
  • Summary – Detailed
  • Periodical
  • Periodical – Detailed
  • Year To Date Analysis

Use these option to switch between Summary, Periodical (Monthly), and Year To Date Analysis (Monthly) formats.

Note: These options are only applicable in Summary Trial Balance Report.
Report Configuration (Select Dimension, Select Accounts, etc.) Depends on the configuration of the report being accessed.

This option can be accessed and modified within the report.

Note: 

This is only applicable in these reports:

  • Project Comparative Financial Statement
  • Projects – Remaining Budget Evaluation
  • Revenue Trends (with Statistics and Ratios)
  • Project Contracts – Revenue and Expense Comparison
  • Cash Flow (Indirect Method)
  • Long Term Plan Overview
  • Statistics by Dimension
Note: This option allows users to configure the report before access, enabling modifications to the Department Dimension and Chart Account Structure.

This is applicable in these reports:

  • Salary and Benefits by Dimension
  • Operating Expenses and Revenues by Dimension
Project

Use this option to enable or disable Show Project Status. When enabled, the report displays Project Status values from the Posting Accounts and adds a Project Status column. This option is disabled by default.

Select Active or Inactive Summary Accounts to control which accounts are displayed.

Note: This option only applies to these reports:
  • Project Analysis
  • Project Analysis and Project Contracts – Revenue and Expense Comparison