How insurance agencies lose commission revenue to carrier underpayments — and how to catch it

1. Step 1: Build a member-level expected-versus-actual comparison for each carrier

   Start by exporting your current book of business: every active policy, member, plan, effective date, and the commission rate you expect to earn. Most agencies keep this in their agency management system or a master spreadsheet. You need one row per member, not per group or employer. The goal is a complete roster of who should appear on this month's commission statement.

   Next, pull the commission statement from the carrier. Download the detailed member-level report, not the summary. You're looking for the line-item data: member name or ID, plan, premium, commission amount, effective date, and any adjustments or terminations. Many carriers bury this in a separate file or portal tab labeled "detail" or "transaction report." If the carrier only provides a group-level summary, request the member detail — you cannot reconcile accurately without it.

   Now compare the two lists side by side. For every member on your book-of-business roster, confirm they appear on the carrier statement with the correct plan, rate, and commission amount. Mark any member who is missing, underpaid, or showing an unexpected adjustment. This comparison is tedious when done manually, but it's the only way to catch the errors carriers don't flag. Agencies that skip this step and reconcile only at the group or total-dollar level routinely miss individual member underpayments that add up to significant money over time.

   Document every discrepancy in a tracking log: member name, expected amount, actual amount, difference, and the issue type (missing, wrong rate, unexplained termination, etc.). This log becomes your dispute file. Carriers require specific detail to process adjustments, and a vague "the total looks low" complaint goes nowhere. You need to say "Member Jane Doe, policy 123456, should have paid $45 but shows $0 — no termination notice was received."

2. Step 2: Identify the five most common underpayment patterns and flag them systematically

   Carrier errors cluster into predictable patterns. Once you know what to look for, you can scan a statement and spot problems in minutes. The first pattern is the silent drop: a member who was on last month's statement, is still active in your records, but vanishes from this month's payment with no termination notice. This happens when the carrier's enrollment feed lags or processes a cancellation you never approved. Every silent drop is lost revenue until you catch it.

   The second pattern is the rate mismatch: the member appears, but the commission amount is wrong. This occurs when the carrier applies an outdated rate schedule, uses the wrong plan code, or fails to process a mid-year rate increase. Compare the commission amount to the rate you contracted. If a member should pay $50 but shows $38, the carrier is using old data. These errors compound every month until corrected.

   The third pattern is the phantom termination: the carrier shows a member as terminated, but you have no record of the client leaving. Sometimes the carrier processes a termination request from the wrong group, applies a non-payment term to the wrong member, or backdates an end date incorrectly. You lose the commission, and often the first signal that the client is gone comes from the statement, not from the client. Catching phantom terminations early lets you intervene before the client is actually lost.

   The fourth pattern is the unexplained adjustment: a negative line item with no explanation, often labeled "adjustment" or "correction." These are frequently chargebacks for prior months, but without detail you can't verify if the chargeback is valid. Demand backup documentation for every adjustment over a threshold you set — many agencies use $100. Carriers sometimes apply adjustments in error or double-charge for the same issue.

   The fifth pattern is the missing block: an entire group or employer that should appear but doesn't. This is rarer but catastrophic when it happens. It usually means the carrier's commission system didn't receive the enrollment file, or the group was miscoded and routed to a different agency or producer. If a group that consistently paid last quarter is completely absent, escalate immediately. The carrier's payment window closes quickly, and you need to get the block reinstated before the cycle locks.

3. Step 3: Establish a 90-day dispute window and act on errors immediately

   Most carriers impose a dispute or correction window — typically 90 days from the statement date. After that, the commission is final and you cannot recover underpayments. This deadline is rarely advertised clearly, and many agencies discover it only after trying to dispute a six-month-old error. The operational discipline you need is simple: identify errors within two weeks of receiving the statement, and submit disputes within 30 days. Waiting until the end of the quarter or "when you have time" guarantees you'll miss the window on some errors.

   When you identify an underpayment, document it immediately in your tracking log with the statement date, the error details, and the dollar amount at stake. Then contact the carrier's commission or producer services team. Most carriers require disputes in writing via email or a web portal. Use the specific language the carrier needs: policy number, member name or ID, the month in question, what you expected, what you received, and the difference. Attach supporting documentation: enrollment confirmations, rate sheets, prior statements showing the member was active, or correspondence proving the client did not terminate.

   Carriers process disputes slowly. Expect 30 to 60 days for a response, and follow up every two weeks if you hear nothing. Keep a separate log of open disputes with the submission date, the carrier contact, and the expected resolution date. Agencies that don't track disputes lose them in the shuffle — the carrier never responds, the agency forgets, and the money is gone. Treat each dispute like an accounts-receivable aging report: anything open longer than 60 days gets escalated to a supervisor or your carrier account manager.

   Once the carrier approves the adjustment, verify it appears on a future statement. Carriers sometimes approve a correction but fail to process the payment, or they apply it to the wrong month or producer. Cross-check the adjustment amount against your dispute log. If the numbers don't match, reopen the case. This final verification step recovers money that agencies assume was paid but never actually arrived.

4. Step 4: Track recovered revenue and underpayment trends by carrier and product line

   Every dollar you recover from a carrier dispute is revenue that would have been lost. Start tracking total recovered revenue by carrier, by month. This metric tells you two things: how much money your reconciliation process is saving, and which carriers have the worst payment accuracy. If you recover $3,000 per month from Carrier A and $200 from Carrier B, Carrier A has a systemic problem that requires a different approach — either tighter monthly scrutiny or a conversation with your account manager about fixing their data quality.

   Break down underpayments by error type as well. If 70% of your disputes are silent drops, the carrier's termination feed is broken. If most errors are rate mismatches, their rate-schedule updates aren't reaching the commission system. Presenting this data to the carrier — "We've disputed 18 rate errors in the past three months totaling $4,500" — often triggers them to investigate and fix the root cause. Carriers don't want to process disputes any more than you want to file them.

   You should also track underpayment trends by product line. Medicare Advantage, group health, ancillary, and life products often run on separate commission systems within the same carrier. If one product line consistently underpays while others are clean, the issue is isolated and fixable. Knowing this lets you allocate reconciliation effort where it matters: spend more time on the product lines with high error rates and less on the ones that pay reliably.

   Finally, calculate the cost of not reconciling. Take your total recovered revenue for the past six months and divide by six to get a monthly average. That number represents the revenue you would lose every month if you stopped doing member-level reconciliation and went back to spot-checking. For most agencies, this number is large enough to justify the time spent on the process — or to justify investing in a tool that automates the comparison and flags errors for you. Tools like CommissionSight handle the member-level matching automatically and surface underpayments without the manual spreadsheet work, letting you focus on filing disputes and recovering money instead of hunting for errors.

5. Step 5: Build a carrier scorecard and use it to guide your book-of-business strategy

   Not all carriers are equal partners. Some pay accurately and on time, respond quickly to disputes, and maintain clean data feeds. Others underpay chronically, ignore disputes, and make reconciliation a monthly battle. You need a scorecard that ranks carriers on payment accuracy, dispute resolution speed, and overall ease of doing business. This scorecard informs where you grow your book and where you pull back.

   Start with payment accuracy: calculate the error rate as a percentage of total expected commission. If Carrier A should pay you $20,000 this month and you dispute $1,200 in errors, the error rate is 6%. Track this monthly and calculate a rolling three-month average. Any carrier consistently above 3% has a problem worth escalating. Carriers below 1% are reliable and worth prioritizing for new business.

   Next, track dispute resolution time: how many days from submission to payment. Some carriers resolve disputes in 30 days; others take 90 or never respond. If a carrier routinely ignores disputes or denies valid claims without explanation, that's a red flag. You're not just losing the disputed amount — you're losing the time your staff spends chasing unrecoverable money. Factor this into your cost of doing business with that carrier.

   The third dimension is operational friction: how hard is it to get the data you need? Carriers that provide detailed member-level reports in a consistent format every month are easy to reconcile. Carriers that change file layouts without notice, bury detail in PDFs, or require manual portal downloads add hours of work. Quantify this: if Carrier A takes 30 minutes to reconcile and Carrier B takes three hours, Carrier B is costing you real money in staff time every cycle.

   Use this scorecard in your business-development decisions. When a prospect asks which carrier you recommend, steer them toward the ones that score well. When you're deciding whether to keep writing a low-margin product line, factor in the reconciliation cost — a product that pays a small commission but generates constant disputes may not be worth the administrative burden. Some agencies have exited entire carrier relationships or product lines after realizing the operational cost exceeded the revenue. The scorecard makes that decision data-driven instead of emotional.

6. Step 6: Automate the member-level comparison and focus your time on dispute resolution and recovery

   Manual member-level reconciliation works, but it doesn't scale. As your book grows, the number of statements and members increases faster than you can add back-office staff. At some point, the manual process breaks: you fall behind, errors slip through, and you start losing money again. The solution is to automate the comparison step and focus your human effort on the high-value work — investigating flagged errors, filing disputes, and recovering revenue.

   Automation means using a tool that ingests your book-of-business data and every carrier statement, matches members automatically, and flags discrepancies. The tool does the tedious row-by-row comparison in seconds and surfaces only the items that need your attention: missing members, rate mismatches, unexplained adjustments, and silent drops. You review the flagged list, validate the errors, and file disputes. This cuts reconciliation time from days to hours and catches errors you would have missed manually.

   CommissionSight is built specifically for this workflow. You upload your carrier statements and book-of-business data, and the platform scores every member green, yellow, or red based on payment status and month-over-month changes. Red flags are underpayments, missing members, or unexplained drops. Yellow flags are rate changes or adjustments that may be legitimate but need review. Green means everything matches and no action is required. You work through the red and yellow flags, document the issues, and export a dispute-ready report to send to the carrier.

   The operational benefit is twofold: you catch more errors because the tool doesn't get tired or skip rows, and you free up staff time to focus on recovery instead of data entry. Agencies using automated reconciliation report recovering two to five times more underpaid commission than they did with manual spot-checking, simply because they're now seeing errors that were invisible before. The tool doesn't replace your judgment — you still decide which disputes to file and how to handle edge cases — but it eliminates the grunt work and ensures nothing falls through the cracks.

   If you're not ready to adopt a tool, at minimum standardize your manual process: use the same spreadsheet template every month, create a checklist for each carrier, and assign clear ownership for each step. Consistency reduces errors and makes it easier to train new staff when your reconciliation lead is out. But recognize that manual reconciliation has a ceiling: eventually, the volume will exceed your capacity, and errors will start slipping through again. Plan for automation before you hit that wall.