Skip to content
All posts

Lead Tracking Without a CRM: A Minimal Pipeline From Your Inbox

By Collen KrielClients & pipeline

You know that Sunday night feeling when you are hunched over your laptop, scrolling back through old emails, trying to work out whether you ever replied to that warm intro, while the kettle clicks and cools in the kitchen. Your family is waiting, your head is buzzing, and the thought pops up: "This is exactly the kind of thing I wanted to leave behind."

In corporate life there was always a sales team, a tracking tool, some poor soul keeping the system neat. We just did the work. Now every unread email is a maybe project and every missed follow-up is money left on the table.

Here's the good news. You do not need a full-on system to fix this. You can keep on top of your leads with three things you already use: your inbox, your calendar, and one spreadsheet. It will not turn you into a salesperson. It will simply stop good leads leaking through the cracks and give you your evenings back.

Why Your Leads Slip Through the Cracks

Most solo consultants are not short of leads; they are short of a way to keep track of them. The common failure points are boring and familiar.

  • Relying on memory and "I will remember to reply on Tuesday"
  • Starring or flagging emails then never checking the starred folder
  • A calendar that mixes dentist appointments, kids' clubs, and client meetings with no sign of lead follow-ups
  • No single place that shows who is at what stage

The cost is not just money. It is that low-level dread whenever someone asks, "Did we ever get back to them?" It is losing yet another evening hunting for "that LinkedIn message from that person in Berlin" and wondering what else might be hiding in your inbox. You feel busy, but not sure if you are busy with the right things.

Financially it adds up. Two or three missed follow-ups a month can easily mean one solid project drifting away every few months. For many independent consultants that one project is worth more than any tool. The problem is not that tools do not exist. It is that you do not want your quiet solo practice to feel like you have built a mini sales department.

A Simple Lead Path You Can Run From Your Inbox

Think of a "quiet" system as a simple path, not a big machine. Just clear steps from "new lead" through "chat booked", "proposal sent", "verbal yes", and "paid". No fancy features. Just enough structure so you always know who is where.

Start with email labels or folders. For example,

  1. Lead, New
  2. Lead, In Conversation
  3. Lead, Proposal Sent
  4. Lead, Waiting on Client
  5. Lead, Won / Lost

Whenever a new enquiry arrives, drag that email into "Lead, New". When you reply and a call is booked, move it to "In Conversation". Proposal goes out, move it to "Proposal Sent", and so on. It is the same inbox you already know, just with clear buckets.

A small naming habit helps. When you send anything important, tweak the subject line to include what it is: "Proposal, Website revamp, ACME" or "Follow-up, Strategy workshop". This makes search less painful later.

Then link your inbox to your calendar. Any time you promise to "circle back next week", add a calendar event at the moment you send the email. Treat follow-ups as small meetings with your future self:

  • "Follow-up, website revamp, Wed 10:00"
  • "Chase contract, retainer support, Tue 15:30"

Block 15 minutes. Drop the email link or a short note in the event description so you know exactly what to do.

Once a week, spend ten minutes tidying: move emails to the right label, add any missing follow-ups to the calendar, and clear anything that is now definitely lost. Quiet, boring, and effective.

One Spreadsheet To Track Every Conversation

Your inbox shows messages. Your calendar shows moments. You still need one place that shows the whole picture. That is your lead spreadsheet.

Set up columns like,

  • Name
  • Company
  • Where they came from (referral, LinkedIn, website, and so on)
  • Date of first contact
  • Stage (matching your email labels)
  • Next step
  • Estimated value
  • Last touched date

Each time a real lead appears, add one row. Update the stage and "last touched" whenever something happens. It takes less than a minute per lead.

Then use filters or colours to spot trouble. For example,

  • Colour any row where "last touched" is older than 14 days
  • Filter to show all "Proposal Sent" that have no decision noted
  • Sort by "estimated value" so big opportunities sit at the top

You can keep this very light. A bare-bones template for under ten live leads at a time can just have name, company, stage, next step, last touched. That is enough to stop leaks.

If your practice offers different services or retainers, add a few more columns like "Service type" or "One-off vs Retainer". That way you can see, at a glance, how your mix of work is shaping up. In truth, any proper client system is just this spreadsheet with reminders and nicer screens glued on.

Keeping Follow-ups Light, Human, And Fast

A lot of people left corporate partly to get away from feeling like they worked in sales. So the thought of "nurture flows" and "sequences" is not very appealing. You probably just want to remember when to gently nudge someone, in normal human language.

You do not need clever scripts. Simple lines like these work fine,

  • "Just wanted to check where this landed on your side."
  • "No rush on this from my side, I just did not want to drop the thread."
  • "Happy to park this for later in the year if that works better for you."
  • "If this has fallen down the list, that is completely fine, a quick yes or no helps me plan my time."

The trick is batching. Once a week, open your spreadsheet, filter for "Waiting on Client" or anything with "last touched" older than your comfort level, then,

  • Send five short follow-up emails
  • Update "last touched"
  • Add or adjust calendar reminders

That is it. Twenty to thirty minutes, once a week, instead of a little cloud of worry every evening while you refresh your inbox.

When A Simple System Is Not Enough Anymore

Over time you might feel your email-plus-spreadsheet setup starting to creak. Signs include juggling subcontractors, more than twenty live leads at once, different currencies or tax setups, or clients across time zones who all expect clear proposals and clean invoices. At that point you might start looking at more dedicated tools like Bonsai, HoneyBook, or Dubsado. Many of these tools are built with heavier workflows in mind and often lean towards US tax and banking.

Kiaro is designed as a quieter next step. It keeps the same simple feel as your inbox plus sheet, but joins up leads, proposals, contracts, time tracking, invoices, and payments in one workspace. The key bit is trust: AI suggests draft emails, proposals, and next steps based on your own data; you confirm, and nothing is sent or updated until you click. Kiaro does not replace an accountant, a lawyer, or your judgement; it just takes the busywork out of the admin you already do. When your single spreadsheet starts to sprawl across tabs and colours, it is usually a sign you are ready for a quiet upgrade rather than a heavyweight system.

Set Up Your Quiet Lead System in One Weekend

You can get all of this in place over one calm weekend, especially in late summer when clients are slower to reply and you finally have a bit of breathing room.

A simple plan,

  • Friday afternoon, create your email labels, tidy the inbox, start the calendar habit of turning follow-up promises into events
  • Saturday morning, build or copy the spreadsheet structure, tweak columns so they match your practice
  • Sunday evening, add your current live leads, mark honest stages, book a recurring 30-minute weekly review slot

The real pay-off is not the sheet or the labels. It is the quiet shift that happens when you trust your system more than you trust your inbox search bar. You stop waking up wondering who you have forgotten. Your evenings are no longer swallowed by anxious scrolling. And when you are ready to move into a fuller workspace like Kiaro, those tools can sit on top of habits you already trust, instead of trying to organise chaos from scratch.

Run your consulting business in one place

Kiaro brings time tracking, invoicing, proposals, and the client portal under a single AI command bar. Free to start, no credit card.

Start free