{"product_id":"pool-service-route-tracker-spreadsheet-route-board-chemical-log-and-monthly-billing-for-pool-cleaners-google-sheets","title":"Pool Service Route Tracker Spreadsheet | Route Board, Chemical Log and Monthly Billing for Pool Cleaners — Google Sheets","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.\u003c\/p\u003e\u003cp\u003eCan a substitute tech run your route cold?\u003c\/p\u003e\n\u003cp\u003eThat'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.\u003c\/p\u003e\n\u003cp\u003eLog 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.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT'S INSIDE — 6 focused tabs, not a 30-tab kit:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- \u003cstrong\u003eStart Here\u003c\/strong\u003e — a plain-English guide and quick-start steps\u003cbr\u003e- \u003cstrong\u003eClients \u0026amp; Stops\u003c\/strong\u003e — every customer: address, route day, monthly rate, gate and alarm notes, a dogs flag, and status (Active or Paused)\u003cbr\u003e- \u003cstrong\u003eRoute Board\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eChemical Log\u003c\/strong\u003e — one row per visit: date, stop, chlorine (ppm) and pH readings, what you dosed, and what the chemicals cost\u003cbr\u003e- \u003cstrong\u003eRepairs \u0026amp; Extras\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eDashboard\u003c\/strong\u003e — the month at a glance: monthly recurring revenue, stops per route day, chemical spend, visits logged, extras billed, and total revenue\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003cbr\u003e1. After checkout you get a PDF with your private link. Click it and choose \"Make a copy\" — the tracker is yours.\u003cbr\u003e2. Add your stops once: route day, monthly rate, gate notes, dogs. The Route Board builds itself from your list.\u003cbr\u003e3. 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHY THIS ONE\u003c\/strong\u003e\u003cbr\u003eMost 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.\u003c\/p\u003e\n\u003cp\u003eFINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eREQUIREMENTS:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68083116998941,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_9401e666-d779-40ea-af7e-4f5ac3cf3bea.jpg?v=1794696730","url":"https:\/\/inksheetstudio.com\/products\/pool-service-route-tracker-spreadsheet-route-board-chemical-log-and-monthly-billing-for-pool-cleaners-google-sheets","provider":"InkSheet Studio","version":"1.0","type":"link"}