This page (revision-66) 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
66 26-Nov-2021 10:22 13 KB Meg McFarland to previous
65 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
64 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
63 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
62 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
61 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - DC
Tax Reporting - DC

Version management

Difference between version and

At line 4 added one line
At line 6 added 2 lines
%%information Note that while DC has indicated that it will migrate to the [ICESA] file format for UI reporting in the future, we continue to support the UI wage reporting for the District of Columbia in the special DC-80 byte file format until further notice.%%
At line 77 removed 2 lines
The District of Columbia accepts quarterly UI reporting in the ICESA formal. Record codes A, E, S, T and F are required.
\\ \\
At line 95 changed one line
!Record Name: Code A - Transmitter Record
At line 99 changed 7 lines
|2-5 DC|Blank|Fill with blanks
|6-14|Submitter's Federal Employer Identification Number (FEIN)|Enter the submitter’s Federal Employer ID number. \\Enter only numeric characters. Omit hyphen, prefixes & suffixes.
|15-23 DC|Blank|Fill with blanks
|24-73|Business Name|Enter the legal name of the organization submitting the file. \\Enter the name exactly as the Employer is registered with the state Unemployment Insurance agency.
|74-113|Business Address|Enter the street address of the organization submitting the file.
|114-138|Business City|Enter the city of the organization submitting the file.
|139-140|Business State|Enter the standard two character FIPS postal abbreviation. DC is "11"
|2-5|Year|Enter the year this report is prepared for \\Derived from the user specified FROM-TO period converted to YYYY
|6-14|Transmitter’s Federal Employer Identification Number (FEIN)|Enter the transmitter’s Federal Employer ID number. \\Enter only numeric characters. Omit hyphen, prefixes & suffixes.
|15-18|Taxing Entity Code|Constant “UTAX”
|19-23|Blank|Fill with blanks
|24-73|Transmitter Name|Enter the name of the organization submitting the file. \\Enter the name exactly as the Employer is registered with the state Unemployment Insurance agency.
|74-113|Transmitter Street|Enter the street address of the organizationsubmitting the file.
|114-138|Transmitter City|Enter the city of the organization submitting the file.
|139-140|Transmitter State|Enter the standard two character FIPS postal abbreviation.
At line 107 changed 8 lines
|154-158|Transmitter Zip Code|Enter the transmitter's zip code
|159-163|Transmitter Zip Code Extension|Enter the transmitter's four digit extension of the zip code, if applicable \\Include hyphen in position 159. \\If unknown, fill with blanks.
|164-193|Transmitter Contact|Enter the name of individual from transmitter's organization who is responsible for the accuracy and completeness of the wage report.
|194-203|Transmitter Contact Telephone Number|Enter the telephone number where the transmitter's contact can be reached. \\Numbers only, no special characters
|204-207|Telephone Extension/Box|Enter transmitter's telephone extension number or message box.
|208-242 DC|Not Required for the District of Columbia|Fill with blanks
|243-250|Media Creation Date|Enter the date the file was created, in MMDDYYYY format \\Derived from the System date
|251-276|Blank|
|154-158|Transmitter Zip Code|Enter a valid zip code
|159-163|Transmitter Zip Code Extension|Use this field as necessary for the four digit extension of the zip code. \\Include hyphen in position 159. \\If unknown, fill with blanks.
|164-193|Transmitter Contact|Enter the title of individual from transmitter's organization who is responsible for the accuracy and completeness of the wage report.
|194-203|Transmitter Contact Telephone Number|Enter the telephone number where the transmitter's contact can be reached
|204-207|Telephone Extension/Box|Enter transmitter's telephone extension or message box.
|208-242|Not Required for the District of Columbia|Fill with blanks
|243-250|Media Creation Date|Enter the date in MMDDYYYY format \\Derived from the System date
|251-275|Blank|
At line 117 changed one line
!Record Name: Code E - Employer Record (Required)
!Record Name: Code B - Authorization Record
At line 121 added 23 lines
|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 the BASIC EIN (seq 2010) [IDFDV] Field Identifier.
|15-22|Computer|Enter the manufacturer’s name. \\Derived from the ‘BASIC COMPUTER’ (seq 2020) [IDFDV] Field Identifier.
|23-24|Internal Label|Enter SL, NS, NL, AL or blank for diskette. \\Derived from the ‘BASIC INTERNAL LABEL’ (seq 2100, first 2 characters) [IDFDV] Field Identifier.
|25-25|Blank|Fill with blanks
|26-27|Density|Enter 16, 62, 38 or blank for diskette. \\Derived from the ‘BASIC DENSITY’ (seq 2110) [IDFDV] Field Identifier.
|28-30|Recording Code (Character Set)|Enter EBC or ASC. \\Always enter ASC for diskette. \\Derived from the ‘BASIC RECORDING MODE’ (seq 2120, first 3 characters) [IDFDV] Field Identifier.
|31-32|Number of Tracks|Enter 09 or 18 or blanks for diskette. \\Derived from the ‘BASIC RECORDING MODE’ (seq 2120, fourth and fifth character) [IDFDV] Field Identifier.
|33-34|Blocking Factor|Enter the blocking factor of the file. Not to exceed 85. \\Enter blanks for diskette. \\Derived from the ‘BLOCKING FACTOR’ (seq 3050) [IDFDV] Field Identifier.
|35-38|Taxing Entity Code|Constant ‘UTAX’
|39-146|Blank|Fill with blanks
|147-190|Organization Name|Enter the name of the organization who the media should be returned to. \\Derived from the ‘BASIC NAME’ (seq 2040) [IDFDV] Field Identifier.
|191-225|Street Address|Enter the street address of the organization who the media should be returned to. \\Derived from the ‘BASIC ADDRESS’ (seq 2050) [IDFDV] Field Identifier.
|226-245|City|Enter the City of the organization who the media should be returned to. \\Derived from the ‘BASIC CITY’ (seq 2060) [IDFDV] Field Identifier.
|246-247|State|Enter the standard two-character FIPS postal abbreviation. \\Derived from the ‘BASIC STATE’ (seq 2070) [IDFDV] Field Identifier.
|248-252|Blank|Fill with blanks
|253-257|ZIP Code|Enter a valid ZIP code. \\Derived from the ‘BASIC ZIP CODE’ (seq 2090) [IDFDV] Field Identifier.
|258-262|ZIP Code extension|Enter the four-digit extension of ZIP code, including the hyphen, in position 258. \\Derived from the ‘BASIC ZIP EXTN’ (seq 2080) [IDFDV] Field Identifier.\\ \\Clients must include the hyphen (‘-‘) when defining the [IDFDV] Seq 2080
|263-275|Blank|Fill with blanks
!Record Name: Code E - Employer Record
||Column||Description||Source
At line 123 changed 4 lines
|24-73|Employer's Legal Name|Enter the first 50 positions of the employer’s legal name, exactly as registered with the state UI agency. \\Derived from the Entity.
|74-113|Address Where Work Performed|Enter the street address where the employee performed work. \\Left justify and fill with blanks \\Derived from the Entity Location.
|114-138|Employer City|Enter the employer's City \\Derived from the Entity Location
|139-140|Employer State|Constant "DC" \\Derived from the Entity Location
|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's mailing address. \\Derived from the Entity Location.
|114-138|Employer City|Enter the City of the employer's mailing address. \\Derived from the Entity Location
|139-140|Employer State|Enter the appropriate FIPS postal numeric code. \\Derived from the Entity Location
At line 129 changed 2 lines
|154-158|ZIP code|Enter the employer's ZIP code \\Derived from the Entity Location.
|159-166 DC|Blank|Fill with blanks
|154-158|ZIP code|Enter a valid ZIP code \\Derived from the Entity Location.
|159|Blank|Fill with blanks
|160|Type of Employment|Enter A, H, M, Q, R, or X \\Derived from [IDFDV] Field Identifier ‘TYPE OF EMPLOYMENT’
|161-162|Blocking Factor|Enter the blocking factor of the file. Not to exceed 85. \\Enter blanks for diskette
|163-166|Establishment Number or Coverage Group/PRU|Enter either the establishment number of the coverage group/PRU, or fill with blanks \\Derived from the Field Identifier ESTABLISHMENT NUMBER
At line 132 changed 5 lines
|171-172|State Code|Enter the appropriate FIPS postal numeric code. DC is "11"
|173-187|State Unemployment Insurance Account Number|Enter the State UI employer account number \\Left justify and zero fill \\Derived from the IDGV State SUI Registration.
|188-189|Report Quarter|Enter the last month of the calendar quarter the report applies to, such as: 03, 06, 09, or 12
|190-190|No Wage Report Indicator|Enter a "0" if the employer did not pay wages during the calendar quarter and there will not be any employee records in the report. Otherwise enter "1"
|191-276 DC|Not required|Fill with blanks
|171-172|State Code|Enter the appropriate FIPS postal numeric code. \\
|173-187|State Unemployment Insurance Account Number|Enter the State UI employer account number \\Derived from the IDGV State SUI Registration.
|188-189|Reporting Period|Enter the last month of the calendar quarter the report applies to. Such as: 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’ employee records. \\Enter ‘1’ to indicate that the E record will be followed by ‘S’ employee records.
|191-255 DC|Not required|Fill with blanks
|256|Foreign Indicator|If data in positions 74-158 is for a foreign address, enter the letter ‘X’, otherwise leave it blank. \\Derived from [IDFDV], Field Identifier: ‘FOREIGN ADDR INDICATOR’
|257-276 DC|Blank|Fill with blanks
At line 138 removed one line
At line 142 changed 20 lines
|2-10|Social Security Number|Enter the employee’s SSN. Do not drop the leading zeros. \\If not known, enter ‘I’ in position 2 and fill with blanks
|11-30|Employee Last Name|Enter the employee's last name. \\Left justify and fill with blanks
|31-42|Employee First Name|Enter the employee's first name. \\Left justify and fill with blanks
|43-43|Employee Middle Initial|Enter the employee's middle initial. If no middle initial, fill with blanks
|44-45|State Code|Enter the appropriate FIPS postal numeric code. DC is "11"
|46-63 DC|Not Required for District of Columbia|Fill with blanks
|64-77|State QTR Unemployment Insurance Total Wages|Enter the total quarterly gross wages paid. \\Include cents but omit decimal. \\Include all tip income. \\Derived from the 7200 [IDFDV] Field Identifier.
|78-131 DC|Blank|Fill with blanks
|132-134 DC|Number of Hours Worked|Enter the number of hours the employee worked in the reporting period. \\Right justify and fill with zeroes
|125-146 DC|Blank|Fill with blanks
|147-161|State Unemployment Insurance Account Number|Enter the State Unemployment Insurance Account Number \\Right justify and fill with blanks \\Derived from the SUI Registration Number from on [IDGV]
|162-176 DC|Blank|Fill with blanks
|177 DC|Adjustment Reason|Enter the reason code for adjustment to employee wages
|178-209 DC|Blank|Fill with blanks
|210 DC|Owner/Officer Relationship|Include the owner/officer relationship of the worker.
|211-214 DC|Blank|Fill with blanks
|215-220 DC|Reporting Quarter and Year|Enter the last month and year of the calendar quarter this report applies to, in MMYYYY format. Example: 0320YY for first quarter of 20YY
|221-226 DC|Month First Employed|Enter the month and year when the employee was first employed, in MMYYYY format \\Optional. Fill with blanks if not known.
|227-232 DC|Month the employee became separated from employment|Enter the month and year when the employee separated from employment, in MMYYYY format \\Optional. Fill with blanks if not known.
|233-276 DC|Blank|Fill with blanks
|2-10|Social Security Number|Enter the employee’s full nine-digit SSN. Do not drop the leading zeros. \\If not known, enter ‘I’ in position 2 and fill with blanks
|11-30|Employee Last Name|Enter the employee's last name.
|31-42|Employee First Name|Enter the employee's first name.
|43-43|Employee Middle Initial|Enter the employee's middle initial. Leave blank if no middle initial
|44-45|State Code|Enter the appropriate FIPS postal numeric code.
|46-49 DC|Not Required for District of Columbia|Fill with blanks
|64-77|State QTR Unemployment Insurance Total Wages|Enter the total quarterly gross wages paid. Include all tip income. \\Derived from the 7200 [IDFDV] Field Identifier.
|78-91|State QTR Unemployment Insurance Excess Wages|Enter the total State quarterly Unemployment Insurance Excess Wages \\Derived from the State quarterly UI total wages less the State quarterly UI excess wages.
|92-105|State QTR Unemployment Insurance Taxable Wages|Enter the State quarterly UI total wages \\Derived from the State quarterly UI total wages less state quarterly UI excess wages.
|106-134|Not required for the District of Columbia|Fill with blanks
|135-142|Blank|Fill with blanks
|143-146|Taxing Entity Code|Constant ‘UTAX’
|147-161|State Unemployment Insurance Account Number|SUI Registration Number from [IDGV]
|162-214 DC|Not required for the District of Columbia|Fill with blanks
|215-220|Reporting Quarter and Year|Enter the last month and year for the calendar quarter this report applies to. Example: 0320YY for first quarter of 20YY
|221-276|Not Required for District of Columbia|Fill with blanks
At line 163 changed one line
!Record Name: Code T - Total Record (Required)
!Record Name: Code T - Total Record
At line 166 changed 12 lines
|2-8|Total Number of Employees|Enter the total number of ‘S’ records reported since the last ‘E’ record \\Right justify and zero fill
|9-26 DC|Blank|Fill with blanks
|27-40|State QTR Unemployment Insurance Total Wages for Employer|Enter the total quarterly gross wages subject to State unemployment tax. Include all tip income. \\Include cents but omit decimal. \\Right justify and fill with zeroes \\The total of this field on all ‘S’ records since the last ‘E’ record
|41-54|State QTR Unemployment Insurance Excess Wages for Employer|Enter the total quartertly wages in excess of the State UI taxable wage base. Include all tip income. \\Include cents but omit decimal. \\Right justify and fill with zeroes \\ Total of all ‘S’ records since the last ‘E’ record
|55-68|State QTR Unemployment Insurance Taxable Wages for Employer|Enter the quartertly UI total wages less state quartertly UI excess wages. \\Right justify and zero fill \\ Total of all ‘S’ records since the last ‘E’ record
|69-81 DC|Blank|Fill with blanks
|82-87 DC|Reporting Quarter and Year|Enter the last month and year this report applies to, in MMYYYY format. \\Right justify and zero fill
|88-226 DC|Blank|Fill with blanks
|227-233|Month 1 Employment for Employer|Enter the number of covered employees who worked or received pay for the pay period including the 12th day of the 1st month of the reporting period. \\Right justify and zero fill
|234-240|Month 2 Employment for Employer|Enter the number of covered employees who worked or received pay for the pay period including the 12th day of the 2nd month of the reporting period. \\Right justify and zero fill
|241-247|Month 3 Employment for Employer|Enter the number of covered employees who worked or received pay for the pay period including the 12th day of the 3rd month of the reporting period. \\Right justify and zero fill
|248-276|Blank|Fill with blanks
|2-8|Total Number of Employees|Enter the total number of ‘S’ records reported since the last ‘E’ record
|9-12|Taxing Entity Code|Constant ‘UTAX’
|13-26 DC|Not required for the District of Columbia|Fill with blanks
|27-40|State QTR Unemployment Insurance Total Wages for Employer|Enter the total quarterly gross wages subject to State unemployment tax. Include all tip income. \\The total of this field on all ‘S’ records since the last ‘E’ record
|41-54|State QTR Unemployment Insurance Excess Wages for employer|Enter the total quartertly 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|Enter the quartertly UI total wages less state quartertly UI excess wages. \\ Total of all ‘S’ records since the last ‘E’ record
|69-81 DC|Not required for the District of Columbia|Fill with blanks
|82-87|UI tax rate this quarter|Enter the employer UI rate for this reporting period. \\Format: One decimal point followed by 5 digits, such as 2.8% = .02800
|88-100|State QTR UI taxes due|Enter the total quarterly UI taxes due. \\Derived from the quartertly state UI taxable wages multiplied by the UI tax rate
|101-111|Previous Quarter(s) underpayment|State Specific Data\\If not used, fill with zeroes
|112-122|Interest|State Specific Data \\If not used, fill with zeroes
|123-133|Penalty|State Specific Data \\If not used, fill with zeroes
|134-148 DC|Not required for the District of Columbia|Fill with blanks
|149-159|Employer Assessment Amount|State Specific Data \If not used, fill with zeroes
|160-174 DC|Not required for the District of Columbia|Fill with blanks
|175-185|Total Payment Due|State Specific Data \\If not used, fill with zeroes
|186-226 DC|Not required for the District of Columbia|Fill with blanks
|227-233|Month 1 Employment for Employer|Enter number of covered employees who worked or received pay for the pay period including the 12th day of the 1st month of the reporting period.
|234-240|Month 2 Employment for Employer|Enter number of covered employees who worked or received pay for the pay period including the 12th day of the 2nd month of the reporting period.
|241-247|Month 3 Employment for Employer|Enter number of covered employees who worked or received pay for the pay period including the 12th day of the 3rd month of the reporting period.
|248-276|Not required|Fill with blanks
At line 180 changed one line
!Record Name: Code F - Final Record (Required)
!Record Name: Code F - Final Record
At line 183 changed 4 lines
|2-11|Total Number of Employees in File|Enter the total number of ‘S’ records in the entire file \\Right justify and zero fill
|12-40 DC|Blank|Fill with blanks
|41-55|Quarterly State Unemployment Insurance Total Wages in File|Enter the total quarterly wages subject to state UI tax \\Include cents but omit decimal. \\Right justify and fill with zeroes \\Total of this field for all ‘S’ records in the file
|56-276 DC|Blank|Fill with blanks
|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|The total number of ‘E’ records in the entire file
|22-25|Taxing Entity Code|Constant ‘UTAX’
|26-40 DC|Not required for the District of Columbia|Fill with blanks
|41-55|Quarterly State Unemployment Insurance Total Wages in File|Enter the total quarterly 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|Enter the total quarterly wages in excess of the state UI taxable wage base \\Total of this field for all ‘S’ records in the file
|71-115 DC|Not required for the District of Columbia|Fill with blanks
|116-123|Month-1 Employment for employers in file|Enter the total number of employees covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month \\Total of this field on all ‘S’ records in the file
|124-131|Month-2 Employment for employers in file|Enter the total number of employees covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month \\Total of this field on all ‘S’ records in the file
|132-139|Month-3 Employment for employers in file|Enter the total number of employees covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month \\Total of this field on all ‘S’ records in the file
|140-275|Blank|
This page (revision-66) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop