Prospect tracker template that works

Every prospect tracker template I have ever downloaded has died the same death. Week one it is beautiful. Week two there are four rows with a status of "Contacted" and no memory of what contacting them involved. Week three I stop opening it and go back to scrolling my sent folder like an idiot.

That is not a discipline problem. It is a design problem. Most templates are built to report upwards, so they are full of columns a manager would want in a pipeline review: stage, probability, forecast value, close date. If you are the person actually doing the prospecting, none of those columns tell you what to do when you sit down on a Tuesday morning with forty minutes and a coffee.

So the template below is built backwards from that Tuesday morning. It is boring on purpose.

Status columns are where prospect trackers go to die

A status column asks you to summarise a relationship as one word. "Contacted." "Nurturing." "Warm." Those words feel like information and carry almost none.

Two prospects can both sit at "Contacted" when one of them replied asking for pricing on Friday and the other got a cold email nine days ago and has never heard of you. If your tracker treats those two rows identically, the tracker is lying to you, and you will either work the wrong one or work neither.

Worse, a status column ages badly in a way that is invisible. Nothing in the row changes when a week passes. The spreadsheet looks exactly as healthy on day thirty as it did on day one, which is how you end up with a pipeline that is technically full and practically empty.

Replace it with two columns that cannot lie: the next action, and the date you promised yourself you would take it.

The columns that earn their place

Column	What goes in it
Company	The account, not the person. One row per account.
Contact	Name and role. Role matters more than the name.
Next action	A verb and an object. "Send the Q3 numbers", not "Follow up".
Next action date	A real date. Never blank.
Last touch	What you actually did and when, in your own shorthand.
Source	Where they came from. Referral, inbound, cold, event.
Why now	One line on what makes this live this month.
Notes	Everything else, newest at the top.

Eight columns. That is the whole thing. You can build it in Sheets in ten minutes and it will outlast every prettier template you have tried.

Two of those columns do almost all the work.

The next action column has one rule: if you cannot write a verb and an object, you do not have a prospect, you have a name. "Follow up" is not a next action. "Send the two-page version of the proposal with the integration section cut" is a next action, because future-you at 8:40am can do it without thinking. I have caught myself writing "check in" on a row and what that really meant was "I have no idea why I am still tracking this company", which is useful to find out.

The next action date column is the one that turns the sheet into a to-do list. Sort by it ascending and the top of your sheet is your morning. Everything with a date in the past is a promise you broke, which stings enough to fix. If a row has no date, it should not be on the sheet.

The "why now" column is the one people cut first and it is the one that saves deals. A prospect who is hiring three SDRs, or who just lost a competitor's contract, or whose head of ops changed in June, is a different prospect from a name on a list. If you cannot write anything in that column, the honest answer is usually that this is a low-priority row, and marking it as such beats pretending.

What a real row looks like

Say you are selling into operations teams at mid-size logistics companies. A row on the second week might read something like this.

Company: a 200-person freight brokerage in Leeds. Contact: head of ops, reports to the COO, has budget up to about ten grand without a sign-off. Next action: send the one-pager with the driver-app section removed, because she said in the call that it is not their problem this year. Next action date: Thursday the 18th. Last touch: twenty-minute call on the 9th, she asked twice about onboarding time. Source: referral from their finance lead. Why now: they are moving off a legacy TMS in Q1 and she has to pick tooling before Christmas.

Read that row back in three weeks and you can pick the thread up cold. Read a row that says "Leeds brokerage, Contacted, Warm" and you cannot. That is the whole difference, and it is worth the extra forty seconds of typing per touch.

The tracker is the paperwork underneath a prospecting plan and proper qualification, not a replacement for either.

Where every prospect tracker stops being useful

The tracker tells you what you did. It cannot tell you what happened next.

You mark the row "proposal sent, Thursday". Then nothing. Was it opened? Did anyone get past the pricing page? Did the head of ops forward it to the COO, who is the person who actually decides, and if so did the COO read the bit that answers his objection? Your sheet knows none of that. It knows you sent something.

When I was running growth at a data company I would send a deck on a Friday and spend the weekend guessing, then write "followed up" in a spreadsheet on Monday and let the spreadsheet look productive on my behalf.

Two things fix it, and only one is a tool. Write the next action for a proposal before you send it, so "wait and see" never becomes the plan. Then send the document as something you can see into. That is why we built LiveDocument: you record a short walkthrough over the PDF, share it as one link instead of an attachment, and get page-level analytics on which pages they sat on and what they came back to. It is not a CRM and will not manage your pipeline, so it sits next to your tracker rather than replacing it.

Keep the tracker dumb and keep it current. A dumb spreadsheet you update every day beats a clever one you abandon in a fortnight.

Should you use a spreadsheet or a CRM?

Use a spreadsheet until the sheet starts hurting. Under about fifty live accounts, a Google Sheet is genuinely better than a CRM, because there is no friction between having a thought and recording it.

You want a CRM the moment more than one person needs the same view, or the moment you start wanting history you did not manually type. HubSpot's free lead tracker is a reasonable middle step if you want the structure without the subscription, and Coefficient's prospect tracking template is fine if you want something that syncs back to a real data source.

Do not migrate because a spreadsheet feels unprofessional. Nobody is looking at it but you.

Questions people ask about prospect trackers

How many prospects should be in the tracker at once?

Fewer than you think. If you are doing your own outbound alongside other work, thirty to fifty live accounts is about the ceiling before the next-action column starts going stale. A tracker with two hundred rows is an archive, not a tracker.

How often should I update it?

At the end of every touch, not at the end of the week. Batching it on a Friday is how the "last touch" column turns into fiction, and fiction in a tracker is worse than an empty cell.

Does a prospect tracker template work for inbound leads too?

Yes, with one change: the source column becomes the most useful column on the sheet, because inbound rows arrive with wildly different intent. A demo request and an ebook download should never sit at the same priority, and the source column is what stops that happening.

I built LiveDocument because I got tired of writing "proposal sent" in a spreadsheet and having no idea what that actually meant. If that is a feeling you recognise, it is at livedocument.com.

The prospect tracker template that survives contact with a real week