Skip Header Wisconsin.gov banner wisconsin.gov home        state agencies        subject directory

Wisconsin Department of Workforce Development

DWD Internet homepage Call Us For Help | About DWD | News | Documents | Sitemap
 

PART 3 - WAGE FILE UPLOAD DATA FORMATS


Following are specifications for the four data formats that may be used to submit quarterly wage reports on-line using Internet Wage File Upload.

Wisconsin UI Format - Alternative 1: This record format contains the employer UI account number and employee wage record information and quarter designation in one self-contained record per employee.

Federal IRS/SSA Tape Format - Alternative 2: This format is a modified IRS/SSA format. Although the IRS/SSA reporting allows for record types 'A','B','E','W','I','T','F', we will be capturing the necessary Wage Record information exclusively from record types 'E', employer record, and 'S', employee wage, and bypassing all other record types. The 'E' and 'S' record types have been modified to allow for UI information.

Note: Wages reported to IRS/SSA are different from Wisconsin UI total Gross Wages.

Federal IRS/SSA Diskette Format - Alternative 3: This is a modified Federal IRS/SSA Diskette format. There are four types: 'E' employer records '1' and '2', and 'W' Wage records '1' and '2'.

Note: Wages reported to IRS/SSA are different from Wisconsin UI Total Gross Wages.

Tab-Delimited Text Format - Alternative 4: Employers and Payroll Service Providers that prepare quarterly wage file using MS-Excel can convert their file to a tab-delimited text format and submit it via the Wage File Upload process.

Updated: October 27, 2009

Content Contact: UI Wage Reporting

Navigation Links