What is a three-way reconciliation in property management?
By the Propfina team · Last updated
A three-way reconciliation in property management proves that the adjusted bank balance, the trust ledger, and the sum of every owner and tenant ledger agree to the cent on the same cutoff date. When two match and the third does not, you know which class of error you have.
This is the month-end proof for a small property-management office of about 50 to 300 doors on AppFolio, Rentvine or Buildium, often with QuickBooks Online on the side. The cash in the trust account is other people’s money. The rec is how you show it exists and is allocated.
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 still in trust | The cash is allocated to the right people |
When all three match, the money exists and is allocated. A NARPM conference presentation (Mumford, hosted on narpm.org) writes it as bank statement = check register = client ledgers, with no negative ledgers.
AppFolio (June 16, 2026) calls this a Triple Tie Out of owners, banks, and the general ledger, and says to rec it monthly, 100 percent of the time. Rentvine (read 2026-10-08) describes a 3-way tie of bank statement, trust ledger, and property ledgers. Buildium (December 8, 2025) writes the same three totals.
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 | $24,180.00 |
| Plus deposits in transit | $620.00 |
| Minus outstanding owner-draw checks | ($1,800.00) |
| Adjusted bank balance | $23,000.00 |
The trust ledger in the PM software, run to that same date, is $23,000.00.
| Ledger | Amount |
|---|---|
| Owner A, 12 Pine | $7,400.00 |
| Owner B, 44 Elm | $5,100.00 |
| Owner C, 8 Oak | $4,200.00 |
| Tenant security deposits | $5,800.00 |
| Broker fee still sitting in trust | $500.00 |
| Sum of sub-ledgers | $23,000.00 |
The three numbers agree. 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 a 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. Other states cap that buffer differently. Check yours.
How to do a three-way trust account reconciliation is the packet that gets you to this $0.00 difference: what to pull, how to adjust the bank, how to sum the ledgers, and what to do when the lists disagree.
Two-way is not the third number
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. That is the first two numbers. It is not the third.
| Rec | What it matches | What it misses |
|---|---|---|
| Two-way bank rec | Bank statement to the trust register | Whose money it is |
| Three-way trust rec | Those two, plus the sum of owner and tenant ledgers | Nothing, if no owner is negative and no door was swapped |
If owner statements can still be wrong after the bank rec closes, you skipped the third leg. 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 owner and tenant ledgers.
What a matching total can still hide
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 $23,000:
| Ledger | Amount |
|---|---|
| Owner A, 12 Pine | $7,400.00 |
| Owner B, 44 Elm | $5,700.00 |
| Owner C, 8 Oak | ($400.00) |
| Tenant security deposits | $5,800.00 |
| Broker fee still sitting in trust | $500.00 |
| Sum of sub-ledgers | $23,000.00 |
The three numbers still agree. Owner C is negative. Cash in the account still belongs to other owners and tenants. C’s bills were paid with someone else’s rent. Hold C’s draw until that ledger is whole.
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-08). Buildium’s January 2026 checklist says a negative owner ledger before an owner draw means you are using other owners’ funds.
On r/appfolio in June 2026, a write-up of owner distributions said AppFolio does not block a negative owner ledger: a repair bill paid before that owner’s rent posts borrows from the trust-account float. A receipt applied to the wrong property can still leave the three totals matching while the distributions are off.
The usual cutoff miss is a statement through the 30th and an owner-ledger export generated on the 2nd. Pick the bank-statement date first. Run every report to that date.
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 | 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 floor on a class | Only if you look |
Someone still has to pick the cutoff, refuse a negative draw, and refuse to send owner statements 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. Texas requires a monthly accounting of trust money when the account has had activity (TREC Rule 535.146(c)(6)). Oregon’s Real Estate Agency property-management guide (read 2026-10-08) says a manager who holds tenants’ security deposits must open a clients’ trust account just for them. Each account gets its own three-way rec, signed and dated within 30 days of the bank-statement date. There the deposit account ties to the deposit ledgers and the owner account to the owner ledgers, not one combined total. 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.
When you actually run it
Do not send owner draws, and do not send owner statements, until the three numbers agree and no owner ledger is negative. How to create owner statements for property management in QuickBooks is the packet that goes out after. Property management bookkeeping is the monthly cycle this rec sits inside.
Pull last month’s trust-account bank statement, the owner-ledger export, and the tenant deposit report. Start by comparing those three totals on the statement date. The files already exist.
Frequently asked questions
Is a two-way bank rec the same as a three-way rec?
No. A two-way rec matches the bank statement to the trust ledger or check register. The third number is the sum of every owner ledger and every tenant security-deposit ledger on that same date. QuickBooks Online's native rec is two-way. If owner statements can still be wrong after the bank rec closes, you skipped the third leg.
Can the three totals match while one owner ledger is negative?
Yes, and that is the usual audit finding. Cash in the account can still belong to other owners and tenants. A negative owner ledger means that owner's bills or draw were paid with someone else's rent. Hold that owner's draw until the ledger is whole. Colorado's Division of Real Estate lists negative ledger balances among common trust-accounting violations.
How often do property managers have to run a three-way rec?
It depends on the state. Colorado expects a monthly three-way rec for property-management trust accounts. California requires a monthly reconciliation of beneficiary records to the control record in months with activity. Texas requires a monthly accounting when the account had activity. Oregon wants security deposits in their own trust account, reconciled separately. Check your own state's commission and your CPA.
Does AppFolio finish the three-way rec when the bank rec closes?
AppFolio, Rentvine and Buildium keep the owner and tenant ledgers in the same system as the bank rec, which is why PM software wins this job. Closing the bank rec is still only two of the three numbers. You still export the owner and tenant balances as of the statement date, add them, and refuse to send owner draws until that total equals the adjusted bank and the trust ledger.