Employee List Fields (Import/Export)

Employee ID

Y

Alphanumeric - Employee ID number

Employee First Name

Y

Alphanumeric - Employee name

Employee Middle Initial

Y

Alphanumeric - Employee name

Employee Last Name

Y

Alphanumeric - Employee name

Sales Rep

Y

Boolean - Sales Rep check box; valid choices are [True] or [False]

Employee

Y

Boolean - Employee check box; valid choices are [True] or [False].

Inactive

Y

Boolean - Inactive check box; valid choices are [True] or [False], where True=Inactive and False=Active.

Address-Line One

Y

Alphanumeric - Employee Address line 1

Address-Line Two

Y

Alphanumeric - Employee Address line 2

City

Y

Alphanumeric - Employee city

State

Y

Alphanumeric - Employee state

Zip

Y

Alphanumeric - Employee ZIP Code

Country

Y

Alphanumeric - Employee country

Employee Social Security #

Y

Alphanumeric - Employee social security number

Employee Type

Y

Alphanumeric - Employee type category

Home Phone

Y

Alphanumeric - Employee home phone number

Employee Email

Y

Alphanumeric - Employee email address (use the [email protected] format)

Federal Filing Status

Y

Numeric (Whole) - Federal filing status; valid numbers are 0 and 1, where 0=Single and 1=Married.

Federal Allowances

Y

Numeric (Whole) - Number of allowances the employee is claiming, enter 99 if employee is exempt.

Additional Fed Withholdings

Y

Numeric (Real) - Any additional withholdings the employee has requested.

State Filing Status

Y

Numeric (Whole) - State filing status; valid numbers are 0 to 15, where 0=Single and 1=Married, 2=Head/Household, 3=Not Required, 4=Married/Jointly, 5=Married/Separately, 6=Qualifying Widow(er), 7=Married/2 Incomes, 8=Special A, 9=Special B, 10=Special C, 11=Special D, 12=Special E, 13=Special F, 14=Special G, 15=Special H.

State Allowances

Y

Numeric (Whole) - Number of allowances the employee is claiming, enter 99 if employee is exempt.

Additional State Withholdings

Y

Numeric (Real) - Any additional withholding the employee has requested.

W2 ID-State

Y

Alphanumeric - Enter the state ID for the W2 forms. This is the state abbreviation. For example, use [GA] for the state of Georgia.

Local Filing Status

Y

Numeric (Whole) - Local filing status; valid numbers are 0 to 15, where 0=Single and 1=Married, 2=Head/Household, 3=Not Required, 4=Married/Jointly, 5=Married/Separately, 6=Qualifying Widow(er), 7=Married/2 Incomes, 8=Special A, 9=Special B, 10=Special C, 11=Special D, 12=Special E, 13=Special F, 14=Special G, 15=Special H.

Local Allowances

Y

Numeric (Whole) - Number of allowances the employee is claiming, enter 99 if employee is exempt.

Additional Local Withholdings

Y

Numeric (Real) - Any additional withholding the employee has requested.

W2 ID-Local

Y

Alphanumeric - Enter the local ID for the W2 forms. This is the location within the state. For example, [NYC RES] for New York City residents.

Retirement Plan

Y

Boolean - Retirement Plan check box, valid choices are [True] or [False]. Check this box if you want the Pension box on the employee's W2 form checked.

Statutory

Y

Boolean - Statutory check box; valid choices are [True] or [False]. Check this box if this contractor qualifies as a statutory employer.

Date Hired

Y

Date - Date employee was hired. Must be in ##/##/## (month/day/yr) format. (This field is required if using Electronic Time and Attendance.)

Date Last Raise

Y

Date - Date of employee's last raise. Must be in ##/##/#### (month/day/yr) format.

Date Terminated

Y

Date - Date of employee's resignation or termination. Must be in ##/##/## (month/day/yr) format.

Label for Employee Custom Field 1

(entered in Employee Defaults)

Y

Alphanumeric - The text value of employee custom field 1 (entered in Maintain Employees/Sales Reps).

Label for Employee Custom Field 2

(entered in Employee Defaults)

Y

Alphanumeric - The text value of employee custom field 2 (entered in Maintain Employees/Sales Reps).

Label for Employee Custom Field 3

(entered in Employee Defaults)

Y

Alphanumeric - The text value of employee custom field 3 (entered in Maintain Employees/Sales Reps).

Label for Employee Custom Field 4

(entered in Employee Defaults)

Y

Alphanumeric - The text value of employee custom field 4 (entered in Maintain Employees/Sales Reps).

Label for Employee Custom Field 5

(entered in Employee Defaults)

Y

Alphanumeric - The text value of employee custom field 5 (entered in Maintain Employees/Sales Reps).

Pay Method

Y

Numeric (Whole) - The employees pay method; valid choices are 0=Salary, 1=Hourly-Hours Per Pay Period, 2=Hourly-Time Ticket Hours (Sage 50 Premium Accounting and higher), and 3=Hourly-Electronic Time (no longer supported).

Pay Frequency

Y

Numeric (Whole) - Frequency of employee payment; valid numbers are: 0=Weekly, 1=Bi-weekly, 2=Semi-monthly, 3=Monthly, and 7=Annually.

Hours Per Pay Period

Y

Numeric (Positive) - If Payment Method=1, then this field is required. If Payment Method=0, 2, or 3, then this field must be blank or zero.

Hourly Billing Rate

Y

Numeric - The hourly rate used when applying this employee's time tickets to customer invoices. All employees have access to this field (salaried or hourly). This field is not required. (Sage 50 Premium Accounting and higher)

Pay Info-Use Standard (there are 20 levels)

Y

Boolean - Employee's Pay Info Levels (1-20) custom/standard check box; valid choices are [True] or [False], where True=custom and False=use standard.

Pay Info-Account ID (there are 20 levels)

Y

Alphanumeric - G/L Gross account no. for Levels 1-20 (if you are not using standard). Must be a valid account number from your Chart of Accounts.

Pay Info-Rate/Amount (there are 20 levels)

Y

Numeric (Real) - The hourly rate or salary amount for Levels 1-20.

EmpEE Fields-Use Custom (there are 40 employee fields)

Y

Boolean - Employee's Fields 1-40 custom/standard check box; valid choices are [True] or [False], where True=custom and False=use standard.

EmpEE Fields-Account ID (there are 40 employee fields)

Y

Alphanumeric - Employee's Fields'

1-40 G/L account no. (if you are not using standard). Must be a valid account number from your Chart of Accounts.

EmpEE Fields-Calc On (there are 40 employee fields)

Y

Boolean - Employee Fields 1-40 calculation check box; valid choices are [True] or [False], where True=calculation on and False=calculation off.

EmpEE Fields-Calc Name (there are 40 employee fields)

Y

Alphanumeric - Employee Fields

1-40 calculation name from the payroll tax tables.

EmpEE Fields-Amount (there are 40 employee fields)

Y

Numeric (Real) - Employee Fields (1-40) amount if the field is not a calculation. Note that an amount is not required.

EmpEE Fields-Adj Integer (there are 40 employee fields, each with 6 integers)

Y

Numeric (Whole) - Employee Fields (1—40) adjusting gross information. The six adjust integer fields correspond to the 40 possible check boxes under the Adjust button.

EmpER Fields-Use Custom (there are 40 employer fields)

Y

Boolean - Employer's Fields (1-40) custom/standard check box; valid choices are [True] or [False], where True=custom and False=use standard.

EmpER Fields-Liab Acct ID (there are 40 employer fields)

Y

Alphanumeric - Employer Fields (1-40) liability account no. (if you are not using standard). Must be a valid account number from your Chart of Accounts.

EmpER Fields-Exp Acct ID (there are 40 employer fields)

Y

Alphanumeric - Employer Fields (1-40) expense account no. (if you are not using standard). Must be a valid account number from your Chart of Accounts.

EmpER Fields-Calc On (there are 40 employer fields)

Y

Boolean - Employer Fields (1-40) calculation check box; valid choices are [True] or [False], where True=calculation on and False=calculation off.

EmpER Fields-Calc Name (there are 40 employer fields)

Y

Alphanumeric - Employer Fields (1-40) calculation name from the payroll tax formulas.

EmpER Fields-Amount (there are 40 employer fields)

Y

Numeric (Real) - Employer Fields (1-40) amount if the field is not a calculation. Note that an amount is not required.

EmpER Fields-Adj Integer 1-6 (there are 40 employer fields, with up to 6 integers for each)

Y

Numeric (Whole) - Employer Fields (1-40) adjusting gross information. The six adjust integer fields correspond to the 40 possible check boxes under the Adjust button.

Raise Date

Y

Date - Date of employee's raise. Must be in ##/##/## (month/day/yr) format. (Sage 50 Premium Accounting and higher)

Applicable Rate Index (there are 20 levels)

Y

Numeric (Whole) - Hourly or Salary Pay Levels. (Sage 50 Premium Accounting and higher)

Tip: Both the applicable pay rate index and the pay rate name have been included to help map the two together. (For example, 0=Regular, 1=Overtime, etc.)

Applicable Rate Name (entered in Employee Defaults; there are 20 levels)

Y

Alphanumeric - The Field Name for Hourly or Salary Pay Levels (as entered in Employee Defaults on the Pay Level tab). (Sage 50 Premium Accounting and higher)

Base Amount

Y

Numeric (Real) - Base amount of pay, as displayed in Base Amount field of Raise History table. (Sage 50 Premium Accounting and higher)

Raise Amount

Y

Numeric (Real) - Raise amount, as displayed in Raise Amount field of Raise History table. (Sage 50 Premium Accounting and higher)

Raise Percentage

Y

Numeric (Real) - Raise percentage, as displayed in Raise Percentage field of Raise History table. (Sage 50 Premium Accounting and higher)

Raise Notes

Y

Alphanumeric - Notes (If text was entered through use of the Note button in the Raise History table). (Sage 50 Premium Accounting and higher)

Numeric (whole) - Ethnic origin; valid numbers are 0-7, where 0=none specified, 1=American Indian/Alaska Native, 2=Asian, 3=Black/African American, 4=Hispanic/Latino, 5=Native Hawaiian/Pacific Islander, 6=Other, 7=White (Sage 50 Premium Accounting and higher)

Numeric (whole) - Marital status; valid numbers are 0-5, where 0=none specified, 1=Married, 2=Single, 3=Divorced, 4=Widowed, 5=Other (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's emergency contact name (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's emergency contact relationship (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's emergency contact phone 1 (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's emergency contact phone 2 (Sage 50 Premium Accounting and higher)

Numeric(whole) - Employee's employment status; valid choices are 0-10, where 0=none specified, 1-10=Statuses 1-10 which are specified in Employee Defaults (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's job title (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's job code (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee ID for the employee's supervisor (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's division (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's location (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee's department (Sage 50 Premium Accounting and higher)

Numeric(whole) - Employee's I-9 verification status; valid choices are 0-3, where 0=none specified, 1=Yes, 2=No, 3=Pending (Sage 50 Premium Accounting and higher)

Date-Employee's I-9 reverification date. Must be in ##/##/## (month/day/yr) format. (Sage 50 Premium Accounting and higher)

Date-Employee's next review date. Must be in ##/##/## (month/day/yr) format. (Sage 50 Premium Accounting and higher)

Date-Employee's review date. Must be in ##/##/## (month/day/yr) format. (Sage 50 Premium Accounting and higher)

Numeric(whole) - Employee's review rating; valid choices are 0-10, where 0=none specified, 1-10=Ratings 1-10 which are specified in Employee Defaults (Sage 50 Premium Accounting and higher)

Alphanumeric-Employee ID for the person who conducted the employee's review (Sage 50 Premium Accounting and higher)