Integrate QuickBooks Time and QuickBooks Desktop using Web Connector
by Intuit•3• Updated 4 months ago
Learn how to set up the QuickBooks Time and QuickBooks Desktop Integration using the Web Connector.
If you are in the US and use QuickBooks Desktop 2021 or later, we recommend integrating using the direct method.
Before you get started
Notes:
- We integrate with any QuickBooks Desktop account except for QuickBooks Desktop for Mac.
- Only one QuickBooks company file can be linked with one QuickBooks Time account.
In QuickBooks Desktop:
- Be on the computer you’ll be using to sync QuickBooks Time and QuickBooks Desktop. The sync can only be done in one location.
- Open the company file you want to integrate with QuickBooks Time, and sign in as admin and in single-user mode.
- Turn on time tracking:
- Select Edit, then Preferences, and select Time and Expenses.
- Select Company Preferences, then select Yes next to Do you track time.
- Select OK.
- Turn on payroll preference:
- Select Edit, then Preferences, and select Payroll & Employees.
- Select Company Preferences, then select Full payroll, and OK.
- Make sure your week start date matches in QuickBooks Desktop and QuickBooks Time.
- In QuickBooks Desktop, select Edit, then Preferences, and select Time and Expenses.
- Select Company Preferences, then select the correct start day for First Day of Work Week, then select OK.
- In QuickBooks Time, select Company Settings, then Payroll & Overtime.
- Make sure the Week Start matches QuickBooks Desktop, then select Save.
- Add all employees and vendors (including admins) into QuickBooks Desktop who'll need to have time exported to QuickBooks.
- Set up employee payroll info:
- Select Employees, then Employee Center.
- Select an employee, then Edit ✎, and select Payroll Info.
- Below the Earnings section, select the checkbox next to Use time data to create paychecks.
- Assign at least 1 payroll item to your employee.
- Repeat for each employee.
- Set up company employee default:
- Select Edit, then Preferences, and select Payroll & Employees.
- Select Company Preferences, then select Employee Defaults…
- Select Use time data to create paychecks, and then OK.
- Set up vendors correctly who need to track time:
- Select Vendors, then Vendor Center.
- Select a vendor, then Edit ✎, and make sure they First and Last name.
These instructions assume you’re integrating QuickBooks Desktop with an existing QuickBooks Time account. If you don't have a QuickBooks Time account, sign up and get started.
Set up the integration
Notes:
- QuickBooks Time doesn’t change any info in your QuickBooks Desktop company file during the integration process. The only info that QuickBooks Time exports is approved time data.
- Employee pay rates don’t import, only payroll items.
Step 1: Install add-on
- Sign in to QuickBooks Time as an admin.
- Select Feature Add-ons, then Manage Add-ons.
- Select Install next to QuickBooks Desktop Integration.
Step 2: Select options
Note: All options that import from QuickBooks Desktop (employees and vendors, customers or jobs, payroll items, service items, billable items, and class) need to be managed in QuickBooks Desktop.
- In the QuickBooks Desktop Integration Preferences window, make selections for what information you want to bring over. These selections can be changed later:
- Delete all team members: If you've already added employees into QuickBooks Time, they wouldn’t be linked with your QuickBooks account. You can choose to archive them upon the first sync.
- Share Customers and Jobs from QuickBooks: This imports all active customers and their jobs into your QuickBooks Time account. Employees can then track time against them. You can either assign them to all employees, or assign them individually later (uncheck Assign imported Customers and Jobs). If available, the customer's address will also sync into QuickBooks Time for location tracking.
- Show Service Items: Brings your Service Item list over as a list employees can select from while tracking time.
- Show Billable: Gives employees an option to indicate whether the time they're tracking is billable or not. When time exports to QuickBooks Desktop, the billable rate shows up in weekly timesheet if the timesheet is both associated with a service item rate and is marked as billable.
- Show Class: Brings your Class list over as a list employees can select from while tracking time.
- Import Vendors as team members: If you have Vendors or Contractors who need to track time, you can choose to import them.
- Only Import 1099 Vendors: Limits the Vendor import to only those with Vendor eligible for 1099 checked in QuickBooks Desktop.
- Your first sync removes any jobs or customers you set up in QuickBooks Time before the integration. This won’t delete any time in the QuickBooks Time account. If the warning window displays, read the warning. If you want to continue, select Next, then type delete.
Step 3: Set up Web Connector
- In the next window Step 2: Set Up Web Connector, select Advanced/Manual Setup.
- Select the web_connector link, and open the downloaded file.
Note: If you can’t launch the QuickBooks Time web connector file, open the Web Connector, select Add application, go to downloads, and select and open the web_connector_XXXX.qwc file. - In the security window, select OK.
- In the next security window, select Yes, whenever this QuickBooks company file is open, then Continue.
- In the Access Confirmation window, select Done.
- In QuickBooks Time, locate the 4-digit password in Set Up Web Connector.
- Enter the 4-digit password in the QuickBooks Web Connector, and press Enter on your keyboard. Save the password when prompted.
- Check the box to next to the QuickBooks Time application, and select Update Selected.
- After the sync completes, go back to QuickBooks Time. In the Congratulations! window, follow the steps listed there, like How to Map Payroll Items.
Now that the integration is set up, you can sync data any time you need to import data into QuickBooks Time, or export timesheets to QuickBooks Desktop.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Connect QuickBooks Time to QuickBooks Desktop for Windowsby QuickBooks•40•Updated May 22, 2024
- Integrate older versions of QuickBooks Desktop with QuickBooks Timeby QuickBooks•5•Updated June 01, 2024
- Sync QuickBooks Time after upgrading QuickBooks Desktopby QuickBooks•7•Updated December 01, 2023
- Fix error QuickBooks - Application with Revoked Certificateby QuickBooks•47•Updated May 07, 2024