Sales Commission Tracker
Track sales commissions per rep with four calculation models: flat-percent, tiered-percent (progressive brackets), base-plus-percent, and bonus-per-deal. Parse deals from CSV, compute per-rep totals, generate payout schedules (monthly/quarterly/annually), find top performers, detect commission caps, leaderboard, history (localStorage), shareable URL. 100% client-side.
About Sales Commission Tracker
Track sales commissions per rep with four calculation models: flat-percent, tiered-percent (progressive brackets), base-plus-percent, and bonus-per-deal. Parse deals from CSV, compute per-rep totals, generate payout schedules (monthly/quarterly/annually), find top performers, detect commission caps, leaderboard, history (localStorage), shareable URL. 100% client-side. Everything runs locally in your browser — your data never leaves your device.
How to use
- Enter your input in the tool above.
- Adjust any options to your preference.
- Use the Copy or Download buttons to save the result.
- Everything happens locally — your data never leaves your browser.
FAQ
How does the commission tracker work?
Enter your commission model (flat percent, tiered percent with progressive brackets, base-plus-percent, or bonus-per-deal) and paste deals as CSV: deal_name,sales_rep,amount,close_date,status. The tool parses each line, calculates commission for closed-won deals only, aggregates per-rep totals, and generates a payout schedule grouped by month, quarter, or year based on close date.
How is tiered commission calculated?
Tiered commission uses progressive brackets. Example tiers '0,5\n50000,10\n100000,15' mean: first $50k at 5%, next $50k ($50k–$100k) at 10%, anything above $100k at 15%. So a $75k deal earns $2,500 + $2,500 = $5,000 — not $7,500 (which would be flat 10% of $75k).
Can I export the commission report?
Yes. Copy the text report to clipboard, download it as a .txt file, or download the full deal-level breakdown (with commission and payout period per row) as a CSV file ready for Excel or Google Sheets.
What extra features does this tool have compared to others?
(1) Deal parser with field validation. (2) Four commission type calculators (flat, tiered, base+percent, bonus-per-deal). (3) Progressive tiered brackets. (4) Per-rep totals (deals, amount, commission). (5) Payout schedule generator. (6) Three payout frequency presets (monthly/quarterly/annually). (7) Status filter (all/closed-won/closed-lost/open). (8) Top performer finder. (9) Average commission per deal. (10) Text report renderer. (11) CSV export. (12) Copy + Download .txt + Download CSV. (13) History (localStorage, last 20). (14) Shareable URL. (15) Summary stats. (16) Payout period formatter ('Q3 2026', 'July 2026', '2026'). (17) Commission cap detector (warns if commission exceeds deal amount). (18) Rep leaderboard sorted by commission.
Is my data sent anywhere?
No. All commission calculations run locally in your browser. Deal data never leaves this device. History is stored in localStorage on this device only.
Related tools
Advanced Markup Calculator
Calculate markup, margin, retail price, cost with tax. 100% private. 100% private.
Annuity Calculator
Calculate annuity present value, future value, and payout with custom terms. 100% private. 100% private.
ARR Calculator
Calculate Annual Recurring Revenue from MRR, churn, and growth. 100% private. 100% private.