Reconciles

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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

NeedSpreadsheetTrust module in your systemReconciles
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

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.