WindowBossPro Blog — Storefronts & Commercial

Moving Commercial Window Cleaning Accounts Off Spreadsheets and Into One System

Most storefront routes start in a spreadsheet. A row per business, a column for the address, a column for the price, maybe a column for “last cleaned” that stopped being updated in March. It works for ten accounts. By thirty, the spreadsheet is a liability: nobody trusts the dates, notes are scattered and billing takes an evening every month.

Signs the Spreadsheet Has Run Its Course

Late payments, covered in Collecting From Commercial Window Cleaning Accounts That Pay Late, are often a symptom of the same problem. When billing lives in a spreadsheet, invoices go out late and follow-up depends on memory. Other signs:

• Storefronts missed because nobody noticed they were due
• Gate codes and alarm codes in a separate text thread
• A property manager getting separate invoices for each building
• Only the owner knows the route order
• Copies of the sheet on three phones, none matching

Step 1: Clean Up the List

Before importing anything, spend an hour on the spreadsheet. Remove accounts that are no longer active. Fix addresses that are incomplete. Make sure every row has a contact name, phone number and email if you have one.

Most importantly, look for rows that belong to the same payer. Three rows for three buildings managed by the same property company should become one client with three addresses. Mark those groups now, because it is much easier than merging records later. For why this matters, see One Account, Many Addresses: How Commercial Window Cleaning Clients Are Set Up.

Step 2: Import With a CSV

WindowBossPro supports CSV import of clients and addresses. Save the cleaned spreadsheet as a CSV and import it. Every imported address is placed on the map automatically, so your storefronts show up on the Waiting List map and in route planning without anyone typing in coordinates.

If you are coming from generic field-service software rather than a spreadsheet, the same applies. Export your clients and addresses to a CSV, import them, and every address lands on the map.

Step 3: Add the Window Details

A spreadsheet rarely has the details a tech needs. After the import, go through the commercial addresses and fill in:

• Number of windows
• Stories: 1-story, 2-story or 3+ story
• Sides: outside only, inside and outside, or inside only
• Extras: screens, tracks, hard-water removal
• Access notes: back doors, keys, alarm codes, opening times, parking

This is the moment to pull those codes out of the group text and onto the addresses where they belong, behind each tech's PIN.

Step 4: Set the Cycles

Give each address its recurring service with the right minimum days between visits: 14 for every two weeks, 30 for monthly, and so on. Use your best record of the last cleaning date as the starting point. If you are not sure, it is fine to let a storefront come due a little early the first time.

From then on, each storefront comes due on the Waiting List on its own, and the “last cleaned” column is gone for good.

Step 5: Tags, Fields and Billing

Tag commercial clients Storefront or Commercial. Move spreadsheet columns like PO number or manager name into custom fields. Then set billing for each account: card on file for single storefronts, Monthly for property managers and multi-location clients.

Add your employees with their PINs and van assignments, and the storefront tech can log in on the phone and see their first route.

Run Both for a Couple of Weeks

Keep the old spreadsheet for a couple of weeks while the first cycles run through the new system. Compare the Waiting List against what you expected to be due. Ask the tech whether the access notes are complete. Fix what is missing. After one full cycle, most companies stop opening the spreadsheet altogether.

Common Import Mistakes

• One client per building. Group locations under the paying client before you import, not after.
• Missing suite numbers. “410 Pine St” is not enough when there are eight units. Include the unit so the tech finds the right door.
• Old prices. If a storefront's price changed last year and the sheet never caught up, fix it now.
• Codes left behind. Move every access code into the address notes and then delete the old text thread.

One System Instead of One Spreadsheet

Moving commercial accounts off a spreadsheet takes an afternoon of cleanup and a couple of weeks of checking. After that, cycles, notes, routes and billing all live in one place. For the full commercial setup, visit the WindowBossPro commercial window cleaning software page.