Mobile Car Detailing Profit Tracker

Mobile Car Detailing Profit Tracker Excel for your detailing business — package pricing per car, job profit, supplies inventory, and a monthly P and L dashboard. Know what every car actually costs — and whether the month actually made money.

Built for mobile detailers, car detailers, and small detailing businesses who need to know, package by package and job by job, whether the price covers the supplies, the labor, and the fuel — without accounting software. If a job is losing money, this workbook shows it before the next booking.

WHAT'S INCLUDED (6 sheets):

- Packages and Add-Ons — hours per car, supplies and labor cost per car, cost per car, price per car, and margin in dollars and percent for every package. Change a supplies cost and every job profit updates by formula.

- Jobs — date, customer and vehicle, job type (Single Car, Fleet, Recurring, Gift Card), package, cars, price per car, revenue, cost per car pulled from the packages sheet, profit per job, and margin. Log single cars, fleets, recurring clients, and gift cards in one place.

- Supplies and Inventory — supply, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you order it before the next job.

- Monthly P and L — revenue, job cost, equipment and repairs, fuel and vehicle, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and job cost are formulas from the Jobs sheet.

- Dashboard — total revenue, jobs, cars detailed, average job value, gross and net profit and margin, best package by margin dollars and by margin percent, best-selling package, best job and best job type, costs by category, and low stock count.

- Cover and How to Use — start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (October 2026 — replace with your own numbers):

- Total revenue 2,282 from 20 jobs and 27 cars detailed; average job value 114.10.

- Job cost 1,016; gross profit 1,266; gross margin 55.5 percent.

- Equipment and Repairs 285; Fuel and Vehicle 340; Other Expenses 210; total expenses 1,851; net profit 431; net margin 18.9 percent.

- Revenue by job type: Single Car 1,607 (best), Fleet 280, Recurring 395, Gift Card 0.

- Best service by margin per unit: Ceramic Spray Coating (3 hrs), margin 119 per unit (cost 80 per unit, price 199). Best service by margin percent: Headlight Restoration (1 hr), 69.3 percent (cost 23 per unit, price 75).

- Best-selling service: Fleet Wash - per vehicle (0.75 hr), 8 units sold. Next: Express Exterior Wash (1 hr) 4, Full Detail - Inside + Out (4 hrs) 4.

- Best job: Thompson - BMW X5, Ceramic Spray Coating (3 hrs) — revenue 199, profit 119.

- Loss-making job: Walsh - VW Golf (promo), Express Exterior Wash (1 hr) — revenue 30, profit -10.

- Inventory: stock value 1,404; 2 items at or below reorder point — Leather Conditioner, Air Freshener.

- Average cost per unit across services 39.20; average margin percent 57.8 percent.

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each package's supplies cost per car, labor cost per car, and price per car. Cost per unit and margin fill in by formula.

3. On sheet 2, log every job: date, customer, job type, package (spelled exactly as on sheet 1), quantity, and unit price. Revenue, cost per unit, and profit fill in by formula.

4. On sheet 3, keep quantities on hand current and set a reorder point for each supply. Buy more of anything flagged LOW STOCK before the next job.

5. On sheet 4, enter equipment and repairs, fuel and vehicle, and other expenses each month, then check gross and net profit on the Dashboard.

HOW THE NUMBERS WORK:

Cost per car is supplies cost per car plus labor cost per car. Margin per car is price per car minus cost per car. Margin percent is margin per car divided by price per car. Gross profit is revenue minus job cost; net profit is revenue minus job cost, equipment and repairs, fuel and vehicle, and other expenses. Supplies are inside job cost, not in the equipment line. One unit is one car.

WHO IT'S FOR:

Mobile detailers, car detailers, and small detailing businesses who want package pricing, job profit, supplies inventory, and a monthly P and L in one workbook — without accounting software.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for October 2026 is included (10 services, 20 jobs, 27 cars detailed, 12 supplies). Replace it with your own numbers.

- The example is simplified: add-on services are priced as separate packages in the example, so add a row per add-on on sheet 1 if you price them separately. Check your local water-use rules for mobile washing.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.