Three way reconciliation software for law firm and client trust accounts
Reconciles is three way reconciliation software for firms that hold client money. You upload the trust account bank statement and the exports from your trust ledger and client ledgers, and every bank line is matched to the ledger entries behind it. Whatever does not tie, a check still outstanding, a fee posted to the wrong client, a deposit with no ledger entry, lands in an exceptions queue with the exact dollar gap. Plans are published from $888 a year, and the prepared three way comparison is on the Scale plan.
Your files are processed in your browser and never stored. No card needed.
Why the third leg of a trust reconciliation takes the evening
A two way reconciliation asks whether the bank statement agrees with your books. A three way reconciliation adds the question that regulators and auditors care about: do the individual client balances add up to the trust ledger, and does that total equal the adjusted bank balance. All three numbers must be the same at the end of every month.
The numbers rarely start out equal.
- A client's retainer arrives as one wire, but your ledger holds it as two entries.
- A check written from the trust account has not cleared, so the bank balance is higher than the ledger.
- A deposit made on the 30th shows in the ledger and in the bank on the 2nd.
- An earned fee is moved to operating and recorded in the trust journal, but nobody posted it to the client ledger.
- One client ledger goes negative because a disbursement was charged to the wrong matter.
A spreadsheet can carry this for a handful of clients. Past a few dozen active matters, the monthly tick and tie is the part that gets skipped or rushed, and an unexplained difference of a few hundred dollars is exactly what a bar audit asks about.
How to run a three way reconciliation with Reconciles, step by step
-
01 Export the three records
Download the trust account bank statement for the month as CSV, XLSX, OFX, MT940 or PDF. From your trust accounting system or QuickBooks, export the trust account journal and the client ledger transactions as CSV or XLSX. Any file with a date, a client or reference and an amount works.
-
02 Upload the statement and the ledger exports
Drop the bank statement in the first slot and the ledger exports in the second. Reconciles reads columns by content, so there is no template to build per system or per client.
-
03 Review matches and exceptions
Each bank deposit, check and fee transfer is matched to the ledger entry behind it, including one deposit to many client entries. Items found on one side only, amount differences and duplicates go to the exceptions queue.
-
04 Prove the three balances
Take the bank balance, add deposits in transit and subtract outstanding checks, both read from the unmatched lines. Compare the result with the trust ledger balance and with the sum of the client ledger balances. On the Scale plan Reconciles prepares this three way comparison for you from an export of your client balances. On Starter and Growth you take the totals from the matched report, as the worked example below shows.
-
05 Export the report
Download the result as XLSX or PDF for the month end file, the bar audit or the client's own review.
Who uses three way reconciliation software
- Law firms and solo practitioners with an IOLTA or client trust account who must reconcile every month.
- Bookkeepers and accounting firms that keep the trust books for several law firms and want one repeatable step.
- Property managers who hold tenant security deposits and owner funds in trust accounts, see property management bank reconciliation.
- Escrow, settlement and similar practices that hold funds for other people and answer to a regulator.
Healthcare practices are a less obvious case. A clinic that collects patient deposits in Xero or QuickBooks, whose clinicians work in clinical software such as Prescriber, still has to prove those deposits against the bank in the same way.
What the matching catches
- Deposits in the bank with no ledger entry, and ledger receipts that never reached the bank.
- Checks and electronic disbursements still outstanding, listed with their age.
- Fee transfers recorded in the trust journal but missing from the client ledger.
- Disbursements charged to the wrong client or matter, which leave a client balance negative.
- Duplicate receipts and bank fees nobody has booked.
Every match shows its reason and a confidence score, so a reviewer accepts it in one click or opens the exception.
Reconciles compared with a trust accounting module and a spreadsheet
Legal practice management systems such as Clio include trust accounting, and bookkeeping systems keep client balances through classes or sub ledgers. They record the transactions. What they do not always do is explain a difference between the bank and the books line by line, or work across more than one system. A matching layer fills that gap.
| Need | Spreadsheet | Trust module in your system | Reconciles |
|---|---|---|---|
| Record client receipts and disbursements | No | Yes | No |
| Match each bank line to a ledger entry | By hand | Partly | Yes |
| Match one deposit to many client entries | By hand | Limited | Yes |
| List outstanding items with age | By hand | Yes | Yes |
| Work across several banks or several systems | By hand | No | Yes |
| Published price | Staff hours | Part of the system | $888 to $5,988 a year |
Keep your trust accounting system for the books and add Reconciles as the second check against the bank. If the firm manages many trust accounts across entities, the multi entity reconciliation page shows how accounts are grouped.
A month end trust account, line by line
Say the trust bank statement closes at $48,215.40. Two checks are outstanding, $1,870.00 and $1,250.00, which is $3,120.00. A $2,500.00 deposit was made on the last day and posts on the 2nd. The adjusted bank balance is $48,215.40 minus $3,120.00 plus $2,500.00, which is $47,595.40.
The trust ledger also shows $47,595.40. The client ledgers for the three active matters show $18,240.10, $21,005.30 and $8,350.00, and those add up to $47,595.40. All three agree and the month is proved.
Now suppose the client ledgers add up to $47,170.40 instead. The $425.00 gap is an earned fee transferred to operating that was entered in the trust journal but never posted to the client ledger. Reconciles matches the $425.00 bank transfer to the journal entry, finds no client ledger entry behind it, and puts it in the exceptions queue with the amount. You post it to the right client and the three numbers agree again.
Plans for firms of every size
Starter is $888 a year billed yearly for 3,000 matched transactions a month, enough for a firm with dozens of client matters. Growth is $2,388 a year for 20,000 a month across 5 entities, for bookkeepers who keep trust books for several firms. Scale is $5,988 a year for 100,000 a month across 25 entities and prepares the three way comparison from an export of client balances. See the pricing page, and for the general file matching flow read about bank reconciliation software. Trust account rules differ by state, so check yours with the state bar, and see the ABA Model Rule 1.15 on safekeeping client property.
Three way reconciliation questions
A three way reconciliation compares three records of the same client money: the adjusted bank balance, the trust ledger balance and the total of the individual client ledgers. All three must agree. It is the standard monthly check for law firm trust accounts, and any difference is investigated and fixed before the month is closed.
Law firms with one trust account and a few matters are well served by the trust module in their practice management system. A matching tool such as Reconciles fits when the exceptions take the time: deposits that cover several clients, outstanding checks, fees posted to the wrong ledger. Plans start at $888 a year, with the prepared three way comparison on Scale.
Reconcile the trust bank account in QuickBooks as usual, then run a client ledger or customer balance report as of the same date. The statement balance, adjusted for outstanding items, must equal the QuickBooks trust balance and the sum of the client balances. Export both and upload them to Reconciles to see each gap by line.
Most state bars expect a monthly reconciliation of every client trust account, and some require a quarterly summary. The exact rule depends on your jurisdiction, so check your state bar's trust account guidance. Reconciling at each month end, within a few days of the statement, keeps differences small and easy to trace.
No. Reconciles does not record receipts, disbursements or client balances. It reads the exports from your trust accounting system and the bank statement, matches them and lists what does not tie. Keep your system for the books and use Reconciles as the monthly proof against the bank.
Reconciles publishes its plans. Starter is $888 a year billed yearly for 3,000 matched transactions a month, Growth is $2,388 a year for 20,000 a month across 5 entities, and Scale is $5,988 a year for 100,000 a month across 25 entities. Monthly billing is $149, $399 and $999.
Check last month's trust account against the bank
Upload the trust account statement and your ledger export. You will see which deposits and checks matched, and which lines do not tie, before you create an account.