Guides
Bank statement = trust ledger = sum of all beneficiary balances. Here is how to prove it every month, and what to do when it doesn't.
Updated 2026-07-16 · TrustRecon research team
Trust account reconciliation is not the same as a bank reconciliation. Most property managers are comfortable reconciling a bank statement against a general ledger — two legs. Three-way reconciliation adds a mandatory third leg: the sum of every individual beneficiary balance held in the trust account must independently agree with the other two. All three numbers must be identical to the penny before the month is closed.
The three legs are:
The phrase property management trust account reconciliation sometimes refers informally to only the first two legs — bank versus books. Regulators use the three-way standard. A shortage is only visible in the third leg: you can have a perfectly balanced bank-to-books reconciliation while simultaneously holding insufficient funds to cover every owner's sub-ledger, because one owner's negative balance is silently funded by another owner's deposits in the same pooled account.
| Leg | Source | Example Amount |
|---|---|---|
| ① Adjusted bank balance | Bank statement $142,850 + deposits in transit $3,200 − outstanding checks $1,050 | $145,000.00 |
| ② Trust journal balance | Property management software trust control account as of month-end | $145,000.00 |
| ③ Sum of beneficiary balances | Owner A $61,400 + Owner B $38,600 + Owner C $22,500 + Security deposit register $22,500 | $145,000.00 |
When all three figures match, the reconciliation ties. When they do not, the difference is not a rounding issue — it is a signal that client funds are either missing, misallocated, or both.
Three-way reconciliation is a statutory obligation in every state that licenses property managers. California codified the requirement at Reg. 2831.2, which mandates that a broker reconcile trust account records against the bank statement at the close of each calendar month and retain the completed worksheet for three years. Florida's equivalent is FREC Rule 61J2-14.012(2); Colorado's is 4 CCR 725-1 Rule 5.14; Washington's is WAC 308-124E-105; Arizona enacted ARS 32-2151(C)(5) in 2024. The rule numbers differ; the obligation does not.
The California DRE's FY 2023-24 audit summary makes the enforcement reality concrete. The DRE conducted 361 audits of licensed real estate offices and property management companies. 57% identified recordkeeping violations; 32% found actual trust account shortages totaling approximately $3.5 million. In one audit, a company's internal reconciliation "showed no discrepancy" — the DRE's three-way comparison found a shortage of at least $46,729.72. The bank statement balanced. The books balanced. Only the sub-ledger comparison exposed the gap.
California Reg. 2831.1 separately requires each owner's sub-ledger to be maintained in columnar format showing the date and amount of every deposit, the payor, the check number, the date and check number of every disbursement, and a running balance after each transaction. That granularity is what makes the third leg of the reconciliation computable.
Collect the trust bank statement for the month just closed, the trust account register from your property management software, a trial balance of all owner sub-ledgers, the security deposit register, and the prior month's completed reconciliation worksheet.
Start with the bank statement closing balance. Add deposits in transit (recorded in your books before month-end, not yet posted by the bank). Subtract outstanding checks (issued before month-end, not yet cashed). The result is leg one.
Pull the trust control account balance as of the last day of the month from your property management software. It should reflect every receipt and disbursement posted during the period. This is leg two. Any difference from leg one must be explained by a specific, named item — bank fees, returned items, a posting error — before proceeding.
Run a sub-ledger trial balance showing the closing balance for every owner sub-ledger and every property. Add the total of all active tenant security deposit register entries. Sum every balance. This is leg three. Never offset a negative sub-ledger against a positive one — a negative balance on any owner sub-ledger is itself a violation under California Reg. 2832.1, because it means disbursements exceeded that owner's available funds, with the shortfall covered by another client's deposits.
Legs one, two, and three must be identical to the penny. Any variance requires a written explanation tied to a specific transaction — a check number, a deposit date. Arizona ARS 32-2151 requires that every reconciling item be identified individually. "Timing difference" is not an acceptable explanation.
Prepare the reconciliation worksheet showing all three legs, the outstanding checks list with check numbers and issue dates, the deposits-in-transit list, and the variance explanation. The responsible broker must sign and date the worksheet. An unsigned reconciliation is treated by state auditors as a missing one.
California B&P §10148 requires trust account records to be retained for three years. Arizona ARS 32-2175 sets the same period. The obligation survives the end of a management agreement. Store signed worksheets, bank statements, sub-ledger trial balances, and deposit registers together so any item from the prior 36 months can be produced immediately on auditor request.
When a disbursement is processed against an owner sub-ledger that lacks sufficient funds, the sub-ledger goes negative. The pooled trust bank balance stays positive because other owners' money fills the gap silently. The bank-to-books reconciliation passes. The three-way fails: the sum of all sub-ledger balances — once negative ones are correctly included rather than ignored — no longer equals the bank balance. NCREC documented a case where a broker paid a $1,000 water heater bill against an account holding only $200, with the $800 shortfall invisible in a $50,000 pooled trust until the three-way comparison was applied.
A rent payment is entered in the software and credited to the tenant and owner sub-ledger. The check or cash never reaches the bank. Leg two shows the receipt; leg one does not. California Reg. 2831.2 and Texas TREC §535.146 both specify deposit windows (three and two business days, respectively) — missing that deadline is a separate violation from the reconciliation failure it creates.
A payment cleared in Month A's bank reconciliation is voided in Month B. The reversal carries a Month B date. The positive and negative entries now sit in different reconciliation windows. Month B's adjusted cash balance is permanently off by the voided amount. This is among the most common causes of persistent, unexplained adjusted cash balance differences in AppFolio and Buildium environments.
A payment posts to the trust control account but is never allocated to a specific owner sub-ledger — often because the payment arrived without a unit number or tenant name. Leg two includes the receipt; leg three does not. The unallocated amount accumulates in a suspense account, and the sub-ledger sum falls short of the bank and journal balances by exactly that amount.
An owner distribution or deposit refund check issued in January is voided in April after going uncashed. Voiding removes it from the outstanding check list, so the adjusted bank balance rises by the check amount. If the voided amount is not re-credited to the original owner or tenant sub-ledger, leg three falls short of legs one and two by precisely that amount. The cash is in the bank but belongs to no identified beneficiary, and eventually becomes subject to state escheatment.
If a management fee is deducted from the owner sub-ledger in the software but the corresponding transfer from the trust account to the operating account is delayed or mis-posted, legs two and three show the fee as disbursed while leg one still includes the cash. The reverse also occurs when the transfer precedes the software posting. Either sequence creates a leg disagreement.
Security deposits create a running liability equal to every active tenant's deposit balance. When a deposit is received and credited to the bank but not entered on the register, or when a move-out occurs and the register is not updated, the register total diverges from the escrow bank balance. The deposit register is itself the sub-ledger for the security deposit escrow account and must be included in leg three. Any difference between the escrow bank balance and the register total is a standalone violation.
State auditors follow structured audit packets. Based on documented audit guidance from the California DRE, NCREC, and Arizona ADRE, these categories are consistently requested:
Documentation that cannot be produced is treated as evidence of improper maintenance — an independent violation separate from what the missing records might have shown.
Yes. In states requiring separate accounts for security deposits and rental receipts — Colorado 4 CCR 725-1 Rule 5.11 is one example — each account must be independently reconciled. The deposit register serves as the sub-ledger for the security deposit escrow, and the register total must equal the escrow bank balance every month. Combining the two accounts' balances for reconciliation purposes is itself a violation: the funds belong to different classes of beneficiaries (tenants versus owners) and must not be commingled.
A deposit still listed as in-transit after five business days — or reappearing in a second consecutive monthly reconciliation — is no longer a timing item and requires investigation. California DRE audit records document cases where large unexplained variances traced entirely to amounts listed as deposits in transit that never reached the bank. Contact the bank, confirm whether the deposit was received, and identify the cause. Leaving it listed as a timing item and closing the month is not acceptable.
Three years is the baseline in most states — California B&P §10148 and Arizona ARS 32-2175 both specify this period. The obligation continues after a management agreement ends. Retention covers not just the signed worksheets but also the source documents: bank statements, sub-ledger trial balances, deposit registers, and the transaction detail supporting each entry. Failure to produce any item within the retention window is itself a recordkeeping violation, independent of whether the underlying numbers were correct.
For an independent review of your trust account records — whether as preparation for a state audit or a routine compliance check — TrustRecon's free initial assessment identifies where reconciliation records fall short of state requirements. See also: why Buildium reconciliations fail to balance and the complete trust account audit checklist.
Upload three exports. Within 48 hours you get a discrepancy report with every finding tied to a record ID. Built from the same failure patterns state auditors look for.
For property management companies on Buildium or AppFolio. No call required.