You have a handful of deals that could hit in the next quarter, payroll due, and a partner asking whether commissions will cover cash. Here’s a simple, repeatable way to forecast CRE commission revenue 90 days out that we actually use — no fuzzy averages, no wishful thinking.
The core idea
Forecast at the deal level: apply product-specific commission bands, weight by stage and timing (see our stage-by-stage playbook for brokers), then validate top-down against your pipeline health. Do that and your 90-day view will be useful for planning, not fantasy.
1) Start with product-specific commission bands
Stop using one blended commission rate for every deal. Different product types and buyer profiles carry very different commission expectations. Use explicit bands and pick where each deal sits inside its band.
- Investment sales: institutional trades and private-capital trades are different. Institutional trades tend toward the lower end of market bands; private-capital trades sit higher. Use the appropriate band per deal instead of a single average.
- Leasing: leasing commissions are their own animal. Treat leasing separately from sales — mixing them hides concentration and timing risk.
- Record these bands in the sheet. When an associate hands you a deal, the line should show product, expected commission band, and the anchor (low/mid/high) selected.
Why this matters: product bands force discipline. You stop forecasting 3% on every deal and you stop overstating upside on thin-margin institutional trades.
2) Use simple certainty buckets — and be strict
Break the pipeline into a few stages: Committed (signed or fully executed LOI), LOI (subject to limited conditions), Proposal/Offer, and Prospect. For each stage, define the evidence required to move a deal forward — and use a process to track LOIs and counter-offers without losing the thread. Be explicit about the documentation you need.
Don’t fudge: treat Committed deals as much higher confidence than Proposals. LOIs without financing or cleared due-diligence windows are not committed. A classic mistake is rolling LOIs as if they’re closed — that kills accuracy. Enforce follow-up discipline that beats lead volume so evidence stays current.
Couple this with a market rule of thumb for healthy pipeline coverage. A well-shot pipeline tends to run multiple times your trailing-quarter revenue; when it drops below a certain threshold, expect a slowdown rather than a miracle close. Track that multiple and use it as a sanity check on your 90-day view.
3) Layer in timing — when the commission actually pays
Commissions aren’t earned the same day a check clears. Some pay at signing; others at funding or lease commencement. For a 90-day forecast you must map event to cash timing:
- Confirm contract language: payment triggers (signing, funding, occupancy).
- Confirm counterparty timelines: lender funding windows, investor closings, or owner approval cycles.
- Model cash lag explicitly: if a deal is likely to close inside 90 days but pays at funding and funding routinely slips 30–60 days, adjust the forecast.
Be brutal on timing. Over‑optimistic close dates are the single biggest source of error in short-range commission forecasts.
4) Quick top-down validation — pipeline multiples and revenue mix
After you build the deal-level forecast, validate it top-down. Two checks we always run:
- Pipeline coverage: compare your forward pipeline to trailing-quarter revenue. If you need a framework for what healthy coverage looks like, see our active pipelines vs. wish lists analysis.
- Revenue mix sanity: remember leasing typically makes up a chunk of brokerage revenue. If your short-term forecast leans heavily on one product while your historical mix shows diversified sources, review assumptions.
This step catches the “sweetheart deal” problem: a single large assumed commission can look plausible in isolation but improbable when the whole pipeline is too thin or your mix suggests you should be leaning on leasing instead. If you want concrete steps to structure the top-down check, review building a healthy CRE deal pipeline.
Mini-case: How we walk through a four-deal pipeline
We won’t present hypothetical dollar math here. Instead we’ll show the exact steps we run so you can apply them to your numbers:
- Inventory: list the four active deals and tag each with product type (investment vs leasing), whether it’s institutional or private buyer, and the selected commission band for that product.
- Stage and evidence: mark which are Committed vs LOI vs Proposal and attach the key documents or emails that justify that stage.
- Timing: for each, note the payment trigger in contract language and the expected payment timing (signing, funding, commencement). If payment routinely happens after funding, add that lag to the 90-day window check.
- Weight: apply your certainty-bucket policy. If an LOI is subject to financing and there’s no lender term sheet yet, downgrade it inside the LOI band until you get the lender confirmation you require.
- Validate: compare the summed 90-day forecast to your pipeline multiple and historical revenue mix. If the sum exceeds what your pipeline multiple suggests is realistic given trailing revenue, re-open the deals and re-check evidence.
Do this in under an hour for a small brokerage. The point is speed and discipline: evidence-first forecasting beats heroic assumptions.
Common mistakes we see (and how to stop them)
- Rolling all LOIs as closed. Fix: require a finance or title condition to be cleared before upgrading confidence.
- Using one blended commission rate. Fix: maintain explicit product bands and force the analyst to select low/mid/high inside the band.
- Ignoring payment triggers. Fix: surface contract payment language in your pipeline sheet and make payment timing a required field.
- Skipping a top-down sanity check. Fix: compare to pipeline coverage and historical mix every cycle.
Where a CRE-specific tool helps
When you need to make the process fast and auditable, a CRE tool can enforce the discipline above: centralize follow-ups, surface property contact history, and push the right alerts so evidence is current. Use Action Center to prioritize due and overdue follow-ups; use the Property Activities panel or Log Touch to keep contact history attached to each asset; and configure deal stage triggers so required reminders are created automatically. These controls reduce missed next steps and stop warm owners from going cold — and they let you track your acquisitions pipeline in CREflow with the fields you rely on.
Key takeaways
- Forecast at deal level and use product-specific commission bands — no blended averages.
- Be strict about certainty buckets and require evidence to move deals up the chain.
- Map contract payment triggers to cash timing; timing assumptions matter more than marginal rate picks.
- Always validate bottom-up forecasts with a top-down pipeline multiple and revenue-mix sanity check.
FAQ
How granular should my commission bands be?
As granular as you can reliably populate. Separate institutional from private-capital trades, and separate leasing from sales. Keep the band ranges in your sheet and force a low/mid/high selection per deal.
What if a large deal skews the forecast?
Don’t rely on it. Flag it as concentration risk, run scenario sensitivity, and apply stricter evidence thresholds before you count it in the 90-day number.
How often should we refresh the 90-day forecast?
Weekly for active pipelines; biweekly if you have fewer active deals. Refreshing means re-checking stage evidence, payment triggers, and any change to counterparty timelines.
Can we automate this in a CRM or spreadsheet?
Yes — but automation only helps if the fields you automate are disciplined. Automate product bands, stage logic, payment-trigger flags, and the top-down validation checks. Garbage in, garbage out.
What’s the single fastest way to improve accuracy?
Enforce evidence for stage upgrades. That rule alone cuts most optimistic forecast errors.
Before You Forecast This, Check This:
- Do you have product type and chosen commission band for every deal?
- Is there documentation (LOI, lender email, owner approval) to justify the current stage?
- Do payment triggers and typical cash lag put the expected cash inside 90 days?
- Does the 90-day sum pass the pipeline-coverage and revenue-mix sanity check?
- If a single deal moves the forecast dramatically, have you treated it as concentration risk?
Forecasting commissions 90 days out isn’t hard. It’s just discipline: product bands, evidence-based stages, timing mapped to cash, and a quick top-down sanity check. Do that, and your leadership will stop treating your forecast like a suggestion.