30 Days Free Trial
Register Now

Time Tracking Integration with QuickBooks Online Timesheet

Last modified: October 18, 2022
You are here:

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.




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 ‘Export Report’ option and then click on the ‘QuickBooks Online Export’ button.







Was this article helpful?
Dislike 0
Views: 178

Select Color