· Published by Small Business Tool Lab
Check the CRM forecast before your next sales meeting and the available bank balance before approving a purchase. A customer relationship management system can show a useful weighted pipeline without showing when customers will actually pay you. The number helps you organize selling, but it can’t pay for payroll or a supplier deposit on its own.
Microsoft’s forecasting overview describes a planning view built from pipeline activity, categories, quotas and reporting rollups. To use a view like that responsibly, follow a proposal all the way through closing, billing and payment.
Check the percentage behind the total
In a basic weighted pipeline, multiply each deal’s amount by its probability of being won, then add the results. HubSpot defines its Weighted amount property this way. That is different from adding the full amounts of all open opportunities.
Consider two hypothetical proposals in the same currency: an $8,000 job assigned a 50% win probability and a $12,000 job also assigned 50%. Their weighted values are $4,000 and $6,000, totaling $10,000. No customer has promised to pay either weighted amount. Under this simplified all-or-nothing example, the eventual sales total is $0, $8,000, $12,000 or $20,000—not $10,000.
The weighted total is an expected-value calculation if the assigned probabilities are meaningful. It is not a minimum outcome or a confidence interval. If both prospects depend on the same delayed construction project, their outcomes may move together; summing weighted values does not reveal that concentration risk. For a small pipeline, one large lost deal can dominate the result.
Find which probability the report actually uses
A stage label alone may not explain the number. Pipedrive documents that deal-specific probability overrides stage probability. Do not multiply the two percentages together. HubSpot separately warns that manually editing a deal’s probability can stop its automatic updates from open-stage changes. These are vendor-specific behaviors worth checking in your own configuration.
Take one valuable opportunity and compare its amount, stage, probability and displayed weighted value. Ask the owner what evidence supports the probability and when it was last reviewed. If the number is stale, fix the underlying record through your normal approval process instead of changing a report just to make the total look better.
The salesperson’s close date becomes someone else’s billing task
A forecasted closing date is not automatically an invoice date. Your agreement may require a signature, delivery, customer acceptance or a deposit before billing. Record that trigger separately. A recurring contract may also be fulfilled across several months rather than become one immediate payment.
Salesforce’s Manufacturing Cloud training illustrates how probability and product schedules can affect a period’s forecast. Its setup is specific to that product, but it makes a useful question visible: does your report place the whole contract in one month or use a schedule? Neither choice should quietly turn into your assumption about when cash arrives.
Track payment after the invoice goes out
Once an invoice is issued, payment terms and the customer’s behavior determine when cash might arrive. The SBA’s forecasting discussion explains why credit sales can appear in profit reports before the money reaches the bank. A won deal, an invoice and a cleared receipt are different events.
For a clearly hypothetical timing example, assume the $8,000 job is won, completed and invoiced on November 20, with a contractual December 20 due date. Assume no deposit and no earlier payment. Even though the sales report places the win in November, the planned receipt belongs in December. The customer could still pay late; the due date is not a guarantee.
Use the handoffs to make a spending decision
Keep a separate cash view with opening usable cash, dated expected receipts and dated outflows. Identify which receipts are already collected, which are invoiced and which still depend on winning a proposal. Avoid counting the same deal once as a weighted opportunity and again as an unpaid invoice.
Before a new commitment, test what happens if the largest uncertain receipt slips beyond the payment date. That is a downside scenario, not a forecast of failure. If it creates a shortfall, the owner can reconsider the purchase date, negotiate terms or seek suitable advice before committing.
At a regular review, save the original stage probabilities and compare them with outcomes of deals that have had enough time to close. Include losses and delays, and note when the sales process changed. A few lucky wins don’t prove a percentage is right. If the team cannot maintain the underlying records, revisit the CRM-versus-spreadsheet coordination test before buying another forecasting feature.
Sources
CRM documentation checked October 21, 2026. Features and permissions vary by product and plan. All deal amounts, probabilities and payment dates in the examples are hypothetical.