Still Building Your Sales Forecast by Hand?

We had a capable CRM. Yet more than half my week went into assembling sales reports and sitting in meetings to explain them.

Every two weeks, several people pulled together spreadsheets and PowerPoint slides for another pipeline review. We entered numbers by hand, added up projections, and questioned whether the totals were right.

Then came hours of meetings. What was the next step on a deal? Why was it forecast to close next quarter? Where did a particular number come from?

We were reconstructing information the CRM should have made available.

The work had moved outside the CRM

Next steps weren’t captured consistently. Reports weren’t configured around the questions leadership needed answered. Salespeople kept important information outside the system.

A meeting became the place to collect the facts. Preparing for that meeting meant gathering them again in a different format.

The cost was more than administrative effort. Time spent assembling a forecast was time unavailable for coaching, helping a salesperson prepare for a difficult conversation, or examining why a promising opportunity had stalled.

I rebuilt the CRM, but adoption still lagged. Fixing the configuration addressed only part of the problem. The team also needed to use it consistently.

Start with the decisions you need to make

Before adding another dashboard, decide which questions it must help you answer. Which opportunities need attention? What supports the expected close date? What has the buyer agreed to do next?

Then work backward. Identify the information needed, where it belongs, and who keeps it current. Make those expectations clear to the team.

A field called “Next step” helps only if the entry means something. “Follow up” describes a seller’s intention. A buyer-agreed action, with an owner and date, provides something you can review.

Useful reporting also depends on leadership habits. If every review requires a separate slide deck, the team has another place to maintain its version of the pipeline. Use the CRM during reviews and address missing information where it belongs.

Try the five-opportunity check

Open five active opportunities in your CRM this week. For each one, check:

• Is the buyer’s business problem clear?
• Can you see the next action agreed with the buyer, who owns it, and when it should happen?
• Is there a reason for the expected close date beyond the salesperson’s estimate?
• Could another person understand the deal without calling the salesperson?

Notice where you have to leave the CRM to find an answer. A missing field, a confusing report, and an unused field are different problems. Each calls for a different correction.

Review the findings with the team. Ask what makes the information difficult to capture or keep current. Start with the few changes that make the next pipeline review more useful.

Find the gaps before choosing the fix

At StelzlCRO, DeeAnn and I bring marketing and HubSpot experience together with sales leadership and process design. We examine how interest moves into sales, how follow-up is managed, and what leadership can actually see.

Our focused CRM assessment reviews the sales process, setup, reporting, and team usage. You receive findings, priorities, and a roadmap for improvement. Implementation or repair work can then be scoped around what the review uncovers.

If you’re considering HubSpot, or already own it but still work around it, contact us about a CRM assessment. We start with your business and the systems you already use.