Pressure Washing Business Spreadsheet: Quote, Track Jobs and See Real Profit
You have the rig, the surface cleaner and a phone that keeps ringing every spring. What you probably do not have is one place that tells you what to charge for the next house, which jobs are still unpaid, and whether last month actually made money after chemicals, fuel and the helper. A pressure washing business spreadsheet does exactly that: it turns measurements into a quote, follows each job from booked to paid, and rolls every dollar in and out into a profit figure you can trust.
This guide shows the tabs a pressure washing (or soft wash, or mobile detailing) business needs, walks through a complete worked quote with real arithmetic, shows how to check the profit on that job after costs, and gives you a copy-ready layout you can build yourself in Excel or Google Sheets.
All figures below are worked examples with stated assumptions, not market averages. Rates vary a lot by region, surface and competition. Use your own numbers.
Why pressure washing businesses lose track of money
Most exterior cleaning businesses start the same way: a machine, a truck, word of mouth, and a notes app full of addresses. It works until about the second season, when three things start to happen at once.
- Quotes drift. You priced the last ranch house at $300 from the curb, the next one at $275 because the client pushed, and you no longer know what your actual rate per square foot is.
- Money goes missing in the gaps. A roof wash gets a deposit, the balance is “due on completion,” and nobody chases it because the next job is already loaded.
- Profit is a guess. Revenue is easy to see in the bank account. Chemicals, fuel, the replacement surface cleaner and the helper’s six hours are scattered across receipts, so the true margin is unknown until tax time.
The fix is not complicated software. It is a handful of linked tabs where each number is entered once and used everywhere.
The 8 tabs a pressure washing business spreadsheet needs
1. Settings
Enter the numbers that drive everything else once: your hourly labor rate, target markup, default price per square foot, trip charge, mileage rate and the share of profit you set aside for tax. Change a setting and every quote and report follows.
2. Service menu
Your standard services and how each is priced. Exterior cleaning uses three pricing bases:
| Pricing basis | Typical services | Unit |
|---|---|---|
| Per square foot | House soft wash, driveways, patios, decks, roofs | sq ft |
| Per linear foot | Gutter brightening, fences | lin ft |
| Per item / flat | Windows, single vehicles, full details, fleet units | each |
Each service also gets an estimated time, because time is what turns a price into an hourly rate. Without it you cannot tell a good job from a busy one. For a full walk-through of setting your per-square-foot numbers, see how much to charge for pressure washing per square foot.
3. Quote builder
Pick services, enter quantities, and the sheet returns a line total for each, a services subtotal, estimated labor hours, the trip charge and the quote total. Most importantly it returns effective dollars per labor hour, the one number that tells you whether the quote is worth taking.
4. Job tracker
Every booking on one row: date, client, service, address, status (Quoted, Booked, Done, Paid), quoted amount, amount paid, balance, payment method and mileage. Filter by status and you instantly see open quotes to follow up and finished jobs still owing money.
5. Client list with re-book reminders
Exterior cleaning is a repeat business. A house wash is often annual, driveways and storefronts quarterly, fleet washes every week or two. Record each client’s frequency and last service date and the sheet calculates the next due date and flags who is due now. That column is your spring marketing list.
6. Income and expenses
Every payment in and every cost out, tagged by category: job revenue, chemicals, fuel, equipment, labor, insurance, marketing. A month column lets the dashboard total each month automatically.
7. Equipment log
Your pressure washer, surface cleaner, soft wash system and truck, each with purchase cost, current run hours and a service interval. The sheet calculates when the next service is due, so a pump does not fail on a Saturday because nobody changed the oil.
8. Mileage log and dashboard
Every business trip with start and end odometer readings, turned into miles and a deduction value at the rate you set. The dashboard then pulls everything together: total revenue, expenses, net profit, jobs completed, outstanding balances, a tax set-aside, profit margin, mileage deduction and average job value.
Worked example: quoting a house wash, driveway and gutters
Here is a full quote built line by line. All rates are example inputs.
The job: a two-story house with about 1,800 sq ft of siding, a 600 sq ft driveway and 150 linear feet of gutters. The property is 9 miles from your shop (18 miles round trip).
Your settings (assumptions): trip charge $25, mileage rate $0.70 per mile, target markup 40%.
| Line | Rate | Qty | Line total | Est. hours |
|---|---|---|---|---|
| House soft wash | $0.18 / sq ft | 1,800 | $324.00 | 2.5 |
| Driveway (surface cleaner) | $0.15 / sq ft | 600 | $90.00 | 1.5 |
| Gutter brightening | $1.25 / lin ft | 150 | $187.50 | 1.5 |
| Services subtotal | $601.50 | 5.5 |
Now the additions:
- Travel: $25 trip charge + (18 miles × $0.70) = $25 + $12.60 = $37.60
- Markup: 40% × $601.50 = $240.60
- Quote total: $601.50 + $37.60 + $240.60 = $879.70
Finally, the test that matters:
- Effective rate per labor hour: $879.70 ÷ 5.5 hours = $159.95 per hour
That hourly figure is what you compare against your target. If your target is $120 an hour after you have accounted for costs, this quote clears it comfortably and you have room to round to $875 if the client asks for a deal. If the same arithmetic came out at $85 an hour, you would know before you sent the price that the job is underpriced, not after you have spent a Saturday on it.
Checking the profit on that job
Price is not profit. Here is the same job with its direct costs (all assumptions, use your own):
| Cost | How it is worked out | Amount |
|---|---|---|
| Chemicals | Soft wash mix for siding plus degreaser for the drive | $38.00 |
| Fuel | Truck round trip plus pump engine for 5.5 hours | $22.00 |
| Helper | 5.5 hours × $20 | $110.00 |
| Equipment wear | 5.5 run hours × $1.50 per hour set aside for repairs and replacement | $8.25 |
| Direct cost | $178.25 |
Job profit before overhead: $879.70 − $178.25 = $701.45, a margin of about 80% on direct costs.
That looks generous until you remember the costs that do not belong to any single job: insurance, marketing, phone, software, the truck payment and slow winter months. Those are paid from the profit on jobs like this one. The point of the spreadsheet is that you see both sides: the per-job margin in the quote, and the overhead in your monthly expense totals. We work through a full month, overhead included, in is a pressure washing business profitable?
Measuring before you quote
A per-square-foot price is only as good as the measurement behind it. Three quick methods cover most residential jobs:
- Siding: walk the perimeter (or use the footprint from a map tool) and multiply by wall height. A 40 × 30 ft footprint has a 140 ft perimeter; at an 18 ft two-story wall height that is 2,520 sq ft before you subtract large windows and garage doors, and before you add gable triangles (base × height ÷ 2 for each).
- Flatwork: length × width for each rectangle. A two-car driveway of 20 × 24 ft is 480 sq ft; add walkways and the patio separately.
- Gutters: run the roof edge. On a simple rectangular house the gutter length is roughly the two long sides plus any short sides that carry gutters.
Write the measurements into the quote line, not on a scrap of paper. Next year, when the client re-books, the square footage is already there.
Pricing models: per square foot, hourly, or flat
There is no single correct model; most successful operators combine them.
- Per square foot scales with the job and is easy for clients to understand. Its weakness is that tiny jobs come out too cheap, which is why you also need a minimum job charge.
- Hourly protects you on difficult or unpredictable work (heavy rust stains, oil spots, multi-level decks) but clients dislike open-ended prices.
- Flat package suits repeatable services like a standard driveway, a vehicle detail or a fleet unit. You learn your times, then sell the outcome.
Whichever you use, run every quote back through the same test: total ÷ hours = effective hourly rate. That single column catches more pricing mistakes than anything else. We list the most common ones, with fixes, in pressure washing estimate mistakes that cost you profit.
If you also do mobile detailing
Many exterior cleaning businesses add vehicle detailing, either as a separate service line or a fleet contract for a local company. Detailing is almost always priced flat per vehicle, so the per-hour test matters even more: a $175 full detail that takes 3.5 hours earns $50 an hour before supplies and travel, while a $28 fleet wash that takes 30 minutes earns $56 an hour, and does it six times in a row in the same parking lot. We compare detail packages side by side in mobile detailing pricing: how to price a full detail per hour.
Copy-ready layout to build your own
If you want to build it yourself, here is a minimal version in Excel or Google Sheets.
Quote tab (one row per service line, starting row 2):
- Columns: Service | Basis | Rate | Qty | Hours | Line total
- Line total (F2):
=IFERROR(C2*D2,0) - Services subtotal:
=SUM(F2:F9) - Hours:
=SUM(E2:E9) - Travel:
=TripCharge + RoundTripMiles*MileageRate - Markup:
=Subtotal*MarkupPct - Quote total:
=Subtotal+Travel+Markup - Effective $/hour:
=IFERROR(QuoteTotal/Hours,0)
Job tracker tab:
- Columns: Date | Client | Service | Status | Quoted | Paid | Balance
- Balance:
=IFERROR(E2-F2,0) - Outstanding total:
=SUM(G:G)
Client re-book (Frequency in E, Last service in F):
- Next due:
=F2+IF(E2="Annual",365,IF(E2="Quarterly",91,IF(E2="Bi-Annual",182,IF(E2="Bi-Weekly",14,"")))) - Due flag:
=IF(G2<=TODAY(),"DUE","")
That is enough to stop the leaks. The full version adds dropdowns, an equipment service schedule, a mileage log and a dashboard so you are not rebuilding formulas every time you add a row.
Done-for-you option
The Pressure Washing & Mobile Detailing Business Tracker is the complete version of everything above, already linked: a Settings tab for your labor rate, markup, default price per square foot, trip charge, mileage rate and tax set-aside; a Service Menu priced per square foot, per linear foot or flat; a Quote Builder that returns the quote total and your effective rate per labor hour; a Job Tracker from Quoted to Paid with balances; a Client List that calculates each client’s next service date; Income & Expenses by category; an Equipment Log with service-due flags; a Mileage Log; and a Dashboard with revenue, net profit, margin, outstanding money and average job value. It comes with a sample season filled in so you can see how it works before you clear it.
Featured on ReadySheetGo
Pressure Washing & Mobile Detailing Business Tracker — $16.99
Quote Builder with effective $/labor hour, Job Tracker with balances, re-book reminders, equipment service log, mileage log and a profit dashboard. Works in Excel and Google Sheets.
More guides for pressure washing and detailing businesses
- How much to charge for pressure washing per square foot: build your rates from a target hourly figure and your real production speed.
- Mobile detailing pricing: how to price a full detail per hour: compare express, full and fleet packages on net dollars per hour.
- Pressure washing estimate mistakes that cost you profit: eight quoting errors and the fix for each.
- Is a pressure washing business profitable?: a full month worked through, from job revenue to money kept after overhead and tax set-aside.
General information only, not tax, legal or accounting advice. Example figures are illustrative assumptions.
Frequently Asked Questions
What should a pressure washing business spreadsheet track?
Six things: a service menu with your rate per square foot, linear foot or flat price; a quote builder that turns measurements into a price; a job tracker that follows each booking from Quoted to Paid with the balance still owed; a client list with the next re-service date; an income and expense log; and a mileage log. A dashboard on top then shows revenue, expenses, net profit, average job value and outstanding money in one place.
How do I write a pressure washing quote?
Measure each surface, multiply square footage (or linear feet, or count) by your rate for that surface, add a trip charge that covers your drive, and check the total against a minimum job charge. Then divide the total by the labor hours you expect it to take; if the result is below your target hourly rate, the quote is too low. For example, 1,800 sq ft of siding at $0.18, 600 sq ft of driveway at $0.15 and 150 ft of gutters at $1.25 comes to $601.50 before travel and markup.
Can I run a pressure washing business from Excel or Google Sheets?
Yes. A solo operator or a two-person crew can quote, schedule, invoice and track profit in a well-built workbook without paying monthly for field-service software. The key is linked tabs, so the rates on your service menu feed every quote, and every paid job and receipt flows to one dashboard.
What expenses should a pressure washing business track?
Chemicals (sodium hypochlorite, surfactants, degreasers), fuel for the truck and the pump engine, equipment purchases and repairs, helper labor, insurance, marketing, water where you pay for it, and business mileage. Logging them by category each week lets you see cost per job and which services actually make money, and gives your tax preparer clean totals at year end.