IN THIS ARTICLE:
Learn how to export time clock entries for use with Express Payroll Services.
Who should use Express Payroll Exports?
The file generated when the export file type “Express Payroll” is used is specifically designed to map to Express Payroll.
For assistance with completing fields and the actual import process, contact Express Payroll support directly.
PRO TIP! The primary identifying information used to match up a staff member in iClassPro with the same employee in Express Payroll is the Time Clock ID entered on the "Time Clock" tab of their Staff details.. These entries will need to match exactly between iClassPro and Express Payroll in order to import data successfully.
About the CSV File for Express Payroll Import
The file that is generated will be a csv file that contains the following fields:
|
QuickBooks Online Field |
Format |
Description |
Data Defaults |
|
Period End |
MM/DD/YYYY |
The last date of the pay period being exported |
Blank |
|
EE Number |
String |
Express Payroll Employee Number |
Time Clock ID |
|
EE Name |
String |
Name of Employee |
Firstname Lastname |
|
EmployeeVendorRefName |
String |
Name of Employee |
Firstname Lastname |
|
* [Staff Role Name/Code] |
Decimal |
Hours worked in specified Staff Role (decimal value) |
Hours rounded to quarter hour |
|
OT |
Decimal |
Overtime Hours (decimal value) |
Estimated Overtime Hours rounded to quarter hour |
NOTE: A separate column will be created for each staff role created under SETTINGS>SETUP>STAFF SETTINGS>STAFF ROLES, including columns for built-in administrative roles for paid time off.