Where’s my next customer coming from?
You know you need more revenue. But where is the next deal actually going to come from? Here's how to answer that question using your CRM and accounting data.
The short answer
Your next customer is already in your pipeline.You need to look at three things: which deals are closest to closing, which lead sources have the best conversion history, and whether your pipeline has enough volume to produce a win this month. Your CRM has the data. Below, we'll show you where.
Why knowing your next customer matters more than total pipeline
Pipeline value is a vanity metric when you look at it in aggregate. $400K in pipeline sounds great until you realize half of it has been sitting in “Proposal Sent” for 60 days, a quarter is from inbound leads with no follow-up, and the rest is a single deal that keeps pushing its close date.
The question isn't “how big is my pipeline?” It's “which specific deals are likely to close, and when?” That requires looking at deal stage, last activity date, lead source, and how your historical close rate breaks down by each of those dimensions.
If you can't name your three most likely next customers right now, you're flying blind. And if you can't connect those deals back to the marketing channel or referral source that produced them, you can't repeat what's working.
Pipeline signals that predict your next closed deal
To figure out where your next customer is coming from, you need to check these things in your CRM:
- Deals in late stages.Anything in “Contract Sent,” “Negotiation,” or “Decision Maker Bought-In” is closer to revenue than a fresh lead. Filter by close date within the next 30 days.
- Recent activity on open deals. A deal with a meeting logged yesterday is more real than one with no activity in three weeks. Sort by last activity date.
- Lead source performance. Which sources (referral, organic, paid, outbound) have the highest close rate historically? Your next customer is statistically more likely to come from the channel that already converts best.
- Deal velocity by source. Even if paid leads close at the same rate as referrals, referrals might close in 14 days while paid leads take 45. Speed matters when you need revenue this month.
How to find your next customer in HubSpot
HubSpot's deal pipeline and sales analytics give you most of what you need. Here's the step-by-step:
- 1Go to Sales → Deals
Switch to the Board view if you're not already there. This shows all open deals organized by stage. Visually scan the rightmost columns (your late stages) for deals with close dates this month.
- 2Filter by close date and last activity
Click Advanced filters. Set “Close date” to “is within the next 30 days.” Then add a filter for “Last activity date” to see which deals have had recent engagement. Deals with no activity in 14+ days are stalling.
- 3Check deal source: Reports → Analytics Tools → Sales Analytics
Navigate to Reports → Analytics Tools → Sales Analytics. Select Deal velocity from the left sidebar. This shows the average number of days deals take to close by source, rep, or deal type.
- 4Run the Deal Funnel report
Go to Reports → Create report. Search for “Deal stage funnel.” This shows conversion rates between stages so you can see where deals are advancing vs. where they stall.
- 5Cross-reference with the forecast tool
Go to Sales → Forecast. Click the Deal stage tab to see forecast totals by stage. If your weighted amount is set, this shows pipeline value adjusted by stage probability.
Total time: 15-20 minutes. You're pulling from the deal board, sales analytics, and the forecast tool. No single view gives you the full picture.
How to find your next customer in Salesforce
Salesforce has more reporting power but also more places to look. Here's the path:
- 1Open Pipeline Inspection
Navigate to Opportunities → Pipeline Inspection (available in Enterprise and above). This view shows every open opportunity with key fields: stage, amount, close date, last activity, days in current stage, and push count (how many times the close date has been moved).
- 2Sort by close date and filter for this month
Filter opportunities with close dates in the next 30 days. Sort by stage (descending) to see late-stage deals first. Pay attention to the “Days in Stage” column. Anything over 30 days in a single stage is likely stalled.
- 3Run a Lead Source Performance report
Go to Reports → New Report. Choose the “Opportunities” report type. Group by “Lead Source.” Add filters for “Stage = Closed Won” over the last 6 months. This shows which sources historically produce wins.
- 4Check Opportunity History for velocity
Create an Opportunity History report to see how long deals spend in each stage. This shows you which sources not only close but close fast. Combine this with your lead source report to find the channel producing your fastest wins.
Total time: 20-25 minutes across Pipeline Inspection, custom reports, and Opportunity History. Salesforce gives you the data but requires you to build the reports yourself.
How to cross-reference CRM deals with your accounting data
Your CRM says a deal closed. But did the customer actually pay? Here's the gap most businesses miss:
- Match CRM “Closed Won” deals to invoices in QuickBooks or Xero. Export your closed deals from the last 3 months. Then check your accounting software for corresponding invoices. If a deal shows as won but there's no invoice, you have a billing gap.
- Check if invoiced amounts match deal amounts. A $25K deal in your CRM that became a $18K invoice means either the scope changed or someone mis-entered the deal value. Either way, your pipeline projections are off.
- Look at time from “Closed Won” to first payment. Your CRM close date and your accounting collection date are often weeks or months apart. Understanding that lag helps you forecast cash, not just revenue.
What this looks like as a monthly habit
To stay on top of where your next customer is coming from, you need to do this review roughly every two weeks:
- 15-25 minutes in your CRM checking late-stage deals and activity
- 10 minutes cross-referencing closed deals with invoices
- A spreadsheet or notebook to track which sources are producing and which are stalling
That's about an hour a month, spread across two sessions. Most owners do it once, maybe twice, then stop because the manual effort of stitching CRM and accounting data together is tedious.
Or see exactly where your next customer is coming from, automatically
Bottomline connects to your CRM (HubSpot or Salesforce) and your accounting software (QuickBooks or Xero) and cross-references them every month. Your report shows:
Instead of toggling between your CRM pipeline view, custom reports, and your accounting software, you get one monthly snapshot that answers the question: where is the next customer coming from, and is that source reliable?