[{TableOfContents }]

!!!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|IDGV#DefinitionTab] tab must be set up for ‘State Registration’ for State/Province: Connecticut.
*The [IDGV Variables|IDGV#VariablesTab] 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|IDGV#VariablesTab]:
***‘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|Edit:Internal.Tax Reporting -  CT]
[{InsertPage page='Internal.Tax Reporting -  CT' default='Click to create a new notes page'}]