QuickBooks Time

Last updated on Mar 05, 2024

QuickBooks Time, formerly known as Tsheets, is an accounting and scheduling software. With QuickBooks Time, employees can easily clock in and out time using their devices and from any location. Additionally, it allows you to track time against different job codes, to gain valuable business insights with QuickBooks Time reports. With the “Who’s Working” feature, it is easy to see where your employees are located and who’s working on what in real-time.

QuickBooks Time authenticates API requests from Hevo to access your account data with OAuth2.0.


Creating an Access Token

You require an access token to authenticate Hevo on your QuickBooks Time account.

Note: You must log in as an Admin user to perform these steps.

Perform the following steps to create the access token:

  1. Log in to your QuickBooks Time as an Admin user.

  2. In the QuickBooks Time home page, click Feature Add-ons and select Manage Add-ons from the drop-down.


  3. In the Manage Add-ons page, do one of the following:

    • Create an access token

      1. Scroll down to the API section and click Install.


      2. Click + Add a new application to create the access token.


      3. In the API application page, specify the Name, Description, and OAuth Redirect URI fields, and then click Save.

        Note: OAuth Redirect URI is the site to which the user is redirected after the authorization server has successfully authorized the app.


      4. Under the Access Tokens section, copy the token and save it securely like any other password.


        Note: By default, the access token that you generate in QuickBooks Time expires after two months. However, QuickBooks Time provides you with an option to extend the access token expiry date.

    • Use an existing access token:

      1. Scroll down to the API section, and click Preferences.


      2. Click Edit Token, corresponding to the name of the access token to reveal the access token.


        Copy the access token and save it securely like any other password. Use the access token while configuring your Pipeline.

Configuring QuickBooks Time as a Source

Perform the following steps to configure QuickBooks Time as the Source in your Pipeline:

  1. Click PIPELINES in the Navigation Bar.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select QuickBooks Time.

  4. In the Configure your QuickBooks Time Source page, specify the following:


    • Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.

    • Access Token: The access token that you copied from your QuickBooks Time account.

  5. Click TEST & CONTINUE.

  6. Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

For Teams Created Default Ingestion Frequency Minimum Ingestion Frequency Maximum Ingestion Frequency Custom Frequency Range (in Hrs)
Before Release 2.21 1 Hr 1 Hr 24 Hrs 1-24
After Release 2.21 6 Hrs 30 Mins 24 Hrs 1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

  • Historical Data: In the first run of the Pipeline, Hevo ingests all the existing data for the selected objects from your QuickBooks Time account and loads it to the Destination.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object Description
Current User Contains details about the currently authenticated user in your Quickbooks Time account.
Custom Fields Contains details about the custom fields that you have created to capture information related to custom activities other than time tracking.
Geofence Configs Contains details of clock in and clock out reminders sent to workers when they enter and leave a job site.
Geolocations Contains details of all employees’ real-time location using GPS, to track devices connected to your account.
Groups Contains details of the employees who focus on one kind of task, or have similar job responsibilities.
Jobcodes Contains details of the unique IDs assigned to various roles, such as plumber or carpenter, and tasks, such as mopping or painting.
Jobcode Assignments Contains details of all the jobcodes that a user can select while tracking time.
Locations Contains details of all the physical sites associated with your company.
Locations Maps Contains details of the location of employees when they clock in.
Managed Clients Contains details of all the clients in your QuickBooks Time account, such as the ID and name.
Reminders Contains details of the notifications sent to an employee.
Schedule Calendars Contains details of all the events, meetings, and tasks in your calendar.
Timesheets Contains details of the actions such as completing a job, or making a site visit, and the time spent on these actions by an employee.
Timesheets Deleted Contains details of all the timesheets removed for a user.
Time Off Requests Contains details of all the requests sent by employees for paid or unpaid leaves.
Files Contains details of the images associated with the timesheet. For example, an image which provides a visual proof of the completion of a job.
Users Contains details of all the accounts associated with your company.

Source Considerations

  • Pagination: Each API response for each QuickBooks Time object fetches one page with up to 50 records.

  • Rate Limit: QuickBooks Time imposes a limit of 300 API calls per five minutes. If the limit is exceeded, Hevo defers the ingestion till the limits reset.


  • Hevo currently does not support deletes. Therefore, any data deleted in the Source may continue to exist in the Destination.

  • The data is loaded in Full Load mode in each Pipeline run. As a result, you cannot load the historical data alone at any time.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-05-2024 2.21 Updated the ingestion frequency table in the Data Replication section.
Sep-06-2023 NA Updated the page for more clarity.
Sep-04-2022 1.92 New document.

Tell us what went wrong