Free download
Free insurance commission tracker for agents.
A simple spreadsheet to track what each carrier should pay you against what it actually paid — policy by policy. Works in Excel and Google Sheets. No email required.
What the tracker covers
Carrier & policy number
So every payment ties back to one policy.
Line & product
Life, health, Medicare or ACA — rates differ by product.
New or renewal
First-year and renewal rates are rarely the same.
Premium, your rate or flat fee
Straight from your carrier contract.
Expected commission
Calculated for you: flat fee, or premium × rate.
Commission paid & difference
Paid minus expected. Negative means you were short.
How to use it
- 1. Add each policy. Carrier, policy number, insured, product and whether it's new business or a renewal.
- 2. Enter your contract rate. A percentage, or a flat dollar amount for products like ACA plans. Medicare Advantage and Part D pay set amounts each year.
- 3. Copy in what the statement paid. The difference column shows any shortfall right away.
- 4. Follow up on the negatives. Note the statement date and contact the carrier with the policy, premium, rate and amount short.
Tired of typing statements in by hand?
Commission Guardian reads carrier statements (spreadsheet, CSV or PDF) and checks every line for you — short payments, missed renewals, stale premiums and oversized chargebacks — with the math shown. Your first audit is free.