Cleaning Business Tracker Spreadsheet: Clients, Jobs, Invoices, Expenses, Mileage & Tax Summary (Excel + Google Sheets)

Run a residential, commercial or Airbnb-turnover cleaning business from one workbook.

, ,
, , , ,

Run a residential, commercial or Airbnb-turnover cleaning business from one workbook.

  • Clients list with revenue to date and unpaid balance per client
  • Job log with automatic invoice numbers, hourly or flat pricing, tips, and Paid/Unpaid tracking
  • Expense log by category, mileage log with deduction at your rate
  • Supplies list that flags items below par and totals the reorder cost
  • Dashboard: revenue, collected, receivables, net profit, tax set-aside, average job, effective hourly rate, month-by-month chart vs your goal
  • Schedule C-style summary to hand your tax preparer (bookkeeping aid, not tax advice)

Yellow cells are inputs; everything else updates itself. Sample rows included. Works in Excel 2016+ and Google Sheets. Built with AI assistance and checked for formula errors. Instant download.

What it is used for

Day-to-day bookkeeping for a solo cleaner or small cleaning crew: who owes you, what you earned and spent, and what to hand over at tax time.

Tabs and structure

Nine tabs: Start Here, Dashboard, Settings, Clients, Jobs, Expenses, Mileage, Supplies and Tax Summary.

What you enter

  • Business name, tax year, mileage rate, self-employment set-aside % and monthly revenue goal
  • Expense categories and service types (editable lists)
  • Clients (100 rows) with type, default rate and frequency
  • Jobs, expenses and mileage (300 rows each): dates, hours and rate or a flat price, tips, Paid or Unpaid, odometer readings
  • Supplies (100 rows): on hand, par level, reorder quantity and unit cost

What it calculates

  • Invoice numbers and the amount for each job
  • Revenue and unpaid balance per client
  • Miles and the mileage deduction
  • Reorder cost per item and in total
  • Eleven dashboard figures, a monthly table with a bar chart, and expenses by category on the Tax Summary

How to use it

Fill Settings, add your clients, delete the sample rows, then log each job, expense and trip. The Tax Summary check should read 0.

File and limitations

One .xlsx file for Excel 2016+ and Google Sheets. No macros. Sample rows are made-up examples. The mileage rate is an input; check the current IRS standard rate each year. Built with AI assistance and checked for formula errors. A record-keeping tool, not tax, legal or accounting advice.

You must log in to submit a review.