Service Business Tracker for HVAC, Plumbing, Lawn Care (Excel/Google Sheets)
Price:$16.99
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
Service business spreadsheet for HVAC, plumbing, lawn care and handyman work (Excel and Google Sheets): quotes, jobs, invoices, payments and job profit for teams of 1 to 5 people.
For HVAC, plumbing, electrical, lawn care, pressure washing, cleaning and handyman businesses with 1 to 5 people. Build a quote from your own price list, turn it into a job, invoice it (deposits too), log the payments, and see what every job really made. The Dashboard shows what you've earned, who owes you and for how long, which quotes need a follow-up and which kinds of work make the most money.
WHAT'S INCLUDED
• Service-Business-Tracker.xlsx: the workbook for your records (16 tabs, starting lists for any trade)
• Service-Business-Tracker-DEMO.xlsx: the same workbook filled with a fictional business (Sample HVAC Co.), so you can see every feature working
• PDF guide: setup in 6 steps, every tab explained, and a link to make your own copy in Google Sheets
The listing photos show the sample (DEMO) file. Sample data shown: the business, customers and amounts are fictional.
THE TABS
• Dashboard: revenue this month and year to date, money owed with aging (current, 1–30, 31–60, 61–90, 90+ days), net profit, quote win rate, average job margin, top job types by profit, leads by source, jobs coming up, jobs ready to invoice, and 3 charts
• Settings: your business details, labor rate and labor cost, materials markup, sales tax (your rate, and which kinds of lines are taxed), payment terms, mileage rate, and your own job types, lead sources and expense categories
• Customers: name, phone, email, address and lead source, with quotes, jobs, billed and balance due for each
• Price List: your common items with cost, markup, price and estimated hours; pick them on a quote and the price fills in
• Quotes and Quote Lines: labor hours x rate, materials at cost + markup, flat-rate items and fees; subtotal, tax, total, estimated profit; Draft, Sent, Won or Lost, with follow-up and "expired" flags
• Jobs: link a won quote and the customer, price and tax fill in; quoted vs. actual hours and materials, job profit and margin, and the billing status with the invoice #
• Invoices and Payments: invoice #, due date, deposits and final bills, payments log, balance, days late and aging bucket
• Expenses: categories for small trades (materials, fuel, tools, insurance, vehicle, advertising, subcontractors, permits, software, phone and more), with job tagging for job costs
• Mileage: trip log with your per-mile rate by date
• Monthly P&L: revenue, expenses by category, gross and net profit for each month, plus sales tax collected
• Quote Form and Invoice Form: pick a number and print a clean estimate or invoice with your business details
• Start Here: quick start, FAQ and sources
BUILT TO AVOID MISTAKES
• Cream cells are for you; gray cells are formulas. In Excel they're locked (no password), so you can't type over them by accident
• Dropdowns for customers, job types, items, statuses, categories and payment methods
• A Check column on every log flags missing or mismatched entries, and the Dashboard counts them
• "Blank = default": leave a cell empty to use your price list or settings, or type to override that one row
• No macros. Your data stays in your own file.
WHO IT'S FOR
Owner-operators and small crews who quote, schedule and bill their own work and want clear numbers without a monthly software fee. It suits quoted jobs (installs, projects) and recurring work billed monthly (mowing routes, cleaning clients, service agreements).
HOW DELIVERY WORKS
Instant download after purchase: two .xlsx files and a PDF guide. Open the .xlsx in Microsoft Excel, or follow the link in the PDF guide to make your own copy in Google Sheets. (You can also upload the .xlsx to Google Drive and open it with Google Sheets.)
WHAT IT ISN'T
This workbook is for recordkeeping. It is not tax, legal, or accounting advice, and it doesn't file anything for you. Sales tax rules differ by state and by type of work: you choose the rate and what's taxed. The mileage rate is yours to enter and check. Confirm your numbers with your tax professional.
Designed and built by an AI agent, published by Deftcell (Elite Tech Global LLC); every formula is tested before release.
FAQ
• Does it work in Google Sheets? Yes. Every formula uses functions that both Excel and Google Sheets support. No macros. The PDF guide has a copy link.
• Is it only for HVAC? No. The sample business is an HVAC company, but the job types, price list and expense categories are yours to edit for any trade.
• Can I take deposits? Yes. Invoice a deposit as an amount, then bill the rest of the job later; payments and balances track both.
• How is sales tax handled? You enter your rate and choose which kinds of lines are taxed (labor, materials, flat-rate items, fees). Any quote line can override it, and a quote or invoice can use its own rate.
• What is job profit? The price minus actual hours x your labor cost per hour, minus the expenses you tag to the job.
• Does it work on a phone? It's designed for a computer. The Excel and Google Sheets phone apps are fine for quick look-ups.
• How many jobs? 250 customers, 60 price-list items, 250 quotes with 1,000 quote lines, 400 jobs, 400 invoices, 600 payments, 1,200 expenses and 400 trips. Start a fresh copy each year if you need more.
• Can I change it? Yes. In Excel the sheets are protected without a password, so you can unprotect them to customize. Your Google Sheets copy is fully editable.
REFUNDS
Because this is an instant digital download, returns and exchanges aren't accepted. If a file won't open or doesn't work as described, send us a message and we'll fix it or help you get it working.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
HazCom 2024 Update Kit, Chemical Inventory, SDS Tracker, Training Log (Excel/Google Sheets)
$14.99
-
Digital download
Church Donation Tracker & Year-End Giving Statements, Nonprofit Donor Log (Excel/Google Sheets)
$8.99
-
Digital download
Tithe Tracker 2026 Spreadsheet, Personal Giving Log & Charitable Donation Record, Tithing Goal (Excel/Google Sheets)
$4.99
-
Digital download
Trucking IFTA Fuel Tax & Owner-Operator Expense Tracker Spreadsheet (Excel/Google Sheets)
$14.99
Be the first to leave a review
-
Digital download
Contractor Lead Tracker & Follow Up CRM | Service Business Lead Management Spreadsheet | Job Tracking and Sales Organizer
$12.99
-
Digital download
Construction Accounting Spreadsheet, Job Costing and Progress Billing Tracker for Contractors, Google Sheets + Excel Template with P&L
Sale Price $7.50
Original Price $15.00
-
Digital download
Small Business Excel Template: Automated Invoice, Order, Inventory (Digital Download)
Sale Price $8.25
Original Price $11.00
-
Digital download
Home Maintenance and Repair Business Income Statement Generator | Simple Bookkeeping for Small Business | Excel | Googlesheets
$17.00
-
Digital download
Plumbing and HVAC Template Bundle: Client Database, Track Service Tech Calls, Technicians, Inventory, and Maintenance Contracts
Sale Price $11.19
Original Price $13.99
-
Digital download
Work From Home Service Order Sheet | Google Sheets & Excel | Remote Work Agreement Template | Editable Work Order Form | Freelancer Invoice
Sale Price $5.70
Original Price $11.40
-
Digital download
Service Business: Spreadsheets Templates Bundle Budget Job Scheduler Client Tracker Scheduling Calendar Invoicing Excel Google Sheets Ipad
Sale Price $9.56
Original Price $11.95
-
Digital download
Special Offer Small Business Excel Templates, Etsy Business Planner Editable, Profit and Loss Business Spreadsheets, Invoice Template
Sale Price $15.00
Original Price $30.00
-
Digital download
Electrical Business Performance Dashboard | Contractor Profit KPI Tracker (Digital Download)
Sale Price $25.54
Original Price $51.09
-
Digital download
HVAC Forms Bundle, Quote, Invoice, Receipt, Excel & Word (Digital Download)
Sale Price $9.00
Original Price $13.86
-
Digital download
Job Cost Estimator (Excel + Google Sheets) | Contractor Pricing Spreadsheet (Digital Download)
Sale Price $8.44
Original Price $12.99
-
Digital download
Cost Tracker Excel Template | Pricing Calculator & Business Expense Management Tool
Sale Price $7.50
Original Price $10.00
Shoppers with similar taste loved these
-
Digital download
Lawn Care Business Forms Bundle | Printable Fillable PDF
$11.99
-
Digital download
Lawn Care Client Tracker - lawn care client log - lawn care template - lawn care business - lawn maintenance -landscaping business lawn care
Sale Price $2.59
Original Price $5.19
-
Digital download
Lawn Care Branding Kit: Garden Service Canva Templates (Instant Download)
$27.40
-
Digital download
Lawn Care Business Forms, Canva Templates, Landscaping Service Agreement, Pricelist, Invoice, Checklist & Client Forms, Small Business
$18.11
-
Digital download
Lawn Care Lawn Mower Logo Design, Landscaping Logo, Landscape Maintenance Logo, Zero Turn Mower Logo, Grass Cutting Logo Design, Garden Logo
Sale Price $16.44
Original Price $54.79
-
Digital download
Lawn Care Business Tracker, Automated Schedule Weekly Monthly Google Sheets Template, Google Maps Integrated
Sale Price $13.78
Original Price $22.97
-
Winged Wire Nut Container: ASA Plastic Electrician Tool Organizer
$10.00
-
Digital download
HVAC Preventative Maintenance Checklist Template - Editable Microsoft Word Document - Air Conditioning HVAC Inspection - Digital Download
Sale Price $4.03
Original Price $6.20
-
HVAC Poster, Air Conditioning Poster, Knowledge Poster, HVAC Technician Gift, Industrial Decor, Air Conditioner Poster, AC Poster
$21.00
-
Digital download
HVAC Unit Warranty Canva Template | Decal/Magnet/Sticker/Vinyl Template | Heating and Air / Furnace Template | Instant Download
$3.99
-
Certified YouTube Mechanic sticker - Multiple Sizes Available - FREE shipping!
$4.75
-
What Part of Do You Not Understand T Shirt, Gifts for Dad or Boy Friend, heating guy tee, Funny HVAC Shirt, air condionting dude shirt
$18.99