iClassPro Support

Using Time Clock with QuickBooks Payroll Services

Who should use QuickBooks Exports?

The file generated when the export file type “QuickBooks” is used is specifically designed to map to Intuit QuickBooks Online.

The actual import process will involve the use of a third party import tool such Transaction Pro Importer or another 3rd party solution. Contact a rep at Intuit QuickBooks Payroll for more detailed assistance with these fields and recommended/supported import tools.

PRO TIP! The primary identifying information used to match up a staff member in iClassPro with the same employee in QuickBooks online is the Staff Member’s first and last name. These entries will need to match between iClassPro and QuickBooks Online in order to import data successfully.

About the CSV File for QuickBooks Online Import

The file that is generated will be a csv file that contains the following fields:

QuickBooks Online Field

Format

Description

Data Defaults

ID

String 21

Identifier for the Time Activity required for Modify

Blank

TxnDate

Date

The date of the time activity

Date of Time Entry

NameOf

Defined

Vendor or Employee

Employee

EmployeeVendorRefName

String

Name of Employee

Firstname Lastname

CustomerRefName

String

Full Customer Job Name

Blank

DepartmentRef Name

String

Name of the Department

Blank

ItemRef Name

String

Service Item Name

Title/Position/Role

Class Ref Name

String

Class Reference

Blank

Billable Status

Defined

Billable or NotBillable

NotBillable

Taxable

Defined

True or False

FALSE

Hourly Rate

Decimal

Hourly Rate of Pay

Blank

Duration

hh:mm

Duration of Time Entry

Hh:mm

Break Duration

hh:mm

Duration of Breaks

0:00

Start Time

DateTime

Time Work Started

Blank

End Time

DateTime

Time Work Ended

Blank

Description

String

Description of Work

Blank




Need More Assistance?

Call us at 877-554-6776. Our business hours are Mon-Fri 9am-6pm Central Standard Time.