How to Track Leads Without a CRM

Track leads without a CRM by writing down four things about every enquiry: who they are, what they asked for, the single next action, and the date that action is due. That is the whole record. Put it in a spreadsheet, a notes app, or a task list with dates, and review it twice: once at the moment a lead arrives, and once a week when you read every row that is overdue. Lead tracking fails on the fifth field, not the fourth. Source, stage, deal value, and probability turn a ten second entry into a form, and a form is the thing you skip on a busy Tuesday.

What is a lead record for?

A lead record has exactly one job: to make sure the next conversation happens.

That is worth sitting with, because almost every lead tracking system you can download is built for a different job. Pipeline forecasting, attribution, territory splits, and rep performance are real problems for a sales team of nine. They are not your problem. If you are the person who answered the phone, quoted the job, and will do the work, the only failure mode that costs you money is a person who asked you for something and never heard back.

That failure is common because it is silent. Nobody complains about a quote you forgot to chase. They just book with the other outfit. You find out months later, if at all, when you notice the month was quiet and cannot say why.

So the test for any lead tracking method is narrow. Does it reliably surface the person you are supposed to contact, on the day you said you would contact them? Everything that does not serve that test is decoration, and decoration is not free. It costs entry time, and entry time is what kills the habit.

This matters more than the templates suggest, because most businesses are one person deep. Businesses with no paid employees account for 78.4% of all US businesses according to Census Bureau data for 2023. The person entering the lead is the person doing the work, and their spare capacity for admin at 6pm is close to zero.

Which four fields are enough?

Four. Here is the record, and what each field is actually doing.

Field	Example	Why it earns its place
Who	Dana Reyes, 555 0142	You cannot follow up with a person you cannot reach. Name plus one contact method, whichever one they used to reach you.
What they asked for	Quote for back deck rebuild, approx 20x14	Context you will have completely forgotten in eleven days. This is what turns a cold "just checking in" into a real message.
Next action	Send revised quote with cedar option	One concrete thing you will do. Not a status, an action, phrased so a tired version of you knows what to do without thinking.
Next date	Sep 4	The field that does the actual work. Without a date, a lead is a wish. With one, it resurfaces on its own.

Two rules make those four fields hold up.

Next action is singular and physical. "Follow up" is not an action, it is a category. "Call about the cedar upgrade" is an action. The difference shows up on the day the record surfaces: one of them makes you re-open the whole situation and decide what to do, the other one you just do.

Next date is never blank. Every live lead has a date, always. If you genuinely do not know when to chase, pick a date anyway and change it later. A dated record that turns out to be premature costs you thirty seconds. An undated record costs you the lead, because undated records are invisible.

That is the checklist. Four fields, both rules, and a place that will show you the overdue ones without being asked. In SMBDashboard that place is the task list, where each enquiry goes in as a task with a date and overdue items highlight themselves, but the structure is the point and it works in a spreadsheet just as well.

Which fields quietly kill the habit?

Now the useful half, which nobody publishes: the fields that look responsible and end the system inside a month.

Field that feels useful	What it costs	What to do instead
Source	A decision at entry time, every time, with fuzzy categories ("Google" or "referral" when a referral googled you)	Nothing, at first. If you later want to know where work comes from, ask new customers one question when they book and tally it monthly.
Stage	A judgement call that changes nothing about what you do next	The next action already encodes the stage. "Send quote" and "chase deposit" are stages, expressed as work.
Deal value	A number you are guessing before you have scoped the job, which then anchors you	Leave it out until you send a quote. At that point the quote is the number, and it lives on the quote.
Probability	Invented precision, and demoralising to maintain	Nothing. Nobody has ever won a job by grading it 40%.

The pattern is the same in all four rows. Each field asks you to make a decision at the exact moment you have the least appetite for one, which is right after a phone call, standing in a driveway, with the next thing already waiting. Four fields is a ten second entry you will do standing up. Eight fields is a form, and a form gets postponed until later, and later is where leads go to die.

There is a second cost that is easier to miss. Fields you maintain badly are worse than fields you never had, because a half-filled stage column makes the whole sheet feel untrustworthy, and a sheet you do not trust is one you stop opening. The same logic applies to choosing a spreadsheet over a CRM in the first place: capacity you will not use is not neutral, it is drag.

If you are already sure you want something more structured than a sheet, the honest version of that conversation is whether a simple CRM is enough rather than which platform has the most features.

When do you review the list, and for what?

Two moments. That is the entire cadence, and both of them are short.

• At the moment of the enquiry, within sixty seconds. Four fields, entered before you do anything else. This is the one that decides whether the system works, because a lead you meant to write down later is a lead you did not write down. Speed matters on the outbound side too: Harvard Business Review's study of how quickly companies respond to online sales leads found most were not responding anywhere near fast enough, and the first slip is usually the record that never got made.
• Once a week, for ten minutes, reading only what is overdue. Sort by date, look at everything past due, and give each row one of three outcomes: do it now, move it to a new date on purpose, or close it out. Nothing else gets touched. Live leads with future dates are not your business this week.

That weekly pass slots naturally into a one page weekly review alongside the money and the appointments, and it is the same discipline as a follow up system that stops things falling through. What makes it survivable is that you are not reviewing the pipeline. You are reviewing a short list of things that were due and are not done, which on a normal week is four or five rows.

The failure mode to watch for is the row that keeps getting bumped. If a lead has been rescheduled three times without a real conversation, the bump is not a plan, it is avoidance, and the next section is about calling that.

How do you tell a stalled lead from a dead one?

A stalled lead is one where you owe the next move. A dead lead is one where they do, and they have not made it.

That single distinction does more work than any stage column, because it tells you who to chase. If the next action is yours ("send the revised quote", "price the cedar option"), the lead is not cold, you are the bottleneck, and no amount of follow up technique fixes it. Do the thing.

If the next action was theirs, the useful signal is contact attempts without a response. A workable rule for a small business:

• Two attempts, no reply, on different channels and a week apart. Normal. Keep the record, set a date.
• Three attempts, no reply, across three weeks. Send one closing message that makes it easy to say no ("assuming the timing did not work out, happy to pick it up whenever"), then set the date out ninety days or close the record.
• They replied and asked you to check back later. Not stalled at all. Take them at their word, set the date they named, and put what they said in the "what they asked for" field so the follow up references it.

Closing a record is not losing. It is the thing that keeps the list short enough to read, which is what keeps you reading it. A list of eleven live leads gets reviewed weekly. A list of ninety, most of them ghosts from March, gets avoided.

One boundary worth knowing: if your follow up is email based, commercial messages in the US come with rules about honouring opt outs, and the SBA's guidance on marketing and sales is a reasonable starting point for the wider compliance picture. When someone asks you to stop, stop, and close the record.

When does a lead become a customer record?

At the moment money is agreed, not at the moment work is finished.

The reason to move them is that the questions change. A lead record answers "when do I contact this person next". A customer record answers "what have we done together, what did they pay, and when did I last hear from them". Those need different fields, and keeping a won lead in the lead list means either your lead list slowly grows customer fields or your customer history has a hole at the front.

The handover is small: create the customer, paste the "what they asked for" line into their notes as the origin of the relationship, and close the lead record. In SMBDashboard that means the enquiry stops being a task and becomes a row in the customer list, where the job, the payments, and the last contact date live together. If you are running solo, how a CRM changes for a one person business covers what that record actually needs, and tracking sales without software covers the money side of the same handover.

The practical version of all of this: put each new enquiry in as a task with a date, and let the overdue ones highlight themselves. You can do that free in the task manager or alongside a customer list in the free CRM. There is no account to create, and your data stays in your browser unless you turn on Pro sync. The free tier holds 25 customers, 200 money entries, and unlimited tasks, which is more lead tracking than most small businesses have running today.

Frequently asked questions

What should a lead tracking spreadsheet include?

Four columns: name and one contact method, what they asked for, the next action, and the date that action is due. Add a fifth column only when you have a specific question you are trying to answer with it and you are willing to fill it in every single time. Most lead tracking spreadsheets fail because they start with twelve columns copied from a template built for a sales team, and a twelve column row takes long enough to fill in that you eventually stop filling it in.

How often should I review my leads?

Twice, on two different clocks. Every new enquiry gets entered within a minute of arriving, and once a week you read the overdue rows and give each one an outcome. Ten minutes weekly is plenty for a list that is properly closed out. If your weekly pass is taking half an hour, the problem is usually dead records you have not closed rather than too many live leads.

When should I stop following up on a lead?

When you have made about three attempts across roughly three weeks with no response of any kind, send one message that makes it easy for them to say no, then either push the record out ninety days or close it. Stop immediately if they ask you to. The point of closing is not giving up, it is keeping the list short enough that you actually read it, and a lead that goes quiet in March is not the same person as a lead that went quiet last Tuesday.

Do I need a pipeline with stages?

Not until more than one person has to know where a deal stands without asking you. Stages exist to communicate status across a team and to forecast revenue in aggregate. If you are the only one working the leads, the next action field already tells you the stage in the only form that changes your behaviour, which is what you have to do next and when.