--- title: "Get timesheet totals" method: GET path: "/time-clock/v1/time-clocks/{timeClockId}/timesheet" tags: ["Time Clock:v1:TimeClocks:TimeClock:Get timesheet totals"] --- # Get timesheet totals `GET /time-clock/v1/time-clocks/{timeClockId}/timesheet` Retrieves detailed work records for each employee within a specified date range. This endpoint is designed to support payroll processing by providing total worked hours, categorized by pay rules and resource (if applied in the account settings). Ideal for integrating with external payroll systems to ensure accurate information. The pay rate will be presented in case it is defined within the account. If an automated unpaid break is applied, it will be deducted from the total hours value. In order to retrieve approved paid time-off (PTO) and manual break information, please use the Get time activities endpoint. Hours will be presented in decimal format. The time period is limited to 45 days. ## Path parameters - `timeClockId` integer, required — The unique identifier of the time clock ## Query parameters - `startDate` string, required — The start of the reporting period, in ISO 8601 format (YYYY-MM-DD). The filter includes all records from 00:00:00 on the specified date. Example: A startDate of 2025-01-01 includes data starting from 2025-01-01T00:00:00 - `endDate` string, required — The end of the reporting period, in ISO 8601 format (YYYY-MM-DD). The filter includes all records up to 23:59:59 on the specified date. Example: An endDate of 2025-01-01 includes data up to 2025-01-01T23:59:59. The end date must be no more than 45 days after the start date. If there is an ongoing overnight shift that continues past the end date, the hours of the overnight will only be included if it has been configured in the time clock settings. - `userIds` integer[] — List of user IDs to filter the results. Only time entries associated with these users will be included. If a user has no recorded time entries within the specified date range, they will be excluded from the results. - `groupIds` string[] — List of cohort/group IDs to filter the results. Only time entries associated with users in these cohorts will be included. - `jobIds` string[] — List of job IDs to filter the results. Currently supports only parent job IDs and regular job IDs. If a parent job ID is provided, only sub-jobs that have actual recorded hours will be included in the response. - `isApproved` boolean — Filter by approval status. If not provided, returns all records (approved and unapproved). Set to true for approved only, false for unapproved only. - `isSubmitted` boolean — Filter by submission status. If not provided, returns all records (submitted and unsubmitted). Set to true for submitted only, false for unsubmitted only. - `isLocked` boolean — Filter by lock status. If not provided, returns all records (locked and unlocked). Set to true for locked only, false for unlocked only. ## Response `200` Successful Response - APIResponseTimesheetTotalHoursGetResponse - `requestId` string - `data` TimesheetTotalHoursGetResponse, required - `startDate` string, required — The start date of the reporting period - `endDate` string, required — The end date of the reporting period - `users` UserHoursSummaryResponse[], required — The users and their hour summaries - `userId` integer, required — The unique identifier of the user - `dailyRecords` DailyRecordResponse[], required — The daily breakdown of hours - `date` string, required — The date of the record in ISO 8601 format (YYYY-MM-DD) - `dailyTotalHours` number, required — The total hours for the day - `dailyTotalWorkHours` number, required — The total work hours for the day - `dailyTotalPaidBreakHours` number, required — The total paid break hours for the day - `dailyTotalUnpaidBreakHours` number, required — The total unpaid break hours for the day - `isApproved` boolean, required — Indicates whether the daily record is approved - `isSubmitted` boolean, required — Indicates whether the daily record is submitted - `isLocked` boolean, required — Indicates whether the daily record is locked - `payItems` PayItemResponse[], required — The aggregated pay items for the entire day - `hours` number, required — The number of hours worked - `payRule` PayRuleResponse, required - `id` string, required — The unique identifier of the pay rule - `code` string, required — The code of the pay rule - `type` string, required — The type of the pay rule - `actualPayRate` number — The actual pay rate applied - `totalPay` number — The total pay for the shift - `records` ShiftEntryResponse[], required — The hour entries for this date - `timeActivityId` string, required — The unique identifier of the time activity - `start` StartTimeResponse, required - `timestamp` integer — The start time of the shift - `timezone` string — The timezone of the shift - `locationData` GpsData - … - `source` PunchSourceResponse - … - `end` EndTimeResponse, required - `timestamp` integer — The end time of the shift - `timezone` string — The timezone of the shift - `locationData` GpsData - … - `source` PunchSourceResponse - … - `basePayRate` number — The base pay rate for the shift - `resources` ResourceResponse[], required — The resources assigned to this entry - `resourceId` string — The unique identifier of the resource/job - `subResourceId` string — The unique identifier of the sub resource/job ## Other responses - `422` — Validation Error --- [API](https://skmtc.net/connecteam/apis/connecteam-api-documentation.md) · [All operations](https://skmtc.net/connecteam/apis/connecteam-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/connecteam/connecteam-api-documentation/revisions/d8f7f302222e/schema)