/
Why are unemployment wages calculating as a negative

Why are unemployment wages calculating as a negative

Description of Issue

Unemployment wages are calculating as negative.  I can't figure out where the system is getting that number from. 

Context
  • Payroll

  • State Reporting 

  • Unemployment 

  • ICESA 

  • Tax and Wage reporting

  • Employment Wage and Detail reporting

  • Contribution and Wage reporting

Cause
  • Void payroll that crossed quarters

  • Math

Resolution

Total Unemployment Wages are calculated as:

  1. The sum of Gross amounts from Pay codes in Employee Accumulators for the reporting Quarter/Year that have not been defined on the Generate screen as Exclude.

  2. Minus Employee Amounts from Deduction codes in Employee Accumulators for the reporting Quarter/Year that have been defined on the Generate screen as Exclude. 

  3. Plus Employer Amounts from Deduction codes in Employee Accumulators for the reporting Quarter/Year that have been defined on the Generate screen as Include.

This calculation occurs for any employee with the Unemployment Tax option selected in the Employee Master, that also has Quarterly Accumulator values.

In most cases, there are truly no reportable earnings for the Quarter and in that scenario, you need to delete the ICESA Period Record for this employee before creating the submission file. 

Otherwise, you will need to correct the define issue that's preventing the math you're expecting, such as removing a Pay code defined as Exclude that should not actually be excluded. 

Additional Information

Easiest way to reconcile the reported value is to export Quarterly Accumulators for the affected employee and take the steps above. 

To create the Quarterly Accumulators Export:

  1. Open the Accumulators Report program

  2. Select Search

  3. Enter:

    1. The Employee Number in the Employee field

    2. The reporting year in the Year field

    3. Q in the Frequency field

    4. The reporting Quarter in the Cycle field

  4. Select Accept

  5. Select Browse

  6. Select Excel









Related content

Unemployment reporting validation message - Total Unemployment Wages is negative
Unemployment reporting validation message - Total Unemployment Wages is negative
More like this
WI Unemployment showing Excluded Quarterly Wage Amount
WI Unemployment showing Excluded Quarterly Wage Amount
More like this
Unemployment reporting validation message - Employee has negative Taxable Wages
Unemployment reporting validation message - Employee has negative Taxable Wages
More like this
GA Unemployment and Multiple Worksite Report have differing wage amounts
GA Unemployment and Multiple Worksite Report have differing wage amounts
More like this
Unemployment Wages incorrect when employee earnings matches Taxable Wage Limit amount
Unemployment Wages incorrect when employee earnings matches Taxable Wage Limit amount
More like this
Unemployment Reporting - Taxable Wages is 0
Unemployment Reporting - Taxable Wages is 0
More like this