Error submitting IL Monthly Wage Report - E Record total wages not equal to total wages in file



Description of Issue

When I submit my IL Monthly Wage Report I'm getting an error - 

E Record total wages: $###,###.## not equal to total wages in file: $##,###.##



Context
  • Payroll

  • Illinois

  • IL Monthly Wage Report



Cause

Employees with negative amounts are excluded from the S record on the submission file, but their negative wages are included in the E record report totals



Resolution

Install (master) work ticket MUN-447137 when available. 

Work around:

Manually edit the csv file.

  1. Review the proof report. 

    1. Note the amount of Monthly Wages on the last page of the proof.

    2. Note the amount of Reported Total Wages on the last page of the proof.

  2. Open the csv submission file. The first line in the file is the E Record. 

  3. On the first line, find the Monthly Wages amount you noted from the proof. 

  4. Replace it with the Reported Total Wages amount you noted from the proof.

  5. Save the file as a csv and submit



Additional Information