Home > Unemployment Insurance > File a Tax Report > Electronic Reporting For Employer Service Providers > Request Tax Rates > File Formats

Employer Service Providers

Acceptable Media for Rate Requests include:

• Compact Disc or 3-1/2 Inch Diskette



• Excel Spreadsheet
• Text file




DWD Accepted File Formats for Electronic Tax Rate Inquiries on Compact Disc or 3-1/2 Inch Diskette

The file you submit will be uploaded to a mainframe computer for processing. Therefore, the required spaces are crucial to maintaining the necessary layout for a successful run. DWD will only accept the two file formats defined below, Excel spreadsheet or text file. Of the two options, the Excel spreadsheet is the preferred option because the correct number of spaces is not mandatory.

EXCEL Spreadsheet File Format

Enter UI Account number in Column A       10 digits (Required)

Enter Old Rate in Column C                     7 digits (Optional)

Enter Employer Information in Column E     40 digits (Optional)

Example:

Col A	Col B	Col C	Col D	Col E
5555550001		0002500
4444400007		0011000		Employer's Business Name

• Format all columns to text



• There is an implied decimal place after the third digit of the rates. The above rate would be 001.1000.



• No spaces are needed in Col B and Col D.



• Employer Information entered longer than 40 characters will be truncated on the return file to 40.



• New Rate will be returned in Column D.

Return File Format

We will return the new rates in the same file format you provided.

Example:

1234567890       0013000       0000500       Wisconsin Dept. of Workforce Development

5555550001       0002500       0002500





Text File Format

Fields	UI Account Number	Spaces	Old Rate	Spaces	New Rate	Spaces	Employer's Business Name
Digits Required	10	7	7	7	7	2	40
Data Required	Yes	Yes	Optional	Yes	No	Yes	Optional

Example:

1234567890       0013000       Employer's Business Name  

• There is an implied decimal place after the third digit of the rates. The above rate would be 001.3000.



• The old rate and the employer information fields will be returned in the output file with the new rate filled in.



• If you include the employer's business name, which is optional, you must include:



• the old rate or 7 spaces for the old rate, and
• 7 spaces for the new rate

Return File Format

We will return the new rates in the same file format you provided.

Example:

1234567890       0013000       0000500       Wisconsin Dept. of Workforce Development

5555550001       0002500       0002500




Updated June 10, 2009
Bureau of Tax and Accounting
Content Contact: Tax & Accounting Staff