Shared Deals Inflate Forecasts

Q: How do I find shared deals in my CRM?

Export your active deals with all owner names. Filter for rows where multiple active reps are listed as owners. Cross-reference with account name to spot duplicates, then decide if it's a genuine split or a phantom entry.

Q: What if two reps genuinely co-closed a deal?

Split the deal value equally (or by contribution) across two deal records, one per rep. If your CRM supports it, use an "Assist" field instead. Either way, the total forecast value stays the same; attribution becomes clear.

Q: Does shared deal inflation affect commission payouts?

Yes. If you pay commission on booked or forecast revenue, a deal counted twice might trigger double commission. An audit before close reconciles ownership and prevents overpayment.

Q: How often should I audit for shared deals?

Once a quarter is standard for a growing team. If you're adding intake forms and single-owner enforcement, drop to twice yearly. If you have those controls locked, once yearly is enough.

Your sales team just told you next quarter is ₹2.8 crore locked in. But when you drill into the pipeline, you find two reps have claimed the same deal. That ₹50 lakh entry got counted twice. Your real forecast is ₹2.3 crore. Nobody caught it because your CRM doesn't enforce single ownership, and your reps have no incentive to fix it—both get credit. This isn't rare. In a typical sales org with 10–15 reps, shared deals inflate forecast by 15–40%. Most CRMs don't prevent it. Most teams don't audit for it. And when you do spot it, reconciling who actually owns what becomes a political nightmare. Here's how to find shared deals, decide who owns them, and stop the inflation from happening again. Why shared deals happen—and why your CRM doesn't stop them A prospect talks to Rep A at the conference. Rep A enters a deal. Then the prospect emails Rep B directly. Rep B also enters a deal. Or a deal owner leaves; their replacement inherits the prospect and creates a new deal rather than reassigning. Or it's a team deal—two reps close it together—but your system records it twice. Most CRMs (HubSpot, Pipedrive, Zoho) let multiple users edit the same deal record and add themselves as owners. They don't block duplicates. They don't flag "this prospect already has an open deal." And they definitely don't deduplicate automatically. The math: If 12% of your ₹10 crore pipeline is shared (two reps each claiming 50%), you've inflated forecast by ₹60 lakh. That's the difference between "we're on track" and "we're 20% short." The fix has three steps: audit, decide, enforce. And it starts with a query your CRM probably isn't running. The audit: Finding deals with two or more owners First, you need to know the scale of the problem. Export your active deals (stage not "Won" or "Lost") into a spreadsheet with these columns: Deal ID Deal name Deal value Deal owner(s) Created by Last modified by Prospect/account name Stage Close date If your CRM stores multiple owners as a comma-separated field or array, isolate those rows. Flag any deal where two or more active reps have ownership listed. That's your shared deal list. Next, for each row in that list, check: Is this the same prospect under different names? Search for the company name in other deals. A ₹30 lakh deal under "Acme Corp" and another under "Acme Corporation" might be the same deal entered twice. What's the created-by and last-modified-by chain? If Rep A created it three weeks ago and Rep B modified it yesterday, Rep B probably inherited it and needs to reassign, not duplicate. Check your email or Slack for conversation context. Did both reps contribute to closing this deal, or did one take it over? That shapes your ownership decision. A 50-rep org typically finds 8–20 active shared deals in a quarterly audit. A 100-rep org finds 30–50. If you're finding more than 20%, your deal entry process is broken (no intake form, no duplicate check, no prospect deduplication). The split: Deciding real vs. phantom ownership Once you've identified shared deals, you have three options per deal: 1. One rep owns it (most common) One rep closed it, or brought it in, or is managing the relationship now. The other rep assisted or touched it briefly. Decision: assign it fully to the primary rep. The other rep gets assist credit if your CRM supports it (Salesforce does; Pipedrive does not). This is 70–80% of shared deals. 2. Split it proportionally Two reps are genuinely co-closing a deal. Example: enterprise deal where one rep owns the economic buyer and the other owns the technical buyer. Split the deal value equally, or by contribution. If your CRM doesn't support partial ownership (most don't), create a separate deal record for each rep's share. Rep A gets a ₹25 lakh deal, Rep B gets a ₹25 lakh deal. Both value entries stay in the system; forecast stays accurate. 3. Mark it phantom and remove it from forecast It's a duplicate. One rep entered it by mistake. Remove it entirely or mark it with a "DO NOT FORECAST" tag. It should never have been two entries. The decision tree: Did the prospect/account name match exactly? → Likely phantom. Merge or delete one. Are both reps actively managing this deal (emails, calls, updates in the last 30 days)? → Co-ownership. Split it. Did one rep touch it once three months ago, then the other rep took over? → Reassign to the active rep. Case study: A mid-market SaaS team found ₹48 lakh in phantom deals A 15-rep SaaS sales team was forecasting ₹3.2 crore for Q4. Their manager ran an ownership audit and found 21 active deals with multiple owners. Total value: ₹1.4 crore (44% of pipeline). Of those 21: 14 were pure duplicates. Two reps had each entered the same prospect independently. Total phantom value: ₹48 lakh. These were deleted entirely. 5 were genuine co-ownership. Two reps were jointly managing the deal. The company split each one: ₹12 lakh to Rep A, ₹12 lakh to Rep B per deal. Real value stayed the same; forecast now attributed it correctly. 2 were reass