Bank Statement to QuickBooks for Insurance Agencies: Convert PDF Statements to QBO

Every accounting decision in an agency traces back to how a policy was billed. Under direct bill, the carrier bills the insured, collects the premium, and later pays the agency a commission, usually as one monthly ACH covering many policies. Only that commission is agency revenue. You never touch the premium, so it never appears in your books as income.

Under agency bill, the agency collects the full premium from the insured, keeps its commission, and remits the balance (the net premium) to the carrier. The premium you collect on the carrier's behalf is not your income. It is fiduciary money you owe the carrier. Booking a gross agency-bill deposit as revenue can overstate income by many multiples, because the commission might be a small slice of a large premium. When you review converted transactions, the first question for any deposit from an insured is: agency bill or direct bill?

Many states require agency-bill premiums to be held in a separate premium trust account and prohibit commingling those funds with operating money. The clean way to model this in QuickBooks is a dedicated bank account for the trust, paired with an offsetting premiums payable to carriers liability. When a premium lands in the trust account, cash goes up and the liability goes up by the same amount. When you remit to the carrier, both come down. Each month, reconcile that the trust balance covers the payable.

Trust account rules are state-specific. Confirm the exact requirements with your state department of insurance, since some states set minimum balances, separate-account rules, and audit expectations. The structure parallels how law firms handle client money, and the mechanics we describe for QuickBooks IOLTA trust accounting and for law firm trust bookkeeping map closely to a premium trust account.

That single monthly ACH from a carrier is a summary of hundreds of policy-level commissions, chargebacks for cancellations and mid-term endorsements, and sometimes a bonus. If you book the net deposit as one revenue line, you can never audit whether the carrier actually paid you what each policy earned. At minimum, reconcile the deposit against the carrier's commission statement. Better, split the deposit so earned commission, chargebacks, and any bonus sit on separate lines. A QuickBooks clearing account helps when the deposit date and the statement detail do not line up neatly.

Carriers pay contingent or profit-sharing commissions annually, based on your loss ratio and volume with them. They are uncertain until the carrier declares them, which means recognizing them early creates a swing when the actual number differs. Treat them conservatively, book them when they are reasonably certain rather than when you hope for them, and confirm the revenue recognition question with your CPA. On the bank statement a contingent payment often looks like any other carrier ACH, so tag it deliberately rather than lumping it with regular commission.

When a policy cancels mid-term, the carrier claws back the unearned commission. This usually shows up as a reduction inside a later commission deposit, and occasionally as its own debit on the statement. Track a commission chargeback contra-revenue account so the reversal is visible and so you can adjust the producer's share too. If you paid a producer on a policy that later canceled, the return commission flows through to their compensation. Netting chargebacks silently into a single revenue figure hides both the carrier reversal and the producer adjustment.

Producers are typically paid a split of the commission the agency earns, often on a schedule that lags the carrier deposit. Model producer commission payable as a liability that accrues when the commission is earned, not when the check is cut. That keeps the expense in the right period and shows what you owe at any point. Some producers are W-2 employees and some are 1099 contractors, and the two are reported differently at year end. If you need the current 1099 reporting threshold, confirm it with your CPA rather than relying on an old figure. Our companion piece on recording commission income in QuickBooks walks through the producer accrual in more detail.

A handful of expense categories show up on the bank and card statements of nearly every agency: errors and omissions (E&O) insurance premiums, agency management system subscriptions (Applied Epic, AMS360, EZLynx, HawkSoft), carrier appointment fees, producer licensing and continuing education, and lead costs. Keep lead spend in its own account so you can compute cost per bound policy and judge which lead sources actually pay off. Card processing fees on premiums paid by card are a common line too; see how to record credit card processing fees in QuickBooks so the gross premium and the fee are both captured.

Acquiring another agency's book is a capital transaction, not an expense. The purchase price is an intangible asset that gets amortized over time, and if you financed it with a seller note, each note payment splits into principal (which reduces the note balance) and interest (which is an expense). Booking the whole payment as an expense misstates both your assets and your profit. Confirm the treatment with a CPA before you record the first payment, since the amortization period and any tax elections depend on the deal.

Commercial lines, personal lines, and benefits behave like separate businesses inside one agency. Tag commission income and direct costs with QuickBooks classes (or locations) so you can pull a profit view for each. Once the converted transactions are in, a few minutes of classing turns a flat ledger into something that tells you where the agency actually makes money.

How do I record insurance commission income in QuickBooks?

Record commission as income when it is earned, not the gross premium. For direct bill, the carrier's monthly ACH is your revenue; book it to a commission income account and reconcile it against the carrier's commission statement. For agency bill, only your retained commission is income, and the collected premium is a liability you owe the carrier.

What is the difference between direct bill and agency bill?

Under direct bill, the carrier bills the insured, collects the premium, and pays you a commission, so only the commission is your revenue. Under agency bill, you collect the full premium from the insured, keep your commission, and remit the rest to the carrier. That collected premium is fiduciary money, not income.

How do I set up a premium trust account in QuickBooks?

Create a separate bank account for the trust and a premiums payable to carriers liability account. When premiums arrive, increase both; when you remit to the carrier, decrease both. Reconcile monthly that the trust balance covers the payable. Trust rules are state-specific, so confirm requirements with your state department of insurance.

How do I record a commission chargeback?

Post the clawback to a commission chargeback contra-revenue account so it reduces gross commission without hiding the reversal. When it appears as a reduction inside a later carrier deposit, split that deposit to show earned commission and the chargeback separately. Adjust the affected producer's commission payable too, since their split reverses as well.

What chart of accounts should an insurance agency use?

Include commission income (by line if useful), contingent commission income, a commission chargeback contra-revenue account, a premium trust bank account, a premiums payable to carriers liability, and producer commission payable. On the expense side, add E&O, agency management software, licensing and continuing education, and a separate lead generation account. An accountant can tailor it.

How do I import a bank statement into QuickBooks?