5.10.1 Dashboard Home Page

This section provides details about the Home Dashboard in the Reconciliation Framework application. It explains the available options, filters, and functionalities that help users generate and analyze reconciliation reports efficiently.

Table 5-5 Reconciliation Execution Summary information

Report Name	Reconciliation Execution Summary
Report Level Filters	Not Applicable
Report Description	This report displays the following parameters of the selected Run Execution ID: GL Map ID: The map identification number of the reconciliation defined in the Reconciliation Management window. Map-Version Number: The version number of the defined reconciliation. It indicates the number of times the reconciliation is edited at the reconciliation definition stage. Legal Entity: The Legal Entity is defined for this map and the version number is displayed here. Consolidation Type: The consolidation types of Solo, Consolidation, or Aggregate is displayed here. Reconciliation Type: The reconciliation types: Ledger to Ledger Reconciliation, General Ledger to Product Processor (Manual Reconciliation), or General Ledger to Product Processor (Auto Reconciliation) are displayed here. Reconciliation Level: Displays the level at which the reconciliation is performed: GL Level or Map Level. Adjustment Allocation: Adjustment Allocation is displayed here as Yes or No as defined in the Reconciliation Management window. Balance Type: The Reconciliation period as defined in the Reconciliation Management window is displayed here. Reconciliation Dimensions: The Mandatory Dimensions and Optional Reconciliation Dimensions (if any) are displayed here.
Drill-through On	Not Applicable

Table 5-6 Reconciliation Difference Report information

Report Name	Reconciliation Difference Report
Report Level Filters	Map Name: The name of the reconciliation as defined in the Reconciliation Management window. Map Version: The version number of the defined reconciliation. It indicates the number of times the reconciliation is edited at the reconciliation definition stage.
Report Description	This report displays the identified Reconciliation Differences for a particular Map. The following parameters are displayed: GL Name: The name of the specific GL entity code of the selected Map name. Currency: The currency in which the actual reconciliation difference. Source Balance: The account balance at the source GL entity level. Target Balance: The account balance at the target GL entity level (for Ledger to Ledger reconciliation) or Product Processor. Positive Reconciliation Difference: Any positive reconciliation difference based on the source entity balance. Negative Reconciliation Difference: Any negative reconciliation difference based on the target entity balance. Note: If the percentage is selected in the Reconciliation Difference Value Display field, the positive reconciliation difference and negative reconciliation difference are compared, and the relevant percentage value is populated. For example: If the Actual Positive Reconciliation Difference is 5000 and the Actual Negative Reconciliation Difference is 0, then the percentage is displayed as 100 for positive reconciliation difference. Absolute Reconciliation Difference: This is calculated as the total difference by ignoring the signs between the negative and positive reconciliation differences. For example: if Positive Reconciliation Difference is 19,500 and the Negative Reconciliation Difference is 23,000, then the absolute difference is 42,500. Net Reconciliation Difference: The net difference between negative and positive reconciliation differences. For example: if Positive Reconciliation Difference is 19,500 and the Negative Reconciliation Difference is 23,000, then the net difference is 3,500. Percentage Difference: The percentage difference between Source Balance and Target Balance attributes. The value is derived by using the formula ((Source Balance - Target Balance) * 100)/Source Balance.

Note:

On the Dashboard Home page, the reconciliation sections such as Reconciliation Difference Report, and Reconciliation Adjustment Report, the GL related columns GL Code, and GL Account Name will be blank/MSG for Map level reconciliation.

Table 5-7 Reconciliation Adjustment Report information

Report Name	Reconciliation Adjustment Report
Report Level Filters	Map Name: The name of the reconciliation as defined in the Reconciliation Management window. Map Version: The version number of the defined reconciliation. It indicates the number of times the reconciliation is edited at the reconciliation definition stage.
Report Description	This report is displayed if Adjustment Allocation is selected as Yes while defining reconciliation. This report displays the adjustment amount pass. The following parameters are displayed: GL Account Name: The name of the specific GL entity code of the selected Map Name. Currency: The currency in which the Adjustment Entry is processed. Reconciliation Difference: The net reconciliation difference. Legal Entity: The Legal Entity as defined for this map and version number. Approved Adjustment Amount: The adjustment amount authorized by the approver. Pending Adjustment Amount: The adjustment amount pending to be submitted from the Adjustment Entry window. Submitted Adjustment Amount: The adjustment amount submitted from the Adjustment Entry window, however waiting to be approved by the authorizer. Rejected Adjustment Amount: The adjustment amount rejected by the authorizer from the Adjustment Entry Approval window.