Commission and Sales-Representative Earnings Calculator
Use the Commission and Sales-Representative Earnings Calculator
Calculate tiered commission, quota attainment, draws, bonuses, clawbacks, deductions, and total representative earnings.
- Progressive commission tiers
- Revenue or gross-profit basis
- Quota and clawback visibility
Copy the approved commission plan exactly. Keep tier boundaries contiguous and use a blank upper limit only for the final tier.
What this calculator covers
Inputs you can model
- Currency
- Base salary or pay for the period
- Gross sales
- Returns, credits, and cancellations
- Commission basis
- Cost of goods sold
- Sales or gross-profit quota
- Progressive commission tiers
- Bonus
- Recoverable draw
Results you can review
- Net earnings
- Gross commission
- Commission-basis amount
- Quota attainment
- Effective commission rate
- Base pay
- Bonus
- Recoverable draw
- Clawbacks
- Other deductions
Method, policy basis, and limitations
How the estimate is built
Commission is applied progressively to the selected net-revenue or gross-profit basis. The result then adds base pay and bonus before subtracting draws, clawbacks, and other deductions.
Important limitation
This is a compensation-plan estimate, not a payroll statement. Plan eligibility, split credit, collection conditions, cancellations, caps, accelerators, taxes, and approval status must be confirmed separately.
Your inputs
Enter the values you know. Required fields should be completed first, and optional fields can be left blank if they do not apply to your situation.
Run the calculator to see the planning signal, key measures, reconciliation detail, and any schedules or stress scenarios returned for these inputs.
Your results
The top cards show the most important answers first. Detailed schedules, scenario tables, and supporting notes appear underneath for deeper review.
Inputs changed. Run the calculator again to refresh these results; copy, print, PDF, and Excel actions are unavailable until then.
This is a compensation-plan estimate, not a payroll statement. Plan eligibility, split credit, collection conditions, cancellations, caps, accelerators, taxes, and approval status must be confirmed separately.
