How to build a monthly Property and Liability Premium Report – Tutorial

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 ColumnData SetData Points
Policy NumberPolicies
Policy Number
Property Written PremiumItem Changes
Item Change Written Premium
Earthquake Written PremiumItem ChangesItem Change Written Premium
Liability Written PremiumItem ChangesItem Change Written Premium
Item Name (only for Details)Items Item Name
Item Inforce PremiumItem 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

  1. Complete the Define your Report screen.
  2. 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.

  1. In the Define Rules for your Data screen, add the following filters for your items:

  1. Add calculated columns for premium by type (Property, Liability, Earthquake).

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