Moving Window Cleaning Scheduling Off Paper, Whiteboards and Spreadsheets
Most window cleaning companies start the same way: a paper calendar, a notebook of addresses, maybe a spreadsheet of quarterly customers and a whiteboard in the garage. It works for a while. Then a page gets wet, a customer falls off the spreadsheet, or a second person needs to see the schedule from somewhere other than the garage. That is usually when owners start looking for something better.
When Paper Stops Working
The last article, Adding a Second Van: Splitting Window Cleaning Routes Between Two Crews, covered the step that breaks most paper systems. With one van, the owner carries the schedule in their head. With two, the schedule has to live somewhere both crews and the office can see it.
Other signs are familiar. Quarterly customers who call to ask why you have not been out. Gate codes in a group text nobody can search. A route sheet that was wrong by 9 a.m. The office calling a tech on a ladder to ask where they are.
Step 1: Get the Clients In
Start with a list of clients and addresses. If you have a spreadsheet, export it to CSV and use the CSV import in WindowBossPro. One client can have many addresses, which matters for property managers and businesses with several storefronts.
Addresses on the map are what make the Waiting List and routing work, so after the import, check that each one landed in the right spot. If your list is on paper, typing it in is a good winter project, and a chance to clean out customers you have not seen in years.
Step 2: Add Window Details and Access Notes
This is the part paper never held well. For each address, record the number of windows, stories, sides and extras like screens, tracks and hard-water removal. Add access notes: gate code, dog, where to set the ladder, skylights.
You do not have to do every address before you start. Do the ones coming due in the next few weeks, then fill in the rest as crews visit them. Techs can note anything missing, and the office updates the address.
Step 3: Set the Recurring Plans
Give each recurring customer a plan with minimum days between visits: 14 or 30 for storefronts, 90 or 180 for homes. Get the timing right from the start: a customer you cleaned last month should not show up as due tomorrow.
Once plans are in, the Waiting List fills on its own. Customers who are due show as due now. Those more than seven days past due show as overdue. For many owners, this is the first time they see exactly how many customers are overdue, and it is usually more than they thought. 14, 30, 90 or 180 Days: Setting Recurring Window Cleaning Schedules covers choosing intervals.
Step 4: Run Both for a Week
Do not throw out the whiteboard on day one. For the first week or two, build routes in WindowBossPro and keep your old system as a backup. Assign due jobs to each van and day, auto-route Closest First or Furthest First from the shop, set order by hand where needed, and compare the result to what you would have done on paper.
Most owners find the new route is as good or better within a few days, and the paper quietly stops getting updated.
Step 5: Put the Crew on Their Phones
The tech app runs in the browser on iPhone and Android and can be installed to the home screen. Each tech gets a personal PIN and logs in with the company login. They see their day in route order with a navigation button, the window details and access notes, and they tap Start, Skip or Complete.
Training is usually a single morning. The first time a tech sees the gate code on the card instead of in a text thread, they get it. Customers start getting automatic on-the-way and arrived texts at the same time, which is often the first change they notice.
What You Give Up and What You Get
You give up the comfort of a system you know. You get a schedule that builds itself from customers' plans, a map of what is due, routes in order on every phone, customer texts that go out on their own, and invoices created when jobs are completed. You also get a schedule that someone else can run when you are on a ladder, on vacation or out sick.
Off Paper, On the Map
Moving off paper is a few evenings of setup and a week of running both systems. After that, the whiteboard becomes a place to write the coffee order. For the tools that replace it, see the WindowBossPro window cleaning route software page.
Retire the Whiteboard
WindowBossPro imports your clients, puts every address on the map and builds your schedule from each customer's plan.
Start Free Trial