Build a Client Pipeline Dashboard in a Spreadsheet

A working client pipeline dashboard for a solo consultant needs five core columns, one weighted-value formula, and three saved views. That is the whole build. You can stand it up in Google Sheets or Excel in under an hour, and once it exists, the question "what is actually in my pipeline right now?" stops being a guessing game and becomes a number you can read in two seconds.

Most freelancers track prospects in a tangle of email threads, sticky notes, and a vague sense of dread. A spreadsheet pipeline fixes that not because spreadsheets are powerful, but because the act of forcing every opportunity into the same five columns makes the gaps obvious: the proposal you forgot to follow up on, the "hot" lead that has not moved in six weeks, the month with nothing in it.

The five columns that do all the work

Resist the urge to add twenty fields. A pipeline you do not update is worse than no pipeline, because it lies to you. Keep it to five columns that you can fill in during the thirty seconds after a discovery call:

• Client / Project: who and what, in plain language.
• Stage: a single value from a fixed list (Lead, Contacted, Proposal Sent, Verbal Yes, Won, Lost). Use data validation so you can never type a freehand stage.
• Estimated Value: the full project fee if you win it.
• Probability: your honest gut percentage that it closes, tied to the stage.
• Next Action + Date: the one thing you will do next, and when. This is the column that actually moves money.

A sixth optional column, Source (referral, inbound, cold outreach, repeat client), costs you nothing to fill and tells you within a quarter where your real revenue comes from. Most consultants are surprised: the channel they spend the most energy on is rarely the one that pays.

The one formula: weighted pipeline value

Raw pipeline value is a fantasy number. If you have $80,000 of "Estimated Value" sitting in the sheet, almost none of it is real, because most of those deals will not close. The honest figure is weighted value: each deal's value multiplied by its probability.

In a cell next to each row, write =Value * Probability. So a $12,000 project at 30% probability contributes $3,600 to your real pipeline. Sum that weighted column and you get a single number that approximates the revenue you can actually expect from everything currently open. Watch that number, not the raw total.

This is exactly the weighted pipeline method that sales teams use: as Forecastio's breakdown puts it, "by multiplying the deal value by the probability of closing, you get a weighted value for each opportunity," giving you a data-driven alternative to gut-feel forecasting. The spreadsheet just makes a solo operator's version of it cost nothing.

Tie probability to stage so you are not inventing percentages on the fly. A common working scale: Lead 10%, Contacted 25%, Proposal Sent 50%, Verbal Yes 80%, Won 100%, Lost 0%. These are rules of thumb, not laws of physics. Adjust them after a few months once you can see your own historical close rates. The point is consistency, so the same word always means the same number.

A useful MyDashBorg rule of thumb sits underneath all of this: if your pipeline lives in a fixed set of stages with a number attached to each one, follow-up stops depending on memory. The structure does the remembering. A deal cannot quietly vanish when its stage and its next-action date are both staring back at you in a column.

The three views you actually read

Data in rows is storage. Views are the dashboard. Build three:

By stage. A pivot table grouped on the Stage column, summing both raw and weighted value. This is your "where is everything stuck?" view. If twelve deals are piled in "Proposal Sent" and three are in "Contacted," your problem is not lead generation, it is closing.

By next-action date. A filter sorted on the Next Action date column, oldest first, hiding anything marked Won or Lost. This is your daily worklist. A consultant who works only the top five rows of this view every morning never lets a warm lead go cold.

Weighted total. A single prominent cell, big and bold, showing the sum of the weighted column. This is the number that tells you whether to take a vacation or start prospecting. Put it at the top so it is the first thing you see when the file opens.

A mini-case: the consultant with a "full" pipeline

A solo brand strategist felt busy and assumed her pipeline was healthy. She had nine open opportunities and a raw value north of $95,000, which felt like plenty. When she finally built the weighted view, the real number was about $14,000, because seven of the nine deals were still sitting at the Lead or Contacted stage at 10 to 25% probability. Worse, the by-next-action view showed four of them had a "next action" date more than a month in the past. The pipeline was not full. It was stalled.

The fix took a week, not a quarter. She worked the next-action view top-down, sent three overdue follow-ups, and moved two deals to Proposal Sent. The weighted total roughly doubled, not because she found new leads, but because she stopped letting existing ones decay. The dashboard did not generate revenue. It revealed where revenue was leaking.

When the spreadsheet stops being enough

A spreadsheet pipeline scales beautifully for one person tracking a few dozen opportunities. It starts to strain when you bring on a subcontractor who needs their own view, when you want the weighted total to refresh on a shared screen without someone opening the file, or when "which source closes best?" becomes a question you want answered automatically every week instead of by hand. At that point the maintenance cost of the spreadsheet quietly exceeds its value.

That is the moment a purpose-built dashboard earns its keep, ideally one connected to the same data you already keep, so you are not re-entering anything. MyDashBorg builds done-for-you pipeline dashboards from a freelancer client tracker template and adds an "Ask your data" layer so questions like "what is my weighted pipeline this quarter?" get answered in plain English. But do not jump there first. Build the five-column spreadsheet, run it for a month, and let it tell you exactly what a better tool would need to do.

The discipline matters more than the software. A weighted pipeline you update honestly for thirty seconds after every call will outperform the fanciest CRM you ignore.

Frequently Asked Questions

What columns does a freelance client pipeline tracker need?

Five core columns cover almost every solo consultant: Client/Project, Stage (from a fixed list), Estimated Value, Probability, and Next Action with a date. An optional sixth column, Source, reveals over time which channels actually produce paying clients. Keep it minimal, because a pipeline you do not update is worse than none.

How do I calculate weighted pipeline value in a spreadsheet?

Multiply each deal's Estimated Value by its Probability in a new cell, using a formula like =Value * Probability, then sum that column. A $12,000 deal at 30% probability contributes $3,600. The summed weighted column is a far more honest estimate of expected revenue than the raw total of all open deals.

Is a spreadsheet good enough, or do I need a CRM?

A spreadsheet is genuinely sufficient for one person tracking a few dozen opportunities and costs nothing to start. You outgrow it when you need shared real-time views, automatic weekly reporting, or a teammate with separate access. Run the spreadsheet for a month first so you know exactly what features a paid tool would actually need to justify itself.

How often should I update my pipeline tracker?

Update it within thirty seconds of every meaningful client interaction: after a discovery call, when you send a proposal, or when a deal closes or dies. The single most valuable habit is working the "next action by date" view top-down each morning so warm leads never go cold from neglect.

Ready to move past the spreadsheet? Compare MyDashBorg plans and pricing to see which tier fits a one-person consultancy.