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 requirements for TENNESSEE only. Please refer to the general document for other set up that may 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 - 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.