Financials · Notes

Why doesn't my commission income match my P&L?

Short answer

Your AMS's book of business report gives annual commission on policies in force. The P&L records commission booked during accounting periods. Compare the same twelve months, show growth to today's Book separately, and leave any remaining difference unexplained until the records support a cause.

John Ranieri

John RanieriFounder & Product Lead, Keelridge SoftwareAugust 17, 2026 · 4 min read

Are the two numbers even supposed to match?

Not exactly, even when both records are complete. The book is a point-in-time estimate of annual commission. The P&L is a flow of commission booked between dates.

Keelridge's annual commission figure combines commission recorded in the AMS, annualization of supported six-month terms, and a modeled amount for direct-bill policies whose commission is recorded as zero. It describes what the current in-force book is expected to support annually; it is not a receivable or a promise of cash.

The general ledger reports booked P&C commission on the agency's accounting basis. That may differ from cash received, and its timing follows the agency's posting process rather than the current shape of the book.

A useful comparison keeps each basis and sets a year beside a year. It does not force one day's book estimate to equal one month, or even one trailing year, of accounting activity.

What has to be made comparable first?

Scope before arithmetic. The ledger side should contain the P&C commission accounts represented by the AMS book. Contingent profit-sharing, life and health commission, and other income need their own analysis when they are not represented in that book.

The book side needs one consistent annual basis. Six-month terms cannot remain at half-year premium and commission while twelve-month terms remain annual. Direct-bill zeroes also cannot silently mean that the agency earns nothing when the source file simply omitted the rate.

These are governed setup decisions, not balancing items. Contingent income is not a convenient explanation for a P&C commission difference if it was already removed from the ledger scope, and a modeled direct-bill amount belongs inside the disclosed annual commission estimate rather than being added again as a gap cause.

Why use a twelve-month average of the book?

A trailing-twelve-month P&L contains commission produced by the book as it existed throughout those twelve months. Comparing it only with today's larger or smaller book makes growth look like an accounting discrepancy.

Instead, calculate annual commission at each available book snapshot across the same twelve accounting months and average those readings. Compare the booked P&C commission for that window with that average. Then show the change from average annual commission to annual commission today as a separate growth rung.

That sequence distinguishes a year-to-year operating change from the residual difference between the ledgers. It also prevents a rapidly growing book from manufacturing a large apparent shortfall merely because today's position is being compared with yesterday's revenue.

What does timing and unexplained mean?

It is booked P&C commission for the twelve-month window minus the book's average annual commission for those same months. The result stays signed: the ledger can sit above or below the book estimate.

The label is intentionally modest. Posting timing, statement practices, source omissions, commission assumptions, retention, and other effects may sit inside the difference, but the two ledgers do not prove how much belongs to each cause. Calling the full remainder an unmatched deposit, a retention loss, or a direct-bill backlog would claim evidence the comparison does not contain.

Keelridge reads the latest result against the agency's own history rather than declaring one universal acceptable percentage. A result outside that usual range is a reason to investigate source timing and setup; it is not an automatic diagnosis.

What does a good monthly comparison look like?

Use one repeated bridge: P&C commission in your P&L for the last twelve months; less the signed timing-and-unexplained difference; equals the book's average annual commission for those same months; plus or minus book growth over the window; equals annual commission today.

Keep the recorded, annualized, and modeled portions of annual commission visible. State which GL accounts are in scope. Show the residual trend and the agency-specific usual range without assigning the remainder to a cause the data cannot support.

The output should let an owner tell a changing book from a changing ledger and then open the figures underneath. It is not a single total engineered to agree.

In Keelridge this is the book vs GL tab, under Agency Performance, Financials. In the fictional demo, the ledger booked $858k of P&C commission over the twelve months to September 2026. The book's annual commission averaged $862k over the same months and is $887k today. The $4k between the first two is Timing & unexplained.

What this looks like in practice

A year of ledger beside a year of the book's annual commission.

Keelridge Demo Portal chart comparing monthly booked P&C commission with the book's annual commission Owner viewOpen this page in the live demo →
Captured from the fictional Keelridge Demo Agency. The monthly view shows posted GL commission as bars, the book's commission by term start as dots, the monthly average of the book's annual commission as a line and the same month last year as a tick, without assigning every difference to timing. Opens the public demo as Owner.

Fictional Keelridge Demo Agency. Book vs GL compares the P&C commission in your P&L with the book's average annual commission over the same twelve months, separates growth to today's annual commission, and leaves timing and unexplained visible without assigning it a cause. On the monthly chart, dots show the book's commission by term start beside the posted GL bars.

What to do with this in your own review

Define the P&C commission accounts in scope, build annual commission on a consistent basis, and compare the last year of commission in your P&L with the book's average annual commission over those same months. Show growth to today separately and preserve the remaining signed difference as timing and unexplained until the source records support a narrower conclusion.

Sources used for the industry context

Related questions

Asked alongside this one.

Should an agency's AMS and general ledger commission totals ever be exactly equal?

Exact equality is not the objective because the book estimates annual commission at points in time while the general ledger records commission on the agency's accounting basis across periods. Compare the same twelve-month window, keep the scopes consistent, and preserve the remaining signed difference rather than forcing agreement.

Why is direct-bill commission harder to reconcile than agency bill?

With direct bill the carrier bills the client and later reports or pays agency commission. Agencies may record that commission policy by policy, from monthly statements, in grouped entries, or as cash receipts, so the timing and available policy detail vary. Keelridge models disclosed AMS zeroes inside annual commission; it does not treat them as proven missing ledger income.

Does contingent income belong in a book-to-GL reconciliation?

Not in Keelridge's P&C commission reconciliation. Contingent and profit-sharing income is mapped to separate GL accounts and excluded from the ledger side because the in-force policy Book does not represent it. It remains real income in the P&L and can be reviewed separately.

What is timing and unexplained?

It is the last twelve months of P&C commission in your P&L minus the book's average annual commission across those same months. It may contain timing, source, setup, retention, and other effects, but the aggregate comparison does not prove the cause. Keelridge therefore keeps it signed, visible, and compared with the agency's own history.

See the product

See the book-to-ledger comparison in Keelridge.

The tour and demo use fictional agency records. You can inspect the relevant view without signing up.