---
title: Time Clock Report — Column Reference
description: "This page explains every column available in the Time Clock Report. This report shows both timesheets and expense records in a single view, with the timesheet rows including a full day-by-day breakdown of hours.\n\nEach row is either a Timesheet or an Expense — the ItemType column tells you which."
---
[Skip to content](https://help.simplevms.com/time-clock-report-column-reference#main-content)
English
Show submenu for translations
Open main navigation
Close main navigation
- English
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://help.simplevms.com/?hsLang=en)
2. [Client Help](https://help.simplevms.com/client-help?hsLang=en)
3. [Report Guides](https://help.simplevms.com/client-help?hsLang=en#report-guides)
# Time Clock Report — Column Reference
## This page explains every column available in the Time Clock Report. This report shows both timesheets and expense records in a single view, with the timesheet rows including a full day-by-day breakdown of hours. Each row is either a Timesheet or an Expense — the ItemType column tells you which.
#### Direct Link to Report: https://reports.simplevms.com/Report/12/Time-Clock-Master
#### Grouping Columns
| Column | What it shows |
| --- | --- |
| Site\_Group | Same as **Site** — used as a grouping key |
| Vendor\_Group | Same as **Vendor** — used as a grouping key |
#### Worker & Assignment Information
| Column | What it shows |
| --- | --- |
| Site | Name of the site the worker is assigned to |
| Worker | Worker's full display name |
| WorkerID | SimpleVMS internal ID for the worker |
| TeamName | Worker's team |
| Vendor | Staffing vendor supplying this worker |
| Department | Worker's department |
| StartDate | Start date of the timesheet work week (Sunday) or expense period |
| EndDate | End date of the timesheet work week (Saturday) or expense period |
#### Record Type & Status
| Column | What it shows |
| --- | --- |
| ItemType | Whether this row is a **Timesheet** or an **Expense** |
| ItemID | Internal ID of the timesheet or expense record |
| Status | Workflow status: Created, Submitted, Approved, or Rejected |
| CreatedDate | When the timesheet or expense was created |
| SubmittedDate | When the record was submitted for approval |
| ApprovedDate | When the record was approved |
| Notes | Notes attached to the timesheet or expense record |
#### Summary Hours & Totals
These columns summarize the full week. For expenses, all hour columns are blank and only **Total** is populated.
| Column | What it shows |
| --- | --- |
| RegHours | Total regular hours for the week |
| OTHours | Total overtime hours for the week |
| DTHours | Total double-time hours for the week |
| Hours | Total hours (Reg + OT + DT) for the week |
| RegTotal | Billed amount for regular hours |
| OTTotal | Billed amount for overtime hours |
| DTTotal | Billed amount for double-time hours |
| Total | Grand total billed. For expenses: sum of all expense line items. |
#### Daily Hour Breakdown (Timesheets Only)
These columns show hours entered per day of the work week. Day 1 = Sunday, Day 7 = Saturday.
| Column | What it shows |
| --- | --- |
| BillableHoursDay1–7 | Regular hours entered for each day of the week |
| OvertimeHoursDay1–7 | Overtime hours entered for each day of the week |
| DoubletimeHoursDay1–7 | Double-time hours entered for each day of the week |
#### Rates
| Column | What it shows |
| --- | --- |
| BillableRate | Worker's hourly bill rate |
| OvertimeFactor | Overtime multiplier (e.g., 1.5) |
| DoubletimeFactor | Double-time multiplier (e.g., 2.0) |
- [Client Help](https://help.simplevms.com/client-help?hsLang=en#main-content)
- [Vendors](https://help.simplevms.com/client-help?hsLang=en#vendors)
- [Candidates](https://help.simplevms.com/client-help?hsLang=en#candidates)
- [Reports](https://help.simplevms.com/client-help?hsLang=en#reports)
- [Invoices](https://help.simplevms.com/client-help?hsLang=en#invoices)
- [Job Titles](https://help.simplevms.com/client-help?hsLang=en#job-titles)
- [Dashboards](https://help.simplevms.com/client-help?hsLang=en#dashboards)
- [Workers](https://help.simplevms.com/client-help?hsLang=en#workers)
- [SimpleFLX](https://help.simplevms.com/client-help?hsLang=en#simpleflx)
- [Teams](https://help.simplevms.com/client-help?hsLang=en#teams)
- [Job Postings](https://help.simplevms.com/client-help?hsLang=en#job-postings)
- [Admin](https://help.simplevms.com/client-help?hsLang=en#admin)
- [Time & Expenses](https://help.simplevms.com/client-help?hsLang=en#time-expenses)
- [Home](https://help.simplevms.com/client-help?hsLang=en#home)
- [Report Guides](https://help.simplevms.com/client-help?hsLang=en#report-guides)
- [Vendor Help](https://help.simplevms.com/vendor-help?hsLang=en#main-content)
- [Job Postings](https://help.simplevms.com/vendor-help?hsLang=en#job-postings)
- [Workers](https://help.simplevms.com/vendor-help?hsLang=en#workers)
- [Invoices](https://help.simplevms.com/vendor-help?hsLang=en#invoices)
- [Reports](https://help.simplevms.com/vendor-help?hsLang=en#reports)
- [SimpleFLX](https://help.simplevms.com/vendor-help?hsLang=en#simpleflx)
- [Submitted Candidates](https://help.simplevms.com/vendor-help?hsLang=en#submitted-candidates)
- [Applicants](https://help.simplevms.com/vendor-help?hsLang=en#applicants)
- [Dashboard](https://help.simplevms.com/vendor-help?hsLang=en#dashboard)
- [Time & Expenses](https://help.simplevms.com/vendor-help?hsLang=en#time-expenses)
- [Admin](https://help.simplevms.com/vendor-help?hsLang=en#admin)
- [Clients](https://help.simplevms.com/vendor-help?hsLang=en#clients)
- [Home](https://help.simplevms.com/vendor-help?hsLang=en#home)
- [Contact Us](https://help.simplevms.com/contact-us?hsLang=en)
- [SimpleVMS + Avionté Integration](https://help.simplevms.com/simplevms-aviont%C3%A9-integration?hsLang=en)
- [Worker Help](https://help.simplevms.com/worker-help?hsLang=en#main-content)
- [Time Off Request](https://help.simplevms.com/worker-help?hsLang=en#time-off-request)
- [Web Punching](https://help.simplevms.com/worker-help?hsLang=en#web-punching)
- [SimpleFLX](https://help.simplevms.com/worker-help?hsLang=en#simpleflx)
- [SimpleVMS KB](https://help.simplevms.com/simplevms-kb?hsLang=en)
[](https://simplevms.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, SimpleVMS