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 starting point

Set up your scheme

Insurance agency commission

Use the same currency and period for every amount. Changing these labels does not convert your figures.

Combined agency commission income target.

Optional payout cap

Leave blank for no cap. A zero cap pays no variable commission. Base pay is added separately.

Free to use. No account needed.

Your payout preview

monthly · USD

Total earnings for this period

$10,000.00

$2,500.00 base pay + $7,500.00 variable pay

Target attainment

100%

Effective variable rate

25%

Commission calculation breakdown
CalculationEligible amountRateCommission
New-business agency income$20,000.0030%$6,000.00
Renewal agency income$10,000.0015%$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.

80% of target$8,500.00

$24,000.00 eligible amount · $6,000.00 variable pay

100% of target$10,000.00

$30,000.00 eligible amount · $7,500.00 variable pay

120% of target$11,500.00

$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 templates

Formula 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.

Up to 20 users Free onboarding Access within 24 hours
Request your free trial
Perslace commission dashboard on desktop and mobile

Explore another commission structure