Commission operations ·
Insurance Commission Reconciliation for New Agencies: Your First 90 Days
By SplitVerde editorial team · Insurance agency operations
A new insurance agency may have only a few policies, but its first commission statements can already be difficult to explain. Starting with a clean process is much easier than reconstructing six months of payments later.
Week one: define the records you need
Create a simple source-of-truth inventory containing carrier, policy number, insured, line of business, effective date, expected transaction type, commission basis, and responsible producer. Preserve policy identifiers as text so leading zeros survive spreadsheet imports. Store the original carrier agreement and compensation schedule alongside the agency's internal expectations. Avoid copying an assumed commission rate from a different carrier or line. The most useful first step is not buying complicated software; it is deciding what a correct transaction should look like and where the supporting evidence will live.
Choose a repeatable filing system
Create folders for carrier statements, agency policy exports, compensation schedules, exception correspondence, and producer payout approvals. Use filenames that identify the carrier and statement period. Retain the original statement even if you later clean a CSV or Excel export for matching. If you use a text-based PDF, check the extracted row count and signed total against the visible statement. A successful import is not proof that the columns were interpreted correctly. Consistent files save time when a carrier corrects a payment several months after the original period.
Month one: compare expected and reported transactions
For each carrier statement, compare individual policy transactions rather than only the net total. A carrier may report a new-business commission, renewal, endorsement, installment, or reversal against the same policy. Keep each event distinct. Record expected amount, reported amount, variance, and statement period. A transaction not yet due should not be treated as confirmed underpayment. If you cannot determine the applicable commission basis, flag the calculation for review. The goal of month one is a defensible baseline, not a dashboard that claims every row is matched.
A first-month example
Suppose your agency expects $100, $150, and $200 on three eligible policies. The carrier reports $100, $125, and $225. Both totals are $450, but two policies differ by $25. If you check only the deposit total, those discrepancies disappear. Review the individual policies and relevant schedule. Perhaps one expectation used the wrong premium basis; perhaps the carrier made an adjustment. Preserve both amounts until the reason is verified. The example is fictional, but the lesson is important for a new agency with a small transaction population.
Month two: make exceptions actionable
Give each unresolved item a policy reference, statement row, suspected cause, owner, and next follow-up date. Separate late or not-yet-eligible commission from unexpected negative entries, incorrect rates, and unmatched policy numbers. When asking a carrier about a discrepancy, include the precise statement period and the calculation behind your expectation. Save the response. If a representative says a correction will appear next month, leave the issue open until the later statement confirms it. A short exception log prevents the agency owner from relying on memory.
Month three: add cash and producer controls
Reconcile the carrier's remittance total with the bank deposit separately from policy-level correctness. A matching deposit does not prove each policy was paid accurately. If you have producers, document the agreement version and split basis before approving payouts. Keep calculated, approved, and actually paid amounts separate. A carrier chargeback does not automatically authorize a deduction from producer compensation; review the agreement and applicable law. These controls can remain lightweight while still preventing avoidable disputes.
Review the first ninety days
At the end of the third month, identify which carriers caused repeated mapping problems, unexplained reversals, or timing confusion. Confirm that no expected statement is missing. Archive the original source files, reconciliations, exceptions, and correspondence. Ask whether another person could reconstruct a randomly selected payment without calling you. If not, improve the references. The agency now has a practical monthly process that can grow with transaction volume without depending on increasingly fragile spreadsheets.
A small agency's first operating checklist
A founder can keep the process lightweight by reserving one recurring review window each month. Download statements from each carrier, save originals, compare the statement population with active and recently changed policies, and note unresolved cases. If a carrier has no statement for the month, record that explicitly instead of assuming there were no commissions. Repeat the same order each time so an interruption does not cause a missed step.
A practical starter register might contain policy reference, carrier, expected commission, expected cycle, carrier-reported amount, variance, and notes. Add a status field that distinguishes projected from reported and verified. Resist creating dozens of custom columns before you understand the carrier data. The first few statements will reveal which fields you actually need. Expand the workflow when volume warrants it, not merely because more features are available.
Keep the first ninety days' assumptions in writing. If a carrier pays on a net-60 basis, note how that timing was confirmed and which transactions it affects. If the schedule changes, preserve the old version for historical reconciliation. This documentation is particularly useful when the agency hires its first producer or administrative assistant, because they can follow an established process instead of recreating the owner's reasoning.
Practical checklist
- Keep original carrier statements and verify imported transaction totals.
- Document the calculation and timing basis behind expected amounts.
- Separate policy-level discrepancies from bank deposit differences.
- Assign unresolved issues to an owner with a follow-up date.
- Retain the original transaction when a later correction appears.
Frequently asked questions
Does a matching bank deposit prove every commission was correct?
No. Matching the remittance to the deposit is a cash control. Policy-level reconciliation is a separate review.
Should I overwrite a transaction after a carrier correction?
No. Preserve the original event and link the later correction to maintain a usable audit trail.
Can a negative carrier adjustment automatically reduce producer pay?
Not necessarily. Check the producer agreement and applicable law before changing compensation.
Related guides
Read the agency reconciliation checklist, commission KPIs guide, and producer payout overview.
The 7-day trial requires a payment card and renews unless canceled. No direct carrier integrations or scanned-image PDF OCR.