Exporting CSV Files from this Application to ADP PC/Payroll For Windows

The CloudSuite Business external payroll interface (EPI) exports Paydata records to the ADP PC/Payroll for Windows system. Before exporting payroll-related data, the data must be generated through the standard CloudSuite Business payroll system to create payroll transaction records (prtrx) for each employee.

The Generate Payroll activity summarizes:

Direct and indirect job labor transactions
Data collection time and attendance transactions
HR sick and vacation attendance records
Payroll hours and sales commissions

The activity stores the payroll data in the CloudSuite Business Payroll Transaction table (prtx records). Each payroll transaction record includes all the hours worked by the employee. Data includes regular, overtime, double-time, holiday pay, sick leave and vacation hours for non-salaried employees.

Note: The CloudSuite Business external payroll interface does not export data for salaried employees or non-employees.

You can use the Generate Payroll activity to limit payroll transactions to:

Those satisfying a range of employees or departments
Transactions falling within a specified date range
Employees with certain types of pay frequencies, or
Only certain types of employees.

After the transactions are generated, they can be viewed on the Payroll Log Hours for Pay Period form.

The Export Payroll Information to EPI form establishes the CloudSuite Business payroll transaction information to be exported via the external payroll interface.

Here you can define the starting and ending department and/or starting and ending payroll data to be exported.

Paydata Record File Layout

This is a comma-separated values file.

ADP PC/Payroll for Windows

Field	Data Type	Format	Comment
Co Code	Alphanumeric?	X(3)	Entered on the form
Batch ID	Integer	>>>>>>>	Employee Number if numeric, otherwise 0. Numbers from 000001-000050 are reserved in the ADP software product. A valid employee number in ADP ranges from 000051 through 999999. Because of this limitation, the payroll transaction records of employees whose numbers fall outside this range or whose numbers contain alphabetic characters are not processed. CloudSuite Business automatically adds leading zeros to employee numbers that are less than six digits. The CloudSuite Business Employee Number must correspond exactly to the ADP Employee File Number; otherwise the record is not processed.
File #	Integer	>>>>>>>	Same as Batch ID
Reg. Hours	Decimal	zzzzzz9.99	Employee Regular Hours
Overtime Hours	Decimal	zzzzzz9.99	Employee Overtime Hours
Hours 3 Code	Alphanumeric	X(1)	Other Hours type - values: "D" Doubletime "H" Holiday "S" Sick "Z" Other
Hours 3 Amount	Decimal	zzzzzz9.99	Number of hours for corresponding code
Temp Rate	Decimal	zzzzzz9.99	Employee Pay Rate
Shift	Alphanumeric	X(3)	Included if "Process Shift" check box is selected on the form.