Timesheet template

A timesheet answers one question: where did the hours go? This one splits each day across the projects a person touched. The total becomes a real account of the week, not a number typed on Friday.

Use this when work is charged to more than one project and somebody needs to see the split. For a plain record of hours in and out, the weekly timesheet is the shorter form.

Timesheet — one person, one week

Project | Mon | Tue | Wed | Thu | Fri | Total
Project or client name | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0
Project or client name | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0
Project or client name | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0
Internal or non-project | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0
Daily total | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0

Name · Team · Week ending · Submitted on · Approved by. Hours are decimal: quarter of an hour is 0.25.

How to fill it in

  1. Name the projects first. Write the project rows before the week starts. Naming them afterwards turns the sheet into a memory test.
  2. Log daily, not weekly. A day logged on Friday for Monday is a guess. Most sheets drift by an hour or two that way.
  3. Use decimals. Mixing 1:45 and 1.75 in one column breaks the total. Pick decimal hours and stay there.
  4. Keep the internal row. Meetings, admin and training are real hours. Hiding them makes every project look slower than it is.
  5. Send it to one approver. Two approvers means neither reads it. Name one person per sheet.

PeopleMuster logs the same split per project and per day, and an admin sets how far back a person may still log. The live instance allows five working days. How timesheets work in PeopleMuster.

Questions people ask about this letter

Should a timesheet include unpaid breaks?

No. A break is not project work, so it does not belong in a project row. Record the break in the attendance record, where the day's clock times live.

What if someone worked on six projects in a day?

Add rows. A grid with six thin rows is honest; rounding five of them into a sixth is not, and it makes the biggest project look bigger.

Does a timesheet need to match the attendance record exactly?

Rarely, and forcing it to is a mistake. Attendance records clock times at the door. A timesheet records work. Paid breaks and unlogged admin explain most of the gap.