How to do a three-way trust account reconciliation for property management?

A three-way trust account reconciliation proves that the adjusted bank balance, the trust ledger in your property-management software, and the sum of every owner and tenant ledger agree to the cent on the same cutoff date. If one number is off, the rec is not finished.

This is the month-end job for a small property-management office on AppFolio, Rentvine or Buildium, often with QuickBooks Online on the side, that already has last month’s trust-account bank statement and the owner and tenant ledger exports.

The three numbers

A two-way rec matches the bank to the books. The third number is the sum of the people you owe.

Balance	What it is	What it proves
Adjusted bank balance	Statement ending balance, plus deposits in transit, minus outstanding checks	The cash is at the bank
Trust ledger	Control account or check register in the PM software	Your books match that cash
Sum of sub-ledgers	Every owner ledger plus every tenant security-deposit ledger, plus any broker fee reserve	The cash is allocated to the right people

When all three match, the money exists and is allocated. When two match and the third does not, you know which class of error you have.

Pull one cutoff date

Pick the bank-statement date first. Run every report to that date. The usual miss is a statement through the 30th and an owner-ledger export generated on the 2nd.

What you need in one packet:

• Trust-account bank statement
• Outstanding checks and deposits in transit
• Trust ledger or bank-account activity from the PM software, same date
• Owner ledger balances, same date
• Tenant or security-deposit ledger balances, same date
• Last month’s signed rec, so the beginning point is clean

AppFolio (June 16, 2026) calls this a Triple Tie Out of owners, banks, and the general ledger. Rentvine and Buildium (December 8, 2025) describe the same three-way match.

Adjust the bank

Start with the statement ending balance. Add deposits you recorded that the bank has not credited. Subtract checks and ACH owner draws that have not cleared.

Example, one trust account at month-end:

Item	Amount
Bank statement balance	$52,410.00
Plus deposits in transit	$1,150.00
Minus outstanding owner-draw checks	($3,200.00)
Adjusted bank balance	$50,360.00

A deposit in transit is a valid reconciling item. It is not cash you can send to an owner yet. Bank fees that hit the statement and never hit the books are the usual small gap that keeps the rec open. In California, Commissioner’s Regulation 2835 lets a broker keep up to $200 of the firm’s own money in the trust account to cover bank service charges, on its own beneficiary record. The October 2024 DRE Bulletin says the preferred move is to have the bank debit the operating account instead. Other states cap that buffer differently. Check yours.

Confirm the trust ledger

The trust ledger is the running record of every receipt and disbursement in the PM software: rent deposits, vendor checks, owner draws, management-fee transfers, NSF reversals. It should already include items that have not cleared the bank. If it does not equal the adjusted bank, stop. You are not ready for owner ledgers. Typical causes: a receipt never deposited, a voided check that still cleared, a bank fee never posted, a deposit batch recorded gross when the bank posted net.

Intuit’s QuickBooks Online reconcile help (updated 2026-08-05) is this two-way job: match the register to the statement until the difference is $0.00. That is the first two numbers. It is not the third.

Sum every owner and tenant ledger

Export every owner balance and every tenant security-deposit balance as of the same cutoff. Add them. Include the broker’s own fee reserve if earned management fees still sit in the trust account. That total has to equal the trust ledger. A NARPM conference presentation (Mumford, hosted on narpm.org) writes it as bank statement = check register = client ledgers, with no negative ledgers.

If the trust ledger is $50,360 and the sub-ledgers add to $49,760, $600 sits in the trust account with no owner or tenant name on it. Look first for an unapplied receipt. If the sub-ledgers are higher, look for a receipt applied to an owner that never hit the bank. Matching totals can still hide a swap: rent for 18 Maple posted to 22 Oak leaves both owner statements wrong and the three-way still tying. Spot-check a few doors against the deposit batch.

Do not send owner draws until the three numbers agree and no owner ledger is negative. A negative owner ledger with cash still in the trust account means that owner’s bills were paid with someone else’s rent. Colorado’s Division of Real Estate lists negative ledger balances among the common violations it finds, and tells property-management brokers to bring monthly three-way reconciliations, journals, ledgers, and reconciled bank statements (audit process, read 2026-10-07). Buildium’s January 2026 checklist says a negative owner ledger before an owner draw means you are using other owners’ funds.

When the three lists still disagree

Work bank-to-ledger first, then ledger-to-sub-ledgers. Investigating both at once is how an afternoon becomes two days.

Symptom	Likely cause	What to do
Adjusted bank lower than the trust ledger	Outstanding checks missed, or a deposit in transit that already cleared	Rebuild the outstanding list from check numbers
Trust ledger higher than the sum of ledgers	Unapplied receipt, or a fee never allocated	Find receipts sitting in a clearing or undeposited bucket
Sum of ledgers higher than the trust ledger	Owner credit without cash, or a disbursement on the control account only	Trace the owner draw or vendor check
All three match, one owner is negative	Bills paid before rent posted, or rent applied to the wrong door	Hold that owner’s draw; fix the allocation
Bank rec closes, owner statements still wrong	Two-way rec only	Sum the ledgers. That is the third leg

On r/PropertyManagement in September 2025, one office heading into a real-estate-commission audit wrote that the trust account had never reconciled to the bank, and several properties showed negative balances they could not verify. Totals that look close are not a rec.

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.

Job	AppFolio, Rentvine or Buildium	QuickBooks Online	Spreadsheet
Two-way bank rec	Yes	Yes, native	Yes, by hand
Sum of owner and tenant ledgers	Yes, that is the product	No. Bank vs register only	Only if you built the ledgers
Owner statements from the same numbers	Yes	No	If you rebuild them
Negative owner ledger	Visible on the owner balance report	No	Only if you look

Someone still has to pick the cutoff, tick the outstanding items, and refuse to send owner draws until the difference is $0.00. Saving a bank rec that is $40 off because it will catch up is how last year’s gap is still this year’s gap.

How often, and who signs

Rules vary by state. Colorado expects monthly three-way reconciliations for property-management trust accounts and publishes worksheets for the packet. California Commissioner’s Regulation 2831.2 requires a monthly reconciliation of beneficiary records to the control record in months with activity; the October 2024 DRE Bulletin also tells brokers to reconcile that control record to the bank. Texas requires a monthly accounting of trust money when the account has had activity (TREC Rule 535.146(c)(6)). This is not legal advice. Check your own state’s real-estate commission and your CPA or counsel.

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.

How to tell this month is closed

Adjusted bank, trust ledger, and the sum of owner and tenant ledgers agree to the cent. No owner ledger is negative. Outstanding checks are a real list, not a plug. Last month’s difference was not rolled forward. Owner statements can go out because they were built from those same ledgers.

Pull last month’s trust-account bank statement, the general ledger and owner-ledger exports, and the tenant deposit report. Start with those three files. They already exist.