Skip to main content

Three-Way Reconciliation for Title and Escrow Agencies: How Trust Account Bookkeeping Actually Works

9 min readMike ThriftMike Thrift
Three-Way Reconciliation for Title and Escrow Agencies: How Trust Account Bookkeeping Actually Works

Every dollar that lands in a title or escrow agency's bank account belongs to someone else. Not the agency's revenue, not a temporary float to smooth cash flow, not a source of short-term working capital — it's a buyer's down payment, a seller's proceeds, a lender's payoff, sitting in trust until the closing table clears everyone to move it. Get that bookkeeping wrong, even by a few hundred dollars, and you're not looking at a rounding error. You're looking at a state insurance department investigation, a license suspension, or in the worst cases, criminal exposure.

That's why title and escrow agencies operate under a bookkeeping standard most small businesses never encounter: the three-way reconciliation. It's more rigorous than a bank reconciliation, it's usually mandatory rather than optional, and it exists because the industry has a long, expensive history of finding out — sometimes years later — that trust account math had quietly drifted out of balance.

Why Escrow Accounting Is a Different Sport

In ordinary small-business bookkeeping, your bank balance and your books should match, and if they don't, you investigate a timing difference or a data-entry error. That's a two-way reconciliation: books versus bank.

Escrow accounting adds a third leg. A title agency's trust account typically holds funds for dozens or hundreds of open files simultaneously — one client's earnest money, another's payoff wire, another's seller proceeds waiting on a mailed check to clear. The aggregate bank balance has to equal not just the general ledger's "escrow liabilities" total, but the sum of every individual client ledger, file by file. If the bank statement, the book balance, and the sum of client trial balances don't all agree, you don't know whose money is missing until you dig — and if it's missing because of fraud rather than a bookkeeping slip, every day of delay makes recovery less likely.

This is the structure of a three-way reconciliation:

  1. The trust bank statement — the actual, physical bank balance for the escrow account, adjusted for outstanding items (checks not yet cashed, deposits in transit).
  2. The book balance — the running total in your accounting system's escrow ledger, built from every deposit and disbursement you've recorded.
  3. The client trial balance — the sum of every individual client's file balance, added up across all open files.

All three numbers must match, every reconciliation cycle. Under ALTA's Title Insurance and Settlement Company Best Practices Framework (Pillar 2, covering escrow trust account management), that means completing the reconciliation within roughly 10 business days of the bank statement closing date, unless a stricter state deadline applies — some states require it monthly, others quarterly, and a handful require it more frequently for high-volume agencies.

Running the Reconciliation, Step by Step

1. Pull the bank statement and identify outstanding items. Start with the ending bank balance, then add back deposits in transit and subtract checks that haven't cleared. This gives you the adjusted bank balance — the number the other two legs need to match.

2. Reconcile the book balance. Your general ledger's escrow account should reflect every deposit and disbursement posted during the period. Any difference between the adjusted bank balance and the book balance points to a posting error, a bank fee that hit the account without a corresponding ledger entry, or a transaction recorded in the wrong period.

3. Total the client (file) ledgers. Every open escrow file has its own running balance. Add them all up. This is where problems most often surface, because an error here doesn't just misstate a total — it means money is sitting under the wrong client's name, or a closed file was never zeroed out.

4. Compare all three totals. If they match, you're done for the period. If they don't, the difference has to be traced to a specific transaction and corrected before you move on — not carried forward as an "immaterial" variance to clean up later. In trust accounting, there's no such thing as an immaterial variance, because every dollar is somebody's money.

Where the Discrepancies Actually Come From

Auditors and underwriters see the same handful of problems repeatedly. Stewart Title's escrow audit preparation guidance flags these as the recurring red flags:

  • Negative file balances. A client ledger showing less than zero almost always means a disbursement was recorded against the wrong file, or a deposit that should have hit that file never got posted.
  • Stale deposits in transit. A deposit sitting "in transit" for more than a few days usually means it was never actually deposited — someone recorded the entry but the check is still in a drawer.
  • Old outstanding wires and payoff checks. A payoff check unresolved after 10 days, or a wire that's been pending for days without confirmation, is exactly the kind of thing that turns into a six-figure problem if it's actually gone to the wrong account.
  • "Banked-not-booked" entries. Money hit the bank account but never got recorded in the books — often because a deposit slip got misfiled or a wire confirmation never made it to whoever does the data entry.
  • Dormant or unused accounts left open. Old accounts with old signers still attached are a liability even if the balance is zero, because they're an access point nobody's watching.

None of these are exotic. They're the same categories of error every business makes in routine bookkeeping — except here, "we'll catch it next month" isn't an acceptable answer, because next month someone might be trying to close on a house with money that isn't where the books say it is.

Separation of Duties Isn't Optional Either

The bookkeeping controls matter as much as the reconciliation math. Best practice — and in many states, regulatory requirement — is that whoever performs the reconciliation should have no check-signing authority on the account. If the same person who moves money is also the person who verifies the balance matches, you've removed the one control that catches both honest mistakes and deliberate ones.

Layered on top of that:

  • Management reviews and signs off on every completed reconciliation, not just the ones that look off.
  • Signatory stamps and wire-authorization credentials are restricted to specific, current employees — and revoked immediately when someone leaves.
  • Daily or weekly online banking access lets someone monitor the account between formal reconciliation cycles, rather than discovering a problem 25 days into a 30-day window.

This isn't bureaucratic overhead. It's the difference between catching a $4,000 misposting the week it happens versus discovering a $400,000 shortage during a state examination, which is precisely the pattern behind the license revocations and criminal cases that show up in state insurance department enforcement actions.

The Fraud Backdrop Makes This Non-Negotiable

Trust accounting discipline isn't just about internal bookkeeping hygiene — it's the last line of defense against a fraud category that's grown sharply. The FBI's Internet Crime Complaint Center reported that cybercriminals stole more than $275 million through real estate-related fraud from over 12,300 victims in 2025, up from roughly $173 million the year before. The overwhelming majority of that is business email compromise: a scammer intercepts closing correspondence, sends "updated" wiring instructions that look legitimate, and a buyer's down payment lands in an account that isn't the title company's at all.

Individual losses in these incidents commonly run $98,000 to $125,000, and recovery is a race against time — the FBI's Recovery Asset Team has a roughly 58% success rate on wires it catches quickly, but that window closes within days as funds move through the banking system. An agency with airtight trust accounting and a habit of verbally confirming wiring instructions through a known phone number, rather than trusting whatever showed up in an email, closes off the easiest version of this scam. An agency whose books are already sloppy has no early-warning system at all — a fraudulent disbursement just looks like one more entry in an account nobody's reconciling carefully.

Building This Into Your Bookkeeping Routine

If you run or manage a title or escrow operation, a few habits keep the three-way reconciliation from becoming a monthly fire drill:

  • Reconcile continuously, not just at month-end. Weekly informal checks on the largest or oldest open files catch problems while they're still small.
  • Close files completely. A disbursed file should hit zero and get moved out of the active ledger the same day funds go out — not linger with a small residual balance nobody's tracking.
  • Keep clean, traceable records per file. Every deposit and disbursement should reference a file number on both the check/wire and the deposit documentation, so a reconciler can trace any line item back to a specific transaction without guessing.
  • Document your process. ALTA's Best Practices framework expects a written policy for how reconciliations are performed, by whom, and how discrepancies get escalated — not just that they happen to get done.

Good trust accounting is ultimately a bookkeeping discipline problem before it's a compliance problem. An agency with clear, current, file-by-file records catches a misposted entry in minutes. An agency reconstructing six months of commingled transactions from bank statements alone is the one that ends up in front of a regulator explaining a shortage it can't fully account for.

Simplify Your Financial Management

Whether you're running a title agency's trust account or just trying to keep your own business's books auditable, the underlying principle is the same: records you can trace, verify, and reconstruct beat records you merely trust. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — every entry traceable, every balance verifiable, no black boxes. Get started for free and see why developers and finance professionals are switching to plain-text accounting.

Share this article