New Financial EPM Platform reports

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

Report name Description
ADB Balance Sheet The report generates a balance sheet with average daily balances. The report information includes ending balances and ADB for the selected period such as month, a quarter, or a year.

To run the report, Average Daily Balance must be enabled for the selected Calendar Period.

Note: The report is only enabled to users with the BankingSectorReport_ST role.
ADB Trial Balance The report generates a trial balance with average daily balances. The report information includes opening balances, period movements, closing balances, and ADB for the selected period such as month, a quarter, or a year.

To run the report, Average Daily Balance must be enabled for the selected Calendar Period.

Note: The report is only enabled to users with the BankingSectorReport_ST role.
Comparative Financial Statement

The report can be run for Balance Sheet or Income Statement. The main purpose of the reports is to compare results by year, quarter, or month.

There is a View option when you select Balance Sheet accounts or Income Statement accounts.

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 previous periods in the report, if applicable. Use Manage Analysis to make changes in the columns or periods.

Consolidated Financial Statement

The report can be run for Balance Sheet or Income Statement. The main purpose of the reports is to compare results across selected Accounting Entities.

There is a View option when you select Balance Sheet accounts or Income Statement accounts.

A chart representation of the report is displayed when you select Income Statement accounts view.

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

You can define the maximum default number of columns to display in the report and configure the accounts in the chart for Income Statement. You can also specify a name for the accounts for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Consolidated Financial Statement.

Note: When Sum of Others and ∑ (Calculated) are added as Columns, the drillback in Infor Ming.le or Infor OS Portal on these columns is disabled.
Consolidated Ledger Balance Sheet The report is a standard balance sheet presented for one or more FSM Ledgers.

You can select individual entities to show in the report.

In Report Menu Options, select Columns > Select Accounting Entities.

You can define the maximum default number of columns to display in the report. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Consolidated Financial Statement.

Department (Cost Center) Profit and Loss The report shows revenues and expenditures for each department with actuals and budget comparison.

You can define the maximum default number of Departments to display in the report and configure the Department for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Department (Cost Center) Profit and Loss.

In the column display, the report shows comparison of actual scenarios for the selected period versus previous period in YTD level and Variance. And Budget Scenario, Actual Budget Variance, and Remaining Budget for the selected period.

You can make changes in the column data display for Budget Scenario. In Report Menu Options, select Columns > Select Budget.

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 budget 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 > GL Financial Reporting > Report Configuration. Select Statement of Capital Expenditures.

Project Analysis

The report has the capability to show the Organization’s Balance sheet and income statement accounts, displaying all account types. It shows the data over a period, such as month, a quarter, or a year.

In the column display, the report shows Period values with graph representation, Actual Commitments, Budget, Variance, Variance Percentage, Remaining, Remaining percentage, and Over/Under indicator.

  • You can make changes in the column data display for Scenarios (Actual and Budget). In Report Menu Options, select Column and click Select Actuals or Select Budgets.
  • You can switch column display between Variance or Variance Percentage. In Report Menu Options, select Column > Show Columns.
Note: Show Variance is enabled by default

The previous period column displays a line chart of the past 12 actual values based on the start period selected. Whenever you click a row/period value, it displays a chart onto the right side of the report.

  • When you click the Show data check box, the Project Period Values displays: The actual, budget, variance, and variance percentage for the number of periods selected.
  • You can change the variance chart to display either the percent or the value.
  • Change the number of periods displayed. For example, 1-12.

You can switch calendar hierarchy to:

  • Year-to-Date Calendar
  • Life-to-Date Calendar

Remaining Budget Evaluation

The report has the capability to show the Organization’s Balance sheet and income statement, showing the data over a period, such as month, a quarter, or a year.

In the column display, the report shows actual, encumbrances, commitments, total obligations, budget, variance percentage, remaining/remaining percentage, and over/under indicator.

  • You can make changes in the column data display for Budget Scenario. In Report Menu Options, select Column > Select Budget.
  • You can switch column display between Remaining or Remaining Percentage. In Report Menu Options , select Column > Show Columns.

    Note: Show Remaining is enabled by default.

You can switch calendar hierarchy to:

  • Year-to-Date Calendar
  • Life-to-Date Calendar
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 > GL Financial Reporting > Report Configuration. Select Statement of Net Position.

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 > GL Financial Reporting > Report Configuration. Select Statement of Activities.

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 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 > GL Financial Reporting > Report Configuration. Select Governmental Statement of Revenues.

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 Column > Manage Analysis.

Note: The report is only enabled to users with 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 Column > Select Funds.

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

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 Column > Select Funds.

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

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 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 Column > Select Funds.

Note: The report is only enabled to users with the PublicSectorReport_ST role.
Reconciliation of Balance Sheet of Governmental Funds to Statement of Net Position This report shows Reconciliation of Balance Sheet of Governmental Funds to Statement of Net Position.
You can configure the chart account and fund structure for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Reconciliation Balance Sheet.
Note: The report is only enabled to users with the PublicSectorReport_ST role.
Reconciliation of Statement of Revenues, Expenses, and Changes in Fund Balance to Statement of Activities This report shows Reconciliation of Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances to Government Wide – Statement of Activities.
You can configure the chart account and fund structure for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Reconciliation Statement of Revenues.
Note: The report is only enabled to users with the PublicSectorReport_ST role.