Hours Tab of the Export Timesheets to ADP Form

Use the Hours tab to enter special codes to indicate pay rates that vary from an employee’s regular salary or wage. You also use this tab to set up projects for which you will export special hours, such as vacation and sick time, to ADP.

This tab is based on employee timesheet hours for the selected timesheets.

Contents

If you use multiple companies, only the timesheets for the active company are included.

Field Description
Insert Click this option to insert a special ADP code.
Copy Select a code in the grid and click this option to add a copy of the selected line to the grid. Edit the copy to create a new code.
Delete Select a code to delete and click this option to remove the code from the grid.
Code Enter the appropriate code designed by your company and ADP for processing special tasks during regular and/or overtime work hours.
Description Enter an appropriate word or phrase that describes the code entered in the Code field. You might, for example, enter V in the Code field and Vacation in this field.
Field ID These standard ADP codes represent buckets (storage files) in which the system stores regular and/or overtime hours entered for special tasks.
Active

The CSV file (the export file created by DPS) generates data for only those codes that are marked as Active.

When you enter a new code, DPS automatically selects this option. DPS includes for export all data entered for all codes marked as Active. If you want to exclude the data for this code from the current export, click the Active option again to deselect the code.

Hours Type

Select the type of hours to include for this code. Options are:

  • All
  • Regular
  • Overtime
  • Overtime-2: This option displays only if you enabled secondary overtime for timesheets (in Settings > Advanced Accounting > System).
Labor Code Mask

Enter a mask for this code. A mask identifies which labor codes you define for special processing.

Each mask can contain one or more wild cards (or none at all) represented by an underscore _. If, for example, you are billing labor to an architectural project (denoted by the letter A) for premium overtime (denoted by the letter B), your entry in this field might be AB_ _. The wild card characters must be in the same positions for every labor code that you create. In this example, all subsequent labor codes must include wild cards in the third and fourth positions.

Project Specify a project code for which you want to export hours for special tasks. The drop-down list provides company-defined choices.
Phase Specify the phase code, if any, for which you want to export hours for special tasks.
Task Specify the task code, if any, for which you want to export hours for special tasks.