How to Track Insurance Commissions: A Step-by-Step Guide
Learning how to track insurance commissions properly is one of the fastest ways to recover revenue your agency has already earned. Commissions arrive from many carriers, on different schedules, in different formats — and when tracking is manual, small errors quietly add up to thousands of dollars in lost income every year.
This step-by-step guide shows you a reliable process for recording, reconciling, and reporting on commissions, whether you use spreadsheets today or dedicated insurance agency management software.
Why commission tracking matters
Every policy your agency writes carries an expected commission. The gap between what you should be paid and what actually lands in your account is called commission leakage, and it is remarkably common because no one is systematically checking. Accurate tracking closes that gap and gives you a true picture of which carriers, lines, and producers actually drive revenue.
The step-by-step process
- Record the expected commission when you write the policy. Capture the premium, commission rate, and payment schedule at the moment of sale, not months later.
- Standardize your data. Use consistent carrier names, policy numbers, and line-of-business labels so records match up cleanly later.
- Import or enter carrier statements as they arrive. Each statement lists what the carrier actually paid.
- Reconcile expected against actual. Match every expected commission to a payment and flag anything missing, short, or unexpected.
- Investigate and recover discrepancies. Follow up with carriers on shortfalls while the trail is fresh.
- Report on the results. Track total commission, leakage recovered, and performance by carrier and producer.
The single most important step is recording the expected commission at the point of sale. Without an expectation to compare against, reconciliation is impossible — you are just recording whatever the carrier happens to send.
Spreadsheets vs. dedicated software
Spreadsheets can work for a very small book, but they break down as volume grows: formulas drift, versions multiply, and reconciliation becomes a manual slog no one wants to do. Dedicated software records expected commissions automatically from your policy data and flags discrepancies for you, turning a full-day chore into a quick review.
If leakage is your main concern, read our focused guide on how to reduce commission leakage, and estimate your exposure with the free commission leakage calculator.
Stop leaving commission on the table
PolicyPilot records expected commissions automatically and flags carrier shortfalls so you recover every dollar you earn. Start a free trial.
No credit card required
Frequently Asked Questions
How do insurance agencies track commissions?
Agencies record the expected commission for each policy at the point of sale, then reconcile those expectations against carrier statements as payments arrive, flagging and recovering any shortfalls. Dedicated software automates the recording and matching.
What is commission reconciliation?
Commission reconciliation is the process of matching the commission you expected to earn on each policy against what the carrier actually paid, so you can catch missing or short payments.
Can I track commissions in a spreadsheet?
Yes for a small book, but spreadsheets become error-prone and time-consuming as volume grows. Dedicated agency management software records expectations automatically and flags discrepancies for you.