How to reconcile P&C carrier commission statements

Your carrier statement totals can agree while individual payments still deserve a second look. For an independent property and casualty agency, the useful question is: which transactions need attention, and what evidence will help you resolve them?

This guide walks through a review of one carrier statement. The worked example uses the fictional transactions and agreement in Pineapple Split’s demo. The percentages are sample assumptions, not industry benchmarks or recommended commission rates.

Explore the example before uploading a file →

Start with one carrier and one statement period

Gather the original commission statement, the applicable commission agreement or schedule, and any earlier transactions needed to explain adjustments. Keep the carrier’s original document available while you review extracted or spreadsheet data.

For a percentage-based payment, identify the premium amount to which the commission rate applies. Verify whether that amount represents the transaction, an installment, or another basis specified in the agreement. Do not substitute the full policy premium without checking. Fees, taxes, special arrangements, and adjustments may need separate treatment.

Record the carrier, product, transaction type, and relevant dates alongside the rate. A new-business rate should not automatically become the expected rate for a renewal. If the agreement is missing or ambiguous, mark the transaction as needing a rate, rather than treating the statement’s own percentage as proof that the payment is correct.

1. Reconcile the statement total

Sum the commission lines, including negative entries, and compare the result with the statement’s total. If they differ, first check for omitted pages, duplicated rows, subtotal rows, or separately listed adjustments.

This is a completeness and arithmetic check. It does not establish that the carrier used the right rate on each transaction. Comparing the statement with the corresponding bank receipt is another separate task, especially when payments combine periods or include other adjustments.

Agency management systems also provide reconciliation workflows. For example, Vertafore’s AMS360 documentation describes comparing company statement totals with agency totals and reviewing individual commission transactions. Check what your existing system already handles before adding another tool.

2. Compare the payment with the applicable agreement

For a straightforward percentage-based transaction:

Expected commission = applicable premium × contracted percentage.

Difference to review = expected commission − commission paid.

The example below assumes the listed premium is the correct commission basis and that no other adjustments apply. The two homeowners renewals have a fictional 15% agreement. The auto line has a fictional 12% agreement and also states 12% on the statement.

Sample transaction	Premium basis	Expected	Paid	Difference
Homeowners renewal DEMO-002, at 15%	$2,000	$300	$240	$60
Homeowners renewal DEMO-003, at 15%	$3,000	$450	$360	$90
Auto transaction DEMO-017, at 12%	$2,000	$240	$220	$20
Total for these three transactions		$990	$820	$170

The homeowners payments equal 12% of premium. Their line arithmetic works, but they are below the supplied 15% agreement. The auto payment has a different issue: $2,000 × 12% is $240, while the statement pays $220.

The full fictional statement contains 48 transactions and $17,050 in paid commissions. Its totals agree. These three transactions still produce $170 in calculated shortfalls to review. That is not recovered money or a prediction about your agency’s statements.

See each calculation and prepare the sample follow-up →

3. Keep uncertain items out of the shortfall total

A missing rate is a gap in the check, not a measured loss. The demo also includes six umbrella transactions without a supplied agreement rate. Those transactions are excluded from its calculated shortfall total.

Likewise, a negative commission without a matching original payment in the available records needs investigation. The original might be in an earlier period that you have not imported. Check the policy, transaction dates, cancellation or adjustment details, and earlier payments before disputing it.

A policy’s absence from this month’s statement does not by itself prove a missing commission. Establish that a payment was due in this period using the agreement, billing or payment schedule, and relevant records. A statement alone cannot show every transaction that should have existed.

4. Prepare a follow-up someone can answer

For each confirmed discrepancy, retain:

• The carrier, statement period, and policy or transaction reference.
• The source premium, stated rate, and paid commission.
• The applicable agreement rate and the calculation you used.
• Any adjustments or earlier payments you checked.
• The question you want the carrier to resolve.

For the fictional $60 homeowners difference, a useful request would be:

Please review DEMO-002 on the June statement. The $2,000 premium paid $240. Using the supplied 15% renewal agreement, we calculate $300, a $60 difference. Please confirm the applicable commission basis and explain or correct the difference.

That wording is an example for fictional data. Verify your own agreement and use your carrier’s approved communication channel when following up on real transactions.

Record the response, next action, and any correction received. Keep the calculated difference separate from the amount actually recovered, and check a later statement or payment record before recording a recovery.

A checklist for your next statement

1. Confirm the carrier, period, and completeness of the source document.
2. Check extracted columns and transaction types against the original.
3. Sum commission lines and account for separately listed adjustments.
4. Apply the correct agreement and premium basis to eligible transactions.
5. Separate calculated differences from missing rates and incomplete history.
6. Verify the evidence before contacting the carrier.
7. Track the response and confirm any subsequent correction.

Try the same review in Pineapple Split

Pineapple Split’s P&C commission review workspace helps focus attention on flagged transactions and their supporting evidence. Start with one statement. If its format needs column review, confirm the mapping; if a contract rate is missing, enter the applicable percentage to recheck that statement.

The quality and scope of the findings depend on the source data, applicable rates, and history available. You remain responsible for verifying the agreement and deciding which findings merit follow-up.

Explore the fictional example without signing up, or check your own statement when you are ready.