QuickBooks Time

Learn how to use the QuickBooks Time Connector in DBSync Cloud Workflow

Overview

The QuickBooks Time Connector in DBSync Cloud Workflow enables secure integration between QuickBooks Time (formerly TSheets) and other enterprise systems such as payroll, ERP, accounting, HR, CRM, and analytics platforms.

This connector allows organizations to automate the synchronization of time tracking, employee, job, and timesheet data — helping ensure accurate payroll processing, project costing, and operational reporting without manual exports or data entry.

Key Benefits

For Business Users:

• Accurate Time Tracking: Ensure employee hours and job time are consistently available across systems.

• Payroll Readiness: Automate time data delivery to payroll and accounting platforms.

• Operational Visibility: Gain real-time insight into labor utilization and project costs.

For Technical Teams:

• Secure API Integration: Uses OAuth-based authentication for QuickBooks Time APIs.

• Flexible Workflow Design: Supports scheduled and event-driven data syncs.

• Controlled Data Flow: Configure one-way or bi-directional synchronization as needed.

Key Features

• Bi-directional data sync between QBTimes/TSheets and connected applications.

• Automated scheduling for periodic data transfers.

• OAuth 2.0 authentication with secure token management and automated token refresh.

• Custom fields support is available across key objects, featuring UI hints, validation, and flexible associations.

• Comprehensive error handling, logging, and retry logic.

Supported QuickBooks Time Objects

The QuickBooks Time Connector supports access to key time and workforce management objects, including:

Object	GET	PUT/POST
Users	Yes	Yes
Jobcodes	Yes	Yes
Timesheets	Yes	Yes

These objects can be used as sources or targets in workflows to automate downstream business processes.

Prerequisites

Before configuring the QuickBooks Time Connector, ensure the following requirements are met:

1. DBSync Cloud Workflow Access

   • A valid license for this connector and access to the DBSync Cloud Workflow platform.

2. QuickBooks Time Account

   • An active QuickBooks Time account with API access enabled.

3. User Permissions

   • The connecting user must have administrative or API access rights.

4. OAuth Authorization

   • Ability to authorize DBSync via the QuickBooks Time OAuth flow.

Connector Configuration

Each QuickBooks Time connector instance represents a connection to a specific QuickBooks Time account. If you manage multiple environments or companies, configure separate connector instances.

Authentication (OAuth 2.0)

The QuickBooks Time Connector uses OAuth 2.0 for secure authentication:

OAuth authentication ensures credentials are never stored directly and access remains secure.

Pre-configuration: API Application Setup

1

Register a QuickBooks Time API application

1. Navigate to the QuickBooks Time API Add-ons section.

2. Click Feature Add-ons → API → Add a new application.

3. Enter the required application details:

   • Name: Enter the relevant name.

   • Description: What the app is used for

   • OAuth Redirect URI: Enter the redirect URL from your DBSync workflow (such as https://platform.dbsync.io/cw/rest/qbtime/oauth2).

4. Click Save to store your the app configuration.

The OAuth Client ID and OAuth Client Secret will be generated for you. Record both securely - you’ll use them to authenticate your integration.

2

These steps register your DBSync redirect URL with QuickBooks Time, enabling OAuth authentication and API access.

After registering the API application and redirect URL in QuickBooks Time, the next steps are to enter the Client ID and Client Secret in DBSync and use the OAuth login button to authorize the integration.

Quick Setup Guide

1

1. Login to DBSync Cloud Workflow

• Use your DBSync credentials to access the platform.

2

2. Add the QuickBooks Time Connector

• Navigate to the connectors list in the Apps pane and select QuickBooks Time from the connectors list.

3

3. Initiate Authorization

• Enter the Client Id and Client Secret generated by QuickBooks Time above.

• Ensure the Redirect URL matches the one registered in QuickBooks Time (For example, https://platform.dbsync.io/cw/rest/qbtime/oauth2).

• Click Login to QuickBooks Time

4

4. Authenticate & Approve Access

• Complete the OAuth authorization process.

5

5. Verify Connection

• Confirm that your QuickBooks Time account is successfully connected.

  

Once connected, QuickBooks Time objects become available for workflow configuration.

Business Use Case

Syncing Users, Jobcodes, and Timesheets between CRM, QuickBooks Online, and QuickBooks Time for automated time tracking, reporting, and profitability analysis.

Summary

The QuickBooks Time Connector in DBSync Cloud Workflow provides a secure and efficient way to integrate time tracking data with payroll, accounting, and operational systems. By automating the flow of timesheets, employee data, and job information, organizations can improve accuracy, reduce manual effort, and gain better visibility into workforce performance.

Frequently Asked Questions (FAQ)

Can I connect multiple QuickBooks Time accounts?

Yes — create separate connector instances for each account.

Is authentication secure?

Yes — the connector uses OAuth 2.0, and tokens are securely managed by DBSync.

Can I sync approved timesheets only?

Yes — workflows can be configured to filter and sync only approved entries.

Does the connector support bi-directional sync?

Yes, data can flow in both directions.

Do I need technical expertise to configure workflows?

No — DBSync provides a no-code interface, though understanding time data structures is helpful.