QuickBooks Time (TSheets): Fixing Sync Failures & Missing Hours

When timesheet entries in QuickBooks Time (formerly TSheets) fail to appear in QuickBooks Online, the sync pipeline has stalled. This issue typically surfaces when processing payroll or generating customer invoices from billable hours. The failure is usually triggered by unapproved timesheets, an inactive employee profile, or a missing mapping link between QuickBooks Time job codes and QuickBooks Online payroll items, service items, or customers.

Fast-Fix: The 45-Second Solution

To resolve missing hours immediately, verify that the timesheets are marked as Approved inside QuickBooks Time. Next, open QuickBooks Time, click the QuickBooks sync icon in the top-right corner, and select Sync Now. If the hours still do not transfer, click View Log under the QuickBooks menu to identify the exact rejected employee or job code, then unarchive or remap that item in your QuickBooks Online settings.

---

Quick Status & Triage Snapshot

• Data Risk Tier: Low (Timesheet records remain safely stored inside QuickBooks Time; they are simply blocked from transferring to QBO).
• Multi-User Impact: High for payroll and billing administrators. Employees can continue tracking time, but payroll runs and time-and-materials invoicing are blocked.
• Common Triggers: Timesheet approval status restrictions, archived employees or vendors, missing Payroll Items, or modified Customer/Sub-customer records.
• Estimated Fix Time: 10 to 15 minutes.

---

Diagnostic Flowchart: QuickBooks Time Sync Decision Path

[Start: Hours Missing in QBO]
              |
Are the missing hours Approved in QB Time?
              |-- NO  --> Approve timesheets first (if approvals are required)
              |-- YES --> Proceed to integration check
                           |
Click QuickBooks icon in QB Time > "Sync Now"
                           |
Did the sync complete without errors?
  |
  |-- NO (Sync Fails) --> Click "View Log"
  |                         |-- "Employee Not Found" --> Map QB Time user to active QBO Employee/Vendor
  |                         |-- "Payroll Item Missing" --> Assign item in Payroll Item Mapping preferences
  |                         |-- "Customer Inactive" --> Restore or update customer record in QBO
  |
  |-- YES (Sync Succeeds, but hours still missing in QBO)
            |
            Check Date Range on QBO Payroll or Weekly Timesheet screen
            |
            Verify "Billable / Bill by Customer" preference is mapped to an active Service Item

---

Is Your Data at Risk?

Your time-tracking records are not at risk of being deleted. QuickBooks Time retains all raw punch data, GPS stamps, and manual timesheet adjustments within its own database, even when the integration pipeline stops working entirely.

However, operational risks exist:

• Payroll Processing Deadlines: Delaying sync resolution close to payroll cutoff times can cause late pay distributions or inaccurate payroll tax filings.
• Duplicate Time Entries: Manually keying missing hours into QuickBooks Online while troubleshooting the integration can create duplicate entries once the automated sync is restored.
• Billing Omissions: If hours flagged as billable fail to sync, invoices generated for time-and-materials clients will omit legitimate charges.

If you suspect sync issues have affected broader company configurations, consult Sync Audit: How to Find Where Your QBO App Data Broke.

---

Technical Anatomy: How QuickBooks Time Pairs with QBO

QuickBooks Time relies on an integrated relational sync engine that matches four core data elements between the two platforms:

QuickBooks Time                 QuickBooks Online
-----------------               -----------------
User / Employee       <=====>   Employee or 1099 Vendor Profile
Customer / Job Code   <=====>   Customer:Job Hierarchy
Custom Field / Class  <=====>   Class Tracking List
Pay Item              <=====>   Payroll Items (Salary, Regular, Overtime)

The sync process functions as a two-way street:

1. Downstream Sync (QBO to QB Time): Customers, Vendors, Employees, Classes, and Payroll Items are imported from QBO into QuickBooks Time.
2. Upstream Sync (QB Time to QBO): Approved or completed duration entries are transferred into QBO’s TimeActivity table.

If an employee changes their name in QBO, or if a customer is marked inactive while an employee is actively logging hours against them, the upstream sync engine rejects the timesheet to prevent orphan records in the general ledger.

---

Differential Diagnosis: Determining Why Hours Do Not Display

• Approval Gate: The integration settings are configured to require managerial approval before exporting. Unapproved timesheets remain in QuickBooks Time by design.
• User Permission Issues: An administrator cannot view or sync time because of restricted permissions within QBO. See User Permissions: Why a User Cannot See the QBO Bank Feed for general permission troubleshooting principles.
• External Payroll Engine Conflicts: If hours are intended for export to third-party payroll engines rather than native QBO payroll, the mapping requirements change significantly. See Gusto to QBO: Fixing Payroll Mapping & Journal Entry Errors.
• General Token Failure: The sync tool fails before reading data, indicating an expired connection handshake. See Re-Sync Guide: Disconnect and Re-Connect QBO Apps Without Data Loss.

---

Step-by-Step Repair Guide

Step 1: Check Timesheet Approval Status

1. Log into QuickBooks Time as an Administrator.
2. Navigate to Approvals (or Time Entries > Approvals).
3. Select the correct pay period date range.
4. Verify whether the missing hours are marked as Approved.
5. If your preferences require approval prior to export and the status shows Unapproved, review the hours and click Approve.

Step 2: Read the Integration Sync Log

1. In the top-right corner of QuickBooks Time, click the QuickBooks icon.
2. Select View Log.
3. Scan the log for red error notices. Common errors include:
   • Could not find employee matching name...
   • The customer:job is inactive or deleted.
   • Cannot export time without a payroll item.
4. Note the specific employee and transaction dates triggering the error.

Step 3: Verify Employee and Vendor Mapping

1. Click the QuickBooks menu icon in QuickBooks Time and select Preferences.
2. Click Payroll Item Mapping (or Employee Mapping).
3. Review the list of users:
   • Ensure every active team member is matched to an active record in QBO.
   • If a user tracks hours as a subcontractor, ensure they are mapped to an active Vendor in QBO, not an Employee.
4. If a user is marked with an orange alert icon, click their name and manually select their corresponding QBO profile from the drop-down list.

Step 4: Validate Payroll Items and Service Items

1. Still inside Preferences, check the Map Pay Types tab.
2. Ensure that Regular Time, Overtime, and Double Time in QuickBooks Time are assigned to valid, active Payroll Items in QBO.
3. If you use billable time tracking for customer invoicing, go to Company Settings > Time Options, and ensure Billable options are linked to active Service Items.
4. Click Save.

Step 5: Force a Manual Sync and Audit the Timesheet Table

1. In the top-right corner of QuickBooks Time, click the QuickBooks icon.
2. Click Sync Now.
3. Allow the progress bar to complete fully.
4. Open QuickBooks Online in your browser.
5. Navigate to Time > Time entries, or run the Unbilled Time report.
6. Check that the hours now appear within the appropriate date range.

---

Hard Stop: When to Escalate to Support

Stop troubleshooting and contact Intuit Technical Support if:

• The sync log repeatedly returns an internal database error (e.g., Internal Server Error: 500 or Null Pointer Reference), which indicates server-side record corruption within the Intuit ecosystem.
• Timesheets export successfully according to the sync log, but the TimeActivity table in QBO remains blank across all company reports and payroll preview screens.
• Employee records in QuickBooks Time are duplicated with identical names, and merging them fails due to an underlying database lock.

---

Closing the Books

Missing hours between QuickBooks Time and QuickBooks Online are almost always caused by an unapproved timesheet or an unmatched employee record. Taking a few moments to review the sync log and confirm your payroll item mapping will resolve the issue and keep your payroll runs on schedule.