A financial services firm writes a commercial auto policy this month and earns a $630 commission the moment the policy funds — 15 percent of a $4,200 annual premium, paid by the carrier as soon as the policy binds, not when it was quoted two weeks earlier. Eight months ago, the same firm wrote a $3,600 general liability policy for a different client and earned a $540 commission on that one too, deposited and spent months ago. This month, that older client stops paying and the policy lapses, still inside the carrier's one-year chargeback window, and the carrier deducts the entire $540 from the firm's next commission check. In a generic QuickBooks chart, both commissions landed in the same "Service Income" line the day they arrived, with nothing built to hold the second one apart once it became money the firm might have to give back.
The same firm also holds a $38,000 premium payment in its own bank account for eleven days before forwarding it to the carrier — money that was never the firm's to spend no matter which account it sits in — and carries $620,000 of loans on its books with no reserve for the piece it doesn't expect to collect. A chart built for a business that sells one thing at one price can't tell a commission that's safe from one that's still at risk, a client's money from the firm's own revenue, or a loan portfolio's face value from what it's actually worth. This guide covers the accounts that keep all four of those distinctions visible.
Why a generic chart breaks down for a financial services firm
The default QuickBooks chart has one income account for a service business, fine for a firm that earns one kind of dollar. A financial services firm usually earns several: recurring advisory fees, one-time commissions, and, if it lends, interest income on the spread between what it charges a borrower and what it pays for its own capital. These aren't variations on the same revenue — commissions are transactional and lumpy, advisory fees recur, and interest income carries risks neither does. Blended into one "Service Income" line, a strong commission month can make a shrinking advisory book look healthy, and a new lender can't tell how much of its growth is a new revenue stream versus the same clients paying more.
Commission income compounds the problem because it isn't final the day it's booked. A carrier's producer contract typically allows a full or partial chargeback if a policy lapses within its first year, and a lender's origination fee can carry a similar clawback if a loan doesn't close. Recognizing the commission when the policy funds is right — the revenue is genuinely earned then — but a chart with no account to hold a reversed commission either leaves stale revenue on the books, or unwinds it as a mystery adjustment with no liability tracking what's owed back.
A third distortion comes from money the firm holds but doesn't own. An agency that collects a client's premium before forwarding it to the carrier isn't earning that money — it's holding it in a fiduciary capacity, the same discipline a law firm's trust account keeps for a client retainer. Run that premium through the firm's own cash and revenue accounts, even briefly, and the books can no longer prove client money and firm money never mixed, the first thing an examiner checks.
A fourth distortion hits any firm that lends. A generic chart carries a loan the way it carries a receivable: one asset account, at face value, with no adjustment for the share of any loan portfolio that won't be collected. Under GAAP (Generally Accepted Accounting Principles), a lender has to estimate that shortfall and carry a reserve against it, distinct from a general allowance for doubtful trade receivables, because a loan's credit risk and an invoice's collection risk are different problems. A $620,000 loan book with no reserve implies the firm expects to collect every dollar of it — not a forecast, an omission.
How a commission, a client's money, and a loan-loss reserve move through the accounts
The accounts that do the work
These are the accounts from the finance & financial services template that a generic chart does not give an insurance agency, advisory practice, or lender. Account numbers, names and types below are exactly as they import.
| Row | Account | Number | Type | Purpose |
|---|---|---|---|---|
| 01 | Accounts Receivable | 1200 | Accounts Receivable | Fees and commissions receivable from clients |
| 02 | Loans Receivable | 1210 | Accounts Receivable | Loans issued to customers |
| 03 | Allowance for Loan Losses | 1290 | Accounts Receivable | Reserve for potential loan defaults |
| 04 | Client Funds Held in Trust | 1300 | Other Current Assets | Client funds held in fiduciary capacity |
| 05 | Client Funds Payable | 2220 | Other Current Liabilities | Client funds held in trust - liability side |
| 06 | Policy Reserves | 2230 | Other Current Liabilities | Insurance policy reserves and claims liability |
| 07 | Commissions Payable | 2240 | Other Current Liabilities | Commissions owed to agents and brokers |
| 08 | Deferred Revenue | 2250 | Other Current Liabilities | Advance fees received for future services |
| 09 | Investment Advisory Fees | 4000 | Income | Fees for investment management and advisory services |
| 10 | Commission Revenue | 4100 | Income | Commissions from insurance and investment product sales |
| 11 | Premium Revenue | 4200 | Income | Insurance premium income |
| 12 | Interest Income on Loans | 4700 | Other Income | Interest earned on loans to customers |
| 13 | Client Acquisition Costs | 5000 | Cost of Goods Sold | Direct costs to acquire new clients (marketing, referral fees) |
| 14 | Direct Underwriting Costs | 5100 | Cost of Goods Sold | Direct costs for underwriting insurance policies |
| 15 | Commissions Paid - Direct | 5300 | Cost of Goods Sold | Sales commissions directly tied to revenue generation |
Commission Revenue and Investment Advisory Fees sit apart because a sold policy and a managed relationship are different businesses that happen to send money to the same firm. Commissions Payable is what lets an already-recognized commission come back out cleanly when a carrier claws it back, instead of a plain revenue reversal with no liability showing what's owed. Client Funds Held in Trust and Client Funds Payable clear together and never touch Commission Revenue or Investment Advisory Fees, so a premium in transit can never look like the firm's own income. Loans Receivable and Allowance for Loan Losses share the same QuickBooks account type as Accounts Receivable — the closest canonical type QuickBooks Online offers for money owed to the business — but they're separate account numbers, because a client's unpaid invoice and a loan the firm expects to collect over years carry entirely different risk.
How the accounts get booked
Follow one new policy's commission, one older policy's chargeback, and the firm's first loan-loss reserve through the accounts that hold them apart. Figures are illustrative throughout.
A commercial auto policy funds this month with a $4,200 annual premium. The carrier pays a 15 percent first-year commission directly to the agency, now that the policy is bound and paid for.
| Account | Debit | Credit |
|---|---|---|
| 1200Accounts Receivable | 630 | |
| 4100Commission Revenue | 630 | |
| Totals | 630 | 630 |
The commission posts the day the $4,200 policy actually funds, not the day it was quoted two weeks earlier, and it lands in Commission Revenue rather than Investment Advisory Fees or Interest Income on Loans — three accounts that would blend into one number on a chart built for a firm that only sells one kind of dollar.
A different policy, a $3,600 general liability policy written eight months ago, lapses this month after the client stops paying premiums — still inside the carrier's one-year full-chargeback window.
| Account | Debit | Credit |
|---|---|---|
| 4100Commission Revenue | 540 | |
| 2240Commissions Payable | 540 | |
| Totals | 540 | 540 |
This $540 commission funded and was paid out eight months ago. The carrier now deducts the entire amount from the firm's next commission check. Commissions Payable holds what's owed back until that deduction clears — the same account a chart would use for money owed to a sub-producer, put to work here for money owed back to the carrier, because both are a liability tied to a specific commission.
At month end, the firm reviews its loan portfolio: $620,000 in Loans Receivable, with no reserve booked against it yet.
| Account | Debit | Credit |
|---|---|---|
| 4700Interest Income on Loans | 9,300 | |
| 1290Allowance for Loan Losses | 9,300 | |
| Totals | 9,300 | 9,300 |
Based on the default rate across similar loans, management estimates 1.5 percent of the $620,000 portfolio — $9,300 — will not be collected, and books that estimate now rather than waiting for a specific loan to actually default. The conventional treatment runs that estimate through a dedicated loan-loss provision expense account before it reaches the balance sheet. This chart has no such account, so the offset lands directly against Interest Income on Loans instead — a real gap in the account list, not the textbook answer. Either way, the loan book's carrying value now reflects what the firm actually expects to collect instead of its face value.
What this looks like on the statements
The same accounts, seen from the reports, across a full month of the firm's policies, advisory clients, and loans rather than the three entries above.
| Investment Advisory Fees | 42,000 |
| Commission Revenue | 18,375 |
| Interest Income on Loans | 9,600 |
| Total revenue | 69,975 |
| Direct acquisition and underwriting costs | |
| Commissions Paid - Direct | 4,200 |
| Direct Underwriting Costs | 1,850 |
| Client Acquisition Costs | 2,600 |
| Total direct costs | 8,650 |
| Gross margin | 61,325 |
| Salaries & Wages | 24,000 |
| Compliance & Regulatory Fees | 2,000 |
| Net income | 35,325 |
Example figures.
Commission Revenue nets to $18,375 this month only because it already absorbed the $540 chargeback from Entry 2 — a separate policy's commission earned fresh this month sits in the same number as if nothing were ever at risk. Interest Income on Loans nets to $9,600 only because it absorbed the $9,300 first-time reserve build from Entry 3; a normal month, once the reserve exists, will show a smaller provision against a larger gross number. Gross margin, at $61,325, is visible only because Commissions Paid - Direct, Direct Underwriting Costs, and Client Acquisition Costs all sit apart from Salaries & Wages and Compliance & Regulatory Fees below it.
| Current assets | |
| Accounts Receivable | 630 |
| Client Funds Held in Trust | 38,000 |
| Loans Receivable | 620,000 |
| Allowance for Loan Losses | (9,300) |
| Current liabilities | |
| Client Funds Payable | 38,000 |
| Commissions Payable | 540 |
Example figures.
Client Funds Held in Trust and Client Funds Payable both carry $38,000 — the same premium, on its way from the client to the carrier, showing up on both sides of the balance sheet and neither side of the income statement. Allowance for Loan Losses shows $(9,300) against $620,000 of Loans Receivable, so the loan book's real carrying value is $610,700, not $620,000 — a number no chart with one blended "Loans" account could show. A lender reading Loans Receivable alone, with no allowance sitting next to it, would have no way to tell the difference between a healthy portfolio and one already carrying $9,300 of expected losses.
- 01Is a commission actually safe, or just written? Booking a commission the day a policy funds is correct, but a chart with no clawback account treats every commission as final the moment it lands, when a chargeback window can still take part of it back for up to a year.
- 02Is this fee income or spread income, and does blending them hide which one is disappearing? A client relationship, a single transaction, and a spread on borrowed capital are three different things, and a generic 'Service Income' line can show steady total revenue while any one of the three is actually shrinking.
- 03Is the client's money the firm's money? A premium or loan proceeds passing through the firm's own bank account, even briefly, is not revenue and isn't available to spend. Run it through operating cash instead of a trust pair, and the books can no longer prove the two never mixed.
- 04Is the loan book worth its face value, or something less? A loan portfolio carried with no allowance implies the firm expects to collect every dollar of it, which for a real portfolio isn't a forecast — it's an account that was never opened.
What the template changes
The diff, in the grammar the product uses everywhere else.
- Service Incomeadvisory fees, commissions, and interest income blended into one line
- 4000Investment Advisory Feesincome
- 4100Commission Revenueincome
- 4700Interest Income on Loansother income
- no account for a commission that can be taken backa clawback had nowhere to post but a plain revenue reversal with no liability tracking what is owed
- 2240Commissions Payableliability
- client funds run through the firm's own bank and revenue accountsa premium in transit looked like the firm's own cash, and briefly, its own income
- 1300Client Funds Held in Trustasset
- 2220Client Funds Payableliability
- Loansloan book carried at face value with no reserve for what will not be collected
- 1210Loans Receivableasset
- 1290Allowance for Loan Lossescontra-asset
- 5300Commissions Paid - Directstays a direct cost, matched against the revenue it produced, not overhead
- Publication 535, Business Expenses · Internal Revenue Service
- Principles of Accounting, Volume 1: Financial Accounting · OpenStax, Rice University
Get started
The finance and financial services chart of accounts template includes every account on this page, pre-numbered and ready to import into QuickBooks. It takes about 60 seconds to optimize and gives a financial services owner a P&L that shows fee income apart from spread income, a commission's clawback risk apart from money already spent, and a loan book that's worth what it can actually collect instead of its face value.
If you already have a chart, the optimizer reads it and shows the diff above against your own accounts, so you can see which of these are missing before you change anything. Book a commission when it funds instead of when it's written, keep a client's money out of your own revenue, and reserve for the piece of the loan book that will not come back, and next month's P&L comes from the trial balance instead of a spreadsheet rebuilt after the carrier's next statement arrives.
Frequently asked questions.
Why can't a financial services firm just book every fee and commission to one 'Service Income' line?
Because advisory fees, commissions, and interest income are different businesses that happen to land in the same bank account. Advisory fees are recurring and predictable, commissions are transactional and lumpy, and interest income depends on credit and funding risk that has nothing to do with either. Blending them into one line hides which revenue stream is actually growing and which one a strong month is quietly covering for.
If a commission is already paid, how can it get taken back?
Most producer contracts give the carrier the right to charge back some or all of a first-year commission if the policy lapses within a set window, often a full year. The commission was genuinely earned when the policy funded, but earned isn't the same as permanent — the chargeback right survives until the window closes, and a chart with no liability account to hold that risk finds out about it only when a deduction shows up on the next commission statement.
Is a client's premium payment the firm's own revenue the moment it's deposited?
No. Money the firm holds on its way to a carrier, a custodian, or a brokerage account is held in a fiduciary capacity, not earned, and it's never available to spend on the firm's own expenses. It belongs in a trust asset account matched by an equal liability, never in the same bank account or revenue line the firm's own fees and commissions run through.
The principles are easy. Applying them is the work.
This guide is the theory. The free trial helps you review a real QuickBooks Online chart with a score, structural diff, and prioritized cleanup plan.
- +Score the chart across the health dimensions
- +Compare structure against a reference pattern
- +Prioritize cleanup work before changing books
- +Review recommendations before anything is applied