Creating Export Templates for Time and Attendance Data |
|
Your ADP Time & Attendance 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):
From the Time & Attendance menu, select Maintenance.
Note: If the Maintenance option is not visible, make sure that you have selected Practitioner in the Role Selector.
Under the Payroll heading on the Maintenance page, click the Exports link.
On the Exports page, click the Export Templates menu item on the left side of the page.
On the right side of the page, click the New Template button. The New Export Template page opens.
From the Export Type drop-down menu, select Payroll.
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 Time & Attendance Representative configured for your company.
Click the Next button.
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.
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.
In the User to Receive Inbox Message on Completion field, click the 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.
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.
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 Manager
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 manager.
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 Manager
check box is selected. If you leave this box selected, only transactions
that have been approved by a manager
are included in the export.
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.
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.
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.
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.
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.
Click the Submit button.