[{TableOfContents }]
!!!TENNESSEE ANNUAL AND QUARTERLY REPORTING
!!What's New for Tax Year 2012
There are no format changes in wage reporting for tax year 2012
!!SET UP
This document contains abbreviated set up requirements for __TENNESSEE__ only. Please refer to the [general document|Tax Reporting - USA] for other set up that may be required.
!IDGV - State SUI Registration
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with State SUI Registration for State/Province: Tennessee
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with State SUI Registration for State/Province: Tennessee
** W2 STATE MEDIA FILING must be '02' to generate UI wage magnetic media file for state of Tennessee
!!State File Procedures
Tennessee does not have state personal income tax.
The Tennessee Department of Labor accepts filing of UI quarterly wages via magnetic media using the [ICESA format|ICESA].
!!Quarterly UI Wage Reporting – ICESA format
[RPYEU] must be run and the following selected to generate Tennessee state file information:
*The state of Tennessee must be selected in the ‘Report List Filters’.
*Annual Form Code – Use the Annual Form definition from [IDFDV]. 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 Quarterly Form definition from [IDFDV]. 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.
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
%%information Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
!Record Name: Code E - Employer Record
||Column||Description||Source
|1-1|Record Identifier|Constant ‘E’
|2-5|Payment Year\\ \\Enter the year for which the report is being prepared|
|6-14|Federal EIN\\ \\Enter only numeric characters|Derived from the [IDGV] State SUI Registration
|15-23 TN|Blank|
|24-73 TN|Employer Name\\ \\Not required|
74-113 TN - Employer Street Address\\ \\Not required|
114-138 TN - Employer City\\ \\Not required|
139-140 TN - Employer State
- Enter the standard two character FIPS postal abbreviation of the employer’s address
- Derived from the Entity Location
141-148 TN - Blanks.
149-153 TN - ZIP code extension\\ \\Not required|
154-158 TN - ZIP code\\ \\Not required|
159-159 TN - Blank.
160-160 TN - Type of Employment\\ \\Not required|
161-162 - Blocking Factor.
- Enter blocking factor of the file, must be 25. Enter blanks for diskette.
163-166 TN - Establishment Number or Coverage Group/PRU\\ \\Not required|
167-170 TN - Taxing Entity Code\\ \\Not required|
171-172 - State Identifier Code.
- Enter the state FIPS postal numeric code for the state to which wages are being reported.
- enter ‘47’ for Tennessee.
173-187 - State Unemployment Insurance Account Number.
- Enter state UI employer account number.
- Derived from the IDGV State SUI Registration
188-189 - Reporting Period.
- ‘03’, ‘06’, ‘09’, or ‘12’.
190-190 - No Workers/No Wages\\ \\Not required|
191-208 TN - Not Used
- Enter blanks.
209-255 - Blanks.
256-256 TN - Foreign Indicator.
- Not Required.
257-257 - Blank.
258-266 TN - Other EIN.
- Not Required.
267-275 - Blanks.
!Record Name: Code S – Employee Wage Record
||Column||Description||Source
1-1 - Record Identifier.
- Constant ‘S’
2-10 - Social Security Number
- Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10
11-30 - Employee Last Name.
- Enter employee last name.
31-42 - Employee First Name.
- Enter employee first name
43-43 - Employee Middle Initial.
- Enter employee middle initial. Leave blank if no middle initial
44-45 - State Code
- Enter the state FIPS postal numeric code for the state to which wages are being reported
46-49 - Blanks.
50-63 TN - State QTR Total Gross Wages.
- Not Required.
64-77 - State QTR Unemployment Insurance Total Wages.
- Enter quarterly wages subject to unemployment taxes.
78-91 TN - State QTR Unemployment Insurance Excess Wages
- Not Required
92-105 TN - State QTR Unemployment Insurance Taxable Wages.
- Not Required.
106-120 TN - Quarterly State Disability Insurance Taxable Wages.
- Not Required.
121-129 TN - Quarterly Tip Wages
- Not Required.
130-131 TN - Number of Weeks Worked.
- Not Required.
132-134 TN - Number of Hours Worked.
- Not Required.
135-138 TN - Date First Employed (MMYY)
- Not Required.
139-142 TN - Date of Separation (MMYY)
- Not Required.
143-146 - Taxing Entity Code.
- Constant ‘UTAX’.
147-161 - State Unemployment Insurance Account Number.
- Enter state UI employer account number
- SUI Registration Number from IDGV
162-176 - Unit/Division Location/Plant Code
- The ID assigned to identify wages by work site.
177-190 - State Taxable Wages.
- Enter wages subject to state income tax.
191-204 - State Income Tax withheld
- Enter wages subject to state income tax.
205-209 TN - Not Used
- Enter blanks.
210-210 - Officer Code.
- Enter ‘1’ for officers of the corporation, else enter ‘0’.
211-211 - Wage Plan Code.
- Enter blank.
212-212 - Month-1 Employment.
- Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month, else enter ‘0’.
213-213 - Month-2 Employment.
- Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month, else enter ‘0’.
214-214 - Month-3 Employment.
- Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month, else enter ‘0’.
215-275 TN - Blanks.
!Record Name: Code F - Final Record
||Column||Description||Source
1-1 - Record Identifier.
- Constant ‘F’.
2-275 - Blanks.