Why are unemployment wages calculating as a negative
- Knowledge Assistant
Unemployment wages are calculating as negative. I can't figure out where the system is getting that number from.
Payroll
State Reporting
Unemployment
ICESA
Tax and Wage reporting
Employment Wage and Detail reporting
Contribution and Wage reporting
Void payroll that crossed quarters
Math
Total Unemployment Wages are calculated as:
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.
Minus Employee Amounts from Deduction codes in Employee Accumulators for the reporting Quarter/Year that have been defined on the Generate screen as Exclude.
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.
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:
Open the Accumulators Report program
Select Search
Enter:
The Employee Number in the Employee field
The reporting year in the Year field
Q in the Frequency field
The reporting Quarter in the Cycle field
Select Accept
Select Browse
Select Excel