Five things worth tracking
Forget the 40-field CRM template. For each client you only need:- Last interaction: what happened most recently
- Next action: the specific thing that should happen next
- Owner: you, a teammate, or the client
- Due date: when it should happen
- Waiting on: is the ball with you or with them?
ClientLast interactionNext actionOwnerDue
NorthwindProposal sent MonFollow up if no replyYouThu
AcmeAsked for revised scopeSend updated scopeYouToday
BrightlineApproval requestedCheck for approvalYouFri
VertexPromised brand assetsCheck whether assets arrivedYouMon
"Last contact" and "next action" are different things
This one trips up almost everyone. You emailed a client yesterday, so you write "emailed yesterday" and feel done. But that's history. It doesn't tell future-you what to do.Store both. Last contact: "sent revised proposal." Next action: "follow up Friday if no reply." Now the decision is already made when Friday comes around.Write actions you can do half-asleep
"Follow up with Acme" looks fine on Monday. On Thursday you stare at it and have to dig through three email threads to remember what it was about.Try this instead:- Ask Maya whether the revised homepage is approved.
- Send James the progress update promised on Tuesday's call.
- Ask Priya for the missing product images.
"Waiting" is not "done"
You asked for approval. Your part is done, so you tick it off. Three weeks later you realise nobody ever approved anything and the project has quietly stalled.Waiting items need two things written down: what you're waiting for and when you'll look again.Waiting for homepage approval. Check Thursday. If nothing, send a short nudge.
One list, every morning
Once the data is there, stop opening client records one by one. Use a single list split into four groups:- Overdue: should have happened already
- Today: needs doing now
- Waiting: with the client, each with a check date
- Upcoming: the next few days, so nothing sneaks up on you
Setting it up
If you're starting from zero, block 15 minutes and do this once:- List every client and open prospect, including the ones you're waiting on.
- For each, scroll back to the last real conversation and note what happened.
- Pick the next action and give it a date. Not sure? Write "decide next step" and date that.
- Mark who has the ball.
- Sort by date and clear the overdue ones first.
The column that matters most: who has the ball
If you only add one column, make it "Waiting on." It changes what the date means.- Ball with you: the date is a deadline. Missing it means you broke a promise.
- Ball with them: the date is a check date. Missing it means you lost track, but nobody is upset yet.
When the overdue list is already 30 items long
Every system eventually falls behind: a launch week, a holiday, a sick kid. The mistake is trying to clear thirty overdue items in one heroic morning. You'll do the easy ones and skip the ones that matter.Do a reset instead:- Sort by what's at risk, not by date. Open proposals and things blocking a launch first. "Send a nice article to an old client" last.
- Delete honestly. Anything you know you won't do, remove it. If it was a promise, tell the client (one line: "I said I'd send X, I won't get to it this month").
- Batch the apologies. For anything you owe and are late on, send a short note today with a new date. People forgive a late item with a date. They don't forgive silence.
- Spread the new dates over the next five working days. If you move all 30 to "today," tomorrow you'll have 30 overdue items again and you'll stop trusting the list.
A 20-minute weekly reset
The daily list catches today. A short weekly pass catches drift:- Any client with no next action at all? Give them one, or mark "nothing needed" on purpose.
- Any date that's been moved three times? It's not a scheduling problem. Either do it, delegate it, or drop it and say so.
- Any waiting item older than two weeks? Change channel or change the question. Another identical email won't work.
- Any client you haven't spoken to in 30+ days who is still active? Put a check-in on the list.
Spreadsheet or software?
A spreadsheet handles the first ten or so clients just fine. Columns: Client, Contact, Last interaction, Next action, Due date, Waiting on, Notes. Sort by due date and you're done. Ready-to-paste formulas are in CRM vs spreadsheet for client follow-ups.It starts to creak when you forget to update dates, when a teammate needs the same view, or when you want the context in front of you while writing the message.A full CRM can fix that, but be honest about your stack. Many small agencies already have a CRM for deals, ClickUp or Jira for delivery, Notion for docs and Gmail for everything else. One more big system is often just one more place to forget to update. The question worth asking is simpler: where do I see everything that needs me today?A quick gap check
Every active client should be in one of these states:- You owe them something.
- They owe you something.
- You'll contact them on a set date.
- Nothing is needed, and you decided that on purpose.
Mistakes we see a lot
- Logging activity instead of actions. A perfect record of the past still doesn't tell you what to do tomorrow.
- "Follow up soon." Soon never arrives. Pick a real date, you can move it later.
- Too many fields. If updating takes longer than the follow-up itself, you'll stop updating.
- No habit. The list only works if you actually open it every morning.
Common questions
How often should I follow up with a client?
It depends on what you're waiting for. After a proposal, a few business days. For an approval with a deadline, the day before. For a happy client with nothing open, a light check-in every few weeks. What matters is that you chose the date, not that it fits a schedule.What if a client keeps going quiet?
Stop sending the same message again. Change the question. Ask if priorities shifted, or give them an easy way to say "not now." Then set a later date and let it rest. The full sequence is in how to follow up with a client who hasn't replied.Do I need software for this?
No. A spreadsheet and a morning habit will get you surprisingly far. Software earns its place when keeping the dates current becomes the hard part.Running this system in AwiFin

Sources
- E. J. Masicampo and R. F. Baumeister, Consider it done! Plan making can eliminate the cognitive effects of unfulfilled goals, Journal of Personality and Social Psychology, 2011.