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 option to define or select Dimensions for the column section. Modify Dimensions in the 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 ADB Total Cube. and select Daily Period Total. Alternatively, go to and refreshDrill-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 Daily Period Total. Optionally, go to and refresh ADB Total Cube. and selectDrill-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:
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 .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 .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 . 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 .Other key features are:
|
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:
|
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 The View option includes:
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:
|
.
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: . |
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 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 and 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 Budgets. columns, go to Column report option and select orTo switch the column display between Variance or Variance Percentage, go to 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 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 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 report. The 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 Remaining and Remaining Percentage, go to . . To change the column title betweenNote: 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 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 . Switch the column title between Remaining and Remaining
Percentage under .
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 Statement of Net Position. . SelectNote: 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 Statement of Activities. . SelectNote: 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 , select .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 Governmental Statement of Revenues. . SelectNote: 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 to change the columns or add more Budget in the report. In , select .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 , select .You can configure the fund structure, Enterprise Fund, and Internal Service fund for a Reporting Basis. Go to Proprietary funds. . SelectNote: 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 , select .You can configure the fund structure, Enterprise Fund, and Internal Service fund for a Reporting Basis. Go to Proprietary funds. . SelectNote: 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 , select .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 , select .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 Reconciliation Balance
Sheet. . Select 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 Reconciliation Statement of Revenues. . SelectNote: The report is only available
to users with the PublicSectorReport_ST role.
|