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 will show all accounts, including those with zero balances. Suppress Empty will hide accounts with no data for the selected parameter/calendar. Suppress Zero and Empty will hide accounts with either zero balances or no data.
Note: This option is only applicable in these reports:
  • Comparative Financial Statement
  • Consolidated Financial Statement
  • Income Statement - Budget versus Actual
  • Statement of Capital Expenditures
  • Summary Trial Balance
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
Move Totals to Bottom If selected, summary totals will display at the bottom of the report. By default, summary totals are shown at the top. This option supports an Inverted Hierarchy layout.
Note: This option is only applicable in these reports:
  • Comparative Financial Statement
  • Consolidated Income Statement
  • Income Statement - Budget versus Actual
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

 Displays posting accounts/projects of the report.
Note: Show Posting Projects is only applicable to the Project Analysis report. Show Posting Accounts is applicable to the remaining reports, except for the ADB Trial Balance.

If this option is selected, the Show Hierarchy, Move Totals to Bottom, and Begin Expand On Level options are disabled.
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 is not applicable in these reports:
  • Summary Trial Balance
  • Statement of Capital Expenditures
  • ADB Trial Balance
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
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.
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
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:

  • Show ID
  • Show Description
Note: This option is only 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
Note: Show ID is enabled by default in these reports:
  • Project Analysis
  • Project Comparative Fin Statement
  • Remaining Budget Evaluation
  • Project Remaining Budget Evaluation

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
Show Columns
  • 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
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.
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.
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
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
Calendar Period

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

  • Year-to-Date Calendar
  • Life-to-Date Calendar
Note: This is only applicable in these reports:
  • Project Analysis
  • Remaining Budget Evaluation
  • Project Comparative Financial Statement
  • Projects - Remaining Budget Evaluation
Export
  • Export to Excel
  • Export to PDF >
    • <Report Name>
    • <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 PowerPoint
 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 user can use the Store to IDM option to export reports to the IDM repository in PDF format.
Print Mode Switches the style of the data grid to Print Style. Everything else stays the same.
View
  • Balance Sheet account
  • Income Statement account
 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
  • Year-to-Date Calendar
  • Life-to-Date Calendar
 Use these options to switch calendar hierarchy.
Note: This is only applicable in these reports:
  • Project Analysis
  • Remaining Budget Evaluation
  • 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.