We have created an adjustment report for when a group is in audit mode (Payroll>Deduction Discrepancy Audit>View Report>Adjustments). This report allows us to report the adjustments that need to be made in payroll during the audit and is a date generated report.
NOTE: The only ee's that will be included on this report are those who have had deduction transmission sent to payroll. An ee can be listed on the report multiple times if they have multiple deductions that were discrepant and sent to payroll.
You will see the following fields when generating the report:
- Masked ee SSN
- ee First Name
- ee Last Name
- Deduction Code
- Enrollment Effective Date tied to that deduction
- EE cost per pay
- Estimated Adjustment Cost Calculation= Recurring Deduction Difference*Pay Dates Missed
- See below for calculation explanation**
Recurring Deduction Difference = we are calculating the difference between recurring deduction value in EN and payroll's recurring deduction value on the discrepancy report (this can be a positive or negative value). A positive values means that the amount needs to be deducted from payroll, a negative value means that the ee will need to be credited with that amount in payroll.
Date Missed = we are identifying the missed payroll dates between today's date (or the date that is identified in the report) and effective date of the deduction in EN.
Example: A group is going through the deduction audit today, 3/20/18. During the audit, an employee appears on the deduction discrepancy report because their VISON amount in Paycor is $6.56 and their vision amount in EN is $25.36. When we sent the updated value of $25.36 to Paycor, it will have the effective date of 3/20/18. In reality, the $25.36 deduction was effective 1/1/2018 not 3/20/18. The adjustment report in the audit allows us to determine how much needs to be “adjusted” in the employee’s paycheck to account for the 1/1/18 effective date. This report gives an estimated cost by multiplying the recurring deduction difference * pay dates missed.