Cleaning Business Spreadsheet | Booking Schedule, Recurring Clients, Quote Calculator and Team Pay Tracker

Three cleans today, two crews out, and a client from Tuesday still hasn't paid. Which recurring clean was due yesterday? What should this deep clean actually cost? And at the end of the month — after cleaner pay, supplies, fuel and laundry — what did the business really keep?

Most cleaning spreadsheets stop at a client list or a calendar. This one runs the whole operation: your clients and their access notes live in one register, every booking moves Booked → Confirmed → Completed → Paid on one board with balances that figure themselves, recurring cleans flag their own next due date before one slips, every quote is priced from its true cost at your target margin, supplies flag themselves before you run out, and cleaner pay rolls into a monthly profit-and-loss by itself. In the sample month inside, the business books $4,330 of work and earns $3,200 of it — and three finished cleans are still owed $370, because one client never paid, one paid short, and one simply hasn't been chased yet. Booked is not the same as banked. The sheet knows the difference.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 7 TABS

• Start Here + Dashboard — plain-English quick start, the two settings that run the whole sheet (your target margin % and your cleaner labor rate), and a live dashboard: jobs today, jobs this week, revenue this month, unpaid balances for work already done, repeat-client count and jobs completed

• Client Register — one row per client: address, access notes (gate codes, lockboxes, alarms, pets), home size, bedrooms and bathrooms, how often they book, their rate per clean, and when they started

• Booking & Schedule Board — one row per job: date, client, service, team or crew, arrival window, and a status that walks the pipeline Booked → Confirmed → Completed → Paid. Balance Due figures itself from Amount minus Paid, so finished-but-unpaid work never hides

• Recurring Schedule — your standing weekly, biweekly and monthly cleans. Next Due figures itself from Last Clean and Frequency, and the flag reads OVERDUE once a due date passes, DUE SOON within 3 days, SCHEDULED beyond that — update Last Clean after each visit and the board stays current by itself

• Quote Calculator — beds, baths, square feet and clean type in; base price off the rate card, extras, estimated cleaner-hours, true cost, a suggested price that protects your target margin, and the real margin on the price you actually quote — flagged AT or BELOW TARGET before you send it

• Supplies & Inventory — your stock room in one tab: unit costs, on-hand counts, par levels, the exact amount to order, an OK / ORDER SOON / OUT status, and your total stock value

• Team Pay & Monthly P&L — one row per cleaner per job: hours times that cleaner's rate is pay due, figured for you. Pay totals itself by cleaner, expenses log alongside, and the monthly P&L rolls revenue, cleaner pay and expenses into profit and profit margin by month, by itself

HOW THE PIPELINE WORKS

A booking starts as Booked, becomes Confirmed when the client locks it in, Completed when the clean is done, and Paid when the money lands in full. Anything sitting at Completed with a balance is work you have done and not been paid for — the Dashboard totals exactly that as your unpaid balances, so the chase list is always in front of you.

HOW QUOTES ARE FIGURED — ONE METHOD, NO HIDDEN MATH

Base Clean = (square feet × the per-sqft rate for the clean type) + $10 per bedroom + $15 per bathroom. The rate card on the Quote Calculator starts at $0.07 Standard, $0.10 Deep, $0.12 Move-In / Move-Out. Estimated Hours = sqft ÷ 450 + 0.25 per bedroom + 0.5 per bathroom (cleaner-hours). True Cost = estimated hours × your labor rate (Start Here) + supplies per clean. Suggested Price = true cost ÷ (1 − target margin), so at the suggested price the margin you aimed for is the margin you keep. Your Quoted Price is always yours to set — the sheet just shows you the true margin it really earns and flags anything below your target. The manager starts at a 60% target margin and $18/hour for cleaner time; change either in one shaded cell on Start Here and every price, margin and flag follows it.

THE SAMPLE MONTH

It comes loaded with one fictional month (Sparkle & Shine Cleaning Co., October 2026 — 12 clients, 26 bookings, 3 cleaners) so you can watch every formula work before you delete the samples and type your own: the Okafor biweekly sitting OVERDUE on the recurring board, paper towels OUT on the supply shelf, and a deep-clean quote that keeps 61.48% at $405 against a $390 suggested price. Formulas are pre-filled down the columns — 30 register rows, 40 booking rows, 20 recurring rows, 30 supply rows, ready to go.

A FINISHED FILE, DELIVERED INSTANTLY

You receive the finished spreadsheet file exactly as shown — open it, add your own jobs and customers, and use it right away. It is a complete digital file delivered to you, not a service and not a setup project. Nothing about the file is customized, personalized or built to order. If you ever find a genuine error in a formula or a number, tell us and we will send you a corrected copy of the file, free, forever.

REQUIREMENTS: a free Google account. Your manager lives in Google Sheets — nothing to install, and the day's board is right there on your phone between cleans.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.