Most small teams don't lose deals because their product is wrong or their pricing is off. They lose deals because a lead came in, got a first reply, and then quietly fell through the cracks while everyone was busy. If you want to know how to track sales leads properly, the answer isn't a fancier tool — it's a small, boring system that makes forgetting impossible.
This guide lays out that system in three parts: capture every lead in one place with its source, qualify with a simple stage model, and schedule follow-ups so silence never happens by accident. You can run all of it in a spreadsheet to start. When the spreadsheet starts fighting you, I'll show where a CRM takes over.
The three jobs of lead tracking
A lead-tracking system only has to do three things well. If it does these, you'll close more of what you already generate:
- Capture — every lead lands in one place, with enough context to act on it.
- Qualify — you can tell at a glance which leads are worth your time right now.
- Follow up — no lead goes more than a few days without a next step, until it's clearly won or lost.
Skip any one of these and the whole thing leaks. Capture without follow-up means leads rot. Follow-up without qualification means you burn hours on tire-kickers. Let's build each piece.
Capture every lead with its source
The first rule: one inbox for leads, not five. If leads live in your email, your phone, a contact form, a notebook, and someone's memory, you don't have a system — you have five places to forget.
Pick a single home for every new lead. For each one, capture a small, consistent set of fields:
| Field | Why it matters |
|---|---|
| Name and company | So you know who you're talking to |
| Contact method | Email and/or phone |
| Source | Where the lead came from (referral, website, cold outreach, event) |
| Date received | So you can measure response time |
| What they want | One line on the need or request |
| Owner | Who is responsible for the next step |
The one field people skip and later regret is source. Tracking where leads come from turns guesswork into decisions. After a few months you'll see that referrals close twice as often as one ad channel, and you'll stop spending on the channel that only produces noise. You can't optimize what you never wrote down.
Do the capture the same day the lead arrives. A lead you'll "add later" is a lead you'll lose.
Qualify with a simple stage model
Not all leads deserve equal effort, and a raw list of names doesn't tell you which is which. A stage model fixes that — it's just a set of steps every lead moves through from first contact to closed.
Keep it short. Five or six stages is plenty for most small teams:
- New — captured, not yet contacted
- Contacted — you've reached out, waiting on a reply
- Qualified — they have a real need, budget, and timeline
- Proposal — you've sent pricing or a quote
- Won — closed and paying
- Lost — dead, with a one-word reason (price, timing, went silent, competitor)
Two habits make this powerful. First, actually mark leads Lost instead of letting them linger — a stalled lead pretending to be active is worse than an honest dead one. Second, capture the lost reason. "Went silent" showing up 40% of the time is a follow-up problem, not a pricing problem, and you'd never spot it otherwise.
A stage model also answers "what should I do next?" without thinking. A lead in Contacted needs a follow-up. A lead in Proposal needs a nudge. The stage tells you the action.
Make silence impossible with scheduled follow-ups
This is where nearly every lead-tracking effort dies. You reach out, they don't reply, and there's no mechanism that brings that lead back to your attention. So it disappears.
The fix is simple: every open lead must have a scheduled next step with a date. Not "I'll follow up sometime" — an actual task like "Call Dana re: proposal, Thursday." When you finish one step, you immediately book the next before moving on. A lead is never allowed to exist without a future action attached.
A reasonable default cadence for a lead that's gone quiet:
- Day 0: first outreach
- Day 2: short follow-up
- Day 5: value-add (send something useful, not just "checking in")
- Day 10: last attempt
- Day 14: mark Lost — "went silent" — and stop
Most sales come after several touches, so the teams that keep gently following up win business their competitors abandoned after one email. If you want a deeper walkthrough of the cadence, we wrote a whole lead follow-up system guide on it.
When the spreadsheet stops keeping up
A spreadsheet handles all three jobs — for a while. It breaks down once a second person is involved (who updated what?), once you have follow-ups to track (a sheet can't remind you), and once you want the history of every call and email in one place. That's the moment described in our CRM vs. spreadsheet comparison, and it's when a proper tool earns its keep.
This is exactly what crm-153 is built for, and it's genuinely free — no contact caps, no seat limits, no paid tier waiting to bite you, so it costs nothing to test the system above against it:
- Capture leads and their source with contact management — unlimited contacts, tags, owners, and search — and pull in an existing list via CSV import with email dedup.
- Run your stage model on a drag-and-drop sales pipeline. Move a card from Contacted to Qualified as it progresses, see per-stage value totals, and track won/lost with reasons.
- Kill the silence problem with tasks and reminders: every lead gets a next step with a due date, and you get automatic in-app and email nudges plus Today, Overdue, and Upcoming views.
- Keep the full history on a shared activity timeline — one-click logging of calls, emails, meetings, and notes — so your whole team sees who did what, thanks to unlimited team seats.
And because full CSV export is always free, your data is never held hostage. If you ever leave, you take everything with you.
Put it in place this week
You don't need a big rollout. Do this:
- Pick one home for leads and move today's leads into it — with a source on each.
- Define five or six stages and sort your current open leads into them.
- Give every open lead a dated next step. No exceptions.
- At the end of each day, clear your follow-ups and book the next one for each.
That's the whole system. It works in a sheet and works better in a tool that reminds you. If you'd like to compare options first, start with the best free CRMs for small businesses or how to choose a CRM. When you're ready to stop losing leads to silence, you can start free — no credit card, no trial clock.