A VP of Sales at a $5M ARR company ran forecast for Q2. Pipeline looked strong: $2.3M in deals. But when she drilled into the numbers, she found the same deal appeared in two reps' pipelines, weighted at 100% probability in both. One rep owned the account. The other had jumped in on a co-sell. Neither had marked it as shared. Her real forecast wasn't $2.3M—it was $1.8M. This problem scales. Most CRM systems allow multiple owners or let deals be shared across reps without automatic deduplication. Territory shifts, team hand-offs, and collaborative selling all create the conditions where a single opportunity gets counted twice—sometimes three times. For a 50-person sales org, this easily inflates forecast by 20–40%. You notice when deals slip, when pipeline thins, when the gap between forecast and close widens. But the root cause is often invisible until you audit the data. Here's how to spot inflation, why different platforms handle it differently, and the three-step reconciliation that catches what your system missed. How deals get double-counted: territory, co-sell, and reassignment A deal doesn't duplicate by accident. It duplicates because your sales process creates the conditions for it. Most teams work one or more of these scenarios: Territory splits: An account straddles two regions. Rep A owns the East Coast office, Rep B owns the Central hub. The deal involves both. One rep creates the deal; the other adds themselves as a stakeholder or secondary owner. Both report it in their individual pipeline. Co-selling: A deal requires a specialist. The account rep creates the deal; the sales engineer or partner manager adds themselves and marks the deal as co-owned. If the system doesn't enforce a single owner rule, both reps' forecast includes 100% of the deal value. Reassignment with handoff failure: A deal is reassigned from Rep A to Rep B mid-cycle. Rep A marks the deal as lost or won (incorrectly closing it out). Rep B re-opens it or creates a duplicate. Or the handoff is incomplete and both reps keep the deal active in their personal pipeline. Merged accounts: Two customer records are merged, but the deals attached to each record aren't consolidated. Now the same opportunity sits under two account IDs. None of these scenarios is user error. They're byproducts of how real sales teams work. The problem is that most CRM platforms don't penalize duplicate ownership—they just add it up. How Pipedrive, HubSpot, and Orin handle deal ownership Pipedrive allows a single primary owner plus multiple collaborators. The deal's forecast value is attributed to the primary owner only. If you add collaborators, they see the deal in their activity stream but not in their individual forecast. This is the safest design, but it requires discipline: teams must designate a primary owner on every deal and resist the temptation to mark a deal as owned by multiple people. HubSpot also defaults to a single owner, but the platform allows users to add multiple deal owners on the same record. If two people are marked as owner, the deal appears in both their forecasts at full value. HubSpot's interface does warn that forecast totals may include overlaps, but most teams don't catch it until the damage is visible. HubSpot's reporting includes an option to 'exclude duplicate owners' in forecast rollups, but you have to know to enable it—and many teams don't until they've already had a forecast miss. Orin enforces single deal ownership by default in the CRM and makes ownership changes explicit and logged. If a deal needs to be reassigned, the transfer is recorded in the deal timeline, and the deal moves from one rep's pipeline to the other's. Shared accountability is tracked via team chat threads attached to the deal, not by adding a second owner to the record itself. This keeps forecast clean while preserving visibility into who's working the deal. The consequence of not catching it A 50-rep sales org with 10% of deals in shared ownership scenarios inflates pipeline by roughly 150 deals. If average deal size is $50K, that's $7.5M in phantom forecast. Even at a 20% close rate, you're missing $1.5M in revenue prediction—which flows directly into earnings guidance misses, investor confidence hits, and rep bonus calculations that reward inflated forecasts. Three-step audit to find hidden duplicates and inflated forecast Step 1: Export and audit by deal owner Pull a pipeline export (deals in all active stages) and add three columns: primary owner, all owners (if your system tracks multiple), and deal ID. Sort by account name, then by deal value, descending. Scan for the same account appearing twice with different deals or the same deal ID appearing under two owners. In Excel or a data tool, run a quick pivot: Group by account name and deal ID. Count the number of distinct owners per deal. Flag any deal where owner count > 1. If your CRM exports owner data as a single field, use a formula to split multi-owner fields (comma-separated or lis