Homepage

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