Comparisons

The Comparisons analytic can be used to compare two or more sets of information to validate that the information is the same or different depending on your choices. For instance, you can use this test to confirm that the user responsible for inputting transaction details differs from the user authorizing those transactions. This test can be instrumental in validating consistency between receiving reports and corresponding invoices.

This analytic test can be used to identify:

  • Possible attempts to manipulate the financial statements

  • Financial reporting areas that have lower accuracy or precision

  • Systemic issues in how a department processes transactions

  • Improperly configured system settings which may need improvement and further evaluation

  • Weak internal controls

  • Weak monitoring and detecting activities

  • Poor training

  • A risk of material misstatement due to fraud

Fields used for analysis

The following fields are required for this analysis:

  • Reference field(s) - Unique field(s) that are used to create a unique transaction ID such as the Entry ID field for the general ledger dataset. These columns are not part of the result but are used to identify the transactions that are part of the result. This field is already defined in the test and cannot be modified.

  • Core fields - Two or more fields of any type need to be tagged for the comparison. The fields tagged should be of the same type.

Parameters

The following parameter must be set to run this test:

Comparison type - Select how the data in the selected fields should compare to each other. Your options are:

  • Equal

  • Not equal

  • Greater than

  • Greater than or equal

  • Less than

  • Less than or equal

Test configurations

Note: The configurations available to you vary depending on the product you’re using.

The following configurations are available for this test:

  • Character field comparison - Compares two character fields and lists them based on whether they are equal or not equal.

  • Date field comparison - Compares two date fields and lists them based on whether they are equal or not equal.

  • Numeric field comparison - Compares two numeric fields and lists them based on whether they are equal or not equal.

Technical Specifications

When you run the Comparisons analytic test, the following steps are performed to run the test:

  1. If necessary, place any filters on the data in order that a subset is used for the analysis. If no filter is placed the analysis will be run on the entire data file.

    Note: Filters are not currently available and will be included in a later release.

  2. Validate that the necessary reference fields have been selected. If fields have not been selected, then create a unique reference field. This is only valid if specific fields have been selected. If all the columns are available this is not necessary.

  3. Validate that two or more fields have been selected and that all the fields selected are of the same type.

  4. Obtain the type of comparison from the parameters entered. The options are:

    • Equal (==)

    • Not equal (!=)

    • Greater than or equal (>=)

    • Greater than (>)

    • Less than or equal (<=)

    • Less than (<)

  5. Perform the core analytic comparing the fields selected with the comparison type.

    • When comparing two fields, extract any records where the comparison returns true.

    • When comparing three or more fields, extract any records where the comparison between at least two of the fields returns true.

  6. Extract the result fields selected by the user. The default is to extract all fields.

  7. Optionally, the filters in step 1 can be placed on the data after the core analytic is complete instead of prior to completion.

    Note: Filters are not currently available and will be included in a later release.