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

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 changed 2 lines
!!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.
Tenessee does not have personal income tax.
At line 8 changed one line
!IDGV - State SUI Registration
There are no format changes in wage reporting for tax year 2012
At line 10 changed 3 lines
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with State SUI Registration for State/Province: Tennessee
*The [IDGV Variables|IDGV#VariablesTab] 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
!!SET UP
At line 14 changed 2 lines
!!State File Procedures
Tennessee does not have state personal income tax.
This document contains abbreviated set up requirements for __TENNESSEE__ only. Please refer to the general document for other set up that may be required.
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].
!IDGV - State SUI Registration
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:
* Definition Tab must be set up with State SUI Registration for State/Province: Tennessee
* Variables tab must be set up with State SUI Registration for State/Provice: Tennessee
** W2 STATE MEDIA FILING Must be '02' to generate UI wage magnetic media file for state of Tennessee
At line 22 removed 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.
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.%%
!!STATE FILE PROCEDURES
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|
Tennessee does not have state personal income tax.
At line 63 changed 31 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|
The Tennessee Department of Labor accepts filing of UI quarterly wages via magnetic media using the [ICESA format|ICESA]. The required record codes are 'E', 'S' and 'F'.
At line 95 changed 4 lines
!Record Name: Code F - Final Record
||Column||Description||Source
|1-1|Record Identifier|Constant ‘F’
|2-275|Blank|
The user must run [RPYEU] and select the following to generate Tennessee State file information:
* You must select state Tennessee in the ‘Report List Filters’.
* Annual Form Code’ – use the standard HighLine supplied form code __HL$US-W2-2012__. 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 HighLine supplied Form Code __HL$US-QTR-2012__. 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.