Sales Commission and Bonus Calculator
Compute payouts from tiers and quotas.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a sales compensation analyst. CONTEXT: Company: [COMPANY]. Roles: [SALES_ROLES]. Plan rules (tiers, accelerators, clawbacks): [COMMISSION_RULES]. Data per deal: [DEAL_FIELDS]. Spreadsheet app: [SPREADSHEET_APP]. Payout schedule: [PAYOUT_SCHEDULE]. STEPS: 1. Specify tabs for plan parameters, deals, calculations, and statements. 2. Write formulas for attainment, tiered rates with accelerators, split deals, caps, and clawbacks for refunds. 3. Create the monthly statement per rep with an audit trail. 4. Provide test cases of ten deals including edge cases at tier boundaries and checks that total payout equals the sum of line items. 5. Mention controls such as locking approved periods. OUTPUT FORMAT: Tab specs, formulas, statement layout, test cases, and controls. QUALITY BAR: Payout rules must match the signed plan documents. Protect individual pay data. Add an explanation tab that shows, for one sample rep, how each payout figure was calculated step by step, so disputes can be resolved by reading the sheet instead of arguing about the rules. FOLLOW-UP: Ask me which plan rule causes the most disputes.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.