Detailing money comes in by card, app and cash, and goes out on chemicals, pads, fuel and wages. This tracker sorts it out, turns logged hours into pay, and keeps miles at the right IRS rate for each trip.
Every step is laid out before you buy, so you can see how detailer pay works with screenshots from the real file. It also works hand in hand with our detailing quote calculator.
What the Detailing Income, Expense & Mileage Tracker does
- Tips paid out to detailers counted in your profit, plus sales tax collected kept apart from income
- Income with tips, refunds and card fees figured for you
- Hours log and Detailer Pay for any month
- Mileage between jobs at the IRS rate for each trip's date
- 22 expense categories you can rename, each with its usual tax line
- Monthly Dashboard with profit, average job and top expenses
- Yearly Tax Summary for your tax pro, plus a tax set-aside
What's inside
9 tabs: Start Here, Dashboard, Detailer Pay, Tax Summary, Income, Expenses, Hours, Mileage, Settings.
Who it's for
Solo detailers and small crews who want clean numbers without bookkeeping software.
What you get
Two spreadsheet files (.xlsx): one filled with examples so you can see exactly how it works, and a blank copy ready for your business. For Microsoft Excel and Google Sheets. No macros, no subscription.
The formulas are locked, so a stray keystroke can't break them. You only type in the yellow cells.
What you need to use it
- Microsoft Excel 2010 or newer, on Windows or Mac, including Microsoft 365
- Or Google Sheets in any web browser, free with a Google account
- A laptop or desktop works best for setup. Phones and tablets are fine for checking numbers and quick entries.
- No macros, add-ins or internet connection needed once it's downloaded. Apple Numbers isn't supported.
This is a record-keeping tool, not tax or payroll advice. Tax lines are shown as the usual line, and every category is yours to edit. Check with your tax professional.
Questions
Does it run payroll?
No. Detailer Pay shows what each detailer earned from their hours. Withholding is handled by your payroll service or tax pro.
Is there a blank version?
Yes. Every download has two files: one filled with examples so you can see how everything works, and a blank copy ready for your own business. Your rates and settings come filled in as a starting point, so change them to match yours.
Can I change the formulas?
The gray formula cells are locked so they can't be erased by accident. If you really want to change one, open Review in Excel and choose Unprotect Sheet. There's no password.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The math works the same. Locks don't carry over, so just type in the yellow cells.
How do Free Lifetime Updates work?
Whenever we release a new version, you can download it free from your account, forever. We'll email you when there's something new.
