This page (revision-21) was last changed on 15-Feb-2023 15:08 by Karen Parrott

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
21 15-Feb-2023 15:08 15 KB Karen Parrott to previous

Page References

Incoming links Outgoing links
Tax Reporting - WA
Tax Reporting - WA

Version management

Difference between version and

At line 4 removed 5 lines
!!What's New for Tax Year 2012
Washington state does not have state personal income tax.
There were no file format changes in UI wage reporting for the state of Washington for tax year 2012.
At line 32 changed one line
*Annual Form Code - Use the standard supplied form code HL$US-W2-2013. The Variables need to be entered in this form code for specific use in the installation.
*Annual Form Code - Use the standard supplied form code HL$US-W2-2017. The Variables need to be entered in this form code for specific use in the installation.
At line 36 changed one line
*Period End Date:Enter the quarter end date, i.e. 30-Mar-2013
*Period End Date:Enter the quarter end date, i.e. 30-Mar-2016
At line 47 changed 2 lines
|2-5|Payment Year\\ \\Enter year for which this report is being prepared|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).
|2-5|Payment Year|Enter year for which this report is being prepared\\ \\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).
At line 51 changed 4 lines
|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)
|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)
At line 57 changed 2 lines
|159-163|Transmitter ZIP Code extension\\ \\Use this field as necessary for the four digit extension of ZIP code\\ \\Includes a hyphen in position 159|Derived from [IDFDV] Field Identifier: ‘TRAN ZIP EXTN’ (seq 1070; include ‘-‘ in position 159)
|164-193|Transmitter Contact\\ \\Title of individual from transmitter organization responsible for the accuracy of the wage report|Derived from [IDFDV] Field Identifier: ‘TRAN CONTACT’(seq 1090)
|159-163|Transmitter ZIP Code extension|Use this field as necessary for the four digit extension of ZIP code\\ \\Includes a hyphen in position 159\\ \\Derived from [IDFDV] Field Identifier: ‘TRAN ZIP EXTN’ (seq 1070; include ‘-‘ in position 159)
|164-193|Transmitter Contact|Title of individual from transmitter organization responsible for the accuracy of the wage report\\ \\Derived from [IDFDV] Field Identifier: ‘TRAN CONTACT’(seq 1090)
At line 60 changed one line
|204-207|Telephone Extension/Box\\ \\Enter transmitter telephone extension or message box|Derived from [IDFDV] Field Identifier: ‘TRAN CONTACT EXTN’ (seq 1110)
|204-207|Telephone Extension/Box|Enter transmitter telephone extension or message box\\ \\Derived from [IDFDV] Field Identifier: ‘TRAN CONTACT EXTN’ (seq 1110)
At line 62 changed one line
|243-250|Media Creation Date\\ \\Enter date in MMDDYYYY format|Derived from the System Date
|243-250|Media Creation Date|Enter date in MMDDYYYY format\\ \\Derived from the System Date
At line 68 changed 4 lines
|2-5|Payment Year\\ \\Enter the year for which this report is being prepared|
|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\\ \\‘SL’, ‘NS’, ‘NL’, ‘AL’, or blank for diskette|Derived from [IDFDV] Field Identifier: ‘BASIC INTERNAL LABEL’ (seq 2100, first 2 characters)
|2-5|Payment Year|Enter the year for which this report is being prepared
|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|‘SL’, ‘NS’, ‘NL’, ‘AL’, or blank for diskette\\ \\Derived from [IDFDV] Field Identifier: ‘BASIC INTERNAL LABEL’ (seq 2100, first 2 characters)
At line 78 changed 2 lines
|2-5|Payment Year\\ \\Enter the year for which the report is being prepared|
|6-14|Federal EIN\\ \\Enter only numeric characters of the Federal EIN|
|2-5|Payment Year|Enter the year for which the report is being prepared
|6-14|Federal EIN|Enter only numeric characters of the Federal EIN
At line 81 changed one line
|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
|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
At line 84 changed one line
|139-140|Employer State\\ \\Enter the standard two character FIPS postal abbreviation of the employer’s address|Derived from the Entity Location
|139-140|Employer State|Enter the standard two character FIPS postal abbreviation of the employer’s address\\ \\Derived from the Entity Location
At line 86 changed one line
|149-153|ZIP code extension\\ \\Enter four digit extension of ZIP code, including the hyphen in position 149|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
At line 90 changed one line
|171-172|State Identifier Code.\\ \\Enter the state FIPS postal numeric code for the state to which wages are being reported|Numeric Code for Washington is ‘53’
|171-172|State Identifier Code|Enter the state FIPS postal numeric code for the state to which wages are being reported\\ \\Numeric Code for Washington is ‘53’
At line 92 changed 2 lines
|188-189|Reporting Period\\ \\‘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|
|188-189|Reporting Period|‘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
At line 95 changed one line
|192-201 WA|Agent Code\\ \\Blank|
|192-201 WA|Agent Code|Blank
At line 97 changed one line
|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)
|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)
At line 99 changed one line
|258-269 WA|Other EIN\\ \\Enter Blanks if no other EIN was used|Derived from [IDFDV] Field Identifier: ‘OTHER EIN’ (seq 3060)
|258-269 WA|Other EIN|Enter Blanks if no other EIN was used\\ \\Derived from [IDFDV] Field Identifier: ‘OTHER EIN’ (seq 3060)
At line 105 changed one line
|2-10|Social Security Number\\ \\Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10|
|2-10|Social Security Number|Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10
At line 108 changed 2 lines
|43-43|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\\ \\Use ‘53’ for Washington state|
|43-43|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\\ \\Use ‘53’ for Washington state
At line 112 changed 5 lines
|64-77|State QTR Unemployment Insurance Total Wages\\ \\Enter quarterly wages subject to unemployment taxes|Derived from [IDFDV] Field Identifier: 7200
|78-91|State QTR Unemployment Insurance Excess Wages\\ \\Quarterly wages in excess of the state UI taxable wage base|
|92-105|State QTR Unemployment Insurance Taxable Wages\\ \\State QTR UI total wages less state QTR UI excess wages|
|106-131 WA|Blank|
|132-135 WA|Number of Hours Worked\\ \\The number of hours worked in the reporting period|Derived from [IDFDV] Field Sequence 3300
|64-77|State QTR Unemployment Insurance Total Wages|Enter quarterly wages subject to unemployment taxes\\ \\Derived from [IDFDV] Field Identifier: 7200
|78-91|State QTR Unemployment Insurance Excess Wages|Quarterly wages in excess of the state UI taxable wage base
|92-105|State QTR Unemployment Insurance Taxable Wages|State QTR UI total wages less state QTR UI excess wages
|106-107 WA|Zero-hour Reason Blank|A numeric code to be entered only when a wage is reported but the employee has zero hours
|108-113|Standard Occupational Classification (SOC) Code|A 6-digit numeric SOC code that corresponds to the employee’s occupation. This field should come from the IDJB table (for the employee’s Job Code) - Occupation Code (IDOC)
|114-131| Blank|
|132-135 WA|Number of Hours Worked|The number of hours worked in the reporting period\\ \\Derived from [IDFDV] Field Sequence 3300
At line 119 changed one line
|147-161|Employment Security Reference Number\\ \\Enter state UI employer account number|SUI Registration Number from IDGV
|147-161|Employment Security Reference Number|Enter state UI employer account number\\ \\SUI Registration Number from IDGV
At line 121 changed one line
|210-210|Officer Code\\ \\Enter ‘1’ for officers of the corporation, else enter ‘0’|
|210-210|Officer Code|Enter ‘1’ for officers of the corporation, else enter ‘0’
At line 123 changed 4 lines
|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-220|Reporting Quarter and Year\\ \\Enter the last month and year for the calendar period for which this report applies (i.e. 062008 for Apr-June 2008)|
|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-220|Reporting Quarter and Year|Enter the last month and year for the calendar period for which this report applies (i.e. 062008 for Apr-June 2008)
At line 132 changed one line
|2-8|Total Number of Employees\\ \\The total number of ‘S’ records since the last ‘E’ record|
|2-8|Total Number of Employees|The total number of ‘S’ records since the last ‘E’ record
At line 135 changed 3 lines
|27-40|State QTR Unemployment Insurance Total Wages for Employer\\ \\QTR wages subject to state unemployment taxes\\ \\Total of this field on all ‘S’ records since the last ‘E’ record|
|41-54|State QTR Unemployment Insurance Excess Wages for employer\\ \\QTR wages in excess of the state UI taxable wage base\\ \\Total of all ‘S’ records since the last ‘E’ record|
|55-68|State QTR Unemployment Insurance Taxable Wages for employer\\ \\QTR UI total wages less state QTR UI excess wages\\ \\Total of all ‘S’ records since the last ‘E’ record|
|27-40|State QTR Unemployment Insurance Total Wages for Employer|QTR wages subject to state unemployment taxes\\ \\Total of this field on all ‘S’ records since the last ‘E’ record
|41-54|State QTR Unemployment Insurance Excess Wages for employer|QTR wages in excess of the state UI taxable wage base\\ \\Total of all ‘S’ records since the last ‘E’ record
|55-68|State QTR Unemployment Insurance Taxable Wages for employer|QTR UI total wages less state QTR UI excess wages\\ \\Total of all ‘S’ records since the last ‘E’ record
At line 139 changed 13 lines
|82-87 WA|UI tax rate this quarter\\ \\The employer UI rate for this reporting period\\ \\Six digits with one assumed decimal point (e.g. 2.8%=’028000’)|
|88-100|State QTR UI taxes due\\ \\UI taxes due\\ \\QTR state UI taxable wages times UI tax rate|
|101-111|Previous Quarter(s) Underpayment\\ \\State Specific Data\\ \\If not used, enter zero|
|112-122|Interest\\ \\State Specific Data\\ \\If not used, enter zero|
|123-133|Penalty\\ \\State Specific Data\\ \\If not used, enter zero|
|134-144|Credit/Overpayment\\ \\State Specific Data\\ \\If not used, enter zero|
|145-148 WA|Employment Administration Fund Tax Rate\\ \\Right Justify, Zero fill\\ \\Decimal point is assumed (e.g. 0.03%=0003)|
|149-159|Employment Administration Fund Assessment Amount\\ \\State Specific Data\\ \\If not used, enter zero|
|160-163 WA|Total Exempt Corporate Officers\\ \\State Specific Data\\ \\If not used, enter zero|
|164-174|Employee Assessment Amount\\ \\Blank|
|175-185|Total Payment Due\\ \\State Specific Data\\ \\If not used, enter zero|
|186-196 WA|Amount Remitted\\ \\State Specific Data\\ \\If not used, enter zero|
|197-200 WA|Additional 4 Digit Decimal Position for Amount Remitted\\ \\Blank|
|82-87 WA|UI tax rate this quarter|The employer UI rate for this reporting period\\ \\Six digits with one assumed decimal point (e.g. 2.8%=’028000’)
|88-100|State QTR UI taxes due\\ \\UI taxes due\\ \\QTR state UI taxable wages times UI tax rate
|101-111|Previous Quarter(s) Underpayment|State Specific Data\\ \\If not used, enter zero
|112-122|Interest|State Specific Data\\ \\If not used, enter zero
|123-133|Penalty|State Specific Data\\ \\If not used, enter zero
|134-144|Credit/Overpayment|State Specific Data\\ \\If not used, enter zero
|145-148 WA|Employment Administration Fund Tax Rate|Right Justify, Zero fill\\ \\Decimal point is assumed (e.g. 0.03%=0003)
|149-159|Employment Administration Fund Assessment Amount|State Specific Data\\ \\If not used, enter zero
|160-163 WA|Total Exempt Corporate Officers|State Specific Data\\ \\If not used, enter zero|
|164-174|Employee Assessment Amount\\ \\Blank
|175-185|Total Payment Due|State Specific Data\\ \\If not used, enter zero
|186-196 WA|Amount Remitted|State Specific Data\\ \\If not used, enter zero
|197-200 WA|Additional 4 Digit Decimal Position for Amount Remitted|Blank
At line 153 changed 3 lines
|227-233|Month-1 Employment for employer\\ \\Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record|
|234-240|Month-2 Employment\\ \\Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record|
|241-247|Month-3 Employment\\ \\Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month\\ \\Total for all ‘S’ records after the last ‘E’ record|
|227-233|Month-1 Employment for employer|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record
|234-240|Month-2 Employment|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record
|241-247|Month-3 Employment|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month\\ \\Total for all ‘S’ records after the last ‘E’ record
At line 163 changed 2 lines
|2-11|Total Number of Employees in File\\ \\Enter the total number of ‘S’ records in the entire file|
|12-21|Total Number of Employers in File\\ \\Enter the total number of ‘E’ records in the entire file|
|2-11|Total Number of Employees in File|Enter the total number of ‘S’ records in the entire file|
|12-21|Total Number of Employers in File|Enter the total number of ‘E’ records in the entire file|
At line 167 changed 3 lines
|41-55|Quarterly State Unemployment Insurance Total Wages in File\\ \\QTR wages subject to state UI tax\\ \\Total of this field for all ‘S’ records in the file|
|56-70|Quarterly State Unemployment Insurance Excess Wages in File\\ \\QTR wages in excess of the state UI taxable wage base\\ \\Total of this field for all ‘S’ records in the file|
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File\\ \\State UI gross/total wage less quarterly state UI excess wages\\ \\Total of this field for all ‘S’ records in the file|
|41-55|Quarterly State Unemployment Insurance Total Wages in File|QTR wages subject to state UI tax\\ \\Total of this field for all ‘S’ records in the file
|56-70|Quarterly State Unemployment Insurance Excess Wages in File|QTR wages in excess of the state UI taxable wage base\\ \\Total of this field for all ‘S’ records in the file
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File|State UI gross/total wage less quarterly state UI excess wages\\ \\Total of this field for all ‘S’ records in the file
At line 172 added 22 lines
!!State Quarterly UI Wage Reporting – .CSV File Format
[UEEF] must be run with the following report parameters defined to generate the Washington State Quarterly file information in the .CSV format. \\
||Parameter||Description||Source
|As Of Date|Enter the quarter end date, such as 30-Jun-20YY
|Interface Format Code|Use the annual supplied form code, such as 'HL$US-QTR-WA-20YY'. The 'Variables' need to be entered on this form code for specific use in the installation.
|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
!!Quarterly UI Wage Magnetic Media Reporting - .CSV File Format
||Column||Description||Source
|1|Social Security Number (SSN) or Individual Taxpayer Identification Number (ITIN) |This field must be numeric and may be formatted (i.e., 3 digits, dash, 2 digits, dash, 4 digits) or unformatted (nine digits) e.g., — ?123-45-6789? or — ?123456789? or blank, no spaces. \\ An ITIN is a 9-digit number issued by the IRS to identify an individual who is not eligible to receive an SSN.
|2|Last Name|Up to 30 characters
|3|First Name|Up to 30 characters
|4|Middle Name|Up to 30 characters
|5|Suffix|Optional, Up to 4 characters
|6|*Hours|Enter Quarterly hours subject to unemployment taxes \\ (from Pay Element 'REG HOURS' if the standard IDIF file definition 'HL$US-QTR-WA-20YY' is used)
|7|*Gross|Enter quarterly wages subject to unemployment taxes \\ (from Pay Element 'SUI WAGES' if the standard IDIF file definition 'HL$US-QTR-WA-20YY' is used)
|8|SOC|6 digits, Occupation Code from IDJB for the employee's Job
At line 179 removed one line
This page (revision-21) was last changed on 15-Feb-2023 15:08 by Karen ParrottTop