Trust account reconciliation: The three-way method every PM must master

A state auditor sits across from you with a printed report. She points to a $4,200 discrepancy between your trust account bank balance and the total of your tenant ledger balances. You know the money is there. You are almost certain it is a timing issue from a deposit that posted late. But you cannot prove it because your last trust reconciliation was two months ago, and the documentation trail between then and now has gaps.

That $4,200 discrepancy is not a financial crisis. It is a documentation crisis. The money reconciles cleanly once you trace every transaction. But "probably" does not satisfy state regulators. In trust accounting, an unexplained discrepancy is treated the same as a missing dollar until you prove otherwise.

Trust account reconciliation is the process that prevents this scenario. And the three-way method is the specific technique property management companies use to verify that every dollar held in trust is accounted for, properly allocated, and provably connected to the tenant or owner to whom it belongs.

Three numbers that must all match: Bank balance, book balance, and individual ledger totals

Standard bank reconciliation compares two amounts: your bank statement balance and your book balance. You identify outstanding checks, deposits in transit, and bank fees to explain the difference. Three-way trust reconciliation adds a critical third element. It compares:

1. The bank statement balance. What the bank says is in your trust account as of the reconciliation date.

2. The book balance. What your accounting system says should be in the trust account based on all recorded transactions.

3. The sum of individual ledger balances. The total of every tenant security deposit ledger and every owner escrow ledger should be reflected in the trust account.

All three numbers must match. When they do, you have verified that the bank holds the correct amount, that your books accurately reflect that amount, and that every dollar can be traced to a specific tenant or owner. When any of the three numbers disagrees with the other two, you have a variance that needs investigation.

This third layer is what makes trust reconciliation different from regular bank reconciliation. A standard bank rec tells you your books match the bank. A three-way rec tells you the money in the bank belongs to the people you are holding it for, in the exact amounts your records claim.

Why the ledger-to-bank check catches what standard bank reconciliation misses entirely

The bank-to-book reconciliation identifies accounting errors, including wrong amounts, duplicate entries, unrecorded fees, and timing differences. These are mechanical problems with mechanical solutions. The ledger-to-bank reconciliation catches something more serious: allocation errors. This is where trust accounting risk lives.

A tenant moves out, the security deposit is refunded, but the ledger entry remains. Your books and bank might still reconcile, but the individual ledger total now overstates the amount held. The next audit will show a liability on your ledger that has no corresponding cash in the bank.

A rent payment is received and deposited into the trust account, but it is posted to the wrong tenant's ledger. The bank balance is correct. The book balance is correct. But the individual allocation is incorrect, so the wrong owner would receive credit for the payment when distributions are calculated.

An owner distribution is processed, but the trust account transfer is delayed. The ledger shows the owner's balance reduced, but the bank still holds the funds. The individual ledger total and the bank balance now disagree.

These are the errors that three-way reconciliation catches and two-way reconciliation misses entirely. And they are exactly the errors that state auditors are trained to look for.

A five-step process for running a clean, audit-ready three-way reconciliation

The process follows a logical sequence. Each step builds on the previous one.

Step 1: Complete the standard bank reconciliation. Start with the bank statement ending balance. Add deposits in transit (money you have received and recorded but that has not yet cleared the bank). Subtract outstanding checks and payments (disbursements you have recorded but that have not yet cleared). The result is your adjusted bank balance.

Step 2: Reconcile your book balance. Review the general ledger for your trust account for the same period. Verify that all recorded transactions match the bank's actual activity. Adjust for unrecorded items such as bank service charges or interest credits. Your adjusted book balance should now match the adjusted bank balance from step one.

Step 3: Total all individual ledger balances. Pull every tenant security deposit ledger and every owner escrow ledger associated with the trust account. Sum all balances. This total represents the aggregate liability, the total amount of other people's money you are responsible for holding.

Step 4: Compare the three numbers. The adjusted bank balance, adjusted book balance, and total individual ledger balances should all be identical. If they match, document the reconciliation with a dated report showing all three figures.

Step 5: Investigate and resolve variances. If the numbers do not match, you need to find out why. Common causes include:

1. Deposits received but not yet posted to individual ledgers

2. Refunds processed in the ledger but not yet disbursed from the bank

3. Transactions posted to the wrong tenant or owner ledger

4. Data entry errors in individual ledger amounts

5. Timing differences between ledger updates and bank postings

Resolve each variance, document the cause and correction, and re-run the three-way comparison until all three numbers agree.

Four process gaps that cause three-way reconciliation to fail month after month

Firms that struggle with three-way reconciliation usually have one of four underlying process problems.

1. Batching ledger updates at month-end. When tenant and owner ledger entries are posted in a batch rather than as transactions occur, timing differences accumulate throughout the month. By the time you attempt reconciliation, dozens of transactions need to be traced individually. Daily posting eliminates this backlog.

2. Incomplete move-out processing. When a tenant moves out, the deposit must be refunded or applied to damages within your state's required timeframe, typically 14 to 30 days, depending on jurisdiction, and the ledger must be zeroed out. Deposits that linger after departure create phantom liabilities that continue to throw off the third leg each month until resolved.

3. Missing or informal documentation. Every trust account transaction needs a paper trail. Deposits need receipts. Refunds need authorization records. Owner distributions need supporting calculations. Inconsistent documentation stalls the reconciliation process at every unverifiable transaction.

4. Infrequent reconciliation. Firms that reconcile quarterly face exponentially harder reconciliations than those that reconcile monthly. A single month's transactions can be traced in an hour or two. Three months of accumulated transactions take days, because every unresolved item from month one cascades forward.

Why is monthly the only reconciliation frequency that holds up under audit

Trust account reconciliation is not optional. Treating it as a quarterly or year-end exercise creates the conditions that lead to audit findings and compliance violations.

The three-way method works because it tests the one thing that matters most in trust accounting: that every dollar in the bank can be traced to the specific person to whom it belongs. Not approximately. Not probably. Exactly.

Set a fixed date each month for the reconciliation, ideally as part of a structured month-end close process where trust accounts are reconciled on Day 2 before any owner distributions are calculated. Document it with a signed report. File the supporting schedules. When the auditor arrives, hand them a clean binder instead of spending a week reconstructing what you should have verified all along.