Keywords

The Keywords analytic test is designed to scan one or more fields for specific keywords. These keywords can be input manually, chosen from a predefined list of keywords or derived from a list of terms generated from the selected fields.

This test also includes a parameter that allows you to choose between exact matches and partial matches when searching for keywords.

This analytic test can be used to identify:

  • Transactions that contain significant estimates

  • Fictitious transactions

  • Transactions that are complex or unusual in nature

  • Intercompany transaction

  • Transactions used to reconcile subledgers. For example, you can search for the keywords “reconcile subledger” or "balance subledger.”

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.

  • Keyword field(s) - The character fields which are searched for the selected keywords.

Parameters

The following parameters must be set to run this test:

  • Keyword list - A list of keywords saved as a text file.

  • Exact match - Select whether the values have to match the keyword exactly. If you do not select to identify only exact matches, partial matches are also identified.

  • Ignore case - Select whether or not the keyword matches are case sensitive

  • Create match word column - Create an additional column that will list the words for which matches were found for this configuration.

Test configurations

The only configuration available for this test is Keyword search.

Technical specifications

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

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

  2. Validate that one or more character fields have been selected for the keyword search.

  3. Obtain the list of words, depending on the interface it could come from several sources or a mix of one or more sources:

    • A preprogrammed list of keywords.

    • A list uploaded from the user of the keywords.

    • The user entering the keywords directly into the interface.

    • A combination of one or more of the above.

  4. Allow the user to add or delete keywords from the list especially if it comes from 3a or 3b.

  5. Obtain if the match is case-sensitive or not.

  6. Depending on the selection of exact or partial matches perform the search of the keywords from step 3.

  7. If a keyword match word column has been selected to add, only add one column even if there have been multiple columns selected to search in.