Cube vs. Mosaic for a Commercial Brokerage's Deal Pipeline

A commercial deal's commission is often large enough relative to the brokerage's monthly overhead that one deal closing a month early or a month late meaningfully changes that month's reported revenue, even though nothing about the underlying business actually changed. A forecast that doesn't separate deal-level timing risk from the brokerage's steady-state run rate will look volatile in a way that obscures whether the business is actually healthy.

A broker-owner who reacts to one strong or one weak month as if it reflects a real trend risks making staffing or spending decisions off noise rather than signal, when the more useful read comes from tracking the pipeline's underlying stage mix over several quarters.

Apply a probability to each deal based on its actual stage, signed listing agreement, active negotiation, letter of intent, under contract, rather than assuming every pipeline deal closes on schedule. A deal that's been stuck at letter of intent for an unusually long time should get a lower conversion probability than a fresh one, reflecting the real pattern that stalled deals are more likely to fall through than fresh ones.

Revisit your stage-to-close conversion rates against actual outcomes at least twice a year, since a brokerage's own historical close rate by stage is a far better input than an industry rule of thumb borrowed from a different market or property type.

Weight each deal using checks like these:

• Assign each deal a probability based on its actual stage: signed listing agreement, active negotiation, letter of intent, or under contract.
• Lower the conversion probability on a deal that has sat at letter of intent longer than usual, since stalled deals tend to convert less often.
• Track expected commission and closing date for every active deal, and update both whenever the stage or timeline changes.
• Keep deal-level timing risk separate from the brokerage's steady-state run rate.
• Record why deals fall out of contract so patterns show up in how deals are qualified.

Most brokerages already track their pipeline in a spreadsheet or a basic CRM export, with expected commission and closing date for each active deal. Cube's approach of syncing that spreadsheet against your CRM and transaction data keeps the model where it's understood, with less manual re-entry each time a deal's stage or timeline changes.

Once you're running enough agents that reconciling individual commission splits against total pipeline revenue in a spreadsheet becomes unwieldy, a dashboard rolling that up can help ownership see the picture without a manual reconciliation. Confirm in a demo that Mosaic can handle your specific split structure, since commission splits between the brokerage and individual agents often vary by agent tenure or production level, and a flat-split assumption will misstate what the brokerage actually keeps.

Deal volume and pricing in commercial real estate move with the broader rate environment, since buyers and lenders base financing decisions off the prevailing cost of debt; with the 10-year Treasury yield near 4.44%¹, build your near-term deal-flow assumptions off the current rate environment rather than a rate from a year or two ago, since financing conditions shift buyer behavior in ways that directly affect how many deals actually close.

When a deal falls out of contract, don't just remove it from the pipeline and move on; track why it fell through, financing, inspection, appraisal, or a buyer simply walking, since a pattern across several failed deals often points to something specific worth addressing, whether that's how deals are being qualified earlier in the pipeline or a shift in what buyers are willing to accept in the current market.

A brokerage that logs fall-through reasons systematically can catch a financing-related pattern early, for example if several deals are dying at the lender's appraisal stage, which is a very different problem to solve than one caused by inspection findings or buyer cold feet.

Jirav's driver-based approach is useful when you're planning to recruit additional agents and want the model to show how a new agent's ramp-up period, since agents typically take time to build their own pipeline, affects near-term firm revenue even as it builds long-term production capacity, rather than assuming a brand-new recruit contributes at a seasoned veteran agent's full production level immediately upon joining.