A common reporting requirement for many insurance providers is to split written premium by property and liability (e.g., for year-end reporting to NAIC). In BriteCore, this corresponds to the property-specific and Policy Wide sections of the Policy Builder.
Step 1: Map required data sources
In this example, we need a report that shows:
- Annual Gross Property Premium (excluding earthquake-related Items)
- Annual Gross Earthquake Premium
- Annual Gross Liability Premium
For this report, we need to use the Item Inforce Premium data points as the base and use the Filter and Group By rules to get the Policy Level detail. Item Inforce Premium provides the amount of premium that was written for a particular item during the transaction.
Map your data by identifying your report columns and matching them with the relevant data set and corresponding data point.
|Report Column||Data Set||Data Points|
|Policy Number||Policies||Policy Number|
|Property Written Premium||Item Changes||Item Change Written Premium|
|Earthquake Written Premium||Item Changes||Item Change Written Premium|
|Liability Written Premium||Item Changes||Item Change Written Premium|
|Item Name (only for Details)||Items||Item Name|
|Item Inforce Premium||Item State||Item Inforce Premium|
Tip: Include the Item Name; it’s useful for report reconciliation purposes and will identify where the grouped premium figures come from.
Step 2: Identify required filters
- In most lines setups, you should exclude the Calculation Items from your report. For this example, we assume we should only consider Coverage Type items for the premium calculation.
- We only want premium bearing rows, so we need to filter out all rows for items without premium.
- We don’t need earned premium, so we can remove the Earned Only transaction type.
Step 3: Create report
- Complete the Define your Report screen.
- Select the following data points in the Choose your Data screen:
Rename columns by selecting each existing data point and typing a new name. Select the information icon to see the original data point label.
- In the Define Rules for your Data screen, add the following filters for your items:
- Add calculated columns for premium by type (Property, Liability, Earthquake).
- Add Data to Group By to get totals by policy (from items).
Tip: Always check the This is a summary group checkbox.
Step 4: Final result
The Details sheet contains all the item level premiums used for calculating the policy level premium. Since we specified This is a summary Group, the report creates a separate sheet with the details for the Summary.
The Summary sheet displays premiums broken down by policy numbers.