Table of Contents

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#

ColumnDescriptionSource
1-1Record IdentifierConstant ‘E’
2-5Payment Year

Enter the year for which the report is being prepared
6-14Federal EIN

Enter only numeric characters		Derived from the IDGV State SUI Registration
15-23 TNBlank
24-73 TNEmployer Name

Not required
74-113 TNEmployer Street Address

Not required
114-138 TNEmployer City

Not required
139-140 TNEmployer State

Enter the standard two character FIPS postal abbreviation of the employer’s address		Derived from the Entity Location
141-148 TNBlank
149-153 TNZIP code extension

Not required
154-158 TNZIP code

Not required
159-159 TNBlank
160-160 TNType of Employment

Not required
161-162Blocking Factor

Enter blocking factor of the file, must be 25

Enter blanks for diskette
163-166 TNEstablishment Number or Coverage Group/PRU

Not required
167-170 TNTaxing Entity Code

Not required
171-172State Identifier Code

Enter the state FIPS postal numeric code for the state to which wages are being reported

Enter ‘47’ for Tennessee
173-187State Unemployment Insurance Account Number

Enter state UI employer account number		Derived from the IDGV State SUI Registration
188-189Reporting Period

‘03’, ‘06’, ‘09’, or ‘12’
190-190No Workers/No Wages

Not required
191-208 TNNot Used

Enter blanks
209-255Blank
256-256 TNForeign Indicator

Not required
257-257Blank
258-266 TNOther EIN

Not required
267-275Blank

Record Name: Code S – Employee Wage Record #

ColumnDescriptionSource
1-1Record IdentifierConstant ‘S’
2-10Social Security Number

Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10
11-30Employee Last Name
31-42Employee First Name
43-43Employee Middle Initial

Enter employee middle initial

Leave blank if no middle initial
44-45State Code

Enter the state FIPS postal numeric code for the state to which wages are being reported
46-49Blank
50-63 TNState QTR Total Gross Wages

Not required
64-77State QTR Unemployment Insurance Total Wages

Enter quarterly wages subject to unemployment taxes
78-91 TNState QTR Unemployment Insurance Excess Wages

Not required
92-105 TNState QTR Unemployment Insurance Taxable Wages

Not required
106-120 TNQuarterly State Disability Insurance Taxable Wages

Not required
121-129 TNQuarterly Tip Wages

Not required
130-131 TNNumber of Weeks Worked

Not required
132-134 TNNumber of Hours Worked

Not Required
135-138 TNDate First Employed (MMYY)

Not required
139-142 TNDate of Separation (MMYY)

Not required
143-146Taxing Entity CodeConstant ‘UTAX’
147-161State Unemployment Insurance Account NumberSUI Registration Number from IDGV
162-176Unit/Division Location/Plant Code

The ID assigned to identify wages by work site
177-190State Taxable Wages

The wages subject to state income tax
191-204State Income Tax withheld

The wages subject to state income tax
205-209 TNNot Used

Enter blanks
210-210Officer Code

Enter ‘1’ for officers of the corporation, else enter ‘0’
211-211Wage Plan Code

Enter blank
212-212Month-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-213Month-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-214Month-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 TNBlank

Record Name: Code F - Final Record #

ColumnDescriptionSource
1-1Record IdentifierConstant ‘F’
2-275Blank
This particular version was published on 26-Nov-2021 10:22 by kparrott.Top