Pool Service Route Tracker Spreadsheet | Route Board, Chemical Log and Monthly Billing for Pool Cleaners — Google Sheets

Can a substitute tech run your route cold?

That's the real test of a pool service business — and the reason most route notebooks and whiteboards fail it. This tracker puts the whole route on one board: every stop grouped by weekday, in stop order, with each pool's last chlorine and pH readings already showing. Hand it to a sub, a new hire, or just your future self, and the day runs itself.

Log each visit's readings and doses in the Chemical Log, and the Route Board updates on its own. Monthly billing per stop rolls up automatically on the Dashboard, next to your chemical spend and the extra work you've billed — so you always know what the route actually made.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

WHAT'S INSIDE — 6 focused tabs, not a 30-tab kit:

- Start Here — a plain-English guide and quick-start steps

- Clients & Stops — every customer: address, route day, monthly rate, gate and alarm notes, a dogs flag, and status (Active or Paused)

- Route Board — the route-day board: stops grouped by weekday in run order, a Done checkbox for each stop, issues and notes, and the last chlorine and pH at every pool, pulled in automatically from your log

- Chemical Log — one row per visit: date, stop, chlorine (ppm) and pH readings, what you dosed, and what the chemicals cost

- Repairs & Extras — extra work with quoted amount, Done and Billed checkboxes; work that's done but not yet billed is flagged on the Dashboard so it never slips

- Dashboard — the month at a glance: monthly recurring revenue, stops per route day, chemical spend, visits logged, extras billed, and total revenue

HOW IT WORKS

1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.

2. Add your stops once: route day, monthly rate, gate notes, dogs. The Route Board builds itself from your list.

3. Run the day from the Route Board, tick stops off as you go, and log each visit's readings in the Chemical Log. Billing and spend roll up on the Dashboard.

WHY THIS ONE

Most pool trackers are log-first: endless visit rows, and the route itself — the sequencing, the gate codes, the dog in the yard, what the water looked like last week — lives in your head. This one is route-first. It comes loaded with a fictional sample route (12 stops across five days, one paused for the season) so you can see every formula working before you replace the samples with your own route.

A FINISHED FILE, DELIVERED INSTANTLY

You receive the finished spreadsheet file exactly as shown — open it, add your own jobs and customers, and use it right away. It is a complete digital file delivered to you, not a service and not a setup project. Nothing about the file is customized, personalized or built to order. If you ever find a genuine error in a formula or a number, tell us and we will send you a corrected copy of the file, free, forever.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works in the office, in the truck, and on your phone at the pool gate.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.