You started with a phone and a notebook. Now the notebook is three notebooks, a text thread with your helper, a calculator app, and a bank account you check to see whether a customer paid. Jobs get missed. A quote from last week you cannot find. Someone you promised to call back never got the call. How to keep track of jobs and customers is the first real system problem a growing service business hits, and the honest answer is: start with a spreadsheet. Here is one that works and where it stops working.
How to keep track of jobs and customers: a free tracker
You do not need to buy anything to get organized this week. Open a spreadsheet in Google Sheets or Excel and build two tabs: Customers and Jobs. That is the whole system, and it beats a notebook the day you build it.
The Customers tab is one row per customer: Name, Phone, Email, Address, How they found you, and Notes — the gate code, the dog that bites, the fact that they always pay late. The Jobs tab is one row per job: Job number, Customer name, Date, Work, Quote amount, Status, Invoice number, Amount paid, and Next action. That last column keeps money from falling through the floor.
Why two tabs, not one
A good customer books you more than once. Put jobs and customers on the same tab and you either re-type the customer’s details on every job or lose their history. Two tabs linked by name keeps one row per customer and one per job — the same shape real software uses.
How to set it up so it stays useful
A tracker only helps if it stays current, and it only stays current if updating it is a habit. A few rules separate a sheet you trust from one you abandoned in March.
Number every job
Give each job a number the day it comes in — 2026-001, 2026-002, and up. That number ties a quote to an invoice to a payment later. Never reuse one.
Use a fixed status list
Pick five words and only type those: Lead, Quoted, Scheduled, Done, Paid. Make the Status column a dropdown so nobody invents "pending-ish." Then you can filter to "everything I quoted but nobody paid."
Fill Next action on every open row
Every job that is not Paid gets a next action and a date: "call to schedule 3/14," "send invoice," "follow up on quote." Sort by that date each morning for a ready-made to-do list.
Update it at one fixed time
End of the day, or first coffee. Five minutes. The sheet is only as good as your last update, so make it routine.
Run that for a month and you will keep track of jobs and customers better than most shops twice your size. A spreadsheet is the right tool for a solo operator or a two-person crew. The trouble starts when you outgrow it, and it shows up in four specific places.
Where a spreadsheet breaks: two people editing at once
The day you hire a helper, the spreadsheet develops a split personality. You update a job on your phone in the truck; they mark the same job on the laptop at home. One saves over the other, and now there are two versions with no way to know which is right. Shared cloud sheets help, but they do not fix the deeper problem: a spreadsheet has no idea who is allowed to see what. Your helper can read the margin on every job — there is no way to hand a tech the schedule without also handing them the finances, because it is all one grid.
Where it breaks: no follow-up reminders
The Next action column is a manual reminder. It works right up until you are too busy to read it — exactly when you are busy enough to lose the follow-up. A spreadsheet cannot text a customer three days after a quote goes out, nudge you when a job has been Done for a week and never got invoiced, or ask for a review when the work is finished. A quote you never chased is a job you probably lost; an invoice you forgot for two weeks is two weeks unpaid. A sheet chases nothing for you.
Where it breaks: quote and invoice numbers drift apart
In a spreadsheet, the quote lives in one document, the invoice in another, and the number tying them together lives in your head. You quote $4,200 and fat-finger $2,400 onto the invoice, or forget the add-on the customer asked for. Nobody re-reads it. You just got paid short.
Every place you re-type a number is a place it goes wrong, and a spreadsheet is nothing but places to re-type. The quote total, the Jobs-tab row, the invoice, and the deposit are four hand-entered copies of one figure. When they disagree, you cannot tell which was right.
One number, entered once
The reason to graduate from a spreadsheet is to stop re-typing the same total. In Mortar a quote is calculated once and becomes the invoice untouched — the number you priced is the number you get paid. Nothing to reconcile, because nothing is copied.
Where it breaks: no P&L
You can sum a Paid column, and that tells you revenue. It does not tell you profit. Profit is revenue minus what you spent — materials, fuel, subs, the truck payment, software — and a spreadsheet will not gather that for you. So most operators fly blind until the accountant reports in March how last year went, far too late to change anything.
You can build a P&L by hand, and some do — but now you are maintaining a second sheet, keying in every expense, and reconciling it against the bank yourself. That is the kind of job that does not get done when the phone is ringing. For the plain-English version of what that statement tells you, read how to read your profit and loss statement.
The specific triggers that mean it's time to switch
Do not switch because a blog told you to. Switch when the spreadsheet actively costs you more than software would. The signals, in the order they show up:
- A second person is editing the sheet. Now you need shared records with per-person permissions — the tech sees the schedule, not the margins. A spreadsheet cannot do that split.
- You lost a job to a missed follow-up. A quote that went cold because nobody chased it is the reminder a spreadsheet cannot send, costing you real money.
- A number came out wrong on an invoice. The first time a re-typed total gets you paid short, the re-typing is no longer free.
- You cannot answer "did I make money last month?" without a weekend of spreadsheet work. You have outgrown summing a column.
- You spend hours a week moving numbers between apps — the sheet, the calculator, the invoice, the bank. Those hours are the subscription, paid in your own time.
When two or three of those are true at once, software stops being a nice-to-have. The point of the move is not more features — it is one shared record per job so two people never overwrite each other, follow-ups that fire on their own, a quote that becomes the invoice without re-typing, and a cash-basis P&L off the same data. For the full walkthrough, read how to run a service business, then see the shape of the software in what a field service CRM should actually do.
How do I track service jobs in a spreadsheet?
Build two tabs — Customers and Jobs — one row each. Number every job, use a fixed five-word status list (Lead, Quoted, Scheduled, Done, Paid) as a dropdown, and keep a Next action column with a date on every open row. Update it once a day. That covers a solo operator or a two-person crew.
When should I stop using a spreadsheet to manage my home service business?
When a second person starts editing it, when you lose a job to a missed follow-up, when a re-typed total gets you paid short, or when you cannot tell if you made money last month without hours of work. Any two at once means it costs you more than software would.
Is a spreadsheet good enough to keep track of jobs and customers?
For one person, yes — a well-built spreadsheet beats a notebook and costs nothing. It breaks on four things: two people editing at once, follow-ups it cannot send, numbers that drift when you re-type them, and a real P&L it cannot assemble. Those are the reasons to move, and not before.
Building Mortar — the all-in-one CRM for service businesses. One shared record, one number behind every job.