| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Track crew hours and labor cost on every job with Smarfle. From $19/month. Start free. | |||||||||||||||||||||||||
2 | Google Sheets Time Tracking Template | |||||||||||||||||||||||||
3 | Time tracking spreadsheet for US small service businesses | |||||||||||||||||||||||||
4 | Make a copy to use it privately in your Google Drive | |||||||||||||||||||||||||
5 | Download for Excel (.xlsx) | Works in Excel. A few Google-only formulas work best in Google Sheets. | ||||||||||||||||||||||||
6 | Crew in the field? Get the Smarfle app. | |||||||||||||||||||||||||
7 | Get it on Google Play | |||||||||||||||||||||||||
8 | Download on the App Store | |||||||||||||||||||||||||
9 | Quick start | |||||||||||||||||||||||||
10 | 1. Make a copy. Use the link above, save it in your Google Drive and keep sharing Restricted. | |||||||||||||||||||||||||
11 | 2. Clear the contents of the yellow input cells in these sample rows, not whole rows: Time Entries rows 6:15; Employees rows 6:8; Clients rows 6:9; Jobs rows 6:9. Clear the Sample labels too. Keep formula cells, headers and dropdowns. | |||||||||||||||||||||||||
12 | 3. Set your business name in Settings. Add Employees, then Clients and Jobs before recording work in Time Entries. Clear the report date or week setting to use today's date or the current period. | |||||||||||||||||||||||||
13 | ||||||||||||||||||||||||||
14 | Use this time tracking spreadsheet to record employee hours, customer work and billable time. It fits cleaning crews, pest control, HVAC, plumbing, electrical and landscaping businesses. All sample records are fictional. Choose File → Make a copy, save it in your Drive and keep sharing Restricted. Enter real employee or client information only in your private copy. | |||||||||||||||||||||||||
15 | What this template does | |||||||||||||||||||||||||
16 | Track employees, clients, jobs, dates, start/end times, unpaid breaks, hours, billing rates and labor costs. Overnight shifts calculate across midnight. Weekly summaries show approved hours, billable amounts and entries awaiting approval. Input checks flag duplicates, missing relationships, invalid times and excessive breaks. Overlap alerts identify double-booked work intervals. | |||||||||||||||||||||||||
17 | How the connected tabs work | |||||||||||||||||||||||||
18 | Employees: permanent employee IDs, names and default hourly rates. Clients: one record per customer, plus an internal client for travel or office work. Jobs: select a Client ID and set the service and default billing rate. Time Entries: choose Employee ID and Job ID. Client details fill automatically. Enter work intervals and approval status. Dashboard: selected-week summaries. Settings: business name, report week, shift limit and editable service list. | |||||||||||||||||||||||||
19 | Set up your private copy | |||||||||||||||||||||||||
20 | 1. Clear the date in Settings to use today's date. 2. In your Restricted copy, set the business name. Leave Settings!B7 blank for this week, or enter any date to report on its Monday-to-Sunday week. 3. Remove the sample input values listed in Quick start. Keep formulas and headers. 4. Add employees, clients and jobs with unique IDs. Enter time, review input and overlap alerts, then mark reviewed entries Approved. | |||||||||||||||||||||||||
21 | Worked examples | |||||||||||||||||||||||||
22 | Cleaning: 8:00 AM to 12:00 PM minus a 30-minute break = 3.50 hours. At $60/hour, billable amount is $210. Overnight pest service: 10:00 PM to 2:00 AM with blank End date and a 15-minute break = 3.75 hours. At $95/hour, amount is $356.25. Warranty: a billing-rate override of $0 stays zero. Nonbillable office time still contributes hours and labor cost. Submitted entries stay outside approved totals. | |||||||||||||||||||||||||
23 | Dates, rates and weekly boundaries | |||||||||||||||||||||||||
24 | Dates use MM/DD/YYYY. With a blank End date, an earlier end time means the next day. Equal start/end times mean zero hours; enter an explicit next-day End date for 24 hours. Hours = elapsed time minus unpaid breaks. Billing rate uses an entry override, then the job default, then the employee default when the job rate is blank. Cost rate uses an entry override or employee default. Zero is valid. Entries belong to the Monday-starting week of their start date. Split cross-week shifts when needed. Adjust daylight-saving transitions to actual worked hours. | |||||||||||||||||||||||||
25 | Useful definitions and controls | |||||||||||||||||||||||||
26 | Billable amount = hours × billing rate when Billable? is Yes. Labor cost = hours × cost rate; it excludes taxes, benefits, overhead and overtime premiums. This is a time tracker, not payroll or automated tax compliance. Rates are live defaults. Before changing employee/job defaults, fill the rate overrides on historical entries to preserve the rates used at that time. Overlap warnings require review; totals still include valid Approved entries. | |||||||||||||||||||||||||
27 | Capacity and protection | |||||||||||||||||||||||||
28 | 500 time entries, 50 employees, 100 clients and 100 jobs. Use rows already prepared with formulas and dropdowns. Yellow cells are editable; blue cells calculate. Titles, instructions, headers and formulas are protected. Editing a banner, About Smarfle or the author credit triggers a warning. The owner of a copy can dismiss the warning or change protections. The file records time manually. It does not clock people in, send invoices or calculate legal overtime rules. | |||||||||||||||||||||||||
29 | Using the simplified tables | |||||||||||||||||||||||||
30 | Yellow fields are inputs. Blue results stay live. Technical helpers are grouped and collapsed in place, so permanent IDs and frozen columns do not move. Expand a calculation group only when reviewing how a result works. Check the Needs attention column at the end of each row. It lists active checks in plain words and stays blank when the row is fine. A name lookup beside an ID helps you confirm that the selected person or customer is correct. Keep the ID unchanged when a name changes. | |||||||||||||||||||||||||
56 | About Smarfle | |||||||||||||||||||||||||
57 | Manage customers, jobs and invoices in Smarfle when you need a connected service-business platform. Plans start at $19/month. Plan limits and usage charges apply; check current pricing on the website. Pricing checked 10/03/2026. | |||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | Created by Ihor Lavrenenko, founder of Smarfle | |||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||
101 | ||||||||||||||||||||||||||
102 | ||||||||||||||||||||||||||
103 | ||||||||||||||||||||||||||
104 | ||||||||||||||||||||||||||
105 | ||||||||||||||||||||||||||
106 | ||||||||||||||||||||||||||
107 | ||||||||||||||||||||||||||
108 | ||||||||||||||||||||||||||
109 | ||||||||||||||||||||||||||
110 | ||||||||||||||||||||||||||
111 | ||||||||||||||||||||||||||
112 | ||||||||||||||||||||||||||
113 | ||||||||||||||||||||||||||
114 | ||||||||||||||||||||||||||
115 | ||||||||||||||||||||||||||
116 | ||||||||||||||||||||||||||
117 | ||||||||||||||||||||||||||
118 | ||||||||||||||||||||||||||
119 | ||||||||||||||||||||||||||
120 | ||||||||||||||||||||||||||
121 | ||||||||||||||||||||||||||
122 | ||||||||||||||||||||||||||
123 | ||||||||||||||||||||||||||
124 | ||||||||||||||||||||||||||
125 | ||||||||||||||||||||||||||