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.

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:

Finally, the test that matters:

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:

  1. 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).
  2. Flatwork: length × width for each rectangle. A two-car driveway of 20 × 24 ft is 480 sq ft; add walkways and the patio separately.
  3. 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.

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):

Job tracker tab:

Client re-book (Frequency in E, Last service in F):

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.

More guides for pressure washing and detailing businesses

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.

Know Your Real Rate Per Hour Before You Send the Quote

The Pressure Washing & Mobile Detailing Business Tracker — 9 linked tabs for an exterior cleaning or mobile detailing business: Settings for your hourly labor rate, target 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, each with an estimated time; a Quote Builder that returns the quote total and your effective rate per labor hour; a Job Tracker from Quoted to Paid with balances owed; a Client List that calculates each client's next service date and flags who is due; Income & Expenses by category; an Equipment Log with service-due flags by run hours; a Mileage Log; and a Dashboard with revenue, expenses, net profit, margin, jobs completed, outstanding balances, average job value and tax set-aside. Sample season pre-filled. Works in Excel and Google Sheets.

View on Etsy — $16.99