A handyman's business lives in text messages and a paper notebook in the truck. Who called, what they needed, when the job is, what got quoted. It works until a job gets forgotten or a customer asks what they paid last time.
Most tradespeople don't want job management software. They want something simple that works on their phone and doesn't cost forty dollars a month.
The idea is a handyman call tracker in Google Sheets: every service call, appointment, and payment in one place. It's number 35 on my list of 100 business ideas in Google Sheets, and it's the kind of sheet that's easy to build and easy to sell to people who would never build it themselves.
The idea
A handyman call tracker helps handymen and contractors keep track of their service calls and appointments. It could be used by anyone who provides handyman services: an individual handyman, a small business with a couple of crews, or a contractor who juggles many small jobs alongside big ones.
The person best placed to build this is someone who knows Google Sheets and has experience in the handyman or contracting business. That second half matters. You need to know that a call isn't a job until it's quoted, that customers call back for the same drip six months later, and that Saturday jobs cost more.
A few formulas do most of the work.
COUNTIFS counts service calls within a date range. If the owner wants to know how many calls came in this week, COUNTIFS on the date column does it, and it can split the count by job type or by customer.
AVERAGE gives the average time spent on a service call. If the sheet captures start and end times, the average tells the owner how long a "quick" faucet repair really takes, which is what they need to quote properly.
IF builds conditional logic from the inputs. If the job type is Emergency, apply the emergency rate. If the job is outside the usual radius, add a travel charge.
VLOOKUP pulls details from another tab. Pick a customer from a dropdown and the sheet fills in their address, phone, and last job. Pick a job type and it fills in the standard rate.
SUM totals revenue in a date range. Weekly revenue, monthly revenue, revenue per customer. It's the number that tells the owner whether the week was worth it.
None of that is fancy. That's the point. The handyman doesn't want fancy. They want to open the sheet on their phone, tap a new row, and move on.
How to build it in Google Sheets
- Calls. The main log. Columns: Date Received, Customer, Phone, Address, Job Type, Description, Status (New, Quoted, Scheduled, Done, Paid), Scheduled Date, Start Time, End Time, Hours, Quote, Amount Paid, Notes.
- Customers. Name, Phone, Address, First Job Date, Total Jobs, Total Spent. The last two are formulas off the Calls tab.
- Rates. Job Type, Base Rate, Hourly Rate, Emergency Multiplier. This is the tab VLOOKUP reads from.
- This Week. A summary: calls received, jobs scheduled, jobs done, hours worked, revenue, average job time. Every number a formula.
- Data validation dropdowns for Customer, Job Type, and Status, fed from the Customers and Rates tabs so lookups always match.
-
VLOOKUP to auto-fill the hourly rate once a job type is picked:
=VLOOKUP(E2, Rates!A:C, 3, FALSE). - COUNTIFS and SUMIFS on the This Week tab for counts and revenue by date range.
- Conditional formatting on Status so unpaid jobs are red and scheduled jobs are yellow. A glance at the sheet shows what needs chasing.
- Google Forms intake as an optional front end. A short form the handyman fills in from the truck that drops a new row into Calls automatically.
Who pays for it, and how to sell it
The buyer is the handyman, the small contractor, or the spouse who does the books for one. They pay for time saved and for not losing jobs. The first time the sheet reminds them of a scheduled job they'd forgotten, it has paid for itself.
Price it as a one-time template. Tradespeople hate subscriptions, and this sheet doesn't need updates to stay useful. If you want recurring revenue, sell a service on top: set it up with their customers and rates, or add a customer-facing booking form.
Sell it on Gumroad with a short video showing the phone view. Or use OnlySheets so the sheet is shared automatically the moment someone buys, with no manual copying on your end.
First 10 customers: go local. Find ten handymen in Facebook groups or on Nextdoor in your area, message them, and offer to set the sheet up with their rates for free in exchange for feedback. They'll tell you what's missing, and a few of them will tell other handymen.
Related ideas from the list
- House Painting Work Tracker, the same job tracking mechanic for a trade with bigger projects.
- Mobile Car Washing Service Tracker, another service business that runs on calls and appointments.
- Power Washing Business Calendar, which sells the same kind of buyer a schedule instead of a log.
Want the other 99? This is one idea from my list of 100 business ideas you can build in Google Sheets. Get all 100 business ideas as a free Google Sheet.
And if you want to learn how to package and sell spreadsheets, my course Selling Spreadsheets walks through exactly that.