Mobile Detailing Business Manager Spreadsheet | Quote Builder, Job Tracker, Profit Per Hour and Rebooking Board

Quoted $180, took 4 hours and $31 of chemicals. Worth it?

Most detailing trackers stop at the quote. This one runs the whole job: a quote builder on your own rate card, a job board that moves each detail from lead to paid, a quote-vs-actual log that shows what every job really earned per hour — and a rebooking board that flags which clients are due for their next detail before they quietly book someone else.

WHAT THE SAMPLE DATA SHOWSThe tracker comes loaded with a fictional sample business, Shine Squad Mobile Detailing (12 completed jobs, Sep-Oct 2026), and the samples make the point better than we can: the highest-priced package, Showroom Restoration, charges $738.40 a job on average — and keeps the LEAST per hour, $35.91, once its 15-19 hour jobs and heavy product use land. The cheapest package, Express Wash & Vac, keeps the MOST per hour at $56.02. Price is not profit; hours decide. The rebooking board tells the other half of the story: on the sample date, 2 clients are OVERDUE for their next detail and 2 more are DUE THIS WEEK.

WHAT'S INSIDE — 7 TABS

1. Start Here + Dashboard — the full guide, your two settings (vehicle cost per mile, target profit per hour), the money at a glance (revenue, collected, outstanding, blended profit per hour), and the per-package payoff board.

1. Client & Vehicle CRM — every client and vehicle: size, condition notes, maintenance cadence, last service, jobs done and revenue.

Quote Builder — your rate card (package base prices, vehicle-size and condition multipliers, add-on prices) plus a live calculator: package x size x condition + add-ons + travel, with an estimated profit per hour on every quote before you drive out.

1. Job Board — the pipeline: Lead → Quoted → Booked → In Progress → Completed → Paid, with deposits in and balances due.

1. Job Actuals — one row per completed job: price charged, products actually used, other costs, drive miles, hours on site and drive time → true cost, profit, profit per hour, and a verdict against your target (WORTH IT / OK / THIN).

1. Maintenance Plan & Rebooking Board — next detail due per client from their cadence and last service, graded OVERDUE / DUE THIS WEEK / OK against the As-Of date you set.

1. Expenses & Monthly P&L — overhead log (insurance, phone, marketing, equipment) and a monthly net that pulls revenue and job costs straight from Job Actuals.

HOW THE MATH WORKS

Quote: package base × size multiplier (Compact 0.90 / Sedan 1.00 / SUV-Truck 1.20 / XL 1.40) × condition multiplier (Light 1.00 / Moderate 1.15 / Heavy 1.30), plus flat add-ons, plus travel at $1.25 per round-trip mile beyond 10 free miles. Deposit is 50%. Actual profit: price − products − other costs − vehicle cost (drive miles × your Dashboard rate; $0.70/mi in the samples). Profit per hour divides by ALL your time, job hours plus drive hours.

WHO IT'S FOR

Solo mobile detailers and small crews who price by package, drive to the client, and live on repeat business — and who suspect their biggest package might not be their best earner. It is an organization and calculation tool: it reports the numbers you enter, and it is not tax, financial, or legal advice.

You need a free Google account to use the Google Sheets file. Sample data is fictional and clearly replaceable — swap in your rate card, your clients, and your jobs as you go.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

FINISHED 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.

This is a digital product — no physical item will be shipped. Your file is available instantly after checkout. All sales are final (no returns or cancellations on digital downloads), but if anything is ever wrong with your file, message us anytime and we'll fix it — no time limit.