A flat $150 a month sounds fine until a pool takes 40 minutes, eats $12 of chlorine a week and sits across town. This calculator works out visits per month, hours on site, chemicals, driving and overhead, then prices the pool at your target margin with your minimum. One-time jobs like green-to-clean and filter cleans go on the same quote.
Nothing hidden here. You can read how a pool's monthly price is figured right now, tab by tab. Pair it with our pool chemical dosing calculator and both sides of the job are covered.
What the Pool Service Quote Calculator does
- Weekly or every-2-weeks service, priced from minutes on site and chemical cost per visit
- Overhead and equipment spread over your billable hours
- Monthly price at your target margin, raised to your minimum and rounded
- Price per visit, profit, margin and what you earn per hour on site
- One-time services from your own Service Menu, hourly or flat, with parts markup
- Printable customer quote with the monthly service, one-time jobs and first month total
What's inside
7 tabs: Start Here, Dashboard, Quote, Customer Quote, Service Menu, Lists, Settings.
Who it's for
Owner-run pool routes that want every pool priced to pay, not priced to match the last guy.
What you get
Two spreadsheet files (.xlsx): one filled with examples so you can see exactly how it works, and a blank copy ready for your business. For Microsoft Excel and Google Sheets. No macros, no subscription.
The formulas are locked, so a stray keystroke can't break them. You only type in the yellow cells.
What you need to use it
- Microsoft Excel 2010 or newer, on Windows or Mac, including Microsoft 365
- Or Google Sheets in any web browser, free with a Google account
- A laptop or desktop works best for setup. Phones and tablets are fine for checking numbers and quick entries.
- No macros, add-ins or internet connection needed once it's downloaded. Apple Numbers isn't supported.
Questions
Where does chemical cost per visit come from?
Use a normal week from the Pool Chemical Dosing Calculator, or your own average. Quote green-pool rescues as a one-time service.
Can I set a minimum?
Yes. Set a minimum monthly price on Settings so small pools and spas still pay for the stop.
Is there a blank version?
Yes. Every download has two files: one filled with examples so you can see how everything works, and a blank copy ready for your own business. Your rates and settings come filled in as a starting point, so change them to match yours.
Can I change the formulas?
The gray formula cells are locked so they can't be erased by accident. If you really want to change one, open Review in Excel and choose Unprotect Sheet. There's no password.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The math works the same. Locks don't carry over, so just type in the yellow cells.
How do Free Lifetime Updates work?
Whenever we release a new version, you can download it free from your account, forever. We'll email you when there's something new.
