Table of Contents
- Connecticut Annual and Quarterly Reporting
- Set Up
- IDGV - State Registration
- State File Procedures
- Annual W2 Wage Reporting – EFW2 Format
- State Media Magnetic Media Reporting – EFW2 Format
- Record Name: Code RA - Transmitter Record
- Record Name: Code RE - Employer Record
- Record Name: Code RS - State Record
- Record Name: Code RT - Total Record
- Record Name: Code RF - Final Record
- Quarterly UI Wage Reporting – ICESA Format
- Record Name: Code E - Employer Record
- Record Name: Code S - Supplemental Record
- Record Name: Code F - Final Record
- Notes
Connecticut Annual and Quarterly Reporting#
Set Up#
This document contains abbreviated set up requirements for the State of Connecticut only. Please refer to the general document Tax Reporting - US General for other setup procedures that may also be required.IDGV - State Registration#
- The IDGV Definition tab must be set up for ‘State Registration’ for State/Province: Connecticut.
- The IDGV Variables tab must be set up for ‘State Registration’ for State/Province: Connecticut.
- ‘W2 STATE MEDIA FILING’ must be ‘02’ to generate CT State magnetic media file for CT State only.
State File Procedures#
- The Connecticut Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 file format, and the filing of Quarterly UI wages via magnetic media using the ICESA format.
- Record Codes required for the W2 reporting are Code RA, RE, RS, RT, RF. Record Codes E, S and F are required for UI wage reporting.
- Connecticut State requires to file the CT State file by itself, therefore IDGV must be set up as follows:
- for State Registration of Connecticut, the IDGV Variable:
- ‘W2 STATE MEDIA FILING’ 02 – State requires its own file, do not include other State information in the State file
- for State Registration of Connecticut, the IDGV Variable:
Annual W2 Wage Reporting – EFW2 Format#
RPYEU must be run with the following report parameters and filters defined to generate the Connecticut State file information:RPYEU Report Parameters
| Annual Form Code | Use standard form code, such as 'HL$US-W2-YYYY' |
| Period Type | Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting. |
| Period End Date | Mandatory. Defines the end date of the reporting period. |
| Media Format | Mandatory. 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 Name | Mandatory. 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: Connecticut, USA |
State Media Magnetic Media Reporting – EFW2 Format#
Record Name: Code RA - Transmitter Record#
| Column | Description | Source |
|---|---|---|
| 1-2 | Record Identifier | Constant "RA" |
| 3-11 | Submitter’s Employer ID number (EIN) | Enter the submitter’s FEIN. Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000) |
| 12-19 CT | User Identification | Enter the User Identification |
| 20-23 CT | Software Vendor Code | Not Required by the State of Connecticut. Fill with blanks |
| 24-28 CT | Blank | Not Required by the State of Connecticut. Fill with blanks |
| 24-28 CT | Not Required | |
| 29 CT | Resub Indicator | Enter “1” if a file is being resubmitted. Otherwise, fill with blanks |
| 30-35 CT | Resub WFID | If you entered “1” in the Resub Indicator field (location 29), enter the word “AMEND”. Otherwise, Fill with blanks |
| 36-37 CT | Software Code | Not Required by the State of Connecticut. Fill with blanks |
| 38-94 | Company Name | Enter the name of the company to receive EFW2 annual filing instructions. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-NAME’ (seq 1050) |
| 95-116 | Location Address | Enter the company’s location address (attention, suite, room number, etc. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-LOCN’ (seq 1060) |
| 117-138 | Delivery Address | Enter the company’s delivery address (street or post office box). Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-DELIV’ (seq 1070) |
| 139-160 | City | Enter the company’s city. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-CITY’ (seq 1080) |
| 161-162 | State Abbreviation | Enter the company’s state. Use a standard postal abbreviation. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-STATE’ (seq 1090) |
| 163-167 | ZIP Code | Enter the company’s ZIP code. For a foreign address, fill with blanks. Derived from IDFDV Field Identifier: ‘SUB-COMP-ZIP’ (seq 1100) |
| 168-171 | ZIP Code Extension | Enter the company’s four-digit extension of the ZIP code. If not applicable, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-ZIP-EXT’ (seq 1110) |
| 172-176 | Blank | Fill with blanks |
| 177-199 | Foreign State/Province | If applicable, enter the company’s foreign state or province. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-F-STATE’ (seq 1120) |
| 200-214 | Foreign Postal Code | If applicable, enter the company’s foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130) |
| 215-216 | Country Code | Enter the applicable country code. Derived from IDFDV, Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140) |
| 217-273 | Submitter Name | Enter the name of the organization submitting this file. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150) |
| 274-295 | Submitter Location Address | Enter the location address of the organization submitting this file. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160) |
| 296-317 | Submitter Street Address | Enter the street address of the submitter (street or post office box). Derived from IDFDV, Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170) |
| 318-339 | Submitter City | Enter the submitter’s city. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180) |
| 340-341 | Submitter State Abbreviation | Enter the submitter’s state. Use a standard postal abbreviation for a foreign address and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190) |
| 342-346 | Submitter ZIP Code | Enter the submitter’s ZIP code. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200) |
| 347-350 | Submitter ZIP Code Extension | Enter the submitter’s four-digit extension of the ZIP code. If not applicable, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210) |
| 351-355 | Blank | Fill with blanks |
| 356-378 | Submitter Foreign State/Province | If applicable, enter the submitter's foreign state or province. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220) |
| 379-393 | Submitter Foreign Postal Code | If applicable, enter the submitter's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230) |
| 394-395 | Submitter Country Code | Enter the applicable country code. Derived from IDFDV, Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240) |
| 396-422 | Contact Name | Enter the name of the person to be contacted by DRS concerning processing problems. Derived from IDFDV, Field Identifier: ‘SUB-CONT-NAME’ (seq 1250) |
| 423-437 | Contact Phone Number | Enter the contact’s telephone number (including area code). Left Number justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-CONT-TEL’ (seq 1260) |
| 438-442 | Contact Phone Extension | Enter the contact’s telephone extension. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270) |
| 443-445 | Blank | Fill with blanks |
| 446-485 | Contact E-mail | Required. Enter the contact’s electronic mail or Internet address. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280) |
| 486-488 | Blank | Fill with blanks |
| 489-498 | Contact FAX | For U.S. and U.S. Territories only: If applicable, enter the contact’s FAX number (including area code). Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘SUB-CONT-FAX’ (seq 1290) |
| 499 | Preferred Method of Problem Notification Code | Not Required by the State of Connecticut. Fill with blanks |
| 500 | Preparer Code | Not Required by the State of Connecticut. Fill with blanks |
| 501-512 | Blank | Fill with blanks |
Record Name: Code RE - Employer Record#
| Column | Description | Source |
|---|---|---|
| 1-2 | Record Identifier | Constant "RE" |
| 3-6 | Tax year YYYY | Required. Enter the reporting year. From user specified FROM-TO period converted to YYYY |
| 7 CT | Agent Indicator Code | Not Required by the State of Connecticut. Fill with blanks |
| 8-16 | Employer's Identification Number EIN | Enter only numeric characters. Omit hyphens, prefixes and suffixes. System derived the applicable Federal reporting EIN, from IDGV or IDGR |
| 17-39 CT | Not Required by the State of Connecticut. Fill with blanks | |
| 40-96 | Employer Name | Derived from IDFDV, Field Identifier: ‘W2-ER-NAME’ (seq 2010) |
| 97-118 | Employer Location Address | Enter the employer's location address (attention, suite, room number, etc. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020) |
| 119-140 | Employer Delivery Address | Enter the employer's delivery address (street or post office box). Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030) |
| 141-162 | Employer City | Enter the employer's city. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-CITY’ (seq 2040) |
| 163-164 | Employer State Abbreviation | Enter the employer's state. Use a standard postal abbreviation. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-STATE’ (seq 2050) |
| 165-169 | Employer ZIP Code | Enter the employer's ZIP code. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP’ (seq 2060) |
| 170-173 | Employer ZIP Code Extension | Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070) |
| 174-178 | Kind of Employer | Enter the Kind of Employer as entered on the file submitted to the SSA. Left justify and fill with blanks. |
| 179-201 | Employer Foreign State/Province | If applicable, enter the employer’s foreign state or province. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-F-STATE’ (seq 2080) |
| 202-216 | Employer Foreign Postal Code | If applicable, enter the employer’s foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090) |
| 217-218 | Country Code | Enter the applicable country code. Derived from IDFDV, Field Identifier ‘W2-ER-COUNTRY’ (seq 2100) |
| 219 CT | Employment Code | Not Required by the State of Connecticut. Fill with blanks |
| 220 | Tax Jurisdiction Code | Enter the Tax Jurisdiction Code |
| 221-318 | Blank | Fill with blanks |
| 319-512 | Fill with blanks. Reserved for SSA use. |
Record Name: Code RS - State Record#
Specific to the State of Conneticut| Column | Description | Source |
|---|---|---|
| 1-2 | Record Identifier | Constant "RS" |
| 3-4 | State code | Enter the appropriate FIPS postal numeric code. Connecticut is code "09". System derived from the State being reported |
| 5-9 | Taxing Entity Code | Not required |
| 10-18 | Social Security Number | Derived from IDFDV, Field Identifier: ‘W2-EE-SSN’ If an invalid SSN is encountered, this field is entered with zeroes. |
| 19-33 | Employee First Name | Derived from IDFDV, Field Identifier: ‘W2-EE-FIRST-NAME’ |
| 34-48 | Employee Middle Name or Initial | Derived from IDFDV, Field Identifier: ‘W2-EE-MIDDLE’ |
| 49-68 | Employee Last Name | Derived from IDFDV, Field Identifier: ‘W2-EE-LAST-NAME’ |
| 69-72 | Employee Suffix | Derived from IDFDV, Field Identifier: ‘W2-EE-SUFFIX’ |
| 73-94 | Employee Location Address | Enter the employee's location address (attention, suite, room number, etc. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: W2-EE-LOCN-ADDR |
| 95-116 | Employee Delivery Address | Enter the employee's delivery address (street or post office box). Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-DELIV-ADDR’ |
| 117-138 | Employee City | Enter the employee's city. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-CITY’ |
| 139-140 | Employee State Abbreviation | Enter the employee's state. Use a standard postal abbreviation. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-STATE’ |
| 141-145 | Employee ZIP Code | Enter the employee's ZIP code. For a foreign address, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-ZIP’ |
| 146-149 | Employee ZIP Code Extension | Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-ZIP-EXT’ |
| 150-154 | Blank | |
| 155-177 | Employee Foreign State/Province | If applicable, enter the employee’s foreign state or province. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-F-STATE’ |
| 178-192 | Employee Foreign Postal Code | If applicable, enter the employee’s foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-EE-F-POSTAL’ |
| 193-194 | Employee Country Code | Enter the applicable country code. Derived from IDFDV, Field Identifier: ‘W2-EE-COUNTRY’ |
| 195-247 CT | Not Required | Fill with blanks |
| 248-267 | State Employer Account Withholding Number | Enter the 9-digit Connecticut Withholding Tax number FEIN. Left justify and fill with blanks. Derived from IDFDV, Field Identifier: ‘W2-STATE-REGIST’ for the reporting State |
| 268-273 | Blank | Fill with blanks |
| 274-275 | State code | Enter the appropriate FIPS postal numeric code. Connecticut is code "09" System derived from the State being reported |
| 276-286 | State Taxable Wages | Required. Right justify and zero fill. Derived from IDFDV, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ |
| 287-297 | State Income Tax Withheld | Required. Right justify and zero fill. Derived from IDFDV, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’ |
| 298-487 CT | Not required | Fill with blanks |
| 488-512 | Blank | Fill with blanks |
Record Name: Code RT - Total Record#
| Column | Description | Source |
|---|---|---|
| 1-2 | Record Identifier | Constant "RT" |
| 3-9 | Number of Employees | Enter the total number of RS records reported since the last code RE record. Right justify and zero fill. System derived number of all Code RS records on the entire file |
| 10-24 | State Taxable Wages | Enter the total for all code RS records reported since the last code RE record. Right justify and zero fill. System derived Total State Taxable Wages of all Code RS records on the entire file |
| 25-39 | State Income Tax Withheld | Enter the total for all code RS records reported since the last code RE record. Right justify and zero fill. System derived Total State Taxes of all Code RS records on the entire file |
| 40-512 | Blank |
Record Name: Code RF - Final Record#
| Column | Description | Source |
|---|---|---|
| 1-2 | Record Identifier | Constant "RF" |
| 3-11 | Number of Employees | Enter the total number of code RS records recorded on the entire file. System derived number of all Code RS records on the entire file |
| 12-27 | State Taxable Wages | Enter the grand total of all code RS records on this file. Right justify and zero fill. System derived Total State Taxable Wages of all Code RS records on the entire file |
| 28-43 | State Income Tax Withheld | Enter the grand total of all code RS records on this file. Right justify and zero fill. System derived Total State Taxes of all Code RS records on the entire file |
| 44-512 | Blank |
Quarterly UI Wage Reporting – ICESA Format#
RPYEU must be run with the following report parameters and filters defined to generate the Connecticut State file information:RPYEU Report Parameters
| Quarterly Form Code | Mandatory. Quarterly Form Code HL$US-W2-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. |
| Period Type | Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting. |
| Period End Date | Mandatory. Defines the end date of the reporting period. |
| Media Format | Mandatory. Enter 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 Name | Mandatory. 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: Connecticut, USA |
Record Name: Code E - Employer Record #
| Column | Description | Source |
|---|---|---|
| 1-1 | Record Identifier | Constant "E" |
| 2-3 CT | Quarterly Period | Enter the last month of the Quarter, such as 03, 06, 09 or 12 |
| 4-5 CT | Yearly Period | Required. Enter the last two digits of the reporting year. From user defined FROM-TO period converted to YY |
| 6-14 | Federal EIN | Enter the employer's Identification Number EIN. Enter only numeric characters. Omit hyphens, prefixes and suffixes. System derived the applicable Federal reporting EIN, from IDGV or IDGR |
| 15-23 CT | Reserved | Fill with blanks |
| 24-73 | Employer Name | Enter the name of the Employer Left justify and fill with blanks. Derived from the Entity |
| 74-113 | Street Address | Enter the employer's street address (attention, suite, room number, etc. Left justify and fill with blanks. Derived from the Entity Location |
| 114-138 | City | Enter the employer's city. Left justify and fill with blanks. Derived from the Entity Location |
| 139-148 | State Address | Enter the Postal Abbreviation of the State and fill with blanks. For a foreign address, fill with blanks. Derived from the Entity Location |
| 149 CT | Hyphen | Constant "-" |
| 150-153 | ZIP Code Extension | Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. Derived from the Entity Location |
| 154-158 | ZIP Code or Foreign Postal Code | Enter the employer's ZIP code. For a foreign address, fill with blanks. Derived from the Entity Location |
| 159-159 CT | Employee Name code | Enter Constant ‘S’ |
| 160 | Type of employment | Enter ‘A’ for Agriculture, ‘F’ for Federal Government, ‘H’ for Household, ‘M’ for Military, ‘X’ for Railroad, ‘R’ for Regular (all others) Derived from IDFDV, Field Identifier: ‘TYPE OF EMPLOYMENT’ |
| 161-162 | Blocking Factor | Fill with zeroes |
| 163-168 CT | Reserved | Fill with blanks |
| 169-170 CT | Connecticut FIPS Code | Constant ‘09’ |
| 171-175 CT | Reserved | Fill with blanks |
| 176-182 CT | CT Number | Enter the employer's Unemployment Compensation Number Derived from the IDGV State SUI Registration |
| 183-275 CT | Reserved | Fill with blanks |
| 276 CT | Special Use | Reserved, use only as instructed |
Record Name: Code S - Supplemental Record #
| Column | Description | Source |
|---|---|---|
| 1-1 | Record Identifier | Constant "S" |
| 2-10 | Employee SSN Number | Enter the employee’s social security number. If not known, fill with blanks Do not enter dashes or any other special characters |
| 11-37 CT | Employee Name | Enter the employee's last Name and first Name |
| 38-77 CT | Employee Address | Enter the employee's address |
| 78-102 CT | Employee City | Enter the employee's City |
| 103-112 CT | Employee State | Enter the employee's State |
| 113 CT | Hyphen | Constant "-" |
| 114-117 CT | Employee Zip Code Extension | Enter the employee's four-digit extension of the ZIP code. If not applicable, fill with blanks. Include hyphen ‘-‘ in position 113. |
| 118-122 CT | Employee Zip Code | Enter the employee's ZIP code. For a foreign address, fill with blanks. |
| 123 CT | Reserved | Fill with blanks |
| 124-125 CT | CT FIPS Code | Constant ‘09’ Enter the Connecticut Employer FIPS Code |
| 126-131 CT | Reserved | Fill with blanks |
| 132-140 CT | State Quarterly SUI Gross Wages | Enter the total quarterly gross wages subject to CT Unemployment Tax Derived from ‘SUI TOTAL WAGES’ |
| 141-149 CT | State Taxable Wages | Enter the total quarterly earnings subject to CT Unemployment Tax Derived from ‘SUI TOTAL WAGES’ |
| 150-275 CT | Reserved | Fill with blanks |
| 276 CT | Special Use | Reserved, use only as instructed |
Record Name: Code F - Final Record #
| Column | Description | Source |
|---|---|---|
| 1-1 | Record Identifier | Constant "F" |
| 2-8 CT | Number of employees | Total number of code "S" records on file |
| 9 CT | Reserved | Fill with blanks |
| 10-25 CT | Total Taxable Wages | Enter the total taxableble wages |
| 26 CT | Reserved | Fill with blanks |
| 27-42 CT | Total Excess Wages | Enter the total excess wages |
| 43 CT | Reserved | Fill with blanks |
| 44-59 CT | Total Gross Wages | Enter the total gross wages |
| 60 CT | Reserved | Fill with blanks |
| 61-71 CT | Remittance Amount | |
| 72-72 CT | Reserved | Fill with blanks |
| 73-77 CT | 1st Month Count | Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the first month in the Quarter falls |
| 78 CT | Reserved | Fill with blanks |
| 79-83 CT | 2nd Month Count | Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the second month in the Quarter falls |
| 84 CT | Reserved | Fill with blanks |
| 85-89 CT | 3rd Month Count | Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the third month in the Quarter falls |
| 90-276 CT | Reserved | Fill with blanks |
