All resources

Insurance Agency Accounting

Why Insurance Agency Balance Sheets Don’t Reconcile

When an agency owner says the balance sheet doesn’t reconcile, they usually mean one of four things: the bank doesn’t agree with the books, the detail reports don’t agree with the general ledger, the cash held for insurers and insureds doesn’t cover what is owed to them, or a balance agrees on paper but nobody can explain what is in it. Each has different causes and a different fix, and they often appear together.

Four kinds of “doesn’t reconcile”

Four kinds of reconciliation problem
SymptomWhat it comparesTypical first question
Bank doesn’t agreeBank statement to the cash account in the ledgerAre all reconciling items supported and current?
Detail doesn’t agreeReceivable, payable, or commission detail to its ledger control accountWere both run for the same date, scope, and posting status?
Fiduciary position doesn’t holdFiduciary cash to premiums payable and return premiums dueIs fiduciary cash being used for agency expenses, or is commission sitting untransferred?
Balance can’t be explainedA reconciled balance to its supporting detailWhat are the items, how old are they, and who owns them?

Start with the bank. Reconciliations that rely on an unreliable cash balance tend to move the problem rather than solve it.

1. The detail and the general ledger disagree

Agency accounting usually runs through detail-level records (receivables by invoice, payables by carrier, commissions by policy) that roll up to control accounts in the general ledger. When the detail and the control account disagree, the cause is usually one of these:

  • Entries posted directly to a control account. A manual journal entry that corrects a balance in the ledger, without a matching transaction in the detail, creates a permanent difference. Whether a system allows this depends on the software and how it is configured.
  • Reports run at different times or with different parameters. A detail report run before the last activity was posted, or filtered to one agency code or entity, will not agree with a ledger balance that includes everything.
  • Cutoff. Activity dated in one period but entered after the period was reported can make two reports for the “same” month disagree.
  • Conversion or migration leftovers. Opening balances brought over from a previous system may not have carried full detail.

The first step is always to confirm that both sides cover the same date, entities, agency codes, and posting status. Many apparent differences disappear at that point; the rest become easier to explain.

2. Fiduciary cash doesn’t support what the agency owes

Agency Bill premium collected on behalf of insurers, and return premium owed to insureds, are generally not the agency’s money. State rules on how producers must hold these funds vary.

New Jersey requirement N.J.A.C. 11:17C requires premium funds to be held in a fiduciary capacity and segregated from the producer’s own funds (11:17C-2.1), requires a designated trust account in most situations where collected premiums are deposited (11:17C-2.3(a)), and requires the trust balance to be at all times at least equal to deposits less the lawful withdrawals the rules list (11:17C-2.3(g) and (i)). This is a summary, not legal advice.

From an accounting standpoint, the fiduciary cash should be able to cover the fiduciary obligations. Common reasons it appears not to:

  • Commission not yet transferred. The agency’s earned commission is still sitting in the trust account. That inflates the account against obligations, and it is often transferred in round amounts with no record of which premiums it relates to. In New Jersey, commission may be withdrawn only on premiums deposited into the trust account (11:17C-2.3(g)5), so a documented, premium-level basis for each transfer matters.
  • Agency expenses paid from trust funds. Even briefly, this reduces the cash available for insurers and insureds. In New Jersey, operating expenses are not among the lawful trust withdrawals (11:17C-2.3(g)).
  • Premium remitted before it was collected. Paying an insurer ahead of the customer’s payment uses other insureds’ premium funds to cover the gap, unless the agency has covered the advance with its own funds.
  • Return premiums not recorded as owed. These are covered in the next section.

Recommended practice Many agencies use a trust ratio to monitor this position. Formulas differ between practitioners, but the idea is to compare fiduciary cash and collectible premium receivables with premiums payable to insurers. A ratio below 1.0 is a warning sign; a ratio above it does not prove that every policy-level balance is correct, so treat it as an indicator that prompts review.

3. Return premiums hide inside receivables

When a policy is cancelled or reduced, the insured may be owed a return premium. If it is recorded as a credit on the customer’s receivable, it reduces the receivable total. The total looks smaller and healthier, while a liability to the insured is netted away.

Illustrative Example | Fictional Data The agency, figures and events below are fictional and are included only to illustrate the method.

Harbor & Pine Insurance Agency (fictional) reports Agency Bill receivables of $96,200. The aged detail shows $102,000 of amounts due from customers and $5,800 of credit balances on accounts whose policies were cancelled or reduced. Those credits may be return premiums the agency owes. The net receivable is arithmetically correct, but it understates both what customers owe and what the agency may owe them.

Review credit balances as their own list, every month. Each credit may be a refund due, an unapplied payment, or a posting error; identify which before anything is refunded or reclassified, then resolve it accordingly.

New Jersey requirement Return premium due an insured must be paid or credited within five business days after the producer receives it. A credit balance held on the insured’s account requires monthly written notice to the insured (11:17C-2.2(b)).

Recommended practice For financial statements, present material credit balances that are amounts owed to insureds as a liability rather than netting them against receivables.

4. Unapplied cash and suspense accounts

A receipt that cannot be matched to an invoice or a carrier statement often lands in an unapplied cash or suspense account. That is reasonable for days, not months. Over time these accounts collect partial payments, duplicate receipts, payments for policies not yet invoiced, and amounts nobody has researched. They then hide differences elsewhere on the balance sheet: the receivable looks overdue while the cash that pays it sits unapplied.

Each item in suspense needs an amount, a date, a source, and an owner responsible for applying or researching it. A suspense balance that only grows is a process problem as much as an accounting one.

5. Commission timing and the accounting basis

Commission accounts are a frequent source of confusion because the right answer depends on the agency’s accounting basis.

  • Cash basis (and many income-tax-basis presentations): commission is generally recorded when received, and chargebacks reduce commission income when deducted. On a pure cash basis, a Direct Bill commission receivable shouldn’t normally appear on the balance sheet at all.
  • Accrual-basis books that do not follow full GAAP: practice varies. Commission may be accrued when billed or when the carrier statement arrives; the policy should be written down and applied consistently.
  • GAAP (ASC 606): commission is generally recognized when placement is complete, typically at the policy effective date, including commission expected on installment billing and reduced by an estimate of commission expected to be reversed through cancellations. A receivable (or contract asset) represents commission earned but not yet paid by the insurer. Contingent or profit-sharing commissions are estimated and recognized only to the extent it is probable that a significant reversal will not occur.

Problems arise when the basis is applied inconsistently: accruing some insurers and not others, or recording an accrual without reversing it when the cash arrives. The result is a receivable that grows each month, or one that turns negative. If the agency accrues commission, the receivable should be reconciled to the carrier activity it represents, and estimates should be documented and reviewed. Which basis, and which estimates, are appropriate depend on the agency’s circumstances, the users of its financial statements, and the advice of its tax and assurance advisers.

6. Producer commissions payable

Producer and broker commission payable balances should agree with the calculation detail: earned, less paid, plus or minus approved adjustments. Differences commonly come from payments made outside the normal run, adjustments agreed informally but never recorded, and chargebacks on cancelled policies that were applied to the agency’s commission but not to the producer’s share. Each needs a decision under the producer agreement, not just an entry. See Producer Commissions: Splits, Chargebacks and Controls.

7. Old items and prior-period entries

A reconciliation can agree to the penny and still be wrong if it agrees only because old reconciling items roll forward each month. Prior-period entries make this worse: a correction posted into a closed month after the reports were issued changes the starting point without anyone reviewing it.

Age every reconciling item. Items that should have cleared need research and escalation. Old items should be cleared only with support and an approved decision, not because they are old.

A worked example: premiums payable

Illustrative Example | Fictional Data The agency, figures and events below are fictional and are included only to illustrate the method.

At October 31, Harbor & Pine’s general ledger shows premiums payable to carriers of $418,600. The carrier payable detail report shows $409,350. The difference is $9,250.

Premiums payable difference at October 31 (fictional)
ItemAmountWhat it isResolution
A$4,000An August journal entry credited directly to the ledger control account to correct a remittance, with no matching detail transactionReverse the manual entry. If the correction was valid, re-record it through the normal transaction workflow, with review, so that the detail and the ledger both reflect it
B$3,750October 31 Agency Bill invoices that created $3,750 of carrier payables, posted after the detail report was runRerun the report after posting; no adjustment needed
C$1,500An unexplained amount, more than 90 days old, dating from before a system conversionResearch against pre-conversion records; escalate with a documented decision if support cannot be found
Total$9,250

Item B was never a real difference. Item A is a process issue that will recur unless manual entries to control accounts stop. Only item C is genuinely unexplained, and it now has an owner and a deadline instead of hiding inside a larger number.

An order of work that holds up

  1. Reconcile cash first, including fiduciary accounts, with every reconciling item supported and aged.
  2. Align scope and timing before comparing detail to the ledger: same date, entities, agency codes, and posting status.
  3. Separate the fiduciary position from operating balances and review it every month.
  4. Pull out credit balances and suspense items as their own lists, each with an owner.
  5. Confirm the accounting basis and check that commission accounts follow it consistently.
  6. Document every adjustment with support and approval. Avoid balancing entries that only make a difference disappear.
  7. Fix the cause: stop manual entries to control accounts, run reports after posting with consistent parameters, and give each reconciliation a preparer and a reviewer.

When to get help

If differences have carried forward for several months, follow a system conversion, or involve fiduciary funds, an outside review can separate timing from real errors faster than adding more monthly effort. NJTS provides insurance agency accounting and controller support: balance-sheet reconciliation, close ownership, and the process changes that keep differences from returning. The work is management accounting and advisory support, not an audit or other attest service.

For the full month-end framework, see Insurance Agency Month-End Close.

Describe which balance won’t tie out and how long it has been carrying forward. No confidential records or account access are needed for the initial inquiry.

Discuss a reconciliation issue