Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesConstruction & EngineeringConstruction Project ManagementCrew Timesheet by Cost Code

SpreadsheetConstruction Project ManagementFree

Crew Timesheet by Cost Code

Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.

Shown with sample data

Colour

Crew Timesheet by Cost Code

Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.

Hours this period
97.5
Overtime share
9.7%
Labour cost
$5,247
Including OT and burden
Codes over budget
1
Hours to date by cost code
  • 03-110 Footing formwork24
  • 03-210 Reinforcing steel15.5
  • 03-310 Concrete placing30
  • 03-350 Concrete finishing10
  • 06-110 Rough framing16
  • 01-540 Site cleanup2

How to use it

  1. 1List your crew on the Crew sheet with trade and base hourly rate.
  2. 2On Cost codes, enter each code with its budgeted hours and labour cost, and update percent complete weekly.
  3. 3Each day, the foreman adds one row per worker per cost code with regular and overtime hours.
  4. 4Check Settings for your overtime multiplier and labour burden (payroll taxes, insurance and benefits).
  5. 5Review the cost codes flagged Over budget or Watch at the weekly job cost meeting.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Labour is the cost that moves most on a job, and you can only control it if hours are booked to the right cost code every day. Foremen enter each worker’s regular and overtime hours against a cost code; rates come from the crew list, overtime and labour burden are applied from Settings, and the cost code sheet compares hours and cost to date with budget, uses percent complete to forecast hours at completion, and flags codes heading over.

Who it’s for

  • Self-performing general contractors
  • Concrete, framing and specialty trade crews
  • Weekly labour cost reports
  • Feeding payroll and job costing from one sheet

What’s included

  • Timesheet sheet: One row per worker per cost code per day.
  • Cost codes sheet: Hours and cost to date against budget for each code.
  • Crew sheet: Crew members and base hourly rates.
  • Settings sheet: Overtime and burden rates.

How to use it

  1. 1List your crew on the Crew sheet with trade and base hourly rate.
  2. 2On Cost codes, enter each code with its budgeted hours and labour cost, and update percent complete weekly.
  3. 3Each day, the foreman adds one row per worker per cost code with regular and overtime hours.
  4. 4Check Settings for your overtime multiplier and labour burden (payroll taxes, insurance and benefits).
  5. 5Review the cost codes flagged Over budget or Watch at the weekly job cost meeting.

Tips

  • Split a worker’s day across codes when they move tasks; booking it all to one code hides the overrun.
  • Percent complete should come from quantities installed (e.g. 60% of the slab area placed), not hours spent.
  • Overtime rules differ: US federal law requires 1.5 times the regular rate over 40 hours a week; some states (such as California) also have daily overtime. Prevailing wage jobs have their own rules.

Questions

What is a cost code?

A code from the job budget (often based on CSI MasterFormat divisions, such as 03 30 00 cast-in-place concrete) used to track cost by activity, so you can compare actual cost with the estimate.

What is labour burden?

Employer costs on top of wages: payroll taxes, workers’ compensation, general liability on payroll, health insurance and other benefits. For construction it is often 25–45% of wages.

How is forecast hours at completion calculated?

Hours to date ÷ percent complete. If 300 hours have produced 40% of the work, about 750 hours will be needed to finish.

Related searchesconstruction timesheet templatecrew timesheetcost code timesheetjob cost labor trackingforeman daily timesheetconstruction labor cost tracker

Details

Format
Spreadsheet
Category
Construction Project Management
Sheets
4
Setup
15 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetConstruction Project ManagementFree

Crew Timesheet by Cost Code

Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Construction Project Management
Sheets
4
Setup
15 min
Level
Intermediate
Price
Free

Your copy is private to you.

More construction project management templates

View all
Construction Project Schedule
Task
SepOctNovDecJanFebMar
Permits and mobilisation
Excavation and footings
Slab pour and cure
Framing and sheathing
Roofing
Windows and exterior doors
SpreadsheetConstruction Project Management

Construction Project Schedule

The build programme with planned and actual dates, progress weighted by duration, behind-schedule flags, a month-by-month bar chart and phase summaries.

10 min setupPreview
RFI Log2 sheets

Open RFIs

4

Overdue responses

2

Average days to answer

10.3

ABCD
1RFIRaisedSubjectCategory
2RFI-001Oct 5Slab edge detail at grid line C clashes with drainageStructural
3RFI-002Oct 9Door D14 hardware schedule missingArchitectural
4RFI-003Oct 20Ceiling void too shallow for specified ductwork, level 2Mechanical & electrical
5RFI-004Oct 28Confirm brick type for east elevation; sample rejectedArchitectural
RFIs
SpreadsheetConstruction Project Management

RFI Log

Track every request for information from question to answer, with due dates and cost and schedule impact.

10 min setupPreview
Schedule of Values & Payment Application2 sheets

Contract sum

$1,200,000

Completed to date

52%

Payment due this application

$173,070

ABCD
1ItemDescription of workCategoryScheduled value
21General conditions and supervisionGeneral conditions$85,000
32Site clearance and excavationSite work$62,000
43Foundations and slabStructure$148,000
54Structural steel frameStructure$215,000
Schedule of values
SpreadsheetConstruction Project Management

Schedule of Values & Payment Application

Bill progress against each line of the contract: work completed, stored materials, retainage and payment due.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ