CSV to QBO Converter for Law Firms: Import IOLTA Trust and Operating Bank Transactions into QuickBooks

Create a dedicated bank account in your chart of accounts for the IOLTA balance, and a matching current liability account for the client funds you are holding. The bank account tracks the cash; the liability account tracks whose cash it is. Keep both entirely separate from operating accounts. QuickBooks has no built-in trust module, so the discipline lives in how you structure these accounts.

A three-way reconciliation proves that three balances match exactly: the bank statement, the trust bank account in QuickBooks, and the sum of every individual client ledger. All three have to agree to the penny. Most state bars require it monthly, a few quarterly, and you keep the signed report for five to seven years in case of an audit.

QuickBooks can, but it has no native trust module, so compliance depends on your setup and habits. You track each client as a customer, hold their funds in a liability account, and never let a client ledger go negative. Firms that want automated three-way reports often add a legal layer such as LeanLaw or Clio on top of QuickBooks, but the underlying bank data still has to be complete and correct.

Record a trust deposit as an increase to the IOLTA bank account and to the client trust liability, tagged to that client. When you disburse, decrease both. Because the money belongs to the client, it never touches an income account, and earned fees move to operating only after you invoice and transfer them. Tagging every line to a customer is what lets you produce a per client ledger later.

Download the IOLTA account's activity from online banking as a CSV, convert it to a .qbo above, and import that file into the trust bank register. On QuickBooks Desktop, use Banking, then Bank Feeds, then Import Web Connect File. On QuickBooks Online, upload the .qbo under the bank account. Then match each line to the correct client before you reconcile.

Use the customer field, not a separate bank account per client. Tag every trust deposit and disbursement to the matter's customer record, then run a report grouped by customer against the trust liability account to see each client's balance. The total of those balances is the third number your three-way reconciliation has to match, so it must be current before you reconcile.

No. QuickBooks Desktop cannot import a bank or credit card CSV in any version or year, including Pro, Premier and Enterprise. Its only banking import is a .qbo Web Connect file, loaded through Banking, then Bank Feeds, then Import Web Connect File. That single limitation is why converting the trust account CSV is the standard route for Desktop based firms.

Most state bars require a three-way reconciliation at least monthly, and a few allow quarterly, but monthly is the safe default. The point of doing it that often is to catch a misposted deposit or a bank fee charged to trust while the trail is still fresh. Keep every signed reconciliation report; retention rules run five to seven years after a matter closes.

Yes. Download the full date range from online banking as one CSV, convert it, and import the .qbo. File imports have no 90 day limit, so a January to December pull goes in as a single file on QuickBooks Desktop. On QuickBooks Online, watch the 350 KB and 1,000 row ceiling on manual uploads and split a busy year by quarter if a file is too large.

Direct Connect stops on that date. Any QuickBooks Desktop account that pulled transactions automatically through Direct Connect goes quiet, and Direct Connect bill pay ends with it. Web Connect .qbo imports are unaffected. In practice firms move to downloading a file each month, either as .qbo if the bank offers it or by converting the CSV the bank does offer.

Not if the date ranges do not overlap. Every transaction in a converted .qbo carries a unique ID, the same field QuickBooks checks against activity it has already seen, so a repeated import is normally recognized and skipped. The safer habit for a trust account is still to import clean, non overlapping periods and reconcile each month before importing the next.

Yes. Conversion is a file format change, not a bank connection, so you never share online banking credentials and no login token is stored. The tool reads the CSV you downloaded and writes a .qbo with the same dates, amounts and descriptions. For a trust account that separation is a feature: the only thing moving is a file you already exported yourself.