[{TableOfContents }]

!!!Kansas Annual and Quarterly Wage Reporting
 
!!Set Up
This document contains abbreviated set up requirements for the state of Kansas only.  Please refer to the general document ([Tax Reporting - US General]) for other setup procedures that may also be required.

!IDGV - State Registration
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up for ‘State Registration’ for State/Province: Kansas
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘State Registration’ for State/Province: Kansas
**‘W2 STATE MEDIA FILING’ -  Must be ‘01’ to generate KS state wage file for KS state that includes the federal employee record types ‘RW’, “RO’,’RT’, and ‘RU’.

!IDGV - State SUI Registration
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
**‘W2 STATE MEDIA FILING’- Must be ‘02’ to generate UI wage magnetic media file for state of Kansas.

!!State File Procedures
*The Kansas Department of Revenue accepts filing of state W2 wages via magnetic media using the EFW2 file format, and the filing of Quarterly UI wages via the NASWA/ICESA format.
*Records required for the W2 reporting are codes RA, RE, RW, RS, RT, RV and RF.  Record codes A, B, E, S are required for UI wage reporting 
*When the EFW2 format is used to file for the State of Kansas, the [IDGV] must be set up as follows:
**for State Registration of Kansas, the [IDGV Variables|IDGV#VariablesTab]:
***‘W2 STATE MEDIA FILING’ 01 – Federal Format with state information.  If selected, includes record codes RW, RO, RT and RU.

!Annual W2 Wage Reporting – EFW2 File Format
[RPYEU] must be run with the following report parameters and filters defined to generate the Federal file information: \\ \\
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-YYYY'
|Period Type|Mandatory. Defines the period type.  Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
|Period End Date|Mandatory.  Defines the end date of the reporting period.
|Media Format|Mandatory.  Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory.  Defines the name of the government Magnetic Media file.  Must be defined or an output file will not be produced
|Media File Name|Mandatory.  Defines the media file name of the data being uploaded.  Must be defined or an output file will not be produced

__RPYEU Report Filters__
|Select State: Kansas, USA


!!State Magnetic Media Reporting – EFW2 Format

!Record Name: Code RA – Submitter Record (Same as the Federal Code RA)
[{InsertPage page='W2_EFW2_RECORD_RA'}]
\\ 
!Record Name: Code RE – Employer Record (Same as the Federal Code RE)
[{InsertPage page='W2_EFW2_RECORD_RE'}]
\\ 
!Record Name: Code RW – Employee Wage Record (Same as the Federal Code RW)
[{InsertPage page='W2_EFW2_RECORD_RW'}]
\\ 
!Record Name: Code RO – Employee Wage Record (Optional for State W2 Reporting)
[{InsertPage page='W2_EFW2_RECORD_RO'}]
\\

!Record Name: Code RS - State Wage Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RS"
|3-4|State code|Enter the appropriate FIPS postal numeric code. \\The numeric code for Kansas is "20". \\Derived from the State being reported, from [IDFDV] sequence 7000
|5-9|Taxing Entity Code|Not applicable for Kansas Reporting.  Fill with blanks.
|10-18|Social Security Number|Enter the employee's SSN.\\If an invalid SSN is encountered, this field is entered with zeroes. \\Derived from [IDFDV] W2-EE-SSN Field Identifier 
|19-33|Employee First Name|Enter the employee's first name. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
|34-48|Employee Middle Name or Initial|Enter the employee's middle name or initial. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
|49-68|Employee Last Name|Enter the employee's last name. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
|69-72|Employee Suffix|Derived from [IDFDV], Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
|73-94|Employee Location Address|Enter the employee's location address (attention, suite, room number, etc. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
|95-116|Employee Delivery Address|Enter the employee's delivery address (street or post office box). \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
|117-138|Employee City|Enter the employee's city. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-CITY’ (seq 2620)
|139-140|Employee State Abbreviation|Enter the employee's  state. Use a standard postal abbreviation. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-STATE’ (seq 2630)
|141-145|Employee ZIP Code|Enter the employee's ZIP code. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
|146-149|Employee ZIP Code Extension|Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
|150-154|Blank|Fill with blanks
|155-177|Employee Foreign State/Province|If applicable, enter the employee’s foreign state or province. \\ Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-F-STATE’
|178-192|Employee Foreign Postal Code|If applicable, enter the employee’s foreign postal code. \\Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-F-POSTAL’
|193-194|Country Code|If one of the following applies, fill with blanks: \\ \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-COUNTRY’
|195-247 KS|Blank|Fill with blanks
|248-267|State Employer Withholding Account Number|Enter the 9-digit Kansas Withholding Tax number FEIN.  Left justify and fill with blanks. \\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-273|Blank|Fill with blanks
|274-275|State code|Enter the appropriate FIPS postal numeric code. \\Numeric code for Kansas is "20". \\Derived from the state being reported
|276-286|State Taxable Wages|Taxable Wages for Kansas. Right justify and zero fill. Applies to income tax reporting. \\Derived from [IDFDV], Field Identifier: ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ (7030)
|287-297|State Income Tax Withheld|Kansas Income Tax Withheld. Right justify and zero fill. Applies to income tax reporting. \\Derived from [IDFDV], Field Identifier: ‘W2-ST-TAX-HOME’ (7040) and ‘W2-ST-TAX-WORK’ (7050)
|298-307 KS|Other State Data|Defined by State/local agency. Left justify and fill with blanks. Applies to income tax reporting.
|308|Blank|Fill with blanks
|309-319 KS|Local Taxable Wages|Right justify and zero fill. Applies to income tax reporting.
|320-330 KS|Local Income Tax Withheld|Right justify and zero fill. Applies to income tax reporting.
|331-337|State Control Number|Left justify and fill with blanks. Applies to income tax reporting.  
|338-348|Employee Contribution to KPERS, KP&F, Judges|Amount of Employee Contribution to KPERS, KP & F and Judges. Right justify and zero fill
|349-512 KS|Blank|Fill with blanks

;Multiple Code RS records:Multiple code RS records are generated for an employee if there is applicable county, city or school district tax information to be reported for a state.  In this case, the state wages and tax will be zero for the subsequent code RS records.

!Record Name: Code RT - Total Record (Same as Federal Code RT)
[{InsertPage page='W2_EFW2_RECORD_RT'}]


!Record Name: Code RU - Total Record (Optional for State W2 Reporting)
[{InsertPage page='W2_EFW2_RECORD_RU'}]

!Record Name: Code RV – Total State Record (Same as Federal Code RV)
[{InsertPage page='W2_EFW2_RECORD_RV'}]
 
!Record Name: Code RF - Final Record (Same as Federal Code RF)
[{InsertPage page='W2_EFW2_RECORD_RF'}]


!!State Quarterly UI Wage Reporting – NASWA/ICESA format
[RPYEU] must be run with the following report parameters and filters defined to generate Kansas State file information:

\\ \\
__RPYEU Report Parameters__
|Quarterly Form Code|Use standard form code, such as 'HL$US-QTR-YYYY'.  Must be entered in order to produce the UI wage file in the [ICESA] format. \\The 'Variables' need to be entered on this form code for specific use in the installation.
|Period Type|Mandatory. Defines the period type.  Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory.  Defines the end date of the reporting period.
|Media Format|Mandatory.  State SUI File Format \\Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory.  Defines the name of the government Magnetic Media file.  Must be defined or an output file will not be produced
|Media File Name|Mandatory.  Defines the media file name of the data being uploaded.  Must be defined or an output file will not be produced

__RPYEU Report Filters__
|Select State: Kansas, USA

!Quarterly UI Wage Magnetic Media Reporting – NASWA/ICESA Format
%%information Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
%%information Note: Columns with KS indicate it is a State of Kansas specific requirement which is not the standard record format%%

!Record Name: Code A - Transmitter Record 	
||Column||Description||Source
|1-1|Record Identifier|Constant ‘A’
|2-5|Payment Year|Enter the year this report is being prepared for. \\From user specified FROM-TO period converted to YYYY
|6-14|Transmitter’s Federal EIN|Enter only numeric characters.  Omit hyphens, prefixes and suffixes. \\Derived from [IDFDV], Field Identifier: ‘TRAN EIN’ (seq 1010).
|15-18|Taxing Entity Code|Constant ‘UTAX’
|19-23|Blank|Fill with blanks
|24-73|Transmitter Name|Enter the transmitter name of the organization submitting the file. \\Derived from [IDFDV], Field Identifier: ‘TRAN NAME’ (seq 1030)
|74-113|Transmitter Street Address|Enter the street address of the organization submitting the file. \\Derived from [IDFDV], Field Identifier: ‘TRAN ADDRESS’ (seq 1040)
|114-138|Transmitter City|Enter the city of the organization submitting the file. \\Derived from [IDFDV], Field Identifier: ‘TRAN CITY’ (seq 1050)
|139-140|Transmitter State|Enter the standard two character FIPS postal abbreviation.  \\Derived from [IDFDV], Field Identifier: ‘TRAN STATE’ (seq 1060)
|141-153|Blank|Fill with blanks
|154-158|Transmitter ZIP Code|Enter a valid ZIP code. \\Derived from [IDFDV], Field Identifier:‘TRAN ZIP CODE’ (seq 1080)
|159-163|Transmitter ZIP Code extension|Enter the four digit extension of the ZIP code. This field includes a hyphen in position 159. \\Derived from [IDFDV], Field Identifier:‘TRAN ZIP EXTN’ (seq 1070; include ‘-‘ in position 159)
|164-193|Transmitter Contact|Enter the name of the individual from transmitter's organization responsible for the accuracy of the wage report. \\Derived from [IDFDV], Field Identifier: ‘TRAN CONTACT’(seq 1090)
|194-203|Transmitter Contact Telephone Number|Enter the telephone number of the transmitter's contact. \\Derived from [IDFDV], Field Identifier:‘TRAN CONTACT PHONE’ (seq 1100)
|204-207|Telephone Extension|Enter the transmitter's telephone extension. \\Derived from [IDFDV], Field Identifier: ‘TRAN CONTACT EXTN’ (seq 1110)
|208-229 KS|Blank|Fill with blanks
|230-242|Not Required|Fill with blanks
|243-250|Not Required|Fill with blanks
|251-275|Blank|Fill with blanks

!Record Name: Code B - Authorization Record
||Column||Description||Source
|1-1|Record Identifier|Constant ‘B’
|2-5|Payment Year|Enter the year this report is being prepared for 
|6-14|Transmitter’s Federal EIN|Enter only numeric characters.  \\Derived from [IDFDV], Field Identifier: BASIC EIN (seq 2010)
|15-22|Computer|Enter the manufacturer’s name. \\Derived from [IDFDV], Field Identifier: ‘BASIC COMPUTER’ (seq 2020)
|23-24|Internal Label|Enter ‘SL’, ‘NS’, ‘NL’, ‘AL’, or blank for diskette.  \\Derived from [IDFDV], Field Identifier: ‘BASIC INTERNAL LABEL’ (seq 2100, first 2 characters)
|25-25|Blank|Fill with blanks
|26-27|Density|Enter ‘16’, ‘62’, ‘38’, or blank for diskette.  \\Derived from [IDFDV], Field Identifier: ‘BASIC DESITY’ (seq 2110)
|28-30|Recording Code (Character Set)|Enter “EBC’, or ‘ASC’.  Always ‘ASC’ for diskette.  \\Derived from [IDFDV], Field Identifier: ‘BASIC RECORDING MODE’ (seq 2120, first 3 characters)
|31-32|Number of Tracks|Enter ‘09’, or ‘18’, or blanks for diskette.  \\Derived from [IDFDV], Field Identifier: ‘BASIC RECOEDING MODE’ (seq 2120, fourth and fifth character)
|33-34|Blocking Factor|Enter the blocking factor of the file.  Not to exceed 85. \\Enter blanks for diskette \\Derived from [IDFDV], Field Identifier: ‘BLOCKING FACTOR’ (seq 3050)
|35-38|Taxing Entity Code|Constant ‘UTAX’
|39-146|Blank|Fill with blanks
|147-190|Organization Name|Enter the name of the organization the media should be returned to. \\Derived from [IDFDV], Field Identifier: ‘BASIC NAME’ (seq 2040)
|191-225|Street Address|Enter the street address of the organization the media should be returned to. \\Derived from [IDFDV], Field Identifier: ‘BASIC ADDRESS’ (seq 2050)
|226-245|City|Enter the city of the organization the media should be returned to. \\Derived from [IDFDV], Field Identifier: ‘BASIC CITY’ (seq 2060)
|246-247|State|Enter the standard two character FIPS postal abbreviation.  \\Derived from [IDFDV], Field Identifier: ‘BASIC STATE’ (seq 2070)
|248-252|Blank|Fill with blanks
|253-257|ZIP Code|Enter a valid ZIP code|Derived from [IDFDV], Field Identifier: ‘BASIC ZIP CODE’ (seq 2090)
|258-262|ZIP Code extension|Etner the four digit extension of ZIP code. Include hyphen in position 258. \\Derived from [IDFDV], Field Identifier: ‘BASIC ZIP EXTN’ (seq 2080)\\   \\Customers must include the hyphen (‘-‘) when defining the [IDFDV] BASIC ZIP EXTN Field Identifier (seq 2080)
|263-275|Blank|Fill with blanks

!Record Name: Code E - Employer Record 	
||Column||Description||Source
|1-1|Record Identifier|Constant ‘E’
|2-5|Payment Year|The year the report is being prepared for
|6-14|Federal EIN|Enter only numeric characters of the Federal EIN
|15-23|Blank|Fill with blanks
|24-73|Employer Name|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|The street address of the employer. \\Derived from the Entity Location
|114-138|Employer City|The city of employer’s mailing address. \\Derived from the Entity Location
|139-140|Employer State|The standard two character FIPS postal abbreviation of the employer’s address.  \\Derived from the Entity Location
|141-149|Blank|Fill with blanks
|150-153|ZIP code extension|The four digit extension of the ZIP code.  No hyphen. \\Derived from the Entity Location
|154-158|ZIP code|Derived from the Entity Location
|159-159|Blank|Fill with blanks
|160-160|Type of Employment|Enter ‘A’ (Agriculture), ‘F’ (Federal), ‘H’ (Household), ‘M’ (Military), ‘Q’ (Medicare Qualified Government Employees), ‘R’ (Regular, all other), or ‘X’ (Railroad) \\Derived from [IDFDV], Field Identifier: ‘TYPE OF EMPLOYMENT’ (seq 3020)
|161-162|Blocking Factor|The blocking factor of the file.  Not to exceed 85.  Enter blanks for diskette. \\Derived from [IDFDV], Field Identifier: ‘BLOCKING FACTOR’ (seq 3050)
|163-166 KS|Blank|Fill with blanks
|167-170|Taxing Entity Code|Constant ‘UTAX’
|171-172|State Identifier Code|The state FIPS postal numeric code for the state wages are being reported for
|173-187|State Unemployment Insurance Account Number|The State UI employer account number. \\Derived from the [IDGV] State SUI Registration
|188-189|Reporting Period|Enter ‘03’, ‘06’, ‘09’ or ‘12’
|190-190|No Workers/No Wages|Enter ‘0’ to indicate that the ‘E’ record will not be followed by the ‘S’ record. \\Enter ‘1’ to indicate otherwise
|191-255 KS|Blank|Fill with blanks
|256-256|Foreign Indicator|If data in positions 74-158 is for a foreign address, enter the letter ‘X’, else leave it blank. \\Derived from [IDFDV], Field Identifier: ‘FOREIGN ADDR INDICATOR’ (seq 3040)
|257-275 KS|Blank|Fill with blanks

!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|The state FIPS postal numeric code for the state wages are being reported for
|46-49|Blank|Fill with blanks
|50-63|State QTR Total Gross Wages|The quarterly wages subject to all taxes. \\Derived from [IDFDV], Field sequence 3090
|64-77|State QTR Unemployment Insurance Total Wages|The quarterly wages subject to unemployment taxes. \\Derived from [IDFDV], Field sequence 7200
|78-91|State QTR Unemployment Insurance Excess Wages|The quarterly wages in excess of the state UI taxable wage base
|92-105|State QTR Unemployment Insurance Taxable Wages|The state QTR UI total wages less state QTR UI excess wages
|106-142 KS|Blank|Fill with blanks
|143-146|Taxing Entity Code|Constant ‘UTAX’
|147-161|State Unemployment Insurance Account Number|The state UI employer account number. \\Derived from the SUI Registration number on [IDGV]
|162-211 KS|Blank|Fill with blanks
|212-212|Month-1 Employment|Enter ‘1’ if employee covered by UI worked or received 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 received 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 received pay for the pay period including the 12th day of the third reporting month, else enter ‘0’
|215-220|Reporting Quarter and Year|Enter the last month and year for the calendar period which this report applies to. \\Example: 0620YY for Apr-June 20YY)
|221-275 KS|Blank|Fill with blanks

----
![Notes|Edit:Internal.Tax Reporting - KS]
[{InsertPage page='Internal.Tax Reporting - KS' default='Click to create a new notes page'}]