The Commission Actual vs Expected report shows comparisons of commissions your agency expects to receive and the commissions that were actually received for each policy in your account. This article covers the preconfigured standard report and includes a Custom Reporting recipe. You can use the recipe to build your own versions of the Commission Actual vs Expected report.
Note: Only accounts with the Commission Processing module can access and use AgencyBloc's commission features. To show expected commission data in this report, at least some of your policies need projection tables set up.
Standard Report details
Using the Commission Actual vs Expected report, you can find policies that brought in commissions within or outside a percentage (%) threshold of the expected commissions. Get a sense of how your policies are performing based on your calculations. Your report download will include information on the policy, policyholder, carrier, commission frequency and premium, servicing agent, and projection table.
|Within Expected:||Entering 5% within expected includes policies, where commission received, is 5% plus/minus the expected amount.
(Actual is between 95% to 105% of expected)
|Outside Expected:||Entering 5% outside expected includes policies, where commission received, is outside a threshold of 5% plus/minus the expected amount.
(Actual is 0 to 95% to 105% and beyond of expected)
This report has two options - year and monthly. The option you select will affect whether you see a summary of your AvE data or a month by month comparison of your projected commissions versus your actual commissions.
By using this option, your report output will show the year summary of your AvE data.
By using this option, your report output will show 24 additional columns - 1 column for expected and 1 for actual.
Note: This option will only show AvE projections for the past 12 months (not including the current month).
Custom Reporting recipe
With Custom Reporting, you can access the same data as the Standard Report but you’ll have more flexibility to choose the columns and filters for your report. Below is a recipe to help you get started.
Note: Custom Reporting currently does not have fields for Missing Holder State, Last 12 months Expected, Difference, % of Expected, and Within % of Expected.
- Select 'Policies' report type
- You cannot build this report using other Report Types. The Policy Commission Settings fields and Policy Projected Commissions fields are only available in the ‘Policies’ report type.
- Add report filters (optional)
- You can set filters to narrow down specific data that pulls into your report results. Visit the Adding Filters to Custom Reports article to learn more.
- Add report columns
Policy Details > Policy Info
- Carrier Name
- Policy Holder Name
- Policy Holder Type
- Policy Number
- Coverage Type
- Policy Status
- Project Code
Policy Details > Policy Dates
- Effective Date
- Renewal Date
- Term Date
Policy Details > Agent Info
- Servicing Agent Name
Related Options > Individual Details > Personal Info
- Birth Date
- Associated With
Related Options > Agent Details > Servicing Agent > Agency > Agency Info
- Agency Name
Related Options > Commissions > Policy Commissions Settings
- Advance Months
- Commission Frequency
- Commissionable Premium
Related Options > Commissions > Projected Commissions
- Projection Table
- Projection Amount
- Actual Amount
- Last 12 Months Actual
- You can rearrange the column order, rename the column headings, and use aggregate functions to change how the data is displayed in your report results. Visit the Adding Columns to Custom Reports article to learn more.
- Preview report results
- Visit the Previewing and Saving Custom Reports article for more details.