Trust account reconciliation for real estate attorneys
Updated · Rotomal
A real estate attorney's trust account reconciliation is a three-way match: the adjusted bank balance of the trust (escrow) account, the trust balance in the firm's books, and the total of every client or closing-file ledger must all agree, and every difference must be explained by a specific item. The ABA's model rules treat monthly reconciliation as the preferred practice, and many states require it. Closings make it harder than most practices because large sums move in and out within days, so most errors are timing errors: disbursing before a deposit has cleared, or a file left with a small leftover balance.
The three balances, in plain terms
- Adjusted bank balance: the statement's ending balance, plus deposits in transit, minus checks and wires that have not cleared.
- Book balance: the trust bank account as recorded in the firm's general ledger (QuickBooks, Xero or trust software).
- Client ledger total: the sum of every open client or closing-file balance. No individual ledger may be negative.
When all three agree, the account reconciles. When they do not, the reconciliation must list the items that explain the gap, such as a deposit recorded twice or a fee posted to the wrong file, and they get corrected before the next period.
Why closings make trust reconciliation harder
A litigation retainer might see a few entries a month. A single residential closing can see earnest money, a lender wire, seller payoffs, recording and transfer fees, commissions and refunds, all within a week, across dozens of files at once. That volume creates predictable traps:
- Disbursing against funds that have not cleared. Many states have good-funds rules for closings; the ledger can show money that the bank has not yet collected.
- Lender funds arriving after the closing day, so one file is briefly negative.
- Small leftover balances, typically when estimated recording fees exceed the actual fees, that sit for months.
- Payoff and refund checks that are never cashed, which become stale outstanding items.
- Bank or wire fees charged directly to the trust account instead of the operating account.
- Earned legal fees left in trust after the closing, which mixes firm money with client money.
If you also act as settlement or title agent: ALTA Pillar 2
Attorneys who close as title or settlement agents are usually held to the American Land Title Association's Best Practices by their underwriters and lenders. Pillar 2 covers escrow trust accounts. It calls for receipts and disbursements to be reconciled at least daily, and for a monthly three-way reconciliation with a trial balance listing every open escrow balance, in a form that can be verified electronically.
ALTA's Best Practices are not law, but underwriters and lenders expect them, so in practice the bar's monthly reconciliation and ALTA's daily and monthly steps end up as one routine.
A monthly checklist
- Download the trust bank statement as soon as the period closes.
- List deposits in transit and outstanding checks and wires, with their age.
- Compute the adjusted bank balance and compare it to the book balance.
- Run a trial balance of every open file and compare its total to both.
- Investigate every difference until it is explained; never plug it.
- Review negative, aged and small leftover file balances, and refund or disburse what is due.
- Follow up checks outstanding more than 180 days before they become unclaimed property.
- Have the responsible attorney review and sign, and keep the pack for the retention period your state sets.
Doing it from QuickBooks or Xero without a second system
Many small real estate firms keep their books in QuickBooks Online or Xero and track each closing as a sub-customer, class or tracking category. That is enough to build per-file ledgers; the missing piece is the monthly three-way comparison and the daily exception checks.
| Approach | Cost | Trade-off |
|---|---|---|
| Spreadsheet and your bar's template | Free | Works if someone careful does it every month; no alert on the day a file goes negative |
| Dedicated trust-accounting software (for example TrustBooks) | $59–79 a month; $249 done-for-you | Its own trust ledger alongside your accounting system |
| Practice-management suite (Clio, CosmoLex) | Bundled with the suite | Right if the whole firm moves onto it; a big change for reconciliation alone |
| Trust Reconciler | $39–129 a month | Reads your existing QuickBooks or Xero books read-only and produces the signed monthly pack |
Questions
How often does a real estate attorney have to reconcile the trust account?
It depends on your state. The ABA's model rules describe monthly reconciliation as the preferred practice and quarterly as a minimum, and many states require monthly three-way reconciliations. If you also act as a title or settlement agent, ALTA's Best Practices add daily reconciliation of receipts and disbursements.
Is a closing escrow account the same as an IOLTA account?
Not always. IOLTA accounts hold client funds that are nominal or short-term, with interest going to the state's IOLTA program. Closing funds often pass through an attorney trust or escrow account; large sums held for longer may belong in a separate interest-bearing account for that client. Your state's rules decide which applies.
What should I do with a small leftover balance on a closed file?
Find out why it is there, refund it to the party entitled to it, and document the disbursement. If the owner cannot be found, follow your state's unclaimed property rules rather than moving it to operating.
Is this legal or compliance advice?
No. This guide and Trust Reconciler are record-keeping tools, not legal or ethics advice. Confirm your obligations with your state bar's trust-account rules or your own counsel.
Sources
- ABA Model Rules on Client Trust Account Records, commentary: monthly reconciliation is the preferred practice; quarterly is a minimum. Source: americanbar.org
- ALTA Best Practices (2019 update, effective 2020): daily reconciliation of escrow receipts and disbursements and a monthly three-way reconciliation with trial balance. Source: alta.org
- TrustBooks lists trust accounting at $59–79 a month and a done-for-you tier at $249 a month. Source: trustbooks.com