Commission reconciliation is one of the most time-consuming — and most consequential — tasks for any BGA, MGA, or independent insurance agency. When done poorly, it leads to missed revenue, overpaid producers, and compliance exposure. When done well, it becomes a competitive advantage.
What Is Commission Reconciliation?
Commission reconciliation is the process of comparing what a carrier says it paid you against what your internal records say you should have been paid. Any gap is an exception — and exceptions cost agencies real money if left unresolved. For a typical BGA processing $2M/month in commissions, even a 2% discrepancy rate means $40,000/month in potential revenue at risk.
Step 1: Import Carrier Statements
Most carriers still deliver commission statements as CSV or XLSX files. The first step is getting those files into your system with consistent field mapping. Common fields include policy number, insured name, premium amount, commission rate, and payment date.
Key challenges at this stage: each carrier uses different column names and date formats; some split statements by product line or state; files can contain thousands of rows requiring bulk validation. A modern platform lets you save column mapping templates per carrier so you never re-map the same format twice.
Step 2: Match Statements to Internal Records
Once imported, each statement row needs to be matched to a policy in your system. Matching logic typically uses policy number as the primary key, with fallbacks to insured name + effective date. Confidence scoring automates high-confidence matches and routes low-confidence ones to a review queue.
Step 3: Identify and Work Exceptions
Exceptions fall into four categories: missing commission, underpayment, overpayment, and policy not found. Each should be prioritized by dollar amount and age. Learn more in our guide on Commission Exception Management.
Step 4: Approve and Close the Period
Once exceptions are resolved, the reconciliation period can be approved and closed — creating a locked snapshot with total carrier payments, expected commissions, variance, and all approved exceptions with resolution notes.
Best Practices
- Reconcile monthly, not quarterly — problems compound quickly
- Keep saved mapping templates for every carrier format
- Set exception aging alerts at 30, 60, and 90 days
- Never edit a closed period — use adjustment entries instead
- Export reconciliation reports for carrier dispute documentation