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 42 changed 2 lines
!Record Name: Code RA – Submitter Record
__Same as the Federal Code RA__\\
!Record Name: Code RA – Submitter Record (Same as the Federal Code RA)
At line 46 changed 2 lines
!Record Name: Code RE – Employer Record
__Same as the Federal Code RE__\\
!Record Name: Code RE – Employer Record (Same as the Federal Code RE)
At line 51 changed 2 lines
!Record Name: Code RW - Employee Wage Record
__Same as the Federal Code RW__\\
!Record Name: Code RW - Employee Wage Record (Same as the Federal Code RW)
At line 96 added one line
At line 118 changed 4 lines
!!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:\\
!Quarterly UI Wage Reporting – ICESA Format
[RPYEU] must be run with the following report parameters and filters defined to generate Michigan State file information:
At line 124 changed one line
|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. \\
|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. \\
At line 135 changed 2 lines
!Quarterly UI Wage Magnetic Media Reporting
%%information NOTE: The following ‘Not Required’ fields may or may not always contain blanks.%% \\
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
%%information NOTE: the following ‘Not Required’ fields may or may not always contain blanks.%% \\
At line 139 changed one line
!Record Name: Code E - Employer Record (Specific to the State of Michigan)
!Record Name: Code E - Employer Record
At line 142 changed 7 lines
|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
|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
At line 150 changed one line
!Record Name: Code S – Employee Wage Record (Specific to the State of Michigan)
!Record Name: Code S – Employee Wage Record
At line 153 changed 11 lines
|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
|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
At line 165 changed one line
!Record Name: Code O – Out of State Employee Wage Record (Specific to the State of Michigan)
!Record Name: Code T - Total Record
At line 167 changed 12 lines
|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
|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
At line 180 changed one line
!Record Name: Code V – Visa Employee Wage Record (Specific to the State of Michigan)
!Record Name: Code Z - Final Record
At line 182 changed 12 lines
|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
|1-1 MI|Record Identifier|Constant ‘Z’
|2-276 MI|Not required|Fil with blanks
At line 195 removed 2 lines
This page (revision-28) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop