Trust/IOLTA Account Three Way Reconciliation Alerts
A daily automated workflow compares your trust account bank balance, client ledger balances, and internal trust ledger, then alerts your accounts manager the moment any figure doesn't match. Monthly, it generates a formatted three way reconciliation report ready for compliance records.
The Problem
Trust account violations are the leading cause of attorney discipline in most jurisdictions. Not fraud. Not malpractice. Bookkeeping errors. A bank fee hits the trust account, nobody notices for 30 days, and your firm is technically in shortfall from the moment it happened.
Every law society and bar association requires lawyers holding client funds to perform three way reconciliation: matching the bank statement balance against individual client ledger balances against the firm's internal trust ledger. Most firms do this monthly, if they do it at all. Manual reconciliation takes four to eight hours each month for firms with moderate trust activity. That's an entire working day spent cross referencing spreadsheets against bank statements.
The tools firms use don't help much either. QuickBooks and Xero weren't built for trust accounting. They don't understand the difference between operating funds and client funds. Practice management platforms like Clio and MyCase offer basic trust features, but they can't pull your bank feed, compare it against two other data sources, and flag the specific matter number where the numbers diverge. So firms rely on a person with a spreadsheet. And people miss things.
A $15 service fee charged to the wrong account sits undiscovered for a month. Meanwhile, the trust account is in shortfall. That's a disciplinary violation from the day it happened, not from the day you found it.
How It Works
The automation runs daily, pulling data from three sources and comparing them automatically. When something doesn't add up, your accounts manager knows within hours, not weeks.
1. Scheduled daily trigger
A workflow (built in n8n or a Python script) fires each morning at a set time. No manual initiation required. It runs every business day, including days your accounts team is busy with other priorities.
2. Pull bank transaction data
The workflow connects to your trust account bank feed through an API service such as Plaid and retrieves all transactions posted since the last run. This gives you the bank's view of your trust account balance.
3. Pull client ledger balances
Next, it queries your practice management system (such as Clio, Smokeball, or MyCase) via API to get the current balance for each client matter that holds trust funds. This is the second leg of the three way reconciliation.
4. Pull internal trust ledger
The workflow also retrieves your firm's internal trust ledger, whether that lives in your accounting software, a dedicated trust register, or a structured spreadsheet. This is the third data source.
5. Compare all three sources
The system runs a comparison across all three datasets. It checks that the total bank balance equals the sum of all client ledger balances and that both match the internal trust ledger. It also checks at the individual matter level, so you know exactly where a discrepancy sits.
6. Flag and categorise discrepancies
If any variance exists, the system categorises it: timing difference (a cheque in transit), bank error (a fee charged to the wrong account), data entry issue, or unidentified. This stops your team from chasing false positives caused by normal clearing delays.
7. Alert the accounts manager
An alert goes to your accounts manager via email or Slack with the specific matter number, client name, variance amount, and discrepancy type. They can act on it that same day instead of discovering it three weeks later during the monthly reconciliation.
8. Generate monthly compliance report
At month end, the workflow compiles a formatted three way reconciliation report suitable for your jurisdiction's compliance requirements. It's ready to file or present during an audit without anyone spending a day assembling it manually.
Why Monthly Reconciliation Isn't Enough
Most firms reconcile their trust accounts once a month because that's what the rules require as a minimum. But think about what happens in those 30 days between reconciliations.
Say a bank charges a $15 monthly service fee to your trust account on the 3rd. Your accounts person doesn't reconcile until the 28th. For 25 days, your trust account balance is lower than the sum of client ledger balances. That's a shortfall. It doesn't matter that it was the bank's error. It doesn't matter that it's only $15. From the moment the fee posted, your firm was holding less client money than it should have been.
A solo practitioner handling 40 active matters with trust funds has 40 individual balances to verify against two other data sources. One transposition error, one missed transaction, one bank fee in the wrong account. That's all it takes.
Firms that catch discrepancies within 24 hours can resolve them before they compound. A bank fee gets reversed the same week. A misposted deposit gets corrected before the next transaction obscures it. Daily automated checks turn a 30 day exposure window into a single day.
What This Looks Like for Different Firm Types
Personal injury firms hold settlement funds, sometimes for months while structured payouts are negotiated. The amounts are large and the consequences of a shortfall are severe. For these firms, the automation checks every matter where trust funds exceed a set threshold and sends a separate priority alert if a high value account shows any variance at all.
Conveyancing and real estate practices move money constantly. Deposits come in, settlements go out, adjustments happen daily. The volume alone makes manual reconciliation unreliable. Automation handles the volume without fatigue. It doesn't skip a row in the spreadsheet at 4pm on a Friday.
Solo practitioners and small firms feel this the most. They don't have a dedicated trust accountant. The principal is doing the reconciliation themselves after hours, or it's delegated to an office manager who handles it alongside a dozen other responsibilities. These are the firms where automation has the greatest protective effect, because there's no backup if the one person responsible makes a mistake.
The Business Impact
Take a five lawyer firm with a billing rate averaging $350 per hour. The accounts manager spends six hours each month on manual three way reconciliation. That's $2,100 in labour cost every month, or $25,200 per year, assuming the accounts manager's time is valued at the firm's blended rate.
With automated daily reconciliation, the monthly review drops to about 45 minutes of checking flagged items and signing off on the generated report. That's a recovery of over five hours per month. Across a year, the firm reclaims more than 60 hours of skilled time.
But the real number isn't the time saving. It's the risk avoided. Defending a bar complaint related to trust account mismanagement can cost $50,000 to $100,000 in legal fees and lost billing time. A practising certificate suspension costs the firm its entire revenue stream. The automation costs a fraction of one billable hour per month to run.
- Daily discrepancy detection instead of 30 day exposure windows
- Monthly compliance reports generated automatically, ready for audit
- Over 60 hours per year recovered from manual reconciliation tasks
- Matter level alerts with client name, matter number, and variance amount
- Categorised discrepancies so your team resolves real errors, not timing differences
- Practising certificate protection through continuous trust account monitoring
Frequently Asked Questions
Does this work with our existing practice management system?
The automation connects to any practice management platform that exposes client trust ledger data via API. Clio, Smokeball, MyCase, and LEAP all support this. If your system doesn't have an API, we can pull data from structured exports as a fallback.
What about banks that don't support modern API access?
Many Australian banks now support open banking feeds. For banks without API access, the workflow can ingest CSV or OFX bank statement files uploaded to a shared folder. It's not as hands off as a live feed, but it still automates the comparison and alerting.
Won't this generate too many false positives from timing differences?
The system distinguishes between timing differences (cheques in transit, pending deposits) and actual errors. It learns your firm's normal clearing patterns and only sends priority alerts for genuine discrepancies. Timing differences are logged but flagged separately so they don't create noise.
Do we really need daily reconciliation if the bar only requires monthly?
The bar requires monthly reconciliation as a minimum. But a trust account shortfall is a violation from the moment it occurs, not from the moment you discover it. Daily checks mean you catch and resolve issues before they become disciplinary matters. The monthly report still gets generated for compliance. You're just not flying blind between reports.
Is the data secure?
The automation runs on infrastructure you control. Bank credentials are handled through secure API services like Plaid, which use bank grade encryption and never expose your login details to the workflow. No client data is stored outside your existing systems. The workflow reads, compares, and alerts. It doesn't move money or modify records.
Can this handle multiple trust accounts across different jurisdictions?
Yes. Firms operating in multiple states or territories can run separate reconciliation workflows for each trust account, each configured with the relevant compliance rules for that jurisdiction. The monthly reports are formatted to meet local requirements.
How long does setup take?
Most firms are running within two to three weeks. The main variables are API access to your practice management system and bank feed connectivity. Once the data sources are connected, configuring the comparison logic and alert rules is straightforward. Book your free audit and we'll map out exactly what's needed for your firm's setup.
Sources
- PageLightPrime: IOLTA Account Reconciliation Guide 2026
- American Bar Association: A Guide to Ensuring IOLTA Account Compliance
- Law Firm Velocity: IOLTA Three Way Reconciliation
- Firm Balance: Navigating Trust IOLTA Reconciliations
- Bookkeeper.law: Three Way Reconciliation Accounting in Law Firms
- CosmoLex: Trust Accounting Features
- MyCase: Legal Accounting Software
- PageLightPrime: Three Way Reconciliation for Law Firm Trust Accounts
Automations we’ve already built
Thirty days after onboarding begins, an automated workflow surveys your client, pulls milestone data from your project tools, generates an AI written retrospective, and flags anyone who needs a recovery call. Every onboarding teaches the next one.
When a new client lands in your practice management software, this automation generates a tailored engagement letter with the right services, fees, and deadlines, sends it for electronic signature, then builds the client folder and kicks off your onboarding checklist. No chasing. No waiting.
A project manager fills out a short form after a discovery call. Within minutes, AI drafts a full Statement of Work into your branded template, routes it through Slack for internal approval, and sends it to the client for signature.
When a project closes in your PM tool, this automation collects every contract, deliverable, and sign off from across your systems, organises them into a standardised archive folder, and generates a summary PDF. No manual cleanup required.
When a contact is tagged in your CRM as needing an NDA, the agreement is generated from a template with their details prefilled, sent for signature, and tracked automatically. Overdue NDAs trigger reminders so nothing slips through.
Automatically converts raw meeting notes or recordings into structured, branded board minutes with tracked resolutions and action items, so your admin staff can stop spending full days on documentation that nobody reads until it's too late.
Capture scope changes on site, generate costed PDFs, route them through internal approval and client e signature, and log everything automatically. No verbal agreements, no lost paperwork, no payment disputes.
When a new contract lands in your cloud folder, an AI agent extracts the text, checks every clause against a risk framework, and sends your team a structured memo flagging the problems that actually matter. Preliminary review drops from hours to minutes.
When a new contractor lands in your HR system or Airtable base, this automation generates a complete document bundle, sends it as a single signing package through PandaDoc, and updates your records the moment everything is signed.
When a deal hits the proposal stage in your CRM, this automation pulls the client name, scope, pricing, and line items, then merges everything into a branded template. The finished PDF lands back on the deal record and in the prospect's inbox without anyone touching a document.
When every party signs a document in DocuSign or PandaDoc, this automation downloads the completed PDF, renames it to your filing convention, stores it in the right client folder, and notifies the account manager. No manual downloading, no misfiled contracts.
A scheduled workflow scans your contracts database daily, flags renewals at 30, 14, and 7 day intervals, and sends tiered alerts to account managers and leadership so nothing expires unnoticed.
When a new client is created in your CRM, this automation builds their billing profile, generates the first invoice, sets up recurring payments, and sends a secure link to collect their payment method. No manual data entry between systems, no forgotten first invoices.
When a project is marked complete in your project management tool, this automation pulls billable hours and rates, generates a branded PDF invoice, and emails it to the client with payment instructions. A copy lands in the client folder without anyone lifting a finger.
When a new patient books an appointment, this automation sends digital intake forms, collects consent and insurance details, converts everything to PDF, files it in the patient folder, and notifies your front desk. No clipboards. No data entry.
An AI agent that turns your meeting recordings into structured summaries, assigned action items, and tracked tasks across Slack, Asana, and Notion. No more post meeting admin, no more forgotten decisions.
An automated workflow pulls client KPIs from your data sources on the first business day of each month, populates branded report templates, converts them to PDF, and emails every client their personalised report before your team starts work.
Automatically classify incoming contracts by type, route each one to the right reviewer, and track every document through the review pipeline so nothing stalls in someone's inbox.
When a new B2B client submits their intake form, this automation reads every team member's role and sends each person the exact onboarding content they need. Billing contacts get payment setup. Project sponsors get the timeline. Day to day operators get tool access and kickoff details. Every stakeholder's progress is tracked independently until all are ready.
When a new client record lands in your CRM with a signed engagement letter, a prefilled contract is automatically generated and sent for e signature. No copying, no delays, no forgotten clauses.
When a prospect opens your proposal, this automation logs the view in your CRM, pings the assigned salesperson on Slack, and sends a templated follow up email if the document stays unsigned after 48 hours.
When a real estate agent fills out a short form with property details and buyer information, the automation generates a complete contract of sale, attaches the correct disclosure forms, and sends the full package to DocuSign with the right signing order.
Automatically converts approved quotes into signed service contracts with warranty terms, payment schedules, and scope definitions. No manual paperwork, no verbal agreements, no disputes three months later.
When a vendor sends a contract, AI extracts payment terms, liability caps, termination clauses and auto renewal dates into a structured row. Your procurement team can then compare every vendor agreement side by side, spotting bad deals before anyone signs.
Not ready to talk yet? Start here.
Everything we've learned building 300+ automations for small businesses, in one practical guide. Written for business owners, not engineers.
- Where your team's hours are actually disappearing
- The five automations worth setting up first and why
- How to calculate what manual work is actually costing you
- A step by step checklist to get your first automation live this week
Completely free.