New Financial d/EPM Platform reports

This table shows financial reports under the new Financial Reporting Home dashboard:

Report name Description
Comparative Balance Sheet This report is used to display balance sheet item values such as assets and liabilities for the selected current and previous periods and the variances in between the periods.

You have alternative chart options where you can switch views:

  • Default display is a chart based on the periodical views.
  • In the additional chart, you have YTD view option displaying YTD values.

Click a chart account in the report to reflect monthly values on the chart.

In this report, you have the option to disable:

  • Show Analysis
  • Show Variance
  • Show Variance%

These are enabled by default.

Use the option Add Analysis to add more periods in the report. Use Manage Analysis to make changes in the columns or periods.
Consolidated Income Statement This report is used to display income statement items such as revenue and expenses for the selected period as in individual entities level plus also as aggregated values.

A chart representation of the report is displayed.

The report context parameters show all the dimensions configured from the Financial Reporting Home.

You can select individual entities to show in the report.

In Report Menu Options, select drop-down Column > Select Accounting Entities.

You can configure the accounts in the chart for Consolidated Income Statement and specify a name for the accounts for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration.

Note: When Sum of Others and ∑ (Calculated) are added as Columns, the drillback in Infor Ming.le on these columns is disabled.
Income Statement – Budget versus Actual On this screen, you can display and compare income statement items for the selected period in periodical and in YTD level. You can compare actuals versus and current versus previous period for both periodical and YTD levels.

A chart representation of the report is displayed.

You can click a chart account in the report to reflect values on the chart.

The report context parameters show all the dimensions configured from the Financial Reporting Home.
Summary Trial Balance On this screen trial balance items are displayed as opening balance, debit or credit outstanding balance and finally as closing balance.

A chart representation of the report is displayed.

You can click a chart account in the report to reflect monthly values on the chart.

The report context parameters show all the dimensions configured from the Financial Reporting Home. You can filter values here depending on the data you intend to see.
Statement of Capital Expenditures This report displays Beginning and Ending Balance for Property Plant and Equipment (PPE) and Accumulated Depreciation. These values are used to calculate Net Increase or decrease in PPE and Depreciation. These two values are summed to create Capital Expenditure. These values are displayed for the current and prior year.

Although this report is typically a year-end report that is run at year end, you can run the report anytime during the year.

A chart representation of the report is displayed.

You can configure the accounts for Statement of Capital Expenditures and specify a name for the accounts for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration.
Government Wide – Statement of Net Position The Statement of Net Position is a government-wide report that presents the same account information as a balance sheet. It assesses the balance of a governments’ assets against its liabilities. The report has the capability to show a government’s assets, liabilities, and equity.

You can configure the fund structure, Governmental Activities, Business Type Activities and Component Units funds for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration. Select Statement of Net Position tab.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Governmental Funds – Balance Sheet The report has the capacity to show Assets, Liabilities, and Equities for all different Funds under each Government sector.

You can select individual funds to show in the report. In Report Menu Options, select drop-down Column > Select Funds.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances The report has the capability to show a government’s revenues, expenditures, and changes in fund balances.

You can setup revenues, other financing sources, special items, expenses and configure the fund structure and funds for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration. Select Governmental Statement of Revenues tab.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Proprietary Funds - Statement of Net Position This report shows a government’s assets, liabilities, and equity at a point in time.

You can select individual funds to show in the report. In Report Menu Options, select drop-down Column > Select Funds.

You can configure the fund structure, Enterprise Fund, and Internal Service fund for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration. Select the Proprietary funds tab.

Note: The report is only enabled to users with the PublicSectorReport_ST role.

Proprietary Funds - Statement of Revenues, Expenditures, and Changes in Net Position

 This report shows a government’s revenues and expenses plus changes in Fund Balances or Equity at specific points in time, including end of month, end of quarter and end of year, calendar or fiscal.

You can select individual funds to show in the report. In Report Menu Options, select drop-down Column > Select Funds.

You can configure the fund structure, Enterprise Fund, and Internal Service fund for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration. Select Proprietary funds tab.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Fiduciary Funds – Statement of Net Position This report assesses the balance of a government’s assets against its liabilities.

You can select individual funds to show in the report. In Report Menu Options, select drop-down Column > Select Funds.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Fiduciary Funds - Statement of Changes in Net Position This report shows a government’s additions and deductions plus changes in Net Position or Equity at specific points in time, including end of month, end of quarter and end of year, calendar or fiscal.

You can select individual funds to show in the report. In Report Menu Options, select drop-down Column > Select Funds.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Government Wide - Statement of Activities This report shows revenues, expenditures, and the change in net position for government activities at a specific point in time.

You can configure the Program Revenues, General Revenues, Expenses, Fund Structure, Governmental Activities, Business Type Activities, and Component Units Funds for a particular Reporting Basis. Go to Dashboards > Administration > Report Configuration. Select Statement of Activities tab.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Budget and Actual – Statement of Revenues, Expenditures, and Changes in Fund Balances

The report shows government’s revenues and expenses, plus change in net position at a specific point in time. You can display and compare income statement items for the selected period.

Use Manage Analysis to make changes in the columns or add more Budget in the report. In Report Menu Options, select drop-down Column > Manage Analysis.

Note: The report is only enabled to users with PublicSectorReport_ST role.

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.
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 Balance Sheet
  • Consolidated Income Statement
  • Income Statement - Budget versus Actual
  • Statement of Capital Expenditures
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
Row Height Select this option to change the cell size for better visibility. The options available are:
  • 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
Group Separator Enable this to separate sections visually.
Note: This is not applicable in these reports:
  • Comparative Balance Sheet
  • Consolidated Income Statement
  • Income Statement – Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures
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 Balance Sheet
  • Income Statement-Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures
Select Accounting Entities You can select individual entities to show in the report.
Note: This option is only applicable in Consolidated Income Statement.
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 Balance Sheet
  • Consolidated Income Statement
  • Income Statement - Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures
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 Income Statement.

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 Balance Sheet
  • Consolidated Income Statement
  • Income Statement - Budget versus Actual
  • Summary Trial Balance
  • Statement of Capital Expenditures

For header settings, Wrap Headers is activated by default. 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 Income 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
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.
Note: This option is only applicable in Comparative Balance Sheet.
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
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 is not applicable in these reports:
  • Summary Trial Balance
  • Statement of Capital Expenditures
Export
  • Export to Excel
  • Export to PDF >
    • <Report Name>
    • <Report Name> (Statutory)
      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> (Statutory). Long file names are automatically cut to 46 characters.

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

  • Export to PowerPoint
 Select any of the options to get a better view of the reports.
Note: 
  • Export to PDF > {Report Name} (Statutory) are only applicable in these reports:
    • Comparative Balance Sheet
    • Consolidated Income Statement
    • Income Statement - Budget versus Actual
    • Summary Trial Balance
    • Statement of Capital Expenditures
  • Export to Excel ignores the Wrap Headers option. The column names in the report are always in wrap headers.
Print Mode Switches the style of the data grid to Print Style. Everything else stays the same.