Before following the below steps, you'll want to be sure two key tasks have already been completed.
1. Create the Client. See this article for more information
2. Request and receive the Payroll Input Data from your client in the proper format. See this article for more information.
0. Create the Engagement
Step 0a: Select Engagements from the left navigation pane
Step 0b: Select the New Engagement button
1. Add Engagement Details
Step 1a: Select the button for "I have payroll data"
Step 1b: Select the Client Name.
Before creating an engagement, ensure that the client has been added in the 'Clients' screen, as they will not appear in the selection list otherwise. See this article for how to create a client.
Step 1c: Enter the Engagement Name
We recommend having a firm standard Engagement Name that includes the year and client name, as the Engagement Name will be incorporated into the header of your Payroll Reports
Step 1d (optional): Enter the Client's EIN and Plan Number
Step 1e: Select any AuditMiner user who should be able to access this Engagement in the Assignees field
Step 1f: Enter the Beginning of Year and End of Year for the plan year
Step 1g: Click Save and Continue
2: Upload Payroll File
Step 2a: Add the payroll input file received from your client. You can drag and drop the file into the dotted box, or select the dotted box to browse out to the file.
Reminder: It is essential that the Payroll Input File be in an AuditMiner compatible format. For more information, see this detailed article.
Step 2b: Be sure the file shows as validated. See this article for assistance if your file does not validate.
Step 2c: Select Save & Continue
3. Map Payroll Fields
There are 3 required data fields that need to be present in your Input File. This mapping screen allows you to tell AuditMiner which columns in the Input File contain the required data.
Step 3a: For the Column Header from File that contains the Employee Identifier, select Employee Identifier in the AuditMiner field.
Step 3b: If the input file contains one column with the full employee name, select Full Name in the AuditMiner field next to that Column Header from File.
If the input file contains separate columns for First Name and Last Name, map each Column Header from file to the First Name and Last Name AuditMiner fields as appropriate.
Step 3c: For the Column Header from File that contains the Pay Date, select Pay Date in the AuditMiner field.
Step 3d: You'll notice the Required data fields at the top change from red to teal when the mapping is correctly done. If you have any red fields, you must correct the mapping before proceeding.
4. Compensation Mapping
This screen allows you to map which columns in the input file represent eligible and ineligible compensation based on the plan document.
In step 4, only map the available columns on the right that represent compensation codes.
Step 4a: Select all eligible compensation codes using the check boxes next to the columns. Once the codes are selected, you can click the codes and drag them into the eligible box.
Repeat until all eligible compensation codes have been mapped. You can use the search columns box to more easily find the eligible columns.
Step 4b: Repeat step 4a for ineligible compensation.
Step 4c: Select Save & Continue.
5. Contribution Mapping
This screen allows you to map columns in the input file that represent contribution codes to the relevant money source type.
In step 5, only map the available columns on the right that represent contribution codes.
Step 5a: Select all Employee Pretax codes using the check boxes next to the columns. Once the codes are selected, you can click and drag them into the Employee Pretax box.
Repeat until all Employee Pretax codes have been mapped. You can use the search columns box to more easily find the Employee Pretax columns.
Step 5b: Repeat step 5a for Employee Roth.
Step 5c: Repeat step 5a for Employer.
At this point, there should be no compensation or contribution columns remaining in the Available Columns list on the right.
If any contribution columns remain, finish mapping them on this screen.
If any compensation columns remain, use the Back button in the lower left to return to Step 4 and finish mapping.
Step 5d: Select Save & Continue.
6. Review & Process
Step 6a: Select the Process Engagement button. This will initiate the creation of your AuditMiner Payroll Reports.
Once you process the engagement, your firm will be charged for 1 Payroll engagement.
Step 6b: You will be automatically redirected to the Engagements screen, where the Engagement Status will be Processing.
7. Retrieving Your Payroll Reports
Step 7a: When your Payroll Reports are ready, the Status will update to Results Available and you will receive an email notification.
Step 7b: Select the Actions menu, then View Results.
Step 7c: Select Download All and a zip file with the Payroll Contribution Detail and Payroll Census will be downloaded to your local machine.
