Delaware Annual and Quarterly Reporting#

Set Up#

This document contains abbreviated set up requirements for the State of Delaware 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 tab must be set up for ‘State Registration’ for State/Province: Delaware.
• The IDGV Variables tab must be set up for ‘State Registration’ for State/Province: Delaware.
  • ‘W2 STATE MEDIA FILING’ - Delaware state accepts W2 wage report with federal and other state information, therefore, the Media Filing variable can be set to ‘01’, which will include state information in the Federal File. (However, it must be set to ‘02’ if a W2 magnetic media file is required for the state of DE only.)

IDGV - State SUI Registration#

• The IDGV Definition tab must be set up with ‘State SUI Registration’ for State/Province: Delaware
• The IDGV Variables tab must be set up with ‘State SUI Registration’ for State/Province: Delaware
  • ‘W2 STATE MEDIA FILING’- Must be ‘02’ to generate UI wage magnetic media file for Delaware

State File Procedures#

• The State of Delaware Department of Revenue accepts filing of W2 wages via magnetic media using the standard EFW2 file format supplied by the SSA. The required records are RA, RE, RS and RF.
  Code records are RW and RT are optional. Code records RV, RW, RO, RT and RU will be ignored if submitted.
• The Delaware Department of Labor accepts filing of Quarterly UI wages via magnetic media using the ICESA format. The required record codes are ‘E’, and ‘S’.
• When using the EFW2 format to file wage report for the state of Delaware, IDGV must be set up as follows:
  • for State Registration of Delaware, the IDGV Variables:
    • ‘W2 STATE MEDIA FILING’ 02 – State requires its own file, do not include other state information in the state file.

RPYEU must be run with the following report parameters and filters defined to generate the Delaware state 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: Delaware, USA

State Media Magnetic Media Reporting – EFW2 file Format#

Record Name: Code RA – Submitter Record (same as federal code RA)#

Record Name: Code RE – Employer Record (same as federal code RE)#

Record Name: Code RS – State Wage Record (same as federal specified code RS)#

Record Name: Code RF – Final Record (same as federal code RF)#

Quarterly UI Wage Reporting – ICESA Format#

The Delaware Department of Labor accepts filing of Quarterly UI wages via magnetic media using the ICESA format.
Record Codes E and S are required.

RPYEU must be run with the following report parameters and filters defined to generate Delaware State 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 "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: Delaware, USA

Record Name: Code E - Employer Record (Required)#

Column	Description	Source
1-1	Record Identifier	Constant ‘E’
2-5 DE	Reporting Period	Enter the month and year the report is being prepared for, in MMYY format
6-14	Federal Identification Number (FEIN)	Enter the tranmitter's FEIN. Only numeric characters. Omit hyphens, prefixes and suffixes. Derived from the IDGV State SUI Registration
15-16 DE	Blank	Fill with blanks
17-22 DE	State Account Number	Enter the 6 digit State account number
23 DE	Blank	Fill with blanks
24-73	Employer Name	Enter the employer’s name. Derived from the Entity.
74-160 DE	Blank	Fill with blanks
161-162 DE	Blocking Factor	Constant "25"
163-275 DE	Blank	Fill with blanks

Record Name: Code S – Employee Wage Record (Required)#

Column	Description	Source
1-1	Record Identifier	Constant ‘S’
2-10	Social Security Number	Enter the employee’s SSN. Do not drop the leading zeros. If not known, fill with blanks
11 DE	Employee First Initial	Enter the employee's first name initial
12 DE	Employee Middle Initial	Enter the employee's middle initial
13 DE	Blank	Fill with blanks
14-37 DE	Employee Last Name	Enter the employee's last name
38-123 DE	Blank	Fill with blanks
124-125 DE	State Code	Enter the appropriate State Code. Delaware is "10"
126-127 DE	Blank	Fill with blanks
128-131 DE	Reporting Period	Enter the month and year the report is being prepared for, in MMYY format
132-140 DE	Employee Wages	Enter the total employee wages
141-149 DE	Blank	Fill with blanks
150-151 DE	Number of Weeks Worked	Enter the total number of hours worked during the reporting period.
152-275 DE	Blank	Fill with blanks

---

Notes#

Click to create a new notes page