Excel Invoice Template for Handyman Services
The handyman invoice has a problem the specialty trades do not. A plumber shows up, replaces a water heater, and leaves. You show up, replace a water heater, and while you are there the customer mentions the closet door sticks, the smoke detector is chirping, and could you look at the fence gate. By the end of the day you have done six unrelated things for one person, and now you have to turn that into a document that makes sense to them and still tells you something useful.
What a handyman invoice needs that a generic template does not
Multiple unrelated tasks on one document, each priced separately. The customer wants to see what each thing cost, not one lump sum labeled “handyman services.” Itemizing is not bureaucracy here, it is how you avoid the conversation where someone thinks four hours of work should have cost less because they were only thinking about the door. It also means that when they call again in two months, you can look up what you charged for the same task last time.
You need to know which tasks were actually worth doing. This is the one that costs handymen real money. Some jobs on your list are profitable and some are barely worth the drive, and if every invoice is a single labor total you will never find out which is which. A per-task cost and margin turns a year of scattered work into an answer about what you should be saying yes to.
Materials get bought at retail, mid-job. Unlike the trades with supply house accounts, a lot of handyman material comes from a hardware store run in the middle of the day. That receipt needs to land on the invoice with whatever markup you apply, and the trip itself is time that either gets billed or silently eats your margin. A generic template has nowhere to put either fact.
Three kinds of handyman work, three different documents
The multi-task visit
The most common job and the hardest to invoice. Several small unrelated tasks in one visit, some quick and some not. The customer’s mental math is running the whole time, so the invoice needs to show its work: this task, this long, this much. Bundled into one line it looks arbitrary, no matter how fair the number is.
The quoted project
Deck repair, drywall and paint in a room, fence section replacement, tile backsplash, door and trim work. These get quoted before the work and the customer is often comparing you against a specialty contractor who charges more. Your advantage is that you are doing all of it rather than three separate trades, and the quote should make that legible — everything included, one crew, one number.
Recurring and property work
Landlords, property managers, realtors prepping listings, and elderly clients who call every few weeks. This work is steadier and lower-drama than one-off residential, but it bills differently: often monthly rather than per visit, sometimes against a purchase order, and usually with an expectation that you can produce a history of what you did to which property. That last part is where paper invoices in a folder stop working.
Line items handyman services actually bill
- Labor — standard hourly, half-day and full-day rates, minimum service charge, after-hours or weekend rate, two-person rate for jobs that need a second set of hands
- Trip and pickup — service call or trip charge, material pickup time, disposal or dump run
- Carpentry and doors — door adjustment and rehang, lock and deadbolt replacement, trim and baseboard, shelving, cabinet hardware, deck board and railing repair
- Drywall and paint — patch by size, texture matching, room or wall painting, caulking, trim paint
- Fixtures and small installs — ceiling fans, light fixtures, faucets, toilets, garbage disposals, blinds, curtain rods, TV mounts, grab bars, smoke and CO detectors
- Exterior — gutter cleaning, pressure washing, fence repair, screen replacement, weather stripping, minor roof and siding patching
- Materials — hardware store purchases at cost plus markup, with the pickup trip billed or absorbed deliberately
The list is longer than a specialty trade’s and that is the point. Nobody remembers what they charged for a ceiling fan install eight months ago. Having the common tasks saved with a price means today’s fan install matches the last one, and the customer who calls back gets the same number rather than whatever you guessed on the phone.
What a multi-task visit invoice looks like
A half-day visit, four unrelated tasks, one customer. The four columns on the left are what the customer receives. The three on the right stay in your workbook and never print.
| Description | Qty | Price | Amount | Taxable | Cost | Margin |
|---|---|---|---|---|---|---|
| Ceiling fan install — bedroom (fixture supplied by customer) | 1 | 145.00 | 145.00 | ☐ | 55.00 | 90.00 |
| Interior door — plane, rehang, adjust strike | 2 | 85.00 | 170.00 | ☐ | 28.00 | 114.00 |
| Drywall patch and texture — hallway, 12in | 1 | 120.00 | 120.00 | ☐ | 42.00 | 78.00 |
| Smoke detector replacement — hardwired | 3 | 55.00 | 165.00 | ☐ | 18.00 | 111.00 |
| Materials — detectors, patch compound, hardware | 1 | 96.00 | 96.00 | ☑ | 64.00 | 32.00 |
| Material pickup — hardware store run | 0.5 | 70.00 | 35.00 | ☐ | 32.00 | 3.00 |
| Subtotal | 731.00 | — | 327.00 | 404.00 | ||
| Tax (6.5%, taxable lines only) | 6.24 | — | — | — | ||
| Total | 737.24 | Profit $404 (55.3%) | ||||
Half-day visit, 4 hrs on site. Bedroom fan mounted to existing braced box. Two interior doors planed and rehung. Hallway patch textured to match; paint not included, customer to finish. Three hardwired detectors replaced with interconnect verified.
Look at the right-hand columns for a second, because that is where the useful information is. The door work and the detectors carried the day. The material pickup ran half an hour and made three dollars — which is fine once, and a problem if every job has one. That is the kind of thing you cannot see on a single invoice and cannot miss across fifty of them. Those columns stay in your workbook; the customer’s copy is the four on the left.
Where the template approach breaks down
The first invoice is easy. It is the pattern across a year that a template will never show you.
Every ceiling fan install gets priced from memory, so it drifts. Repeat customers get their address retyped every time. The property manager asks what you have done at the Oak Street unit since spring and the answer is somewhere in a folder of forty files. And the question that actually matters — which of the twenty things you do is worth your time — has no answer at all, because nothing is adding it up.
What we built instead
EG Quote & Invoice is a macro-enabled Excel workbook that turns Excel into an actual quoting and invoicing application. It keeps a client list and a priced catalog of the tasks you do over and over, so a multi-task visit is a few clicks rather than a rebuild. It converts a won quote into an invoice in one click, tracks what has been paid and what is overdue, and shows your margin on every line — which is how you find out which tasks are worth saying yes to.
It runs on your own PC. No account, no cloud, no subscription. The free edition has no limit on how many quotes or invoices you create and does not expire.
See EG Quote & InvoiceFree edition · Windows Excel · 32-bit and 64-bit
Other trades: Browse all invoice templates by trade →
★★★★★
“Talk about fast and knowledgable! Money well spent! This man is going to save me 1 hour every-week just from this excel program!!!”
Workbook repair client · via Upwork, 2021
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →