Three Way Reconciliation Template Excel, IOLTA Trust Account Spreadsheet, Law Firm Client Ledger Bookkeeping, Google Sheets
Price:$19.00
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
A monthly three-way reconciliation workbook for a law office’s client trust account (an IOLTA or any other trust account). Type the bank statement balance, the outstanding checks and deposits in transit, the trust journal balance, and each client ledger balance, and it works out the adjusted bank balance and the sum of client ledgers and compares the three figures to the cent.
WHAT IS INSIDE
- Reconciliation: the adjusted bank balance, the trust journal balance, and the sum of client ledger balances side by side, each difference, an optional roll-forward from the prior period, and a Status line that reads Reconciled or Not reconciled.
- Outstanding checks (100 rows, with days outstanding for each), Deposits in transit (40 rows), and Client ledgers (300 rows, each ledger below zero marked).
- Checks: ten checks and six notes. Each reads OK or says what does not add up, for example a client ledger below zero, or a client listed twice.
- Check aging: outstanding checks by days outstanding (0 to 30, 31 to 60, 61 to 90, over 90), so old checks stand out.
- Year log: the bank balance, the three figures, and the differences for each of 12 months.
- Instructions, and a made-up example already filled in (one trust account, March 2026).
HOW TO USE IT
1. Open the file in Excel or upload it to Google Sheets. Save a copy for each month.
2. Clear the example, then type in the tinted cells. In Excel every other cell is locked, so a formula cannot be typed over by accident; there is no password.
3. Read the Status line and the Checks sheet, then print the Reconciliation sheet. It fits one page wide.
4. To check the finished file a second way, the Instructions sheet gives the address of a free report that opens the workbook in your browser and compares every figure with its own.
WHAT YOU GET
- 1 Excel workbook (.xlsx) with 9 sheets
- Opens in Excel 2010 or later and in Google Sheets
- Real formulas. No macros and no add-ins
- A made-up example already filled in, and an Instructions sheet
- Tinted cells to type in. In Excel the formulas are locked, with no password
- Prints one page wide. Instant download; nothing is shipped
- Sheets: Instructions, Reconciliation, Outstanding checks, Deposits in transit, Client ledgers, Checks, Check aging, Year log, Working
WHAT IT DOES NOT DO
- It does not read a bank statement, connect to a bank, or keep the trust journal or the client ledgers themselves. It makes no statement about what any rule, regulation, or agreement requires, and says nothing about what a difference means or how to resolve it.
- Calculations only; not legal, tax, or accounting advice. It adds, multiplies, and compares the numbers typed into it.
- This is a digital file. Nothing is mailed.
HOW IT WAS MADE
Designed by OpenSlot LLC, the company behind Mathproven, with the use of AI tools: the formulas, sheets, and listing pictures were written with an AI coding assistant, then checked against the same tested calculations the free tools on the site run.
Prepared with Mathproven (mathproven.com).
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Trucking Mileage and Fuel Log Spreadsheet, Quarterly Fuel Tax Worksheet by State, Owner Operator Excel Template, Google Sheets
$19.00
-
Digital download
Seller Bookkeeping Spreadsheet, Online Shop Monthly Books Template Excel, Sales Tax by State, Sales by Product, Fee Tracker, Google Sheets
$17.00
-
Digital download
Donation Tracker Spreadsheet, Year End Giving Statement Template, Church Tithe Log, Nonprofit Donor Log Excel, Google Sheets
$17.00
-
Digital download
Owner Statement Template Excel, Rental Property Management Spreadsheet, Landlord Income Expense Ledger, Google Sheets
$15.00
Be the first to leave a review
-
Digital download
Trust Accounting Sheet | Excel and Google Sheet Template | Trust Ledger for Law Firms, Clients, Finance, Compliance & Transparency
Sale Price $5.69
Original Price $11.38
-
Digital download
Trust Account Ledger Excel Spreadsheet, Trustee & Estate Planning Accounting Template, Transaction Register Workbook (Digital)
$11.99
-
Digital download
Bank Reconciliation Excel Template Bookkeeping Monthly Accounting Spreadsheet Financial Tracking Digital Download
$5.82
-
Digital download
Intercompany Reconciliation Sheet | Google Sheets Template | Financial Transaction & Account Balancing Tool | Accurate and Efficient
Sale Price $5.69
Original Price $11.38
-
Digital download
Construction Financial Statements Excel Template Bookkeeping Auto Balance Sheet Income Statement Accounting Digital Download
$18.20
-
Digital download
Balance Sheet Reconciliation Template, Editable Google Sheets, Easy-to-Use, Digital Download for Accounting, Financial Reporting, and Audits
Sale Price $2.91
Original Price $7.28
-
Digital download
Income and Expense Ledger for Trustees
$49.00
-
Digital download
General Ledger (GL) Reconciliation Template | Excel & Google Sheets | Financial Statement Reconciliation Tool | Accounting Spreadsheet
Sale Price $5.69
Original Price $11.38
-
Digital download
Month-End Closing Checklist for Bookkeepers and Accountants Bookkeeping Excel Template Digital Download
$10.92
-
Digital download
Accounting Year End Close Checklist Excel Template Bookkeeping CPA Audit Preparation Tracker Digital Download
$10.92
-
Digital download
Accounting Spreadsheet For CORPORATIONS Service Business Small Business Double Entry Bookkeeping Template Google Sheets MS Excel
Sale Price $11.02
Original Price $14.70
-
Digital download
Accounting Spreadsheet For PARTNERSHIP Service Business Small Business Double Entry Bookkeeping Template Google Sheets MS Excel
Sale Price $11.02
Original Price $14.70
Shoppers with similar taste loved these
-
Digital download
Editable Sublease Agreement, Customizable Sublease Template, Sublease Contract, Renter Agreement,Residential Sublease template, PDF,Canva
Sale Price $3.59
Original Price $3.99
-
Digital download
Editable Food Truck Lease Agreement Template, Canva & PDF
Sale Price $2.73
Original Price $3.03
-
Digital download
Construction Budget, Management and Cost Tracking Tool
$9.99
-
Digital download
Editable Studio Rental Agreement Template, Studio Lease Agreement, Studio Rental Contract, Customizable Studio Lease Agreement Pdf,Canva
Sale Price $2.73
Original Price $3.03
-
Digital download
Event Rental Agreement, Event Decorating Services Contract Template, Wedding decorating agreement, Wedding Rental, Pdf, Canva
Sale Price $2.73
Original Price $3.03
-
Digital download
Event Planning Proposal Template, Event Planning Services form, Event Proposal, Pdf, Canva
Sale Price $3.59
Original Price $3.99
-
Digital download
Educational Proposal Template Form, Pdf, Canva
Sale Price $3.59
Original Price $3.99
-
Digital download
Business Partnership Proposal Template, Partnership Proposal form, Collaboration Proposal, Pdf, Canva
Sale Price $3.59
Original Price $3.99
-
Digital download
Construction Project Manager | Streamline Construction Tasks | Google Sheets Tool
Sale Price $3.60
Original Price $9.00
-
Digital download
Price & Profit Calculator for Small Businesses with 5 Pricing Strategies and up to 2 Taxes | Price Guide | Price List Spreadsheet Template
Sale Price $4.53
Original Price $9.06
-
Digital download
LLC articles of organization, LLC Formation Document, Pdf, Canva
Sale Price $2.73
Original Price $3.03
-
Digital download
Editable Buy–Sell Agreement Form template, Business Purchase Agreement, Ownership Transfer Document, Customizable Legal Document, PDF, Canva
Sale Price $3.59
Original Price $3.99