Bonus and Commission Calculation Audit
Check calculations against the plan rules.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Recalculate commissions. Plan rules: [COMMISSION_PLAN]. Sales data by code: [SALES_DATA]. Amounts paid: [AMOUNTS_PAID]. Apply the rules, show the calculation for each person code, compare with paid amounts, and flag differences and ambiguous rules. Check cut-off dates and returns or cancellations. Return a table, the total difference, a list of unclear rules to clarify in writing, and a dispute process. Plan terms may be contractual and need review [VERIFY]. Add a worked recalculation: plan pays 5 percent of sales over 10,000 up to 50,000. Person code 08 sold 42,000, so commission = 5 percent x (42,000 - 10,000) = 1,600; paid 1,800, a difference of 200. A returned sale of 3,000 in the same period may reduce the figure: 5 percent x 3,000 = 150. Present unclear rules as questions. Add a dispute process. Add a worked error check: a person code sold 42,000 and the plan pays 5 percent of sales over 10,000, giving 1,600; the payment was 1,800 because the threshold was applied to 38,000 instead of 42,000 minus returns. Provide a dispute process: written query, review within ten working days, correction in the next payroll with an explanation. Keep the plan rules in a single versioned document.
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.