Export Expense and Cost data from AccountSight to QuickBooks Online Bills

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 Online

2. 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.

 

1Expense-and-cost

2Customer

3Employee

4project

5Payment-terms

6Expense-category

7Tasks 

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.

1Expense-report-exporting

2Validating

3Validation

4Exporting

5exported-message

6expense-data-in-QBO

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.

7Cost-report

8Processing

9Validation

10exporting

11Cost-report-exported-message

12Exported-data-in-QBO

 Related Pages:

Try It Free