Timesheet

Hours in, invoice out — a Project dropdown driving a cross-sheet SUMIF rollup. Pairs with the Invoice starter.

Use this templateSheets template
TimesheetHours in, invoice out — a Project dropdown driving a cross-sheet SUMIF rollup. Pairs with the Invoice starter.

Hours

ABCDEF
1DateProjectTaskHoursRateBillable
22026-07-02Client ADiscovery call1.5$150$225.00
32026-07-02Client AWireframe review3.0$150$450.00
42026-07-03Client BData model review2.0$175$350.00
52026-07-04Client BMigration script4.5$175$787.50
62026-07-05InternalWeekly planning1.0$0$0.00
72026-07-05Client ACopy pass2.0$150$300.00
8<date><what you did>$0.00

By project

ABCDEF
1ProjectHoursBillableShare
2Client A6.5$975.0046%
3Client B6.5$1,137.5054%
4Internal1.0$0.000%
5Total14.0$2,112.50100%
6
7WeekHoursCapacity
82026-W2714.040
9
10
11
12
13
14
Hours by project
01.633.254.886.5Client AClient BInternal6.56.51Hours
Hours by project data
CategoryHours
Client A6.5
Client B6.5
Internal1
Weekly utilization
2026-W27Current 14Target 40
Weekly utilization data
LabelCurrentTarget
2026-W271440