A trust account reconciliation template has three blocks on one page: the adjusted bank balance, the trust journal (book) balance, and a listing of every client ledger balance with its total. All three figures must agree. Below the blocks sit a difference line, the preparer and reviewer sign-off, and a list of the records filed behind it.
What goes on a trust account reconciliation template?
A trust account reconciliation template needs a bank block, a book block, a client ledger block and a sign-off. The bank block adjusts the statement balance for timing items. The book block shows the trust journal balance. The client block lists what is held for each person. A results line compares the three totals.
Each block has its own columns.
The bank block
- Statement closing balance, copied from the last page of the bank statement for the month.
- Deposits in transit, each with its date, client or matter, and amount.
- Outstanding checks, each with its check number, date, payee and amount.
- Other bank-side items, such as a bank error the bank has agreed to correct.
- Adjusted bank balance, the result.
The book block
- Trust journal balance at month-end. Some firms call this the trust checkbook or the cash receipts and disbursements journal.
- Book-side items not yet posted, which should be empty by the time the template is signed.
The client ledger block
- Client or matter name and number, one row each.
- Balance held at month-end.
- Total of all client balances.
The results line
Three differences: adjusted bank less book, book less client total, and adjusted bank less client total. All three should read zero. The method behind those three comparisons is set out in three-way reconciliation for trust accounts. This post covers the paper itself.
Trust account reconciliation template, filled in for one month
The trust account reconciliation template below is filled in for an example law firm's trust account for March 2026. The bank shows 48,210.00 at month-end. After one deposit in transit and two outstanding checks, the adjusted bank balance is 44,500.00, which matches both the trust journal and the total of five ledger balances.
All names and amounts are examples.
Bank block
| Line | Detail | Amount |
|---|---|---|
| Statement closing balance | Trust account ending 2208, 31 March 2026 | 48,210.00 |
| Add: deposit in transit | 31 Mar, Alvarez matter 26-014, settlement funds | 3,500.00 |
| Less: outstanding check 1042 | 27 Mar, county clerk, Bennett filing fee | (1,200.00) |
| Less: outstanding check 1045 | 30 Mar, Chen, net settlement payout | (6,010.00) |
| Adjusted bank balance | 44,500.00 |
Book block
| Line | Amount |
|---|---|
| Trust journal balance, 31 March | 44,500.00 |
| Unposted book items | 0.00 |
| Adjusted book balance | 44,500.00 |
Client ledger block
| Client / matter | Balance held |
|---|---|
| Alvarez, 26-014 | 3,500.00 |
| Bennett, 25-188 | 12,000.00 |
| Chen, 25-201 | 4,000.00 |
| Dawson, 26-003 | 24,850.00 |
| Firm money for bank charges | 150.00 |
| Total | 44,500.00 |
Results
| Comparison | Difference |
|---|---|
| Adjusted bank less book | 0.00 |
| Book less client total | 0.00 |
| Adjusted bank less client total | 0.00 |
Two lines in that example deserve a comment. The Chen check for 6,010.00 has already been posted to the Chen ledger, so that ledger shows 4,000.00, the amount still held after the payout. The 150.00 of firm money is listed as if it were a client, because it is in the account and must be accounted for. Several states let a lawyer keep a small amount of their own money in trust to cover bank charges; The Florida Bar's Chapter 5 trust account rules allow an amount "no more than is reasonably sufficient to pay bank charges". Check your own state's limit before copying this line.
Client ledger listing on the trust template
The client ledger listing on a trust template shows one row for every client or matter with money in the account at month-end, small and old balances included. It is built from the individual ledgers, never typed in from memory. Zero balances can be left off. Negative ones must be shown, in brackets.
Practical points for the listing:
- Print it from the ledgers. Most trust accounting systems produce a client balance report. Use that report as the source and attach it.
- Sort by matter number. A reviewer comparing this month to last month can then spot a matter that has vanished or a balance that jumped.
- Show negative balances, never net them. A ledger below zero means one client's money has paid another client's costs. Netting it against a positive balance hides that. What causes a negative client trust balance and how to cure it covers the fix.
- Flag balances that have not moved. A balance unchanged for six months or more may belong to a finished matter and should be refunded or researched.
- Keep firm money on its own line. Firm money for bank charges, or earned fees not yet withdrawn, must be visible, not folded into a client.
The listing is the block most often skipped on homemade templates, because a normal bank reconciliation has no equivalent. It is also the block that proves no client's money is missing.
How should the trust template's sign-off block be completed?
The trust template's sign-off block is completed by a preparer and then a reviewer, each with a printed name, signature and date. The preparer signs to say the figures came from the records. The reviewer, ideally the responsible lawyer, signs to say the three totals agree and every reconciling item was examined.
A sign-off block that means something has these fields:
| Field | Example entry |
|---|---|
| Account | Example Law PLLC trust account ending 2208 |
| Period | 1 to 31 March 2026 |
| Prepared by | Bookkeeper's name, signature, date prepared |
| Reviewed by | Responsible lawyer's name, signature, date reviewed |
| Exceptions noted | "None" or a list with the action taken on each |
| Records attached | Bank statement, journal, client listing, item support |
Dates matter. A reconciliation reviewed two months after month-end is evidence that it was done late. Florida's rule, for example, requires both the bank reconciliation and the comparison to the client ledgers every month, so the dates on the block are what show the work kept pace.
The reviewer should not be the person who wrote the checks or posted the journal. In a sole practice that is not always possible, so a common substitute is a monthly review by an outside bookkeeper or accountant who signs as reviewer. For the order of work each month on an IOLTA account in particular, see IOLTA reconciliation each month, step by step.
Building the trust account reconciliation template in Excel
A trust account reconciliation template in Excel works best as one sheet with input cells for the statement balance, a range for timing items, a range for client balances, and formula cells for every total and difference. The formulas make the template check itself, so an unbalanced month shows in red before anyone signs.
A layout that works, with example cell references:
| Cell | Content | Formula (example) |
|---|---|---|
| C4 | Statement closing balance | typed from the statement |
| C6:C15 | Deposits in transit | typed, one per row |
| E6:E25 | Outstanding checks | typed, one per row, entered as positive numbers |
| C27 | Adjusted bank balance | =C4+SUM(C6:C15)-SUM(E6:E25) |
| C29 | Trust journal balance | typed from the journal |
| H6:H60 | Client balances | pasted from the client balance report |
| H62 | Client total | =SUM(H6:H60) |
| C31 | Bank less book | =ROUND(C27-C29,2) |
| C32 | Book less clients | =ROUND(C29-H62,2) |
| C33 | Status | =IF(AND(C31=0,C32=0),"Balanced","Investigate") |
Three habits keep the workbook honest:
- Round the differences. Without
ROUND, Excel can show a difference of 0.0000001 that is really zero, or hide a real one-cent error behind formatting. - One sheet per month, never overwritten. Copy last month's tab, clear the inputs, and keep the old tab. Overwriting destroys the history an auditor will ask for.
- Lock the formula cells. Protect the sheet so the formulas cannot be typed over. A typed-over total is how a template ends up "balanced" when the account is not.
Conditional formatting on C33 is optional. A red fill on "Investigate" helps a reviewer who is checking many accounts.
Property managers who keep owner and tenant money in trust often reconcile inside their management software instead. Bank reconciliation in Yardi covers that route, and the same three-block check still applies to what the software produces.
Records to file with each monthly trust reconciliation
Each monthly trust reconciliation should be filed with the bank statement, the trust journal for the month, the client balance report, support for every reconciling item, and the signed template. Together those papers let someone rebuild every number on the page without asking the preparer a single question.
A filing checklist for each month:
- The complete bank statement for the trust account, every page, including check images if the bank supplies them.
- The trust journal or receipts and disbursements register for the month.
- The client ledger balance report as of month-end.
- Deposit slips or bank confirmations for each deposit in transit.
- A copy of each outstanding check, or the check register entry, with its date and number.
- Notes on any exception, what caused it, and the entry that corrected it.
- The signed and dated template.
Keep the file for the full retention period your state sets. Florida, for example, requires the monthly reconciliations and comparisons to be kept for at least six years, and its other trust records for six years after the representation ends. Where a rule measures from the end of the matter, a long-running matter keeps old reconciliations in the file well past six years.
PreciseBankFlow can help with the bank side of this file. It checks that each trust statement foots from opening to closing balance, matches statement lines to the register, and exports an exception report you can file with the month. The client ledger block remains yours to complete. You can request early access.
When a plain bank rec template fails for trust money
A plain bank reconciliation template fails for trust money because it compares only two figures, the bank and the book. A trust account can pass that test while one client is short and another is overstated, because the error sits inside the book total. Only the client ledger block catches it.
Here is how it happens, with example figures. A bookkeeper pays a 2,000.00 expert fee for the Bennett matter but posts it to the Dawson ledger. The bank is right. The journal is right. A two-way template balances. But Dawson's ledger is understated by 2,000.00 and Bennett's is overstated by the same amount. If Dawson's matter settles first and the firm pays out what the ledger says, Dawson is shorted.
The three-block template still balances in that case, because the client total is unchanged. What catches the error is the monthly review of the client listing: the Dawson balance dropped with no Dawson invoice behind it. So a template is only as good as the review done with it.
Other cases where a generic template is the wrong tool:
- Pooled accounts with many small balances. A template with a fixed number of client rows tempts the preparer to group small balances under "other". Never group them.
- Accounts where interest is paid to the bar foundation or to clients. The interest line needs its own treatment, and a generic template has nowhere to put it.
- Escrow and deposit accounts outside law firms. Property managers, title agents and insurance agencies hold money for others under their own rules. The three-block layout carries over, but the labels and the regulator's requirements change.
If your template has no place for client balances, it is a bank reconciliation, not a trust reconciliation. Add the block before the next month-end.