Crew Timesheet & Hours Tracker: log every shift and cost every hour in the Excel time log

Crew Timesheet & Hours Tracker

CA$25
Skip to product information
Crew Timesheet & Hours Tracker: log every shift and cost every hour in the Excel time log
1/8
  • Crew Timesheet & Hours Tracker: log every shift and cost every hour in the Excel time log
  • What's included: the timesheet workbook, printable weekly timesheet and Start Here guide
  • Hours, overtime and labour cost worked out from start, end and break times
  • Close-up of the Time Log: each shift's start, end, break, hours, overtime and cost
  • Close-up of the Crew sheet: hourly rate, hours, overtime and cost for each person
  • Close-up of Job Hours: hours, overtime and labour cost by job
  • How it works: download, open the workbook and enter your hours rules and crew rates
  • Example and blank versions of the timesheet workbook
  • Crew Timesheet & Hours Tracker: log every shift and cost every hour in the Excel time log
  • What's included: the timesheet workbook, printable weekly timesheet and Start Here guide
  • Hours, overtime and labour cost worked out from start, end and break times
  • Close-up of the Time Log: each shift's start, end, break, hours, overtime and cost
  • Close-up of the Crew sheet: hourly rate, hours, overtime and cost for each person
  • Close-up of Job Hours: hours, overtime and labour cost by job
  • How it works: download, open the workbook and enter your hours rules and crew rates
  • Example and blank versions of the timesheet workbook
Crew Timesheet & Hours Tracker
Back-Office

Crew Timesheet & Hours Tracker

CA$25

Prices in Canadian dollars. Any tax that applies is shown at checkout.

A crew timesheet in Excel that turns start, end and break times into hours, daily overtime and labour cost by person and job, prints a weekly timesheet under your company name, and comes with a printable paper timesheet.

List your crew by number and label with a role and an hourly rate, then log each shift: date, crew number, job, start, end and unpaid break. The workbook works out the hours, the overtime over your daily threshold across all of a person's shifts that day, and the labour cost at your overtime multiplier.

Pick a person and a week and the Weekly Timesheet prints on one page: hours by day, overtime, straight hours, cost, a weekly threshold check and up to 12 shifts. Job Hours shows hours and cost by job. The overtime rules are editable samples, with a note to confirm them with your own adviser.

  • Time log Excel, 300 shifts, hours, daily overtime and cost
  • Crew 30 people by number and label, role and hourly rate
  • Weekly timesheet One page per person per week, under your company name
  • Job hours Hours, overtime and cost by job
  • Paper timesheet 1-page PDF to fill in by hand
  • Start Here 5-page PDF guide

Instant download after checkout, with the link also sent by email

30-day money-back guarantee, no questions asked

Secure checkout through Shopify

One business, unlimited use on its own projects

What's inside

Timesheet workbook, Excel (.xlsx), six sheets, in two versions. Settings for your company details, the daily and weekly overtime thresholds and the overtime multiplier (editable samples), a status date and the week to print. The Crew sheet takes up to 30 people with a number, label, role and hourly rate, and shows each person's hours, overtime and cost. The Time Log takes up to 300 shifts; hours, overtime and cost are calculated. Check columns flag a missing date, crew number or time, a crew number not on the list, an end before the start or a break longer than the shift.

Weekly Timesheet. Choose a crew number and one page prints under your company name: hours by day, the week's total, overtime, straight hours, cost, the weekly threshold check and up to 12 shifts.

Job Hours. Hours, overtime and cost by job across the log.

Paper timesheet, 1-page PDF. A week by day with start, end, break, hours and overtime, and lines for the worker and the approver.

Start Here guide, 5-page PDF. What is included and how to set the hours rules, add the crew, log each shift, print the weekly timesheet and read job hours.
Formats
  • Excel (.xlsx): the workbook in example and blank versions, standard formulas and no macros. Shaded cells are inputs; formula cells are locked with sheet protection that has no password. Filters on the Time Log work while it is protected. Made for Microsoft Excel: desktop Excel 2016 or later and Excel for the web.
  • PDF, letter size: the paper timesheet (1 page) and the Start Here guide (5 pages).
  • Fonts: the PDFs use Cormorant Garamond and Inter, built into the files. The workbook uses Georgia and Arial.
  • Not included: a payroll system, PowerPoint or Canva files, and page-preview images.
  • Delivery: one ZIP file (about 0.20 MB) holding all four files, on the order page right after checkout and by email.
Licence

One purchase covers one business, with unlimited use on that business's own projects. Your employees may use it for the business's work. Edit it freely and give your clients the finished documents. Reselling, sharing or uploading the template files, edited or not, is not permitted. Read the full licence.
Refunds

If the timesheet isn't right for you, email support@thebuildersledger.com within 30 days of purchase with your order number for a full refund, no questions asked. After a refund the licence ends and the download link is turned off, so please delete your copies of the files. Refund policy.
FAQ

How is overtime worked out?

Hours over the daily threshold on the Settings sheet count as overtime, across all of a person's shifts that day. The weekly threshold is shown as a separate check on the weekly timesheet. Both thresholds and the multiplier are samples; hours and overtime rules depend on where you work and on each person's agreement, so confirm them with your own adviser or accountant.

How do I enter times?

As hours from midnight: 7.5 means 7:30 and 15.75 means 3:45 pm. Break is unpaid hours, for example 0.5.

Is it a payroll system?

No. It tracks hours and labour cost for jobs and timesheets. It does not work out deductions or pay slips.
A note on hours and overtime

The overtime thresholds and the overtime multiplier are editable samples, not rules. Hours and overtime rules depend on where you work and on each person's agreement, so confirm your settings with your own adviser or accountant before you rely on them. The workbook tracks hours and labour cost; it is not a payroll system and does not work out pay, deductions or pay slips. Not legal or tax advice.