Insurance agencies · Free editable template
Insurance agency commission plan template
Give new business and renewals separate producer shares. This example starts with the commission income received by the agency, then calculates the amount allocated to a producer.
Edit the sample below. No account needed.
Your payout preview
monthly · USDTotal earnings for this period
$10,000.00
$2,500.00 base pay + $7,500.00 variable pay
Target attainment
100%
Effective variable rate
25%
| Calculation | Eligible amount | Rate | Commission |
|---|---|---|---|
| New-business agency income | $20,000.00 | 30% | $6,000.00 |
| Renewal agency income | $10,000.00 | 15% | $1,500.00 |
What happens at different sales levels?
Same rates, base pay and cap. The new-business and renewal mix stays constant; a zero-income example uses new business.
$24,000.00 eligible amount · $6,000.00 variable pay
$30,000.00 eligible amount · $7,500.00 variable pay
$36,000.00 eligible amount · $9,000.00 variable pay
Illustrative planning calculation. Rates are editable examples. Eligibility, adjustments, taxes and approval rules need review before operational use. Variable pay is rounded after calculation.
Put your plan to work in Perslace
14 days free for up to 20 users. Free onboarding assistance. Trial access activated within 24 hours.
Request your free trial Explore all templatesFormula and worked example
Producer variable pay = new-business agency commission income × producer share + renewal agency commission income × renewal share.
If agency commission income is 20,000 from new business and 10,000 from renewals, a 30% new-business producer share and a 15% renewal share pay 6,000 + 1,500 = 7,500 in variable pay. A 2,500 base adds up to 10,000 in total earnings.
Keep premium and agency income distinct
Enter the agency’s commission income in this example, not the policy premium. If your plan pays directly on premium, use the base-plus-commission template with the appropriate eligible amount and rate, and document the different basis.
Define new business and renewal ownership
Specify which policy events qualify, who receives credit and which date determines the reporting period. Document how producer transfers, policy amendments and changes in carrier statements affect the eligible income.
Plan for adjustments and reconciliation
Agree how cancellations, returns and carrier adjustments are reviewed. This planning preview calculates positive eligible income for one period. Reconcile your operational sample and adjustment rules with the onboarding team before approving payouts.
Your plan. A working commission process.
Try Perslace free for 14 days
Test your commission process with up to 20 users and free onboarding assistance. We’ll activate your trial access within 24 hours of your request.
