Importing QuickBooks Data

QuickBooks Data Import Process

Hour Timesheet utilizes the QuickBooks Web Connector to enable the exchange of data between QuickBooks Desktop an Hour Timesheet. To sync your data, you will need access to your login credentials for your QuickBooks Desktop company file.

The import tool will sync Employees, Customer/Jobs, Payroll Items, Service Items, Classes and Vendors.

1. Open your company QuickBooks company file and enter the new data.

2. Login to your Hour Timesheet login page as user with admin or accountant role

3. Navigate to the Settings menu item

4. Click the Connect to QuickBooks tab

5. Click the Request for Import button to initiate the import process.

6. Toggle back to your QuickBooks company file and navigate to File/Update Web Services and run the web connector file.

NOTE 1:  Once the data import process is complete, you will receive an email with the details of the import.

NOTE 2: The import process should be run each time new data is entered into QuickBooks.

NOTE 3: Hour Timesheet does not allow Customer/Jobs, Service Items, Classes, Payroll Items or Vendor data to be added through the Hour Timesheet software. You must add the data to your QuickBooks company file first to sync the data.  Hour Timesheet does allow for employee data to be created using the software but these employees WILL NOT sync timesheet data back into your QuickBooks file.

NOTE 4: This article requires that the initial data sync has already been established during the setup of Hour Timesheet and that the web connector file is linked from your QuickBooks company file to your Hour Timesheet account.  See Web Connector Installer for more instructions.

Watch Video