Employer Tax Report
There may be zero or more records after each header record.
The following table lists the field name, description, data type, size, and format for the employer tax report.
Field Name | Description | Data Type | Size | Format |
---|---|---|---|---|
Record Type | H | String | 1 | X(1) |
Sequence | The sequence of the tax report in the file. | Integer | 3 | 9(3) |
Employer Number | The first seven digits are the employer number. The last three digits are the location (multi-unit number). | Integer | 10 | 9(10) |
Quarter Ending | Filing calendar quarter Valid values:
| Integer | 5 | QCCYY |
Gross Wages | Gross Wages field on the tax portion of Form 1028. | Integer | 13 | 9(11)V99 |
Excess Wages | Excess Wages field on Form 1028. | Integer | 13 | 9(11)V99 |
Workers 1st Month | 1st Month field on Form 1028. | Integer | 6 | 9(6) |
Workers 2nd Month | 2nd Month field on Form 1028. | Integer | 6 | 9(6) |
Workers 3rd Month | 3rd Month field on Form 1028. | Integer | 6 | 9(6) |
Final Report | Final Report option on the MI Quarterly Unemployment Report - Report page. Valid values:
| Integer | 1 | 9(1) |
Apportionment | Apportionment option on the MI Quarterly Unemployment Report - Report page. Valid values:
| Integer | 1 | 9(1) |
Amended | Always defaults to 0. | Not Applicable | Not Applicable | Not Applicable |
Number of Wage Records | Should match the total number of wage records, out-of-state records, and visa records on Form 1028. | Integer | 7 | 9(7) |
Total Gross Wages | Should match the sum of the Gross Wages fields from wage records, out-of-state records, and visa records on Form 1028. | Integer | 13 | 9(11)V99 |