Generating Predefined Reports in Reconciliation Compliance
Predefined reports (listed below) are available to Service Administrators for most of your reporting needs and are a useful starting point for report creation. These reports are available whether you are using the sample application or create a new application. You can review the query used to create the report and see the parameters.
There are also a few additional reports provided within the sample application that are listed in the following section.
Additionally, you can create custom reports. See Generating Custom Reports
Note:
To avoid report errors, you must enter the required parameters.Table 19-1 Reconciliation Manager - Report Required Parameters
Report | Description | Required Parameters |
---|---|---|
Balance by Account Type |
Displays key reconciliation metrics grouped by account type. |
|
Balance by Organizational Unit |
Displays key reconciliation metrics grouped by organizational unit. |
|
Reconciliation Compliance Analysis |
Displays key compliance metrics by user. |
|
Invalid Profiles |
Displays invalid profiles and the reasons the profile is invalid. |
N/A |
Late Reconciliations |
Displays reconciliations that are currently late for either the preparer role or for any reviewer level role. |
Period––Data is displayed only for the selected period. |
Missing Reconciliations |
Displays profiles that should exist in the period but do not exist (either because they were not copied to the period, or because they were copied and deleted). "Should Exist" is determined based on the frequency of the profile matching the frequency of the period. Report excludes inactive profiles. |
Period––Data is displayed only for the selected period. |
Open Reconciliations Aging Analysis | Analyzes the lateness of reconciliations that are still open (status not equal to closed). Only reconciliations that are not closed are included in the report, and lateness is analyzed using the reconciliation End Date (the due date associated with the last workflow role). Any reconciliation that is open, and the End Date is before the report run date, is included.
The report is comprised of the following sections:
|
|
Reconciliation Performance Analysis by Organizational Unit |
Displays key compliance metrics by Organizational unit. A reconciliation is counted once for each workflow role assigned to the reconciliation, and the most recent workflow action "wins". For example, if a reconciliation is prepared twice (because it was rejected after the first certification), then the second certification is included in the metrics. |
Period––Data is displayed only for the selected period. |
Profile Audit Trial |
Displays the changes made to profiles during a user selected date range. |
|
Reconciliation Audit Trail |
Displays the changes made to reconciliations during a user selected date range. |
|
Reconciliation Result |
Presents an analysis of the magnitude of the Source System Balance in three categories:
|
|
Reconciliation Trend Analysis |
Displays a line chart reflecting the value of a selected reconciliation balance attribute over a range of twelve periods. |
|
Rejected Reconciliation |
Displays the list of reconciliations that were rejected by any reviewer level role. |
Period––Determines which period’s data is used. |
Transaction Aging Analysis |
Displays a pie chart reflecting the count and value of selected reconciliation transactions, grouped by aging bucket. |
|
Users with Late Reconciliations |
Displays the count of reconciliations that are late for either the preparer role or for any reviewer level role, grouped by user name. |
Period––Determines which period’s data is used. |
Currency Rates |
Displays the currency rates defined in Account Reconciliation. |
|
To generate reports:
- From Home, select Reports.
- Select the report you want to generate. You can use the quick Search option to find a report under a selected group.
- For Output Format, select one of the following:
- XLSX - not supported for graphs.
- HTML - not supported for graphs and charts.
-
CSV - does not use template and is better at faster data retrieval.
Note:
For reports that contain more than 10,000 records, it is recommended to use the CSV format. -
CSV (Formatted) - is best suited for a simple data table with formatted data and does not support images, graphics, or styling in the template.
Note:
The CSV (Formatted) format takes additional time to generate the report to honor template formatting when compared to the CSV format. Therefore, you can select CSV to generate the data quickly or CSV (Formatted) to generate formatted template based data.
- Click Generate.
- For each parameter, select the value.
Note:
For more information on parameters, see Generate Report for Account Reconciliation in REST API for Enterprise Performance Management Cloud - Click Generate.
Note:
- You can use the Back button to preserve the parameter values that you have selected and regenerate the report.
- You can use the Reset button to clear the parameter values that you have selected and regenerate the report.
- Select Open or Save File to save the ZIP file.
The report generation process uses a backend job framework that runs report jobs in the background. If the report has an error, for example, if the size is greater than the recommended size, you see a message stating the error in the Generate Report dialog before the report is generated. For reports with very large number of records, it is recommended to use filtering to break the report down to lesser records.
Additional Predefined Reports Provided in Sample Application
In the Sample Application, there are three categories (or report groups) containing predefined reports:
- Compliance Reporting
- Reconciliation Manager (these are the same predefined reports as outlined above)
- Variance Analysis
Table 19-2 Compliance Reporting Report Group - Required Parameters
Report | Required Parameters |
---|---|
Large Unexplained Difference |
Period––Determines which period’s data is used. |
Aging Violations |
Period––Determines which period’s data is used. |
IC Unbalanced |
Period––Determines which period’s data is used. |
Warnings |
Period––Determines which period’s data is used. |
Table 19-3 Variance Analysis Report Group - Required Parameters
Report | Required Parameters |
---|---|
Variance Analysis Detailed |
Period––Determines which period’s data is used. |
Variance Analysis Summary |
Period––Determines which period’s data is used. |