Guide • Commission reports
Reports and commissions for insurance brokers: how to organise them
Manual calculation of broker commissions is a major source of errors and conflicts. An organised system calculates the commission on each policy and adds it up in reports by insurer and by product, for clearer settlements without separate spreadsheets.
How commissions are kept under control (steps)
- Commission on each policy: when the policy is recorded, the commission is calculated automatically as the product's default rate multiplied by the premium.
- Recorded policy: it appears in the register, with its commission calculated.
- Renewal: the policy for the new period is recorded as a new policy, with its own commission calculated from the new premium.
- Settlement: when the insurer pays out the commission, you mark it as settled on the policy.
- Settlement report: commissions grouped by insurer and by product, for the current month and the last 6 months, including the current month, for discussion with insurers.
What reports and records you get in 4insurance
- Statistics panel: active policies, portfolio premiums and commissions, open claims files and renewals due in the next 30 days.
- Commission report: commissions grouped by insurer and by product, for the current month and the last 6 months.
- Renewals list: each renewal with its status (pending, notified, renewed, lost) — tracked by status, not as a retention report.
- Claims files: the status of each file and the amounts claimed and approved.