2.2 Trust Account Accounting & Monthly Reconciliation

2.2 Trust Account Accounting & Monthly Reconciliation

Maintaining a real estate trust account requires rigorous, accurate accounting procedures. The Department of Real Estate (DRE) enforces strict regulatory standards governing how trust fund records are formatted, maintained, and reconciled. A broker cannot simply rely on bank statements to track client money; the broker must maintain a dual-ledger accounting system and perform mandatory monthly reconciliations to ensure complete financial accuracy and protect beneficiary funds.

---

Mandatory Trust Account Accounting Records

Under California law, a broker who maintains a trust account must maintain two distinct sets of accounting records: a general trust log (journal) and individual beneficiary ledgers.

1. Columnar Record of All Trust Funds Received and Deposited (DRE Reg. 2831)

DRE Regulation 2831 mandates that every broker maintain a chronological columnar log (often called the Trust Journal or General Ledger) of all trust funds received, deposited, and disbursed. This record must capture the macro-level movement of money flowing into and out of the trust account.

Required Column Fields (DRE Reg. 2831)

1. Date Received: The exact date the trust funds came into the custody of the licensee.
2. From Whom Received: The name of the buyer, tenant, or party delivering the funds.
3. Amount Received: The exact dollar amount received.
4. Date Deposited: The date the funds were deposited into the trust account (or delivered to escrow/principal).
5. Check / Reference Number: The check number or wire reference number of the deposit or disbursement.
6. Date Disbursed: The date checks or transfers cleared or were issued to payees.
7. To Whom Disbursed (Payee): The name of the beneficiary, vendor, or party receiving the disbursement.
8. Amount Disbursed: The dollar amount paid out.
9. Daily Running Balance: The cumulative cash balance remaining in the trust bank account after each transaction.

---

2. Separate Record for Each Beneficiary or Transaction (DRE Reg. 2831.1)

While the trust journal tracks total bank account activity, DRE Regulation 2831.1 mandates that the broker maintain a Separate Record for Each Beneficiary or Transaction (commonly known as the Beneficiary Ledger or Subsidiary Ledger).

Purpose & Rules of Subsidiary Ledgers

• Micro-Level Tracking: A separate sub-ledger must be created for every single client, buyer, property owner, or transaction (e.g., "Ledger for Purchase of 123 Main St – Buyer Miller" or "Ledger for Rental Property 456 Oak Ave – Owner Davis").
• Prevention of Cross-Collateralization: Subsidiary ledgers ensure that money belonging to Owner A is never used to cover expenses for Owner B. Each client's funds must stand entirely on their own.
• Strict Rule Against Negative Balances: A beneficiary ledger running balance must NEVER drop below zero. A negative balance on any individual ledger indicates that the broker disbursed more money for that client than that client had on deposit. By mathematical necessity, the excess funds disbursed were taken from other clients' money, establishing illegal conversion under California law.

---

Mandatory Monthly 3-Way Reconciliation (DRE Reg. 2831.2)

To ensure that trust records match bank reality, DRE Regulation 2831.2 mandates that every broker holding trust funds perform a 3-way reconciliation of each trust account at least once a month.

The 3 Components of Reconciliation

A 3-way reconciliation requires verifying the mathematical equality of three distinct financial figures:

1. Bank Statement Balance (Adjusted): The ending balance shown on the bank statement, adjusted for outstanding checks (subtracted) and deposits in transit (added).
2. Trust Journal Balance (DRE Reg. 2831): The current running total shown on the Columnar Record of All Trust Funds Received and Deposited.
3. Sum of Beneficiary Ledgers (DRE Reg. 2831.1): The total sum of all individual positive balances across all active beneficiary subsidiary ledgers.

 ┌────────────────────────────────────────────────────────────────────────┐
 │                    THE MANDATORY 3-WAY RECONCILIATION                   │
 ├────────────────────────────────────────────────────────────────────────┤
 │                                                                        │
 │  ┌─────────────────────────┐         ┌──────────────────────────────┐  │
 │  │ Bank Statement Balance  │         │ Columnar Trust Journal       │  │
 │  │ (Adjusted for checks    │  ═════  │ Running Balance              │  │
 │  │  & deposits in transit) │         │ (DRE Reg. 2831)              │  │
 │  └────────────┬────────────┘         └──────────────┬───────────────┘  │
 │               │                                     │                  │
 │               └──────────────────┬──────────────────┘                  │
 │                                  │                                     │
 │                                  ▼                                     │
 │                      ┌──────────────────────┐                          │
 │                      │ Sum of Individual    │                          │
 │                      │ Beneficiary Ledgers  │                          │
 │                      │ (DRE Reg. 2831.1)    │                          │
 │                      └──────────────────────┘                          │
 └────────────────────────────────────────────────────────────────────────┘

$\text{Adjusted Bank Balance} = \text{Trust Journal Balance} = \sum \text{Beneficiary Ledgers}$

If any variance exists between these three figures, the trust account is out of balance, signaling an unrecorded deposit, an unposted check, a bank error, or an illegal shortage.

---

Step-by-Step 3-Way Reconciliation Scenario

To illustrate how the 3-way reconciliation works on the exam, consider the following month-end scenario for Apex Brokerage Trust Account as of May 31:

Step 1: Calculate Adjusted Bank Balance

• Bank Statement Ending Balance: $62,400
• Deposits in Transit (Deposit made May 31, clearing June 1): +$4,500
• Outstanding Checks (Check #104 for $2,100 & Check #107 for $1,800): -$3,900
• Adjusted Bank Balance: $62,400 + $4,500 - $3,900 = $63,000

Step 2: Verify Trust Journal Balance

• The running balance column of the DRE Reg. 2831 Columnar Trust Journal shows exactly $63,000 as of May 31.

Step 3: Sum Individual Beneficiary Ledgers (DRE Reg. 2831.1)

• Beneficiary A (EMD - Buyer Smith): $25,000
• Beneficiary B (Property Management - Owner Jones): $18,000
• Beneficiary C (Tenant Security Deposits - Oak Apts): $12,000
• Beneficiary D (Property Management - Owner Taylor): $7,800
• Broker Allowable Fee Reserve (DRE Reg. 2835): $200
• Total Beneficiary Ledgers Sum: $25,000 + $18,000 + $12,000 + $7,800 + $200 = $63,000

Conclusion: Adjusted Bank Balance ($63,000) = Trust Journal Balance ($63,000) = Total Beneficiary Ledgers ($63,000). The 3-way reconciliation is complete and balanced.

---

Record Retention Mandate (B&P Code §10148)

Under Business & Professions Code §10148, a real estate broker must retain all trust account records, bank statements, cancelled checks, deposit slips, beneficiary ledgers, and monthly 3-way reconciliation worksheets for at least three (3) years.

• The 3-year period begins from the date of closing of the transaction or from the date of listing if the transaction does not close.
• Records must be made available for inspection and auditing by DRE auditors upon request.