How to Keep Track of Customers and Job History as a Tradesperson

The Most Expensive Thing You Can Forget

A customer calls. "Hey, you did some work at my house last year — can you come back?" You say yes, drive 30 minutes to the address, and stand in the driveway trying to remember what you did, what parts you used, and where the shutoff valve was.

Or worse: a regular customer calls someone else because you never followed up after the last job. They weren't unhappy — they just forgot your name because you didn't have a system to stay in touch.

Repeat customers are the most profitable part of any trade business. They don't need convincing. They don't shop around. They call you because they trust you. But only if you remember them — and they remember you.

What You Should Track for Every Customer

At minimum, keep a record with these fields for every customer you serve:

Contact information

• Full name (and spouse/partner name if relevant)
• Phone number (cell preferred — that's where they'll text you)
• Email address (for invoices and follow-ups)
• Service address (not always the same as billing address)

Property details

• Gate code or lockbox combination
• Dog in the backyard? Note it.
• Where's the main shutoff / breaker panel / HVAC access?
• Parking instructions (especially for commercial)
• Property type — rental, owner-occupied, commercial

Job history

• Date of each visit
• What you did — specific description, not "plumbing repair"
• Parts used — brand, model, size
• What you charged
• Any issues or follow-up items ("recommend replacing supply valves next visit")

Notes

• Preferences — "customer prefers text over phone calls"
• Billing info — "landlord pays, send invoice to [email]"
• Anything unusual — "main line runs under addition, camera showed roots at 47 ft"

Where Most Tradespeople Keep This (And Why It Fails)

Their head

You can remember 20 regular customers. Maybe 30. But when you hit 50, 100, 200 customers over a few years, memory fails. You show up to a job you've done before and can't remember the gate code, the equipment model, or what you told them last time.

Their phone contacts

You save the customer's name and number. Maybe you add a note: "Johnson — faucet 2024." But phone contacts aren't searchable by job type, date, or address. When Johnson calls 18 months later, that note is useless.

A notebook

Reliable until you lose it, spill coffee on it, or need to find a specific entry from seven months ago. Notebooks are write-only — you never go back and read them efficiently.

A spreadsheet

Better than the options above. You can search, sort, and filter. But spreadsheets aren't connected to your schedule or invoices. The customer record, the job details, and the invoice live in three different places. Updating all three is a chore you skip when you're busy — which is always.

What Good Customer Tracking Actually Looks Like

Here's the difference between a tradesperson with a system and one without:

Without a system:

Customer calls: "You were here last summer, the AC is doing the same thing."

You: "Remind me of your address?" (already looks unprofessional)
You arrive, spend 20 minutes figuring out what you did last time.
You diagnose the same issue and can't remember what part you used.
You guess on the invoice because you don't have last year's records.

With a system:

Customer calls: "You were here last summer, the AC is doing the same thing."

You pull up their profile: 742 Oak St, Carrier 3-ton split, east side. Last visit: July 2025 — replaced 40/5 capacitor, added 2 lbs R-410A, noted possible refrigerant leak.

You: "I remember — I flagged a possible leak last time. I'll bring my leak detector and we'll track it down. Does Thursday morning work?"

The customer thinks you're a genius. You just read your own notes.

The Repeat Customer Math

Repeat customers are worth 5–10x more than new customers over their lifetime. Here's why:

• Zero acquisition cost. You don't pay for ads, flyers, or referral fees. They already know and trust you.
• Higher close rate. A repeat customer says yes to recommended work 70%+ of the time. A new customer? 30–40%.
• They refer you. A happy repeat customer tells their neighbors, their property manager, their family. One good customer can generate 3–5 referrals over a few years.
• They're less price-sensitive. A customer who trusts you doesn't shop around for three quotes. They call you, you give them a number, they say yes.

Losing a repeat customer because you forgot their name, their address, or what you did last time is the most expensive mistake in the trades — and the most preventable.

Building Your Customer System

You don't need fancy CRM software. Start with whatever you'll actually use consistently:

Level 1: Phone contacts + notes app

Save every customer as a contact. After each job, add a note in your phone's notes app: date, address, what you did, parts used. Search by customer name when they call back.

Time per job: 2 minutes
Works until: ~50 customers

Level 2: Spreadsheet

Create a Google Sheet with columns: name, phone, email, address, date, job description, parts, amount, notes. One row per job. Filter and search as needed.

Time per job: 3–5 minutes
Works until: ~200 customers (then it gets slow and unwieldy)

Level 3: A tool that connects customers to jobs and invoices

This is where JobNBill fits. Every customer has a profile. Every job is linked to that customer. Every invoice is linked to that job. When the customer calls back, you tap their name and see:

• Every job you've done for them, with dates and descriptions
• Every part you used and every note you left
• Every invoice — paid, pending, or overdue
• Their address, phone, email, and any property notes

No separate spreadsheet. No notes app. No guessing. It's all in one place because it was entered once — when you scheduled and completed the job.

Time per job: 0 extra minutes (data is captured as part of scheduling and invoicing)
Works until: Unlimited

5 Habits That Build a Great Customer Database

1. Enter the customer before the job, not after. When they call to book, create the record immediately. If you wait until after the job, you'll skip it.
2. Add notes on-site, not at home. The details are freshest while you're still looking at the equipment. "Navien NPE-240A, serial #[X], installed 2021, filter access behind lower panel" takes 30 seconds to type and saves 30 minutes on the next visit.
3. Record what you'd want to know next time. Not just what you did — what you'd want to know if you came back in 6 months. Where's the access panel? What's the gate code? Is there a dog?
4. Note recommended future work. "Supply valves are original — recommend replacing at next visit" turns a $0 note into a $200 upsell next time. And the customer appreciates that you're looking out for them.
5. Update, don't duplicate. When you return to a customer, update their existing record. Don't create a new one. One customer, one profile, complete history.

Your Customer List Is Your Most Valuable Asset

Your van, your tools, your skills — those are replaceable. Your customer list isn't. A plumber with 500 customers and detailed job history for each one has a business worth selling someday. A plumber with the same skills but no records has a job.

Start tracking today. Pick whatever system you'll actually use. And if you want everything — customers, jobs, invoices, notes — in one place without extra effort, give JobNBill a try.

Try JobNBill Free for 14 Days →

No credit card required. Your first customer takes 30 seconds to add.