Log every chemical purchase. See cost per unit and monthly spending trends.
Free spreadsheet to log chemical purchases, track cost per unit, and see monthly spending trends.
Free. Just enter your email.
Log every purchase with date, chemical, vendor, quantity, total cost, and auto-calculated cost per unit.
Monthly spending totals by chemical type with cost per pool calculations.
Chemical costs represent one of the largest variable expenses in pool service, typically accounting for 15-25% of service revenue. Without systematic tracking, most operators significantly underestimate chemical spending and miss opportunities to reduce costs through vendor comparison and bulk purchasing.
For each purchase, record the date, chemical type, brand/product name, vendor, quantity, unit of measure, and total cost. The spreadsheet auto-calculates cost per unit (per pound, per gallon), enabling direct comparison between vendors and products over time.
Tracking cost per unit over time reveals pricing trends that aren't visible from individual receipts. Liquid chlorine costs have fluctuated 40-60% over the past three years. Trichlor tabs peaked at $6-8/pound during the 2021-2022 shortage and have since normalized to $3-4/pound. Monitoring these trends allows you to stock up during price dips and adjust service pricing when costs increase.
The Monthly Summary sheet breaks spending into categories: chlorine, acid, tabs, and other chemicals. Monthly totals and cost-per-pool calculations reveal seasonal patterns — summer chemical costs are typically 2-3x winter costs in most markets. This data supports accurate pricing and helps identify months where chemical costs may exceed what your service rates cover.
This spreadsheet was built to solve these exact problems.
You have no idea what you spend on chemicals per month. It's probably more than you think.
Your supplier raised prices 15% and you didn't notice for three months. That's money lost.
You've been buying from the same supplier for years but never compared prices. You might be overpaying.
You can't set profitable prices because you don't know your true chemical cost per stop.
This spreadsheet fixes all of it. Free.
When spreadsheets stop scaling, PoolDial picks up where they leave off.
Start Free Trial