Why doesn't my trust account bank balance match the owner ledgers?

They do not match because they are different lists. The bank still holds tenant security deposits, outstanding owner-draw checks, deposits in transit, and any management fee sitting in trust. Rec the adjusted bank to the sum of every owner ledger plus every tenant deposit ledger on the same cutoff date.

This is the diagnostic for a 50-to-300-door office on AppFolio, Rentvine or Buildium, often with QuickBooks Online on the side. Stop owner draws until the three numbers agree.

They are different lists

The statement ending balance is cash at the bank on one date. An owner ledger is what you still owe one owner. Adding only those ledgers leaves out tenant deposits and any fee still sitting in the same account.

List	What it shows	What it leaves out
Bank statement ending balance	Cash the bank reports	Outstanding items, whose money it is
Adjusted bank balance	Cash after outstanding items	Whose money it is
Trust ledger	Receipts and disbursements in the PM software	A door posted to the wrong owner
Sum of owner ledgers	What you still owe owners	Tenant deposits, broker fee still in trust

A NARPM conference presentation (Mumford, hosted on narpm.org) writes the rec as bank statement = check register = client ledgers, then splits those client ledgers into owner, tenant, and broker. None of the ledgers should be negative. Owner ledgers are one slice of that third number.

AppFolio (June 16, 2026) calls this a Triple Tie Out of owners, banks, and the general ledger. Rentvine (read 2026-11-02) writes the third record as owner ledger totals. Buildium (December 8, 2025) matches bank, checkbook, and client balances. Rec the bank only to owner ledgers and the gap is usually Mumford’s tenant and broker slices.

A small worked example

One trust account, three owners, cutoff the bank-statement date. The amounts are an illustration, not a live portfolio.

Item	Amount
Bank statement ending balance	$31,400.00
Plus deposits in transit	$800.00
Minus outstanding owner-draw checks	($2,100.00)
Adjusted bank balance	$30,100.00

Ledger	Amount
Owner A, 12 Pine	$9,600.00
Owner B, 44 Elm	$7,100.00
Owner C, 8 Oak	$4,700.00
Sum of owner ledgers	$21,400.00
Tenant security deposits	$8,200.00
Broker fee still sitting in trust	$500.00
Sum of sub-ledgers	$30,100.00

The raw bank is $31,400. The owner ledgers add to $21,400. That $10,000 gap is outstanding checks, deposits in transit, tenant deposits, and the fee still in trust.

How to do a three-way trust account reconciliation is the packet that gets those three totals to $0.00.

Adjust the bank first

Start with the statement ending balance. Add receipts you recorded that the bank has not credited. Subtract owner-draw checks and ACH batches that have not cleared. Compare that figure to the books.

On r/appfolio in June 2026, a write-up of owner distributions called AppFolio’s Adjusted Cash Balance the trust cash available after uncleared checks, ACH batches, and unreconciled deposits. A deposit in transit is a reconciling item. Hold it until it clears.

Bank fees that hit the statement and never hit the books are the usual few-dollar gap. California Commissioner’s Regulation 2835 lets a broker keep up to $200 of firm money in the trust account for those charges, on its own beneficiary record. Other states cap that buffer differently. Check yours.

What sits in the bank off the owner ledgers

Tenant security deposits live in the same bank in many states. They belong to tenants, so they never appear on an owner ledger. How to account for security deposits held in a trust account in QuickBooks is the liability setup if the CPA’s deposit bank lives there.

Oregon splits the cash. The Oregon Real Estate Agency’s maintain-clients’-trust-accounts page (read 2026-11-02) recs the owner clients’ trust account to the adjusted bank, the check register, and the sum of all positive owners’ ledgers. The security-deposit account gets its own rec against tenant deposit balances. There, owner ledgers should match the owner account. Combining both accounts into one total is the miss.

Earned management fees that have not left trust still sit in the bank on a broker ledger. Texas requires a broker who acquires ownership of trust money, including compensation, to take it out within 30 days (22 Tex. Admin. Code § 535.146, read 2026-11-02). California gives 25 days after deposit for the broker’s share of mixed funds that cannot reasonably be split. Other states set their own clocks. This is not legal advice. Check your commission and your CPA. Unapplied receipts raise the bank with no owner name.

How to read the gap

Work bank-to-ledger first, then ledger-to-owner-ledgers. If the three numbers still disagree, stop owner draws.

What you see	Likely cause	What to do
Bank higher than owner ledgers	Tenant deposits, outstanding draws, or a fee still in trust	Add those three, then rec
Bank lower than owner ledgers	Deposit in transit, NSF, or an owner credit without cash	Rebuild the outstanding list
Adjusted bank equals the trust ledger, owner ledgers still short	Unapplied receipt, or deposits left off the sum	Export the tenant deposit report
All three match, one owner is negative	Bills paid before rent posted, or rent applied to the wrong door	Hold that owner’s draw
Bank rec closes, owner statements still wrong	Two-way rec only	Sum the ledgers

Florida’s monthly rec compares the broker’s total trust liability, the sum of every deposit still held, to the reconciled bank. When those two disagree, Rule 61J2-14.012 (read 2026-11-02) wants the written rec to describe the difference and the corrective action. 21 NCAC 58A .0117(e) wants a trial balance of the property or owner ledgers, the adjusted bank, and the journal, all as of one cutoff. If they disagree, investigate until they agree.

When the totals already match

Matching totals can still hide a swap. Rent for 8 Oak posted to 44 Elm leaves both owner statements wrong and the three-way still tying. Spot-check a few doors against the deposit batch.

They can also hide a negative owner. Same cutoff, same $30,100: Owner A $9,600, Owner B $7,500, Owner C ($400), tenant deposits $8,200, broker fee $500. The three numbers still agree. Owner C is negative. Cash in the account still belongs to other owners and tenants. Hold C’s draw until that ledger is whole.

Colorado’s Division of Real Estate lists negative ledger balances among common violations (audit process, read 2026-11-02). Buildium’s January 11, 2026 checklist says a negative owner ledger before an owner draw means you are using other owners’ funds. On r/appfolio in July 2026, a mid-year write-up said a negative owner is still a finding even if the trust has enough cash in aggregate. A June 2026 write-up on the same sub said AppFolio does not block it. A repair bill paid before that owner’s rent posts borrows from the trust-account float.

Run every report to the bank-statement date. An owner-ledger export generated on the 2nd already includes the next month’s rent.

What the software already does

AppFolio, Rentvine and Buildium win the built-in trust rec. They keep owner and tenant ledgers in the same system as the bank rec. On their own books, that rec works. QuickBooks Online wins the two-way rec your CPA already knows.

Job	AppFolio, Rentvine or Buildium	QuickBooks Online
Two-way bank rec	Yes	Yes, native
Sum of owner and tenant ledgers	Yes, that is the product	No. Bank vs register only
Owner statements from the same numbers	Yes	No
Negative owner ledger	Visible on the owner balance report	No floor on a class

Intuit’s QuickBooks Online reconcile help (updated 2026-08-05) is a two-way job. Match the register to the statement until the Difference is $0.00. How to reconcile a property management trust account in QuickBooks Online is the click path if the CPA’s trust bank lives there. Finish that rec, then still add the ledgers.

Someone still has to pick the cutoff, refuse a negative draw, and refuse to send owner statements until the difference is $0.00.

How often, and who signs

Rules vary by state. California’s Department of Real Estate August 26, 2025 advisory lists trust-fund handling and record-keeping, including failing to reconcile, as the most common enforcement violation. Commissioner’s Regulation 2831.2 requires a monthly reconciliation of beneficiary records to the control record in months with activity. Texas requires a monthly accounting of trust money when the account has had activity, and keeps those records four years (TREC FAQ, read 2026-11-02). Colorado expects monthly three-way recs and publishes worksheets. Oregon wants each account rec’d within 30 days of the statement. This is not legal advice. Check your own state’s commission and your CPA.

Keep the packet. Statement, outstanding list, three reports, a $0.00 difference, and a signature. A bookkeeper can run it. The broker of record still owns it. What is a three-way reconciliation is the definition of the three numbers. Do not send owner draws or statements until those numbers agree and no owner ledger is negative.

Pull last month’s trust-account bank statement, the owner-ledger export, and the tenant deposit report. Run every report to the statement date. Add the owner and tenant totals, then adjust the bank for outstanding checks and deposits in transit. Those three files already exist.