July 29, 2026 · ViaSheet Team
The Tradesperson CRM Spreadsheet: Electricians, Plumbers & HVAC Guide
Discover how self-employed electricians, plumbers, HVAC engineers, and specialty trade contractors track job quotes, materials, warranty expirations, and annual maintenance servicing in Google Sheets.
For self-employed electricians, plumbers, HVAC technicians, gas engineers, and specialty trade contractors, running a successful trades business relies on managing two distinct operational sides: Executing Field Work (job site quotes, parts & materials procurement, vehicle stock, warranty terms, safety compliance) and Managing the Business (customer lead inquiries, quote follow-ups, invoice clearing, and annual recurring maintenance servicing).
According to a benchmark survey by the National Association of State Contractors Licensing Agencies (NASCLA), independent tradespeople lose up to 24% of annual gross income because they fail to follow up on unaccepted quotes or forget to contact past customers for annual maintenance check-ups (e.g. annual boiler servicing, AC tune-ups, electrical safety inspections).
While specialized field management software like Jobber, ServiceM8, Tradify, or Housecall Pro exists, their monthly subscription fees ($360 to $1,200 per year) represent an expensive recurring overhead for solo tradespeople and small 2-to-5-person trade teams.
In this ultimate guide, we will show you step-by-step how to build a production-ready Trades CRM Spreadsheet in Google Sheets or Microsoft Excel. You will learn how to track job pipelines from quote to invoice, manage parts and supplier costs, automate warranty expiration alerts, run annual maintenance campaigns, and calculate job profitability without monthly software fees.
Why Independent Tradespeople Need a Spreadsheet CRM
Trade businesses operate on high call volume and rapid job turnover. Electricians and plumbers jump between emergency repair calls, domestic rewires, boiler replacements, and commercial fit-outs.
Here is why self-employed tradespeople choose Google Sheets or Excel:
- Zero Monthly Overhead: Trade income fluctuates seasonally. Eliminating $50/month software fees protects your trade van cash flow during slow months.
- Instant Field Van Mobile Access: Storing customer property addresses, gate access codes, boiler model numbers, and job notes in a cloud Google Sheet allows tradespeople to view details on smartphones or tablets right from the work van.
- Parts & Material Margin Tracking: Trade pricing requires tracking wholesale parts costs vs. retail customer quotes (e.g., 20% markup on copper fittings or electrical breakers). Spreadsheets allow custom formula tracking for every job quote.
- Annual Maintenance Campaign Automation: Automatically generating annual servicing reminders (e.g. 12 months after a new boiler or HVAC installation) fills your schedule during quiet winter or spring months.
Architecture of a Trades CRM Spreadsheet
To keep your trade business organized, professional, and profitable, structure your spreadsheet into six core tabs:
[1. Customer & Property Database] ➔ [2. Master Job Pipeline] ➔ [3. Quote Tracker & Conversion] ➔ [4. Warranty Expiration Radar] ➔ [5. Annual Maintenance Campaign] ➔ [6. Trades Revenue Dashboard]Tab 1: Customer & Property Database
Stores customer names, mobile phone numbers, property addresses, billing email, total jobs completed, and property equipment notes (e.g. Boiler Model: Worcester Bosch Greenstar 30i, Install Date: March 2024).
Tab 2: Master Job Pipeline
Tracks active jobs: Customer Name, Job Description (e.g. Fuse Box Upgrade, Bathroom Rough-In), Job Stage (1. Inquiry ➔ 2. Quote Sent ➔ 3. Scheduled ➔ 4. In Progress ➔ 5. Complete ➔ 6. Invoiced), Labor Hours, Parts Cost ($), and Total Charge ($).
Tab 3: Quote Tracker & Conversion
Logs outstanding estimates, quote presentation dates, follow-up alerts, and quote conversion rates to close more bids.
Tab 4: Warranty Expiration Radar
An automated schedule tracking 12-month, 24-month, or 5-year installer warranties for equipment and labor, alerting you before warranties expire.
Tab 5: Annual Maintenance Campaign
Logs recurring annual service dates (annual gas safety checks, HVAC filter replacements, backflow preventer tests) with automated customer outreach alerts.
Tab 6: Trades Revenue Dashboard
Displays high-level executive analytics: Monthly Gross Revenue, Outstanding Unpaid Invoices ($), Job Win Rate %, and Revenue by Trade Service Category.
Step-by-Step: Building Your Trades CRM Spreadsheet
Let’s build the Master Job Pipeline and Annual Maintenance Campaign tabs in Google Sheets or Excel.
1. Structure the Master Job Pipeline Tab
Create a tab named Job Pipeline and set up the following headers in Row 1:
| Column | Header Name | Data Type | Description / Formula |
|---|---|---|---|
| A | Job ID | Formula | =IF(ISBLANK(B2), "", "JOB-" & TEXT(ROW()-1, "0000")) |
| B | Customer Name | Text | Customer full name |
| C | Property Address | Text | Jobsite location address |
| D | Trade Service Category | Dropdown | Electrical, Plumbing, HVAC / Gas, Boiler Install, General Maintenance |
| E | Estimated Labor ($) | Currency | Labor charge estimate |
| F | Parts Cost ($) | Currency | Wholesale materials cost |
| G | Total Quoted Price ($) | Formula | =E2 + (F2 * 1.20) (Includes 20% parts markup) |
| H | Job Stage | Dropdown | 1. Inquiry, 2. Quote Sent, 3. Scheduled, 4. Complete, 5. Invoiced, 6. Paid |
| I | Invoice Due Date | Date | Invoice payment deadline |
| J | Payment Status Alert | Formula | Visual alert checking unpaid invoices |
2. Automating Annual Maintenance Servicing & Warranty Alerts
Annual maintenance calls are the highest-margin work in trades business. Automate customer recall warnings:
A. Automated Annual Service Due Date (Column G on Maintenance Tab)
Calculate the 1-year (365-day) maintenance recall date from the last service date:
=IF(ISBLANK(Last_Service_Date), "", Last_Service_Date + 365)B. Maintenance Outreach Alert Formula (Column H)
In cell H2, write a conditional logic check classifying service urgency:
=IF(ISBLANK(Last_Service_Date), "No History", IF(TODAY() > Service_Due_Date, "🚨 OVERDUE FOR ANNUAL SERVICE", IF((Service_Due_Date - TODAY()) <= 30, "⚠️ SERVICE DUE (30 Days)", "✅ Serviced / Up to Date")))Explanation:
- If today’s date has passed
Service_Due_Date, flags as🚨 OVERDUE FOR ANNUAL SERVICE(Send friendly SMS or email reminder for annual boiler/HVAC check-up). - If within 30 days of due date, flags as
⚠️ SERVICE DUE (30 Days). - Otherwise, displays
✅ Serviced / Up to Date.
Apply Conditional Formatting to highlight 🚨 OVERDUE FOR ANNUAL SERVICE in bright red (#FEE2E2).
3. Calculating Job Profitability & Parts Markups
On your Trades Revenue Dashboard, track net profit margins per job to ensure profitable quotes:
| Job Description | Quoted Total ($) | Parts Cost ($) | Labor Hours | Net Gross Profit ($) | Gross Margin (%) |
|---|---|---|---|---|---|
| Boiler Replacement | $3,500.00 | $1,800.00 | 8 hrs | =A2 - B2 ($1,700.00) | =D2 / A2 (48.5%) |
| Main Panel Upgrade | $2,200.00 | $850.00 | 6 hrs | $1,350.00 | 61.3% |
Net Gross Profit Formula (Column D):
=IF(OR(ISBLANK(Quoted_Total), ISBLANK(Parts_Cost)), 0, Quoted_Total - Parts_Cost)Gross Margin Percentage Formula (Column E):
=IF(ISBLANK(Quoted_Total), 0, Net_Gross_Profit / Quoted_Total)5 Field Productivity Hacks for Tradespeople
- Send Instant SMS Follow-Ups on Sent Quotes: Filter your
Quote Trackerfor quotes sent over 3 days ago. Send a quick text: “Hi John, just checking if you had any questions regarding the electrical panel quote I sent over Tuesday!” - Log Equipment Model & Serial Numbers: Record boiler serial numbers, AC refrigerant types, and panel brand details in Column K for instant parts ordering before heading to a repair site.
- Audit Unpaid Invoices Daily: Apply conditional formatting to highlight completed jobs whose invoice status remains
Unpaidpast 14 days (🚨 OVERDUE INVOICE). - Log Supplier Material Price Changes: Keep a master
Materialstab listing common parts (e.g. 1/2” copper pipe, 20A breakers) with last-paid supplier prices to ensure accurate quoting. - Manage Daily Van Route Maps: Group jobs by zip code or neighborhood in Column L to minimize driving time between morning emergency calls and afternoon installs.
Frequently Asked Questions (FAQ)
Can tradespeople update job statuses directly from their phones in the work van?
Yes! Google Sheets has free mobile apps for iOS and Android. Electricians and plumbers can open the active job sheet, update job statuses to Complete, and log parts used directly from a smartphone at the jobsite.
How do I handle warranty callbacks versus paid emergency jobs?
In your Master Job Pipeline tab, set the Job Type dropdown to Standard Paid Job, Annual Maintenance, or Warranty Callback. For warranty callbacks, set the labor charge to $0 to track un-billable warranty labor accurately.
Is Google Sheets secure for storing customer addresses and gate codes?
Yes. Google Sheets uses enterprise Google Cloud encryption. Ensure your Google account uses Two-Factor Authentication (2FA), restrict edit permissions to authorized staff, and avoid sharing sheets publicly.
Upgrade to the ViaSheet Trades CRM Spreadsheet
Building a custom trades database with job pipelines, parts markup calculators, warranty expiration radars, and annual servicing campaign logs requires hours of setup.
If you want a pre-built, battle-tested spreadsheet engineered specifically for electricians, plumbers, HVAC engineers, and trade contractors, explore our Trades CRM Spreadsheet.
The ViaSheet Trades CRM features:
- Trades Executive Dashboard: Real-time stats on weekly jobs, monthly revenue, pending quotes, unpaid invoice totals, and job win rates.
- Customer & Property Register: Store customer contact details, property addresses, boiler/HVAC equipment specs, and service history.
- Master Job Pipeline: Track jobs from inquiry to quote sent, scheduled, complete, and invoiced.
- Automated Warranty & Maintenance Radar: Color-coded alerts for expiring warranties and annual servicing dates (annual boiler/AC tune-ups).
- Parts & Materials Ledger: Track wholesale parts costs vs. retail customer quotes to ensure high profit margins.
- One-Time Purchase: Pay just €29 once for lifetime access in Google Sheets and Microsoft Excel—no monthly fees or software subscriptions ever.
Win more quotes, protect recurring maintenance revenue, and run a profitable trades business. Download the ViaSheet Trades CRM today!