Commission Tracker Template
Calculate and track sales commissions by rep and deal.
What's Included:
- Deal-level commission log with rep, deal value, rate, and payout date
- Tiered commission rate structure with accelerators above quota
- Monthly and quarterly commission statements per sales rep
- Commission expense forecasting for budget and cash flow planning
Available Formats:
Download Free Template
Enter your email to download this template instantly. We'll also send you tips on financial management.
Commission tracking gets complicated fast, especially with tiered rates, accelerators, splits, and clawbacks. This template handles the complexity by applying the correct rate to each deal based on the rep's cumulative performance against quota, including automatic tier escalation.
The commission expense forecast is valuable for finance teams. By projecting commission payouts based on pipeline and quota attainment trends, you can budget accurately for this variable cost. Many businesses are surprised by how much commission expense increases when the sales team has a strong quarter—this template prevents that surprise.
How to Use This Template
Set Up Commission Structure
Enter your commission rate tiers—base rate, accelerator rates above quota, and any bonuses. The template applies the correct rate to each deal based on the rep's cumulative performance.
Log Closed Deals
For each closed deal, enter the rep name, deal value, close date, and any special commission terms. The template calculates the commission amount automatically.
Generate Commission Statements
At the end of each pay period, generate individual commission statements for each rep showing deal-level detail and total payout.
Frequently Asked Questions
How do tiered commission rates work?
Tiered rates pay a base percentage up to quota (e.g., 10%) and a higher rate (e.g., 15%) on deals above quota. Some plans pay even higher accelerators at 125% and 150% of quota. This template supports up to four tiers with automatic calculation based on cumulative deal volume.
When should commissions be paid—at deal close or at cash collection?
Best practice depends on your industry and cash flow. Paying at close motivates reps but creates risk if deals cancel. Paying at collection is safer but slows the incentive cycle. Some companies pay 50% at close and 50% at collection. This template supports configurable payout triggers.
Related Financial Resources
Tired of manual spreadsheets?
FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.
Try FiscalInsights Free