How to Clean Up Real Estate Brokerage Books (Step-by-Step Guide)

Most brokers do not love bookkeeping. And we get it.

Messy books in a real estate brokerage are not just an accounting problem. They are a profit problem.

When commissions are not tracked cleanly, you cannot tell which agents are carrying the brokerage and which ones are costing you money. When trust account activity is mixed with operating cash, you have a compliance exposure on top of the bookkeeping mess.

Here is the step-by-step playbook we use when we clean up a real estate brokerage's books, in the order we usually work through it.

‍

What Clean Books Look Like for a Real Estate Brokerage

‍

Clean brokerage books separate trust funds from operating cash, track commission income by agent and by transaction, allocate overhead at the agent level, and close every month within 15 days of month-end.

The five tests of clean brokerage books: trust and escrow accounts reconcile to the penny every month, every commission deposit ties back to a specific closed transaction, agent splits are tracked per transaction (not estimated quarterly), operating expenses can be sliced by category and by agent, and the P&L is generated within 15 days of month-end.

If a brokerage cannot pass all five, the books need cleanup work before they can support real management decisions.

‍

Step 1: Reconcile Trust and Escrow Accounts First

Trust account reconciliation is the first step in any real estate brokerage books cleanup because it is the area most likely to create compliance exposure.

Most state real estate commissions require monthly trust account reconciliation. In practice, many brokerages skip months or batch the work quarterly, which is where audit findings start.

The reconciliation should match three numbers: the trust account bank balance, the total of individual client ledger balances, and the brokerage's general ledger trust liability balance.

When those three numbers do not match, the gap usually traces to commingled funds (operating expenses paid from trust) or missing transactions (deposits or disbursements never recorded). Fix the gap before moving forward. Skipping trust reconciliation to chase commission income errors is a common mistake; the trust account is the riskier exposure.

‍

Step 2: Separate Commission Income From Other Revenue

Most real estate brokerages have a single revenue line called commission income that hides important detail.

Clean brokerage books separate at least four revenue streams: listing-side commission income, buyer-side commission income, referral fee income (referrals sent or received), and ancillary revenue (rental management, transaction coordination, other fees).

For most brokerages, 90% to 95% of revenue is commission income, per NAR Member Profile data. That means the remaining revenue (often 5% to 10%) is frequently miscategorized and worth surfacing.

When commission income is split by side, you can answer real questions. Is the brokerage winning more listings or more buyer-side business? Are referral fees a meaningful revenue source or just a rounding error?

‍

Step 3: Track Agent Splits Per Transaction, Not Per Period

Agent split tracking is the single biggest source of bookkeeping errors in real estate brokerages.

The clean way to track splits is per transaction, against a specific closed deal. Each closing creates three line items: gross commission to the brokerage, the agent's split (paid out), and the brokerage's net (kept).

When the books are clean, you can run a report showing every agent's GCI, payouts, and brokerage retention for any period. When they are not, you cannot.

DIY systems that track splits in spreadsheets or only at quarter-end commonly miss 5% to 10% of the actual splits due over a year. For a 20-agent brokerage doing $2M in annual GCI, a 5% error rate is $100,000 in unaccounted-for splits. That is the part that costs real money.

‍

How Do You Allocate Overhead at the Agent Level?

Brokerage overhead is meaningless until it is allocated to individual agents. Most brokerages stop at total monthly overhead and never connect it back to which agents are profitable.

Fixed overhead per agent typically includes desk fee or office space, E&O insurance share, CRM and tech stack, and management time allocation. Common monthly ranges at a small to mid-size brokerage: desk space $300 to $500, E&O insurance share $50 to $100, CRM and tech stack $75 to $150, and management time allocation $100 to $200.

Total fixed overhead per agent at a general brokerage usually runs $600 to $1,000 per month. Variable overhead (transaction coordination, marketing support, compliance review) commonly runs $300 to $500 per closed transaction.

Once overhead is allocated by agent, the profit-per-agent calculation becomes possible. Without that step, the books cannot answer the most important question a brokerage owner has.

‍

Step 5: Reconcile Closing Statements Against Your Books

Each closed transaction generates a HUD-1 or ALTA closing statement that should match the deposit in the brokerage's account, the agent's split, and the brokerage's retained net.

In the cleanup phase, pull the last 12 months of closing statements (escrow or title company copies) and reconcile each one against the books. The two numbers that most often mismatch are total commission to brokerage at closing, and adjustments (credits, holdbacks, repair concessions) that change the net to brokerage.

If 5% or more of closing statements do not reconcile, the underlying bookkeeping process needs fixing, not just the historical record.

‍

Step 6: Build a Monthly Close Routine That Holds

A brokerage books cleanup is wasted effort without a monthly close routine to keep them clean.

The close routine should hit the same items every month: reconcile every bank account including trusts, categorize every transaction, confirm agent-split records match closings, run a P&L against the prior month and prior year, run a profit-per-agent report, and flag any agents trending unprofitable, and close the books in the accounting system by the 15th of the following month.

Brokerages that close monthly within 15 days find errors when they are still small. Brokerages that close annually find errors when they are catastrophic. The 15-day window is the difference between a fixable problem and a year-end fire drill.

Our team handles this cadence inside our bookkeeping for real estate agencies service, so the close happens on time without the broker having to chase it.

‍

How Long Does a Real Estate Brokerage Bookkeeping Cleanup Take?

A full real estate brokerage books cleanup typically takes 4 to 8 weeks for a small brokerage (under 20 agents) and 8 to 16 weeks for a larger one.

The work scales with three factors: the number of agents (split tracking complexity), the months of backlog (12 months is standard; 24+ months adds significant time), and whether trust accounts have been reconciled in the past year.

Cleanups that start with a year or more of unreconciled trust accounts take longer because the trust work has to come first, before the commission income work can be validated.

Our accounting for real estate brokers practice runs these cleanups as a one-time engagement followed by ongoing monthly bookkeeping. Once the books are caught up, the monthly close routine prevents the same mess from coming back.

Brokerage books that are clean do not just satisfy tax preparers. They give you the information to decide which agents to invest in, where overhead is bleeding profit, and whether the business model still works the way you set it up.

If your real estate brokerage books are out of date or impossible to trust, the cleanup is doable on a 4 to 8 week timeline. Start with the trust accounts, work through the commission income, then put a monthly close routine in place.

Until next time!