Real Estate Escrow Account Reconciliation for Brokers

A real estate escrow account reconciliation checks, each month, that the broker's escrow or trust bank account, the broker's record of all trust funds and the separate record for each transaction agree. Reconcile the bank to the trust journal first, then compare the journal to the total of earnest money ledgers. A gap means a shortage or an error.

What a real estate escrow account reconciliation compares

A real estate escrow account reconciliation compares three records: the bank statement for the broker's trust account, the broker's dated record of every trust receipt and payment, and the ledger kept for each buyer, seller or transaction. When the bank after timing items equals the journal, and the journal equals the sum of the ledgers, the account is in order.

State real estate regulators set the details, and they differ. California is a useful example because its regulator publishes what its auditors look for. The California DRE guide to common violations found in audits describes three linked records under the Commissioner's regulations:

• The record of all trust funds received and paid out (Regulation 2831), kept in columns and in date order, showing the date received, the payor or payee, the amount, the deposit date, amounts paid out with check number and date, and a daily running balance. The guide says a broker should keep one for each trust account.
• A separate record for each beneficiary or transaction (Regulation 2831.1), showing deposits, payments and a running balance for that one person or deal.
• A monthly reconciliation (Regulation 2831.2) of the total of the separate records to the balance of the record of all trust funds, required at least once a month unless the account had no activity.

The guide adds a point that is easy to skip: for that reconciliation to mean anything, the record of all trust funds must first be reconciled to the bank statement as of a cut-off date. So the month's work is really two comparisons, done in order.

Title and escrow companies run a similar exercise at much higher volume, with their own conventions for open files and disbursement ledgers. That version is covered in title escrow reconciliation for settlement agents.

Earnest money records for each real estate transaction

An earnest money record is the separate ledger a broker keeps for one transaction, showing the buyer's deposit, any later deposits, each payment out and the balance still held. It answers the question the bank statement cannot: how much of the account belongs to this deal, and to whom it will go.

Each transaction ledger should carry, at a minimum:

• the property address and the parties, so the ledger can be matched to the file
• the date and amount of each deposit, with the payor's name and check or reference number
• each disbursement, with the payee, check number, date and amount
• a running balance after every entry

Timing rules also bear on the ledger. The California guide says brokers must place funds received on behalf of others into a trust account, a neutral escrow depository or the owner's hands no later than three business days after the broker or salesperson receives them. It also lists, as a common violation, failing to place an offeror's check into escrow or a trust account in a timely manner after the offer is accepted. A broker holding an uncashed earnest money check needs a record of that check too, with the reason it is held and the instructions that allow it.

A ledger that is right on day one can still drift. Earnest money is often refunded, forfeited or transferred to a title company, sometimes in parts. Each of those events should appear as an entry with a reference to the instruction that authorised it, so a reviewer can tie the movement to the file.

How do you reconcile the broker escrow bank statement first?

Reconcile the broker escrow bank statement by starting from the statement's ending balance, adding deposits recorded but not yet credited by the bank, and subtracting checks issued but not yet paid. The result, called the adjusted bank balance, should equal the ending balance in the record of all trust funds on the same cut-off date.

The cut-off date is the day after which no activity counts for this reconciliation, usually the last day of the month. Pick it once and use the same date for the bank, the journal and the ledgers. Mixing a month-end statement with a journal printed on the 5th of the following month guarantees a difference that has nothing to do with errors.

The work, in order:

1. Confirm the statement's opening balance equals last month's closing balance, and that the deposits and withdrawals on the statement add up to its closing balance.
2. Tick each statement line against the journal. Items on both are cleared.
3. List journal deposits not on the statement as deposits in transit, and journal checks not on the statement as outstanding checks.
4. List statement lines not in the journal, such as bank charges, returned items or wires nobody recorded. Each needs a journal entry or an explanation.
5. Compute the adjusted bank balance and compare it to the journal.

When a bank charge appears on the trust statement, record it promptly; a fee taken from trust funds reduces money that belongs to buyers and sellers. Associations run into the same discipline with reserve and operating accounts held for owners, as described in HOA bank reconciliation for community associations.

Is the broker escrow account short of its trust fund liability?

An escrow account is short when the cash in the bank, after timing items, is less than the broker owes to all the people whose money it holds. That owed amount, the broker's trust fund liability, is the total of every positive transaction ledger. Comparing the two each month is the test that matters most.

California's guide defines the condition plainly. Under Regulation 2832.1, a trust fund shortage exists when the bank balance is less than the broker's total trust fund liability to all owners, and the broker did not have written consent from every owner before the disbursement that caused it. The guide notes that the obvious cause is intentional misuse, but that undetected record keeping errors can produce the same result, for example a disbursement that was never recorded, or a deposit recorded too high on a beneficiary's ledger. An overstated ledger is more likely to be paid out in full, and the payment creates a real loss.

Example tie-out for one month

The figures below are an example for a broker trust account at 30 April 2026. The transactions and amounts are invented.

All three figures agree at 24,000.00. If the ledgers had totalled 25,000.00 while the bank and journal showed 24,000.00, the account would be 1,000.00 short until the cause was found.

Broker escrow problems the monthly review should catch

The monthly broker escrow review should catch the problems that the arithmetic alone can miss: broker money mixed with client money, checks held longer than the instructions allow, and balances that stopped moving long ago. A reconciliation that balances can still contain all three.

• Commingled broker funds. The California guide describes commingling as including the deposit of trust funds into the broker's general business account, and keeping more than 200 dollars of broker funds in a trust account. Look for broker deposits on the journal and for trust receipts that went to operating.
• Held or late deposits. An earnest money check recorded on the ledger but not deposited within the required time is both a timing item and a compliance question.
• Stale ledgers. A transaction ledger with a balance months after closing or cancellation means money is owed to someone. Research it, refund it or follow your state's process for funds nobody claims.
• Unauthorised signers. The guide also lists signers who lack the broker's written authorisation, or the required fidelity coverage, among common findings. The review is a natural moment to compare the bank's signer list with the authorisations on file.
• Unusual payments. A disbursement to a payee who is not a party to the transaction, or a round-number transfer with no file reference, deserves a question. The broader patterns are listed in fraud red flags in bank statements.

A monthly broker escrow reconciliation checklist

A monthly broker escrow reconciliation checklist turns the steps above into a record the broker can sign and keep. Complete it for each trust account with activity in the month, attach the bank statement and the ledger listing, and file it where an auditor will find it. The list below is an example; adapt it to your state's rules.

1. Choose the cut-off date and print or export the statement, the trust journal and the ledger listing as of that date.
2. Confirm the statement foots from opening to closing balance.
3. Reconcile the bank to the trust journal and list every outstanding item with its date.
4. Record any bank-only items, such as charges or returned deposits, in the journal and on the correct ledger.
5. Total the transaction ledgers and compare the total to the journal.
6. Check that no transaction ledger is negative.
7. Compare the adjusted bank balance to total trust fund liability and note any shortage.
8. List outstanding items older than one month and the action taken on each.
9. List ledgers for closed or cancelled transactions that still hold money.
10. Scan the journal for broker deposits, transfers to operating and payees outside the transaction.
11. Sign and date the reconciliation, with the reviewer's name.

Step 2 is easy to skip and expensive to get wrong, because every later figure starts from the statement. PreciseBankFlow foots each statement and matches its lines to the trust journal, so the broker starts the review knowing which items cleared and which did not.