How to keep track of jobs without a spreadsheet

Most one-person businesses lose track of jobs for one reason. The job lives in five places at once. They are a text thread, a notes app, a spreadsheet tab, a stack of paper quotes and memory. Nothing is wrong with any one of those tools. The problem is that no single one of them has the whole picture.

Just starting out? Your first jobs shows which habits to add first.

Track the job, not the document

A spreadsheet tracks rows. It does not track a job that moves through stages. So it stops working when you have more than a couple of jobs going. You have no obvious place to see what is waiting on you right now. You also cannot see what you are waiting on someone else for. A better system tracks each job as one thing with a status. The status runs from first request to paid:

• Requested. Someone asked. You have not quoted it yet.
• Quoted. The number is out. You are waiting on a yes.
• Scheduled. They said yes and it is on the calendar. See when the client says yes.
• In progress. You are doing the work.
• Invoiced. The work is done and the bill is out.
• Paid. Done, actually done.

That is six stages, one job and one status at a time. Look at your list. Which jobs have been stuck at “quoted” for two weeks? Each one is a follow-up you were about to forget.

A “scheduled” job does not always stay on its first date. A client may ask to move it, or may not show. That is still an update to the same record. It is not a fight to start from scratch. See cancellations and no-shows for the notice window and the wording to have ready before it happens. If two jobs land on the same “scheduled” slot, see double-booked for the fix.

Keep client history in one place, not your memory

A spreadsheet also fails at context. What did this client ask for last time? What did you charge? Did they pay on time? When that lives in your head, it works fine. Then a client you have not heard from in eight months calls, and you are guessing. A simple client record needs almost nothing:

• Contact info. Phone, email and address. Keep the basics in one place, not scattered across old text threads.
• Every past job, with what you quoted, what you invoiced, and whether the client paid on time. The last part matters more than people think. A client who is always a little late is worth a deposit next time, not a surprise.
• Notes that would otherwise live in your head. “Prefers text over calls,” “gate code is 4471,” “always asks about a discount.” These are small things. But they make you look organized when you remember them without asking.

Not ready to track jobs on a screen at all? The free, printable client card holds the same things on one page per client. It has contact details, billing notes and a job-history table. The week planner covers the “what is on this week” half of the same problem. Paper works fine for one binder’s worth of clients. Move toward the six-stage system above when paper stops working.

Make the paperwork follow the job, not the other way around

A spreadsheet feels necessary for one reason. Quotes, invoices and client notes usually live in separate tools that do not talk to each other. Track the job as one thing instead. See how to write a quote that wins the work for getting the first document right. Then the quote, the invoice and the client history can all hang off that one record. You do not retype them into a new place at every stage. A system is not a pile of documents that happen to be about the same job. In a system, everything about a job stays connected from the first request to the last payment. This includes what is written on the invoice it turns into (see what to put on an invoice).

You do not need software to start. A notebook with one page per job works, if each job has a status and you check the notebook weekly. The habit is what matters. The tool is whatever makes the habit easiest to keep.

Track the job as a whole, not the paperwork it produces. Then “what am I forgetting” stops being a question you ask yourself every morning.

Not sure whether tracking is your weakest stage, or whether something earlier in the job is? The free admin health check scores all five stages, quoting through follow-up, in two minutes. It tells you which to fix first.

That same record tells you when to check back in with a client. A seasonal service or an annual job is another follow-up that waits on a date. See what to do after the job for the thank-you, review, referral and check-in messages. They keep a finished job from being the last one.