QuickBooks Online can keep IOLTA records a bar auditor will accept, but only if you set it up so that every dollar in the trust bank account is tied to a named client, no client balance ever goes below zero, and three numbers agree every month: the reconciled bank balance, the trust liability balance in your books, and the total of your client ledgers. QuickBooks will not enforce any of that; the setup and monthly routine below do.
Each state sets its own trust rules, most modeled on ABA Model Rule 1.15 (Safekeeping Property). Your books have to show four things from it:
Separation. Client funds are kept in a separate account, apart from the firm’s own money: two bank accounts, two bank ledgers.
No firm money, with one narrow exception. Rule 1.15(b) lets a lawyer keep their own funds in trust only to pay bank service charges on that account, and only in the amount needed. Some states set a hard cap. Minnesota’s trust-account guide, for example, limits the firm’s own funds in trust to $200.
Advance fees stay in trust until earned. Rule 1.15(c) says advance fees and expenses go into the trust account and come out only as fees are earned or expenses incurred. A retainer is not income the day it arrives.
Disputed money stays put. If you and a client disagree about part of a balance, Rule 1.15(e) says that part stays separate until the dispute is resolved, and the undisputed part is distributed promptly.
The rule also requires complete records of trust funds. The model text sets retention at five years after the representation ends, in brackets so each state can choose its own period. Minnesota’s guide says six years. Check your state’s version before you decide how long to keep the monthly reports.
Intuit’s own help article on retainers and deposits (updated August 2026) treats a client deposit as a liability, because it does not belong to the firm until it pays for services. Build on that.
1. A separate trust bank account. Add the IOLTA account to the chart of accounts as its own bank account and connect its bank feed separately from operating. Never route trust deposits through the operating account first.
2. A trust liability account. In the chart of accounts, create a new account with account type Other Current Liabilities and detail type Trust Accounts - Liabilities, named something like “Client Trust Liability.” At any moment its balance should equal the cash in the trust bank account.
3. A client name on every line. Each client or matter is a customer (or sub-customer for each matter). Every deposit to and every payment from the trust account carries that customer on the liability line. That is what turns one liability account into a set of client ledgers. Intuit’s method for seeing the per-client balances is to open the liability account’s report for all dates and group it by customer. Turn on Track expenses and items by customer in settings so expenses paid for a client can carry the customer name too.
4. A retainer item. Create a service item called “Retainer” whose account is the trust liability account, not an income account. Receive deposits on a sales receipt with that item, deposited to the trust bank account.
Minnesota’s guide, written for QuickBooks Desktop, instead uses one liability sub-account per client matter in a separate company file. Either works if applied consistently; customer tags scale better past a few dozen matters.
This is where most QuickBooks trust files go wrong. Earning the fee and moving the cash are two separate entries.
Step 1, the invoice. Invoice the client for the fees earned, and add the Retainer item as a negative line for the amount being applied. Revenue is recognized, the client’s trust liability goes down, and the invoice nets to what is still owed. Intuit notes you cannot apply more retainer than the invoice total.
Step 2, the transfer. Move exactly that amount from the trust bank account to operating, with the client and invoice number in the memo. Illustrative numbers: a client deposits $5,000. In March you bill $1,800 of earned fees and apply $1,800 of the retainer. Transfer $1,800 to operating. The client’s ledger now shows $3,200, the trust bank account is $3,200 lower than its peak by exactly that transfer, and the two still agree.
Skip the transfer and earned fees sit in trust, commingled with client money. Transfer before invoicing and the firm has taken unearned funds. A three-way reconciliation catches both.
Paying a client cost from trust (a filing fee, a settlement payout) is a check from the trust bank account coded to the trust liability account with the client as customer, never to an expense account.
Iowa’s Office of Professional Regulation states that a full three-way trust account reconciliation is required each month, and its checklist is a clean template for any state. Three balances, as of the statement date, must be equal:
The adjusted bank balance. Statement ending balance, less outstanding checks, plus deposits in transit: the trust bank account reconciled in QuickBooks Online’s reconcile tool.
The book balance. The trust liability account balance on the balance sheet as of the statement date (the general ledger, or check register, in the bar’s wording).
The client ledger total. The trust liability report grouped by customer, summed. Before you total it, look at every line. Iowa’s checklist says to review and resolve any negative client balance first.
When all three agree, save the statement, reconciliation report and client ledger report together. Minnesota’s guide keeps those monthly printouts six years.
A negative client balance. Paying more for a client than they have on deposit means you used another client’s money. The Minnesota guide is blunt: you can’t cover one client’s negative balance with anyone else’s money. QuickBooks will happily let the grouped report show a negative, so check it every month.
Unassigned money. A deposit with no customer, a bank charge with no owner, or interest coded straight to income leaves money loose in the account. The Minnesota guide says there can never be unallocated money in trust. Bank service charges come out of the firm’s small cushion, recorded against a firm-funds line, not left floating.
Spending against a deposit that has not cleared. The same guide warns against writing trust checks on unverified deposits. Wait for the bank to confirm the funds.
Operating expenses paid from trust. Rent or payroll paid from the IOLTA account is commingling, even if repaid the next day.
If your trust ledger has drifted (old matters with small balances, unexplained differences, months without a reconciliation), the fix is a structured reconciliation rebuild and a QuickBooks cleanup that traces each difference to a client. Behind on the operating books too? Catch-up bookkeeping handles both, and monthly bookkeeping keeps the reconciliation on schedule.
This article is general bookkeeping information, not legal or ethics advice. Trust account rules, record retention periods and IOLTA program requirements vary by state. Confirm specifics with your state bar or its trust account resources.
Can QuickBooks Online handle IOLTA trust accounting?
Yes, with discipline. It has no built-in trust compliance, but a separate trust bank account, a trust liability account, a client name on every trust transaction and a monthly three-way reconciliation produce the records state rules ask for.
What is a three-way trust reconciliation?
A monthly check that three balances match as of the statement date: the adjusted bank balance, the trust account balance in your books, and the total of every client’s ledger balance. Iowa, for example, requires one every month.
Is a client retainer income when I receive it?
No. Under ABA Model Rule 1.15(c), advance fees stay in trust and are withdrawn only as fees are earned. In QuickBooks, record the retainer to a trust liability account and move it to income only when you invoice earned work.
Can I keep some firm money in the trust account?
Only enough to cover bank service charges on that account, under Model Rule 1.15(b). Some states set a dollar cap; Minnesota’s guide, for example, says $200.
Tell us what you’re working on. We respond same business day.
Founder of Numerawise Solutions, based in Atlanta. Intuit ProAdvisor Gold tier. Former Intuit Technical Support engineer. Has personally led two hundred accounting software conversions for US small businesses since founding the practice. Reachable directly at [email protected].
Related: QuickBooks cleanup services · Bookkeeping · Hiring a QuickBooks consultant