Team Sales Commission Tracker

Run your entire producer team from one spreadsheet. Built for agency owners and sales managers who are tired of doing commission math by hand.

Each producer gets their own section and a live scoreboard — total premium, policies sold, tier, and net commission — with bar charts that update as you enter sales. The tiered commission engine is fully built (4% up to 15% based on volume), and it handles new business, rewrites at 50%, and chargebacks automatically. On top of that you get team analytics, multi-year premium history, and a carrier-production report, all pulling live from the monthly tabs.

Rename the agent sections to your team, enter premium and a type code (NEW / RW / CB), and the tiers, payouts, and dashboards do the rest. Set up for four producers and easily adjustable.

✓ Per-agent scoreboards with live bar charts

✓ Tiered commission math (4%–15%) auto-calculated

✓ Handles new business, rewrites & chargebacks

✓ Team, yearly & carrier production analytics

✓ Works in Excel and Google Sheets — instant download