This page (revision-34) 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
34 26-Nov-2021 10:22 9 KB Meg McFarland to previous
33 26-Nov-2021 10:22 9 KB Meg McFarland to previous | to last
32 26-Nov-2021 10:22 9 KB Meg McFarland to previous | to last
31 26-Nov-2021 10:22 9 KB Meg McFarland to previous | to last
30 26-Nov-2021 10:22 10 KB kparrott to previous | to last
29 26-Nov-2021 10:22 11 KB kparrott to previous | to last
28 26-Nov-2021 10:22 11 KB kparrott to previous | to last
27 26-Nov-2021 10:22 11 KB kparrott to previous | to last
26 26-Nov-2021 10:22 21 KB kparrott to previous | to last
25 26-Nov-2021 10:22 21 KB kparrott to previous | to last
24 26-Nov-2021 10:22 20 KB kparrott to previous | to last
23 26-Nov-2021 10:22 20 KB kparrott to previous | to last
22 26-Nov-2021 10:22 20 KB kparrott to previous | to last
21 26-Nov-2021 10:22 20 KB eyeung to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - AZ
Tax Reporting - AZ

Version management

Difference between version and

At line 40 removed 36 lines
!!STATE UI Wage MAGNETIC MEDIA REPORTING – State Format
!Header Record Format
||Column||Description||Source
|1-1|Transaction Code|Constant Letter ‘H’
|2-9|Employer Account Number\\ \\SUI Registration Number from [IDGV]|
|10-13|Reporting Year|
|14-14|Quarter (single value 1,2, 3, or 4)|
|15-20|Number of Wage items\\ \\Number of Code ‘D’ records|
|21-31|Total Wages S9(9)V99 \\ \\(Signed, no $ or Decimal)|
|32|Source Code|Constant ‘E’
|33-105|Not Used\\ \\Fill with blanks|
|106-113|Batch Number\\ \\Not used, fill with zeros|
|114-117|Batch Item\\ \\Not used, fill with zeros|
!Detail Record Format
||Column||Description||Source
|1-1|Transaction Code|Constant Letter ‘D’
|2-9|Employer Account Number |SUI Registration Number from [IDGV]
|10-13|Reporting Year|
|14-14|Quarter\\ \\Single value (1,2,3,or 4)|
|15-23|Social Security Number|From Employee Record
|24-48|Employee Last Name|
|49-63|Employee First Name|
|64-64|Employee Middle Initial|
|65-75|Employee Gross Wages S9(9)V99\\ \\(Signed, no $ or decimal)|
|76-76|Project Code\\ \\Not used, fill with zeros|
|77-81|Hourly Rate\\ \\Not used, fill with zeros|
|82-103|Occupational Code\\ \\Blank|
|104-105|Area Code\\ \\Blank|
|106-113|Batch Number\\ \\Not used, fill with zeros|
|114-117|Batch Item\\ \\Not used, fill with zeros|
----
![Notes|Edit:Internal.Tax Reporting - AZ]
[{InsertPage page='Internal.Tax Reporting - AZ' default='Click to create a new notes page'}]
At line 167 added 3 lines
|325-339|Income Tax Withheld by Third-Party Payer|Derived from [IDFDV] Field Identifier: SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
|340-354|Income from Non-statutory Stock options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
|355-512|Blank|
At line 204 removed 6 lines
325-339 - Income Tax Withheld by Third-Party Payer|Derived from [IDFDV] Field Identifier: SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
340-354 - Income from Non-statutory Stock options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
355-512|Blank|
At line 173 added 4 lines
|1-2|Record Identifier|Constant "RF"
|3-7|Blank|
|8-16|Number of RS Records\\ \\Total number of code "RW" records on file|
|17-512|Blank|
At line 213 removed 10 lines
1-2 - Record Identifier
- Constant "RF"
3-7|Blank|
8-16 - Number of RS Records
- Total number of code "RW" records on file
17-512|Blank|
At line 227 changed 2 lines
*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 blank in order to produce UI wage file in EFW2 format..
*Annual Form Code’ – use the standard supplied form code HL$US-W2-2012. The ‘Variables’ will need to be entered in this Form Code for use specifically in the installation.
*The ‘Quarterly Form Code’ must be blank in order to produce UI wage file in EFW2 format.
At line 235 changed one line
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
%%information: Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
At line 237 changed one line
Note: Columns coded with AZ indicates it is an Arizona specific requirement which is not the standard record format
%%information:Note: Columns coded with AZ indicates it is an Arizona specific requirement which is not the standard record format.%%
At line 196 added 21 lines
|1-2|Record Identifier|Constant "RS"
|3-4|State code, appropriate FIPS postal numeric code|Derived from the State being reported, from [IDFDV] 7000\\ \\Arizona is code ‘04’
|5-9|Taxing Entity Code\\ \\Constant ‘UITAX’\\ \\[IDGV] setup for SUI registration ‘variables’ tab ‘Taxing Entity’ field|
|10-18|Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’\\ \\If an invalid SSN is encountered, this field is entered with zeroes
|19-33|Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
|34-48|Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
|49-68|Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
|69-72|Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’
|73-94|Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’
|95-116|Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’
|117-138|Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’
|139-140|Employee State Numeric Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’\\ \\The system will convert the State Abbreviation into the required Numeric State Code (i.e. Arizona is ’04’).
|141-145|Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’
|146-149|Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’
|150-196 AZ|Blank|
|197-202|Reporting Period MMCCYY|From user specified Period End Date converted to MMCCYY for the quarter\\ \\e.g. Period End Date = ‘31-Dec-2003’, then reporting period is ‘122003’
|203-213|State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’\\ \\Note that the [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in [UPCALC] and therefore for employees who exceed the maximum wage base, this identifier will contain no SUI Insurance wages, therefore [RPYEU] is using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages
|214-224|State Quarterly Unemployment Insurance Taxable Wages|This amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government\\ \\Please read document [PR_US_QTR_MMREF_Generic.doc] for detail for quarterly reporting
|225-247 AZ|Blank|
|248-267|State Employer Account Number, including the Branch Number|Derived from [IDFDV] Field Identifier: ‘W2-STATE-REGIST’ for the reporting State\\ \\When [RPYEU] is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from [IDGV] for the SUI Registration of the State
|268-512 AZ|Blank|
At line 242 removed 57 lines
1-2 - Record Identifier
- Constant "RS"
3-4 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported, from IDFDV sequence 7000.
- Arizona is code ‘04’
5-9 - Taxing Entity Code
- Constant ‘UITAX’.
- IDGV setup for SUI registration ‘variables’ tab ‘Taxing Entity’ field.
10-18 - Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’
- if an invalid SSN is encountered, this field is entered with zeroes.
19-33 - Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
34-48 - Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
49-68 - Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
69-72 - Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’
73-94 - Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’
95-116 - Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’
117-138 - Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’
139-140 - Employee State Numeric Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’
- The system will convert the State Abbreviation into the required Numeric State Code (i.e. Arizona is ’04’).
141-145 - Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’
146-149 - Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’
150-196 AZ|Blank|
197-202 - Reporting Period MMCCYY
- From user specified Period End Date converted to MMCCYY for the quarter
- e.g. Period End Date = ‘31-Dec-2003’, then reporting period is ‘122003’
203-213 - State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
- note that the IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in UPCALC and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages, therefore RPYEU is using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages
214-224 - State Quarterly Unemployment Insurance Taxable Wages
- this amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government
- please read document PR_US_QTR_MMREF_Generic.doc for detail for quarterly reporting
225-247 AZ|Blank|
248-267 - State Employer Account Number, including the Branch Number|Derived from [IDFDV] Field Identifier: ‘W2-STATE-REGIST’ for the reporting State
- When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV screen for the SUI Registration of the State
268-512 AZ|Blank|
At line 303 changed 2 lines
1-2 - Record Identifier
- Constant "RF"
|1-2|Record Identifier|Constant "RF"
|3-512 AZ|Blank|
----
![Notes|Edit:Internal.Tax Reporting - AZ]
[{InsertPage page='Internal.Tax Reporting - AZ' default='Click to create a new notes page'}]
At line 306 removed one line
3-512 AZ|Blank|
At line 230 added one line
This page (revision-34) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop