Commission operations ·
How to Match Insurance Carrier Commission Statements to Bank Deposits
By SplitVerde editorial team · Insurance agency operations
Match carrier commission remittances to bank deposits without hiding policy-level discrepancies. This guide focuses on the evidence and practical steps needed to make the result trustworthy.
Separate three different reconciliations
Policy reconciliation compares expected and carrier-reported transactions. Remittance reconciliation explains the carrier's net payment. Bank reconciliation confirms what actually reached the account. A matching deposit does not prove every policy was paid correctly. Store statement period, remittance reference, deposit date, and bank amount separately so differences can be investigated without rewriting the underlying policy transactions.
Before treating a number as final, ask which source supports it and what period the source covers. A policy effective date, a carrier statement date, and a bank deposit date can all be different. Keep those distinctions explicit. If a carrier changes a schedule or revises a statement, retain the prior evidence and record the reason for the new interpretation. A reviewer should be able to reproduce the conclusion without relying on someone's memory or a screenshot of a summary total. This discipline matters most when an apparent discrepancy crosses month-end or affects producer compensation.
Calculate the statement net
Sum positive commissions and negative adjustments using their original signs. Check whether the carrier includes fees, prior-period offsets, or other noncommission items in its remittance. Some carriers may combine multiple statements in one deposit or split a payment. Do not assume one statement always maps to one bank entry. Preserve the payment advice and source file because the remittance explanation may not be visible in the transaction rows.
Be careful with the difference between missing information and a confirmed error. A blank field, absent statement, or uncertain matching key does not prove the carrier underpaid. It means the record needs investigation. Mark that status clearly, assign ownership, and keep a next review date. This protects the agency from wasting time on false alarms while ensuring real shortages remain visible. When asking a carrier for help, provide the policy reference, relevant period, expected amount, and the evidence behind the question.
Find the deposit with evidence
Use carrier identity, payment reference, statement period, amount, and deposit date to identify the corresponding bank activity. Deposit descriptions can be abbreviated and settlement dates can differ from statement dates. Where several statements are paid together, list each contributing remittance rather than forcing a one-to-one match. Keep unexplained cash differences in a separate exception queue from policy commission shortages.
An accurate reconciliation can still be incomplete if the input is wrong. Validate imported transaction counts and signed totals against the original statement. Inspect a sample of negative adjustments and identifiers with leading zeros. A matching grand total can hide two offsetting policy errors, and a successful upload does not guarantee correct extraction. Stop when a source validation fails; otherwise the matching engine may produce dozens of convincing but meaningless exceptions. Preserve the failed import and the reason for correction.
| Policy | Expected | Reported | Difference |
|---|---|---|---|
| A | $200 | $250 | +$50 |
| B | $200 | $150 | −$50 |
| Total | $400 | $400 | Two exceptions |
Illustrative amounts, not actual carrier transactions.
Example: a forty-dollar gap
Suppose positive commissions total $5,000 and reversals total $180, giving a $4,820 net statement. The bank shows $4,780. Investigate the $40 gap through payment advice, other offsets, and settlement activity. Do not arbitrarily spread the difference across producer commissions. If the carrier documents a separate deduction, preserve that evidence and determine its accounting treatment with appropriate guidance. The cash discrepancy and policy-level commission discrepancies are different questions.
Build the workflow around distinct transaction states. Expected is not the same as reported; reported is not the same as deposited; a calculated producer share is not the same as an approved or transferred payout. These categories may be related, but merging them hides the cause of a delay. A useful dashboard shows where the transaction sits and which evidence is missing. That makes it possible to answer a producer's question without claiming money was received before it reached the agency.
Matching cash does not prove accuracy
Imagine two policies expected to pay $200 each. The carrier reports $250 on one and $150 on the other. The $400 deposit can be perfectly matched while both policies have $50 discrepancies. Keep those exceptions open. A carrier's correct remittance of its own statement net is not confirmation that the statement's individual commissions are right. This distinction is essential when agencies review producer payouts or missing renewals.
Negative amounts deserve the same attention as positive commissions. A chargeback may reflect cancellation, premium change, rewrite, or correction. Keep the original payment and the negative event separately with their own statement dates. Do not overwrite the original with the net result. Whether the negative event affects a producer payout depends on the governing agreement and applicable law. Record the investigation and approval rather than letting a spreadsheet formula silently decide compensation.
Archive an auditable payment trail
Save the carrier statement, remittance advice, bank reference, review notes, and unresolved variances. Record who reviewed the match and when. If a deposit arrives later, update cash status without changing the original statement date. If the carrier posts a correction next month, link that new transaction to the original exception. This makes the close reproducible for the bookkeeper and agency owner.
At the end of the period, retain the original statement, matching results, unresolved exceptions, carrier correspondence, and review decisions. Keep open items assigned to a person and a follow-up date. A promised correction is not verified until a later statement contains the relevant transaction. Bank-deposit matching should be performed separately from policy-level commission review. The objective is not to make every cell green; it is to create a reliable explanation for the money the agency expected, the carrier reported, and the agency actually received.
Frequently asked questions
Does a matching statement total mean every policy is correct?
No. Offsetting policy-level errors can produce the same grand total. Check each relevant transaction.
Should unresolved matches be automatically approved?
No. Keep uncertain matches visible until sufficient supporting evidence establishes the correct transaction.
Does a negative carrier commission automatically reduce producer pay?
Not necessarily. Review the applicable producer agreement and law before making compensation adjustments.
Related guides
Read our reconciliation overview, file format comparison, and monthly checklist.