Delimited File Format Instructions
Files can be submitted in either Tab or Comma Delimited format. Tab or Comma Delimited files must include all of the following fields, in the order listed.
Each field may be enclosed by double-quotes. Each record line of the file should represent one record.
You can download our CSV Template or Tab-Delimited Template to assist you in creating your files.
| Field | Type | Status | Comments |
|---|---|---|---|
| Employee First Name | Char | Required | At least one character, no special characters. |
| Employee Middle Initial | Char | Optional | |
| Employee Last Name | Char | Required | At least one character, no special characters except hyphen. |
| Employee Address Line 1 | Char | Required | At least two characters, left justify. |
| Employee Address Line 2 | Char | Optional | |
| Employee City | Char | Required | At least two characters, no special characters except hyphen. |
| Employee State | Char | Required | Valid 2 letter FIPS abbr. (e.g. TN) |
| Employee Zip | Numeric | Required | All zeros will be rejected |
| Employee Zip+4 | Numeric | Optional | |
| Employee Social Security Number or ITIN | Numeric | Required | No hyphens |
| Employer Name | Char | Required | At least two characters, left justify. |
| Employer Address Line 1 | Char | Required | At least two characters, left justify. |
| Employer Address Line 2 | Char | Optional | |
| Employer City | Char | Required | At least two characters, left justify. |
| Employer State | Char | Required | Valid 2 letter FIPS abbr. (e.g. TN) |
| Employer Zip | Numeric | Required | All zeros will be rejected |
| Employer Zip+4 | Char | Optional | |
| Employer FEIN | Numeric | Required | 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 center. |
| Employer Payroll Address Line 1 | Char | Optional | Address where employee’s check is processed |
| Employer Payroll Address Line 2 | Char | Optional | |
| Employer Payroll City | Char | Optional | |
| Employer Payroll State | Char | Optional | |
| Employer Payroll Zip | Numeric | Optional | |
| Employee Date of Hire | Numeric | Required | Format - CCYYMMDD |
| Left Your Employment During Period | Char | Optional | Y=Yes, N=No |
| Employee Date of Birth | Numeric | Optional | Format - CCYYMMDD |
| Employee Gender | Char | Optional | |
| Employee Work State | Char | Optional | Valid 2 letter FIPS abbr. (e.g. TN) |
| Earned Income Tax Credit Indicator | Char | Optional | Y=Yes, N=No |
| Is Medical Insurance Available to Employee? | Char | Optional | Y=Yes, N=No |
| Outlet or Store Number | Char | Optional |