CRE Comp Management: Why Closed Deals Get Lost

Comp management fails in a specific way no one warns you about. A deal closes. The numbers are real. Months later you remember it, you know it would strengthen a current pitch, and you cannot find the record. The deal happened. The data is gone in practice.  

This is the lost comp: a closed transaction whose details exist somewhere but cannot be retrieved when you need them. 

The detail that makes this worse than having no data is simple. You know the deal exists, so you keep searching long past the point where you should have stopped.  

This article describes four ways a brokerage loses a comp during normal workflow, without anyone making a mistake, then the one structural change that closes all four gaps. The examples follow one firm: a fifteen-agent retail and industrial brokerage where comp management is everyone’s responsibility and therefore no one’s job. 

Four ways a closed deal becomes a lost comp 

Each cause follows the same shape: what happens, why it happens, and why it looks like nobody’s fault. That last part matters. These are not failures of discipline. They are the predictable result of how brokerages actually store deal data. 

1. The junior broker who never entered the data 

A first-year agent closes a small flex-space lease and moves to the next deal. The comp lives in their notes and their memory, never in a shared location. Junior brokers are measured on deals closed, not data entered, so entry is the first task to drop. It looks like nobody’s fault because the agent did their actual job. They closed the deal. 

2. The departed agent whose folders left with them 

A producer who handled the firm’s strongest industrial deals leaves for a competitor. Their comps lived in a personal drive and a local folder on a reclaimed laptop no one opened. The comps were never central to begin with, so when the broker left, the data went too. This is not a small risk.  

Research on workplace knowledge loss found that on average, 42% of the skills and information needed to do a job well are held by the person currently in the role, and nowhere else. When that person leaves, almost half of what they knew leaves with them. For a brokerage, a large share of that missing knowledge is comp data. 

3. The VA-handled deal that never hit the shared system 

A senior broker delegates comp entry to a virtual assistant. The VA records deals in a spreadsheet the broker uses for their own book, not in any firm-wide system, because no one told them one existed. The data is clean, organized, and invisible to the rest of the team.  

Delegation without a shared destination just moves the silo from the broker to the assistant. It looks like nobody’s fault because the VA did exactly what they were asked to do. 

4. The one-off transaction filed somewhere unusual 

The firm closes a deal outside its normal pattern, a medical office sale when it usually does retail. Because it did not fit the routine, it landed in a one-off place: an email thread, a client-named project folder, a drive subfolder three levels deep.  

Anything that breaks the routine breaks the filing habit with it. It looks like nobody’s fault because someone did file it, just where the deal made sense at the time, not where anyone would later look. 

Why a lost comp is worse than no comp 

Missing data you never had is a closed question. You know it does not exist, so you stop looking. A lost comp is an open loop.  

You remember the deal, so you believe the record is findable, so you keep searching: the shared drive, your email, a message to the broker who might know, a reply that confirms the file was on a wiped laptop. Every search ends in the false hope of almost finding it.  

The knowledge that the deal happened is exactly what makes the loss expensive. No data is a wall you walk around. A lost comp is a door you keep trying, that never opens. 

What lost comps cost a brokerage 

The cost shows up in three places, none of them on a balance sheet: 

• Lost pitches. A broker knows the firm closed a comparable deal that would prove competence, but without the record the pitch leans on weaker evidence while a competitor’s specific number wins the business. 
• Search time. Hours disappear hunting for records that may not be recoverable, invisible because the loss is spread across many people in small amounts. 
• Eroded confidence. A broker who cannot back a claim with the record stops making the claim, and over time the team speaks less precisely about its own track record. 

How lost comps stall deals and financing 

These costs stay inside the firm. The stakes rise when a lost comp surfaces during a live deal. A broker asked to support a valuation during an appraisal, defend value when a lender questions the numbers, or keep a transaction moving toward close needs the firm’s own relevant comp in hand.  

When that record cannot be produced, the broker’s position weakens at the exact moment it matters most. Appraisals stall while value is re-justified, financing hits a roadblock when the supporting evidence is thin, and the transaction slips past its closing date. The lost comp stops being an internal inconvenience and starts costing the deal itself. 

The fix is structural, not behavioral 

The instinct is to fix this with discipline: a new rule, a reminder, a quarterly audit. Discipline fails because all four causes come from structure, not behavior.  

The reliable fix is a single shared record that every team member touches by default, as part of closing the deal, not as an extra step afterward. When entry is the workflow rather than an addition to it, the four gaps close at once: 

• The junior broker enters the comp because that is where deals get recorded. 
• The departed agent’s comps stay because they were never in a personal drive. 
• The VA works in the shared system because it is the only system. 
• The one-off deal lands with everything else because there is only one place. 

Where Compstash fits 

Brokerages have always patched around this with shared drives, CRMs, and house rules. Compstash is the first system built specifically to close the gap rather than work around it. Its team comp management keeps a brokerage’s closed-deal comps in one private database the whole team uses by default, instead of scattering across drives, spreadsheets, and the memories of people who may not be at the firm next year.  

Compstash is not a market data source, and it does not resell anyone’s deals. Because comp entry happens in the shared system rather than alongside it, the four causes lose their grip: no personal drive to follow a departing agent, no separate VA spreadsheet to go invisible, no unusual folder for a one-off deal.  

You can see how the centralized database and permission controls handle this directly. The point is not more features. It is that the lost comp stops being possible, because there is nowhere for a closed deal to get lost. 

Stop losing deals you already closed. Put your firm’s comp history in one place that survives every departure. Start a free trial and keep your comps where you can find them.