ADP Export is a CSV (comma separated values) structure with a header and the following elements:


  • CompanyNumber
  • SSN
  • EmployeeNumber
  • Dept
  • LastName
  • FirstName
  • CategoryCode
  • CategoryNumber
  • Hours
  • Dollars
  • OverrideRate
  • LaborField1
  • LaborField2
  • LaborField3
  • LaborField4
  • LaborField5
  • LaborField6
  • LaborField7
  • LaborField8
  • ORResLocation
  • ORWorkLocation
  • ORSchoolDist
  • MultiWorkStateOR
  • MultiWorkLocOR


Required Entries:

Company Number -> exported in the CompanyNumber column.

SSN

  or

Employee Number


Export Properties:

Process PTO as deduction x

Select one of your Hours Types to be sent to payroll as a Deduction item.


Process Monetary as deduction x

Select one of your Monetary Types to be sent to payroll as a Deduction item.


Send Pay Rates

Setting this option to "No" will prevent the Temp Rate column from being Populated.


Skip Missing Pay Codes

Setting this option to "No" will cause the Export to Expose an Error if there are Pay Types used that have blank export codes.

Setting this option to "Yes" will cause the export to pass over, without prompting, any Pay Types that have blank export codes.