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

This option is not applicable to the Statistics by Dimension report.
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 only applicable in these reports:
  • Comparative Financial Statement
  • Consolidated Financial Statement
  • Income Statement - Budget versus Actual
  • Project Analysis
  • Remaining Budget Evaluation
  • Consolidated Ledger Balance Sheet
  • Reconciliation of Balance Sheet of Governmental Funds to Statement of Net Position
  • ADB Balance Sheet
  • Finance Structure and Account Analysis
  • Long Term Plan Overview
  • Statistics 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
  • Project Analysis
  • Remaining Budget Evaluation
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:
  • Summary Trial Balance
  • 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).
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 Expansion 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, Statistics by Dimension and Long Term Plan Overview.
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 these reports:

  • Summary Trial Balance
  • Statement of Capital Expenditures
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
Note: This option is enabled by default.
Note: For Revenue Trends (with Statistics and Ratios), the option is disabled by default.
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:
  • Comparative Financial Statement
  • Consolidated 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
  • Project Analysis
  • Remaining Budget Evaluation
  • Consolidated Ledger Balance Sheet
  • 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
  • Financial Structure and Account Analysis
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
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.

Select any of these options to display required information for an Account:

  • ID
  • Name

This option is only applicable in these reports:

  • Project Analysis
  • Remaining Budget Evaluation
  • Consolidated Ledger Balance Sheet
  • ADB Trial Balance
  • Project Contracts Revenue and Expense Comparison

Special Case:

Department (Cost Center) Profit and Loss only allows the option to add ID in the report.

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
  • 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
  • Finance Structure and Account Analysis

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 to these report:

  • Statistics by Dimension
  • Government Wide – Statement of Activities
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.
  • 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.

    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
Note: No Scaling is enabled by default in these reports:
  • Project Analysis
  • Project Comparative Fin Statement
  • Remaining Budget Evaluation
  • Project Remaining Budget Evaluation
  • Finance Structure and Account Analysis
  • Department (Cost Center) Profit and Loss
  • ADB Balance Sheet
  • Operating Expenses and Revenues by Dimension
  • Salary and Benefits by Dimension
  • Revenue Trends (with Statistics and Ratios)
  • Projects Contracts Revenue and Expense Comparison
Decimals Select this option to display values with decimals in the report.
Note: Show Decimals are enabled by default in these reports:
  • ADB Balance Sheet
  • Project Analysis
  • Project Comparative Financial Statement
  • Projects Remaining Budget Evaluation
  • Remaining Budget Evaluation
  • Operating Expenses and Revenues by Dimension
  • Salary and Benefits by Dimension
  • Projects Contracts Revenue and Expense Comparison
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.
  • The Store to IDM option allows users to export reports to the IDM repository in PDF format.

    This feature enables users 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
  • Periodical
  • 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