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

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

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
48 26-Nov-2021 10:22 19 KB Meg McFarland to previous
47 26-Nov-2021 10:22 19 KB Meg McFarland to previous | to last
46 26-Nov-2021 10:22 19 KB Meg McFarland to previous | to last
45 26-Nov-2021 10:22 12 KB Meg McFarland to previous | to last
44 26-Nov-2021 10:22 12 KB Meg McFarland to previous | to last
43 26-Nov-2021 10:22 23 KB kparrott to previous | to last
42 26-Nov-2021 10:22 23 KB kparrott to previous | to last
41 26-Nov-2021 10:22 24 KB kparrott to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - AR
Tax Reporting - AR

Version management

Difference between version and

At line 3 removed 63 lines
!!!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|Tax Reporting - USA] for other set up that may be required.
!IDGV - State SUI Registration
* 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
!!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|ICESA].
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 __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.
!!ICESA for Tennessee
* 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,
----
![Notes|Edit:Internal.Tax Reporting - AR]
[{InsertPage page='Internal.Tax Reporting - AR' default='Click to create a new notes page'}]
Table of Contents
WHAT’S NEW FOR TAX YEAR 2011 4
SET UP 5
IDGV - State Registration 5
STATE FILE PROCEDURES 6
ANNUAL W2 WAGE REPORTING – EFW2 (formerly MMREF1) format 7
ANNUAL W2 MAGNETIC MEDIA FILE EFW2 LAYOUT 8
Record name: Code RA - Transmitter Record 8
Record name: Code RE - Employer Record 10
Record name: Code RW - Employee Wage Record (Optional for State Quarterly Reporting) 11
Record name: Code RS - State Record 13
Record name: Code RT - Total Record 15
Record name: Code RF - Final Record 16
QUARTERLY UI WAGE REPORTING - ICESA format 18
QUARTERLY UI WAGE MAGNETIC MEDIA FILE FORMAT – ICESA LAYOUT 19
Record name: Code E - Employer Record 19
Record name: Code S – Employee Wage Record 20
At line 229 added 255 lines
!!ICESA for Arkansas
* 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,
RPYEU must be run and the following selected to generate Arkansas State file information:
|Media Format:|- State SUI File Format
|Select State:|- Arkansas, USA
*Client must select state ARKANSAS 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. – 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.
QUARTERLY UI WAGE MAGNETIC MEDIA FILE FORMAT – ICESA LAYOUT
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
Note: Columns coded with AR indicates it is a Arkansas specific requirement which is not the standard record format
Record name: Code E - Employer Record
Column Description
1-1 - Record Identifier.
- Constant ‘E’.
2-5 - Payment Year.
- Tax Year for which this report is being prepared.
6-14 - Federal EIN
- Enter only numeric characters
- Derived from the IDGV State SUI Registration
15-23 - Blanks.
24-73 - Employer Name.
- Enter the first 50 positions of the employer’s name exactly as registered with the state UI agency
- Derived from the Entity
74-113 - Employer Street Address
- Enter the street address of the Employer
- Derived from the Entity Location
114-138 - Employer City
- Enter the city of employer’s mailing address
- Derived from the Entity Location
139-148 - Employer State
- Enter the standard two character FIPS postal abbreviation of the employer’s address
- Derived from the Entity Location
149-153 - ZIP code extension
- Enter four digit extension of ZIP code, including the hyphen in position 149.
- Derived from the Entity Location
154-158 - ZIP code.
- Enter a valid ZIP code
- Derived from the Entity Location.
159-159 AR - Name Code.
- Constant ‘S’ to indicate that surname appears first
160-160 - Type of Employment.
- ‘A’, ‘F’, ‘H’, ‘M’, ‘Q’, ‘R’, or ‘X’.
- Derived from IDFDV screen, Field Identifier: ‘TYPE OF EMPLOYMENT’
161-162 - Blocking Factor.
- Enter blocking factor of the file, not to exceed 85. Enter blanks for diskette.
163-275 AR - Blanks.
Record name: Code S – Employee Wage Record
Column Description
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-37 AR - Employee Name.
- Enter employee name as per Name Code ‘S’ (surname first, followed by first name)
38-123 AR - Blanks.
124-125 AR - State Code
- Use standard FIPS postal numeric code
- Constant ‘05’ for Arkansas.
126-127 AR - Blanks.
128-131 AR - Reporting Period.
- Month end date of the quarter for which this report is being prepared (i.e. 0903 for third quarter of 2003).
132-140 AR - State Quarterly Total Wages.
- Enter total wages subject to state tax.
141-164 AR - Blanks
165-176 AR - State Unemployment Insurance Account Number.
- Enter the DIR tax account number
- SUI Registration Number from IDGV
177-275 AR - Blanks.
QUARTERLY UI WAGE REPORTING - ICESA format
- The user must run RPYEU and select the following to generate Alabama State file information:
Media Format: - State SUI File Format
Select State: - Arkansas, USA
- Client must select state ARKANSAS 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. – 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.
QUARTERLY UI WAGE MAGNETIC MEDIA FILE FORMAT – ICESA LAYOUT
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
Note: Columns coded with AR indicates it is a Arkansas specific requirement which is not the standard record format
Record name: Code E - Employer Record
Column Description
1-1 - Record Identifier.
- Constant ‘E’.
2-5 - Payment Year.
- Tax Year for which this report is being prepared.
6-14 - Federal EIN
- Enter only numeric characters
- Derived from the IDGV State SUI Registration
15-23 - Blanks.
24-73 - Employer Name.
- Enter the first 50 positions of the employer’s name exactly as registered with the state UI agency
- Derived from the Entity
74-113 - Employer Street Address
- Enter the street address of the Employer
- Derived from the Entity Location
114-138 - Employer City
- Enter the city of employer’s mailing address
- Derived from the Entity Location
139-148 - Employer State
- Enter the standard two character FIPS postal abbreviation of the employer’s address
- Derived from the Entity Location
149-153 - ZIP code extension
- Enter four digit extension of ZIP code, including the hyphen in position 149.
- Derived from the Entity Location
154-158 - ZIP code.
- Enter a valid ZIP code
- Derived from the Entity Location.
159-159 AR - Name Code.
- Constant ‘S’ to indicate that surname appears first
160-160 - Type of Employment.
- ‘A’, ‘F’, ‘H’, ‘M’, ‘Q’, ‘R’, or ‘X’.
- Derived from IDFDV screen, Field Identifier: ‘TYPE OF EMPLOYMENT’
161-162 - Blocking Factor.
- Enter blocking factor of the file, not to exceed 85. Enter blanks for diskette.
163-275 AR - Blanks.
Record name: Code S – Employee Wage Record
Column Description
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-37 AR - Employee Name.
- Enter employee name as per Name Code ‘S’ (surname first, followed by first name)
38-123 AR - Blanks.
124-125 AR - State Code
- Use standard FIPS postal numeric code
- Constant ‘05’ for Arkansas.
126-127 AR - Blanks.
128-131 AR - Reporting Period.
- Month end date of the quarter for which this report is being prepared (i.e. 0903 for third quarter of 2003).
132-140 AR - State Quarterly Total Wages.
- Enter total wages subject to state tax.
141-164 AR - Blanks
165-176 AR - State Unemployment Insurance Account Number.
- Enter the DIR tax account number
- SUI Registration Number from IDGV
177-275 AR - Blanks.
This page (revision-48) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop