Cleaning Fee Log Excel - Free Template

1. Open the Fee Log tab and enter each booking on its own row. Start with Booking ID, property name, and the stay dates so every cleaning charge ties back to a specific reservation.
2. Fill in the cleaning date, cleaner or vendor, and service type. Then enter the fee charged, cleaner paid, tip, and supplies cost in dollars.
3. Review the calculated fields for total cost, gross profit, and profit margin. A $120 fee with $80 paid to the cleaner and $10 in supplies leaves $30 of gross profit before overhead.
4. Update status and payment method as work is completed and paid. That gives you a quick view of open balances and completed turnarounds.
5. Check the Summary Dashboard tab for the high-level totals. Use it to compare properties, spot low-margin jobs, and see which vendor costs are rising.
6. Read the Instructions tab before you change the layout. If you add more properties or more cleaners, keep the same fields so the summary stays usable.

A host with one condo in Phoenix, a sole proprietor filing Schedule C, and a small LLC running six units all use this kind of log the same way: to match each reservation to the cleaning charge attached to it. If you collect a $135 turnover fee on 42 stays in a year, that is $5,670 of revenue you need to reconcile against cleaner pay, tips, and supplies.

This sheet is especially useful at month-end when you want to know whether a property is producing real margin or just passing money through. A cleaner paid $90, plus $12 in supplies, turns that $135 fee into $33 of gross profit before overhead. That is the kind of number you need before you decide whether to keep charging a separate cleaning fee or fold the cost into the nightly rate.

For Hosts, Property Managers, And Bookkeepers

A property manager with 18 turnovers in a weekend needs a quick way to see which units were cleaned, which ones were paid, and which ones still need follow-up. A bookkeeper can use the same log to build the monthly profit & loss and keep the owner from guessing at cleaning expense.

When The Log Becomes A Control Tool

If you manage 3 properties and each one averages 10 cleanings a month, you are reviewing 30 rows, not 300. That is exactly the scale where a spreadsheet still beats a clunky app, because you can sort by city, vendor, or status in seconds.

The IRS expects you to keep records that support income and deductions, and the practical rule is to keep them at least 3 years, with some records held up to 7. For a short-term rental operator, that means booking confirmations, vendor invoices, payment proof, and a log that shows the cleaning fee charged and the cost behind it.

If you report the activity on Schedule C, the cleaning fee is business income and the cleaner payment is a deductible expense. A $1,200 monthly total in cleaning fees with $820 in vendor pay and $96 in supplies leaves $284 of gross profit before any other rental expenses.

Why The Dollar Trail Matters

This log gives you the paper trail that connects the reservation to the transaction. If the cleaner is a contractor paid $600 or more during the year, you may need a 1099-NEC and an W-9 on file, so keeping vendor names and payment methods inside the sheet saves you a separate cleanup later.

Cleaning Fees Are Not Payroll

Do not treat a one-off cleaner payment the same way you treat wages subject to FICA. A contractor paid $95 per turnover is tracked as vendor expense, not payroll tax, and the log should make that distinction obvious when you review the year-end numbers.

The first failure is simple: you charge a cleaning fee but never record the actual cost. If you billed 50 stays at $125 and your real average cost was $104, you think you made $6,250 in fee income when the true gross profit was only $1,050.

The second failure is paying different cleaners from memory instead of a log. One extra $20 tip on 40 stays is $800 a year, which is enough to wipe out the margin on a small unit if you never notice the drift.

Missing Vendor Detail Costs Real Money

If a contractor is paid $650 over the year and you cannot prove who it was or what service they performed, you may spend hours rebuilding the trail from text messages and bank statements. That is not just annoying; it delays your year-end close and can leave your books wrong by hundreds or thousands of dollars.

Bad Margin Math Hides Weak Properties

When you do not separate gross profit from total revenue, a property that charges $150 and costs $145 looks fine until you realize the spread is only $5. At 20 turnovers a month, that is $100 of profit before platform fees, laundry, and your time, which is too thin for most operators to accept.

Use the sheet on a fixed day, not whenever you remember it. The easiest routine is to update it right after the weekly turnover run or during month-end close, when you already have the cleaner invoices and payout records in front of you.

Three Habits That Keep It Current

• Copy the prior month’s rows into the new month so you start with the same structure.
• Enter fees and vendor pay within 24 hours of each stay so you do not lose the transaction details.
• Use the status column to mark paid, unpaid, or disputed before the week ends.

When To Move Beyond A Spreadsheet

If you are running 25 or more units and cleaners are texting updates all day, a spreadsheet starts to feel tight and a property-management system or bookkeeping app becomes the better choice. Until then, this file is fast enough, transparent enough, and easy enough for an assistant to update without training.