Every reconciliation cycle produces exceptions — commission amounts that do not match, policies that cannot be found, payments that arrive without explanation. How quickly and systematically you clear those exceptions determines how much revenue your agency actually collects versus how much it writes off or loses track of entirely.
What Creates Exceptions?
Commission exceptions fall into four main categories. Amount mismatches occur when the carrier paid a different amount than your internal records expected — this could be a rate discrepancy, a premium error, or an unreported policy change. Policy not found exceptions arise when a statement row references a policy number that does not exist in your system, often because the policy was written under a slightly different identifier or was never imported. Missing payment exceptions occur when a policy is active and commission-eligible but the carrier paid nothing for that period. Duplicate payment exceptions happen when the same policy appears twice in the same statement or was paid in two consecutive periods without a valid reason.
Prioritize by Dollar Amount and Age
Not all exceptions deserve equal attention. Prioritizing your queue by a combination of dollar amount and age ensures your team works the highest-value items first. A reasonable severity framework: critical exceptions are over $1,000 and more than 30 days old; high severity covers exceptions over $500 or older than 60 days; medium covers anything over $100; low is everything under $100. Low-value exceptions that age past 90 days without resolution should be written off with a note rather than left in the queue indefinitely — the staff time to resolve them costs more than the exception itself.
Assign Ownership to Every Exception
Unowned exceptions get ignored. Every exception that enters your queue should have an assigned owner within 24 hours. Carrier relations issues — where you believe the carrier made an error — go to operations staff with carrier contact experience. Calculation errors that appear to be internal go to finance for review. Policy not found exceptions go to the agent of record for the policy in question. Clear ownership means accountability and prevents exceptions from sitting unworked for weeks.
The Five-Step Resolution Workflow
A structured resolution workflow ensures consistency and creates the audit trail you need for carrier disputes and compliance reviews. Step one is investigation: pull the original carrier statement row, check the policy record in your system, and verify the compensation plan that should apply. Step two is carrier contact: if the carrier appears to owe money, document your outreach with date, method, and representative contacted. Step three is resolution: post the correction as an adjustment entry, write off the exception with a note, or escalate to management if the amount warrants it. Step four is documentation: every resolved exception needs a note explaining what happened, what the correct amount should be, and how it was resolved. Step five is close: mark the exception resolved with a timestamp and the resolver's name.
Metrics to Track
Exception management metrics tell you whether your reconciliation operation is improving or deteriorating over time. Track average days to resolution by exception type — this reveals bottlenecks by category. Track exception rate as a percentage of total commissions processed — a healthy operation runs under 2%. Track recovery rate — what percentage of disputed amounts were ultimately collected versus written off. And track open exception aging — your 30/60/90/90-plus day breakdown tells you how stale your queue is getting. These metrics feed directly into the reconciliation health score that tells you whether your commission operations are under control.