Do I have deals with no contact assigned?
A deal without a contact is a revenue opportunity that nobody can follow up on. Here's how to find these orphaned deals in your CRM and fix the gap.
The short answer
Filter your CRM for open deals with no associated contact. In HubSpot, filter deals where “Associated contacts” is 0. In Salesforce, look for opportunities with no Contact Role assigned. These orphaned deals can't be properly followed up, won't appear in contact-based reports, and are likely to fall through the cracks.
Orphaned deals are invisible revenue leaks
A deal without a contact is like a delivery with no address. You know the opportunity exists, but you can't reach the person who needs to say yes. These deals usually happen when someone creates a deal quickly from a meeting or a phone call and forgets to associate the contact.
The damage goes beyond follow-up. Orphaned deals break your reporting: they don't show up in contact-based pipeline reports, they can't be matched to marketing touchpoints, and they can't be cross-referenced with invoices in your accounting software. They're pipeline value that exists in a vacuum.
How to find deals with no contact in HubSpot
- 1Go to Sales → Deals, switch to List view
Click Advanced filters. Add a filter for “Number of associated contacts is equal to 0” and “Deal stage is not Closed Won or Closed Lost.” This shows all open deals with no contact linked.
- 2Note the total value of orphaned deals
The sum at the bottom of the list shows how much pipeline value is sitting in deals with no contact. This is money that's difficult to follow up on and likely to stall.
- 3Fix them: associate a contact to each deal
Open each orphaned deal. Click Addunder Associated Contacts. Search for or create the contact. This takes 1-2 minutes per deal. For 10 orphaned deals, you're looking at 15-20 minutes of cleanup.
Total time: 5 minutes to find them, 15-20 minutes to fix them. Consider making contact association required when creating a deal to prevent this in the future.
How to find deals with no contact in Salesforce
- 1Create an Opportunities Without Contact Roles report
Go to Reports → New Report. Select “Opportunities with Contact Roles” as the report type. Run the report, then cross-reference against all open opportunities. Alternatively, create a formula or use a list view filtered by opportunities where the Contact Role count is 0.
- 2Check Pipeline Inspection for missing data
In Opportunities → Pipeline Inspection, opportunities with missing key fields (including contacts) may show data quality warnings. Look for opportunities flagged with incomplete information.
- 3Set up validation rules
In Setup → Object Manager → Opportunity → Validation Rules, you can create a rule that prevents opportunities from advancing past a certain stage without a Contact Role assigned. This prevents the problem from recurring.
Total time: 10-15 minutes to identify. Salesforce makes this harder to find than HubSpot because Contact Roles are a separate object. Validation rules are the best prevention.
Why orphaned deals break your CRM-to-accounting connection
When Bottomline (or any integration) tries to match CRM deals to QuickBooks or Xero invoices, it relies on contact information. A deal with no contact can't be matched to a customer in your accounting system. This means even if the deal closes and gets invoiced, the connection between the CRM deal and the accounting invoice is broken, leaving a gap in your reporting.
Monthly effort to keep deals clean
Run the orphaned deal filter once a month. It takes 5 minutes to identify and 15-20 minutes to fix. Better yet, set up a required field or validation rule so deals can't be created without a contact. Prevention takes 10 minutes of setup and saves you time every month.
Or get orphaned deals flagged automatically
Bottomline checks your CRM every month for data quality issues including deals with no associated contact. Your monthly report flags them so you can fix them before they cause problems.
Clean CRM data is the foundation of accurate pipeline reporting. Bottomline catches the gaps so your pipeline numbers, forecasts, and cross-references with accounting all work properly.