Available Field Mappings
109
Field Mappings when Using the Project/Role --> Job/Item Structural
Relationship
Available Field Mappings when Transferring Users from Web TimeSheet to QuickBooks as Employees
Available Field Mappings when Transferring Users from Web TimeSheet to QuickBooks as Vendors
Web TimeSheet Field
QuickBooks Field
Notes
First Name
First Name
This mapping cannot be edited or
removed.
Last Name
Last Name
This mapping cannot be edited or
removed.
Employee ID
Acct No. (Emp ID)
SS No.\SIN
Custom Field
The Integration Manager cannot
modify Social Security Numbers or
Social Insurance Numbers in
QuickBooks after the initial transfer.
Internal E-mail Address
Email
Custom Field
External E-mail Address
Email
Custom Field
The External E-mail Address field
is only available for mapping if there
is a license for the Web TimeSheet
Offline Timesheet module.
Supervisor
Custom Field
Department
Custom Field
Hourly Cost
Hourly Cost
Custom Field
If Hourly Cost is mapped to Hourly
Cost, there must be an Hourly
Cost item available in the Payroll
Item list in QuickBooks in order for
the mapping to be successful.
Start Date
Hire Date
The Integration Manager cannot
modify hire or release dates in
QuickBooks after the initial transfer.
If Start Date is not mapped to Hire
Date, the Hire Date field will be
filled with the current date.
End Date
Release Date
Employee Type
Custom Field
Login Status
(Enabled/Disabled)
Status (Active/Inactive)
User Defined Field
(User Category)
Custom Field
Web TimeSheet Field
QuickBooks Field
Notes
First Name
First Name
This mapping cannot be edited or
removed.
Last Name
Last Name
This mapping cannot be edited or
removed.
Internal E-mail Address
Email
Custom Field