Wage File Internet Upload Data Formats
Wisconsin Unemployment Insurance accepts quarterly wage data in four data formats:
Wisconsin UI Format - Alternative 1: This record format contains the employer UI account number, employee wage information and quarter designation in one self-contained 80 byte record per employee.
Federal IRS/SSA Tape Format - Alternative 2: This is a modified IRS/SSA tape format. We will be capturing wage record information exclusively from record types 'E' and 'S'. Each record is 275 bytes in length.
Federal IRS/SSA Diskette Format - Alternative 3: This is a modified IRS/SSA diskette format. We will be capturing wage record information from record types '1E', '2E', '1W', and '2W". Each record is 128 bytes in length.
Tab-Delimited Text File Format - Alternative 4: This is a tab-delimited text file format that is similar to the WI UI Format. This format allows employers and agents who maintain and submit quarterly wage data using MS Excel to convert an Excel file to a tab-delimited text file that the on-line tax and wage reporting application will accept.