Importing CSI Secure Connect Pay Data into ADP

AUTOPAY:

ADP offers a feature called Automatic Pay. This allows employees to receive earnings every payroll cycle without entries being made in the ADP system. Salary employees are an example of Automatic Pay. Another example is Standard Hours employees. Standard Hours is a feature in the ADP system where an amount of hours can be keyed into the file maintenance side of the payroll system. A check will be generated for an hourly employee every payroll automatically.

 

If clients utilize the Standard Hours feature in the payroll system, an additional step is required for the setup of the timekeeping system. Employees must be coded in the ADP system identifying them as automatic pay employees or straight hourly employees:

 

“0” is entered for straight hourly employees. 

“1” is entered for employees with Automatic Pay.

 

Any empty field in the ADP system can be used for this item. We highly recommend the Clock field on the Other tab in ADP File Maintenance. This is how the Report Smith file, HRExport, has been set to run. If the Clock field is already being utilized in the payroll system, the HRExport file will need to be modified to accommodate the system.

 

If the Standard Hours feature is not being utilized, the HRExport file will be set up to reflect employees as Salary or Hourly. No additional steps will need to be taken in the ADP system for timekeeping setup for this format.
 

Hours Codes: 

ADP has Hours Codes set up that are standard with every payroll system. Clients have the ability to add additional hours or modify the existing codes. The timekeeping system is currently set up to identify the following:

 

V

vacation

S

sick

P

personal

H

holiday

 

If an employee is set up for Automatic Pay, the hours will import into the Paydata batch in ADP as Hours 4. If the employee is not set up for Automatic Pay or straight hourly, the hours will import into the Paydata batch as Hours 3. If additional hours fields are currently being used, the account rep will need to be notified.
 

Overtime:

The timekeeping system is currently designed to calculate overtime hours as hours worked over 40 during the pay week. Hours are not calculated on a per day basis. All time off hours can either be set to count or not count toward overtime.

 

Before importing the data into the ADP system, make sure the default pay codes are correct for the company. To view the pay codes click on the Time Administrator menu and view the pay code values at the bottom. The default values are:

 

V

vacation

S

sick

P

personal

H

holiday

 

Import PayData: From the payroll menu, select Utilities, Import, PayData.

There should be an import file for each company code.  Choose Select All and click OK.

To verify imports were successful, open the Paydata batch and scroll through the individual entries.

Note: If there are problems getting the import file to appear in the ADP system, follow these steps:

Click Menu, Setup and choose the company.

Click the Options tab and go to page 2.

In the section labeled Import, verify a check mark is on the Paydata field.