Time & Expense Report — Column Reference

Direct Link to report: https://reports.simplevms.com/Report/6/Time-and-Expense-Master

Grouping Columns

These columns are duplicates of other fields used for grouping and subtotaling in pivot tables or report tools.

Column	What it shows
Site_Group	Same as Site — used as a grouping key
PeriodStartDate_Group	Same as PeriodStartDate — used as a grouping key
Vendor_Group	Same as Vendor — used as a grouping key
ItemID_Group	Internal ID of the timesheet or expense record — used as a grouping key

Site & Worker Information

Column	What it shows
Site	Name of the site the worker is assigned to
SiteCity	City where the site is located
SiteDistrict	District the site belongs to (may be blank if not assigned)
ClientSiteID	Your organization's internal site identifier (client-defined)
Team	The worker's team; shows "No Team" if not assigned to one
Title	The worker's job title on this assignment
Worker	Worker's full display name
FirstName	Worker's first name
LastName	Worker's last name
WorkerID	SimpleVMS internal ID for the worker
ClientWorkerID	Your organization's identifier for the worker (e.g., badge number)
ClientWorkerID2	Secondary client-assigned worker identifier
VendorWorkerID	The staffing vendor's identifier for the worker
VendorWorkerID2	Secondary vendor-assigned worker identifier
WorkerStartDate	The date the worker's assignment began
WorkerEndDate	The date the worker's assignment ended (blank if still active)
WorkerStatus	Current assignment status (e.g., Active, Inactive)
AVPlacementID	Avionte placement ID — populated for clients integrated with Avionte
SSN	Worker's Social Security Number — only visible to users with SSN access permission
BuyerSupervisorName	Full name of the worker's supervisor on your side
BuyerSupervisorEmail	Email address of the worker's supervisor on your side
VendorSupervisorName	Full name of the worker's supervisor at the staffing vendor
VendorSupervisorEmail	Email address of the worker's supervisor at the staffing vendor

Job Codes

Each worker can have up to five job codes assigned to their placement.

Column	What it shows
JobCode1	First job code assigned to the worker
JobCode2	Second job code
JobCode3	Third job code
JobCode4	Fourth job code
JobCode5	Fifth job code

Timesheet & Expense Record Details

Column	What it shows
Type	Whether the row is a TimeSheet or an Expense
SpecialType	For timesheets only — the custom timesheet type if one is set (e.g., Salary, Holiday). Shows "Normal" if no special type. Blank for expenses.
Status	Workflow status of the record: Created, Submitted, Approved, or Rejected
InvoiceNumber	Invoice number the record is attached to (blank if not yet invoiced)
PeriodStartDate	The Sunday that starts the work week this record covers
PeriodEndDate	The Saturday that ends the work week (always 6 days after PeriodStartDate)
CreatedDate	When the timesheet or expense was originally created
SubmittedDate	When the record was submitted for approval
ApprovedDate	When the record was approved
ItemDescription	Description of the expense line item. Blank for timesheets.
DaysSinceStartDate	Total number of distinct days across all of the worker's approved timesheets where any hours were recorded. This represents total days worked, not calendar days since the assignment start.

Cost Center & GL Accounts

Column	What it shows
CostCenter	The cost center the hours or expenses are charged to. When running the report without allocation mode, this is the worker's primary cost center. In allocation mode, this reflects each individual cost center the work was split across.
GLAccount	General ledger account number for regular hours, from the cost center configuration
GLAccountOT	GL account number for overtime hours
GLAccountDT	GL account number for double-time hours
Department	Department associated with the worker or cost center

Rates & Markup

These columns are only meaningful for timesheet rows. Expense rows show 0.

Column	What it shows
BillRate	The hourly bill rate in effect for the timesheet period
PayRate	The hourly pay rate in effect for the timesheet period
OvertimeFactor	The multiplier used to calculate overtime rates (e.g., 1.5 for time-and-a-half)
OTPayRate	Overtime pay rate, calculated as PayRate × OvertimeFactor
OTBillableRate	Overtime bill rate, calculated as BillRate × OvertimeFactor
Markup	Ratio of bill rate to pay rate (BillRate ÷ PayRate). Shows 0 if either rate is zero.

Hours (Timesheets Only)

Hours are pulled from time clock punches when available; otherwise they come from manually entered timesheet values. All hours reflect the cost center allocation percentage — if a timesheet is split across multiple cost centers, each row shows only the portion allocated to that cost center.

Formula: Actual hours × (allocation percentage ÷ 100)

Example: 40 regular hours split 60%/40% across two cost centers = one row showing 24 hours, one row showing 16 hours.

Column	What it shows
RegHours	Regular hours worked, adjusted for cost center allocation
OTHours	Overtime hours worked, adjusted for cost center allocation
DTHours	Double-time hours worked, adjusted for cost center allocation

Dollar Totals

All totals are rounded to 2 decimal places and reflect the cost center allocation percentage (same logic as hours above).

For expense rows: only Total is populated (sum of all line item costs). RegTotal, OTTotal, and DTTotal are always 0.

Column	What it shows
RegTotal	Billed amount for regular hours
OTTotal	Billed amount for overtime hours
DTTotal	Billed amount for double-time hours
Total	Grand total billed. For timesheets: RegTotal + OTTotal + DTTotal. For expenses: sum of all expense line item costs.

ACA Fees

ACA (Affordable Care Act) fees are surcharges calculated based on vendor-buyer configuration. These are separate line items in the report and always show 0 hours.

Column	Formula	What it shows
RegACA	(Per-hour ACA charge × RegHours) + (ACA % of pre-tax billed × RegTotal), adjusted for allocation %	ACA surcharge applied to regular hours
OTACA	(Per-hour ACA charge × OT multiplier × OTHours) + (ACA % of pre-tax billed × OTTotal), adjusted for allocation %	ACA surcharge applied to overtime hours

How Cost Center Allocation Works

A timesheet or expense can be split across up to 4 cost centers. When allocation is configured, the report produces one row per cost center split, with hours and dollars proportional to each allocation's percentage