You are looking at a sample company. Every figure here is seeded demo data, not a customer result.
Set this up for my firmThe three-way reconciliation your state requires: bank statement vs your trust journal vs every beneficiary ledger, checked on every sync instead of once a month from memory.
1 · Trust bank balance
$243,050
2 · Funds held for others
$241,200
3 · Beneficiary ledgers total
$241,200
Every dollar the three records disagree on, and what to do about it
Trust bank holds funds not attributable to any beneficiary
$1,850
Money sitting in the trust account that no beneficiary ledger accounts for -- usually an earned fee or cost reimbursement deposited to the wrong account. Move it to Operating and record the correction.
What is held for whom -- each must never go below zero
| Beneficiary | Held in trust |
|---|---|
| Harborview Residential Trust | $57,500 |
| Summit Crossing Owners LLC | $52,400 |
| Maple & Vine Partners | $38,750 |
| Pier 41 Commercial LP | $36,500 |
| Cedar Row Holdings LLC | $24,550 |
| Brightline Retail Group | $18,900 |
| Kestrel Family Trust | $12,600 |
| Total | $241,200 |
Every movement through the trust account, newest first
| Date | Memo | Beneficiary | Amount |
|---|---|---|---|
| 2026-08-12 | Management fee deposited to trust account in error | Unattributed | +$1,850 |
| 2026-08-05 | Deposit refunds -- 2 move-outs, Maple & Vine | Maple & Vine Partners | -$2,450 |
| 2026-07-15 | Security deposits -- Kestrel SFR portfolio | Kestrel Family Trust | +$12,600 |
| 2026-06-29 | Deposit refunds and damage offsets -- Harborview | Harborview Residential Trust | -$7,300 |
| 2026-06-11 | Retail tenant deposits -- Brightline | Brightline Retail Group | +$18,900 |
| 2026-05-22 | Deposit refunds -- 3 move-outs, Cedar Row | Cedar Row Holdings LLC | -$4,150 |
| 2026-05-06 | Security deposits transferred at takeover -- Summit Crossing | Summit Crossing Owners LLC | +$52,400 |
| 2026-04-21 | Commercial security deposits -- Pier 41 | Pier 41 Commercial LP | +$36,500 |
| 2026-04-08 | Security deposits -- Maple & Vine | Maple & Vine Partners | +$41,200 |
| 2026-03-24 | Security deposits -- Cedar Row SFR portfolio | Cedar Row Holdings LLC | +$28,700 |
| 2026-03-10 | Security deposits transferred at takeover -- Harborview | Harborview Residential Trust | +$64,800 |