New Financial EPM Platform reports

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

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

To run the report, enable Average Daily Balance for the selected Calendar Period.

The report also includes a feature to select any date within the current month and an option to navigate the ADB Balance Sheet by Dimension, allowing users to define or select which Dimension they want to add to the column section. Dimensions can be modified in the Report Configuration within the report.

Note: DPTOT (Daily Period Total) must be reloaded to fully utilize the report. Please note that the drillback functionality in Infor OS Portal is disabled for all columns in this report. To reload, navigate to Infor Financials & Supply Management > Administration Console > Analytic Cube and select Daily Period Total. Optionally, you can access Application Administrator > Financials > Shared Processes > Update Analytic Cube and select ADB Total cube to refresh.
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.

The report also includes a feature that allows users to select any date within the current month to generate an average daily balance for each day.

Note: DPTOT (Daily Period Total) must be reloaded to fully utilize the report. Please note that the drillback functionality in Infor OS Portal is disabled for all columns in this report. To reload, navigate to Infor Financials & Supply Management > Administration Console > Analytic Cube and select Daily Period Total. Optionally, you can access Application Administrator > Financials > Shared Processes > Update Analytic Cube and select ADB Total cube to refresh.
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.

Use the Move Totals to Bottom option to display summary totals at the bottom of the report. By default, summary totals are shown at the top.

In this report, you can hide data based on your preference:

  • No Suppress: 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.

In this report, you can 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 adjust columns or periods and select Prior Period: Period -1, Periods -2, Periods -3, and Same period prior year: Year -1, Years -2, Years -3 as an enhancement.

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.

Use the Move Totals to Bottom option to display summary totals at the bottom of the report. By default, summary totals are shown at the top.

In this report, you can hide data based on your preference:

  • No Suppress: 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.

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 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, Variance and Variance %. And Budget Scenario, Actual Budget Variance, Actual Budget Variance %, Remaining Budget 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 view 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.

Use the Move Totals to Bottom option to display summary totals at the bottom of the report. By default, summary totals are shown at the top.

In this report, you can hide data based on your preference:

  • No Suppress: 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.

Additional features were introduced, allowing you to compare yearly and monthly values. This feature provides the flexibility to choose whether to display the previous period or year. The ellipsis icon reveals these options: for periodic comparison—Period -1, Periods -2, Periods -3; and for YTD comparison—Year -1, Years -2, Years -3.

If the selected period or year has no data, the column label displays "! No Data Found for Selected Period!".

A chart representation of the report is displayed.

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

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

Summary Trial Balance Trial balance items are displayed as opening balance, debit or credit outstanding balance, and finally as closing balance.

As an enhancement, you can view Periodical and Year to Date reports. Click the View button to switch formats:

  • Summary: Default view shows YTD values for the selected period.
  • Periodical: Shows periodical values for all available months based on the selected period.
  • YTD Analysis: Shows YTD values for all available months based on the selected period, with the last period as the closing balance.

In this report, you can hide data based on your preference:

  • No Suppress: 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.

A chart representation of the report is displayed.

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

The report context parameters show all the dimensions configured from the Financial Reporting Home. You can filter values depending on the data that you want to see.

Trial Balance – Summary Totals The report is similar to the Summary Trial Balance. However, the Chart Account column is in the same format as the Consolidated Financial Statement - Balance Sheet. This means the posting accounts are displayed in Summary Accounts, and the total amounts are presented for each summary to the posting accounts level.

The Summary Accounts shows the account balances in the Opening Balance, Debit, Credit, and Closing Balance columns.

Statement of Capital Expenditures Shows 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 previous year.

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

In this report, you can hide data based on your preference:

  • No Suppress: 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.

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 Shows the Organization Balance sheet and income statement accounts, and all account types. Data over a period, such as month, a quarter, or a year is displayed.

In the column display, the report show Actuals, Budgets, Remaining percentage, Variance and Over/Under indicator.

  • To apply changes in the column data 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 shows a line chart of the past 12 actual values based on the start period selected. When you click a row/period value, a chart is displayed on the right side of the report.

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

You can switch calendar hierarchy to:

  • Year-to-Date Calendar
  • Life-to-Date Calendar
Project Comparative Financial Statement This report is identical to Comparative Financial Statement, but projects are displayed instead of a chart of accounts. The report is available if the customer has projects. It shows the list of projects and can expand or collapse down to the account level.

You can define the maximum default number of Projects that show in the report and configure the Account Dimension for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Project Comparative Financial Statement.

The View options in Calendar can be changed to Year-To-Date Calendar and Life-To-Date Calendar.

You can disable:

  • Show Analysis
  • Show Variance
  • Show Variance%

These are enabled by default.

Use Add Analysis to add more previous periods in the report, if applicable. You can use Manage Analysis to adjust columns or periods and select Prior Period: Period -1, Periods -2, Periods -3, and Same period prior year: Year -1, Years -2, Years -3 as an enhancement.

Projects – Remaining Budget Evaluation Accounts are displayed by project.

You can define the maximum default number of projects to show in the report and configure the Account Dimension for a particular Reporting Basis. Go to Dashboards > GL Financial Reporting > Report > Configuration. Select Project - Remaining Budget Evaluation.

The View options in Calendar can be changed to Year-To-Date Calendar and Life-To-Date Calendar.

In the column, the actual, encumbrances, commitments, total obligations, budget, variance percentage, remaining/remaining percentage, and over/under indicator are displayed.

  • You can change the column data for Budget Scenario. In Report Menu Options, select Column > Select Budget.
  • You can change the column title between Remaining or Remaining Percentage. In Report Menu Options, select Column > Select Show Columns.
Note: Show Remaining is enabled by default
Remaining Budget Evaluation Shows the Balance sheet and income statement, including the data for a period, such as month, quarter, or year.

The report shows actual, encumbrances, commitments, total obligations, budget, variance percentage, remaining/remaining percentage, and over/under indicator.

  • You can change the column data for Budget Scenario. In Report Menu Options, select Column > Select Budget.
  • You can change the column title to Remaining or Remaining Percentage. In Report Menu Options , select Column > Show Columns.
    Note: The default is Show Remaining.

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 shows 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 Shows revenues, expenditures, and the change in net position for government activities at a 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 available to users with the PublicSectorReport_ST role.
Governmental Funds – Balance Sheet Shows Assets, Liabilities, and Equities for all funds in each Government sector.

Select individual funds to show in the report. In Report Menu Options, select Column > Select Funds.

Note: The report is only available to users with the PublicSectorReport_ST role.
Governmental Funds – Statement of Revenues, Expenditures, and Changes in Fund Balances Shows revenues, expenditures, and changes in fund balances.

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

Note: The report is only available to users with the PublicSectorReport_ST role.
Budget and Actual – Statement of Revenues, Expenditures, and Changes in Fund Balances Shows revenues and expenses and change in net position at a point in time. You can view and compare income statement items for the selected period.

Use Manage Analysis to change the columns or add more Budget in the report. In Report Menu Options, select Column > Manage Analysis.

Note: The report is only available to users with PublicSectorReport_ST role.
Proprietary Funds - Statement of Net Position Shows 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 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

Shows 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 Reporting Basis. Go to Dashboards > GL Financial Reporting > Report Configuration. Select Proprietary funds.

Note: The report is only available to users with the PublicSectorReport_ST role.
Fiduciary Funds – Statement of Net Position Use to assess 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 available 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 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 available 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 available 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 available to users with the PublicSectorReport_ST role.