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 Employee SSN# Employee Last Name Employee First Name Employee Middle Initial Employee Address Line 1 Employee Address Line 2 Employee City Employee State Employee Postal Code Employee Zip+4 Employer Name Employer Address Line 1 Employer Address Line 2 Employer City Employer State Employer Postal Code Employer Zip+4 Employer FEIN Employer State EIN Employee Date of Hire Employee Date of Birth Filler
Description As reported by employee. At least one character, no special characters except hyphen. At least one character, no special characters. If non-blank must be one character, no special characters. At least two characters, left justify Left justify. Spaces if unused. At least two characters, no special characters except hyphen. Valid state or territory abbreviation. U.S. 5 digit zip code, left justified. If present, must be 4-digits. Spaces if unknown At least two characters, left justify. At least two characters, left justify. Left justify if present. Blank if unused. At least two characters, left justify Valid state or territory abbreviation. U.S. 5 digit zip code, left justified. If present, must be 4-digits. Spaces if unknown Federal Employer Identification Number (no hyphens). Use the same FEIN for which listed employee(s) quarterly wages will be reported under. If you have questions, please contact our Registry. State Employer Identification Number (no hypens). This is the 7-digit state employer number used on the NCUI101 Employer Quarterly Tax and Wage Report Numeric. Format - MMDDYYYY If present, numeric. Format - MMDDYYYY Leave blank
Status Required Required Required Optional Required Optional Required Required Required Optional Required Required Optional Required Required Required Optional Required Optional Required Optional Required
Type Numeric Char Char Char Char Char Char Char Numeric Numeric Char Char Char Char Char Numeric Numeric Numeric Numeric Numeric Numeric Char