Insurance Commission Reconciliation: What Agencies Are Missing and How Much It Costs

Insurance commission reconciliation is the process of matching what carriers actually paid against what your agency expected to earn based on written policies, applied commission rates, and your carrier agreements. The industry average error rate sits at 3-7% of total commissions owed. An agency earning $500,000 per year in commissions that leaks 5% is losing $25,000 annually - often without anyone noticing because reconciliation is done manually, inconsistently, or not at all.

This analysis covers what reconciliation is, why errors happen, the 4-step process that catches them, and the specific formats and tools involved for each major carrier.

Key Takeaways

• Carriers underpay commissions at a rate of 3-7% of total commissions owed, per IVANS and independent agency benchmarks
• The most common error types are: wrong commission rate applied (most frequent), missing policy on carrier statement, return commission not processed after cancellation, and override/contingency calculation errors
• An agency with $500K in annual commissions leaking 5% loses $25,000 per year; most of it is never recovered because reconciliation is manual or absent
• The 4-step reconciliation process: policy register export from AMS → carrier statement download → match and identify exceptions → dispute and recover
• Hartford, Travelers, and Progressive each use different statement formats; 130+ carriers support IVANS ACORD 820 download; the remaining ~40% require manual portal download
• Direct bill reconciliation requires trusting the carrier's statement; agency bill reconciliation starts from what the agency collected
• Override and contingency reconciliation runs on a separate annual cycle and requires a formal carrier audit appeal process for disputes

What Insurance Commission Reconciliation Actually Is

Reconciliation is not bookkeeping. It is a revenue verification process.

When a policy is written, your AMS stores the expected commission: premium amount multiplied by the commission rate from your carrier agreement. When the carrier pays, the commission statement shows what they actually paid. Reconciliation compares those two numbers at the policy level - not in aggregate.

Aggregate comparison misses most errors. A carrier that overpays on one policy and underpays on three others produces numbers that look close enough in total. Line-by-line reconciliation catches all four discrepancies.

The goal is a three-way match: policy in AMS, policy on carrier statement, and dollar amounts aligned. Anything that does not match is an exception requiring investigation and, if the carrier owes money, a formal dispute submission.

Why Commission Discrepancies Happen

Errors originate from five distinct causes. Each requires a different investigation approach.

Carrier processing errors: wrong rate applied. The carrier's commission system applies a rate from an outdated or incorrect commission schedule. This happens when rate agreements are updated but the change is not propagated to the carrier's policy processing system. A 1-point rate error on a $100,000 premium policy produces a $1,000 underpayment per policy year. On a book of 200 such policies, that error generates $200,000 in underpayments before anyone catches it.

Carrier processing errors: wrong effective date. The carrier books the policy effective date incorrectly, shifting commission into the wrong payment period. These discrepancies are often timing issues rather than revenue losses, but they create reconciliation noise that masks real errors if not tracked properly.

Cancellation return commission not processed. When a policy cancels mid-term, the carrier owes a return commission for the unearned portion of the premium. Carriers frequently fail to process this automatically. For agency bill accounts, the agency may have already remitted commission based on the full term; the carrier owes that money back. For direct bill accounts, the carrier simply fails to credit the return, reducing the next commission statement by the return amount.

Policy changes not reflected in commission statements. Mid-term endorsements that change premium should trigger a commission adjustment. Many carriers process the endorsement in their underwriting system but fail to route the commission adjustment to their accounting system. The commission statement reflects the original premium. The agency earned commission on the endorsed premium. The gap is the discrepancy.

Contingency and override miscalculations. Contingency commissions are calculated annually by carriers using their own records of your premium volume and loss ratio. Override commissions are triggered when your production with a carrier exceeds a threshold. Both rely on carrier-maintained data that agencies cannot independently verify without requesting raw data. Errors in these calculations are the hardest to catch and the hardest to dispute.

The Financial Stake

Most agency principals have no accurate number for how much commission they are not collecting. Here is how to calculate it.

These losses compound. A rate discrepancy on a renewable policy repeats every 12 months until someone submits a correction and the carrier fixes it. An agency that catches a rate error after three years of renewals is owed three years of underpayments - but most carriers limit recovery to the prior 12-24 months. The commission earned before the lookback window is gone permanently.

The 4-Step Reconciliation Process

Step 1: Policy Register Export from AMS

Pull every active and cancelled policy for the reconciliation period from your agency management system. The export must include: policy number, carrier, line of business, insured name, effective date, cancellation date (if applicable), written premium, commission rate from your carrier agreement, and expected commission amount.

AMS360 produces this through the Commission Accounting module and the Download Center. Applied Epic uses the Commission Journal report. HawkSoft generates a Production Report filtered by carrier and policy status. Each platform stores commission rate tables - verify these match your current carrier agreements before running the report. A rate table that was not updated after last year's negotiation produces incorrect expected values on every policy with that carrier.

The policy register is your source of truth. Every line on the carrier's commission statement should map to a corresponding line in your register.

Step 2: Carrier Commission Statement Download

The format of the carrier statement determines how much work this step requires.

IVANS commission download (ACORD 820 format). This is the electronic standard. Carriers transmit commission data as ACORD 820 XML files through the IVANS platform. The format includes: policy number, effective date, premium amount, commission rate, commission amount, and transaction type (new business, renewal, endorsement, cancellation, reinstatement). More than 130 carriers support ACORD 820 download through IVANS, including most of the top 20 P&C carriers by volume. Agencies using AMS360 or Applied Epic get IVANS download included in their AMS subscription. Other agency management systems can connect to IVANS separately. ACORD 820 data is machine-readable: no reformatting, no manual entry, no OCR. For carriers on IVANS, statement download takes minutes.

Carrier portal downloads. Hartford sends detailed line-item commission statements through the Hartford Connector portal. The statements are downloadable as CSV and include policy-level detail consistent enough for direct comparison against AMS data. Travelers distributes commission statements through EDI download via the IVANS integration - agencies with IVANS access pull Travelers statements automatically. Progressive ForAgents provides CSV commission downloads through its producer portal. Liberty Mutual's Liberty Aspire portal offers commission statements in a structured format downloadable monthly.

Carriers without IVANS support. Approximately 40% of P&C carriers by volume do not support ACORD 820 download through IVANS. These carriers send statements as PDFs via email, post them to portal interfaces that do not support CSV export, or mail paper statements. For these carriers, agencies must either manually enter statement data into a comparison spreadsheet or use reconciliation software with PDF OCR capability. Manual entry for a 200-line PDF statement takes 2-3 hours and introduces transcription errors.

Step 3: Match Records and Identify Exceptions

With the AMS policy register and carrier statements in hand, the matching process identifies three categories of exceptions.

Policies in AMS not on carrier statement. Every policy in your register that does not appear on the carrier's statement for the period is a potential missing commission. The investigation starts in the carrier portal: is the policy bound and active in the carrier's system? If yes and the commission did not appear, the carrier failed to generate the commission transaction. If the policy is pending, the commission will appear in a future statement. Allow 30 days for processing before treating a missing policy as an exception. Beyond 30 days, submit a missing commission inquiry directly to the carrier's commission department.

Policies on carrier statement not in AMS. Lines on the carrier statement that have no corresponding record in your AMS most often indicate cancellations that were not updated in the AMS. The agency wrote the cancellation, the carrier processed it and reflected it on the commission statement, but someone forgot to update the AMS record. This category also catches a more serious problem: policies the carrier is crediting that the agency did not write, which can indicate agency code errors or assignment of another agency's business to your code.

Rate and amount discrepancies. Policies that match on both sides but show different dollar amounts are the most common exception category. The investigation path: compare the commission rate on the carrier statement to the rate in your carrier agreement. If the rates match but amounts differ, check whether the carrier's premium figure matches your AMS premium. If rates differ, confirm when your current agreement became effective and whether the carrier updated its system. Most rate discrepancies result from the carrier applying the old rate for months or years after an agreement renegotiation.

Step 4: Dispute and Recover

Submit discrepancy corrections to the carrier's commission department - not to your underwriting contact or marketing rep. Commission corrections require the accounting department.

An effective dispute submission includes: your agency name and code, the reconciliation period, a policy-by-policy table of exceptions with expected amount, received amount, and variance, the commission rate from your signed carrier agreement, and supporting documentation such as policy declaration pages and AMS screenshots confirming premium and effective dates.

Email submission with a structured attachment produces faster results than phone calls. Carriers process commission corrections on accounting cycles - typically monthly. The standard resolution timeline is 30-60 days. Carriers that do not respond within 30 days should receive a follow-up email with an explicit escalation timeline. At 60 days without resolution, escalate to your carrier marketing representative with documentation of the original submission date.

Track every open dispute in a log: carrier name, submission date, amount requested, response received, amount recovered, and status. Untracked disputes close without recovery. A $1,200 dispute submitted in January and forgotten by March is commission income the agency earned and will not collect.

Most carriers set a recovery lookback limit of 12 months. A few allow 24 months. Errors older than the lookback window are not recoverable. This is the primary financial argument for monthly reconciliation: catching errors in the month they occur, not 13 months later when the window has closed.

Direct Bill vs. Agency Bill Reconciliation

The billing method determines who has the data and who has the problem.

Direct bill reconciliation. The carrier invoices the client, collects the premium, and pays the agency its commission. The agency has no independent record of what premium the carrier collected. Reconciliation requires trusting the carrier's statement as the source of premium data, then verifying that the commission rate applied matches the agency agreement. The agency can check: does every direct bill policy appear on the statement, does the commission rate match the agreement, and does the commission calculation match the stated premium at the stated rate. What the agency cannot easily verify: whether the carrier correctly billed the client, whether endorsement premiums were included, and whether the carrier applied any premium adjustments the agency was not notified of.

Agency bill reconciliation. The agency invoices the client, collects the full premium, retains its commission, and remits net premium to the carrier. The agency knows exactly what premium it collected because it collected it. Reconciliation is simpler: compare what the agency collected and retained as commission against what the carrier's records show. Discrepancies most often arise from cancellation timing - the agency collected full-term premium, the policy cancelled mid-term, and the carrier expects a return premium but the agency has not yet returned the commission. Agency bill reconciliation connects directly to premium trust account reconciliation, since any commission retained from the trust account must be reconcilable back to a policy earning.

Override and Contingency Reconciliation

Override and contingency reconciliation is a separate process from monthly statement reconciliation. It runs annually.

Override commissions are incremental rate increases triggered when your production with a carrier exceeds a threshold. A carrier might pay 12% base commission on the first $1M in premium and 14% on premium above $1M. The 2-point difference on premium above the threshold is the override. At year-end, the carrier calculates whether you hit the threshold and applies the override retroactively or prospectively. To verify the carrier's calculation: pull your total premium written with that carrier for the period from your AMS, compare it to the carrier's stated eligible premium in the override calculation, and verify the rate tiers match your agreement.

Contingency commissions are annual bonus payments tied to a combination of production volume, loss ratio, and retention rate. The carrier calculates all three metrics from its own systems. Agencies receive a contingency statement that shows the carrier's numbers - not the agency's. To audit the contingency calculation: request the carrier's underlying data (premium volume by line, loss runs by line, and retention calculation methodology). Compare the carrier's premium figure to your AMS production report. Compare the carrier's loss figure to your clients' claim totals, which you can verify through your E&O carrier or through loss run requests. Discrepancies in contingency calculations often involve large dollar amounts. Disputes require a formal carrier audit appeal process. For discrepancies above $10,000, involve your E&O attorney in the documentation process.

The ACORD 820 Format: What It Is and Why It Matters

ACORD 820 is the electronic data interchange standard for insurance commission payments. Carriers transmit commission data in ACORD 820 XML format through the IVANS platform. The format standardizes the data fields that must accompany every commission transaction: transaction type, policy identifier, line of business code, effective date, premium amount, commission rate, commission amount, and payment reference.

For agencies with IVANS connectivity, ACORD 820 means policy-level reconciliation is machine-executable. The matching engine receives structured data with consistent field names and values. A policy number in the ACORD 820 file matches a policy number in the AMS. The comparison happens in seconds per policy.

For carriers without ACORD 820 support, reconciliation reverts to manual or semi-manual processes: download a PDF, extract data through OCR or manual entry, normalize field names, then run the comparison. This is why IVANS connectivity is the most important factor when evaluating any reconciliation approach. The 130+ carriers on IVANS represent the majority of P&C premium volume for most independent agencies. But the 40% of carriers not on IVANS - often regional carriers, specialty carriers, and surplus lines markets - generate commission errors at the same rate and require significantly more work to reconcile.

What Most Reconciliation Guides Miss

Most published guides describe the process generically: get statements, compare to AMS, submit corrections. They do not address the format problem. An agency with 15 carrier partners may have 4 on IVANS ACORD 820 download, 6 with carrier portal CSV downloads, 3 with PDF-only statements, and 2 that still mail paper. A single reconciliation process must handle all four formats in the same month. The time and accuracy difference between an IVANS download and a paper statement is not a footnote - it is the central operational challenge of commission reconciliation for most agencies.

See commission reconciliation process steps for the step-by-step workflow, and commission reconciliation software tools for a comparison of platforms that handle multi-format statement processing.

FAQ

What is the difference between commission reconciliation and bookkeeping?

Bookkeeping records what was received. Commission reconciliation verifies that what was received is what was earned. An agency can have perfect books and still be missing $20,000 in underpaid commission because the books record only what came in, not what should have come in. Reconciliation requires a second data source - the carrier statement - and a comparison against expected commission calculated from the agency's own policy records.

How often should agencies reconcile commissions?

Monthly. The practical reason: most carriers set a 12-month lookback window on commission corrections. An error caught in month 1 is recoverable. The same error caught in month 14 is outside the recovery window. Monthly reconciliation also prevents the accumulation of exceptions that makes quarterly or annual reconciliation overwhelming.

Which carriers are most likely to have commission discrepancies?

Carriers with complex commission schedules (tiered rates, override thresholds, contingency programs) and carriers that recently changed systems or rate agreements generate the most errors. Regional carriers with less automated commission systems are also higher-risk. Agencies should track discrepancy rates by carrier and prioritize reconciliation effort toward carriers with the highest historical error rates.

Can you recover commissions that were underpaid more than a year ago?

Most carriers allow recovery within 12 months of the payment date. A few - primarily larger national carriers - allow 24 months. Some carriers have no published policy and will consider disputes older than 12 months on a case-by-case basis. Beyond the carrier's lookback window, recovery is unlikely without escalation to senior carrier management or legal involvement. The older the discrepancy, the weaker the agency's position.

What documentation do you need to dispute a commission discrepancy?

At minimum: agency name and code, policy number, reconciliation period, expected commission amount with calculation shown (premium × rate), received commission amount from the carrier statement, dollar variance, and the relevant page of your signed commission agreement showing the applicable rate. Supporting documents strengthen the case: policy declaration page showing the premium, AMS screenshot confirming the policy details, and a history of previous payments at the correct rate if the error is a recent change.

How do override and contingency commissions get audited?

Request the carrier's underlying calculation data: the premium volume figure they used, the loss ratio calculation, and the retention metric. Compare the carrier's premium total to your AMS production report for the same period and line of business. Discrepancies in the premium figure are the most common source of override and contingency errors. If the carrier's premium figure differs from your AMS total by more than 2%, request a policy-level detail report from the carrier to identify which policies they excluded or miscounted.

Written by Javier Sanz, Founder of BrokerageAudit. Last updated April 2026.

Stop leaving commission income on the table. BrokerageAudit matches every carrier statement against your AMS policy data automatically, flags exceptions by type and dollar amount, and generates dispute documentation ready to submit. Start recovering what carriers owe you →