Skip to main content

​
How to Export a Policy

Follow these steps to export a policy from the system:
Any filters applied on the Policies page will carry over to the export. Make sure to apply your desired filters before exporting.

​
Step 1: Filter Policies

  1. Select the Policies tab from the sidebar
  2. Click the Add Filters button to open the filter menu
  3. Select your desired filter criteria from the available options
  4. Click Add Filter to apply your selected criteria
  5. The filtered results will display only the policies matching your criteria

​
Step 2: Access Export Options

  1. Click the Actions dropdown in the top right corner
  2. Select Export Policies from the dropdown menu

​
Step 3: Configure Export Settings

  1. Verify that the policies you want to export are selected (you can see “All 236 policies” or your filtered selection)
  2. Save as Preset (Optional):
    1. Click the Save as Preset button to save your current field configuration
    2. Enter a name for your preset in the popup dialog
    3. Click Save to save the preset or Cancel to close without saving
  3. Add Fields to Export: Click on any field tags in the “Add Fields to Export” section to include them in your export
  4. Reorder Fields: Drag and drop the selected fields in the “Reorder Fields for Export” section to change the column order
  5. Click Export Policies to generate and download your export

​
Step 4: Download the Export

The export file will be automatically downloaded to your computer based on your browser’s download settings once you click Export Policies.

​
Exposure Rating Fields

This feature adds exposure rating fields to policy export. The exposure rating field values are populated with the values set on the primary insured. In other words, it’s as if all the primary insured fields became fields on the policy itself (during the export flow). This means that:
  • For Policy export, we use the primary insured field value for the given point in time of the export
  • Group fields get concatenated into one cell

​
Policy Amount Fields

Policy exports include several categories of amount-related fields. Understanding the differences between them is important for accurate reporting.
Rated amounts, billed amounts, and financial amounts can differ for the same policy. This is expected — each category serves a distinct purpose and reflects different amounts.

​
Rated Amount Fields

These fields reflect amounts calculated by the rating engine at the time of rating:
FieldDescription
Total PremiumThe total rated premium for the policy as calculated by the rating engine.
Broker CommissionThe total rated broker commission amount, calculated as Total Premium × Broker Commission Percentage.
[Modification fields]Company-specific modification adjustments (credits/debits) applied during rating, such as schedule credits or experience modifications. These fields are configured per company in the rating engine and vary by company.
[Tax fields]Company-specific tax amounts applied during rating, such as state or surplus lines taxes. These fields are configured per company in the rating engine and vary by company.
[Fee fields]Company-specific fee amounts applied during rating, such as policy fees or inspection fees. These fields are configured per company in the rating engine and vary by company.

​
Billed Amount Fields

These fields reflect amounts generated by the quoting process — that is, amounts on invoices created when a quote is bound. They only include amounts that have been billed through the system.
FieldDescription
Total BillThe total amount billed on the policy: rated premium plus all taxes and fees included on generated invoices.
Total PaidThe total amount paid against invoices generated by the quoting process.
FieldDescription
Broker Commission PercentageThe broker commission rate as a percentage (e.g., 15%). This is a rate, not an amount — it is the percentage used to calculate the Broker Commission amount field.

​
Note: Rated vs. Billed vs. Financial Amounts

AI Insurance tracks policy amounts in three distinct ways:
  • Rated Amounts (e.g., Total Premium, Broker Commission, modification/tax/fee fields): Amounts calculated by the rating engine per the policy terms. These reflect the intended premium and adjustments at the time of rating.
  • Billed Amounts (e.g., Total Bill, Total Paid): Amounts that have been invoiced and collected through the quoting process. Total Bill is the sum of premium, taxes, and fees on generated invoices. Total Paid is the total collected against those invoices.
  • Financial Amounts (e.g., Premiums - Total, available in financial exports): Transaction-based ledger totals from AI Insurance’s financial system. These track actual financial activity and can differ from rated or billed amounts when users create or edit transactions outside of the quoting flow.