Three-Way Reconciliation: Monthly Steps and an Example

A three-way reconciliation proves that the money in your trust bank account matches what your books say you hold and what you owe each individual owner and tenant. If you manage property for others and collect rent or security deposits into a trust (escrow) account, it is the core monthly control your regulator, auditor, and owners expect to see. This playbook covers the three balances, the monthly steps, a worked example where all three balances tie, and how to tell a harmless reconciling item from a real problem. For the bigger picture of why trust money gets this treatment, start with our guide to real estate trust accounting.

What the three balances are

All three numbers are measured as of the same date, usually the last day of the month.

All three must agree to the penny, after documented reconciling items. Each comparison catches something different:

• Bank vs. books catches unrecorded transactions, bank errors, and data-entry mistakes. This is an ordinary bank reconciliation.
• Books vs. individual ledgers catches transactions posted to the trust account but never assigned to an owner or tenant ledger.
• Reviewing the ledger list line by line (part of every three-way reconciliation) catches what the totals can’t: a negative ledger, meaning one owner’s money is quietly covering another owner’s bills, or a receipt posted to the wrong person. In both cases the totals still match.

Trust account reconciliation steps

Reconcile every trust bank account separately: operating trust, security deposits, and any account held for a single owner or association.

1. Close the period. Post every receipt, disbursement, owner draw, and fee transfer dated in the month before you start. Don’t reconcile against a moving target.
2. Pull the bank statement for the full month, including the ending balance and the list of cleared checks and deposits.
3. Clear transactions. Match each deposit and check on the statement to its entry in your books. Mark what cleared.
4. List deposits in transit. These are deposits recorded in your books on or before month end that the bank had not credited yet. They should clear within the first few business days of the next month.
5. List outstanding checks with check number, payee, date, and amount.
6. Compute the adjusted bank balance: statement balance plus deposits in transit, minus outstanding checks.
7. Find items on the bank statement that aren’t in your books (fees, returned tenant payments, interest, bank errors). These most often need follow-up.
8. Run the ledger report listing every owner, tenant, and deposit ledger balance as of month end, and total it.
9. Compare all three balances. If they don’t agree, trace the difference before moving on. If they do, review the ledger list for red flags (below).
10. Document and sign. The preparer signs and dates the package; the broker or a second person reviews and signs.

A three-way reconciliation example

Here is a September 30 reconciliation for a small management company’s operating trust account. This company’s state allows security deposits in the same trust account; if yours must be held separately, reconcile that account the same way on its own.

Bank side

Book side: trust cash per the general ledger at 9/30 is $83,328.10.

Individual ledgers

All three balances agree. One of the two deposits in transit deserves a closer look: on 9/29 the bank charged a $25.00 service fee to the trust account.

That isn’t a harmless timing difference. A fee paid from trust funds means $25 of owners’ and tenants’ money paid the bank. The company recorded the fee, deposited $25 from its operating account on 9/30 to replace it (the $25 deposit in transit above), and asked the bank to charge future fees to the operating account. Some states let a broker keep a limited amount of company money in trust to avoid certain bank charges. Arizona, for example, says it is not commingling for a broker to deposit up to $5,000 of personal funds to keep the account open or to avoid charges for an insufficient minimum balance (A.R.S. § 32-2151). Check your own state’s rule before relying on a cushion like that.

With both deposits in transit documented, the September summary ties:

The totals still hide a second problem: D. Chen’s ledger is negative $640.00. An HVAC repair was paid before that owner’s rent came in, so other owners’ money funded it. All three balances tie while this is true, which is why the line-by-line ledger review is part of the job. Chen needs to fund the shortfall (or the company covers it, if state rules allow), and the payables process should block payments that exceed an owner’s available balance.

Reconciling items vs. red flags

Normal reconciling items have a clear cause and resolve on their own or with one entry:

• Deposits in transit that clear in the first few days of the next month
• Outstanding checks that are recent and expected to clear
• Bank fees or returned payments that are recorded and, for fees, replaced from operating
• Interest posted by the bank, if the account earns it (who it belongs to depends on your state and your agreements)

Red flags need investigation, and some may need to be reported:

• Negative owner or tenant ledgers. Someone else’s money is covering them.
• An unexplained difference, even a small one. A small gap can be two larger errors that partly offset.
• “Plugs” or adjusting entries made to force the reconciliation to balance
• Stale outstanding checks (older than about 90 days). Contact the payee; long-uncashed funds may eventually fall under your state’s unclaimed property rules.
• Deposits in transit that don’t clear in the first week of the next month
• Earned management fees left sitting in trust, which can be treated as commingling company money with client funds
• Security deposit ledgers that don’t match the leases you hold, or deposits still on the books for tenants who moved out

What to keep from each month-end trust reconciliation

Keep a complete package for every trust account, every month:

• Bank statement for the period
• Bank reconciliation with the deposit-in-transit and outstanding-check lists
• Trust general ledger (or trial balance) as of month end
• Ledger report listing each owner, tenant, and security deposit balance
• The three-way summary showing all three balances side by side
• A written explanation of every reconciling item and how and when it was resolved
• Preparer and reviewer signatures with dates

Retention periods vary by state. Arizona, for instance, requires property management firms to keep client financial records, including bank statements, client ledgers, and owner statements, for at least three years (A.R.S. § 32-2175). Your state real estate commission or attorney can confirm the period that applies to you.

Once the trust account reconciles, each owner ledger becomes the basis for that owner’s monthly statement. Our property management accounting guide covers how the reconciliation fits into the rest of the monthly close.

How often states require it

There is no single national rule. Trust account requirements for property managers are set state by state, generally through the real estate commission or licensing board. Arizona is one of the more explicit examples: its statute requires a broker to complete a monthly three-way reconciliation between the trust account bank statements, client ledgers, and trust account ledgers, and to explain any variation. Arizona also treats a variation caused by failing to complete the reconciliation regularly as a violation (A.R.S. § 32-2151).

Other states may require a monthly reconciliation without using the term “three-way,” set a deadline after month end, or require the designated broker to review and sign it. Look up your state’s current rule rather than relying on a summary, and ask your attorney if anything is unclear. Even where your state is less strict, monthly is the right cadence: errors are far easier to trace after 30 days than after six months.

Signs it’s time to get help

• You are more than a month or two behind, or reconciliations are done only before an audit
• The same unexplained difference carries forward month after month
• Negative owner ledgers keep showing up
• You switched software and the opening balances never fully tied out
• The person who writes the checks is also the only one who reconciles
• You’ve received notice of a trust account review or audit
• Your portfolio grew and month-end now takes days instead of hours

If several of these sound familiar, a specialist can catch you up and set a monthly routine. JAV’s property management trust accounting service covers three-way reconciliations and security deposit tracking, documented and ready for review. If you also need owner statements and a full monthly close, see our property management accounting services.

This article is general information, not legal or tax advice. Trust account rules vary by state; confirm the requirements that apply to you with your state real estate commission, attorney, or CPA.

This article is general information, not tax or legal advice. Talk with your CPA or attorney about your situation.