Contents: This report provides both detail and summary information on commission payments to agencies within a user specified month. Listed on the report is the following information:
Producer Code
Insured Name
Transaction Type (e.g., Renewal, Endorsement, No-Renewal, etc.)
Policy Number
Effective / Expiration Date
Payment / Premium (Note: The column does not include Premiums / Payments amounts if commission is not being paid on that amount. So, if commission is not being paid on any fees, the fee premium is not included.)
Commission Rate
Commission Dollar Amount (or amount of commission to be paid on the policy for the month)
After all policy level information is printed for each producer, the report has a Summary Section that is shown following the last producer. In this section, commission totals for all producers within the agency are totaled and included. Listed are the following columns:
Line of Business
Commission Paid (Written or Paid Premium)
Total Payments / Premium (including all fees, charges regardless if commission is paid or not on the fee or charges)
Fees / Charges Dollar Amounts (not subject to commission)
Payments / Premiums Subject to Commission (Note: This is the Total Payments / Premium column minus the Fees / Charges amount column
Commission Dollar Amount.
Sub-totals, by Producer within each agency, are displayed for: Payment / Premium dollar amounts and Commission dollar amounts for each producer. The producer number and producer name is shown on the Sub-total producer line.
On the Statement Summary, totals are displayed for the following: Total Payments / Premium, Fees / Charges (not subject to Commission, Payments / Premiums Subject to Commissions and Commission Dollar Amount.
Sorted By: The report sorts alphabetically by agency and begins a new page when the next agency prints.
Who Uses the Report: Accounting department to pay monthly commissions to their agents as well as show policy level monthly commission detail to their agents.
When to Run Report: If paying commissions on a monthly basis, the report should be run after End of Month has completed; however, if reviewing prior months commission performance, it can be run at anytime.
Input Parameters:
Month: Select
Year (YYYY)
Company / State (With an option for "All)
Agency (With an option for "All)