Earnings and Deductions-Deduction Reconciliation tab shows a discrepancy message

Description of Issue

User is reviewing an employee's withholding for a particular deduction in a closed warrant. On the Deduction Breakdown tab in Deduction Detail under Withholding, a message appears in red on the left:

There is a discrepancy between the 'reconciliation-calculated' and 'actual' amounts. This may be due to changes to settings that have occurred since the payroll was originally run.

The calculated amount on that tab is also different from what was originally withheld.

Context
  • Enterprise ERP Payroll

  • Payroll Start and Status

  • Earnings and Deductions

  • Deduction Detail

  • Employee Deductions

  • Deduction and Benefit Master

  • Tax Tables

  • Payroll Exceptions

Cause

The Deduction Breakdown shows a real-time step by step calculation for the deduction based on the current set up. If anything in the set up has changed since this payroll was run that would affect how much the employee would have withheld based on the Deduction Gross in this warrant, this message will show up to alert the user of this. In this case a different withholding amount would show at the end of the calculation from what was originally calculated and withheld.

Resolution

Possible set up pieces to review:

  • Tax Tables

    • Have the values on the most recent tax tables changed?

    • Were Annual Tax Tables enabled or disabled?

  • Payroll Exceptions

    • Has a pay code or deduction been added to or removed from Exceptions?

    • Was the check box for Exclude Exp Only checked or unchecked for a pay or deduction?

    • Was Apply Pay Type Exceptions When Adding/Subtracting checked or unchecked?

Additional Information