Every Dollar Your Agency Receives Should Go Somewhere. This Report Tells You If It Did.

Commission management has two sides that don’t always get looked at together. There’s the agency side — what your carriers paid you. And there’s the agent side — what you paid out to your producers. Most agencies track both, but fewer track whether they actually match.

That gap is where allocation errors live. An agent split that wasn’t configured correctly. A policy that processed without a split table assigned, so 100% defaulted to the House when it shouldn’t have. A bonus that posted to the wrong payment type and didn’t flow through to the agent who earned it. A manual adjustment that didn’t account for how it would affect the payout calculation downstream.

These things happen. In a busy agency processing dozens or hundreds of payments per month, they happen regularly. And because they don’t announce themselves — because the system continues processing and reports continue running and nobody flags a discrepancy — they can go undetected for months.

The Agency vs. Agent Commission Comparison report is Commission Tracker’s auditing tool for exactly this problem. It cross-references what your agency received from carriers against what was paid out to agents — including the portion retained by the House — and surfaces any payment where those numbers don’t reconcile. Run it for any date range, filter by carrier or agent or revenue group, and choose the report format that fits what you’re trying to do.

The most efficient place to start is the Discrepancy view. This is an exception-only report — it shows only payments where there’s at least a $1.00 gap between gross commission received and total commissions allocated. No matches, no noise, just the rows that need attention. In a well-configured agency this list should be short. If it isn’t, you’ve found something worth investigating before it compounds further.

Once you’ve identified discrepancies, the Reconcile Report gives you the full picture. It shows all payments for the period — matched and unmatched — so you can see exactly what was received, what was paid out, and whether the difference represents an intentional House retention or an unintended allocation gap. For agencies that want to work through this in a spreadsheet, the same data is available in a flat export format you can pull directly into Excel.

What this report is particularly good at is validating your split configuration without requiring you to open individual policies. If the comparison is consistently clean for most carriers but consistently shows discrepancies for one, that tells you something about that carrier’s table setup or how splits are assigned on policies associated with it. If the discrepancies appear for a specific agent across multiple carriers, that points to something about their split table configuration. The pattern in the data tells you where to look.

Most agencies that run this report for the first time find a few surprises — payments that the House absorbed when they should have been split, or agents who were paid on policies they weren’t supposed to be on. Neither is a crisis if you catch it early. Both become harder to resolve the longer they go undetected.

The goal isn’t to audit your team’s intentions. It’s to confirm that the system is doing what you configured it to do — that the rules you set up around splits and assignments and payment types are actually producing the results you intended. The Agency vs. Agent Commission Comparison report is how you verify that on a regular basis rather than hoping it’s right.

Every dollar your agency receives should have a destination. This report tells you whether it got there.