Table of Contents
- TENNESSEE ANNUAL AND QUARTERLY REPORTING
- SET UP
- IDGV - State SUI Registration
- State File Procedures
- Quarterly UI Wage Reporting – ICESA format
- Quarterly UI Wage Magnetic Media Reporting - ICESA Format
- Record Name: Code E - Employer Record
- Record Name: Code S – Employee Wage Record
- Record Name: Code F - Final Record
TENNESSEE ANNUAL AND QUARTERLY REPORTING#
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-2016
- 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 |