Apply to Work With Us
Online Businesses ▾
Side Hustles ▾
Passive Income ▾
Make Money Online ▾
Build & Start a Business ▾
Solopreneur ▾

A simple client record is one row per client with five things on it: who they are, what was agreed, what has been delivered, what is still open, and where the files live. A spreadsheet holds this perfectly well. The whole point is that it fits on one screen, takes a minute to update, and answers the question you will actually be asked, which is almost always "where did we leave it."

This article is general information about process and recordkeeping. It makes no claim about financial results of any kind. Anything touching legal, tax, entity, licensing, invoicing or insurance questions varies by jurisdiction and belongs with a qualified professional where you live.

Why a Spreadsheet Beats Memory

Memory is good at the client you spoke to yesterday and bad at the one you spoke to in March. It is also confidently wrong, which is worse than being blank, because you act on it.

When you are running something small around other work, the gaps between contacts are long. Four weeks between conversations is normal, and four weeks is well past the point where you remember whether you said you would send the second draft or they said they would send the brief. A written line removes that whole category of problem.

A spreadsheet in particular has three properties that matter here. It sorts, so you can see everything open in one view. It has one row per thing, which forces short entries. And it is boring, which means you will actually open it rather than admiring the layout.

There is a quieter benefit too. A written record means you can stop holding the state of every client in your head, and the hours you are not working stop being hours where you are half-remembering obligations.

The Five Columns, in Order

Resist the urge to add columns. Five is enough to be useful and few enough to stay current.

ColumnWhat goes in itWhat to leave out
WhoName, organization, how to reach themNotes about their personality
AgreedWhat you said you would do, and by whenLong descriptions of the work
DeliveredWhat has actually been handed over, with the dateThings nearly finished
OpenWhat remains, and who it is waiting onVague items like "follow up"
FilesWhere the work is stored, in plain wordsAnything that needs explaining

Two of these are routinely misused. Delivered should only contain things that have genuinely left your hands — "sent the final version on the 14th" — because a column that includes almost-finished work stops being a record and becomes an intention.

Open needs the second half of its job done properly: who it is waiting on. "Waiting on their feedback" and "waiting on me to write it" look identical in your head three weeks later and require completely different actions.

Where the Files Are Is a Real Column

The files column looks like the least important one and is usually the first thing you need. It exists because work gets stored in whatever place was convenient at the time, which means it is scattered by default.

Write the location in plain words that will still make sense in a year. A folder name and where that folder sits is enough. If the work lives in two places because something arrived by message and something else by mail, say both.

One rule makes this column reliable: one client, one home. Everything for that client goes in one place, even if it arrived from four directions, and the column names that place. The alternative is a column that lists four locations and therefore tells you nothing.

If something exists only as an attachment in a message thread, it is not stored. Move it before you write the row, or write "not yet filed" so the gap is visible rather than assumed.

What Makes a Simple Client Record Stay Current

Updating is the whole problem. The format is easy and the habit is not, so attach the update to something that already happens.

  1. Update at the end of the conversation, not later. Two minutes while it is fresh, before you close the window or put the phone down. Later is where records go to die.
  2. Give it a fixed slot. A short weekly pass through the record, in the same block every week, to catch anything missed and to read the Open column top to bottom.
  3. Write in the words you would use out loud. "Sent part one, they want changes to the second half" is a better entry than a tidy summary nobody can act on.
  4. Date everything. Every entry in Delivered and Open gets a date. Undated entries become unrankable within a month.
  5. Never leave a row half-updated. If you only have time for one column, do Open. It is the only one that changes what you do next.

The weekly pass is where a simple client record does the most work. Reading the Open column in one sitting surfaces the thing that has been sitting with you for three weeks, which is almost never the thing you were worrying about.

When a Simple Client Record Needs to Become Something More

A spreadsheet stops being enough at reasonably clear boundaries. Three signs are worth watching for.

More than one person updates it. Two people editing the same sheet produces conflicting rows and lost edits. At that point you need something with a real history of who changed what.

You need to see the same client across many separate pieces of work. When a client has eight distinct jobs over two years, one row cannot hold it, and stacking eight rows per client breaks the sort.

The record starts driving reminders. As soon as you want the Open column to tell you something on a specific future date rather than when you happen to read it, you have outgrown a flat sheet.

Until one of those three is true, upgrading mostly adds setup work and new places for things to hide. A sheet you maintain beats a system you abandoned, and the migration is far easier from a clean five-column sheet than from a messy one.

How the Record Rots

Records fail in predictable ways, and all of them are reversible if you catch them early.

The most common is column creep. A sixth column appears, then a ninth, each one reasonable on its own, until the row is too wide to update in a minute and you stop. Audit the columns twice a year and cut anything you have not read.

The second is the orphan row — a client you stopped working with whose row stays in the Open view forever. Mark the row closed with a date and move it below the live ones. Nothing gets deleted; it just stops competing for attention.

The third is the parallel note. You start keeping client details somewhere else as well, usually in a notes app or on paper, and now there are two versions and neither is right. Pick one home and fold the other into it the next time you touch the record.

Start the Sheet This Week

Open a blank spreadsheet, put the five column names across the top, and fill in a row for every client you currently have anything open with. For most people that is fewer than ten rows and takes under half an hour.

Then add two minutes of updating to the end of your next client conversation, and read the Open column once a week. That is the entire practice, and it replaces a surprising amount of low-level worry with a thing you can look at. If you want a ready-made column layout rather than building it from scratch, the Free Resources page on this site is the place to look.

Editorial & AI Disclosure