Payroll Version 17 Manual
 
 
Importing employee information
Once the payroll program is installed, you can import a tab-delimited text file that contains employee's information (e.g., name, address, wages). This can save the time of having to manually enter much of the general employee information requirements.
The tab-delimited text file format may be created with any word processor providing the file is saved in text format. In the Save dialog, name the file and select TEXT from the pop-up menu.
The information for each employee must be typed in sequence using all of the following information, even if it is zero. A Tab must be put between each field and a Return after each employee. If the sequence is Not followed you will have problems getting the data to import properly.
Employee Name
Address
City
State
Zip Code
Social Security Number
Base Wage (if the Base Wage is a salary, tab once, add an X and tab again)
Number of federal exemption claims
Number of state exemption claims
Marital status (1=single, 2=married, 3-married-filing separately, 4=head of household)
The information Must be set in the following order with a Tab between fields and a Return after each employee.
Employee Name <tab> Address <tab> City <tab> State <tab> Zip Code <tab> Social Security Number <tab> Base Wage <tab> Number of federal exemption claims <tab> Number of state exemption claims <tab> Number of local exemption claims <tab> Marital Status <RETURN>
Ignore what the text file might look like on your screen, the important thing is that you put a Tab space between each field and a Return keystroke after each employee.  If it is not set to the proper format, the information will be imported into the program properly.
  1.