30 Days Free Trial
Register Now

Export Expense and Cost data from AccountSight to QuickBooks Online Bills

Last modified: October 18, 2022
You are here:

AccountSight users can synchronize AccountSight expense data for their employees and time & expense data contractors with QuickBooks Desktop and QuickBooks Online as vendor bills. Bills can be paid to employees and contractor/vendors via QuickBooks directly in order to maintain accounting information accurately.

Here are the steps to transfer your expense sheet data to QuickBooks Online Bills

Step 1: Integrate AccountSight with QuickBooks Online

Step 2: Complete your QuickBooks Online Timesheet mapping under Settings

Settings > Integrations > QuickBooks Online > Expense and Cost Mapping

AccountSight Expense and Cost Data Mapping with QuickBooks Online Bills

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

  • AccountSight Expense and Cost same as QuickBooks Online Bills
  • AccountSight Customer Name same as QuickBooks Online Customer Name 
  • AccountSight Employee, Contractor, Resource Name same as QuickBooks Online Employee, Vendor, Resource
  • AccountSight Project Name same as QuickBooks Online Project (Sub-Customer) 
  • AccountSight Payment Terms same as QuickBooks Online Payment Terms
  • AccountSight Expense Category (Accounts) same as QuickBooks Online Accounts 
  • AccountSight Task Name same as QuickBooks Online Service Name

You can update the default mapping by unchecking option ‘Create Products and Services’ under tab (Tasks (Service Item) to enable your custom mapping.

You can update the default mapping by selecting option ‘Not Applicable’ under tab (Project) 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 bills like this Customer:Project(sub-customer).
Note: While exporting system will create the setup data automatically that is not available in QuickBooks Online2. Selecting ‘Not Applicable’ will create bills without sub-customer 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 Expense Data to QuickBooks Online

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

 

Expense Consolidated Export

Step 4: Process to Export AccountSight Cost Data to QuickBooks Online

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

 

Was this article helpful?
Dislike 0
Views: 50

Select Color