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 (ADB), including ending balances and ADB for a selected period (month, quarter, or year).

By default, totals are positioned at the bottom. You can move them to the top by enabling Display Totals on Top.

To run the report, enable Average Daily Balance for the selected Calendar Period. You can select any date within the current month and navigate the ADB Balance Sheet by Dimension using the View option to define or select Dimensions for the column section. Modify Dimensions in the Select Dimensions... toolbar, which serves as the report configuration.

Note: Display Totals on Top is not applicable in the ADB Balance Sheet by Dimension view.

Reload DPTOT (Daily Period Total): navigate to Infor Financials & Supply Management > Administration Console > Analytic Cube and select Daily Period Total. Alternatively, go to Application Administrator > Financials > Shared Processes > Update Analytic Cubeand refresh ADB Total Cube.

Drill-back functionality in Infor OS Portal is disabled for all columns.

Access is restricted to users with the BankingSectorReport_ST role.

ADB Trial Balance The report generates a trial balance with average daily balances, including opening balances, period movements, closing balances, and ADB for a selected period such as month, quarter, or year.

To run the report, enable Average Daily Balance for the selected Calendar Period. You can select any date within the current month to generate an average daily balance for each day.

Note: 

Reload DPTOT (Daily Period Total): navigate to Infor Financials & Supply Management > Administration Console > Analytic Cube and select Daily Period Total. Optionally, go to Application Administrator > Financials > Shared Processes > Update Analytic Cube and refresh ADB Total Cube.

Drill-back functionality in Infor OS Portal is disabled for all columns.

Access is restricted to users with the BankingSectorReport_ST role.

Comparative Financial Statement

The report can be run for the Balance Sheet or Income Statement to compare results by year, quarter, or month. You can select Year-to-Date (YTD) Calendar or Standard Calendar in the context selection.

The key features of the report are:

  • View Options - select Balance Sheet or Income Statement accounts.
  • Chart Options
    • Default - displays periodical views.
    • Additional Chart - displays YTD values.
    • Click a chart account to show monthly values.
  • Context Parameters - displays all dimensions configured in Financial Reporting Home.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

You can disable options such as Show Analysis, Show Variance, and Show Variance %, which are enabled by default.

Enable Add Analysis to include previous periods in the report. Use Manage Analysis to adjust columns or select prior periods such as Period -1, -2, -3 or past years such as Year -1, -2, -3.

Consolidated Financial Statement

The report can be run for the Balance Sheet or Income Statement to compare results across selected Accounting Entities. You can choose Year-to-Date (YTD) Calendar, or Standard Calendar in the context selection.

The key features of the report are:

View Options - select Balance Sheet or Income Statement accounts.

Chart Display - a chart is shown when viewing Income Statement accounts.

Context Parameters - displays all dimensions configured in Financial Reporting Home.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

Customization & Configuration:

Columns & Accounts - define the maximum number of columns and configure Income Statement accounts.

Custom Account Names - assign names for accounts under a specific Reporting Basis. Configuration Path is Dashboards > GL Financial Reporting > Report Configuration > Consolidated Financial Statement.

Note: Drillback is disabled in Infor OS Portal for columns with Sum of Others and Σ (Calculated).
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.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

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 displays revenues and expenditures for each department, comparing actuals and budgets.

You can define the default number of departments and configure them for a specific Reporting Basis. Go Dashboards > GL Financial Reporting > Report Configuration > Department (Cost Center) Profit and Loss.

Other key features are:

  • Column Display
    • Actual vs. Previous Period - YTD Level, Variance, Variance %
    • Budget Comparison - Budget Scenario, Actual Budget Variance, Actual Budget Variance %, Remaining Budget, and Remaining Budget %.
  • Customization - adjust Budget Scenario in Report Menu Options > Columns > Select Budget.
Income Statement – Budget versus Actual The report enables viewing and comparing income statement items for the selected period in periodical and YTD levels, including actual vs. budget and current vs. previous periods.

Display Totals on Top - totals are positioned in the bottom by default. Move them to the top by enabling this feature.

The key features of the report are:

  • Comparison Options
    • Periodic - compare against Period -1, Periods -2, Periods -3.
    • YTD - compare against Year -1, Years -2, Years -3.
    • If no data is available, the column label displays "! No Data Found for Selected Period!".
  • Chart Representation
    • Displays a visual representation of the report.
    • Click a chart account to show values on the chart.
  • Context Parameters - shows all dimensions configured in Financial Reporting Home.
Summary Trial Balance The report displays trial balance items as opening balance, debit/credit outstanding balance, and closing balance. It now includes the parent of each account, and you can modify the report to display posting-level details by enabling Show Posting Accounts.

The View option includes:

  • Summary (default), which shows YTD values for the selected period.
  • Periodical, which displays periodical values for all available months
  • YTD Analysis, which presents YTD values for all available months, with the last period as the closing balance.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

The additional features are:

  • Chart Representation click a chart account to display monthly values.
  • Context Parameters - displays all dimensions from Financial Reporting Home.
  • Filtering - customize values based on the data you want to see.
Trial Balance – Summary Totals

The report is similar to Summary Trial Balance, but the Chart Account column follows the format of the Consolidated Financial Statement - Balance Sheet. Unlike the Summary Trial Balance report, the report does not include a View option or a Show Posting Accounts option. Posting Accounts can only be viewed in the Summary Trial Balance report.

Additionally, you can position totals at the top, since they are positioned at the bottom by default.

Statement of Capital Expenditures

The report displays Beginning and Ending Balances for Property, Plant, and Equipment (PPE) and Accumulated Depreciation, which are used to calculate the Net Increase/Decrease in PPE and Depreciation. These values are summed to determine Capital Expenditure and are shown for both the current and previous years. Although typically a year-end report, you can the report anytime during the year.

The report includes a chart representation where you can configure accounts for the Statement of Capital Expenditures and assign names for specific Reporting Bases. To configure, go to: Dashboards > GL Financial Reporting > Report Configuration > Statement of Capital Expenditures .

Finance Structure and Account Analysis

This report allows flexibility in customizing reports by rearranging dimensions into rows or columns. Use the Select Dimensions option to configure which dimensions appear in rows and columns.

You can disable the Display Totals on Top option, which is enabled by default.

The report also offers a choice of calendar hierarchy, including Standard Calendar, Year-to-Date Calendar (Default), and Life-to-Date Calendar, accessible via the View option.

Revenue Trends (with Statistics and Ratios)

This report provides a clear and detailed overview of revenue trends over time, incorporating statistical data and ratio calculations. Revenue and statistical data are organized by account number in rows, while columns represent the year and month.

You can choose between Standard Calendar and Year-to-Date Calendar through the View option. Additionally, you can configure within the report by selecting the Select Accounts... menu option.

Operating Expenses and Revenue by Dimension

This report offers a comprehensive financial overview, allowing for efficient analysis of revenue and expenses across departments. You must configure the report settings before accessing it. You can also modify settings within the report by selecting Select Dimensions to update the Dimensions and Chart Accounts.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

The report also allows switching between Operating Revenue by Department and Operating Expenses by Department using the View option.

Salary and Benefits by Dimension

This report offers a detailed overview of salary and benefit expenditures across departments, allowing you to analyze salary and wage accounts, associated benefits, and Full-Time Equivalent (FTE) data, along with total calculations for each department. You must configure the report settings before accessing it. You must also configure the report settings before accessing it. To update the Dimensions and Chart Account, modify setting within the report by selecting Select Dimensions.

The report allows to choose between Standard Calendar and Year-to-Date Calendar through the View option.

Project Analysis

The report displays the Organization Balance Sheet and Income Statement accounts, including all account types. Data is shown over a selected period, such as a month, quarter, or year. In the column display, the report includes actuals, budgets, remaining percentage, variance, and an over/under indicator.

To modify the Scenario columns, go to Column report option and select Actuals or Budgets.

To switch the column display between Variance or Variance Percentage, go to Report Menu Options > Column > Show Columns Show Variance is enabled by default.

Display Totals on Top - totals are positioned in the bottom by default. You can move the totals to the top by enabling this feature.

The previous period column includes a line chart displaying the past 12 actual values based on the selected start period. Click a row/period value to open a chart on the right side of the report.

To display project period values, select the Show Data checkbox The values include actual, budget, variance, and variance percentage for the chosen number of periods.

To show either percentage or value, adjust the Variance Chart-

You can modify the number of displayed periods. For example, 1-12 periods.

You can switch the calendar hierarchy to Year-to-Date Calendar and Life-to-Date Calendar.

Project Comparative Financial Statement

This report is identical to the Comparative Financial Statement but displays projects instead of a chart of accounts. The report is available for customers with projects and shows a list that can expand or collapse down to the account level.

To define the maximum number of projects displayed in the rows report menu options and configure the account dimension for a specific reporting basis, use the Select Dimensions option. You can switch the Calendar View options fromYear-To-Date Calendar or Life-To-Date Calendar.

You can disable options such as Show Analysis, Show Variance, and Show Variance %, which are enabled by default. Use the Add Analysis feature to include previous periods in the report. Use Manage Analysis to adjust columns or select prior periods such as Period -1, -2, and -3 or past years such as Year -1, -2, and -3).

Projects – Remaining Budget Evaluation

This report is the Project version of the Remaining Budget Evaluation report. The Projects report lists projects from the projects structure rather than accounts.

You can define the maximum number of projects displayed in the Rows report menu options and configure the Account Dimension for a specific Reporting Basis using the Select Dimensions option. Switch from Year-To-Date Calendar to Life-To-Date Calendar by using the Calendar View options.

Modify the Budget Scenario by selecting Report Menu Options > Column > Select Budget. To change the column title between Remaining and Remaining Percentage, go to Report Menu Options > Column > Select Show Columns.

Note: The Show Remaining option is enabled by default.
Projects Contracts - Revenue and Expense Comparison

This report displays Project Contracts per Account with an option to compare by Funding Source or Project. The report is available if Project Contracts have been created on the your end.

Display Totals on Top - totals are positioned in the bottom by default. Users can move them to the top by enabling this feature.

You can choose between Year-to-Date Calendar and Life-to-Date Calendar through the View option. Additionally, you can modify dimension and chart account within the report by selecting the Report Configuration menu option.

Remaining Budget Evaluation

The report displays the Balance Sheet and Income Statement, including data for a selected period such as a month, quarter, or year. The report provides details on actuals, encumbrances, commitments, total obligations, budget, variance percentage, remaining/remaining percentage, and the over/under indicator.

Display Totals on Top - totals are positioned in the bottom by default. You can move them to the top by enabling this feature.

To modify the Budget Scenario, navigate to Report Menu Options > Column > Select Budget. Switch the column title between Remaining and Remaining Percentage under Report Menu Options > Column > Show Columns.
Note: The default setting is Show Remaining.

Adjust the calendar hierarchy from Year-To-Date Calendar to Life-To-Date Calendar based on your preferences.

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.