This page (revision-28) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
28 26-Nov-2021 10:22 13 KB Meg McFarland to previous
27 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
26 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
25 26-Nov-2021 10:22 11 KB Meg McFarland to previous | to last
24 26-Nov-2021 10:22 11 KB Meg McFarland to previous | to last
23 26-Nov-2021 10:22 20 KB kparrott to previous | to last
22 26-Nov-2021 10:22 20 KB kparrott to previous | to last
21 26-Nov-2021 10:22 21 KB kparrott to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - MI
Tax Reporting - MI

Version management

Difference between version and

At line 118 changed 2 lines
!Quarterly UI Wage Reporting – ICESA Format
[RPYEU] must be run with the following report parameters and filters defined to generate Michigan State file information:
!!Quarterly UI Wage Reporting
The State of Michigan accepts quarterly UIA reporting in a State specific format. \\Required records are Codes E and S. Optional records are Codes O and V \\ \\
[RPYEU] must be run with the following report parameters and filters defined to generate Michigan State file information:\\
At line 122 changed one line
|Quarterly Form Code|Mandatory. Quarterly Form Code HL$US-QTR-20YY, defined on the IDFDV form. \\Must be entered in order to produce the UI wage file in [ICESA] format. \\NOTE: Always use the current year form code. __DO NOT__ use a prior year form code as the Identifiers may be obsolete. \\
|Quarterly Form Code|Mandatory. Quarterly Form Code HL$US-QTR-20YY, defined on the IDFDV form. \\NOTE: Always use the current year form code. __DO NOT__ use a prior year form code as the Identifiers may be obsolete. \\
At line 133 changed one line
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
!Quarterly UI Wage Magnetic Media Reporting
At line 137 changed one line
!Record Name: Code E - Employer Record
!Record Name: Code E - Employer Record (Specific to the State of Michigan)
At line 140 changed 12 lines
|2-23 MI|Not Required|
|24-73|Employer Name|Left justify and fill with blanks
|74-113|Employer Street Address|Left justify and fill with blanks
|114-138|Employer City|Left justify and fill with blanks
|139-148|Employer State|Left justify and fill with blanks
|149-153|Blank|Not Required
|154-158|Employer ZIP code|Enter a valid ZIP code\\Derived from the Entity Location
|159-175 MI|Not Required|Fill with blanks
|176-185 MI|State Unemployment Insurance Account Number|Enter the State Unemployment Insurance Account Number \\Derived from the [IDGV] State SUI Registration
|186-190 MI|Not required|Fill with blanks
|191-199 MI|Federal Employer Identification Number (FEIN)|Enter the Federal Employer Identification Number (FEIN)
|200-276 MI|Not required|Fill with blanks
|2-8 MI|Employer Number|Enter the employer's UIA account number
|9-11 MI|Location/Multi Unit Number|Enter the UA Multi Unit Number
|12-15 MI|Year|Enter the year that is being reported, in YYYY format
|16 MI|Quarter|Enter the quarter number that is being reported. \\Options are 1, 2, 3, 4
|17-40 MI|Not Required|Fill with blanks
|41-47 MI|Number of Employees|Enter the number of employees on this file. \\This should match the number of wage details records, codes S, O and V \\Right justify and fill with zeroes \\Cannot be zeroes
|48-60 MI|Total Wages|Enter the total amount of wages reported on the wage details records. \\This should match the total of Employee Gross Wages from record codes S, O and V \\Right justify and fill with zeroes \\Cannot be negative
At line 153 changed one line
!Record Name: Code S – Employee Wage Record
!Record Name: Code S – Employee Wage Record (Specific to the State of Michigan)
At line 156 changed 8 lines
|2-10|Social Security Number|
|11-26 MI|Employee Last Name|
|27-37 MI|Employee First Name|
|38-127 MI|Not Required|Fill with blanks
|128-133 MI|Reporting Period|Enter the month end date and year of the quarter this report applies to. Example: 0920YY for Jul-Sept 20YY
|134-142 MI|State QTR Total Gross Wages|Enter the total Quarterly wages subject to all taxes
|143-143 MI|Status|Enter ‘F’ if employee is a family member, else enter a blank
|144-276 MI|Not Required|Fill with blanks
|2-8 MI|Employer Number|Enter the employer's UIA account number
|9-11 MI|Location/Multi Unit Number|Enter the UIA Multi Unit Number
|12-15 MI|Year|Enter the year that is being reported, in YYYY format
|16 MI|Quarter|Enter the quarter number that is being reported. \\Options are 1, 2, 3, 4
|17-25 MI|Social Security Number|Enter the employee's SSN
|26-32 MI|Blank|Fill with blanks
|33-48 MI|Employee Last Name|Enter the employee's last name
|49-60 MI|Employee First Name|Enter the employee's first name
|61 MI|Employee Middle Initial|Enter the employee's middle inital, if applicable
|62-71 MI|Employee Gross Wages|Enter the employee's total quarterly gross wages. \\Right justify and fill with zeroes \\Cannot be negative
|72 MI|Family Status Indicator|Enter "F" is employee is a family member. Otherwise fill with a blank
At line 165 changed one line
!Record Name: Code T - Total Record
!Record Name: Code O – Out of State Employee Wage Record (Specific to the State of Michigan)
At line 167 changed 5 lines
|1-1|Record Identifier|Constant ‘T’
|2-8|Total Number of Employees|Total number of ‘S’ records since the last ‘E’ record
|9-34 MI|Not Required|Fill with blanks
|35-47 MI|State QTR Total Gross Wages for employer|Enter the total QTR gross wages subject to all taxes\\Total of this field on all ‘S’ records since the last ‘E’ record
|48-276 MI|Not required|Fill with blanks
|1-1|Record Identifier|Constant ‘O’
|2-8 MI|Employer Number|Enter the employer's UIA account number
|9-11 MI|Location/Multi Unit Number|Enter the UA Multi Unit Number
|12-15 MI|Year|Enter the year that is being reported, in YYYY format
|16 MI|Quarter|Enter the quarter number that is being reported. \\Options are 1, 2, 3, 4
|17-25 MI|Social Security Number|Enter the employee's SSN
|26-31 MI|Blank|Fill with blanks
|32-47 MI|Employee Last Name|Enter the employee's last name
|48-59 MI|Employee First Name|Enter the employee's first name
|60 MI|Employee Middle Initial|Enter the employee's middle inital, if applicable
|61-62 MI|State|Defines the State/region the wages were earned prior to Michigan. \\Includes District of Columbia, Virgin Islands and Puerto Rico \\Cannot be blank
|63-72 MI|Employee Gross Out of State Wages|Enter the employee's total quarterly gross Out of State wages. \\Right justify and fill with zeroes \\Cannot be negative
At line 173 changed one line
!Record Name: Code Z - Final Record
!Record Name: Code V – Visa Employee Wage Record (Specific to the State of Michigan)
At line 175 changed 2 lines
|1-1 MI|Record Identifier|Constant ‘Z’
|2-276 MI|Not required|Fil with blanks
|1-1|Record Identifier|Constant ‘V’
|2-8 MI|Employer Number|Enter the employer's UIA account number
|9-11 MI|Location/Multi Unit Number|Enter the UIA Multi Unit Number
|12-15 MI|Year|Enter the year that is being reported, in YYYY format
|16 MI|Quarter|Enter the quarter number that is being reported. \\Options are 1, 2, 3, 4
|17-25 MI|Social Security Number|Enter the employee's SSN
|26-31 MI|Blank|Fill with blanks
|32-47 MI|Employee Last Name|Enter the employee's last name
|48-59 MI|Employee First Name|Enter the employee's first name
|60 MI|Employee Middle Initial|Enter the employee's middle initial, if applicable
|61-62 MI|Visa Type|Enter "01" for an employee with a J-1 visa. \\Enter "02" for an employee with a H-2B visa. \\Cannot be zero filled
|63-72 MI|Employee Quarterly Wages|Enter the employee's total quarterly gross wages. \\Right justify and fill with zeroes \\Cannot be negative
At line 195 added 2 lines
This page (revision-28) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop