How to Deduplicate Customers in Jobber, Housecall Pro, and ServiceTitan

Companies lose 16 sales deals per quarter due to poor-quality CRM data, according to Validity's 2025 State of CRM Data Management report.

For home service contractors, the single largest contributor is duplicate customers. Two records for the same household means split job history, blown-up reactivation lists, and revenue reports that lie.

Each of the three biggest contractor CRMs handles deduplication differently. This is the step-by-step playbook for all three.

Why Duplicates Show Up in Contractor CRMs

Before you start merging, understand the source so you do not just recreate them.

The four most common causes:

• A CSR cannot find a returning customer by phone, gives up, and creates a new record
• A QuickBooks sync introduces a billing record that does not match the existing Jobber or HCP name
• A tech adds a customer in the field while the office adds the same customer from a phone call
• An online booking form auto-fills "New Jersey" while the customer types "NJ", which the CRM treats as a different address

A contractor on the Jobber community forum said the autofill mismatch is the most common duplicate trigger he sees, accounting for the majority of his weekly QuickBooks sync errors.

Step 1: Pull a Customer Export

Before you touch any merge button, export everything. You want a snapshot to fall back on if a merge goes wrong.

In Jobber, go to Reports and run the Client list export. In Housecall Pro, the Customers list has a CSV Export action. In ServiceTitan, run the Customer List report under Reports.

Export jobs and invoices separately too. If you ever need to reconcile a merged customer's job history, those exports are your audit trail.

Text Clint: "how many total customers and how many jobs are in my CRM right now?"

Step 2: Identify Duplicate Candidates

Sort the customer export by phone number. Then sort by address. Then by last name.

The strongest duplicate signal is two records sharing two of those three fields. A pair sharing only one field is a maybe. A pair sharing all three is almost guaranteed.

Mark the keeper. The keeper is usually the older record (more job history) or the one that lines up with QuickBooks if you sync billing.

For a 4,000-customer database, expect 200-800 duplicate pairs to surface. For a 10,000-customer database, expect 800-2,500 pairs.

Text Clint: "find duplicate customers where the phone or address matches and rank by which has more completed jobs"

Step 3: Deduplicate in Housecall Pro

Housecall Pro has the cleanest native experience.

Click Customers in the left nav, then Actions, then Manage Duplicates. Housecall Pro auto-groups customers by Name, Mobile, Home Phone, Work Phone, or Email.

Open one group at a time. Expand each customer row to see job history, addresses, and notes. Confirm the customers really are duplicates, then select two or more and click Merge in the upper right corner.

Bulk merge is also available. From the Customers list itself, check boxes next to customers you want to merge, click Bulk Actions, then Merge Customers.

Two warnings on Housecall Pro merges:

• You cannot unmerge after you confirm. Test on one pair first to make sure the result is what you expect.
• All tags, notes, addresses, and emails get combined. If any record was marked Do Not Service, the merged record inherits that flag.

Text Clint: "list customers I just merged in Housecall Pro and confirm the job count moved over"

Step 4: Deduplicate in ServiceTitan

ServiceTitan has merge built in but the path is less obvious.

Open the customer record you want to keep, then go to Settings (the gear icon) and select Merge Customer. Pick the duplicate customer to merge in. Same flow exists at the location level via Merge Locations.

Important constraint: locations can only merge if they are under the same customer. If you have a location attached to the wrong customer, you have to relocate it first by editing the customer field on the location page, then merge.

Run the duplicate report first. ServiceTitan ships a built-in duplicate customer and duplicate location report you can schedule to email daily. Set that up before you start merging so you have a working list rather than guessing.

A community-recommended workflow from ServiceTitan users: append "DUP" or "INACTIVE" to the duplicate name as you find them, work through merges in batches, and use Ctrl+F on the customer list to expedite search on larger accounts.

Text Clint: "show me ServiceTitan locations attached to the wrong customer based on billing address"

Step 5: Deduplicate in Jobber (the Manual Workaround)

Jobber is the painful one. Jobber does not let you merge clients natively, and they have not committed to a release date despite years of feature requests on the community forum.

The manual workaround:

1. Open both client profiles in two browser tabs
2. Decide which one is the keeper, usually the older one with more job history
3. Copy notes, custom fields, and tags from the dupe into the keeper
4. Move any open quotes or jobs from the dupe to the keeper by editing the client field on each one
5. Note the dupe's address(es) and add them to the keeper as additional properties if applicable
6. Re-link any photos or attachments by downloading from the dupe and uploading to the keeper (Jobber does not allow direct copy)
7. Delete the dupe profile

Jobber operators on the community forum estimate 30 minutes per pair. For a database with 400 duplicate pairs, that is 200 hours of office work, which is why most Jobber shops do this in waves over a quarter rather than a single weekend.

To prevent QuickBooks-driven duplicates going forward, Jobber's official guidance is to sync one direction first and accept that side as the master. If you already have clients in QuickBooks, sync them into Jobber first instead of importing a CSV that overlaps.

Text Clint: "list my Jobber duplicate candidates by phone match and tell me which has more completed jobs so I know which to keep"

Step 6: Standardize Addresses to Prevent Recurrence

Half of all new contractor CRM duplicates trace back to address inconsistencies. Fix the root cause now.

Run your customer addresses through USPS standardization, SmartyStreets, or a similar service. Output is a single canonical format per household. "123 Main Street", "123 Main St", and "123 Main St." collapse into one.

Apartments, suite numbers, and unit numbers belong in the unit field, not appended to the street. ZIP+4 should be present and formatted consistently.

Watch for two patterns that look like duplicates but are not:

• A customer with two physical addresses where one is a billing address. Often the billing address belongs to a property manager or family member, and the service address is the real customer
• Property managers tied to 30 service locations. These are a single customer with many properties, not 30 duplicates

If your CRM has a parent-child or property-level structure, use it. ServiceTitan has it native. Housecall Pro added a property layer in recent updates. Jobber stores additional properties under a single client, which works for residential but not commercial portfolios.

Text Clint: "show me customers with two addresses where one is the billing address and the other is the service address"

Step 7: Confirm Job History Stayed Intact

After every merge, spot-check that job history transferred. Pull the merged customer record and count completed jobs, total revenue, and last service date.

Compare against the pre-merge totals from your Step 1 export. They should match. If they do not, restore from the export and figure out what the merge tool dropped before continuing.

Housecall Pro reports have known gaps on customer-level revenue rollups, so you may need to use the export rather than the dashboard for this confirmation.

Text Clint: "rank customers by total revenue in the last 24 months and flag any whose job count dropped after a merge"

Step 8: Set the Recurring Maintenance Habit

The cleanup is not done. New duplicates will appear every week from the same five sources you just identified.

Set these recurring habits:

• Weekly: scan for new duplicate candidates from the past 7 days. Both Housecall Pro's manage-duplicates view and ServiceTitan's duplicate report can be checked in 10 minutes
• Train the CSR script: search the customer list before creating any new record, ask for spelling, ask for the phone number first
• Monthly: re-run a phone match across the whole database to catch dupes that slipped past the weekly scan

The Validity 2025 report found that workers spend 13 hours per week hunting for basic information in their CRM. A weekly 10-minute dedupe scan saves several hours of that, every week, forever.

What This Makes Possible

A clean customer database makes the questions no dashboard will answer suddenly answerable. Real lifetime value. Real reactivation pools. Real revenue per source.

Tommy Mello scaled A1 Garage Door to $220M+ on a ServiceTitan database he treats as a strategic asset. The discipline starts with deduplication and never stops.

Sources

• Validity, State of CRM Data Management 2025
• Housecall Pro Help Center, Manage and Merge Duplicate Customers
• ServiceTitan Help, Merge and Unmerge Duplicate Customer and Location Records
• ServiceTitan Help, Duplicate Customer and Location Reports
• Jobber Community Forum, Duplicates Merge Discussion
• Jobber Community Forum, Preventing Duplicate Records on QuickBooks Sync
• ValiantCEO interview with Tommy Mello, A1 Garage Door Service
• Insycle, Ultimate CRM Data Cleanup Checklist