3-Way IOLTA Reconciliation Tracker | Google Sheets Template + Practical Guide | Law Firm Trust Accounts

A clear, repeatable monthly workflow for 3-way IOLTA trust account reconciliation.

The Bradford Bookkeeping 3-Way IOLTA Reconciliation Tracker gives bookkeepers, law firm administrators, and attorneys a structured system for comparing the adjusted bank balance, adjusted QBO balance, and adjusted client-ledger balance — every month, with full documentation support.

This is not just a spreadsheet. It includes a 12-page Practical Guide that explains the reconciliation, walks through the monthly workflow step by step, and covers troubleshooting, red flags, and common mistakes.

WHAT'S INCLUDED

Google Sheets Tracker:

• Quick Start tab — selected-month summary with open items, completion checks, and recommended action
• Two-account Dashboard — side-by-side monthly status for both trust accounts
• Annual summary tabs for each trust account (Recon 1234 / Recon 5678)
• Monthly reconciliation Template Month tab — duplicate once per account per month
• Outstanding Checks tracker — aging, status, and open-item detail
• Deposits in Transit tracker
• Completed example reconciliation
• Printable Template Cover Sheet
• Setup tab — firm name, account details, dynamic names, statement-date offsets
• In-workbook Instructions tab

Bradford Bookkeeping Practical Guide (12-page PDF):

• What a 3-way reconciliation proves and why a QBO bank rec alone is not enough
• Initial setup walkthrough
• Step-by-step monthly reconciliation workflow
• Explanation of every adjustment type (outstanding checks, deposits in transit, QBO adjustments, client-ledger timing items)
• Dashboard and Quick Start field definitions
• Troubleshooting guide for Pending statuses and balance differences
• Month-end completion checklist and red flags table
• Frequently asked questions (Clio, Smokeball, non-month-end statements, more than two accounts)
• Monthly quick reference checklist

WHO THIS IS FOR

• Bookkeepers serving law firms (one license required per client firm)
• Law firm administrators managing monthly trust reconciliation
• Attorneys responsible for trust-account oversight
• Firms seeking a clearer, more defensible monthly reconciliation workflow

INTRODUCTORY PRICE — $37

IMPORTANT

The workbook is structured for two trust accounts. The tracker organizes and documents the reconciliation process. It does not replace QuickBooks, individual client ledgers, bank statements, or professional judgment, and does not guarantee compliance with any jurisdiction's requirements.

LICENSE

Purchase grants a non-transferable single-law-firm license. Bookkeepers must purchase one license per client law firm. Redistribution, resale, sublicensing, public posting, or sharing the master template or guide is prohibited.

DISCLAIMER

This product is an educational and operational tool. It is not legal, tax, audit, or accounting advice and does not guarantee compliance with any jurisdiction's requirements.