Commission Tracking Spreadsheet
Download free commission tracking templates for Google Sheets and Excel. Flat rate, tiered, and multi-rep split templates — no signup required.
| Rep Name | Deal | Amount | Close Date | Rate | Commission | Status |
|---|---|---|---|---|---|---|
| Sarah Chen | Acme Corp | $85,000 | 2026-01-15 | 10% | $8,500 | Paid |
| Marcus Rivera | TechFlow | $42,000 | 2026-01-18 | 10% | $4,200 | Paid |
| Sarah Chen | DataSync | $120,000 | 2026-02-03 | 12% | $14,400 | Pending |
| Jake Morrison | CloudBase | $65,000 | 2026-02-10 | 10% | $6,500 | Pending |
| Marcus Rivera | SignalHub | $38,000 | 2026-02-15 | 8% | $3,040 | Draft |
Total Commission
$36,640
Reps Tracked
3
Avg Deal Size
$70,000
Choose a Template
Track deals and calculate flat commission. Best for teams with a single commission rate.
Track deals with graduated commission tiers. Best for teams with accelerators.
Track deals with commission splits between reps. Best for teams with SDR/AE handoffs.
No signup required. Template is yours to keep.
- More than 15 reps
- Multiple commission plan types running simultaneously
- Tiered rates with quarterly resets
- Commission splits on most deals
- Reps asking "how was my commission calculated?" regularly
- Monthly close takes more than 2 hours
- You've found errors after paying out
When spreadsheets stop scaling, Carvd automates commission calculations from your CRM data.
| Industry | Low | Average | High |
|---|---|---|---|
| Spreadsheets | 1% | 8% | 15% |
| Basic Software | 15% | 30% | 50% |
| Mid-Market Software | 50% | 100% | 200% |
| Enterprise Software | 200% | 500% | 1000% |
How to Use the Commission Tracking Spreadsheet
- 1Preview the sample commission tracking data to understand the template structure.
- 2Select a template: Basic Flat Rate, Tiered Commission, or Multi-Rep Split.
- 3Click 'Copy Google Sheets Template' or 'Download Excel' to get your copy.
- 4Replace the sample data with your own deals and reps.
Flat Commission (Spreadsheet)
=deal_amount * commission_rateBasic formula used in the flat rate template. Apply to each row.
Tiered Commission (Spreadsheet)
=SUMPRODUCT(MIN(deal_amount, tier_ceiling) - tier_floor, tier_rate)Nested formula for tiered commission. The template handles this automatically.
Split Commission (Spreadsheet)
=total_commission * split_percentageDivides total deal commission between primary and secondary reps.
Frequently Asked Questions: Commission Tracking Spreadsheet
Related Resources
Tired of calculating commissions manually?
Carvd automates commission tracking for your whole team. Upload deals, set comp plans, and let every rep see their earnings in real time.
Free for up to 5 reps. No credit card required.