Creating an ADP Export Template

  1. Click on the main "Admin" navigation tab, and then on the Exports link located under the System Tools section of the screen.
  2. From the main "Exports" screen, click on the [CREATE EXPORT TEMPLATE] icon.
  3. Enter a name for this template as you would like it to appear in the software.
  4. Select "ADP" from the Export Type drop-down menu.
  5. Click on the [CONTINUE] icon.
  6. Select the desired version from the  Version drop-down list.
  7. Enter the Company Number that you use with the ADP software.
  8. The Batch ID can be any 2 digit number. You can alternate this number every time you export, or the same number can be used repeatedly.
  9. The Disbursement Map Codes section of the screen allows you to set up export codes for the following pay types, "Pay Adjustment," "Tips - Cash," "Tips - Credit," and "Other."
    Note:     All export codes come from within the ADP software.
  10. If you would like to select specific pay types to be exported, click on the [SELECT PAY TYPES] icon. If not, click on the [CONTINUE] icon to move on to the next step.
    • The Available Pay Types box displays all of your TimeForce pay types.
    • The Pay Types Selected box displays the pay types that are selected to be exported.
    • Highlight the desired pay types and click on the [>>] icon. This assigns the selected pay types to be exported.
    • Once you have specified the desired pay types to be exported, click on the [SAVE] icon, and then on the [CONTINUE] icon to move on to the next step.
  11. If you would like to insert specific export codes for each of your department levels, click on the [MODIFY] icon located in the Department Export Codes field. Otherwise, click on the [CONTINUE] icon to move on to the next step.
    • Enter the export code for each of your department levels. These codes are defined within the ADP software.
    • Click on the [SAVE] icon to save your changes, and then on the [CONTINUE] icon to move on to the next step.

ADP Hours Codes

This is the screen that is used to enter the pay codes used in your payroll software.
The drop-down menu at the top of the screen allows you to select a department. This is used when you want to insert a different set of pay codes for each of your individual departments, making it so that departmental hours totals are exported which are broken down into "Regular" and "Overtime" levels.
Each TimeForce hours type is listed in the column on the left-hand side of the box. Each hours type can be broken down into five different levels: "Regular," "OT1," "OT2," "OT3," and "OT4."

The hours types are broken up into four different sections, the first of which is Regular and Holiday hours.

The second section is Accrual Absences. This section allows you to set up a pay code for each accrual policy that hours are deducted from (as in "Vacation" or "Sick Time"). Leave this section blank if you do not wish to have your hours totals broken down by hours taken from an accrual. This section will only be available if you have set up accrual policies within the software.

The third section is Non-Accrued Absence Codes. This section allows you to set up a pay code for each non-accruing absence code that has been set up within the system. Leave this section blank if you do not wish to break up your hours totals by non-accruing absence codes. This section will only be available if you have set up non-accruing absence codes within the software.

The fourth section is Premium Pay Types. This section is used when you want to export hours and earnings totals for your premium pay policies which are broken down into "Regular" and "Overtime" levels. Premium pay totals are exported in addition to individual employee totals. Leave this section blank if you do not wish to export hours totals for premium pay policies.

TimeForce uses specific hours codes to export payroll information. Match each Time Force hours code with the subsequent ADP code.
TimeForce Hours Code ADP Hours Code
Regular 012
Overtime 1 013
Any other hours codes are entered as 016 through 019 with the first letter of the hours code after the 3 digit number.

Example: If you want to export holiday and vacation hours, 016H would be entered into the Mapped As field for Holiday, and 017V would be entered for Vacation.

Enter the appropriate export codes into their corresponding fields, and click on the [FINISH/SAVE] icon.