THE SHORT ANSWER
Use columns that help you prepare the job, collect payment, and know what happens next.
A useful customer spreadsheet should show who the customer is, where the work happens, what was agreed, when the next appointment occurs, what it costs, whether payment arrived, and what follow-up is needed. If a field does not help you perform or manage the service, question whether you need to collect it.
THE ESSENTIAL COLUMNS
Start with seven groups of information.
Customer ID, full name, preferred name, mobile number, email, and preferred contact method.
Service address, unit, property type, approximate size, parking, and building-entry notes.
Service type, frequency, agreed scope, exclusions, priorities, and special surfaces.
Last service, next service, arrival window, assigned cleaner, and recurrence pattern.
Standard price, approved extras, discount, deposit, and the date the price was last confirmed.
Invoice number, amount due, due date, payment status, payment date, and method—never full credentials.
Confirmation sent, reminder sent, review request, next action, owner, and follow-up date.
STRUCTURE THE FILE
Use one customer row only when the business is still simple.
One row per customer works when each person has one service address, one normal price, and a predictable schedule. It becomes awkward when one customer has several properties, many completed jobs, changing prices, or unpaid invoices.
At that point, keep separate customer, job, and payment tables connected by the same customer ID—or move to software designed to link those records. Do not keep adding dozens of repeated columns such as Job 1, Job 2, Job 3.
MAKE IT ACTIONABLE
Add fields that tell you what needs attention.
New inquiry, estimate needed, estimate sent, booked, not moving forward, or follow up later.
Active, paused, one-time completed, former customer, or do not schedule.
Not invoiced, sent, due, partially paid, paid, refunded, or needs review.
The specific task, responsible person, and date it should happen.
PROTECT THE FILE
Keep high-risk information out of the worksheet.
Do not record full card or bank information, PINs, or security codes.
Do not store customer email, Wi-Fi, alarm-account, or portal passwords.
Use a restricted method or temporary code when possible, and remove it when service ends.
Avoid identity numbers, birth dates, and private information unrelated to cleaning.
KEEP IT RELIABLE
Build a ten-minute weekly maintenance habit.
- Resolve duplicates
Search for repeated phone numbers, emails, and addresses before adding another customer.
- Update next appointments
Make sure every active recurring customer has a visible next service date.
- Review unpaid work
Filter payment status and decide the next action for every open balance.
- Close finished follow-up
Mark completed reminders, review requests, and callbacks instead of leaving them ambiguous.
- Back up and restrict access
Keep a recoverable copy and remove access for anyone who no longer needs the file.
KNOW THE LIMIT
Upgrade when the spreadsheet requires repeated copying.
A spreadsheet remains useful while one person can update it consistently and see the complete workload. Consider a CRM or service-management tool when schedule changes require edits in several places, team members overwrite information, reminders are missed, or customer, job, invoice, and payment records no longer stay connected.