Real Estate Broker Trust Account Reconciliation: The Three-Way Match That Protects a License

A single $5,000 earnest money deposit, dropped into the wrong bank account by a stressed assistant on a Friday afternoon, has ended careers. Not because the broker stole the money — they didn't — but because for forty-eight hours that buyer's deposit sat next to the brokerage's payroll, the rent check, and the office Costco card. That's commingling. Every state real estate commission in the country treats it as grounds for license suspension or revocation, even when nobody loses a penny.

Trust accounting is one of the few areas in small-business bookkeeping where the math has to be perfect to the cent, every month, with three independent records in agreement — and where getting it wrong can end the business overnight. This guide walks through how brokerages comply with state real estate commission rules on earnest money deposits, run a three-way reconciliation between the bank, the general ledger, and individual client sub-accounts, document pending-sale deposit handling under statutory holding periods, and avoid the license suspension and bar discipline that follow even an accidental commingling.

Why Earnest Money Is Different From Every Other Dollar in the Brokerage

When a buyer signs a purchase contract and writes a check for earnest money, that money does not belong to the brokerage. It does not belong to the seller yet, either. It belongs to the buyer until certain contract conditions are met — and the brokerage holds it in a fiduciary capacity until the contract tells it where the money goes.

Three things follow from that fiduciary capacity:

The money has to be physically separated. It goes into a dedicated trust account at a state-approved bank, titled in a way that makes clear the funds are held for clients. Operating revenue does not touch it. The broker's own money does not touch it (with two narrow exceptions discussed below).
Every dollar has to be traceable to a named beneficiary. The brokerage has to know, at any moment, exactly how much of the total trust balance belongs to which buyer, which transaction, and which property.
The records have to be reconcilable to three independent sources every month. The bank says one number. The brokerage's internal trust ledger says another. The sum of every client sub-ledger says a third. All three have to agree, on paper, with a signed worksheet, every month.

That last requirement is the three-way reconciliation. It is the single most-cited compliance item in state real estate commission audits, and the most common reason brokers get disciplined.

The Three-Way Reconciliation, Explained

Imagine the brokerage holds earnest money for fifteen pending sales at the end of the month. The total in the trust account at the bank is $187,500 according to the bank statement.

The three-way reconciliation answers three questions at once:

Bank balance. What does the bank say is in the trust account, after adjusting for outstanding checks and deposits in transit? This is the adjusted bank balance.
General ledger balance. What does the brokerage's internal "trust account" line item say, recording every receipt and disbursement chronologically in a single running register?
Sum of sub-ledgers. When you add up the balance owed to every individual buyer, seller, or tenant across all fifteen open transactions, what's the total?

All three numbers must be identical. If the bank says $187,500, the GL says $187,500, and the sub-ledgers add up to $187,500, the brokerage is reconciled. If any one of the three is off by even a dollar, the broker cannot sign the worksheet until the variance is found and explained.

That sounds simple. In practice, the things that break a reconciliation are mundane:

A check the brokerage cut for a closing was never cashed by the title company; it shows as an outstanding check on the bank side but the sub-ledger has already been zeroed out.
An earnest money deposit was recorded in the buyer's sub-ledger but the deposit slip never made it to the bank — the cash is sitting in the assistant's desk.
The bank charged a wire fee against the trust account by mistake. The GL doesn't know about it.
A buyer's check bounced; the brokerage recorded the original deposit but not the NSF.

Each of those is a real audit finding documented somewhere in a state real estate commission's bulletin. None of them require dishonesty — they just require ordinary human mistakes that nobody catches because nobody is doing the three-way match.

The Mechanics of a Compliant Trust Account Workflow

State requirements vary in the details, but the operational template is consistent across jurisdictions like California, North Carolina, Oregon, Colorado, Arizona, and Nevada.

Opening and titling the account

The trust account has to be at a federally insured bank in the state where the brokerage is licensed (some states allow out-of-state banks if the funds are federally insured; check the specific statute). The account is titled in a way that signals fiduciary capacity — for example, "Smith Realty LLC — Trust Account" or "Smith Realty LLC, Broker, as Trustee for Clients." A plain "Smith Realty Operating" account does not qualify.

The broker named on the license must be a signatory on the account. In California, this is a Section 10145 requirement, and the failure to have the designated officer as a signatory is one of the most-cited audit deficiencies.

Most states allow the broker to earn interest on the trust account only if it flows to the beneficiary or to a state-approved housing trust fund (in California, for example, interest-bearing trust accounts route earnings to specific authorized recipients, not to the broker).

Receiving an earnest money deposit

When a buyer's check arrives at the brokerage, the workflow is:

Log the check. Date, amount, payor name, transaction it relates to, and the receiving agent.
Deposit it within the statutory window. Most states require deposit by the next business day or within three banking days. Some states (Florida, for example) require deposit by the end of the third business day after receipt of the contract. Holding a buyer's check in a drawer over a long weekend because "the contract isn't ratified yet" is a common violation.
Record it in two places simultaneously. Once in the general trust ledger (the chronological register of every receipt and disbursement across all clients) and once in the individual sub-ledger for that specific transaction.
Create or update the transaction file. Both parties' names, the property address, the deposit date and amount, and any contingencies that affect when the money can be released.

The sub-ledger is the part that bookkeepers new to real estate often underweight. It is the document that proves, on a transaction-by-transaction basis, exactly how much of the trust balance belongs to each party — and it is the document that the state auditor walks through line by line during a routine examination.

Holding the deposit through contingencies

Once the deposit is in trust, it sits there until a contractual or statutory condition releases it. Most contracts run the deposit through inspection, financing, appraisal, and title contingencies, with specific calendar deadlines. Each contingency is either satisfied (the deposit becomes non-refundable to that extent) or fails (the buyer is entitled to the deposit back).

State statutes set the outside boundary. In most states, if a transaction does not close and the parties disagree about who gets the deposit, the broker cannot just pick a side. The broker must either:

Continue holding the funds until the parties agree in writing,
Interplead the funds into the local court (deposit them with the clerk and let a judge decide), or
Follow a state-specific procedure such as Florida's escrow disbursement order request to the state real estate commission.

What the broker absolutely cannot do is release the funds to whichever party threatens to sue first. That is a license-discipline event in every state.

Disbursing at closing or upon termination

When the deal closes, the deposit is typically wired to the title or escrow company as part of the buyer's funds to close. The journal entry is straightforward: debit the buyer's sub-ledger to zero, credit the trust cash account, record the check or wire reference in the chronological register.

When a deal dies cleanly and both parties sign a mutual release, the broker disburses the deposit per the release and zeros out the sub-ledger the same way.

Every disbursement check must show date, check number, payee, amount, and which transaction it relates to — both on the check itself (in the memo) and in the sub-ledger.

Commingling: What Counts and What Doesn't

The line between a clean trust account and commingling is bright, but a handful of exceptions exist that confuse new bookkeepers.

What counts as commingling:

Depositing a buyer's earnest money into the brokerage's operating account, even temporarily.
Leaving earned commissions in the trust account after a closing instead of sweeping them to operating within the state's deadline (often as little as 25 days in California once a deal closes and the broker's portion is determined).
Paying any operating expense — rent, marketing, payroll, even a refund to the brokerage — out of the trust account directly.
Letting a client deposit cover a bank fee that the broker should have paid from operating.

What does not count as commingling (in most states):

A small broker-owned cushion held in the trust account specifically to cover bank service charges. California permits up to $200 for this purpose; other states have similar small allowances. The cushion has to be tracked as a separate sub-ledger entry called something like "broker funds — bank fees."
Funds that belong partly to the broker and partly to a client, held temporarily, as long as the broker's portion is disbursed within the statutory window (25 days in California) and there is no dispute about who gets what.

The pass-through-check exception is also worth knowing. In California, if a buyer hands the brokerage a check made payable directly to an escrow company, credit reporting service, or appraiser, and the total of such pass-through checks does not exceed $1,000 per transaction, the broker is not required to keep the detailed trust account records that would otherwise apply. The check is just forwarded. Above that threshold, full trust accounting kicks in.

The Monthly Reconciliation Worksheet

The reconciliation worksheet is the single document a state auditor will demand first. It should be signed by the broker, dated, and retained for the state's record-retention period (typically three to six years; some states require seven).

A workable worksheet has four sections:

Bank reconciliation. Ending bank balance + deposits in transit − outstanding checks = adjusted bank balance.
General ledger reconciliation. Ending GL balance, with the running total tied to the chronological register.
Sub-ledger summary. A line for every open transaction with its current sub-ledger balance, summed at the bottom.
Three-way match. All three adjusted balances on the same page, side by side, with a difference column. The difference column must read zero on every row.

If the three balances don't match, the broker cannot sign the worksheet. The broker writes the variance, investigates, and either corrects the error before signing or documents the unresolved discrepancy in writing for the file. State auditors will accept a documented, in-progress variance with a clear remediation plan. They will not accept a signed worksheet that papered over a difference.

Bookkeeping Setup That Survives an Audit

A few practical principles separate trust accounting that survives audits from trust accounting that doesn't.

Use a separate accounting system or a separate chart-of-accounts module for the trust account. Mixing trust transactions into the same QuickBooks file used for operating revenue is permitted in many states but invites errors. A clean separation — a separate accounting file, or at minimum a separate dedicated set of accounts that no operating transaction can touch — eliminates a whole class of mistakes.

Treat every transaction as a two-entry event. Every earnest money receipt updates the general ledger and the sub-ledger in the same posting session. Tools that automatically generate both entries from a single input reduce the risk of a deposit landing in the bank with no sub-ledger record (or vice versa).

Reconcile on a fixed calendar. Pick a date — the fifth of the month, the day after the bank statement closes — and reconcile then, every month, without exception. State auditors look at the pattern of reconciliation dates as a signal of whether the broker takes the obligation seriously.

Keep the deposit receipt chain physical and digital. The buyer's check, the deposit slip, the bank confirmation, and the journal entry all need to tie out. Keeping a scan of each deposit slip stapled (or attached) to the journal entry is a low-cost habit that pays off when an auditor asks "show me where this $5,000 came from."

Maintain a separate ledger row for broker-owned funds in trust. That $200 service-charge cushion needs its own sub-ledger entry so the three-way reconciliation includes it. Treating it as "the float" without recording it is exactly how brokers accidentally commingle.

State-Specific Wrinkles Worth Knowing

The general framework above is consistent across the United States, but a few state-specific quirks have tripped up brokers.

California: The $200 bank-fee cushion and the 25-day rule for releasing broker-owned funds after a closing are codified in Title 10 of the California Code of Regulations. Failure to have the designated broker as a signatory on the trust account is one of the top-cited audit findings.
Florida: The deposit must be in trust by the end of the third business day after the broker receives the contract; the broker can ask the state for an escrow disbursement order if the parties dispute the funds.
North Carolina: Detailed columnar records (date, payor, payee, transaction reference, check number, running balance) are required, and the state publishes an internal-controls checklist that mirrors what auditors review.
Oregon: Each clients' trust account and each security deposit account must be reconciled monthly under ORS 696.241; commingling is grounds for license discipline regardless of intent.
Arizona: ARS § 32-2151 requires a monthly three-way reconciliation with an explanation for any variation, and the explanation has to be in writing.
South Dakota: Failure to reconcile bank, trust ledger, and check register at least monthly is a direct statutory violation of SDCL 36-21A-80.
Nevada: Annual reconciliation reports must be filed with the Division of Real Estate on a state-provided form, in addition to the monthly internal reconciliations.

Brokers operating in multiple states need to maintain separate trust accounts and separate reconciliation procedures for each, calibrated to the most restrictive of the applicable rules.

What Triggers an Audit — and What Auditors Look For

Most states audit on a rolling schedule (every two to four years for an active brokerage) and audit out-of-cycle in response to a complaint. A consumer complaint about a missing deposit, a bank notifying the state of an overdraft on a trust account, or a new broker-of-record appointment can each trigger an out-of-cycle review.

When the auditor arrives, the typical request is:

The trust account bank statements for the last twelve to twenty-four months.
The general trust ledger for the same period.
All client sub-ledgers covering open transactions and a sample of closed transactions.
The signed monthly three-way reconciliation worksheets.
The deposit slips, cancelled checks, and supporting transaction files.
The brokerage's written trust account procedures.
A list of every signatory on the trust account.

The audit then walks transactions from origination (the buyer's check arriving) through deposit, holding, and disbursement, checking that every leg ties out to the same number in the GL, the sub-ledger, the bank statement, and the transaction file. A clean audit takes a day or two. A messy one takes weeks, generates a deficiency notice, and the brokerage has to respond in writing with a remediation plan and timeline. Repeat or serious findings escalate to license suspension or revocation.

The Cost of Getting It Wrong

The penalty range is wide and depends on the state and the severity of the finding. Common consequences include:

Administrative fines. Per-violation fines in the $1,000–$10,000 range are typical for paperwork deficiencies. Substantive commingling or misappropriation findings can carry six-figure aggregate penalties.
License suspension. Suspensions from 30 days to several years are common for serious or repeated violations.
License revocation. Permanent loss of the right to practice real estate in the state, which usually ends the brokerage as a going concern.
Civil liability to clients. Even if the state pursues administrative action, affected clients can sue separately for breach of fiduciary duty and recover damages.
Bond claims. Many states require brokerage surety bonds; mishandled trust funds trigger bond claims that the bonding company will pursue against the broker personally.
Criminal exposure. When commingling crosses into outright misappropriation — using client funds for personal expenses — criminal theft and embezzlement charges follow.

The asymmetry matters: the upside of cutting corners on trust accounting is zero (it doesn't save material time), and the downside is career-ending. There is no other line item in a brokerage's bookkeeping where that is true.

Keep Your Books Audit-Ready From Day One

Trust accounting works because every transaction leaves an unbroken paper trail from the buyer's check to the closing wire — a trail an auditor can walk, a defense attorney can produce, and an aggrieved client can audit themselves. The brokerages that handle this well treat their general ledger and sub-ledgers as the source of truth and use software that makes commingling structurally hard rather than relying on discipline alone.

Beancount.io provides plain-text, double-entry accounting that gives brokerages complete transparency over every dollar that moves through the trust account — every receipt, every disbursement, every sub-ledger balance — with full version history and no vendor lock-in. When a state auditor asks "show me how this $5,000 moved from the buyer's check on March 3 to the title company's wire on April 17," the answer is a plain-text ledger and a diff, not a screenshot. Get started for free and see why brokerages and finance professionals choose plain-text accounting for the books that have to be perfect.