Three-Way Reconciliation for Property Managers: What a Trust Account Audit Checks First

Three-way reconciliation is the check that proves a property management trust account holds exactly the money it owes to the people it holds it for. You take the adjusted bank balance, the trust journal balance and the sum of every owner, tenant and deposit ledger, and confirm all three match on the same date. If one of them is off, the account is not reconciled, no matter how clean the bank reconciliation looks.

It is also the first thing a state examiner or auditor asks to see. Here is what they look for, how to do it properly, and where it usually goes wrong.

What Is Three-Way Reconciliation, and Why Does It Matter?

A normal bank reconciliation answers one question: does the bank agree with the books? A trust account has to answer a second one: do the books agree with the individual people the money belongs to?

The three legs are:

1. 1The bank. The ending statement balance, adjusted for deposits in transit and outstanding checks.
2. 2The book. The balance of the trust account in your general ledger or trust journal.
3. 3The beneficiaries. The total of every owner balance, tenant prepayment and security deposit held in that account.

Here is why the third leg matters. Say a manager holds $412,000 in trust, the bank agrees, and the journal agrees. But owner ledgers add up to $418,500 because one owner's ledger sits at minus $6,500. In total the account balances. In reality, one owner's repair bill was paid with another owner's rent. That is commingling of client funds, and in most states it is the kind of finding that puts a broker license at risk.

How Do You Perform a Three-Way Reconciliation, Step by Step?

Do this for every trust account (operating trust, security deposit trust, and any separate escrow accounts) as of the last day of the month.

1. 1Close the period in your software. Make sure every receipt, payment, owner draw and management fee for the month is posted before you start.
2. 2Reconcile the bank. Start with the statement balance, add deposits in transit, subtract outstanding checks, and confirm the adjusted balance matches the trust journal.
3. 3Pull the ledger totals. Run the owner balance report, tenant prepayment report and security deposit liability report as of the same date.
4. 4Add them up and compare. The sum of those ledgers should equal the adjusted bank balance and the book balance exactly.
5. 5Investigate every difference. Do not plug. Find the transaction that caused it, whether a misapplied receipt, a fee taken twice or a deposit refunded from the wrong account.
6. 6Review negative ledgers. Any owner or tenant ledger below zero is a problem even if the totals agree.
7. 7Sign and date it. Keep the reconciliation, the bank statement and the supporting reports together, signed by the preparer and a reviewer.

A simple summary on the front page of the reconciliation file makes it easy for anyone reviewing it:

What Documents Does a Trust Account Audit Review First?

Examiners differ by state, but most start in the same place. Expect to produce:

• Monthly three-way reconciliations for the review period, signed and dated
• Bank statements for each trust account, including canceled check images
• The trust journal or cash receipts and disbursements journal
• Owner ledgers and owner statements
• Tenant ledgers and the security deposit register
• Management agreements showing how and when fees are earned
• Records of any transfers between trust and operating accounts

If those documents are clean and current, the rest of the exam tends to go quickly. If reconciliations are missing or unsigned, examiners usually widen the sample.

How Often Should Property Managers Reconcile Trust Accounts?

Monthly, at a minimum. Many states put it in writing. California's real estate regulations, for example, require brokers to reconcile the trust account record against the separate beneficiary records at least once a month. Other states set similar rules or expect the same through their audit practice.

Timing matters as much as frequency. A reconciliation completed on the 10th of the following month can trace a $340 variance to a single transaction. A reconciliation completed four months later is often trying to explain a dozen differences that have started to interact. We aim to finish trust reconciliations within the first two weeks after month end for every trust accounting client.

What Are the Most Common Trust Account Discrepancies?

Most problems we find during a bookkeeping cleanup fall into a short list:

• Negative owner ledgers. Bills paid before the owner's rent came in, covered by other owners' funds.
• Management fees taken early. Fees transferred to operating before they were earned under the agreement.
• Deposits held against the wrong tenant or unit. Common after transfers, renewals or a software migration.
• Unidentified receipts. Money sitting in suspense because nobody matched it to a tenant.
• Stale outstanding checks. Owner or vendor checks from many months ago that still appear as outstanding and may be subject to unclaimed property rules.
• Bank fees or interest posted to no one. Small amounts that throw off the beneficiary total every month.

None of these are dramatic on their own. They become serious because they compound.

What Happens If a Trust Account Fails to Reconcile?

It depends on the direction of the difference and the state.

A shortage, where beneficiary ledgers exceed the cash, means client money was used for something it should not have been. Regulators treat this as the serious version of the problem. It usually has to be funded immediately, documented, and in some states reported.

An overage, where cash exceeds what is owed, usually means unidentified deposits or posting errors. It is less alarming but still needs to be traced and assigned to its rightful owner.

In both cases the fix is the same: find the cause, correct it with a documented entry, and keep a written explanation in the reconciliation file. A plugged difference will fail the next review.

What Software Makes Three-Way Reconciliation Easier?

AppFolio, Buildium, Rent Manager, Yardi, Propertyware and Entrata all produce the reports needed: bank reconciliation, owner balances, deposit registers and trust account summaries. Several produce a single three-way report.

The software cannot decide whether a $1,200 receipt in suspense belongs to Unit 4B or whether a stale check should be voided and reissued. That review is the actual work. If you run AppFolio or Buildium, the reports are there; the habit of reviewing them every month is what keeps you audit-ready.

Get Your Trust Accounts Audit-Ready

If your trust accounts have not reconciled three ways for a while, start with the most recent month and work backward to the last date everything agreed. That tells you how big the job is. Vertex Accounting does this as part of our bank reconciliation services, then keeps the account reconciled every month inside the software you already use.