17.2.1.1 Dashboard: Home

This section provides information about the Dashboard Home page used in the Reconciliation Framework application.

Table 17-1 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:

  • Map Name: The name of the reconciliation as defined in the Reconciliation Management window.
  • Map-Version Number: The version number of the defined reconciliation. This indicates the number of times the reconciliation is edited at the reconciliation definition stage.
  • Legal Entity: The Legal Entity is defined for this particular map and the version number is displayed here.
  • Consolidation Type: The consolidation types 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 17-2 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.

Reconciliation Difference Value Display: If the Reconciliation Difference is to be displayed in actual format, select Actual, else select Percentage.

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.

Drill-through On GL Name
Drill-through Report Name: Reconciliation Difference Detailed Report
Description

Navigation Path: Click GL Name in the Reconciliation Difference Report to view the detailed report. This detailed report is displayed for the particular Map Name and Version number selected in the Report Level Filters.

This report provides a detailed view of the identified reconciliation differences, and the following parameters are reported:

  • GL Name: The name of the specific GL entity code of the selected Map Name.
  • Legal Entity: The Legal Entity as defined for the particular map and version number.
  • Accounting Standard Code: The Accounting Standard Code defined in the reconciliation.
  • Currency: The currency in which the actual reconciliation difference is displayed.
  • Other optional dimensions: Values against respective optional dimensions (if any) are reported here.
  • 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.
  • Reconciliation Difference: The net reconciliation difference.

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 17-3 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.
  • Reconciliation Difference Value Display: If the Reconciliation Difference is to be displayed in Actual format select Actual, else select Percentage.
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 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 particular 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.
Drill-through On GL Name
Drill-through

Report Name: Reconciliation Adjustment Detailed Report

Navigation Path: Click GL Name in the Reconciliation Adjustment Report to view the detailed report. This report is displayed for the particular Map Name and Version number selected in the Report Level Filters.

This report provides a detailed view of the adjustment entries passed. The following parameters are reported:

  • GL Name: The name of the specific GL entity code of the selected Map Name.
  • Legal Entity: The Legal Entity as defined for this particular map and version number.
  • Currency: The currency in which the actual reconciliation difference is displayed.
  • Accounting Standard Code: The Accounting Standard Code defined in the reconciliation.
  • Other optional dimensions: Values against respective optional dimensions (if any) are reported here.
  • Exposure Amount: The Adjustment Entry amount.
  • Authorization Status: If the Adjustment Entry is approved, pending to be submitted, or submitted but pending to be approved, the relevant status is displayed here.
  • Product Processor: The PP to which the Adjustment Entry is passed.
  • Product Processor Balance Column: The specific column in the PP to which the Adjustment Entry is passed.

Note:

The Adjustment Report displays the entry of Root Node for Map level executions. You can ignore this particular entry.