If you manage escrow trust accounts, you've heard the term “three-way reconciliation” hundreds of times. Your underwriter expects it. Your state bar expects it. ALTA Best Practices 4.2 now mandates it daily. But when you ask ten agency owners to describe exactly what a three-way reconciliation involves, you get ten different answers — and at least half of them are incomplete.
This article is the complete reference. What a three-way reconciliation is, what each of the three components actually represents, how the comparison works step by step, the most common failure modes, and what a properly documented reconciliation looks like when the auditor asks for it.
The three components
A three-way reconciliation compares three independently maintained records of the same pool of money. Each one is produced by a different system, maintained by a different process, and represents a different perspective on the same underlying truth: how much money is in your escrow trust account.
The bank statement balance. This is the balance your bank reports. It reflects every transaction that has cleared the bank as of the statement date — deposits that have posted, checks that have cleared, wires that have settled. It does not include transactions that are in transit. A check you wrote yesterday that hasn't cleared yet is still included in your bank balance. A deposit you made this morning that hasn't posted yet is not.
The book balance. This is your internal ledger — the running total maintained by your escrow software (SoftPro, Qualia, ResWare, RamQuest, or whatever system you use). It reflects every transaction you've recorded, whether or not it has cleared the bank. When your closer records a disbursement, the book balance decreases immediately — even if the check hasn't been cashed yet.
The trial balance. This is the sum of every individual client ledger in your escrow software. Each open escrow file has its own ledger showing the funds received and disbursed for that specific transaction. The trial balance is the total of all those individual ledgers added together. It represents the same money as the book balance, but from a different angle — instead of one running total, it's the sum of many individual accounts.
Why all three must agree
Each comparison catches a different category of error:
Bank vs. book catches timing differences and external errors. If a check cleared for a different amount than you recorded, or a wire fee was deducted that you didn't book, or an unauthorized debit hit the account, this comparison reveals it. The adjusted bank balance (bank statement plus deposits in transit minus outstanding items) should equal the book balance. If it doesn't, something happened at the bank that isn't reflected in your books — or something happened in your books that the bank doesn't recognize.
Book vs. trial balance catches internal errors. If a transaction was recorded to the operating ledger but not posted to a specific client file, or if a client ledger has a data entry error, or if funds were moved between files incorrectly, the book balance and trial balance will diverge. This comparison ensures that your aggregate ledger and your individual file ledgers tell the same story.
The three-way agreement means the money at the bank matches what your books say, and what your books say matches the sum of every individual client account. There is one truth, confirmed from three independent angles. That's the standard. That's what the auditor wants to see.
The adjusted bank balance
The bank statement balance is never compared directly to the book balance — because the bank doesn't know about your outstanding items. The comparison uses the adjusted bank balance, which accounts for transactions in transit:
Adjusted bank balance = Bank statement balance + deposits in transit − outstanding checks and wires
Deposits in transit are funds you've received and recorded in your books but that haven't posted at the bank yet. Outstanding checks and wires are disbursements you've recorded and issued but that haven't cleared the bank yet. Once you adjust for these timing differences, the adjusted bank balance should equal your book balance exactly.
If it doesn't, the difference isn't a timing issue — it's an actual discrepancy that needs investigation.
Common failure modes
After years of reconciliation practice across the title industry, the same failure modes appear over and over:
Stale outstanding items. A check from four months ago that never cleared is still sitting on your outstanding items list, making the adjusted bank balance look correct even though the money is effectively lost. The reconciliation “balances” but the underlying reality is wrong. This is why aging analysis on outstanding items matters — and why ALTA specifically calls out stale items.
Misposted transactions. A deposit was recorded to the wrong client file. The book balance is correct (the total is right) and the trial balance is correct (the sum of all files is right), but the individual file allocation is wrong. The three-way reconciliation passes, but the client-level accounting is incorrect. This is why reconciliation alone isn't sufficient — you also need file-level verification.
Unrecorded bank fees. The bank deducted a wire fee, analysis charge, or service fee that was never recorded in your books. The bank balance is lower than expected, creating a small variance that gets carried forward month after month. Individually these are immaterial. Collectively, over time, they accumulate into a real discrepancy.
Duplicate entries. A transaction was recorded twice in the book — once manually and once via import. The book balance is overstated relative to the bank, and the variance shows up as a phantom deposit in transit that never arrives. These are surprisingly common during system migrations or when multiple people touch the same ledger.
Trial balance drift. The sum of all client ledgers doesn't match the book balance because a transaction was recorded to the operating ledger but never allocated to a specific file. The money is accounted for in aggregate but not at the file level. This creates a trial balance variance that grows over time as more transactions accumulate without proper file allocation.
What a properly documented reconciliation looks like
When the underwriter auditor pulls a random date from the last twelve months, the reconciliation record for that day should include:
- The bank statement balance as of that date
- The list of deposits in transit with dates and amounts
- The list of outstanding checks and wires with dates, amounts, and payees
- The computed adjusted bank balance
- The book balance from your escrow software
- The trial balance (sum of all client ledgers)
- The variance between each pair (should be zero)
- Any exceptions identified, with explanations and resolution status
- The identity of the person who performed the reconciliation
- The date and time the reconciliation was completed
If any of these elements are missing, the documentation is incomplete. If the reconciliation was reconstructed after the fact rather than performed contemporaneously, the auditor will know — and that's a finding.
Daily changes everything
The difference between monthly and daily reconciliation isn't just frequency — it's a fundamentally different relationship with your data. Monthly reconciliation is forensic: you're looking backward at 30 days of transactions, trying to figure out what happened. Daily reconciliation is operational: you're looking at yesterday's activity, with full context, while everything is fresh.
An exception discovered the day after it occurs takes five minutes to resolve. The same exception discovered 30 days later takes two hours — if it can be resolved at all. This is the real argument for daily reconciliation. Not just compliance. Operational efficiency.