COLUMN A) Payroll Employee No. – The employee number can be any alphanumeric combination you choose. Zeros can be added to the beginning of an Employee Number to create a uniform number of characters across all employees. This creates a uniform look and keeps the order consecutive. If you are using our HR solution, a new employee number will be created by that module once your information has been imported.

COLUMN B) Starting Date – This is the first day the employee worked.

COLUMN C) State – This must be the two-letter abbreviation for the state in capital letters. For example, Washington should be WA, not Wash., Washington, or washington. If there is a situation where an employee lives in one state and would receive unemployment from a different state there will need to be two rows for that employee, one for each state.

COLUMN D) Deduction/Exemption 1 – List deductions/exemptions according to the state’s withholding form.

COLUMN E) Deduction/Exemption 2 – List deductions/exemptions according to the state’s withholding form.

COLUMN F) Deduction/Exemption 3– List deductions/exemptions according to the state’s withholding form.

COLUMN G) Deduction/Exemption 4– List deductions/exemptions according to the state’s withholding form.

COLUMN H)Deduction/Exemption 5– List deductions/exemptions according to the state’s withholding form.

COLUMN I) Deduction/Exemption 6– List deductions/exemptions according to the state’s withholding form.

COLUMN J) Deduction/Exemption 7– List deductions/exemptions according to the state’s withholding form.

COLUMN K) Deduction/Exemption 8– List deductions/exemptions according to the state’s withholding form.

COLUMN L) Employee wages Exempt from State Income Tax – Enter True or False

COLUMN M) Status Code – This is optional because not all states require a status. Use whatever is on your form. This should be entered in all capital letters.

COLUMN N) Decimal 1 – This is also based on the state’s form. These fields are used when there is a specific amount to be withheld instead of a withholding allowance number. This is not the Additional Withholding amount.

COLUMN O) Decimal 2 – see above.

COLUMN P) Decimal 3 – see above.

COLUMN Q)Decimal 4 – see above.

COLUMN R) Boolean 1 – The Boolean fields are also based on the individual state’s form. These cannot be left blank. You must enter True or False.

COLUMN S) Boolean 2– see above.

COLUMN T) Boolean 3– see above.

COLUMN U) Boolean 4– see above.

COLUMN V) State bonus WH Percent – This field will depend on how your organization calculates bonuses. When processing a bonus check, if you calculate using the bonus percentage for state withholding, then you will enter that percentage.

COLUMN W) Employee Taxed in Two States – This field needs to be filled in with either True or False. Do not leave this field empty. If the employee has withholding taxes in more than one state, you would enter True. If you have this situation, please alert your Implementation Specialist.

COLUMN X) Exempt from State Income Tax Withholding – If you are Exempt from State Income Tax, mark True. Otherwise, mark False. This field is required.

COLUMN Y) Default State – This is an unemployment indicator (SUTA) and should be filled in with True or False. Do not leave this field blank. Mark this as True if this is the unemployment state.

COLUMN Z) Resident State – This indicates if the resident state is different from the default state for employees who have two rows on this form. Mark this as True for the state that is withholding unemployment. If the employee only has one row this field would be marked False.