cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Intuit
5 helpful votes

Integrate TSheets and QuickBooks Online

These instructions assume that you are integrating QuickBooks Online Plus, Essentials, or Advanced with an existing TSheets account. If you do not yet have a TSheets account, see: how to get TSheets on my computer.

Step 1: Install the QuickBooks Online integration add-on

  1. In TSheets, go to Feature Add-ons, then select Manage Add-ons.
  2. Find QuickBooks Online Integration and select Install.
  3. Select Connect to QuickBooks. The Intuit sign-in page displays.
  4. Sign in and, if you have multiple companies, select the one to which you want to link.
  5. When prompted, select Authorize. A "You are now connected" message displays, and the Preferences window opens.

Or

  1. Go to Apps.com, find TSheets Time Tracking, and select Learn more.
  2. If prompted, in the new tab, sign in to your QuickBooks Online account.
  3. If prompted, choose which QuickBooks company you'd like to integrate with TSheets.
  4. On the Set up TSheets Time Tracking page, login to an existing account, or start a free trial.

Step 2: Choose what to import in QuickBooks Online

  1. In the Preferences window, select the items that you want to import into TSheets from your QuickBooks account.
    • Delete all users: If you've already added employees into TSheets, they would not be linked with your QuickBooks account, so you can choose to archive them upon the first sync.
    • Import customers and jobs: This imports all active customers and their jobs into your TSheets account to allow employees to track time against them. You can either assign them to all employees, or assign them individually later (clear assign imported Customers and Jobs).
      Note: If available, the customer's address will also sync in to TSheets for the Nearby Jobs functionality.
    • Show service items: Brings your service item list over as a list employees can pick from while tracking time.
    • Show billable: Gives employees an option to indicate whether the time they're tracking is billable or not.
    • Show class: Brings your class list over as a list employees can pick from while tracking time.
    • Import vendors as employees: If you have vendors/contractors that need to track time, you can choose to import them as users into TSheets.
    For more information, see about QuickBooks integration preferences
  2. Read the warning about items that will be deleted, and if you agree, in the empty box, enter Delete, and select Next.
  3. Under Exporting time to QuickBooks, select the date prior to which timesheets won't be exported to QBO.

Step 3: Import from QuickBooks Online

Additions and changes in QuickBooks will automatically import into TSheets every 1 minute. The sync log will display (Auto) next to the automatic imports.

  • To restrict the import, go to QuickBooks, then select Preferences. Under Automatically import changes to, clear the items you don’t want to automatically import.
  • To grayed out the automatic import entirely, clear the Automatically import for changes made in QuickBooks.
    Note: A manual import can still be performed, if needed. In the upper right corner of TSheets, select QuickBooks, then Import.

Step 4: Map payroll items

If you'll be using the TSheets + QBO integration for payroll, select the Use QuickBooks Online for payroll box in the QuickBooks Online Integration Preferences. Payroll items, if imported upon first sync, will map automatically to the correct time types (e.g., the Overtime payroll item will be mapped to the Overtime time type), but it is important to double check and make adjustments if needed. See: How to Map QuickBooks Payroll Items.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us