Contact Us (888) 300-4473

Excel File Layout Instructions


You can download our Excel template to assist you in creating your files.

Note: The first row showing the field names are optional. Each row in the excel file contains all required information for a single newhire.

Field Employer FEIN Employer Name Employer Address Line 1 Employer Address Line 2 Employer City Employer State Employer Zip Code Employer Zip +4 Employer Country Employer International Postal Code Employee SSN# Employee Last Name Employee First Name Employee Middle Name Employee Address Line 1 Employee Address Line 2 Employee City Employee State Employee Zip Code Employee Zip +4 Employee Country Employee International Postal Code Employee Date of Birth Employee Date of Hire Employee State of Hire Filler
Description Federal Employer Identification Number. Must be 9 digits; include leading zeroes. Left Justify Employer payroll processing address. Left justify Left justify if present. Spaces if unused Left justify Required if domestic address. Spaces if international address Required if domestic address. Spaces if international address If present, must be 4-digits. Spaces if unknown or international address Required if international address. Left justify. Spaces if domestic address. Do not report "USA" or "US" Spaces if domestic address or unknown Must be 9 digits Left justify Left justify Left justify. Space if unknown Left justify Left justify. Spaces if unused Left justify Required if domestic address. Spaces if international address Required if domestic address. Spaces if international address If present, must be 4-digits. Spaces if unknown or international address Required if international address. Left justify. Spaces if domestic address. Do not report "USA" or "US" Spaces if domestic address or unknown CCYYMMDD. Must be a valid date CCYYMMDD. Must be a valid date. Emloyee's first day of work Standard postal abbreviation. Only required if other than "WI" spaces
Status Required Required Required Optional Required Required Required Optional Required Optional Required Required Required Optional Required Optional Required Required Required Optional Required Optional Required Required Required Optional
Type Numeric Char Char Char Char Char Numeric Numeric Char Char Numeric Char Char Char Char Char Char Char Numeric Numeric Char Numeric Numeric Numeric Char Char
P.O. Box 14431 Madison, WI 53708 | Phone (888) 300-4473 | Fax (800) 277-8075
© 2009- 2024 Wisconsin New Hire Reporting Center. Site design by Stellarware