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 and select . Optionally, you can access and select 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 and select . Optionally, you can access and select 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 option when you select Balance Sheet accounts or Income Statement accounts.You have alternative chart options where you can switch views:
Click a chart account in the report to reflect monthly values on the chart. Use the 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:
In this report, you can disable:
These are enabled by default. Use the option to add more previous periods in the report, if applicable.Use 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 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 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:
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 Consolidated Financial Statement. . SelectNote: 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 , select .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 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 . 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 , select . |
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 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:
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 button to switch formats:
In this report, you can hide data based on your preference:
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:
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 Statement of Capital Expenditures. . Select |
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.
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.
You can switch calendar hierarchy to:
|
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 . Select .The View options in Calendar can be changed to Year-To-Date Calendar and Life-To-Date Calendar. You can disable:
These are enabled by default. Use to add more previous periods in the report, if applicable. You can use 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 . Select .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.
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 switch calendar hierarchy to:
|
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.
|