Account Reconciliation Manager Predefined Reports
Note:
To avoid report errors, you must enter the required parameters.
Table 1-2 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. |
|
Compliance Analysis |
Displays key compliance metrics by user. |
|
Invalid Profiles |
Displays invalid profiles and the reasons the profile is invalid. Because a profile may be invalid for multiple reasons, the same profile may be listed more than one time in the report. |
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 Profiles |
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. |
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:
|
|
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. |