QuickBooks

How to Reconcile an IOLTA Account in QuickBooks When You Have Wire Fees and Interest

Key Takeaways:

• Wire fees and interest can throw off your IOLTA reconciliation in QuickBooks, but with proper setup and specific steps, you can maintain compliant three-way reconciliation every month

• Creating separate subaccounts for firm funds and interest income prevents the most common reconciliation errors and protects against inadvertently using client funds for bank charges

• While QuickBooks requires manual workarounds for IOLTA compliance, following a systematic process and considering legal-specific integrations can reduce reconciliation time from hours to minutes

It’s the end of the month, and you’re staring at your IOLTA bank statement. The numbers don’t match your QuickBooks balance—again. There’s a $25 wire fee here, $50 in interest there, and somehow your three-way reconciliation is off by $73.42. Sound familiar?

If you’re like most mid-sized law firms using QuickBooks for trust accounting, reconciling your IOLTA account when wire fees and interest are involved feels like solving a Rubik’s Cube blindfolded. One wrong move, and you’ve inadvertently commingled funds or created a compliance nightmare.

Here’s the harsh reality: Mishandling IOLTA accounts remains one of the leading causes of attorney discipline. And when wire fees and interest enter the equation, the complexity multiplies. QuickBooks, while excellent for general accounting, wasn’t designed with the intricate requirements of legal trust accounting in mind.

But don’t panic. With the right setup, clear procedures, and a systematic approach, you can master IOLTA reconciliation in QuickBooks—even with those pesky wire fees and interest payments. This guide will walk you through every step, from initial setup to monthly reconciliation, ensuring you stay compliant and audit-ready.

The Three-Way Reconciliation Challenge

Before diving into wire fees and interest, let’s clarify what makes IOLTA reconciliation unique. Unlike regular business accounts, IOLTA accounts require three-way reconciliation:

Bank Statement Balance: What your bank says you have
Trust Account Ledger: Your QuickBooks IOLTA account balance
Individual Client Ledgers: The sum of all client trust balances

All three must match perfectly. Not close—perfectly. Even a penny discrepancy can trigger bar discipline.

Now add wire fees and interest to the mix. Wire fees must be paid from firm funds, never client money. Interest belongs to your state IOLTA program, not to you or your clients. Get either wrong, and you’ve violated fundamental trust accounting rules.

Why QuickBooks Makes This Complicated

QuickBooks wasn’t built for lawyers. It doesn’t understand that:

Client funds are sacred and cannot pay bank fees
Wire fees are your firm’s responsibility, even when processing client transactions
Interest must be tracked separately and forwarded to IOLTA
Every transaction needs a clear audit trail linking to specific clients

Without proper setup and procedures, QuickBooks will happily let you:

Deduct wire fees from client funds (ethics violation)
Lose track of which client owns which dollars (commingling)
Create negative client balances (misappropriation)
Fail to properly account for interest (compliance failure)

Setting Up QuickBooks for Success

Proper setup is 80% of the battle. Here’s the structure you need:

Essential Accounts Structure

1. IOLTA Bank Account (Asset)

Account Type: Bank
Detail Type: Trust account
Name: “IOLTA Trust Account – [Bank Name]”

2. Client Trust Liability (Other Current Liability)

Account Type: Other Current Liabilities
Detail Type: Trust Accounts – Liabilities
Name: “Funds Held in Trust”

3. Individual Client Subaccounts Under “Funds Held in Trust,” create subaccounts for:

Each client (e.g., “Trust: Smith, John – Matter #1234”)
Firm Funds (critical for wire fees)
IOLTA Interest Income

The Firm Funds Subaccount: Your Secret Weapon

This is where many firms go wrong. You MUST maintain a “Firm Funds” subaccount within your trust liability structure. Why? Because banks will charge fees against your IOLTA account, and those fees cannot come from client money.

Setting it up:

Right-click on “Funds Held in Trust”
Select “New” to create a subaccount
Name it “[Firm Name] Funds”
Keep the same account type settings

Best practice: Maintain a small cushion (typically $100-500) to cover monthly fees, wire charges, and other bank costs.

The Monthly Reconciliation Process

Now for the main event: reconciling when wire fees and interest are involved.

Step 1: Pre-Reconciliation Preparation

Before opening QuickBooks:

Review your bank statement for all wire fees
Note the interest earned amount
Identify any unusual charges or fees
Gather documentation for all wire transfers

Step 2: Begin Reconciliation in QuickBooks

Navigate to Banking > Reconcile and select your IOLTA account:

Enter the statement ending date
Verify the beginning balance matches
Critical: Don’t enter service charges or interest yet

Step 3: Handle Interest Correctly

In the reconciliation window:

In “Interest Earned” field: Enter the interest amount
In the account dropdown: Select “Funds Held in Trust: IOLTA Interest Income”
This credits the interest to the proper subaccount

Important: Interest is NOT your money or your client’s money. It belongs to your state IOLTA program.

Step 4: Process Wire Fees and Bank Charges

This is where most errors occur:

In “Service Charge” field: Enter total bank fees
In the account dropdown: Select “Funds Held in Trust: [Firm] Funds”
This ensures fees are charged against firm funds, not client funds

Never select a client subaccount for fees. This would illegally use client funds for firm expenses.

Step 5: Match Transactions

Work through each transaction:

Verify all deposits are linked to correct client subaccounts
Confirm all checks/withdrawals have proper client attribution
Check that wire transfers show both the transfer and associated fee

Step 6: Complete the Three-Way Reconciliation

After QuickBooks shows “Difference = 0.00”:

First Check – Bank to Ledger:

Reconciled bank balance: $_____
QuickBooks IOLTA account balance: $_____
These must match exactly

Second Check – Ledger to Client Total: Run a Balance Sheet Detail report filtered for “Funds Held in Trust”:

Total of all client subaccounts: $_____
Firm funds subaccount: $_____
Interest subaccount: $_____
Total must equal IOLTA bank account balance

Third Check – Individual Client Verification: For each client with activity:

Beginning balance + Deposits – Withdrawals = Ending balance
No client should ever show negative

Handling Common Wire Fee Scenarios

Let’s walk through real-world examples:

Scenario 1: Incoming Wire with Fee Deducted

Client wires $50,000 for retainer, but bank deducts $25 fee, depositing $49,975.

Correct handling:

Record deposit of $49,975 to client’s trust subaccount
Record separate expense of $25 from Firm Funds subaccount
Consider billing client for wire fee as a cost (from operating account)

Why this matters: The client entrusted you with $50,000. The bank fee is your cost of doing business, not theirs.

Scenario 2: Outgoing Wire Transfer

Sending $100,000 settlement to client, bank charges $30 wire fee.

Correct handling:

Record wire transfer of $100,000 from client’s subaccount
Record wire fee of $30 from Firm Funds subaccount
Ensure total bank deduction is $100,030

Common mistake: Recording $99,970 to client (deducting fee from their funds).

Scenario 3: International Wire with Multiple Fees

Complex international transaction with originating and receiving fees.

Best practice:

Document all fees clearly
Pay all fees from Firm Funds
Consider separate client authorization for reimbursement
Maintain detailed memo records

Red Flags That Scream “Audit Risk”

Watch for these danger signs:

1. Negative Client Balances Even temporarily, this indicates you’ve spent money that isn’t yours.

2. Missing Firm Funds Cushion Without funds to cover fees, you’ll be forced to use client money.

3. Unreconciled Interest Accumulated interest sitting in your IOLTA account raises questions.

4. Pattern of Corrections Frequent adjusting entries suggest systemic problems.

5. Delayed Reconciliations Monthly means monthly, not “when you get around to it.”

Best Practices for Long-Term Success

Create a Monthly Checklist

[ ] Print bank statement immediately after month-end
[ ] Review all wire transactions and fees
[ ] Verify Firm Funds balance covers anticipated charges
[ ] Complete reconciliation within 5 business days
[ ] Run three-way reconciliation reports
[ ] File all documentation properly
[ ] Transfer interest to IOLTA program (per state requirements)

Documentation Standards

For each wire transaction, maintain:

Wire transfer confirmation
Client authorization (if applicable)
Fee documentation
Reconciliation notes explaining any adjustments

Know Your State Requirements

Requirements vary significantly:

Some states require interest remittance monthly
Others accumulate quarterly
Fee handling rules differ
Consult your state bar’s IOLTA guidelines

When QuickBooks Isn’t Enough

Let’s be honest: Managing IOLTA reconciliation in QuickBooks requires significant manual effort. For growing firms, consider:

Legal-Specific Software Benefits:

Automated three-way reconciliation
Built-in wire fee handling
Interest tracking and reporting
Audit-ready compliance reports
Real-time balance verification

Tools like LeanLaw integrate with QuickBooks Online, adding:

One-click reconciliation
Automatic fee segregation
Client-level reporting
Compliance alerts
Simplified wire processing

The investment often pays for itself in time saved and risk reduced.

Your Action Plan

Starting today:

Immediate Steps:

Create Firm Funds subaccount if missing
Deposit funds to cover 3 months of fees
Set up IOLTA Interest Income subaccount
Document your wire fee procedures

This Month:

Complete a full three-way reconciliation
Clean up any existing discrepancies
Create your monthly checklist
Train all staff on procedures

Ongoing Excellence:

Reconcile within 5 days of month-end
Review and adjust Firm Funds quarterly
Conduct internal audits semi-annually
Stay current with rule changes

The Peace of Mind Factor

IOLTA reconciliation with wire fees and interest doesn’t have to be a monthly nightmare. With proper setup, clear procedures, and consistent execution, it becomes routine. More importantly, you’ll sleep better knowing you’re protecting client funds and your license.

Remember: Every wire fee paid from client funds, every interest payment mishandled, every reconciliation skipped increases your risk exponentially. But every month you properly reconcile, document, and maintain compliance builds your reputation as a trustworthy fiduciary.

The state bar isn’t looking to trap you—they want client funds protected. When your QuickBooks IOLTA reconciliation properly handles wire fees and interest, you’re not just following rules. You’re demonstrating the professionalism that clients expect and deserve.

Don’t let another month pass with questionable reconciliation. Start implementing these procedures today. Your clients, your firm, and your professional standing depend on it.

FAQ Section

Q: Can I deduct wire fees from a client’s trust funds if they authorized it? A: No. Wire fees are business expenses that must be paid from firm funds, never from client trust money. You can seek reimbursement by billing the client separately through your operating account, but you cannot directly deduct fees from their trust funds. This is true even with written authorization—ethics rules prohibit using client funds for bank charges.

Q: What if I don’t have enough in my Firm Funds subaccount to cover a wire fee? A: You must immediately transfer money from your operating account to cover the shortage. Never allow bank fees to be deducted from client funds. Best practice is maintaining a cushion of $100-500 in your Firm Funds subaccount. If fees exceed this, increase your cushion or transfer funds before initiating wires.

Q: How do I handle interest if my state requires quarterly remittance instead of monthly? A: Continue recording interest monthly in your IOLTA Interest Income subaccount during reconciliation. This maintains accurate records and prevents the interest from being confused with client funds. When it’s time for quarterly remittance, you’ll have a clear total to transfer. The key is keeping interest segregated at all times.

Q: My bank statement shows a “wire reversal” – how do I handle this in reconciliation? A: Treat a wire reversal as two separate transactions: First, record the original outgoing wire as normal. Then, record the reversal as a deposit back to the same client’s subaccount. Document thoroughly why the reversal occurred. If fees were charged for both transactions, handle each fee separately from your Firm Funds subaccount.

Q: What reports should I save after reconciliation for potential state bar audits? A: Save these reports monthly: (1) Bank reconciliation report from QuickBooks, (2) Balance Sheet Detail filtered for trust accounts, (3) Transaction List by Customer showing all trust activity, (4) Bank statement, (5) Three-way reconciliation worksheet. Keep these for at least 5-7 years per your state’s requirements. Consider digital storage with proper backups.

Q: Is it worth upgrading to legal-specific software if I only have 20-30 trust transactions monthly? A: Calculate your time investment: If reconciliation takes 3-4 hours monthly, that’s 36-48 hours annually. At typical attorney rates, the cost of manual reconciliation often exceeds software costs. Additionally, consider risk reduction—automated systems prevent errors that could lead to bar discipline. For firms with even moderate trust activity, the investment typically pays for itself.

Resources and References

State IOLTA Programs:

IOLTA National Resources
ABA Model Rules on Trust Accounting
Individual state bar IOLTA guidelines

LeanLaw Resources:

QuickBooks Resources:

Professional Support:

About LeanLaw

LeanLaw helps law firms simplify billing, trust accounting, and financial reporting—without changing how attorneys work. Built specifically for legal teams, LeanLaw integrates seamlessly with QuickBooks to give you clarity, compliance, and control.

Product Capabilities

Solutions

Resources

About