Find unpaid members
The commission you’re most likely to lose is the commission for members the carrier simply never paid you for — a member who’s active in your book but missing from the statement. CommissionSight finds them. Open Unpaid members from the account menu (it’s a tab under Audit).
The three find-money questions
CommissionSight answers “am I getting all my money?” with three reports, each built on different evidence and each catching a failure the others can’t. This page is the third.
| Report | Question it answers | Evidence it uses | What it catches |
|---|---|---|---|
| Chargeback proof-out | Was the money they took back legitimate? | Statements vs. statements | Clawbacks with no prior payment; multi-month over-reversals |
| Payment gaps | Which months did they skip mid-stream? | A member’s own payment timeline | Months with no record between two paid months |
| Unpaid members (this page) | Who did they never pay at all? | Your roster vs. statements | Members missing from the statements entirely |
The first two run entirely off your loaded statements. But statements can’t reveal a member who never appears in them — and a member whose payments simply stop looks like normal churn. Those are exactly the cases this report exists for, and why it’s the only one that asks you for something: your active-member roster is the outside ground truth the statements can’t provide.
How it works
- Upload your active-member roster (a CSV exported from your AMS / CRM). Pick which column holds the member/policy id — CommissionSight guesses it, and you can pick the name and plan columns too.
- Pick the carrier and period. We compare your roster to who the carrier actually paid on that statement, matching by member id or policy number (case- and space-insensitive). This matters more than it sounds: your AMS almost always knows members by policy number, while many carriers pay under their own member id — two id systems for the same person. CommissionSight checks both, so a member is never reported “unpaid” just because your roster and the carrier’s statement key them differently.
- See the gap. The members in your roster the carrier didn’t pay, an estimated recoverable (the count × the median commission of the members that were paid — so it needs no rate setup and is defensible), and a match rate. Export the unpaid list to CSV to take to the carrier. Because keying differences are already ruled out, every name on the unpaid list is a member genuinely absent from the statement — a real conversation to have with the carrier, not a data artifact to chase down first.
We also surface unrostered members — paid by the carrier but missing from your roster — which usually means a stale export, or a member you’d forgotten you had.
Save the roster (auto-reconcile)
You can reconcile once in memory, or save the roster for a carrier. Once saved:
- Reconcile any period against it without re-uploading.
- Track the unpaid trend across months.
The saved roster replaces the previous one for that carrier, and you can clear it any time. (Reconcile-in-memory still works if you’d rather not save anything.)
A note on complete data
Unpaid-member counts assume the statement you’re checking is complete. If a carrier’s month is missing or a statement loaded only partially, CommissionSight flags it with an incomplete-period warning on the Audit page — load the missing statement before acting on the numbers.