CONNECT COMMISSION RECORDS TO THE SALE

Insurance Commission Reconciliation by Policy and Producer

Import carrier commission statements, match payments to recorded policies and producers, and bring missing or inconsistent records into one review queue.

Create a free account Find your best starting point

HOW THE RECORDS CONNECT

The Sold Policy Log supplies the records reconciliation checks.

Agents and administrators record their own sales in the Sold Policy Log. When an authorized administrator imports a carrier commission statement, Ins Cheat Sheet compares each statement row with those recorded sales using the policy number, carrier, and producer.

1
Agent records the salePolicy number, carrier, producer, premium, and effective date are saved in the Sold Policy Log.
2
Administrator imports the statementThe carrier's Excel or CSV columns are mapped before any rows are added.
3
Policies and producers are matchedEach payment is labeled matched, needs review, or unmatched.
4
Administrator reviews differencesExpected and paid commission can be compared before follow-up or accounting review.

WHAT IT INCLUDES

Built around real agency work.

Excel and CSV statement imports
Policy-number and producer matching
Expected-versus-paid commission variance
Matched, needs-review, and unmatched queues
Administrator-only compensation access

HOW IT FITS THE WORKFLOW

From source to next action.

1Download the template or select a carrier statement.
2Map the carrier's columns to the suggested commission fields.
3Import the statement and let Ins Cheat Sheet compare policy numbers and producers.
4Review variances and unmatched rows against carrier contracts and accounting records.

COMMON QUESTIONS

Know where the tool stops.

Can this connect commission records to policies and producers?

Yes. It compares imported policy numbers and producer details with the agency's Sold Policy Log, then labels each row matched, needing review, or unmatched.

Does a match prove the carrier paid the correct amount?

No. The workspace highlights the recorded difference. The carrier statement, contract, accounting records, and agency review remain controlling.

Can ordinary agents see agency commission statements?

No. Commission reconciliation is limited to the agency owner and authorized administrators.