← All guidesCleaning Business

How to Track Recurring Cleaning Clients Without Paying $80 a Month for an App

If you run a residential or commercial cleaning business, your real product is not the cleaning. It is the recurring relationship. The weekly client, the biweekly client, the once-a-month deep clean that turns into a standing appointment. Lose track of those and you lose the revenue that actually pays your bills. So at some point a slick app starts whispering at you: let us manage your schedule, your clients, your gate codes, your invoices. Then the bill shows up, and it keeps showing up, every single month, whether you booked 4 jobs or 40.

This article shows you how to track every recurring cleaning client (schedules, entry instructions, and lifetime value) using nothing but a spreadsheet you own once. We will put the real 2026 app pricing side by side with a one-time cleaning business client tracker spreadsheet so you can see exactly what you are paying for, and decide for yourself whether the subscription is worth it.

What the cleaning apps actually cost in 2026

The three names you hear most in the cleaning world are ZenMaid, Jobber, and Housecall Pro. All three are real tools, and for a multi-crew operation with dispatchers and a front office, they can earn their keep. But look at what a solo cleaner or a two-person team is signing up for month after month:

Tool Typical 2026 starting price Cost per year Notes
ZenMaid About $58 to $79/mo (small plans, billed annually) ~$700 to $950 Built for maid services, but price climbs with cleaner count
Jobber Core around $39/mo, Connect tier around $119/mo ~$470 to $1,400+ Lowest tier limits users and features; useful tiers cost more
Housecall Pro Basic around $59/mo, mid tier around $149/mo ~$700 to $1,800+ Per-user add-ons stack up fast for teams
1099 Sheets cleaning tracker $29 one time $29, then $0 forever You own the file in Excel or Google Sheets

Prices shift with plans and promos, so check the current page before you sign. But the shape of the math does not change. Even on the cheapest serious plan, an app costs you somewhere between $500 and $1,800 a year, every year. A spreadsheet costs you $29 once. One year of a true mid-tier subscription (roughly $1,200) is more than 40 times the one-time cost of the spreadsheet, so the spreadsheet would have to fail you dozens of times over to lose that comparison. For most solo and small-team cleaners, it does not come close.

The honest tradeoff: apps send automated text reminders, take card payments inside the app, and route a fleet of cleaners across a city. If you genuinely need automated dispatching for six crews, pay for the app. If you are a solo cleaner, a couple, or a small team that already texts clients and gets paid by Zelle, Venmo, check, or cash, you are renting a Ferrari to drive to the mailbox.

The four things a recurring cleaning business actually has to track

Strip away the dashboards and notifications, and a cleaning operation runs on four pieces of information. A spreadsheet handles all four cleanly.

1. The recurring schedule (who, how often, what day)

Every client gets a row. The columns that matter: client name, address, frequency (weekly, biweekly, every 4 weeks, monthly), preferred day, preferred time window, and the date of their last clean. The magic column is Next Visit, which you can calculate automatically. In Google Sheets or Excel, if your last visit is in column F and your frequency in days is in column G, the formula is simply:

  • =F2+G2 gives you the next scheduled date for that client.
  • Set frequency in days: 7 for weekly, 14 for biweekly, 28 for every four weeks, 30 for monthly.
  • Add conditional formatting so any "Next Visit" date within the next 3 days turns yellow, and any overdue date turns red. Now your spreadsheet flags who needs booking, with no monthly app subscription required.

Sort the sheet by Next Visit and your entire week lays itself out in front of you, top to bottom.

2. Gate codes, alarm codes, and entry instructions

This is the detail that quietly makes or breaks a cleaning business. Show up to a recurring client and not know the gate code, the lockbox combo, the alarm disarm sequence, or where the dog is, and you have either wasted a trip or triggered a 2 a.m. alarm call. Apps store this. So does a spreadsheet, and arguably more safely, because you control exactly who has access to the file.

Add a dedicated Access section with columns for gate code, garage or door code, alarm code, lockbox location, key location, parking notes, and pet warnings. A few practical rules:

  • Keep this information in a separate tab with restricted sharing, not on the same public-looking sheet you might screenshot for a client.
  • In Google Sheets, share the file only with specific cleaner emails, not "anyone with the link."
  • Write entry steps in plain order: "Park on street, gate code 4417, key under blue pot, disarm alarm code 2290 within 30 seconds."

One clear cell of text saves a frantic phone call on the doorstep. That is the unglamorous work a paid app and a $29 spreadsheet do equally well.

3. Pricing, payment, and what you are owed

For each recurring client, track the price per visit, the payment method, and whether the last visit was paid. A running Outstanding column (price per visit times unpaid visits) tells you at a glance who owes you money, which is the number most solo cleaners lose track of first. You do not need an in-app payment processor that shaves a percentage off every job. You need to know who has not paid yet, and a spreadsheet shows you that in one filtered view.

4. Client lifetime value (the number the apps bury)

Here is where a spreadsheet quietly beats the apps for a small operator. Customer lifetime value tells you what a recurring client can be worth, and it changes how you treat them. A weekly client at $130 per clean is not a $130 customer. Residential cleaning relationships often run a couple of years or more, and over a 2.5-year span at that rate the numbers add up fast:

  • $130 per visit, weekly, for 2.5 years, which is about 130 visits, or roughly $16,900 in lifetime revenue.
  • A biweekly client at the same rate works out to about 65 visits, or roughly $8,450 over that span.

The formula in your tracker is: average price per visit, times visits per year, times average years retained. These are estimates, not guarantees, since retention varies client to client, but putting the number in a column next to each client makes a few things obvious immediately. You stop treating a potential $16,900 client like a one-off. You think twice before nickel-and-diming them on a small request. And when one of them cancels, you understand the real size of the hole, which pushes you to follow up, win them back, or replace them fast. Most cleaners never calculate this. A spreadsheet hands it to you in one column.

How to set it up in Google Sheets in an afternoon

You can build a basic version yourself. The structure looks like this:

  • Tab 1, Clients: name, address, frequency, frequency in days, preferred day, price per visit, last visit, next visit (formula), lifetime value (formula), status (active, paused, lost).
  • Tab 2, Access (restricted): client name, gate code, door or garage code, alarm code, key or lockbox location, pet notes, special instructions.
  • Tab 3, Payments: date, client, amount, method, paid yes or no, with a SUMIF to total what is still outstanding.
  • Tab 4, Dashboard: count of active clients, total weekly revenue, total monthly recurring revenue, and total outstanding, all pulled with simple COUNTIF and SUMIF formulas.

Works the same in Excel or Google Sheets, on your phone in the driveway or your laptop at the kitchen table, with no internet plan required and no per-user fee when your spouse or your one helper needs access.

A quick note: this article is about scheduling and client management, not taxes, and nothing here is tax advice. For how to handle your 1099 income, deductions, and quarterly estimates, talk to a qualified tax professional.

Build it yourself, or skip straight to the finished file

You can absolutely build the version above over an afternoon and a few YouTube formula tutorials. But if you would rather spend that afternoon cleaning houses and getting paid, the 1099 Sheets Cleaning Business Tracker is already built for exactly this work. It comes with the recurring schedule and auto-calculated next visits, the restricted access tab for gate and alarm codes, the payments tracker, and the lifetime value dashboard, all set up and ready for your client list. It works in both Excel and Google Sheets, there is no app to learn and no login to remember, and it is a one-time $29. No subscription, no monthly fee, no per-cleaner charge. You buy it once, it is yours forever, and it never sends you another bill. Get the Cleaning Business Tracker spreadsheet for a one-time $29 here and keep the $700-plus a year an app would have charged you.

Cleaning Business spreadsheet

Stop renting your numbers.

The complete Cleaning Business spreadsheet: income, expenses and every deduction. One payment of $29, yours forever, no subscription.

Get it for $29