The 21st Minute


Employee Benefit Plan Sampling



McConnell & Jones LLP is a public accounting firm serving a broad section of industry, government and non-profit organizations. The team provides a full array of tax and assurance services that include audits, review examinations and compilations. The firm specializes in Employee Benefit Plan (EBP) audits, and performs more than 160 each year.


EBP audits require a manual process of sorting through hundreds or thousands of records and detailed transactional data to find ineligible participants. Auditors can spend countless hours verifying records and HR data to identify sample participants. McConnell & Jones wanted to find a solution to automate the process of selecting samples across multiple employee benefit plan (EBP) types to increase efficiency, reduce time and generate uniform output of data for further analysis.


Audimation Services created a process that automatically queries and identifies ineligible participants based on employment dates and employee status parameters for all three plan types; Defined Contribution Pension Plans, Defined Benefit Pension Plans, and Health & Welfare Plans. It also automatically performs several data integrity checks such as verifying that all records in the census data appear in the clients HR data.  Users can opt to generate a sample of participants who have enrolled in all investment types to save additional time. Data is output into an Excel worksheet in a uniform fashion, providing a consistent approach to audits. Exceptions are noted for further analysis and testing. The built-in logic reduces hours of manual work. The process was turned into an Audimated App with dialog boxes to walk users through each step of the process for additional ease of use.


McConnell & Jones experienced immediate ROI and time savings as a result of using the App. The sample selection process, which once took 8 hours of manual effort, was reduced to 20 minutes, and improved the consistency and uniformity of outputs.


Automate Procedures , Success Story

Posted By


Related Posts
Turn Your Data into a Competitive Advantage
Nov 05 Download the eBook We are in the midst of a data explosion where every action is collected, from a credit card swipe to the vibration of a factory machine. Y...
Infusing Python into Your Analysis with IDEA
Oct 06 The tech community often refers to Python as the official programming language for non-programmers. It’s free and easy to learn (even if you don’t know wher...
Exploring IDEA's Built-In Power of Python
Aug 20 In December of 1989, Dutch programmer Guido van Rossum was looking for a hobby programming project to keep him occupied during a slow work week around Christmas...

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