How to Switch HVAC Software Without Losing Your Job History

DEFINITION

Data Migration

The process of moving customer records, job history, invoices, and other business data from one software system to another. For small HVAC shops, migration typically involves exporting CSV files from the old system and importing them into the new one.

DEFINITION

Parallel Operation

Running two software systems simultaneously during a transition period — new jobs go into the new system while the old system remains accessible for reference. Running in parallel for 2-4 weeks catches migration gaps before fully committing to the new platform.

DEFINITION

CSV Export

A comma-separated values file download of your data — customers, jobs, invoices — that most software platforms provide. CSV files can be opened in Excel or Google Sheets, cleaned up, and imported into a new platform. The universal format for moving business data between systems.

Why Contractors Stay on Bad Software

The number-one reason HVAC shop owners stay on software they don’t like is fear of losing job history. Years of customer records, equipment notes, warranty dates, job photos, and invoice history feel irreplaceable. And the software companies know this. Lock-in is a feature, not a bug.

About 37% of small HVAC firms report data migration issues as a barrier to switching platforms. That number sounds high until you realize most of those problems come from not having a plan, not from the actual migration being difficult.

We built CrewRoute with easy data import because we kept hearing this from shop owners: “I’d switch, but I can’t lose my records.” You shouldn’t have to stay with software you hate because you’re afraid of losing your data.

Step 1: Export Everything Before You Cancel

This is the most important step, and the one most people skip. Export your data while you still have full access to your current platform.

Here’s what to export:

Customer list: Names, addresses, phone numbers, email addresses, property details. Every platform has this as a CSV export.

Job history: Completed jobs with dates, descriptions, parts used, and totals. This is usually available through the reporting section.

Invoices: Open invoices, paid invoices, and any outstanding balances. Export as CSV or PDF.

Equipment records: If you track installed equipment (model numbers, serial numbers, install dates, warranty info), export this separately. Not every platform includes it in the standard export.

Notes and photos: This is the hardest to export. Most platforms don’t include tech notes or job photos in CSV exports. If you have critical notes (warranty details, access codes, system quirks), you may need to pull these manually for your most active customers.

Do all of this before you cancel, downgrade, or even tell your current vendor you’re leaving. Some platforms restrict export access on canceled accounts. Get your data out first.

Step 2: Decide What Actually Needs to Migrate

Here’s where most people overcomplicate things. You don’t need to import 10 years of job history into your new system. You need two things:

1. Active customer records (anyone you’ve served in the last 12-24 months)
2. Open items (unpaid invoices, pending estimates, scheduled jobs)

Everything else is reference material. Keep it in your exported CSV files, organized in a Google Drive folder. If a customer from 2019 calls, you can look them up in the CSV. You don’t need them cluttering your new dispatch board.

For most 1-5 truck shops, this means migrating 200-500 active customers instead of 3,000+ total records. That’s a manageable afternoon project, not a multi-week migration.

Step 3: Clean Your Data Before Importing

Your exported data is going to be messy. Guaranteed. You’ll find:

• Duplicate customer entries (same person listed three different ways)
• Old addresses from customers who moved
• Phone numbers that are disconnected
• Test entries from when you first set up the system
• Incomplete records with just a first name and no contact info

Spend an hour in Excel or Google Sheets cleaning this up. Sort by last service date and delete anyone you haven’t served in 24+ months (they’re in your archive CSV if you need them). Merge duplicates. Fix obvious errors.

Importing clean data into a new system means your dispatch board and customer list are accurate from day one. Importing dirty data means you’re dealing with the same mess in a new interface.

Step 4: Import Into Your New System

The import process depends on your new platform:

CSV import (most common): Housecall Pro, Jobber, and most modern platforms accept CSV files for customer import. Map your columns (name, address, phone, email) to their fields, upload, and you’re done. Customer data imports in minutes.

Job history import: This varies. Some platforms import job history from CSV. Others only accept customer records and require you to enter jobs going forward. Ask your new vendor specifically: “Can I import job history from a CSV?”

Manual entry: If your new platform doesn’t support import, or your data is too messy for automated import, manually enter your top 50-100 active customers. At 2-3 minutes per customer, that’s 2-4 hours. It’s tedious but thorough, and you end up with clean records.

Vendor-assisted migration: Some platforms offer migration help as part of onboarding. Housecall Pro has a data import team. Jobber walks you through CSV mapping. ServiceTitan charges $5,000-$50,000 for implementation that includes migration, though that’s overkill for a small shop.

Step 5: Run Both Systems in Parallel

Don’t flip the switch overnight. Run your old system and new system simultaneously for 2-4 weeks.

Here’s how parallel operation works:

• All new jobs go into the new system
• When a returning customer calls, check both systems for their history
• If you find records in the old system that should be in the new one, add them
• Your techs use the new system in the field, but can reference the old one for past job details

This catches gaps. Maybe you forgot to import a customer segment. Maybe the equipment records didn’t transfer correctly. Running in parallel gives you a safety net without risking a hard cutover that leaves you scrambling.

Step 6: Keep Old System Access for 90 Days

After your parallel period, stop using the old system for new work. But don’t cancel it yet.

Downgrade to the cheapest available tier. Many platforms have a “view-only” or basic tier that costs $10-$30/month. This gives you access to look up old job notes, check warranty dates, and reference past invoices without paying full price.

Keep this access for at least 90 days after full cutover. Here’s why: a customer will call in month two about a repair you did eight months ago, and you’ll need to look up what part you installed. That information is in the old system. It’s worth $30/month to have that reference available while you build history in the new system.

Step 7: Cut Over Completely

After 90 days, check: have you logged into the old system in the last 30 days? If not, cancel it. Your CSV exports serve as your permanent archive. You can search them anytime.

If you’re still referencing the old system regularly after 90 days, either your migration missed important data or your new system is missing features you need. Both are worth investigating rather than paying two software subscriptions indefinitely.

Common Migration Mistakes

Mistake 1: Canceling before exporting. Once you cancel, some platforms lock you out or delete your data after 30-60 days. Always export first.

Mistake 2: Trying to migrate everything. You don’t need 10 years of history in the new system. Migrate what’s active, archive the rest.

Mistake 3: Switching during peak season. Migrate in your slow months (spring or fall for HVAC). Don’t add a software transition to your July workload.

Mistake 4: Not training techs. The new software only works if your techs actually use it. Spend 30 minutes walking them through the mobile app before go-live. If they can dispatch, invoice, and collect payment on day one, the rest they’ll learn as they go.

Making the Switch Easier

We designed CrewRoute for shops making exactly this switch, usually away from ServiceTitan or another platform that got too expensive or too complicated. Our CSV import pulls in your customer list, and you can be dispatching on CrewRoute the same day. $149/month flat, no setup fees, no annual contract. If it doesn’t work, you cancel. No data hostage situations.

But regardless of what you switch to, the process is the same: export first, clean your data, import what matters, run parallel, and cut over when you’re confident. It’s a weekend project, not a six-month implementation.