Your ADP ezLaborManager representative has set up export templates for each pay cycle used by your company. Use the following instructions if you need to create a new template for exporting time and attendance data (special instructions are included at the end of this procedure for third-shift employees):

  1. Click the Home tab.

  2. Under the Home tab, click the Exports link.

  3. On the Exports page, click the Export Templates menu item on the left side of the page.

  4. On the right side of the page, click the New Template button. The New Export Template page opens.

  5. From the Export Type drop-down menu, select Payroll.

  6. From the Export Format drop-menu menu, select the format appropriate for your payroll processing system. The available formats are determined by the payroll processing systems that your ADP ezLaborManager representative configured for your company.

  7. Click the Next button.

  8. In the Template ID field, enter an ID that will help you easily identify the template. The template ID can be a maximum of 25 characters and can be any combination of numbers, uppercase letters, and lowercase letters. This is a required field.

  9. In the Description field, enter a short phrase that clearly identifies the data being exported. You must enter a description for each culture supported by your company. This is a required field.

  10. In the User to Receive Inbox Message on Completion field, click the Select button. In the User Lookup window, select the user whom you want to receive the Inbox message when the export is complete. The Inbox message includes the number of records exported, the number of records skipped due to errors, and an export confirmation number. This is an optional field.

  11. In the E-mail Address for Additional Notification of Completion field, enter or edit the e-mail address to which you want an e-mail message sent when the export is complete. The e-mail message includes the number of records exported, the number of records skipped due to errors, and an export confirmation number. This is an optional field.

  12. If you want to limit the export to only records that have been approved by particular users, select the appropriate check boxes in the Only Export Records with These Approvals section.

    Notes:
    The Payroll and Supervisor check boxes are always available. If you selected ASCII Delimited or ASCII Fixed as the export format, the Loan Supervisor check box is also available. When the Loan Supervisor check box is selected, loaned time pairs and supplemental earnings are only exported if they have been approved by the appropriate supervisor.

    By default, the Payroll check box is not selected. If you select this check box, only transactions that have been approved for payroll are included in the export.

    By default, the Supervisor check box is selected. If you leave this box selected, only transactions that have been approved by a supervisor are included in the export.

  13. Select a pay cycle from the Pay Cycle drop-down menu.

    Notes:
    Data is exported only for employees assigned to the pay cycle you select.

    If you select a projected pay cycle, you must also make a selection from the Payroll Export Contents drop-down menu to indicate whether you want payroll data exported with or without reconciliation adjustments, or whether you want only the reconciliation adjustments to be exported.

  14. If you selected ASCII Delimited or ASCII Fixed as the export format, enter a character in the Delimiter field. A delimiter is used to separate fields in the export file.

    Note: A comma is entered in the Delimiter field by default. ADP recommends that you use a comma as the delimiter.

  15. If you selected ADP Pay eXpert, ADP Horizon, ADP TotalSource, or ADP PC/Payroll as the export format and you want to list employee data by department in the exported file, select the Summarize by Department check box.

    Notes:
    If you select the Summarize by Department check box, you can also select the following check box.

    Include and Summarize Rate -
    Includes rates in the export for employees who have worked for more than one department.

  16. In the Batch Number field, enter the batch number for the export. If you are exporting data to an ADP product, 90 is automatically entered in the field. If you are exporting data to a non-ADP product, enter the batch number manually (if desired). This is an optional field.

  17. If you are creating an export for ADP Pay eXpert, ADP TotalSource, or ADP PC/Payroll and you want to include employees' time punch records on their pay stubs, select the Export Time Punch Detail check box.

    Important: When exporting time and attendance data for third-shift employees, you must select Totals Hours By Pay Date to collect punch details by the employees pay date not the time they punched in.
     

  18. Click the Submit button.