Building a Close Worksheet for a Commercial Brokerage

Commission revenue is typically recognized at close of escrow, not when a deal is under contract or even when a letter of intent is signed. A worksheet that tracks every active deal's stage alongside its projected and actual close date gives your close process a clean signal for which deals should have hit revenue this month and which are still pending, catching the common error of booking commission on a deal that hasn't actually closed yet at all.

Each deal carries its own commission split between the agent and the brokerage, sometimes tiered based on the agent's production level for the year. Recording that split at the deal level, not just as a lump commission expense, is what lets the worksheet reconcile total commission income against total agent payouts each month, and it's the specific number most brokerages get wrong when an agent's split changes mid-year and the change doesn't get updated everywhere it needs to, including in any prior deals still working through the payout schedule.

Many states require earnest money and other client funds to sit in a separate trust or escrow account, reconciled independently from the brokerage's own operating cash. This reconciliation isn't optional or a judgment call the way some accruals are; state real estate commission rules typically require it on a set schedule, and a lapse here is a licensing risk, not just an accounting one. Whatever close process you run, this reconciliation needs its own dedicated line item, checked every single month without exception, signed off by name.

Once the worksheet above exists, FloQast's task model is a natural fit for enforcing that each column gets reviewed and signed off monthly, especially the trust account reconciliation, which benefits from a documented, auditable trail. For a single-entity brokerage running through one commission and trust accounting system, that's usually sufficient without a heavier platform, and it keeps the review process consistent even as individual agents or office staff turn over.

The close worksheet needs these columns:

• Deal stage, with the projected and actual close-of-escrow date for every active deal.
• The agent split and brokerage take recorded at the deal level, not just as a lump commission expense.
• Trust or escrow funds held, reconciled independently from operating cash on the schedule state rules require.
• A flag for any deal reopened after being booked, plus property management fee income on its own line.

A brokerage that's expanded into multiple legal entities, perhaps a separate entity for property management fee income alongside the brokerage itself, or one preparing financials for a sale or a merger with another firm, is where BlackLine's consolidation across entities starts to matter more than the deal-level worksheet discipline described above, which stays valuable either way and doesn't get replaced, only supplemented.

A back-office accountant managing commission worksheets and trust reconciliation for a mid-sized brokerage costs somewhere in the national range for accountants and auditors, with the median at $83,680 and the 75th percentile at $109,810 a year¹. For many single-entity brokerages, one experienced hire running this worksheet with discipline outperforms either close platform in the first year or two, particularly since trust accounting compliance depends more on process rigor than on which software tracks the task.

A deal that was recognized as closed but later unwinds, whether from a failed financing contingency discovered late or a title issue, requires reversing both the commission revenue and the agent's payout, and if the payout has already gone out, that reversal becomes a receivable from the agent rather than a clean accounting entry. A worksheet that flags any deal reopened after its recorded close date makes this specific exception visible immediately instead of surfacing months later, during a routine trust or commission audit.

Brokerages that also run a property management arm typically earn a separate, recurring management fee alongside deal commissions, and that revenue stream behaves nothing like commission income: it's steady month to month rather than lumpy around closings. Keeping the two revenue types on separate lines in the close worksheet, rather than blending them into one total, makes it much easier to see whether the brokerage side or the management side is actually driving growth, which matters for decisions about where to add headcount next.