Blush graphic titled Cleaning Business Expense Tracker Spreadsheet

Cleaning Business Expense Tracker: Spreadsheet to Track Income, Costs and Profit

A cleaning business expense tracker needs two logs: one row per job (client, hours, price, tips, paid or not) and one row per cost (supplies, fuel, staff, insurance). Keep both in one spreadsheet and your profit, revenue per hour and unpaid invoices appear without extra maths.

Below is what to record, how to set the sheet up in Google Sheets or Excel, and how to work out cleaning company profit job by job. If you would rather start from a finished file, our cleaning business expense tracker (Google Sheets and Excel) has the job log, expenses, mileage and client list ready to use.

Please note: this article is about keeping good business records. It isn't tax or accounting advice. Rules for deductible expenses and mileage differ by country and change over time, so check the current rules with your tax authority or a tax professional.

What should a cleaning business expense tracker include?

Many cleaners track income in one place and costs in another, then struggle to see what a job really earned. Put both in the same workbook, with these tabs:

  • Jobs: date, client, service (regular clean, deep clean, move-out), hours, price, tip, and a Paid? column.
  • Expenses: date, category, amount and a note. Categories to start with: cleaning supplies, equipment, fuel, staff or subcontractors, insurance, software and phone.
  • Mileage: odometer start and end for the drive between clients.
  • Clients: each client's total jobs and total billed.
  • Dashboard: monthly income, expenses and profit.

How do you track cleaning company profit?

Profit is income minus expenses, but cleaning company profit tracking is more useful when you look at it per job and per hour:

  1. Income per job: price plus tip.
  2. Revenue per hour: income divided by hours worked. Include the drive time between homes if you want an honest number.
  3. Costs: add up supplies, fuel and staff for the month, then divide by the number of jobs to see the average cost per job.
  4. Profit for the month: total income minus total expenses.

A client who looks good on price can drop down the list once you add a long drive and extra supplies. The same job log shows which clients are worth keeping.

How do you make a cleaning business spreadsheet in Google Sheets?

  1. Create the Jobs tab. Headings in row 1: Date, Client, Service, Hours, Price, Tip, Paid?
  2. Add an hourly rate. In column H type =(E2+F2)/D2 for income per hour and copy it down.
  3. Add a Paid? dropdown. Select column G, choose Data, then Data validation, and list Yes and No.
  4. Show what you are owed. =SUMIFS(E:E,G:G,"No") totals the price of every job not yet paid.
  5. Create the Expenses tab with a category dropdown, then use =SUMIFS(Expenses!C:C,Expenses!B:B,"Supplies") to total each category.
  6. Build the monthly summary. Subtract total expenses from total job income for each month.

That is enough to start. The ready-made cleaning business income and expense tracker adds revenue per hour, average job price, an amount-still-owed total, a mileage log, charts and an optional tax set-aside, all with the formulas built in. It works in any currency and in km or miles.

Which cleaning business expenses should I record?

Record everything, then let your accountant decide what counts. Common categories are:

  • cleaning products and consumables
  • vacuums, mops and other equipment
  • fuel and vehicle costs, or mileage
  • staff pay and subcontractors
  • insurance and licences
  • marketing, phone and software

Keep receipts or photos of them, and enter each cost soon after you buy it. A ten-minute weekly session beats a year-end scramble. Rules for what you can deduct vary by country, so this is about keeping records, not tax advice.

How do I keep track of clients who haven't paid?

Add a Paid? column to the job log and filter it for "No" each week. Adding the date you sent the invoice makes it easy to spot anything more than a couple of weeks old. A client list tab that totals what each client has been billed helps you see at a glance who is behind.

Is there a free cleaning business spreadsheet?

You can build one yourself with the steps above, and that works well for a single cleaner with a few clients. A pre-built sheet saves the setup time and avoids formula mistakes once you have staff or dozens of regular clients. If you do more than cleaning, the side hustle finance kit includes trackers for several types of work, and the small business bookkeeping spreadsheet covers income, expenses and profit and loss for a growing company.

For related reading, see how to log miles in our mileage tracker guide, or keep household money in order with a monthly budget template for Google Sheets. Our cleaning checklist is handy to share with clients and staff.

Trackers for cleaners and small businesses

FAQ

What is the best way to track expenses for a cleaning business?

Use one spreadsheet with a job log for income and an expenses tab for costs, and update both weekly. Categories such as supplies, fuel, staff and insurance make monthly totals easy.

How do I calculate profit for a cleaning job?

Add the price and any tip, subtract the supplies, fuel and labour you spent on that job, and divide by the hours to see profit per hour.

Does the tracker work in Google Sheets?

Yes. The tracker is an .xlsx file that opens in Excel, and in Google Sheets you choose File, then Import, then Upload.

Is this tax advice?

No. A tracker helps you keep clear records. Rules for deductible expenses and mileage differ by country, so check the current rules or ask a tax professional.

Back to blog

More from the blog

Read all articles