TimeTracking
Manages QuickBooks Time Tracking events, supporting creation, updates, deletion, and queries for employee or job time entries.
Table Specific Information
This table has a Custom Fields column. See the Custom Fields page for more information.
Select
By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.
QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for TimeTracking entries are Id, TimeModified, Date, EmployeeName, and EmployeeId. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM TimeTracking WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'
Insert
To insert a TimeTracking entry, specify the Employee and Duration columns.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier assigned by QuickBooks when the time-tracking entry is created. It is guaranteed to be unique across all time-tracking entries. | |
| BillableStatus | String | False | 15 |
The billing status of the time entry. If no billing status is set in QuickBooks, this value empty. Common statuses include Billable, NotBillable, or HasBeenBilled. The allowed values are Empty, Billable, NotBillable, HasBeenBilled. | |
| Date | Date | False |
The date of the time-tracking entry in the format YYYY-MM-DD (for example, 2025-01-01). This field is required when adding a new time-tracking record. | ||
| CustomerName | String | False | 1000 |
The name of the customer associated with the time-tracking entry. This is required when BillableStatus is set to Billable and CustomerId is not provided. | |
| CustomerId | String | False |
Customers.ID | 255 |
The unique identifier for the customer associated with the time-tracking entry. This is required when BillableStatus is set to Billable and CustomerName is not provided. |
| Duration | String | False | 50 |
The duration of time being tracked, represented in the format HH:MM. For example, 2 hours and 30 minutes is represented as '2:30'. | |
| EmployeeName | String | False | 1000 |
The name of the employee, vendor, or subcontractor whose time is being tracked. This is required when EmployeeId is not provided. | |
| EmployeeId | String | False |
Employees.ID | 255 |
The unique identifier for the employee, vendor, or subcontractor whose time is being tracked. This is required when EmployeeName is not provided. |
| Notes | String | False | 5000 |
Optional notes or comments about the time-tracking entry. | |
| Class | String | False | 1000 |
The name of the class associated with the time-tracking entry, used for categorization. | |
| ClassId | String | False |
Class.ID | 255 |
The unique identifier for the class associated with the time-tracking entry. |
| PayrollWageItemName | String | False | 100 |
The name of the payroll wage item, such as Regular Pay or Overtime Pay. This can only be specified if the tracked entity is an employee (not a vendor or subcontractor) and the 'Use time data to create paychecks' option is enabled for the employee in QuickBooks. | |
| PayrollWageItemId | String | False | 255 |
The unique identifier for the payroll wage item, such as Regular Pay or Overtime Pay. This can only be specified if the tracked entity is an employee (not a vendor or subcontractor) and the 'Use time data to create paychecks' option is enabled for the employee in QuickBooks. | |
| ServiceItemName | String | False | 1000 |
The name of the service item representing the type of work performed. This is required if BillableStatus is set to Billable and ServiceItemId is not provided. | |
| ServiceItemId | String | False |
Items.ID | 255 |
The unique identifier for the service item representing the type of work performed. This is required if BillableStatus is set to Billable and ServiceItemName is not provided. |
| EditSequence | String | True | 16 |
A string used for version control to track updates to the time-tracking entry. | |
| TimeModified | Datetime | True |
The date and time when the time-tracking entry was last modified in QuickBooks. | ||
| TimeCreated | Datetime | True |
The date and time when the time-tracking entry was created in QuickBooks. |