SolarCleaningBossPro Blog — Routes & Scheduling

Moving Solar Cleaning Scheduling Off Paper, Whiteboards and Spreadsheets

Most solar cleaning companies start on paper. A notebook of customers, a whiteboard for the week, a spreadsheet of last cleaning dates, gate codes in a group text. It works for the first fifty customers. Somewhere after that, customers start falling through the cracks, and the owner spends evenings reconciling three lists that disagree. Moving off paper is less work than it looks, if you do it in the right order.

Owner-Operators Feel It First

The one-phone setup described in The Owner-Operator Solar Cleaning Schedule: Cleaning, Routing and Booking From One Phone is often the first thing an owner tries after giving up on paper. This guide is the step-by-step move, whether you have one truck or three.

Step 1: Bring In the Customer List

Start with what you have. If your customers are in a spreadsheet, use CSV import to bring them in. The addresses are placed on the map automatically, so the Waiting List map is useful from the first day. If they are in a notebook, type in the regulars first and add the rest over the next few weeks.

One client can have many addresses, which matters for landlords and commercial owners. Tags like Residential, Commercial and Twice a Year help sort them, and custom fields can hold anything else you track.

Step 2: Add Panel Details and Access Notes

This is the step that pays off the most. For each customer, enter the panel details: number of panels, mount, roof stories, pitch and extras. Then the access notes: spigot location, roof access side, gate code and dog. Pull the gate codes out of the group text while you are at it.

You do not have to finish this in one sitting. Many owners fill in details as each customer comes due, so the list is complete after one full cycle of cleanings. Once entered, the details show on every visit after.

Step 3: Put Regulars on Plans

Set each recurring customer on a plan with the right minimum days between visits: 180 for twice a year, 365 for yearly, 90 for quarterly commercial arrays. Keep your old spreadsheet handy while you do it, so you know which customers are already overdue and which were cleaned recently. The overdue ones are the first routes to build.

One-time customers do not need a plan. Book them as single jobs, and if they like the result, move them onto a plan after the cleaning.

From here on, nobody needs to check the spreadsheet to see who is due. The Waiting List map shows it, colored not due yet, due now and overdue.

Step 4: Build the First Routes

Pick a week and build it from the map. Group due pins by area, assign them to a truck and a day, and auto-route Closest First or Furthest First from the shop. Adjust the order by hand for steep roofs and time requests. The first week may take longer than the whiteboard did. By the second week it will be faster, and by the fourth you will not want the whiteboard back.

The full approach is in Solar Cleaning Route Scheduling: The Complete Guide to Planning Days, Trucks and Routes.

Step 5: Move the Crew Over

Give each tech a personal PIN and a truck. They open the tech app in the browser on their own phone, log in with the company login and their PIN, and see their stops in route order with navigation, panel details and access notes. Teach the three buttons, Start, Skip and Complete, and the habit of writing a note when something on the card is wrong.

Run paper and the app side by side for a few days if it helps the crew feel safe, then drop the paper. Once the crew sees the gate code and spigot location on the card, they rarely ask for the printed sheet again.

Step 6: Turn On Customer Texts

Once routes are being built in the app, turn on the customer side. Customers choose night-before, when-they're-next and arrived alerts. On-the-way and arrived texts go out automatically as techs work the route, and replies come to the office through two-way texting. The customer app gives them the live route map, invoices and online payment.

What You Leave Behind

The whiteboard that got wiped. The spreadsheet nobody updated. The group text full of old codes. The customer who was due in March and never got a call. For the rest of the routing tools, see the SolarCleaningBossPro solar cleaning route software page.