Sales pipeline tracker: build one in a spreadsheet, and know when to leave it
A sales pipeline tracker is a list of every open sale with its stage, value, likelihood and next step, and a spreadsheet can hold one in an afternoon. Here are the columns, the stages, the weighted pipeline formula, and the signs that the spreadsheet has started to hide what you need to know.
A sales pipeline tracker is a list of every sale you are working on, with where each one stands, what it is worth, how likely it is to close, when, and what happens next. You can build one in a spreadsheet in an afternoon, and for a handful of deals it works well. This guide gives you the columns, a set of stages with probabilities, the weighted pipeline formula with a worked example, and the specific signs that a spreadsheet has started to hide what you most need to know.
First, what goes in it: leads and opportunities
Most pipelines start as a sheet called Deals, with a column nobody updates. The fix begins with what a row is. A pipeline tracker is not a contact list. A lead is a person or company who might buy. An opportunity is one specific sale you are pursuing with them, with a value and a stage. One client can be three opportunities over a year; a lead can sit in your contacts for months without ever becoming one. Track leads wherever you keep contacts. Track opportunities in the pipeline.
That distinction decides the shape of your template: one row per sale, never one row per person.
Column | What goes in it |
|---|---|
Opportunity | A short name you will recognise: client and what they are buying |
Contact and company | Who it is with, and who decides |
Stage | Where it stands, from your fixed list of stages |
Value and currency | What it is worth if it closes, in the currency it will be paid in |
Probability | How likely you think it is, as a percentage |
Expected close | The date you honestly expect a decision |
Next step and date | The one thing that moves it forward, and when |
Outcome and reason | Won or lost, and why, filled in when it ends |
If you only keep four of these, keep stage, value, expected close and next step. Every other habit of a good pipeline hangs off those.
Write the next step as an action with a date ("send revised proposal, Thursday"), never as a status ("waiting"). A pipeline full of "waiting" is a pipeline nobody is working.
Sales pipeline stages, and a probability for each
Stages are where most spreadsheet pipelines go wrong, because they describe what you hope rather than what the buyer has done. Define each stage by something that has actually happened, and give it a probability you can defend. Here is a common starting set for a service business.
Stage | What must be true to be here | Probability |
|---|---|---|
Qualified | They have a need, a budget, and you have spoken to someone who can decide | 10% |
Needs agreed | You both agree what problem you are solving | 25% |
Proposal sent | They have your proposal and a date to respond | 50% |
Negotiating | They are discussing terms, not whether | 75% |
Won or lost | A decision, with the reason recorded | 100% or 0% |
Your stages and percentages will differ, and they should. After a few months, replace the guessed percentages with your own: of the sales that reached each stage, how many were won? That number is the stage's real probability.
A stage is an event, not a feeling. "Very interested" is not a stage. "Asked for a proposal" is.
The weighted pipeline formula, worked through
Adding up the value of every open sale gives your pipeline value, and it always looks better than reality. The weighted pipeline is the honest version: each sale's value multiplied by its probability, then added up.
Weighted pipeline = sum of (value × probability) for every open sale
Sale | Value | Probability | Weighted |
|---|---|---|---|
Website rebuild | $12,000 | 50% | $6,000 |
Quarterly retainer | $9,000 | 75% | $6,750 |
Brand workshop | $4,000 | 25% | $1,000 |
Training day | $2,500 | 10% | $250 |
Total | $27,500 | $14,000 |
Twenty-seven and a half thousand in the pipeline, fourteen thousand you can reasonably plan around. Put your own sales in; the gap between the two totals is usually the most useful number in the sheet.
Two rules keep the formula honest. A sale with no expected close date cannot be forecast, so count how many of your open sales have one: if only a third do, your forecast describes a third of your pipeline. And a sale that has gone quiet should come out of the forecast until it moves again, or it will flatter the total for months.
Never add values in different currencies in one column. A spreadsheet will happily sum dollars and pounds into a number that means nothing. Give each currency its own total.
Where a spreadsheet sales pipeline tracker starts to hide things
A spreadsheet is good at showing where every sale is now. It is poor at remembering how each one got there, and that is the part you learn from.
A spreadsheet remembers where a deal is. It forgets how it got there.
These are the points where it starts to cost you:
It overwrites history. When you change a stage, the old one is gone. You cannot work out how your stages convert, how long a sale takes to close, or where deals die, because the sheet never recorded the moves.
Next steps live in a cell, not a calendar. Nothing reminds you. A sale with a next step dated three weeks ago looks exactly as alive as one scheduled for tomorrow.
Lost sales disappear. Rows get deleted or hidden, so the win rate is calculated on the sales you kept, so it is wrong.
The client exists three times. Once in the pipeline, once in your contacts, once in the project that starts when you win. Each copy drifts.
Two people, two versions. The moment a colleague edits a copy, you have a merge problem instead of a pipeline.
Paused deals and mixed currencies quietly inflate the totals, as above.
With five open deals and one person, you will hardly notice. It starts to matter the day someone asks for your win rate and nobody can answer.
Keep the spreadsheet, or move on?
Keep it while you can answer these from memory. Move when you cannot.
Which open sales have no next step scheduled?
What was your win rate last quarter, counting the ones you lost?
How long does a sale take you, from first conversation to decision?
Which stage do most of your lost sales die in?
What is expected to close this month, in each currency?
When a sale is won, does its work start without retyping anything?
When you do move, look for a tool that fixes the spreadsheet's gaps without taking away its one real virtue: the spreadsheet is yours. It sits on your computer, it opens without a login, and you can take it anywhere. Plenty of pipeline tools are rented per person per month and keep your sales history on their servers, because recurring revenue suits the seller. Before you trade your spreadsheet for one, check where your pipeline would live and whether you can export your sales when you leave.
The test of a pipeline tool is the export. Put a few sales in during the trial, export them, and open the file. If everything you entered comes back out, the pipeline is yours.
What a good replacement should do on its own, without discipline from you:
record every stage change with its date, so conversion and time to close are measured, not guessed
turn next steps into real tasks with dates, and show you the sales with none
ask for a reason when you mark a sale lost, and keep it in the win rate
leave paused sales out of the forecast, and tell you how many open sales have a close date
keep currencies separate
let the same client be one record across the pipeline, your contacts and your projects
Questions people ask
What is a sales pipeline tracker? A list of every sale you are working on, with its stage, value, probability, expected close date and next step. It can be a spreadsheet or a dedicated tool; the columns are the same.
What is the difference between a lead and an opportunity in a CRM? A lead is a person or company who might buy. An opportunity is a specific sale you are pursuing with them, with a value and a stage. One contact can be part of several opportunities over time.
What are the stages of a sales pipeline? There is no fixed list, but a common set is qualified, needs agreed, proposal sent, negotiating, then won or lost. Define each by something the buyer has done, and give each a probability based on how many sales at that stage you actually win.
How do you calculate a weighted pipeline? Multiply each open sale's value by its probability and add the results. A $10,000 sale at 50% contributes $5,000. Leave out paused sales, and keep each currency separate.
Is Excel good enough to track a sales pipeline? For a few deals and one person, yes. It struggles once you need history: conversion between stages, time to close and an honest win rate all depend on records a spreadsheet overwrites.
What is the difference between a sales pipeline and a sales funnel? A pipeline tracks individual sales through your stages, so you can act on each one. A funnel describes how many prospects make it from one stage to the next overall. The pipeline is where you work; the funnel is what you measure afterwards.
This is the model behind Opportunities in PrimeTask: your own pipelines and stages, value and probability per sale, next steps as real tasks, stage and state changes recorded automatically, lost sales kept with their reasons, paused sales left out of the forecast, currencies never mixed, and reports where every figure opens the sales behind it. It runs on your own Mac or Windows computer, exports to CSV and JSON, and comes with PrimeCRM in PrimeTask Pro, bought once.
