Build a Sales Pipeline Dashboard That Shows Stalled Deals

Define Stages by What the Buyer Has Confirmed

Start with your sales process. For each stage, write the evidence needed to enter it and the buyer action that would move it forward. A seller sending a document is observable, but it doesn't establish that the buyer has reviewed it or agreed to decide.

For example, you might distinguish an initial conversation, discovery completed, a proposal under discussion, and an agreed decision pending. Those are suggested labels. Change them to match the way your team actually sells, while keeping their meaning consistent across opportunities.

Say a seller has emailed a managed-services proposal but hasn't arranged a discussion. Mark the proposal as sent, record the missing conversation, and give the seller a follow-up task. Don't quietly move it into a stage that implies the client has accepted the scope.

In a practitioner discussion, Paul Green recommends choosing the tool after defining the MSP's marketing and sales process. He allows that a PSA can suit straightforward referral or renewal visibility, while distinguishing those needs from campaigns, forecasting, and follow-up accountability. I'd settle the records you need before shopping for a different system.

Keep the Next Action Beside the Value

Give each live deal a named owner. Keep the account and contact details, source, current stage, and date it entered that stage. Then show the fields that decide the next action without making the owner open every record.

Keep an unknown date visibly unknown. A guessed close date entered to satisfy the CRM shouldn't look like a commitment from the buyer. Ask the seller what supports the date, and record the answer beside it.

Keep one-time hardware and project value separate from MRR. You may want both in the commercial view, but adding them into a monthly total changes what the number means. Finance and delivery need to recognize the same distinction when the opportunity becomes work.

Use Age to Start a Conversation

Don't label every proposal old after a borrowed number of days. Compare stage age with your own completed deals, including wins and losses, and inspect the long-running open ones. A buying process waiting for a known budget decision needs a different response from an unanswered quote.

I'd ask the seller: What has the buyer agreed to do next, and what are we waiting on? If the answer is only that the proposal went out, arrange a real follow-up. Try: I want to check whether the scope and monthly fee fit what you need. Who needs to review them before you can make a decision?

When a decision date passes, ask for an update rather than changing the date without comment. Say: We had planned to speak after your review. Has the decision moved, or is there something in the proposal we should resolve? Record the new information and the next agreed step.

Ray J. Green recommends distinguishing follow-up that gets an explicit yes-or-no answer from opportunities that simply age into a lost status. He treats a clear refusal as closure, even though it isn't a win. I'd show those outcomes separately so an administrative cleanup doesn't look like a completed buyer conversation.

Check Wins Against the Plan Without Inventing Coverage

The model's new-client starting fee is $2,200 in MRR. Its 8.7-client stable planning result is an annual average, so it isn't a literal promise of a fractional client or a quota every seller should copy. Put your actual target and actual signed wins beside the remaining open opportunities.

Then compare proposed recurring fees and likely start dates. A signed client starting later in the year contributes fewer months of revenue than an otherwise identical client starting earlier. Show the end-of-year recurring run rate separately from revenue expected inside the year.

Don't multiply the target by a generic pipeline-coverage ratio and call the forecast done. Use your own stage results to estimate what open opportunities could produce. If you lack enough completed deals to support a probability, show the unweighted values and the missing evidence rather than adding confident percentages.

Separate lead sources when reviewing those results. A referral already familiar with your service and an unfamiliar outbound prospect may arrive with different information. Investigate the differences in your records before deciding whether a stage or message needs to change.

Leave the Review With Named Actions

Run the meeting from the opportunities that require a decision. Ask each owner for the buyer evidence, unresolved point, and next action. You don't need a spoken tour through every company name to learn which deals need help.

• Sales owns follow-up, stage evidence, decision dates, and the explanation for changes in value.
• The owner or sales lead resolves pricing and scope questions the seller cannot approve alone.
• Delivery confirms whether the proposed scope and start can be accepted before those dates become commitments.
• Finance checks signed recurring fees and start dates against the revenue plan, with acquisition spending kept visible.

After the review, the seller updates the opportunity rather than leaving the useful information in meeting notes. If a buyer has declined, record the actual reason they gave. If they've gone quiet, record that condition without pretending you know why.

I'd start by opening the proposals you're counting on to reach your target. For each, find the named owner, buyer's next step, proposed MRR, and support for the start date. Fill those gaps before adding another chart. That's the view that can tell you what to do about a stalled deal.