QuickBooksTimes
Overview
The DBSync QBTime Connector (formerly TSheets Connector) enables seamless, automated integration between QuickBooks Time (QBTimes/TSheets) and other applications or databases via the DBSync platform. It supports streamlined time tracking data flows, workforce management operations, and advanced business process automation.
Key Features
Bi-directional data sync between QBTimes/TSheets and connected applications.
Automated scheduling for periodic data transfers.
Pre-built templates for common use cases (e.g., syncing timesheets, users, job codes).
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.
Connection Setup
Steps for API Application Setup
Navigate to the QuickBooks Time API Add-ons section.
Click on "Feature Add-ons" and then on "API".
Select "Add a new application".
Enter the required application details:
Type the relevant name into the name field.
Copy the redirect URL from your DBSync workflow (such as https://test03.mydbsync.com/cw/rest/qbtime/oauth2).
Paste it into the Redirect URL field in QuickBooks Time.
Click "Save" to store your app configuration.
Fill additional required fields, such as "Client ID," and "Client Secret," if prompted.
Click "Save" again to finalize the registration.
Select the user or profile for whom the app should be enabled and save changes.
These steps help register your DBSync integration's redirect URL with QuickBooks Time and prepare it for OAuth authentication and API connection.
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.
Steps to Complete DBSync Connection
Copy the Client ID and Client Secret from the QuickBooks Time API application (created earlier).
Paste the Client ID into the corresponding field in the DBSync QuickBooks Time connector setup screen.
Paste the Client Secret into its corresponding field in DBSync.
Ensure the Redirect URL matches the one registered in QuickBooks Time (e.g., https://test03.mydbsync.com/cw/rest/qbtime/oauth2).[1]
Click the "Login to QuickBooks Time" button in DBSync to initiate the OAuth flow.
Complete authentication to connect your QuickBooks Time account—this may require logging in and granting permissions.
Supported Objects Overview
Users
Yes
Yes
Jobcodes
Yes
Yes
Timesheets
Yes
Yes
Business Use Case Example
Syncing Users, Jobcodes, and Timesheets between CRM, QuickBooks Online, and QuickBooks Time for automated time tracking, reporting, and profitability analysis.
Last updated