17.2.1.2 Dashboard: Threshold Breach

Table 17-4 Threshold Breach Summary information

Report Name Threshold Breach Summary
Report Level Filters Not Applicable
Report Description

This report displays the threshold parameters of the selected Run Execution ID. The following parameters are reported:

Global Threshold: Indicates the point of reconciliation difference greater than which execution process may either stop or continue at the time of execution. Global Threshold is compared with cumulative percentage difference across all reconciliation definitions getting executed in a Run.

  • Execution on Threshold Breach: Depending on your selection in the Run Execution Parameters window, Continue or Stop is displayed here.
  • Auto Approval: The value selected in the Run Execution Parameter window: Yes or No.
  • Global Threshold: Indicates if the Global Threshold Level is breached or not breached.

The following parameters are reported:

  • Map Name: The name of the reconciliation as 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.
  • Number of Observations: The number of times the same map and version is executed.
  • Number of Breaches: The number of breaches reported based on the threshold value specified in the Reconciliation Management window.
Drill-through On Map Name
Drill-through Description

Report Name: Threshold Breach Detailed Report

Navigation Path: Click Map Name in the Threshold Breach Summary to view the detailed report.

Map Level Filters: Map Name, Map Version

This report provides a detailed view of the threshold value breaches; 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 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.
  • Source Balance: The account balance at the source GL entity.
  • Target Balance: The account balance at the target GL entity (for Ledger to Ledger reconciliation) or Product Processor.
  • Reconciliation Difference: The net reconciliation difference amount.
  • Threshold Breach Type: Indicated as a negative or positive breach based on the positive or negative reconciliation differences.
  • Threshold Value: The value per the breach type.
  • Threshold Currency: The Threshold currency is displayed if the Threshold value is in Absolute format.
  • Threshold Breached by: The value or percentage by which the threshold value is breached based on the reconciliation difference.

Table 17-5 Global Threshold Breach Summary information

Report Name Global Threshold Breach Summary
Report Level Filters Not Applicable
Report Description

This report displays the global threshold parameters of the selected Run Execution ID. The following parameters are reported:

  • Global Threshold Percentage: Indicates the point at which the execution process may stop or continue at the time of execution if the reconciliation difference surpasses the defined Global Threshold level. Global Threshold is compared with the cumulative percentage difference across all reconciliation definitions getting executed in a Run.
  • Difference Percentage: The absolute percentage difference.
  • Breach Percentage: The percentage by which the Global Threshold is breached based on the reconciliation difference.
Drill-through On Not Applicable

Table 17-6 Threshold Definition information

Report Name Threshold Definition
Report Level Filters

GL Map Name: Select the name of the specific GL entity map name.

Map Version: The version number of the selected map name. It indicates the number of times the reconciliation is edited at the reconciliation definition stage.

Report Description

This report displays the following parameters:

  • Target Entity: The name of the Product Processor is displayed here in case of a GL to PP reconciliation, or the name of the Target GL entity.
  • Target Balance Column: The specific column in the Product Processor (for GL-PP reconciliation) or target GL entity (for GL-GL reconciliation) is displayed here.
  • The threshold In: The type of threshold: Absolute or Percentage.
  • Threshold Currency: The currency in which the threshold value is defined. It is not displayed when Percentage is selected.
  • Positive Correction Threshold: The positive correction threshold value defined in the Reconciliation Management window.
  • Negative Correction Threshold: The negative correction threshold value defined in the Reconciliation Management window.
Drill-through On Not Applicable