How to use the Cleaning Income, Expense & Mileage Tracker

See what the business really makes, pay each cleaner for their hours, and get tax-time totals. Here's every step, with screenshots from the real spreadsheet.

Get this tool · $9Start here

Version 1.0 · 9 tabs · Excel and Google Sheets · Free Lifetime Updates

At a Glance
StepHow long
1Before you start1 min 2Set up10 min, once 3Log income and expensesSee step 4Log hours and pay cleanersSee step 5Log milesSee step
Messages explainedSee them →

Before you start

The one rule: yellow cells with blue text are yours to fill in. Gray cells calculate on their own and are locked, so you can't erase a formula by accident.
  1. Your download is a zip with two files. Double-click it to open it. Start with the one marked with examples to see how everything works, then use the blank one for your business.
  2. Open the file in Microsoft Excel. Using Google Sheets? Upload it to Google Drive, then open it with Google Sheets.
  3. Start on the Start Here tab. It has the same steps, right inside the file.
  4. The sample data is there so you can see how everything works. Type over it with your own when you're ready.

Here's how to set up once, then log income, hours and miles in a few minutes a day.

1Set up (one time, about 10 minutes)

  1. Open Settings. Enter the year and the share of profit to set aside for taxes.
  2. Add your card and app fee rates and your cleaners with their pay per hour.
  3. Look over the expense categories. Rename or add your own. Each shows its usual tax line. Check with your tax pro.

2Log income and expenses

Cleaning Income, Expense & Mileage Tracker Tax Summary tab in Excel and Google Sheets. The Tax Summary totals every category with its usual tax line, ready for your tax pro.
The Tax Summary totals every category with its usual tax line, ready for your tax pro.
  1. Income: add each payment with the lead cleaner, what it was for, the amount, tip and how they paid. Card fees fill in on their own.
  2. Expenses: add what you spend, pick a category and mark whether you have a receipt.

3Log hours and pay cleaners

Cleaning Income, Expense & Mileage Tracker Cleaner Pay tab in Excel and Google Sheets. Cleaner Pay turns logged hours into what each cleaner earned for the month, with tips.
Cleaner Pay turns logged hours into what each cleaner earned for the month, with tips.
  1. Hours: one row per cleaner per day or job.
  2. Cleaner Pay: type any date in the month. Each cleaner's hours, pay and tips are added up.

4Log miles

Cleaning Income, Expense & Mileage Tracker Mileage tab in Excel and Google Sheets. The mileage log for driving between homes, using the IRS rate for each trip's date.
The mileage log for driving between homes, using the IRS rate for each trip's date.
  1. Mileage: log trips between homes and supply runs. Each uses the IRS rate for its date.

What the messages mean

The tool watches your numbers and tells you in plain words when something needs a look. Here's every message you might see.

Pick how they paid.
What it means: Paid by is blank, so card fees can't be figured.
What to do: Pick Cash, Card or another type.
Cleaner isn't on Settings.
What it means: The name doesn't match the list. Often a typo.
What to do: Pick the cleaner from the list.
Refunds need a minus sign, like -45.
What it means: A refund was entered as a positive number.
What to do: Add the minus sign.
Not in this year, so it won't count.
What it means: The date is outside the year on Settings.
What to do: Fix the date or start a new file for the new year.
No IRS rate for this date. Add one on Settings.
What it means: There's no mileage rate for that trip's date.
What to do: Add the rate on Settings.

Using Google Sheets or your phone

  • To use Google Sheets, upload the file to Google Drive, then right-click it and choose Open with, then Google Sheets.
  • Dropdowns, colors, and every calculation work the same in Google Sheets.
  • On a phone, the Google Sheets and Excel apps work for quick changes. For setup and printing, a computer is easier.
  • Want to start fresh? Type over the yellow example cells. Don't delete rows, since other tabs may be reading them.

Ready when you are

Everything above comes with our cleaning income tracker for $9, updates included. Or get it as part of the full cleaning toolkit.

Common questions

Is this payroll?

No. It shows what each cleaner earned. Withholding and payroll taxes are handled by your payroll service or tax pro.

Is this tax advice?

No. Tax lines are the usual ones and every category is editable. Check with your tax pro.

Quick reference from the Start Here tab

Welcome

Know what the cleaning business is really making. Track every payment, tip and expense, log the miles between homes, pay each cleaner for the hours they worked, and walk into tax time with clean totals.

Setup (About 10 Minutes, One Time)

1

Open 'Settings'. Enter the year, your card and app fees, your cleaners and their pay per hour, and how much to set aside for taxes.

2

Check the expense categories. Rename or add your own. The tax lines are the usual ones, not advice. Confirm them with your tax pro.

Every Day Or Week

1

'Income': add each payment. Keep tips in their own column. Card and app fees fill in on their own.

2

'Expenses': add what you spend and pick a category. Mark whether you kept the receipt.

3

'Hours': log each cleaner's hours. 'Cleaner Pay' turns them into pay for any month.

4

'Mileage': log the drive between homes and supply runs. Each trip uses the IRS rate for its date.

How You Work

Solo cleaner: log your income, expenses and miles. Leave Hours blank, or log your own to see what each hour really earned.

Team with employees or contractors: log every cleaner's hours. 'Cleaner Pay' shows what each one is owed, with the tips they collected.

Supplies you resell to commercial clients go in as Supplies billed, so they don't inflate your cleaning income.

What It Tells You

'Dashboard': income, tips, fees, expenses and profit by month, your average clean, and what to set aside for taxes.

'Tax Summary': yearly totals by category with the usual tax line, plus your mileage at the IRS rate for each trip's date.

Handy Tips

Refund? Add it on 'Income' as What = Refund with a minus sign, like -45.

Each trip's mileage uses the IRS rate in effect on its date. Add new rates on 'Settings' when they're announced.

Using Google Sheets? Upload this file to Google Drive and open it with Google Sheets. Everything works the same.

Important

This tracker organizes your numbers. It isn't tax or legal advice. Tax lines, deductions and mileage rules depend on your situation, so check with a tax professional.

Your License

This file is licensed to one business, including everyone who works there. Please don't share, resell or post it online.

© 2026 EasyWorkTools. All rights reserved. easyworktools.com

Every tab

This file has 9 tabs, in this order:

  1. Start Here
  2. Dashboard
  3. Cleaner Pay
  4. Tax Summary
  5. Income
  6. Expenses
  7. Hours
  8. Mileage
  9. Settings
Still stuck on something? Ask us. We answer within one business day, and we'll add the answer here for everyone.