20.1.1.1.2 Dashboard: Threshold Breach

Table 20-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 20-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.
  • Global Threshold Breached Status: It displays the Breached or Not Breached status.
  • Global Threshold Condition:This field is only applicable in case of Global Threshold Percentage and Global Threshold Absolute type are selected, else NA must be selected.
    • OR: If either Global Threshold Absolute or Global Threshold Percentage is Breached, then the Final Status will be Breached.
    • AND: If both Global Threshold Absolute and Global Threshold Percentage are Breached, then the Final Status will be Breached.
    • NA: If only Global Threshold Percentage or if only Global Threshold Absolute is selected
    • If both are Not Breached, then the Final Status will be Not Breached.
  • Global Threshold Option
    • Percentage: This option, provides Global Threshold Percentage information
    • Absolute: This option, provide Global Threshold Absolute and Global Threshold Currency information.
    • Percentage& Absolute: This option, user must select a Global Threshold Condition (AND/OR), and provide values for Global Threshold Percentage, Global Threshold Currency, and Global Threshold Absolute.
  • Global Threshold Absolute: The global threshold absolute value which is a fixed monetary limit applied across all accounts to flag reconciliation differences that exceed that amount, regardless of percentage.
Drill-through On Not Applicable

Table 20-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