Bank Statement to QuickBooks for Law Firms: Convert PDF Statements to QBO

A law firm rarely runs on one account. There is an operating account for fees and overhead, at least one IOLTA or client trust account, often a credit card, and sometimes a separate escrow or settlement account. Bank feeds usually reach back only about 90 days, and they frequently skip trust accounts and older history. That is a problem when a bar auditor can ask for years of trust records at any time.

QuickBooks does not read a PDF on its own. If your bank only hands you PDF statements for the trust account, you need to convert them into a format QuickBooks accepts. Manual uploads carry no date limit, so you can bring in a full prior year or an account the feed never touched. You can convert a bank statement to QuickBooks in a few minutes with the tool above.

The first rule of legal bookkeeping is that client money and firm money stay apart. Retainers and settlement funds sit in the IOLTA or trust account until they are earned or disbursed. Firm income, payroll, rent, and software live in the operating account. Commingling the two, even briefly, is one of the fastest ways to draw a bar complaint. Most state bars and the ABA Model Rules require a separate trust account and a running ledger for each client whose money you hold.

In QuickBooks, set up the trust bank account on its own, and record client funds against an Other Current Liability account (commonly called Funds Held in Trust) with a sub-account or class for each client or matter. The money is a liability because it belongs to the client, not the firm, until you earn it. Never book a trust deposit as income.

Trust accounting is the most common source of attorney discipline in the country, and the standard safeguard is a monthly three-way reconciliation. Three numbers must agree. First, reconcile the IOLTA bank account in QuickBooks against the bank statement, as you would any account. Second, confirm that the Funds Held in Trust liability balance equals that reconciled bank balance. Third, add up every client's individual trust ledger and confirm the total equals the same number.

When the bank balance, the trust liability, and the sum of the client ledgers all match, the reconciliation is clean. If they do not, you have a bookkeeping error or, worse, a shortage in client funds to find before month end. Converting your trust statement to a clean data file each month makes this quicker, because you check real imported transactions instead of retyping them.

Getting categorization right at import time keeps the trust liability and the operating books honest. Here is how everyday firm transactions line up in QuickBooks.

The earned fee transfer is where most firms slip. Money moves from trust to operating only after you have invoiced the client and earned the fee. Recording that transfer promptly keeps the trust liability equal to the trust bank balance, which is exactly what three-way reconciliation checks.

Because the trust account holds other people's money, it gets its own reconciliation, separate from the operating account. Convert the IOLTA account's PDF statement, import it, and reconcile it to the penny each month. Bank fees and any interest posted to the account (in a true IOLTA the interest goes to the state bar foundation, not the firm) must never reduce a client's balance. Keep the reconciliation report, the client ledger detail, and the bank statement together as your compliance record.

If you manage several firms, converting statements in bulk bank statement to QuickBooks saves time, and bookkeepers with multiple legal clients may prefer the workflow built for bank statement conversion for accountants.

1. Upload your PDF bank, credit card, or IOLTA trust statements to the converter at the top of this page. You can add several at once. It accepts PDF and image files.
2. The tool OCRs and parses each statement and reconciles the running balance, keeping the date, description, and amount for every line.
3. Download a .qbo file per statement, plus Excel and CSV copies for your trust ledgers and three-way reconciliation worksheets.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 lines per file. Each file must be in English and 350 KB or less, so split a long statement if it runs past those limits. For more detail, see how to import a bank statement into QuickBooks Online or use the PDF to QBO converter directly.

Can I use QuickBooks for attorney trust accounting?

Yes. QuickBooks can handle IOLTA and client trust accounting if you set up the trust bank account separately, track client funds as a liability with a sub-account per client, and run a three-way reconciliation each month. Many firms add legal billing software on top, but the core trust ledger works in QuickBooks when it is configured correctly.

How do I record a retainer in QuickBooks?

Record a client retainer as a deposit to the trust bank account and an increase to a Funds Held in Trust liability, tagged to that client. It is never income while it sits in trust. When you invoice and earn the fee, transfer that amount from trust to operating and recognize the income at that point.

What is three-way reconciliation?

Three-way reconciliation is a monthly check that three trust numbers match: the IOLTA bank statement balance, the trust account balance in QuickBooks, and the sum of all individual client trust ledgers. When all three agree, no client funds are missing or misapplied. Most state bars expect firms to perform and keep this reconciliation for the trust account.

How do I set up an IOLTA account in QuickBooks?

Add the IOLTA account as a separate bank account in your chart of accounts, then create an Other Current Liability account named Funds Held in Trust with a sub-account or class for each client. Record every trust deposit against the correct client, never as a lump sum, so the client ledgers stay accurate for reconciliation.

Can I import old bank statements into QuickBooks for taxes?

Yes. Manual uploads have no date limit, unlike bank feeds that reach back only about 90 days. Convert your older PDF statements, including prior year trust and operating statements, into .qbo files and upload them. This is how most firms backfill a tax year or reconstruct a trust account for a bar audit. Import each account separately and reconcile month by month.

Does QuickBooks work for law firms?

Yes. QuickBooks handles a firm's operating books, expenses, payroll, and, with careful setup, IOLTA trust accounting. Use classes to track matters and clients, keep trust funds in a separate liability, and reconcile the trust account on its own. Firms with heavy billing needs often pair it with legal practice software, but the accounting foundation runs in QuickBooks.