Table of Contents

CSV Import Guidelines

Payroll System has the capability of importing payroll or 1099 data in a CSV (Comma Separated Values) file that can be created by organizing data in a spreadsheet (e.g. in Microsoft Excel) then saving the spreadsheet in CSV format.

Be sure to first save your spreadsheet in its native format (e.g., as an XLSX file if you are using Excel). Then use "Save As" to save a copy of the file in CSV format. If the program asks you if you want to keep the file in CSV format, answer "No." If there is a problem importing the CSV file, discard it and use the XLSX file to make any adjustments. Then use "Save As" to save a new copy as CSV.

Input Options

There are five different CSV file input options:

  • Payee name, address, and identification for the payroll grid
  • Payroll dollar information for the payroll grid
  • 1099 information for the payroll/1099 grid
  • W2 form input
  • 1099 form input

The first three options import data into the payroll/1099 grid in the after-the-fact (941/940) program. This is where you need to import if the requirement is to create 941s and the 940. 1099 data imported to the grid is organized by recipient; when the program generates 1099s, the data from the grid will be appropriately accumulated to make one 1099 per recipient.

Formatting columns

  • Dollars: Numeric format with 2 decimal places.
    Make sure there are no commas and no dollar signs.
  • Dates: MM/DD/YYYY date format.
    Make sure your Regional Settings (in Windows Control Panel) are not causing a different separator to be used.
  • Addresses: Eliminate any apostrophes.
  • ZIP Codes: Special – ZIP code format or as text, especially where it contains a leading zero.
    Excel will hide the leading zero by default even if there is one in the CSV file. The zero will be removed if Excel saves the file.
  • SSN: Special – Social Security Number format or as text.
  • EIN: Text format.
Name and Address fields have a length limit of about 30 characters.
Be sure that there are no empty rows being saved to the CSV file. Empty rows can cause rejection of the file.
Be sure that each row contains last name and ID number (SSN or EIN).

How did we do?

Backup Considerations

Data Locations (Default)