Three-way trust account reconciliation compares the adjusted bank statement balance, the trust cash control balance, and the total beneficiary subledgers at the same cutoff. All three must agree, but equal totals alone do not prove that funds were handled lawfully or that every beneficiary has enough money. The reconciliation itself is not a posting event.
Difference? Explain timing, missing, or duplicate items before calling it reconciled.
Name the three records before comparing them
The bank statement is external evidence of cleared cash. The cash control is the firm’s trust receipt/disbursement journal or general-ledger cash balance. The beneficiary trial balance lists money owed to each owner, tenant, or other entitled party. This example is the manager’s separate fiduciary record set, not its corporate revenue ledger and not each owner’s rental P&L. Trust cash is not the manager’s spendable operating cash.
A normal bank reconciliation compares bank and books. The third comparison tests allocation to beneficiaries. Start with the same bank account, statement period, and timestamp; do not combine accounts to hide a shortage.
Worked example: adjust the statement, not the income
Assume a USD trust account at October 31 with a $25,300 statement ending balance. A $1,200 receipt recorded October 31 is a deposit in transit and clears November 2. Checks totaling $2,000 were recorded in October but clear in November. Neither item is missing from the books. There are no bank errors, bank fees, permitted firm funds, or interest in this simplified example.
| Item | Adjustment | Balance |
|---|---|---|
| Statement ending balance | Starting point | $25,300 |
| Deposit in transit | +$1,200 | $26,500 |
| Outstanding checks | −$2,000 | $24,500 |
| Adjusted bank balance | Compare with trust cash control | $24,500 |
| Trust cash control | Already includes receipt and checks | $24,500 |
| Difference | $24,500 − $24,500 | $0 |
Tie the beneficiary trial balance
| Beneficiary | Ending obligation | Control evidence |
|---|---|---|
| Owner A funds | $10,000 | Owner ledger and disbursement register |
| Owner B funds | $8,500 | Owner ledger and disbursement register |
| Tenant deposit obligations | $6,000 | Separate tenant-by-tenant list |
| Total beneficiaries | $24,500 | Equals control and adjusted bank |
The $6,000 tenant category must itself reconcile to named tenants; it is not a substitute for individual subledgers. The outstanding $2,000 checks have already reduced both the control and the relevant beneficiary ledgers. Subtracting them again from the $24,500 beneficiary total would double-count the disbursements. The deposit in transit is already assigned to its beneficiary.
Investigate differences without inventing an entry
If the bank and control tie but beneficiaries total $24,700, investigate a $200 allocation/control discrepancy. Do not book $200 of expense simply to make the worksheet green. If a documented bank fee is missing, establish who legally bears it, record the actual omitted event with approval, then rerun the reconciliation. Corrections must preserve the original evidence and the beneficiary affected.
A negative Owner B balance cannot be cured by borrowing Owner A’s positive balance. Even when net totals agree, inspect individual deficits, unallocated receipts, stale checks, pending refunds, and authorized fee transfers. Subsequent clearing confirms a timing explanation; unexplained old items need investigation rather than indefinite carryforward.
Monthly controls are jurisdiction-specific
The North Carolina Real Estate Commission’s reconciliation guidance describes monthly balancing of the bank statement, books, and property trial balance and references Rule A.0117(e). It calls reconciliation within 48 hours of receiving a statement a best practice, not an NCREC requirement. This is a North Carolina broker example; verify the current rule, license type, retention duties, and state requirements with counsel or the regulator.
- Retain the statement, outstanding-item list, cash journal, and dated beneficiary trial balance.
- Trace each timing item to the next statement or document an investigation.
- Review deficits and unallocated balances individually, not just net totals.
- Document preparer, independent reviewer, findings, and corrections.
- Do not call reconciliation a certification of trust compliance.
Keep the trust workflow in a suitable system
Sofia AI is not a complete trust-accounting or compliance system. Standard bank setup does not offer Trust mappings. Some existing trust-related workflows remain partial; their presence does not establish a compliant beneficiary ledger or disbursement process. Chat cannot authorize or execute trust disbursements, generate owner statements, complete reconciliations, or change period locks. Use a suitable trust-accounting system and qualified professionals for fiduciary funds.
Sofia AI is accounting software for real-estate portfolios. Its product screens connect bank activity, transaction context, double-entry accounting, review, reconciliation, and ledger-backed reports. That does not mean chat can perform every screen action. See how Sofia works or request a demo to evaluate the supported workflow; Hire Sofia Accounting Services is the separate human-led service.
For a related liability lifecycle, see security deposits; for cash available to owners, see owner statements. Neither worksheet authorizes a disbursement.
Do I post a three-way reconciliation journal entry?
No. Comparing balances is not a transaction. Only an evidenced omitted event or approved correction may require a posting; timing items already in the books are not posted again.
Can positive owner balances offset a negative beneficiary?
A net tie does not establish that using another beneficiary’s funds is permissible. Investigate individual shortages and follow the applicable fiduciary rules.
Does a zero difference prove legal compliance?
No. Reconciliation tests records and timing, not every rule on segregation, authorization, notices, retention, or disbursement.