This page (revision-22) was last changed on 26-Nov-2021 10:22 by lurtan

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
22 26-Nov-2021 10:22 5 KB lurtan to previous
21 26-Nov-2021 10:22 5 KB kparrott to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - TN
Tax Reporting - TN

Version management

Difference between version and

At line 1 changed one line
[{TableOfContents }]
!!!TENNESSEE Annual and Quarterly Reporting
At line 3 changed one line
!!!TENNESSEE ANNUAL AND QUARTERLY REPORTING
!!What's New for Tax Year 2012
At line 5 added 3 lines
There are no format changes in wage reporting for tax year 2012
At line 6 removed one line
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.
At line 10 added 2 lines
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.
At line 10 changed one line
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with State SUI Registration for State/Province: Tennessee
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up with State SUI Registration for State/Province: Tennessee
At line 14 changed one line
!!State File Procedures
!!STATE FILE PROCEDURES
At line 17 changed one line
The Tennessee Department of Labor accepts filing of UI quarterly wages via magnetic media using the [ICESA format|ICESA].
The Tennessee Department of Labor accepts filing of UI quarterly wages via magnetic media using the [ICESA format|ICESA].
At line 19 changed 2 lines
!!Quarterly UI Wage Reporting – ICESA format
[RPYEU] must be run and the following selected to generate Tennessee state file information:
The user must run [RPYEU] and select the following to generate Tennessee State file information:
At line 22 changed 8 lines
*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.
* You must select state Tennessee in the Report List Filters.
* Annual Form Code – use the __Annual Form__ definition from [IDFDV]. You will have to enter the Variables in this Form Code for use specifically in your installation.
* The Quarterly Form Code must be entered in order to produce UI wage file in [ICESA format|ICESA]. – use the __Quarterly Form__ definition from [IDFDV]. You will have to enter the Variables in this Form Code for use specifically in your 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.
At line 31 changed 2 lines
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
%%information Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
!!ICESA for Tennessee
At line 34 changed 28 lines
!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|
* Only "E" (Employer), "S" (Employee Wage Record) and "F" (Final) records are required.
* The format details are found at the [Tennessee Department of Labor website|http://www.tennessee.gov/labor-wfd/Employers/icesa_format.htm|target='_blank']
* Most fields are Not Required for Tennessee,
At line 63 removed 36 lines
!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|
This page (revision-22) was last changed on 26-Nov-2021 10:22 by lurtanTop