Last Topic: ADP Export Formats

Export Formats

The RMReports starting in RM February 2015 build provides a new report group named “ADPExport”. You will find the five export options The reports are detailed below.

ADP Payroll 1 Export

Some merchants can use the ADP to handle tipped jobs differently than non-tipped. If the merchant has configured their ADP system to do special calculations for tipped employees and the wish to specify which jobs are tipped and which are not, they can use ADP Payroll 1. This option should be used only if the customer has consulted with ADP to do the special tax calculations.. Note: the Payroll 1 export does not include gratuities as wages.

Unless there is a specific requirement to specify special hours codes for tipped employees it is recommended that the merchant use the ADP Payroll 2 format.

The ADP Report 1 is broken down into the following:

Note: Tips will appear on a separate line

 

ADP Report 1 Sample

ADP Report 1

 

ADP Report 1 CSV Format Sample

ADP Report 1 CSV

 

ADP Payroll 2 Export

A specific advantage of the ADP Payroll 2 format is that each record includes a field for the job worked and the pay rate for that specific job. Every time a report is generated, the current pay rate for that employee/job will also pass across in the export. It is important that the end user times carefully any adjustments in pay and when they run the report to ensure the pay rate on the report is what the employee should be paid for the specified report period. Pay Rate information is NOT in format 1, so the end user must adjust pay rates on the ADP side for each employee.

The ADP Report 2 is broken down into the following:

 

Sample Report 2

 

Sample Report 2 CSV Format

 

ADP Payroll 3 Export

The ADP Report 3 is broken down into the following:

Note: Tips will appear on a separate line

Sample Report 3

Sample Report 3 CSV Format

 

ADP Payroll 4 Export

The ADP Report 4 is broken down into the following:

 

Sample Report 4

Sample Report 4 CSV Format

 

ADP Payroll 5 Export

This report breaks down as follows:

 

Sample Report 5

Sample Report 5 CSV Format

 

ADP Payroll 6 Export

The ADP Report 6 is broken down into the following:

Company Short Name (Column 1) - This is a unique 3 character company code supplied by ADP. The Co Code is configured in The Store Info Setup form.

Employee ID (Column 2) - This is a unique employee identifier, The employee identifier is configured in the Employee Setup form.

Pay Statement Type (Column 3) - This column is hard coded and will always be EARNINGS

E/D/T (Column 4) - This column is hard coded and will always be "E" (as in earnings)

E/D/T Code (Column 5) - This will be either a Jobclass name or TIPS (decl & non-cash), or OVERTIME.

E Hours (Column 6) - This line will represent regular hours worked for a Jobclass

E Base Rate (Column 7) - This is the pay rate for the employee Jobclass worked for this line

E/D/T Amount (Column 8) - This will be the total earnings or total tips

 

Sample Report 6

Sample Report 6 CSV Format

 

ADP Payroll 7 Export

The ADP Report 7 is broken down into the following:

Note: Tips will appear on a separate line

 

Sample Report 7

Sample Report 7 CSV Format

 

ADP Payroll 8 Export

The ADP Report 8 is broken down into the following:

 

Sample Report 8

Sample Report 8 CSV Format

Note: Tips will appear on a separate line

 

Next Topic: Generate ADP Export