This is version 1 2 3 4 5 6 7 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Colorado Annual and Quarterly Reporting#

What's New for Tax Year 2011#

There are no noted file format changes in wage reporting for tax year 2011 for the state of Connecticut.

Set Up#

This document contains abbreviated set up requirement for the specific state only, please refer to the general document (US_Annual_Qtrly_Reporting_GEN) for other setup procedure 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 (formerly MMREF1) 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; and for the UI wage reporting are: Codes ‘E’,’S’,’F’.
• 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

Annual W2 Wage Reporting – EFW2 (formerly MMREF-1) format#

RPYEU must be run and the following selected to generate Connecticut State file information:

Media Format:	State File Format
Select State:	Connecticut, USA

State Media Magnetic Media Reporting – EFW2 (Formerly MMREF1) Format#

Record Name: Code RA - Transmitter Record#

Column	Description	Source
1-2	Record Identifier	Constant "RA"
3-11	Submitter’s Employer ID number (EIN) Numeric only	Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
12-37 CT	Not Required by the state of Connecticut
38-94	Company Name	Derived from IDFDV, Field Identifier: ‘SUB-COMP-NAME’ (seq 1050)
95-116	Location Address	Derived from IDFDV, Field Identifier: ‘SUB-COMP-LOCN’ (seq 1060)
117-138	Delivery Address	Derived from IDFDV, Field Identifier: ‘SUB-COMP-DELIV’ (seq 1070)
139-160	Company City	Derived from IDFDV, Field Identifier: ‘SUB-COMP-CITY’ (seq 1080)
161-162	Company State Abbreviation	Derived from IDFDV, Field Identifier: ‘SUB-COMP-STATE’ (seq 1090)
163-167	Company ZIP code	Derived from v, Field Identifier: ‘SUB-COMP-ZIP’ (seq 1100)
168-171	Company ZIP code extension	Derived from IDFDV, Field Identifier: ‘SUB-COMP-ZIP-EXT’ (seq 1110)
172-176	Blank
177-199	Company Foreign State/Province	Derived from IDFDV, Field Identifier: ‘SUB-COMP-F-STATE’ (seq 1120)
200-214	Company Foreign Postal Code	Derived from IDFDV, Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
215-216	Company Country Code	Derived from IDFDV, Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
217-273	Submitter Name	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
274-295	Submitter Location Address	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
296-317	Submitter Delivery Address	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
318-339	Submitter City	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
340-341	Submitter State Abbreviation	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
342-346	Submitter ZIP code	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
347-350	Submitter ZIP code extension	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
351-355	Blank
356-378	Submitter Foreign State/Province	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
379-393	Submitter Foreign Postal Code	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
394-395	Submitter Country Code	Derived from IDFDV, Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
396-422	Contact Name	Derived from IDFDV, Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
423-437	Contact Phone Number	Derived from IDFDV, Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
438-442	Contact Phone Extension	Derived from IDFDV, Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
443-445	Blank
446-485	Contact E-mail	Derived from IDFDV, Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
486-488	Blank
489-498	Contact FAX	Derived from IDFDV, Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
499-500 CT	Not Required by the state of Connecticut
501-512	Blank

Record Name: Code RE - Employer Record#

Column	Description	Source
1-2	Record Identifier	Constant "RE"
3-6	Tax year CCYY	From user specified FROM-TO period converted to CCYY
7 CT	Not Required by the state of Connecticut
8-16	Employer/Agent EIN	System derived the applicable Federal reporting EIN, from IDGV or IDGR
17-39 CT	Not Required by the state of Connecticut
40-96	Employer Name	Derived from IDFDV, Field Identifier: ‘W2-ER-NAME’ (seq 2010)
97-118	Employer Location Address	Derived from IDFDV, Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
119-140	Employer Delivery Address	Derived from IDFDV, Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
141-162	Employer City	Derived from IDFDV, Field Identifier: ‘W2-ER-CITY’ (seq 2040)
163-164	Employer State Abbreviation	Derived from IDFDV, Field Identifier: ‘W2-ER-STATE’ (seq 2050)
165-169	Employer ZIP Code	Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
170-173	Employer ZIP Code Extension	Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
174-178	Blank
179-201	Employer Foreign State/Province	Derived from IDFDV, Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
202-216	Employer Foreign Postal Code	Derived from IDFDV, Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
217-218	Country Code	Derived from IDFDV, Field Identifier ‘W2-ER-COUNTRY’ (seq 2100)
219-221 CT	Not Required by the state of Connecticut
222-512	Blank

Record Name: Code RS - State Record#

Column	Description	Source
1-2	Record Identifier	Constant "RS"
3-4	State code, appropriate FIPS postal numeric code	system Derived from the State being reported e.g. Connecticut is code "09"
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	Derived from IDFDV, Field Identifier: ‘W2-EE-LOCN-ADDR’
95-116	Employee Delivery Address	Derived from IDFDV, Field Identifier: ‘W2-EE-DELIV-ADDR’
117-138	Employee City	Derived from IDFDV, Field Identifier: ‘W2-EE-CITY’
139-140	Employee State Abbreviation	Derived from IDFDV, Field Identifier: ‘W2-EE-STATE’
141-145	Employee ZIP Code	Derived from IDFDV, Field Identifier: ‘W2-EE-ZIP’
146-149	Employee ZIP Code Extension	Derived from IDFDV, Field Identifier: ‘W2-EE-ZIP-EXT’
150-154	Blank
155-177	Employee Foreign State/Province Not read by PA Revenue	Derived from IDFDV, Field Identifier: ‘W2-EE-F-STATE’
178-192	Employee Foreign Postal Code Not read by PA Revenue	Derived from IDFDV, Field Identifier: ‘W2-EE-F-POSTAL’
193-194	Employee Country Code Not read by PA Revenue	Derived from IDFDV, Field Identifier: ‘W2-EE-COUNTRY’
195-247 CT	Not Required by the state of Connecticut
248-267	State Employer Account Number	Derived from IDFDV, Field Identifier: ‘W2-STATE-REGIST’ for the reporting State
268-273	Blank
274-275	State code, appropriate FIPS postal numeric code	system Derived from the State being reported e.g. Connecticut is code "09"
276-286	State Taxable Wages	Derived from IDFDV, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
287-297	State Income Tax Withheld	Derived from IDFDV, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
298-487 CT	Not required
488-512	Blank

Record Name: Code RT - Total Record#

Column	Description	Source
1-2	Record Identifier	Constant "RT"
3-9	Number of Code RS Record in previous Code RE Record	system derived number of all Code RS records in previous Code RE record
10-24	Total State Taxable Wages	System derived Total State Taxable Wages of all Code RS records in previous Code RE record
25-39	Total State Taxes	System derived Total State Taxes of all Code RS records in previous Code RE record
40-512	Blank

Record Name: Code RF - Final Record#

Column	Description	Source
1-2	Record Identifier	Constant "RF"
3-11	Number of Code RS Record on the entire file	System derived number of all Code RS records on the entire file
12-27	Total State Taxable Wages	System derived Total State Taxable Wages of all Code RS records on the entire file
28-43	Total State Taxes	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 and the following selected to generate Connecticut State file information:

Media Format:	State File Format
Select State:	Connecticut, USA

• Annual Form Code – Use the standard supplied form code HL$US-W2-2012. The Variables need to be entered in this form code for specific use in the installation.
• The ‘Quarterly Form Code’ must be entered in order to produce the UI wage file in ICESA format. – Use the supplied form code ‘HL$US-QTR-2012’. The Variables need to be entered in this form code for specific use in the installation.
• Period Type:Quarter
• Period End Date:Enter the quarter end date, i.e. 30-Jun-2011
• Media File Type:State SUI File Format
  
  
• If the Directory Name/Media File Name is not supplied, an output file will not be produced.

Record Name: Code E - Employer Record #

Column	Description	Source
1-1	Record Identifier	Constant "E"
2-3 CT	Last Month of the Quarter 03,06,09,12
4-5 CT	Two Digit Year
6-14	Federal EIN Numeric only
15-23	Blank
24-73	Employer name	Derived from the Entity
74-113	Street address	Derived from the Entity Location
114-138	City	Derived from the Entity Location
139-140	State (use a standard FIPS postal abbreviation)	Derived from the Entity Location
141-148	Blank
149-153	ZIP code extension (including ‘-‘ in position 149)	Derived from the Entity Location
154-158	ZIP code or foreign postal code	Derived from the Entity Location
159-159 CT	Name code	Constant ‘S’
160-160	Type of employment	Derived from IDFDV, Field Identifier: ‘TYPE OF EMPLOYMENT’
161-162	Blocking Factor Maximum 25
163-168 CT	Blank
169-170 CT	Connecticut FIPS Code	Constant ‘09’
171-175 CT	Blank
176-182 CT	Unemployment Compensation Number	Derived from the IDGV State SUI Registration
183-276 CT	Blank

Record Name: Code S - Supplemental Record #

Column	Description	Source
1-1	Record Identifier	Constant "S"
2-10	Employee SSN Number
11-37 CT	Employee Name Last Name, First Name
38-77 CT	Employee Address
78-102 CT	Employee City
103-112 CT	Employee State
113-117 CT	Employee Zip Code Extension (including ‘-‘ in position 113)
118-122 CT	Employee Zip Code
123 CT	Blank
124-125 CT	Connecticut Employer FIPS Code	Constant ‘09’
126-131 CT	Blank
132-140 CT	State Quarterly SUI Gross Wages	Derived from ‘SUI TOTAL WAGES’
141-149 CT	State Taxable Wages	From ‘SUI TOTAL WAGES’
150-276 CT	Blank

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	Blank
10-25 CT	Total Taxable Wages
26 CT	Blank
27-42 CT	Total Excess Wages
43 CT	Blank
44-59 CT	Total Gross Wages
60 CT	Blank
61-71 CT	Remittance Amount
72-72 CT	Blank
73-77 CT	Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the first month in the Quarter falls
78 CT	Blank
79-83 CT	Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the second month in the Quarter falls
84 CT	Blank
85-89 CT	Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the third month in the Quarter falls
90-276 CT	Blank

---

Notes#

Click to create a new notes page