ADP Payroll Export

This report generates a .csv file that will be provided to the payroll service ADP.

Usage:

ADP Payroll Export runs off Payroll files (Compute PR must be run!).

ADP must be notified that all hours will be handled as straight hours. No markups should be applied by ADP.

Salaried employees will be passed to ADP with hours and effective pay rates from Data-Basics.

Note: this version of the interface assumes that ADP handles tax and departmental information in their employee master record. Multi-jurisdictional taxation is not currently handled. Similarly, GL Entities will be assigned according to the employee’s home department from the ADP employee master record.

A new alternative to this version of the export is supported by Report PR Export (ADP). Be sure to consult with your support representative before switching functions.

Registry

See Registry ADP Export for details on the required registry settings for this report.

Setup: Pay Type Viewer

Any hours charged to a pay type with a Category of Regular or Overtime will automatically be classified as Regular Hours or OT Hours in ADP. No additional ADP coding is required.

Pay Types with a Category of Doubletime or Other must include the applicable ADP Codes. The following fields may used for the ADP codes:

Pay Type Hierarchy for ADP Codes:

Pay Type PRS Pay Code (overrides User 1 and Id)
Pay Type User 1 (overrides Id)
Pay Type Id

The export will process all pay types unless the Pay Type User1 field is set to N/A. N/A is NOT supported in the PRS Pay Code field.

Setup: Other Rate Viewer

This release supports the use of the PRS Reimb Code field in the Other Rate record to classify reimbursables for ADP by entering a 1-2 character code appropriate for ADP the applicable field (see below).

Other Rate Hierarchy for ADP Codes:

Other Rate PRS Reimb Code (overrides User 1 and registry)
Other Rate User 1 (overrides registry)
Registry Entry (sys-adp-export DefaultReimbCode option in sys-adp-export)

 When a code is specified in the Other Rate, it will override the DefaultReimbCode registry entry, allowing for multiple codes to be used.

Report ADP Export

Purpose:

This report generates a .csv file that what will be provided to the payroll service ADP.

Usage:

This report should be run after your firm is certain that payroll has been correctly computed for this payroll period. Typically, you would run Compute Payroll, make any needed adjustments, and re-run Compute Payroll.

ADP must be notified that all hours will be handled as straight hours. No markups should be applied by ADP.

Salaried employees will be passed to ADP with hours and effective pay rates from Data-Basics.

The name of the filename is generated as follows: EPIcccff.csv where ccc is the company code and ff is the file name.

NOTE: the next time the report is generated using the same Company Code and File Id, this file will overwrite the existing one (if it exists). Be sure to upload your file to ADP promptly.

A new alternate to this version of the export is supported by Report PR Export (ADP). Be sure to consult with your support representative before switching functions.

Report Range Screen:

Payroll Period Id:

Select the Payroll Period that you wish to run the report for.

Company Code:

Enter the Company Code that will be used generate the file name. If this field has been defined via registry if will default in.

Batch Id:

A unique Batch Id must be entered by the user. This will be written to the data lines of the .cvs file exported to ADP. You may wish to use the date as the Batch Id.

File Id:

Enter the Company Code that will be used generate the file name. If this field has been defined via registry it will default in.

Executive PR:
If you are an Executive Payroll user, this field will default to Y; to run this function for all employees (Executive or not) clear this range. If your User record is not flagged as Executive Payroll, you will only be able to run this function for other non-Executive users even if you clear the filter.

Click GO to generate to generate a printable copy of the report, and the .csv file.

The following fields are included in the data lines:

Company Code (from the registry/report screen)
Batch Id (from the report input screen)
Employee Id (from payroll history)
Regular Hours (total regular hours from payroll history)
Overtime Hours (total overtime hours from payroll history)
Hours3 (the ADP code from the Pay Type for Other Hours)
Other Hours (total other hours of this Pay Type)
Tmp Rate (the pay rate for these hours, from payroll history)
Er3 (RE for all Reimbursables in version 7.0 and 7.1)
Ernnge3 Amount (the reimbursable amount for expenses)