Your trust account, reconciled three ways
Drop the bank statement and the trust ledger. Tiesheet matches them, lists outstanding checks and deposits in transit, totals every client ledger and shows whether bank, book and clients agree — and why not, if they don’t. It runs in your browser; nothing is uploaded.
How it works
- Drop the bank statement export and the trust ledger (CSV or Excel). Optionally add your software's client balance report.
- Check the period and ending balance — read from the statement when it has a balance column.
- See whether it ties: outstanding items, bank items missing from the ledger, every client's balance and the checks that failed. Print it, or with Pro download the Excel workbook.
Why Tiesheet
For small law firms, bookkeepers, real estate brokers and property managers who reconcile a trust or escrow account every month and keep the ledger in QuickBooks, a spreadsheet or practice software.
Matches it for you
Bank lines are matched to ledger entries by check number, amount and date — including one bank deposit that covers several client receipts.
All three legs
Adjusted bank balance, trust ledger balance and the total of every client ledger, side by side, with the differences explained.
Catches the risky stuff
Negative client balances, clients that dipped below zero mid-month, entries with no client, unrecorded bank fees, stale checks and duplicates.
Month to month
Pro saves this month's outstanding checks and deposits in transit in your browser so next month starts where this one ended.
A report you can sign
Print or save as PDF with signature lines. Pro adds an Excel workbook with formulas and per-client ledger cards.
Client data stays put
No upload, no account, no bank connection. Transactions are never stored — close the tab and they're gone.
Simple pricing
Free to reconcile and check. Pro for every client ledger, the Excel workbook and month-to-month carry-forward.
Free
- Reconcile any account, any size
- Three-way summary and every check
- Print / PDF and CSV with up to 10 client ledgers
- No signup, nothing uploaded
7-day pass
- 7 days of Pro, no subscription
- Every client ledger, no footer
- Excel workbook & ledger cards
- Enough for one month-end
Pro Monthly
- Every client ledger, every account
- Excel workbook with formulas
- Outstanding items carried to next month
- Client ledger cards · cancel anytime
Pro Yearly Best value
- Everything in Pro
- Twelve month-ends and every account
- Costs less than 9 months of monthly
Prices in USD. Secure checkout and sales tax handled by our payment partner. Already bought? Enter your license key.
Tools & guides
- Three-way reconciliation for trust accounts, in minutes
- Trust account reconciliation template (Excel and CSV)
- IOLTA reconciliation for small law firms
- Three-way trust reconciliation from QuickBooks
- Trust account reconciliation for real estate brokers and property managers
- Find negative client balances in your trust account
- How to do a three-way reconciliation, step by step
- Trust account reconciliation rules: what the ABA and state bars say
- Outstanding and stale checks in a trust account
- Negative client ledger balance in a trust account: causes and fixes
- Bank fees in a trust account: how to record them
- A TrustBooks alternative for three-way reconciliation
- A LeanLaw alternative for trust reconciliation only
- A Tieout alternative for property-management trust accounts
- A TreasuryFlow alternative that never connects to your bank
- An alternative to reconciling your trust account in Excel
FAQ
What is a three-way reconciliation?
It shows that three balances agree on the same date: the bank statement balance adjusted for outstanding checks and deposits in transit, the trust account ledger (checkbook) balance, and the total of all individual client ledger balances. Lawyers with client trust (IOLTA) accounts and real estate brokers holding escrow funds are generally required to do it regularly; how often depends on your state.
Is my data uploaded?
No. Your files are read by JavaScript in your browser tab and never sent to us or anyone else. Transactions aren't stored at all. With Pro you can choose to keep this month's outstanding items in this browser for next month.
Which files can I use?
CSV, tab-separated or Excel exports. The bank file needs a date and an amount (or deposit and withdrawal columns); a check number and running balance help. The ledger needs a date, an amount and a client, matter, owner or tenant column on each line. QuickBooks-style reports grouped under client headings work. Download the templates to see the layout.
What's free?
Matching, the three-way summary, outstanding items and every check, for any number of transactions. The printed report and CSV list up to 10 client ledgers with a small footer. Pro lists every client ledger and adds the Excel workbook, ledger cards and month-to-month carry-forward.
Does it replace my trust accounting software?
No. Tiesheet reconciles the records you already keep; it doesn't record transactions, write checks or connect to your bank. It also doesn't know your state's rules — check them, and have the report reviewed by the responsible lawyer or broker.
Why doesn't the bank balance agree with my ledger?
Usually bank fees or interest that were never recorded, a deposit or check recorded for the wrong amount, or an item outstanding from last month. Tiesheet lists bank transactions missing from the ledger and says when they explain the whole difference.