The 21st Minute


New & Updated Apps Available in the IDEA Marketplace

Risk-Based Payroll, Looping Search and Word List Maker

Risk Based Payroll Testing Marketplace App LogoSuite of tests designed to analyze employee and payroll data to rank potential violators by risk level in a scorecard format.

Quickly identify employees who are potentially violating payroll processes or controls with this suite of 14 tests that can be run in various combinations, including the ability drill down for greater detail. This complete suite contains a dialog box allowing users to select which tests to run, input additional information needed for specific parameters and control how scores are weighted.

How it Works
To collect an overall risk rating by employee, the user sets the risk level to high, medium or low for each test. Employees who fail the most individual tests are sorted in descending order from highest to lowest. The final scorecard database includes action links to drill down into the data to see more details. The App automatically creates a subfolder to store the database with the final results, which is flagged to make it easier to find.

14 tests included in this App:

  • Different Employee Same Bank Information
  • Missing Bank Information
  • Employees Over Mandatory Retirement
  • Duplicate Tax ID Information
  • Missing or Invalid Tax Information
  • Employees Without PTO
  • Employees Without Benefits Deduction
  • Low Federal / National Tax Withholding
  • Payments After Termination
  • Manual Payroll Checks
  • High Overtime Pay
  • Unusual Net Pay
  • Unusual Hourly Rate Changes
  • Unusual Salary Base Pay Changes

You will need to tag individual fields in order to run the tests. This requires access to both HR Master Data and Payroll Transaction data. If these fields are not available in one database, a database can be created by performing a join of HR Master Data and Payroll Transaction Data in IDEA using common fields, such as employee ID. Instructions for tagging databases are provided in the User Guide, provided with the suite.

Buy Now in the IDEA Marketplace

Looping Search Marketplace App LogoSearch one or multiple fields using a list of key words or wildcard fragments to quickly identify fraud.

Need to search large databases for specific words or phrases, but don’t have time to perform individual searches? The Looping Search App conducts multiple searches at a time across single or multiple fields using keywords or wildcard fragments contained in a second file.

Results are ordered from highest to lowest based on hit rate to quickly identify potential fraud or infractions. The App automatically creates a subfolder to store the database with the final results, which is flagged to make it easier to find. The Looping Search offers the ability to tag data in subfolder for easy access to analyze. This App is highly effective for P-card and T&E audits.

What's New
This App now includes a dialogue box providing users with the choice to perform flexible or exact key word matches. For example, the user can decide whether to allow "spa" to bring in all words starting with those letters, such as "space," or only search for the word "spa." This new capability will help look for specific words or fragments for a more refined search when analyzing large data sets.

How it Works
The Looping Search App identifies specified key words in a table or large database to help identify potential red flags, such as the purchases made at unapproved merchants. The user tags fields for two databases. One contains a list of key words, usually a table or Excel file with one field listing all words of interest, and the second table contains the data to be searched. Dialog boxes assist you in every step required for testing. Search terms are not case sensitive. You can search 1, 2 or 3 columns within a database. The App creates a folder within your Project with the results, which can be summarized and prepared for further investigation.

Buy Now in the IDEA Marketplace

Word List Maker Marketplace App LogoCreate a unique list of words found in a selected field to identify frequently used words.

Want to see which key words occur most often within a data set? This App creates a unique list of words found in a selected field including each occurrence within the database. Words are automatically converted to uppercase with special characters removed and the most frequently used words appear at the top to help you focus on key words of interest.

Results are stored in a subfolder, separate from the input databases, making them easier to find. The Word List Maker App offers the ability to tag data in subfolders for easy access to analyze. This App pairs well with the Looping Search App for developing a list of key words to search within large data sets.

What's New
The App now features a reference card within the result set, which allows the user to see the original data including the entire row where the match resided. Users can gain deeper insights by seeing the word list itself, plus a separate table that includes source data.

How it Works
The Word List Maker App analyzes a tagged field, separated out by spaces, to create a unique list of words found in a field. The App helps “normalize” data by converting words to uppercase and removing special characters, keeping only alphanumeric characters. A summarization is performed on the data to keep only the unique list of words and count the number of occurrences found in the file for each word.

The final database is stored by the count, and moved to a subfolder which is flagged for easy identification. The database contains the word and a count of how many times each word occurred. You can use IDEA’s search feature to extract specific words or records.

Immediately Ready
One can run Word List Maker with no option settings at all. By default, it will count all words two characters or greater in length, and it will convert any special characters to spaces. If these behaviors are undesired, or if the user wishes to submit a list of words to omit from the list produced, the Options Dialog can be utilized. Using this dialog, the user can enter words in the value textbox one at a time and click the green check button to form a list of words to omit. The user can then click the save button to save this list to a file if the user wishes. The file can then be loaded later using the open file button.

This can be useful when creating multiple lists across multiple databases to conveniently omit from any list common words such as “the”, “and”, and “for”, for example. In fact, Omit Words will accept any text files (.txt extension) that contain lists of words with one word per line, not just those it creates.

Buy Now in the IDEA Marketplace

Areas of Applications , Automate Procedures , CaseWare IDEA , News

Posted By

By Team Audimation

Related Posts
Tech Tip: Duplicate Identification
Aug 28 Raw data is often incomplete, messy and inconsistent. One of the first steps in the data preparation process is the detection and removal of duplicate records. ...
Wayfair Woes One Year Later
Jul 24 The rise in online shopping has sharply impacted state sales tax revenue. Rather than increasing the tax rate, states are setting parameters to define nexus, wh...
Importing Date Fields
Jul 24 There are times when you import a date field and it just does not work out as expected. Here are ways to address the problem before or after the import.  ...

This website has been designed for modern browsers. Please update. Update my browser now