California brokerage trust reconciliation brings three balances to the same cutoff date: the control record, the total of the separate beneficiary records and the adjusted bank balance. Then review who owns the money. Matching totals can still conceal a negative client ledger or an unidentified amount.

This worksheet is for California brokerage trust accounts regulated by the Department of Real Estate (DRE), using requirements applicable September 4, 2026. It is an original editorial aid, not an official or DRE-approved form.

Which trust-account records must reconcile?

The three balances answer different questions:

• Control record: What has the brokerage recorded as received and paid out of this bank account? The record tracks receipt details, deposits, disbursements and a daily balance.
• Separate beneficiary or transaction records: Whose money is represented in that balance? Each ledger identifies the parties or transaction and tracks deposits, disbursements, applicable interest and the resulting balance.
• Adjusted bank balance: What does the statement balance become after accounting for documented timing differences and bank errors?

Regulations 2831 and 2831.1 address the first two records, as explained in DRE’s Summer 2019 Broker Compliance Evaluation Manual.

Regulation 2831.2 requires reconciling the separate records to the control record at least monthly, except in months with no bank-account activity. Bank reconciliation is a distinct comparison. DRE’s October 2024 bulletin recommends comparing the control record with the bank statement at a specified cutoff.

Assign both comparisons to the same monthly close in your brokerage operations procedures. A software report showing that the bank matches the books does not, by itself, establish that beneficiary records reconcile.

Prepare one account and one cutoff date

Gather the bank statement, control record, all separate ledgers, prior reconciliation, deposit confirmations, check images and electronic-payment details. Use one bank account per worksheet and export every balance as of the same date.

Complete postings through that cutoff before comparing totals. An August 31 statement cannot be reconciled reliably against a ledger report that includes September transactions. Later clearing evidence can help verify an August outstanding item without changing the August cutoff.

Each entry must remain traceable to the underlying records. Regulations 2831 and 2831.1 allow qualifying accounting systems, including computerized records, when they preserve the required information and permit tracing and reconciliation.

California trust reconciliation worksheet

Account name: Bank/account number:
Balance cutoff: Preparation date:
Prepared by: Reviewed by/date:

Fill the worksheet from attached schedules. Reviewer fields and the investigation log below are recommended controls; they are not additional fields expressly required by Regulation 2831.2.

DRE’s recordkeeping instructions, revised July 2018, explain the relationship between the adjusted statement, control record and separate records.

Attach a schedule listing every beneficiary or transaction name/account identifier and its balance. Show permitted broker funds separately. List positive client balances, negative balances and unidentified amounts separately so the net total cannot hide an exception.

For each outstanding check, record its number, issue date, payee, beneficiary, amount and later clearing evidence. For each deposit in transit, record its date, amount, beneficiary allocation and bank confirmation. Investigate items carried from the prior month instead of automatically rolling them forward.

Example: an outstanding check and a bank charge

Hypothetical August 31, 2026 close for a non-interest-bearing account: The statement ends at $21,180. Check 1048 for $1,200, issued August 28 for Client A, is already deducted from the control record and Client A’s ledger but has not cleared. There are no deposits in transit or bank errors.

The statement also includes a $20 bank service charge missing from the books. Before correction, the control record is $20,000, comprising Client A’s $12,000, Client B’s $7,800 and $200 of identified broker funds for bank charges.

The outstanding check is a timing difference: subtract it from the statement balance, but do not deduct it from the books twice. The bank fee requires a book entry because the bank has already deducted it. In this example, post the $20 against the broker’s fee ledger and the control record; both client balances stay unchanged.

Regulation 2835(a) permits reasonably sufficient broker funds, capped at $200, for bank-assessed service charges or fees. DRE’s October 2024 guidance says to account for those funds in a separate record. That allowance does not explain an unknown overage or authorize a general operating cushion.

Why matching totals can still hide a shortage

Consider a separate hypothetical example with no broker funds or other ledgers: Client A has $10,000, Client B has negative $500, and both the control record and adjusted bank balance are $9,500. All three net totals match. Yet $10,000 remains owed to Client A, leaving a $500 shortage.

DRE’s Trust Funds guide, revised January 2014, calculates aggregate beneficiary liability using positive balances; negative balances do not reduce it.

An unexplained overage also needs investigation. The DRE guide says it must stay in trust, requires a separate record and cannot cover another shortage. Record when it became unexplained and when it was recorded. An “unidentified” ledger entry documents an unresolved issue; it does not establish ownership.

Document the discrepancy and the correction

Start by locating the discrepancy: bank versus control, control versus separate records, or within an individual ledger. Trace the amount to a receipt, deposit, payment, bank debit or posting error.

Use a short investigation log:

Do not insert an unsupported adjustment to make both difference lines zero. For a shortage, unresolved ownership issue or disputed disbursement, promptly involve the designated broker and a California real-estate attorney or accountant experienced in brokerage trust accounting.

Retain the statement, worksheet, beneficiary schedule, outstanding-item schedules, original supporting documents and correction trail together. Business and Professions Code section 10148 requires three-year retention of covered transaction documents, including trust records; the period runs from closing, or the listing date if the transaction is not consummated.

Before sign-off, resolve differences, review individual balances and document outstanding items. Keep any shortage or ownership investigation explicitly open even if the totals match. Include this review in the brokerage’s procedures for real estate regulatory requirements, with enough supporting evidence for the next reviewer to reconstruct what happened.