PoolBossPro Blog — Pool Cleaning Software

← More on Pool Cleaning Software

Moving Your Customer List Into Pool Cleaning Software Without Losing Data

Your customer list is the most valuable thing your pool service owns. Every address, gate code, pool size, and last chlorine reading represents years of route knowledge that lives in a spreadsheet, a billing app, or your head. The fear of losing that data is the number one reason owners put off switching to real pool cleaning software. The good news is that a clean import is mostly about preparation, not luck. Done right, you move every recurring stop, pool profile, and balance owed into PoolBossPro without a single account falling through the cracks.

Start With a Clean Export From Wherever You Are Now

Before you import anything, you have to export it. Most pool techs are coming from one of three places: a spreadsheet, an old billing tool like QuickBooks, or sticky notes and memory. If you are on a spreadsheet, you are already most of the way there — you just need to get the columns in order. If you are exporting from another app, look for a "customers" or "contacts" CSV export. Pull that file down and open it before you touch PoolBossPro. The goal at this stage is simply to see everything in one place so you can spot the gaps: missing phone numbers, accounts with no service address, or duplicates where one pool got entered twice.

Get Your Columns Right: Customer, Property, and Pool

Pool service data has three layers, and mixing them up is where most messy imports go wrong. The first layer is the customer — a name, a phone number for texts, an email for invoices, and a billing address. The second is the property where you actually do the work, which may differ from the billing address for snowbirds, rentals, or property managers. The third is the pool itself: type (in-ground gunite, vinyl liner, fiberglass, above-ground), size in gallons, and the equipment on it. PoolBossPro keeps these as linked records, so one customer can own two homes and each home can carry its own pool profile. When you prep your spreadsheet, give each of those a clear column. A row that crams "Smith, 20k gal, Hayward pump" into one cell will not map cleanly, and you will spend your first week untangling it instead of running stops.

Bring Over Pool Profiles and Equipment, Not Just Addresses

A lot of owners import names and addresses and call it done. That is a missed opportunity. The details that make a route profitable — pool gallons, the filter type, the chlorinator model, the gate code, the dog in the backyard — are exactly the notes a new tech needs on day one. Map those into the pool and property profile fields during import so they travel with the account. When a crew member opens a stop in PoolBossPro, they should see the same context you carry in your head: this is a 25,000-gallon plaster pool on a salt system with a cartridge filter, and the customer wants a text before arrival. That context is what lets you hand a route to someone else without riding along.

Decide What Water Chemistry History to Carry Forward

Here is the honest part: you usually cannot import a full season of chlorine, pH, alkalinity, cyanuric, salt, and phosphate readings from a spreadsheet in a clean way, because most older tools never logged them consistently in the first place. That is fine. The water chemistry logging in PoolBossPro starts paying off the moment your first service is recorded, building a trend line per pool from there forward. What you should carry over is the baseline: the pool's typical chlorine and stabilizer targets, any chronic issue like high cyanuric or a phosphate problem, and notes on a green-to-clean recovery you fought through last summer. Drop those into the pool profile as starting notes so nothing institutional gets lost, then let the software build the real chemistry history going forward.

Reconcile Balances and Card-on-File Before You Cut Over

The riskiest data to move is money. If a customer owes you for two missed visits, or pays monthly by card on file, that has to land correctly or you will be chasing it for weeks. Treat billing as its own import pass. Bring in each account's recurring price and service frequency so invoicing and the route schedule line up from day one. For card-on-file customers, you will re-collect their payment details inside PoolBossPro — you should never move raw card numbers between systems, and the software is built to capture them securely so billing keeps running without a gap. Set a clean cutover date: run your old billing through the end of a billing cycle, then start the next cycle entirely inside PoolBossPro so no invoice gets sent twice.

Verify Against the Map, Then Go Live

Once the import is in, do not trust the count — trust the map. Open your stops on the routing view and look for accounts sitting in the wrong town, addresses that failed to geocode, or a recurring weekly pool that somehow landed as a one-time job. Fixing ten misplaced pins now is far cheaper than a tech driving 40 minutes to a green pool that was never on the right route day. Spot-check a handful of accounts end to end: customer texts enabled, pool profile filled, price set, next service scheduled. When those line up, you are live. For a full walkthrough of those first days, see Your First Week on Pool Cleaning Software: A Setup Roadmap, and if you are still comparing options, the overview of pool cleaning software covers what to look for before you commit.