How to Keep Track of Client Follow-Ups Without a Complicated CRM

Learn a simple system for tracking client follow-ups, next actions, waiting items and promises without building a complicated CRM process.
May 7, 20269 min read
Short answer: for every client or prospect, write down the last thing that happened, the next thing that should happen, the date, and who has the ball. Then work from one list sorted by date. A spreadsheet is fine to start.With three or four clients, your head does the job. Somewhere around eight or ten it stops working. A proposal from last Tuesday, an "I'll send that tomorrow" from a call, a half-answered email about budget. They don't disappear, they just slide out of view. And it's always the important ones that slide.Writing the follow-up email is rarely the problem. Most people can do that in two minutes. The problem is remembering who needs one, why, and when. Here's a small system that answers those three questions, and it takes about 15 minutes to set up.

Five things worth tracking

Forget the 40-field CRM template. For each client you only need:
  1. Last interaction: what happened most recently
  2. Next action: the specific thing that should happen next
  3. Owner: you, a teammate, or the client
  4. Due date: when it should happen
  5. Waiting on: is the ball with you or with them?
For four clients it looks like this:
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
Four rows, and you already know more about your week than your inbox could tell you.

"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.
A verb, a person, a topic. If you can act on it without opening the old thread, it's written well.There's a side benefit that has nothing to do with clients. Unfinished tasks tend to keep pulling at your attention, but research suggests a specific plan is enough to quiet them. In a series of experiments, people with an unfinished goal had more intrusive thoughts and did worse on unrelated tasks, and writing a concrete plan for that goal removed the effect (Masicampo and Baumeister, 2011). A written next action with a date is exactly that kind of plan. It's why a good follow-up list makes evenings feel lighter, not just mornings more productive.

"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
Then the routine is boring in a good way. Open the list, start at the top, do the thing, set the next action, move on. For most small agencies that's ten minutes, not an hour of inbox archaeology. For how to decide what goes first, see the next-action method.

Setting it up

If you're starting from zero, block 15 minutes and do this once:
  1. List every client and open prospect, including the ones you're waiting on.
  2. For each, scroll back to the last real conversation and note what happened.
  3. Pick the next action and give it a date. Not sure? Write "decide next step" and date that.
  4. Mark who has the ball.
  5. Sort by date and clear the overdue ones first.
Fair warning: you'll probably find two or three follow-ups that are already late. That's normal, and it's the whole point.

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.
Mix the two in one undifferentiated list and you'll treat them the same way, which usually means chasing clients for things you actually owe them, or sitting politely on things they're blocking. When you sort each morning, do "ball with you, overdue" first, always.

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:
  1. 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.
  2. 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").
  3. 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.
  4. 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 list you trust with 12 honest items beats a list of 40 you've learned to ignore.

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.
Anything that doesn't fit is a gap. A proposal with no follow-up date. A client who promised files, with no check-in. An update you promised, with no reminder. Those are the ones that bite.

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

AwiFin client list with demo data: every client shows its stage, next action, due date and value, with overdue and due-today items highlighted
AwiFin client list with demo data: every client shows its stage, next action, due date and value, with overdue and due-today items highlighted
We built AwiFin around one question: "what does this client need from me next?" Every client has one main next action. Overdue and waiting items float to the top, and when it's time to write, AwiFin can draft the message from the client's history.Keep your project tool for delivery and your CRM for deals if you like them. AwiFin just makes sure the next step with each client doesn't get lost.

Sources

Was this article helpful?One click, no sign-up needed.
Turn next actions into progressTrack every follow-up. Prepare your next message.
TagsAgency workflowClient communication
DM
Written by Dariusz M.AwiFin founder writing practical workflows for small agencies.
More articles →