US W2 ANNUAL AND QUARTERLY PROCESSING - MINNESOTA#

Set Up #

This document contains abbreviated set up requirements for the State of Minnesota only. Please refer to the general document (Tax Reporting - US General) for other setup procedures that may also be required.

IMUF – Define User Fields for IDGV#

Define the user fields for P2K_CM_GOVT_REGISTRATIONS. The following user fields are used on the IDGV Definition tab, therefore they must set up on IMUF:
  • W2 STATE MEDIA FILING
  • W2 TAX TYPE CODE
  • W2 TAXING ENTITY
  • W2 WAGE PLAN CODE
  • W2 BRANCH CODE

IMUF – Define User Fields for IDDP #

Define user fields for P2K_CM_DEPARTMENT_DETAILS. The following user fields are used on IDDP, therefore they must set up on IMUF:
  • SUI ER NUMBER
  • W2 DESTINATION

IMUF – Define User Fields for IEID #

Define User Fields for P2K_HR_IDENTITIES. The following user fields are used on IEID for Minnesota, therefore they must set up on IMUF:
  • W2 DESTINATION
  • MMREF PROBATIONARY
  • MMREF OFFICER CODE

IDGV – Government Registration for the State#

Define state government registrations for the State of Minnesota.
  • Enter the Minnesota State Employer Account Number on the ‘Number’ field
  • ‘W2 STATE MEDIA FILING’ - enter ‘02’ to generate the State of Minnesota Magnetic Media file for MN State only

IDGV – Government Registration for SUI#

Define ‘US SUI Registration’ for Minnesota State
  • Enter the State of Minnesota SUI Employer Account Number in the ‘Number’ field. This number may be the same or different than the State Employer Account Number defined with ‘State Registration’
  • On the ‘Govt Rate Type’ field, select ‘US SUI Max Base Amt’ and enter the Minnesota SUI Wage Base in the Amount field
  • The SUI Wage Base amount must be updated every year to reflect the most current Wage Base amount from the State of Minnesota
    • This SUI Wage Base amount is used to calculate SUI Excess Wages and Taxable Wages
  • Effective date record, enter ’01-Jan-20YY’ to define the SUI Wage Base amount. This field must be updated annually
  • There is no need to set up the IDGV Definition tab for ‘US SUI Registration’ for Minnesota
  • When RPYEU is run, if the Period Type = ‘Q’ Quarterly Reporting, the SUI information will automatically be derived and written on the Code RS record for the magnetic media file

IDDP – Define Departments#

  • The State of Minnesota requires reporting of the Quarterly file by MN State Unemployment Insurance Account Number and MN Employer Unit Number. These two numbers are defined at the department level. For this reason, the UDF ‘SUI ER Number’ must be set up for each department
    Example: For the Department ‘Planning & Zoning’, the MN number is ‘7977999-004’, then UDF ‘SUI ER Number’ = 7977999-004 should be entered on IDDP.
  • If the ‘SUI ER Number’ is not set up for a department, then the SUI ER Number from IDGV is used
  • Note that on IDDP, the detail section of the screen must be clicked and then the UDF button must be clicked to get to UDF screen
  • ‘W2 Destination’ can be entered for distributing the W2 forms by department

IEID – Employee Identity Screen User Field#

  • The ‘W2 Destination’, ‘MMREF Officer Code’ can be entered for an employee.
  • On the MMREF1 file, the Code RS record position 341, the State of Minnesota requires reporting of the Officer Code for the employee.
  • If an employee qualifies as an Officer for State of Minnesota, ‘Y’ should be entered on ‘MMREF Officer Code’ field.
  • ‘W2 Destination’ can be entered for distributing the W2 forms for the employee
  • ‘MMREF Probationary’ code is not used for State of Minnesota

IDFDV – Define Form Code#

  • Define form code ‘HL$US-W2-20YY’ for MMREF1 format. This code is used for Minnesota quarterly MMREF1 reporting
  • For a complete list of ‘HL$US-W2-20YY’ identifiers, please refer to the W2 Process Processing and W2 Process Set up documents in this Knowledge base.

State File Procedures#

The State of Minnesota accepts filing of quarterly information using the EFW2 format
  • Record Codes required are: Code RA, RE, RW, RS, RT and RF
  • In addition to the quarterly State Magnetic Media filing in the EFW2 format, employers are required to manually fill in Minnesota State Form MDES-1406 form
  • The ‘Total Gross Wages’ and the Employee Count information are required to be filled in for employees who have been paid on the 12th day of each month of the quarter
  • When RPYEU is run for quarterly reporting information, RPYEU produces a report at the ‘SUI Registration’ level that contains this information. The required information should be manually entered on the State form.
  • For the State of Minnesota, the EFW2 file Code RS record positions 248-259 are required to be reported by the MN State Unemployment Insurance Account Number and Employer Unit Number. The MN Employer Unit Number is defined at the department level and therefore the MN State Unemployment Insurance Account Number and MN Employer Unit Number must be set up on IDDP UDF ‘Dept SUI ER Number’ field
  • When RPYEU is run:
    • Define the ‘Sort Level By’ field as ‘DEPT SUI ER Number’, and
    • Define the ‘Provide Sort Level Total’ as ‘Yes’. These fields must be defined in order to obtain the department totals by MN Employer Unit Number
    • The employee’s prime assignment detail record, that is effective as of the period end date, is used to retrieve the department, and the department is used to retrieve the UDF ‘DEPT SUI ER Number’ for reporting.
      Therefore, the employee is reported under the employee's prime assignment detail's department for SUI purpose.
  • When an employee changes department during the quarter, the employee is only reported under the last department that they have worked, effective as of the period end date. The employee is not reported under multiple departments since the quarterly information from the 'ToDate' headers are not kept by department.

Annual W2 Wage Reporting – EFW2 Format#

RPYEU must be run with the following report parameters and filters defined to generate the Minnesota State file information.
RPYEU will generate the Minnesota State W2 EFW2 File Format according to the State specifications

RPYEU Report Parameters

Annual Form CodeUse standard form code, such as 'HL$US-W2-YYYY'
Period TypeMandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
Period End DateMandatory. Defines the end date of the reporting period. Enter in DD-MMM-YYYY format
As of DateThis date is used to retrieve employee information such as name, address, etc.
Combine Employment TypeSet to ‘Yes’ since Code RE records are not reported by ‘Employment Type’
Media FormatMandatory. Set to State File Format
Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
Directory Name Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
Media File NameMandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced

RPYEU Report Filters

Select State: Minnesota, USA
Federal Regist Number: Enter the Federal Registration Number

RPYEU Run Options

Provide Sort Level Totals: Optional. When set to YES, the totals are generated by ‘DEPT SUI ER Number’

Please enter other prompts accordingly.

State Magnetic Media Reporting – EFW2 Format#

Record Name: Code RA - Transmitter Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RA - Submitter Record#

ColumnDescriptionSource
1-2Record IdentifierConstant "RA"
3-11Submitter’s Employer ID Number (EIN)Required.
Derived from the ‘SUB-ER-EIN’ IDFDV Field Identifier (seq 1000).
Numeric only.
12-19User Identification (User ID)Required.
Enter the eight-character BSO User ID assigned to the employee who is attesting to the accuracy of this file.
20-23Software Vendor CodeEnter the numeric four-digit Software Vendor Identification Code assigned by the National Association of Computerized Tax Processors (NACTP).

If "99 (Off-the-Shelf Software)" is entered in the Software Code field (positions 36-37) enter the Software Vendor Code.
Otherwise, fill with blanks.
24-28BlankFill with blanks. Reserved for SSA use.
29Resub IndicatorEnter "1" if this file is being resubmitted. Otherwise, enter "0" (zero).
30-35Resub Wage File Identifier (WFID)If "1" was entered in Resub Indicator field (position 29), enter the WFID displayed on the notice SSA sent. Otherwise, fill with blanks.
36-37Software CodeEnter "99" to indicate 'Off-the-Shelf Software'
38-94Company NameEnter the Company Name.
Left justify and fill with blanks.
95-116Location AddressEnter the company's location address (Attention, Suite, Room Number, etc).
Left justify and fill with blanks
117-138Delivery AddressEnter the company's delivery address (Street or Post Office Box).
Example: 123 Main Street.
Left justify and fill with blanks
139-160CityEnter the company's city.
Left justify and fill with blanks
161-162State AbbreviationEnter the company's State or commonwealth/territory.
Use a postal abbreviation. For a foreign address, fill with blanks
163-167ZIP CodeEnter the company's ZIP code. For a foreign address, fill with blanks
168-171ZIP Code ExtensionEnter the company's four-digit extension of the ZIP code. If not applicable, fill with blanks
172-176BlankFill with blanks. Reserved for SSA use.
177-199Foreign State/ProvinceIf applicable, enter the company's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
200-214Foreign Postal CodeIf applicable, enter the company's foreign postal code.
Left justify and fill with blanks. Otherwise, fill with blanks.
215-216Country CodeIf one of the following applies, fill with blanks:
* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
217-273Submitter NameRequired.
Enter the name of the organization's submitter to receive error notification if this file cannot be processed.
Left Justify and fill with blanks.
Derived from the ‘SUB-SUBM-NAME’ IDFDV Field Identifier (seq 1150).
274-295Submitter Location AddressEnter the submitter's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-LOCN’ IDFDV Field Identifier (seq 1160).
296-317Submitter Delivery AddressRequired.
Enter the submitter's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-DELIV’ IDFDV Field Identifier (seq 1170).
318-339Submitter CityRequired.
Enter the submitter's city.
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-CITY’ IDFDV Field Identifier (seq 1180).
340-341Submitter State AbbreviationRequired.
Enter the submitter's State or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks.
Derived from the ‘SUB-SUBM-STATE’ IDFDV Field Identifier (seq 1190).
342-346Submitter ZIP CodeRequired.
Enter the submitter's ZIP Code.
For a foreign address, fill with blanks.
Derived from the ‘SUB-SUBM-ZIP’ IDFDV Field Identifier (seq 1200).
347-350Submitter ZIP Code extensionEnter the submitter's four-digit extension of the ZIP code. If not applicable, fill with blanks.
Derived from the ‘SUB-SUBM-ZIP-EXT’ IDFDV Field Identifier (seq 1210).
351-355BlankFill with blanks. Reserved for SSA use
IMPORTANT NOTE: If using a foreign address, the foreign State/Province (postions 356-378), Foreign Postal Code (positions 379-393) and the Contry Code (positions 394-395) are required to be completed.
356-378Foreign State/ProvinceIf applicable, enter the submitter's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
379-393Foreign Postal CodeIf applicable, enter the submitter's foreign Postal Code.
Left justify and fill with blanks. Otherwise, fill with blanks.
394-395Country CodeIf one of the following applies, fill with blanks
* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
396-422Contact NameRequired.
Enter the name of the person to be contacted by SSA concerning processing problems.
Left justify and fill with blanks.
Derived from the ‘SUB-CONT-NAME’ IDFDV Field Identifier (seq 1250).
423-437Contact Phone NumberRequired.
Enter the contact's phone number with numeric valies only (including area code). Do not use any special characters.
Left justify and fill with blanks.

NOTE: It is imperative that the contact's telephone number be entered in the appropriate positions. Failure to include correct and complete submitter contact information may, in some cases, delay the timely processing of your file.

Derived from the ‘SUB-CONT-TEL’ IDFDV Field Identifier (seq 1260).
438-442Contact Phone ExtensionEnter the contact's telephone extension.
Left justify and fill with blanks.
Derived from the ‘SUB-CONT-TEL-EXT’ IDFDV Field Identifier (seq 1270).
443-445BlankFill with blanks. Reserved for SSA use.
446-485Contact E-mail/InternetEnter the contact's e-mail/internet address.
Derived from the ‘SUB-CONT-EMAIL’ IDFDV Field Identifier (seq 1280).
486-488BlankFill with blanks. Reserved for SSA use.
489-498Contact FaxIf applicable, enter the contact's fax number (including area code). Otherwise, fill with blanks.
Derived from the ‘SUB-CONT-FAX’ IDFDV Field Identifier (seq 1290).
499BlankFill with blanks. Reserved for SSA use.
500Preparer CodeEnter one of the following codes to indicate who prepared this file:
* A = Accounting Firm
* L = Self Prepared
* S = Service Bureau
* P = Parent Company
* O = Other

If more than one code applies, use the code that best describes who prepared this file.
501-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RE - Employer Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RE - Employer Record#

ColumnDescriptionSource
1-2Record IdentifierConstant "RE"
3-6Tax yearRequired.
Enter the tax year for this report (YYYY).
Derived from the user defined FROM-TO period, converted to YYYY.
7Agent Indicator CodeIf applicable, enter one of the following codes:
* 1 = 2678 Agent
* 2 = Common Paymaster
* 3 = 3504 Agent
If more than one code applies, use the one that best describes your status as an agent.
Otherwise, fill with a blank.
8-16Employer/Agent EINRequired.
Derived from the applicable Federal reporting EIN, from IDGV or IDGR.
17-25Agent for EINIf "1" was entered in the Agent Indicator Code field (position 7), enter the client-employer's EIN for which you are an Agent. Otherwise, fill with blanks.
26Terminating Business IndicatorIf this is the last tax year that W-2s will be filed under this EIN, enter "1". Otherwise, enter 0 (zero).
27-30Establishment NumberFor multiple RE (Employer) Records with the same EIN, you can use this field to assign a unique identifier for each RE (Employer) Record. Otherwise, fill with blanks.
31-39Other EINFor this tax year, if you submitted tax payments to the IRS under Form 941, 943, 944, CT-1 or Schedule H or W2 data to SSA, and a different EIN was used from the EIN in positions 8-16, enter the other EIN. Otherwise, fill with blanks.
IMPORTANT NOTE: The Employer's Name field (positions 40-96) and the Employer's Address fields (positions 97-173) should normally match the employer name and address under which tax payments were submitted to the IRS under Form 941, 943, 944, 945, CT-1 or Schedule H.
40-96Employer NameRequired.
Enter the name associated with the EIN entered in positions 8 - 16.
Left justify and fill with blanks.
Derived from the 'W2-ER-NAME' IDFDV Field Identifier (seq 2010).
97-118Employer Location AddressEnter the employer's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the 'W2-ER-LOCN-ADDR' IDFDV Field Identifier (seq 2020).
119-140Employer Delivery AddressEnter the employer's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the 'W2-ER-DELIV-ADDR' IDFDV Field Identifier (seq 2030).
141-162Employer CityEnter the employer's city.
Left justify and fill with blanks.
Derived from the 'W2-ER-CITY' IDFDV Field Identifier (seq 2040).
163-164Employer State AbbreviationEnter the employer's State or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks.
Derived from the 'W2-ER-STATE' IDFDV Field Identifier (seq 2050).
165-169Employer ZIP CodeEnter the employer's ZIP Code.
For a foreign address, fill with blanks.
Derived from the 'W2-ER-ZIP' IDFDV Field Identifier (seq 2060).
170-173Employer ZIP Code ExtensionEnter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks.
Derived from the 'W2-ER-ZIP-EXT' IDFDV Field Identifier (seq 2070).
174Kind of EmployerRequired.
Enter the appropriate kind of employer:

* F = Federal Government
* State/local non-501c
* T = 501c non-government
* Y = State/local 501c
* N = None apply

NOTE: Leave blank if the tax jurisdiction Code in position 220 of the RE (Employer) Records is "P" (Puerto Rico).
175-178BlankFill with blanks. Reserved for SSA use.
179-201Foreign State/ProvinceIf applicable, enter the employer's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
202-216Foreign Postal CodeIf applicable, enter the company's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks.
217-218Country CodeIf one of the following applies, fill with blanks:

* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
219Employment CodeRequired.
Enter the appropriate employment code:

* A = Agriculture (Form 943)
* H = Household (Schedule H)
* M = Military (Form 941)
* Q = Medicare Qualified Government Employment (Form 941)
* X = Railroad (CT-1)
* F = Regular (Form 944)
* R = Regular (all others) (Form 941).
NOTE: Railroad reporting is not applicable for Puerto Rico and territorial employers.
220Tax Jurisdiction CodeRequired.
Enter the code that identifies the type of income tax withheld from the employee's earnings:

* Blank (W-2)
* V = Virgin Islands (W-2VI)
* G = Guam (W-2GU)
* S = American Samoa (W-2AS)
* N = Northern Mariana Islands (W-2CM)
* P = Puerto Rico (W-2PR/499R-2)
221Third Party Sick Pay IndicatorEnter "1" for a sick pay indicator. Otherwise, enter "0" (zero).
222-248Employer Contact NameEnter the name of the employer's contact.
Left justify and fill with blanks.
249-263Employer Contact Phone NumberEnter the employer's contact telephone number with numeric values only (including area code). Do not use any special characters.
Left justify and fill with blanks.
264-268Employer Contact Phone ExtensionEnter the employer's contact telephone extension with numeric values only. Do not use any special characters.
Left justify and fill with blanks.
269-278Employer Contact Fax NumberIf applicable, enter the employer's contact fax number with numeric values only (including area code). Do not use any special characters.
Otherwise, fill with blanks.
For US and US Territories only
279-318Employer Contact E-Mail/InternetEnter the employer's contact e-mail/internet address.
319-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RW – Employee Wage Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RW - Employee Wage Record #

ColumnDescriptionSource
1-2Record IdentifierConstant "RW"
3-11Social Security NumberRequired.
Enter the employee's SSN.
If an invalid SSN is encountered, this field is filled with zeros.
Derived from the ‘W2-EE-SSN’ (seq 2500) IDFDV Field Identifier.
12-26Employee First NameRequired.
Enter the employee's first name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-FIRST-NAME’ (seq 2510) IDFDV Field Identifier.
27-41Employee Middle Name or InitialIf applicable, enter the employee's middle name or initial.
Left Justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-MIDDLE’ (seq 2520) IDFDV Field Identifier.
42-61Employee Last NameRequired.
Enter the employee's last name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-LAST-NAME’ (seq 2530) IDFDV Field Identifier.
62-65Employee SuffixIf applicable, enter the employee's alphabetic suffix.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-SUFFIX’ (seq 2540) IDFDV Field Identifier.
66-87Employee Location AddressEnter the employee's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the ‘W2-EE-LOCN-ADDR’ (seq 2600) IDFDV Field Identifier.
88-109Employee Delivery AddressEnter the employee's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the ‘W2-EE-DELIV-ADDR’ (seq 2610) IDFDV Field Identifier.
110-131Employee CityEnter the employee's City.
Left justify and fill with blanks.
Derived from the ‘W2-EE-CITY’ (seq 2620) IDFDV Field Identifier.
132-133Employee State AbbreviationEnter the employee's State or commonwealth/territory.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-STATE’ (seq 2630) IDFDV Field Identifier.
134-138Employee ZIP CodeEnter the employee's ZIP code.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-ZIP’ (seq 2640) IDFDV Field Identifier.
139-142Employee ZIP Code ExtensionEnter the employee's four-digit ZIP code extension.
If not applicable, fill with blanks.
Derived from the ‘W2-EE-ZIP-EXT’ (seq 2650) IDFDV Field Identifier.
143-147BlankFill with blanks. Reserved for SSA use.
148-170Employee Foreign State/ProvinceIf applicable, enter the employee's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-F-STATE’ (seq 2660) IDFDV Field Identifier.
171-185Employee Foreign Postal CodeIf applicable, enter the employee's foreign postal code.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-F-POSTAL’ (seq 2670) IDFDV Field Identifier.
186-187Employee Country CodeIf one of the following applies, fill with blanks:

* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
Derived from the ‘W2-EE-COUNTRY’ (seq 2680) IDFDV Field Identifier.
188-198Wages, Tips and Other CompensationNo negative amounts.
Right justify and zero fill.
Derived from the ‘W2-FIT-WAGE’ (seq 3000) IDFDV Field Identifier.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.
199-209Federal Income Tax WithheldNo negative amounts.
Right justify and zero fill.
Derived from the ‘W2-FIT-TAX’ (seq 3010) IDFDV Field Identifier.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.
210-220Social Security WagesZero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is 'Q-MGQE' or 'X-Railroad'.

If Employment Code is 'H-Household' and the tax year is 1994 or later, the sum of this field and the Social Security Tips field must be equal to or greater than the annual Household minimum for the tax year being reported. Otherwise, reports zeros.

The sum of this field and the Social Security Tips field should not exceed the annual maximum Social Security wage base for the tax year being reported.

No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-SSN-WAGE’ (seq 3020) IDFDV Field Identifier.
221-231Social Security Tax WithheldZero fill if the Employment Code reported in position 219 of the preceeding RE (Employer_ Record is 'Q-MGQE' or 'X-Railroad'.

If the Employement Code is not 'Q-MGQE' or 'X-Railroad' and the amount in this field is greater than zero, then the Social Security Wages field and/or the Social Security Tips field must be greater than zero.

No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-SSN-TAX’ (seq 3030) IDFDV Field Identifier.
232-242Medicare Wages and TipsZero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is 'X-Railroad'.

If Employment Code is 'H-Household' and the tax year is 1994 or later, this field must be equal to or greater than the annual Household minimum for the tax year being reported. Otherwise, fill with zeros.

No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-MEDI-WAGE’ (seq 3040) IDFDV Field Identifier.
243-253Medicare Tax WithheldZero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is 'X-Railroad'.

No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-MEDI-TAX’ (seq 3050) IDFDV Field Identifier.
254-264Social Security TipsZero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is 'Q-MGQE' or 'X-Railroad'.

The sum of this field and the Social Security Wages field should not exceed the annual maximum Social Security wage base for the tax year being reported. Otherwise, reports zeros.

If Employment Code is 'H-Household' and the tax year is 1994 or later, the sum of this field and the Social Security Wages field must be equal to or greater than the annual Household minimum for the tax year being reported. Otherwise, report zeros.

No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-SSN-TIP’ (seq 3060) IDFDV Field Identifier.
265-275BlankFill with blanks. Reserved for SSA use.
276-286Dependent Care BenefitsNo negative amounts.
Right justify and zero fill.
Derived from the ‘W2-DEP-CARE’ (seq 3090) IDFDV Field Identifier.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.
287-297Deferred Compensation Contributions to Section 401(k) (Code D)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-D’ (seq 4030) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
298-308Deferred Compensation Contributions to Section 403(b) (Code E)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-E’ (seq 4040) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
309-319Deferred Compensation Contributions to Section 408(k)(6) (Code F)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-F’ (seq 4050) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
320-330Deferred Compensation Contributions to Section 457(b) (Code G)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-G’ (seq 4060) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
331-341Deferred Compensation Contributions to Section 501(c)(18)(D) (Code H)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-H’ (seq 4070) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
342-352BlankFill with blanks. Reserved for SSA use.
353-363Nonqualified Plan Section 457 Distributions or ContributionsNo negative amounts.
Right justify and zero fill.
Derived from the ‘W2-NQUAL-457’ (seq 3102) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
364-374Employer Contributions to a Health Savings Account (Code W)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-W’ (seq 4190) IDFDV Field Identifier.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
375-385Nonqualified Plan Not Section 457 Distributions or ContributionsNo negative amounts.
Right justify and zero fill.
Derived from the ‘W2-NQUAL-N457’ (seq 3104) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
386-396Nontaxable Combat Pay (Code Q)No negative amounts.
Right justify and zero fill.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
397-407BlankFill with blanks. Reserved for SSA use.
408-418Employer Cost of Premiums for Group Term Life Insurance Over $50,000 (Code C)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-C’ (seq 4020) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
419-429Income from the Exercise of Non-Statutory Stock Options (Code V)No negative amounts.
Right justify and zero fill.
Derived from the ‘W2-CODE-V’ (seq 4180) IDFDV Field Identifier.
Does not apply to Puerto Rico employees.
430-440Deferrals Under a Section 409A Non-Qualified Deferred Compensation Plan (Code Y)No negative amounts.
Right justify and zero fill.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
441-451Designated Roth Contributions to a Section 401 (k) Plan (Code AA)No negative amounts.
Right justify and zero fill.
Does not apply to Puerto Rico employees.
452-462Designated Roth Contributions to a Section 403 (b) Salary Reduction Agreement (Code BB)No negative amounts.
Right justify and zero fill.
Does not apply to Puerto Rico employees.
463-473Cost of Employer-Sponsored Health Coverage (Code DD)No negative amounts.
Right justify and zero fill.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
474-484Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)No negative amounts.
Right justify and zero fill.
485BlankFill with blanks. Reserved for SSA use.
486Statutory Employee IndicatorEnter "1" for statutory employee. Otherwise, enter "0" (zero).
Derived from the ‘W2-STAT-EE’ (seq 6000) IDFDV Field Identifier.
487BlankFill with blanks. Reserved for SSA use.
488Retirement Plan IndicatorEnter "1" for a retirement plan. Otherwise, enter "0" (zero).
Derived from the ‘W2-RETIRE-PLAN’ (seq 6020) IDFDV Field Identifier.
489Third-Party Sick Pay IndicatorEnter "1" for a sick pay indicator. Otherwise, enter "0" (zero). Derived from the ‘W2-3PARTY-SICK’ (seq 6060) IDFDV Field Identifier.
490-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RS - State Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RS - State Record#

ColumnDescriptionSource
1-2Record IdentifierConstant "RS"
3-4State CodeEnter the appropriate postal numeric code.
Derived from the State being reported.
5-9Taxing Entity CodeDefined by State/local agency.
10-18Social Security NumberEnter the employee's SSN. If no SSN is available, enter zeros.
Derived from the ‘W2-EE-SSN’ IDFDV Field Identifier.
19-33Employee First NameEnter the employee's first name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-FIRST-NAME’ IDFDV Field Identifier.
34-48Employee Middle Name or InitialIf applicable, enter the employee's middle name or initial.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-MIDDLE’ IDFDV Field Identifier.
49-68Employee Last NameEnter the employee's last name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-LAST-NAME’ IDFDV Field Identifier.
69-72Employee SuffixIf applicable, enter the employee's alphabetic suffix.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-SUFFIX’ IDFDV Field Identifier.
73-94Employee Location AddressEnter the employee's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the ‘W2-EE-LOCN-ADDR’ IDFDV Field Identifier.
95-116Employee Delivery AddressEnter the employee's delivery address.
Left justify and fill with blanks.
Derived from the ‘W2-EE-DELIV-ADDR’ IDFDV Field Identifier.
117-138Employee CityEnter the employee's city.
Left justify and fill with blanks.
Derived from the 'W2-EE-CITY’ IDFDV Field Identifier.
139-140Employee State AbbreviationEnter the employee's State or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-STATE’ IDFDV Field Identifier.
141-145Employee ZIP CodeEnter the employee's ZIP Code.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-ZIP’ IDFDV Field Identifier.
146-149Employee ZIP Code ExtensionEnter the employee's four-digit extension of the ZIP code. If not applicable, fill with blanks.
Derived from the ‘W2-EE-ZIP-EXT’ IDFDV Field Identifier.
150-154BlankFill with blanks. Reserved for SSA use.
155-177Foreign State/ProvinceIf applicable, enter the employee's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
178-192Foreign Postal CodeIf applicable, enter the employee's foreign postal code.
Left justify and fill with blanks. Otherwise, fill with blanks.
193-194Country CodeIf one of the following applies, fill with blanks:

* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
Locations 195 to 267
Apply to Quarterly Unemployment Reporting
If the user has defined ‘Period Type’ as ‘Quarter’, then Locations 195 to 267 will be filled.
Please read the document Tax Reporting - US General for details on quarterly reporting.

195-196Optional CodeDefined by State/local agency.
Applies to unemployment reporting.
197-202Reporting PeriodEnter the last month and four-digit year for the calendar quarter that this report applies.
Applies to unemployment reporting.
203-213State Quarterly Unemployment Insurance Total WagesRight justify and zero fill.
Applies to unemployment reporting.
214-224State Quarterly Unemployment Insurance Total Taxable WagesRight justify and zero fill.
Applies to unemployment reporting.
225-226Number of Weeks WorkedDefined by State/local agency.
Applies to unemployment reporting.
227-234Date First EmployedEnter the month, day and four-digit year.
Applies to unemployment reporting.
235-242Date of SeparationEnter the month, day and four-digit year.
Applies to unemployment reporting.
243-247BlankFill with blanks. Reserved for SSA use.
248-267State Employer Account NumberEnter the State's Employer Account Number.
Applies to unemployment reporting.
268-273BlankFill with blanks. Reserved for SSA use.
Locations 274 to 337
Apply to Income Tax Reporting
If the user has defined ‘Period Type’ as ‘Quarter’ or ‘Year’, then Locations 274 to 337 will be filled.

274-275State codeEnter the appropriate postal numeric code.
Derived from the State being reported.
Applies to income tax reporting.
276-286State Taxable WagesRight justify and zero fill.
Derived from the ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ IDFDV Field Identifiers.
Applies to income tax reporting.
287-297State Income Tax WithheldRight justify and zero fill.
Derived from the ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’ IDFDV Field Identifiers.
Applies to income tax reporting.
298-307Other State DataDefined by State/local agency.
Applies to income tax reporting.
308Tax Type CodeEnter the appropriate code for entries in fields 309-330:
* C = City Income Tac
* D = County Income Tax
* E = School District Income Tax
* F = Other Income Tax.
Applies to income tax reporting.
309-319Local Taxable WagesTo be defined by State/local agency.
Applies to income tax reporting.
320-330Local Income Tax WithheldTo be defined by State/local agency.
Applies to income tax reporting.
331-337State Control NumberOptional.
Applies to income tax reporting.
338-412Supplemental Data 1To be defined by user.
413-487Supplemental Data 2To be defined by user.
488-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RT - Total Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RT - Total Record #

ColumnDescriptionSource
1-2Record IdentifierConstant "RT"
3-9Number of RW RecordsTotal number of "RW" records reported since last "RE" record.
Right justify and zero fill.
10-24Wages, Tips and Other CompensationTotal of all "RW" records since last "RE" record.
Right justify and zero fill.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands emplyees.
Derived from IDFDV Field Identifier: ‘W2-FIT-WAGE’
25-39Federal Income Tax WithheldTotal of all "RW" records since last "RE" record.
Right justify and zero fill.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands emplyees.
Derived from IDFDV Field Identifier: ‘W2-FIT-TAX’
40-54Social Security WagesTotal of all "RW" records since last "RE" record.
Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-WAGE’
55-69Social Security Tax WithheldTotal of all "RW" records since last "RE" record.
Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-TAX’
70-84Medicare Wages and TipsTotal of all "RW" records since last "RE" record.
Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "X-Railroad".
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-MEDI-WAGE’
85-99Medicare Tax WithheldTotal of all "RW" records since last "RE" record.
Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "X-Railroad".
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-MEDI-TAX’
100-114Social Security TipsTotal of all "RW" records since last "RE" record.
Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-TIP’
115-129BlankFill with blanks. Reserved for SSA use.
130-144Dependent Care BenefitsTotal of all "RW" records since last "RE" record.
Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-DEP-CARE’
145-159Deferred Compensation Contributions to
Section 401(k) (Code D)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-D’
160-174Deferred Compensation Contributions to
Section 403(b)(Code E)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-E’
175-189Deferred Compensation Contributions to
Section 408(k)(6) (Code F)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-F’
190-204Deferred Compensation Contributions to
Section 457(b) (Code G)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-G’
205-219Deferred Compensation Contributions to
Section 501(c)(18)(D) (Code H)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-H’
220-234BlankFill with blanks. Reserved for SSA use.
235-249Nonqualified Plan Section 457 Distributions or ContributionsTotal of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-NQUAL-457’
250-264Employer Contribution to a Health Savings Account
(Code W)
Total of all "RW" records since last "RE" record.
No negative amounts.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-W’
265-279Nonqualified Plan Not Section 457 Distributions or ContributionsTotal of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-NQUAL-N457’
280-294Nontaxable Combat Pay (Code Q)Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
Right justify and zero fill.
295-309Cost of Employer-Sponsored Health Coverage
(Code DD)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
Right justify and zero fill.
310-324Employer Cost of Premiums for Group Term Life Insurance over $50,000 (Code C)Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-C’
325-339Income Tax Withheld by Payer of Third-Party Sick PayTotal of all "RW" records since last "RE" record.
Total Federal Income Tax withheld by third-parties (generally insurance companies) from sick or disability payments made to your employees.
Does not apply to Puerto Rico employees.
Derived from IDFDV Field Identifier: ‘SUB-3RD-PARTY-TAX’
340-354Income from the Exercise of Non-statutory Stock Options (Code V)Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-V’
355-369Deferrals Under a Section 409A Nonqualified Deferred Compensation Plan (Code Y)Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico or Northern Mariana Islands employees.
Right justify and zero fill.
370-384Designated Roth Contributions to a Section
401(k) Plan (Code AA)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
385-399Designated Roth Contributions to a Section
403(b) Salary Reduction Agreement (Code BB)
Total of all "RW" records since last "RE" record.
Does not apply to Puerto Rico employees.
Right justify and zero fill.
400-414Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)Total of all "RW" records since last "RE" record.
Right justify and zero fill.
415-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RV – State Total Record (Specific to the State of Minnesota#

ColumnDescriptionSource
1-2Record IdentifierConstant "RV"
3-29Not used by Department of RevenueFill with blanks
30-36Total RS RecordsTotal number of RS Records since the last RE record, regardless of State code. Right justify and fill.
37-72Not used by Department of RevenueFill with blanks
73-87State Taxable WagesTotal of all RS records since the last RE record, regardless of the State code. Right justify and fill.
88-102State Income Tax WithheldTotal of all RS records since the last RE record, regardless of the State code. Right justify and fill.
103-133 Not used by Department of RevenueFill with blanks
134-512BlankFill with blanks

Record Name: Code RF - Final Record#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RF - Final Record#

ColumnDescriptionSource
1-2Record IndentifierConstant "RF"
3-7BlankFill with blanks. Reserved for SSA use
8-16Number of RW RecordsTotal number of RW (Employee) Records reported on the entire file.
Right justify and zero fill
17-512BlankFill with blanks. Reserved for SSA use

Quarterly UI Wage Reporting - EFW2 Format #

RPYEU must be run with the following report parameters and filters selected to generate the Minnesota State quarterly file information.
* RPYEU will generate the Minnesota State Quarterly EFW2 File Format according to the State specifications

RPYEU Report Parameters

Annual Form CodeUse standard form code, such as 'HL$US-W2-20YY'
Quarterly Form CodeUse the standard form code ‘HL$US-QTR-20YY.
Must be entered in order to generate the STATE UI wage file in the ICESA format
Govt Interface FormatMandatory. Enter HL$US-QTR-MM20YY
Period TypeMandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
Period End DateMandatory. Defines the end date of the reporting period. Enter in DD-MMM-YYYY format
As of DateThis date is used to retrieve employee information such as name, address, etc.
Combine Employment TypeSet to ‘Yes’ since Code RE records are not reported by ‘Employment Type’
Media FormatMandatory. Set to State SUI File Format
Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
Directory Name Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
Media File NameMandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced

RPYEU Report Filters

Select State: Minnesota, USA
Federal Regist Number: Enter the Federal Registration Number

RPYEU Run Options

Sort by Level: Must enter ‘DEPT SUI ER Number’ for Minnesota
Provide Sort Level Totals: Optional. When set to YES, the totals are generated by ‘DEPT SUI ER Number’

Please enter other prompts accordingly.

Record Name: Code RS - State Record#

NOTE: All record locations designated by “MN” are read by the Minnesota Department of Economic Security.
ColumnDescriptionSource
1-2 MNRecord IdentifierConstant "RS"
3-4 MNState codeEnter the appropriate FIPS postal numeric code. Minnesota's code is ‘27’
Derived from the state being reported, from IDFDV sequence 7000
5-9BlankFill with blanks
10-18 MNSocial Security NumberEnter the employee’s full nine-digit SSN.
If not known, enter ‘I’ in position 2 and fill with blanks
If an invalid SSN is encountered, this field is entered with zeroes
Derived from IDFDV Field Identifier: ‘W2-EE-SSN’
19-33 MNEmployee First NameEnter the employee's last name.
Derived from IDFDV Field Identifier: ‘W2-EE-LAST-NAME’
34-48 MNEmployee Middle Name or InitialEnter the employee's middle initial, if applicable. Leave blank if no middle initial
Derived from IDFDV Field Identifier: ‘W2-EE-MIDDLE’
49-68 MNEmployee Last NameEnter the employee's last name.
Derived from IDFDV Field Identifier: ‘W2-EE-LAST-NAME’
69-72Employee SuffixEnter the employee's suffix
Derived from IDFDV Field Identifier: ‘W2-EE-SUFFIX’
73-94Employee Location AddressEnter the employee's location address
Derived from IDFDV Field Identifier: ‘W2-EE-LOCN-ADDR’
95-116Employee Delivery AddressEnter the employee's delivery address
Derived from IDFDV Field Identifier: ‘W2-EE-DELIV-ADDR’
117-138Employee CityEnter the employee's city
Derived from IDFDV Field Identifier: ‘W2-EE-CITY’
139-140Employee State AbbreviationEnter the employee's State abbreviation
Derived from IDFDV Field Identifier: ‘W2-EE-STATE’
141-145Employee ZIP CodeEnter the employee's zip code
Derived from IDFDV Field Identifier: ‘W2-EE-ZIP’
146-149Employee ZIP Code ExtensionEnter the employee's zip code extension
Derived from IDFDV Field Identifier: ‘W2-EE-ZIP-EXT’
150-154BlankFill with blanks
155-177Employee Foreign State/ProvinceEnter the employee's Foreign State/Province, if applicable
Derived from IDFDV Field Identifier: ‘W2-EE-F-STATE’
178-192Employee Foreign Postal CodeEnter the employee's Foreign postal code, if applicable
Derived from IDFDV Field Identifier: ‘W2-EE-F-POSTAL’
193-194Employee Country CodeEnter the employee's Country code, if applicable
Derived from IDFDV Field Identifier: ‘W2-EE-COUNTRY’
195-196OptionalFill with blanks
197-202 MNReporting PeriodDerived from the user defined Period End Date converted to MMYYYY for the reporting quarter.
Example: If Period End Date = ‘31-Mar-YYYY’, then reporting period is ‘03YYYY’
203-213 MNState Quarterly Unemployment Insurance Total (gross) WagesEnter the total State quarterly UI gross wages.
Derived from IDFDV Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
NOTE: The IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Symmetry during the US Tax calculation, UPCALC. For employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. RPYEU will then use the State Taxable wages from the ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Identifiers, that are related to the employee's Home GEO and Work GEO code, to report SUI Total Wages
214-224State Quarterly Unemployment Insurance Taxable WagesEnter the total State quarterly UI taxable wages.
Derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government.

Please see example below for calculation details.
225-226Number of Weeks WorkedTotal number of weeks worked.
From the system derived number of Weeks Worked for the Reporting State

The system reads all Pay Headers with the pay category defined as ‘Regular Pay’, that are not reversed, with a Pay Issue Date that falls within the user defined Quarter begin and end dates.
If the Pay Header’s Work State or Home State is the same as the reporting State, then the Pay Header's Tax Weeks are accumulated into this field.
227-234Date First EmployedFrom the system derived latest Employment Hired Date, in MMDDYYYY format
235-242Date of SeparationEnter the employee's separation date, in MMDDYYYY format
If this employee’s Probationary Code = ‘01’, (from IEID User Field ‘MMREF PROBATIONARY’), then this field contains the employee’s termination date. Otherwise fill with zeros
243-247BlankFill with blanks
248-259 MNMN State Unemployment Insurance Account Number and MN Employer Unit NumberThis field is derived from IDDP, UDF ‘SUI ER Number’ field according to the employee’s Prime Assignment Detail Department, that is effective as of the period end date
*If ‘DEPT SUI ER Number’ = 7977999-004, then ‘-’ will be replaced with zeroes
*If ‘DEPT SUI ER Number’ is not defined for a department, then the IDGV SUI ER Number is used
260-260 MNMonth-1 EmploymentEnter ‘1’ if the employee was covered by UI, and worked or received pay, for the pay period including the 12th day of the first reporting month. Otherwise enter ‘0’
261-261 MNMonth-2 EmploymentEnter ‘1’ if the employee was covered by UI, and worked or received pay, for the pay period including the 12th day of the second reporting month. Otherwise enter ‘0’
262-262 MNMonth-3 EmploymentEnter ‘1’ if the employee was covered by UI, and worked or received pay, for the pay period including the 12th day of the third reporting month. Otherwise enter ‘0’
263-273BlankFill with blanks
274-275State codeEnter the appropriate FIPS postal numeric code. Minnesota's code is "27"
Derived from the State being reported
276-286State Taxable WagesEnter the total State taxable wages
Derived from IDFDV Field Identifier: ‘W2-STATE-WAGE-HOME’ and ‘W2-STATE-WAGE-WORK’
287-297State Income Tax WithheldEnter the total State income tax withheld
Derived from IDFDV Field Identifier: ‘W2-STATE-TAX-HOME’ and ‘W2-STATE-TAX-WORK’
298-337BlankFill with blanks
338-340 MNHours WorkedEnter the total hours worked
Derived from IDFDV Field Identifier: ‘W2-SUI-HRS-WRK’
341 MNOfficer CodeEnter the appropriate Officer Code
Derived from IEID UDF ‘MMREF Officer Code’ if defined. Otherwise, fill with blank
342-511BlankFill with blanks
512-512 MNConstant ‘X’Recommended for Minnesota State process only

Calculate State SUI Taxable Wages, Excess Wages#

All wages paid to an employee up to the SUI Wage Base Amount are taxable for SUI purposes.
When an employee’s State Taxable earnings exceed the SUI Wage Base for a calendar year, then the exceeded portion of the earnings are considered as SUI Excess Wages and are not taxable for SUI purposes.

Some states require to report the following 3 items:

  1. State Quarterly Unemployment Insurance Total Wages
    • This is the State Gross wages paid to an employee for the quarter, less 125 Plan contributions and/or 401 exemptions
    • The Total Wages are retrieved from the IDFDV ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Identifiers
    • NOTE: the IDFDV ‘W2-SUI-WAGE-ER’ Identifier is not used to report this field because the value of the ‘W2-SUI-WAGE-ER’ Identifier may have already been capped by Symmetry during the US Tax calculation process, UPCALC. Therefore, for employees who exceed the maximum wage base, the ‘W2-SUI-WAGE-ER’ field will contain no SUI Insurance wages.
      *RPYEU will use the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee's Home GEO and Work GEO codes to derive the SUI Total Wages
  2. SUI Excess Wages
    • This is the SUI Total wages paid to an employee in the reporting quarter that are in excess of the SUI Wage Base
      Example: Employee SUI Total Wages for the quarter: $8500
      Maximum SUI Wage Base: $7000
      Therefore, SUI Excess Wages: $1500
  3. State Quarterly Unemployment Insurance Taxable Wages
    • This is the SUI Total wages that does not exceed the SUI Wage Base Amount for the calendar year
      Example: Employee SUI Total Wages for the quarter: $8500
      Maximum SUI Wage Base: $7000
      SUI Excess Wages: $1500
      SUI Excess Wages = Employee SUI Total Wages – SUI Excess Wages
      SUI Excess Wages = $8500 – $1500 = $7000

Example – SUI Taxable Wages, SUI Excess Wages Calculation#

Quarter 1Person Code: 1000Person Code: 1001Total this Quarter for all Employees
Total Wages for the Quarter$9000$3000$12000
SUI Excess of Wage Base
(Year 2000 Wage Base $7000)
YTD Wages – Wage Base:
$9000 – $7000, up to max of current quarter Wages
= $2000
YTD Wages – Wage Base: $3000 – $7000, up to max of current quarter Wages
= $0
$2000
SUI Taxable WagesTotal Wages – Excess Wage:
$9000 - $2000
= $7000
Total Wages – Excess Wage
= $3000 - $0
= $3000
$10000

Quarter 2Person Code: 1000Person Code: 1001Total this Quarter for all Employees
Total Wages for the Quarter$9000$3000$12000
SUI Excess of Wage Base
(Year 2000 Wage Base $7000)
YTD Wages – Wage Base:
$18000 – $7000, up to max of current quarter Wages
= $9000
YTD Wages – Wage Base:
$6000 – $7000, up to max of current quarter wages
$0
$9000
SUI Taxable WagesTotal Wages – Excess Wage:
$9000 - $9000
= $0
Total Wages – Excess Wage
= $3000 - $0
= $3000
$3000

Quarter 3Person Code: 1000Person Code: 1001Total this Quarter for all Employees
Total Wages for the Quarter$9000$3000$12000
SUI Excess of Wage Base
(Year 2000 Wage Base $7000)
YTD Wages – Wage Base:
$27000 – $7000, up to max of current quarter Wages
= $9000
YTD Wages – Wage Base:
$9000 – $7000, up to max of current quarter Wages
= $2000
$11000
SUI Taxable WagesTotal Wages – Excess Wage:
$9000 - $9000
= $0
Total Wages – Excess Wage
= $3000 - $2000\= $1000
$1000

Quarter 4Person Code: 1000Person Code: 1001Total this Quarter for all Employees
Total Wages for the Quarter$9000$3000$12000
SUI Excess of Wage Base
(Year 2000 Wage Base $7000)
YTD Wages – Wage Base:
$36000 – $7000 up to max of current quarter Wages
= $9000
YTD Wages – Wage Base:
$12000 – $7000, up to max of current quarter Wages
= $3000
$12000
SUI Taxable WagesTotal Wages – Excess Wage:
$9000 - $9000
= $0
Total Wages – Excess Wage
= $3000 - $3000
= $0
$0

Month1, Month2, Month3 Employment Processing#

The State of Minnesota requires the reporting of the Month1, Month2, Month3 Employment for the employer.

Each Month requires the reporting of the total number of employees, full time and part time, who worked during or received pay subject to UI wages, for the payroll period that includes the 12th day of the first month of the reporting period.

The following logic is used to retrieve each Month’s Employment information:

  • From the user-specified Quarter Ending date, determine the First Month Date that includes the 12th of the month
    Example: Quarter Ending Date Mar-31-YYYY, then the First Month Date is Jan-12-YYYY
  • Determine the Payroll Period that the First Month Date ‘Jan-12-YYYY’ falls within the reporting period Start and End dates
    Example: For Jan-12-YYYY, falls into Period YYYY02, with Period Start date Dec-30-YYYY and End date Jan-13-YYYY
  • For each employee, read the Pay Headers for the First Month Period that have the Pay Stage defined as ‘70’ or ‘80’
  • With each Pay Header that qualifies, retrieve the amount according to IDFDV ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ values to determine if the employee has wages that are subject to UI
  • As long as an employee has one pay header that qualifies and has UI wages, the employee is counted for that Month of Employment
  • The above logic is repeated for the Second Month and Third Month of the reporting quarter

Notes#

Click to create a new notes page