Commission Reconciliation Process Steps: Manual vs. Automated Comparison

Commission reconciliation process steps follow a defined sequence whether your agency uses spreadsheets or software. The steps do not change. The execution method does. Agencies that complete all six steps consistently - manually or with software - recover $15,000-$35,000 annually in underpaid commission depending on book size. Agencies that skip steps or skip months recover 40-60% less. See the full analysis of insurance commission reconciliation for why errors happen and what the financial stakes are.

Key Takeaways

• The process has 6 steps: AMS export → carrier statement download → record matching → exception categorization → dispute submission → accounting post
• Manual execution for a 10-carrier agency takes 20-40 hours per month; automated execution takes 2-4 hours
• Step 3 (record matching) accounts for 60-70% of manual reconciliation time; automation reduces this step from hours to minutes
• AMS360 uses the Commission Accounting module and Download Center; Applied Epic uses the Commission Journal; HawkSoft uses the Production Report
• 130+ carriers support IVANS ACORD 820 download - the remainder require portal download or manual PDF entry
• Override commissions and contingency commissions require a separate annual reconciliation process, not the monthly workflow

The 6-Step Commission Reconciliation Process

Step 1: Pull Policy Register from AMS

The AMS policy register is the agency's source of expected commission. It lists every active and recently cancelled policy with the premium, commission rate from the carrier agreement, and calculated expected commission.

Manual method. Each AMS platform produces this differently.

AMS360 generates this through the Commission Tracking report in the Commission Accounting module. Filter by carrier, include active and cancelled policies, and select the reconciliation period. Export as CSV. Verify that the commission rate column reflects your current carrier agreement - AMS360 rate tables must be updated manually when carrier agreements change.

Applied Epic uses the Commission Journal report. Run it filtered by carrier and by transaction date range. The Commission Journal includes transaction type (new business, renewal, endorsement, cancellation), written premium, commission rate, and expected commission per transaction. Export as Excel.

HawkSoft produces the Production Report, filterable by carrier and policy status. HawkSoft includes commission rate and expected commission per policy if the rate tables are configured. Filter for the reconciliation period. Export as CSV.

Automated method. Reconciliation software pulls AMS data through an API connection or a scheduled batch export. The software converts the data into a normalized format used for matching. No manual export or reformatting needed.

Quality check before proceeding. Spot-check 10-15 policies in the register against the actual carrier agreements. A rate table that was not updated after a commission renegotiation produces incorrect expected values on every policy with that carrier - generating false exceptions in every subsequent step.

Step 2: Get Carrier Commission Statement

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

Manual method: IVANS download. Carriers that support the ACORD 820 electronic commission standard transmit statement data through IVANS. More than 130 carriers participate. Agencies using AMS360 or Applied Epic receive IVANS commission download as part of their AMS subscription. Open the IVANS Download Manager, select the commission statement transaction type, and download. The result is a structured XML or CSV file with policy number, effective date, premium, commission rate, commission amount, and transaction type for every line item. No reformatting needed.

Manual method: carrier portals. For carriers not on IVANS, log into the carrier's producer portal and download the commission statement.

• Hartford Connector: Commission statements are downloadable as CSV with detailed line-item data, typically available by the 10th of the following month.
• Travelers Producer Portal: Travelers supports IVANS EDI download for agencies with IVANS connectivity; otherwise, download the CSV from the portal.
• Progressive ForAgents: Commission statements are downloadable as CSV from the Reports section of the ForAgents portal.
• Liberty Aspire: Monthly commission statements are available as structured downloads in the Liberty Aspire producer portal.
• Regional and specialty carriers: Many provide PDF statements only. These require either manual data entry into a comparison spreadsheet or OCR software to extract line-item data. A 200-line PDF statement takes 2-3 hours to enter manually.

Automated method. Reconciliation software with IVANS integration pulls carrier statements automatically for all IVANS-connected carriers. For carriers without IVANS support, the software accepts manual CSV upload or PDF upload with OCR parsing. Some tools scrape carrier portals directly. Either way, the software normalizes the data into the same format used for the AMS data, ready for matching.

Step 3: Match Records

This is where 60-70% of manual reconciliation time is spent - and where automation produces the largest time savings.

Manual method. Export both datasets (AMS register and carrier statements) to Excel. Sort both by policy number. Use VLOOKUP or INDEX/MATCH to find each AMS policy in the carrier statement. Where VLOOKUP returns a match, compare: premium amount (AMS vs. carrier), commission rate (AMS vs. carrier), and commission amount. Flag any row where the difference exceeds your tolerance threshold (typically $5-$10 for large agencies, $25 for smaller ones).

Run a second VLOOKUP in the opposite direction: find every carrier statement line that has no match in the AMS register. These are policies on the carrier statement with no corresponding AMS record.

For a 10-carrier agency processing 500-700 commission line items per month, this step takes 10-20 hours manually.

Automated method. The software compares every AMS policy against every carrier statement line simultaneously. Matching uses policy number as the primary key. For policies where carrier and AMS policy numbers differ in format (prefix added, dashes removed, truncated), fuzzy matching logic handles the variation. The software flags exceptions with the mismatch type labeled: rate discrepancy, missing from carrier statement, missing from AMS, or amount variance. This step completes in under 20 minutes for a 10-carrier book.

Step 4: Categorize Exceptions

Not all exceptions are the same. Categorization determines the investigation path and recovery timeline.

Missing from carrier statement. The policy is active in the AMS but does not appear on the carrier's commission statement. First check: is the policy actually bound in the carrier's system? Log into the carrier portal and verify policy status. If bound, the commission should appear. If the policy is in carrier underwriting review, the commission will appear on a future statement - allow 30 days before escalating. If the policy has been bound for more than 30 days and still does not appear, submit a missing commission inquiry to the carrier's accounting department.

Rate mismatch. The carrier paid commission at a rate different from your agreement. This is the most common exception category. Compare the rate on the carrier statement to your signed commission schedule. If the carrier's rate is lower, determine when your current agreement became effective and whether the carrier updated its system on the correct date. Submit a rate correction request with the signed agreement attached.

Premium amount mismatch. The carrier applied the correct rate to an incorrect premium. Common cause: a mid-term endorsement changed the premium, but the carrier's commission system still reflects the original premium. Check the policy declaration in the carrier portal against the AMS premium.

In carrier statement, not in AMS. The carrier shows a commission line with no corresponding AMS policy. Most common cause: a cancellation or endorsement was processed by the carrier but not updated in the AMS. Also investigate whether the carrier has assigned another agency's business to your code, which occasionally happens after mergers or producer transfers. Verify in the AMS whether the policy exists under a different number or status.

Duplicate credit. The carrier applied a return commission more than once for the same cancellation. Sort the carrier statement by policy number and look for policies with multiple credit entries. Compare against the AMS cancellation record.

Step 5: Submit Disputes

Submit commission corrections to the carrier's commission accounting department - not to your underwriting contact.

An effective dispute submission contains: your agency name and National Producer Number or agency code, the reconciliation period, a structured exception table listing each disputed policy with expected amount, received amount, and variance, the commission rate from your signed agreement for rate disputes, and supporting documentation (AMS screenshot, policy declaration page, IVANS or portal download of the relevant statement line).

Email is more effective than phone calls. Carriers process written correction requests through accounting cycles. Document the submission date and amount.

Carrier response timelines: most carriers respond within 30 days. If no response in 30 days, send a follow-up citing the original submission date. If no resolution in 60 days, escalate to your carrier marketing representative or agency manager with the documentation trail attached.

Track every open dispute in a log: carrier, submission date, amount requested, amount received, status (open/partial/resolved/denied). Partial resolutions need investigation - the carrier may have denied a portion for a valid reason or made an error in the correction.

Step 6: Post to Accounting

Reconciled commissions are posted to income. Unresolved exceptions are held in a suspense account until resolved.

Manual method. Post reconciled commission amounts as income in your accounting software (QuickBooks, Xero, or AMS-integrated accounting). For each unresolved exception, create a suspense account entry with the carrier name, policy number, and disputed amount. Review the suspense account monthly and clear entries as disputes resolve.

Commission split reconciliation runs after carrier commission posting: verify that each producer received the correct split percentage on every transaction in the period. The most common producer payment errors are applying new business split rates to renewals, missing tier changes, and not crediting cross-sold policies to the originating producer.

Automated method. Reconciliation software generates a journal entry file for clean matches. Exceptions remain flagged in the software as pending until manually approved or resolved. Some tools integrate directly with QuickBooks or Xero to post entries without re-entry. The suspense account is managed inside the software's dispute tracker.

What Happens When You Skip Steps

The most commonly skipped steps - and their consequences.

Skipping Step 1 quality check. Agencies that reconcile against incorrect AMS rate tables generate false exceptions on every carrier. Staff investigates discrepancies that are not real, missing actual errors in the noise.

Skipping Step 4 categorization. Without categorization, all exceptions look the same. The agency submits a generic dispute that the carrier partially rejects. Categorization makes disputes specific and documentable - carriers resolve specific disputes faster.

Skipping Step 6 suspense tracking. Disputes submitted without follow-up close without recovery. The IIABA estimates that 20-30% of submitted commission correction requests go unresolved because agencies do not track them. A dispute submitted and forgotten is commission income permanently lost.

For a comparison of software that automates these steps, see commission reconciliation software tools.

FAQ

How often should you reconcile commissions?

Monthly. Most carriers limit commission correction recovery to the prior 12 months. An error caught in month 1 is recoverable. The same error caught in month 14 - when it has repeated 13 times on a renewable policy - is outside the recovery window. Monthly reconciliation also prevents exception backlogs that make quarterly reconciliation overwhelming and inaccurate.

What is the difference between reconciling direct bill vs. agency bill commissions?

For direct bill, the carrier collects premium and pays the agency commission. The agency verifies that every direct bill policy appears on the statement, that the rate matches the agreement, and that the calculation is correct. The agency cannot verify the carrier's premium collection directly. For agency bill, the agency collects premium and retains commission before remitting to the carrier. The agency knows exactly what it collected. Reconciliation confirms that the carrier's records match the agency's receipts. Agency bill reconciliation connects to premium trust account reconciliation - any commission retained from the trust must reconcile back to a specific policy earning.

How do you handle a carrier that will not fix a discrepancy?

First, confirm the dispute was received: request written acknowledgment from the carrier's commission department. If the carrier received it and disputes the correction, request their calculation and the specific reason for denial. Most denials involve rate questions (carrier disputes the rate in your agreement) or policy status questions (carrier claims the policy is not bound). Provide the signed agreement or the carrier's own portal confirmation of binding. If the carrier continues to deny a valid dispute, escalate to your carrier marketing rep. For disputes above $5,000 that remain unresolved after 90 days, consult an insurance agency E&O attorney.

What AMS reports do you need for commission reconciliation?

AMS360: Commission Tracking report from the Commission Accounting module, filtered by carrier and period. Applied Epic: Commission Journal report filtered by carrier and transaction date. HawkSoft: Production Report filtered by carrier and policy status. All three reports must include: policy number, insured name, carrier, line of business, effective date, written premium, commission rate, and expected commission. Verify that the commission rate fields reflect current carrier agreements - these rate tables require manual updates when agreements change.

How long does reconciliation take per carrier?

Manual reconciliation time per carrier per month depends on carrier statement format and policy count. A carrier with 50 policies on IVANS ACORD 820 download takes 30-60 minutes to reconcile manually. A carrier with 150 policies and a PDF statement takes 4-6 hours. For a 10-carrier agency with mixed formats, total manual reconciliation takes 20-40 hours per month. With automation software, the same 10-carrier book takes 2-4 hours per month - primarily reviewing flagged exceptions and approving clean matches.

What should you do with unresolved exceptions at month-end?

Move them to a suspense account in your accounting system and maintain an open dispute log with the submission date, amount, and status. Do not close or write off unresolved exceptions until the carrier formally denies them or the lookback window expires. Review the open dispute log weekly. Send follow-ups at 30 days. Escalate at 60 days. If a dispute is denied, document the denial reason - if the same carrier denies the same type of correction repeatedly, the pattern may indicate a systemic issue with your carrier agreement or your AMS rate configuration.

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

Cut reconciliation time from 30 hours to 3. BrokerageAudit pulls carrier statements, matches them against your AMS policy data automatically, and tracks every dispute through to payment. See how it works →