This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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 requirement for the state of Tennessee only, please refer to the general document (Tax Reporting - US General) for other setup procedure that may also be required.

IDGV - State SUI Registration#

• The IDGV Definition tab must be set up with State SUI Registration for State/Province: Tennessee
• The IDGV Variables 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.

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#

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	Blank
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	Blank
256-256 TN	Foreign Indicator Not required
257-257	Blank
258-266 TN	Other EIN Not required
267-275	Blank

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
31-42	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	Blank
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	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 The wages subject to state income tax
191-204	State Income Tax withheld The 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	Blank

Record Name: Code F - Final Record #

Column	Description	Source
1-1	Record Identifier	Constant ‘F’
2-275	Blank