Report this item to Etsy

Three Way Reconciliation Template Excel, IOLTA Trust Account Spreadsheet, Law Firm Client Ledger Bookkeeping, Google Sheets

Price:$19.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 File

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 15, 2026