Time Tracking Integration with QuickBooks Online Timesheet

AccountSight users can synchronize AccountSight time tracking data for their employees and contractors with QuickBooks (Both Desktop and QuickBooks Online) timesheet and Payroll. Timesheet data in QuickBooks can be used for generating invoicing or processing payroll.

Here are the steps to transfer your timesheet data to QuickBooks Online:

Step 1: Integrate AccountSight with QuickBooks Online

Step 2: Complete your QuickBooks Online Timesheet mapping under Settings

Settings > Integrations > QuickBooks Online > Timesheet Mapping

AccountSight Time Tracking Data Mapping with QuickBooks Online Timesheet

The following are the default field mapping to export data from AccountSight to QuickBooks Online:

  • AccountSight Customer Name same as QuickBooks Online Customer Name
  • AccountSight Project Name same as QuickBooks Online Project (Sub-Customer)
  • AccountSight Task Name same as QuickBooks Online Service Name
  • AccountSight Employee/Contractor Name same as QuickBooks Online Employee
You can update the default mapping by unchecking option ‘Create Products and Services’ under tab Tasks (Service Item) to enable your custom mapping.
 
Mapping Options
Project (Sub-Customer)

 1. Selecting default option as ‘Sub-Customer’ will require each project in QuickBooks Online be setup with same name as AccountSight under customer. Creates timesheet like this Customer:Project(sub-customer).

Note: While exporting system will create the setup data automatically that is not available in QuickBooks Online. 

Tasks (Service Items)

 1. Selecting 'Create Product and Services' checkbox as yes will ignore the mapping below and create service item in QuickBooks Online if synced task (service item) value is not setup already.

2. Unchecking 'Create Product and Services' checkbox will use the mapping in the table below. Unmapped values will be defaulted to 'Hours' in QuickBooks Online during data sync.

 

1Customer-mapping

 2Employee-contractors-mapping

3Project-mapping

4Task-mapping

Step 3) Process to Export AccountSight Timesheet Data to QuickBooks Online

Login to your AccountSight account as the admin. Go to Reports > Time tab. Use the filters to choose the Customer, Project, Task and other options. Click on the 'QuickBooks Online Export' button.

1Time-report

 2Processing

3Validating

4Processing

5Data-exported

6QBOTimesheet 

Related Pages:

 

Try It Free