Report: Cancellation

The Cancellation Report allows you to identify carrier trends (companies non-renewing specific types of policies) or problem clientele (slow payers). Using this information you can react to these types of misplaced, or lost business. In addition, the report includes a totals row that sums each cancellation reason, for a quick review of how the business was lost.

Report Selections

What is this?

Cancellation Date Range

Cancellation Date Range	What is this?
Current Month	Use this option to select the current calendar month.
Select Dates	Use this option to type in, or pick from the date picker, a specific date range that is other than the current month.

Basic Policy Selection

What is this?

Executive

Select to include business for One, Multiple, or All (default) executives.

Representative

Select to include business for One, Multiple, or All (default) representatives.

Broker

Select to include business for One, Multiple, or All (default) brokers.

Type of Business

Select to include business for One, Multiple, or All (default) types of business.

Individual types of business choices are:

Benefits
Commercial Lines
Financial Services
Health
Life
Non-Property & Casualty
Personal Lines

Policy Type

Choose from the following types of policies:

All (default)
BOP
Monoline
Package

Policy type is selected in Basic Policy.

Line of Business

Select one or All (default) line(s) of business.

Only available if Monoline is selected for Policy Type.

Cancel Tran Type

Select one of the following options:

All (default)
Cancellation confirmation (XLC)
Cancellation request (XLN)

Cancel Tran Reason

Select to include One, Multiple, or All cancellation transaction reasons.

Cancellation Reason	What is this?
Agent/Company termination (non-ren)	Use this cancellation reason when you no longer represent the carrier insuring the policy. You need to cancel the policy and re-write with another carrier.
Broker of record change	Use when you are no longer the "Broker of Record". You will cancel the policy and another agent will re-write. In this case the insured signed an official "Broker of Record", changing the agency with which they do business.
Business Sold	Use when the insured's business is sold and there is new ownership. The policy needs to be re-written for the new business, if applicable.
Insureds request	Use when your insured has requested the policy cancellation.
Non-payment	Use when the carrier has cancelled the policy for non-payment.
Not taken	Use when the policy is presented to the insured and they opt not to purchase the coverage.
Other	Use when none of the other listed cancellation reasons apply.
Out of business	Use when the insured goes out of business. The policy is canceled because coverage is no longer needed.
Payment received	Use when the insured's premium payment is too late for reinstatement.
Rewritten	Use when the original policy has canceled and needs to be rewritten.
Underwriting reasons	Use when the carrier's underwriter cancels the policy for underwriting reasons.
Work Completed	Use when the work is completed on a project and the coverage is no longer needed. For example, a contractor insures the construction of a home. When the home is built, the contractor's insurance is no longer needed.

Customer Selection

Customer	What is this?
Customer	Search for a specific customer or choose All (default) customers.
Search	Use this link to search for a customer.
All	Check this option to print the report for all customers.
Status	Choose the status of the customers you want to print on your report. The options are as follows: All (default) Active Inactive

Company

Company	What is this?
Type	Select business for (All) companies, or you can select business for just Brokerage or Insurance companies.
Parent	Select business for One, multiple, or All (default) Parent companies. The choice of parent companies is dependent upon the Type of company selected.
Writing	Select business for One, multiple, or All default) Writing companies. The choice of writing companies is dependent upon the Parent companies selected.

Report Options

Report Options	What is this?
Sort Order	Select the primary sort for the report. Your options are as follows: Broker - No page breaks. Company - Page breaks between companies. Customer - No page breaks. Executive - Page breaks between executives. Representative - Page breaks between representatives. The secondary sort is ascending order by the cancellation effective date.
Report Totals Only	Check this option to only see the totals for the report criteria selected.
Print Cover Page	Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.
Description	Accept the default description, or enter a new one that describes the report you are requesting.

Report Fields

Description

Customer Name

If a customer has both a firm name and a first and last name, then the Firm Name prints first followed by the DBA name, if entered, and then the Last Name, First Name.

Business with Agency

A one-letter abbreviation identifies the business the customer has with the agency. The translations are as follows:

P = Personal
C = Commercial
L = Life
H = Health
B = Benefits
F = Financial
N = Non-Property & Casualty

Policy Personnel

The Executive, Representative, and Broker (if applicable) assigned to the referenced policy.

Policy #

The number of the cancelled policy.

Term

The effective and expiration dates of the referenced policy.

Company

The parent company for the cancelled policy.

Total Cost

The sum of all the premium columns for the entire policy and non-premium rows for fees and taxes only. Does not include financed non-premium rows or down payments.

It also excludes rows where "Do not include in premium totals" is marked.

Full Term Premium

The amount entered in the Full Term Premium field on the policy transaction.

Transaction Effective Date

The effective date of the cancellation.

Type

The Type of transaction (e.g., Cancellation Confirmation or Cancellation Request).

Reason

The Reason selected for the cancellation.

Description

The Description entered for the cancellation.

Tran Premium

The premium entered for the transaction.

Invoice Detail for this transaction

Field	What is this?
Invoice #	The invoice number for the cancellation transaction.
Date	The invoice effective date of the cancellation transaction.

Total Cancellations by Reason

The report summarizes total cancellations by Cancellation Reason and reports these totals at the end of the report. Totals appear for the following reasons:

Agent/Co Termination
Broker of Record
Insured Request
Non-Payment
Not Taken
Out of Business
Other
Payment Received
Rewritten
Business Sold
Underwriting Reasons
Work Complete

CSV Columns

Description

Transaction Date

The date the cancellation transaction is effective.

Policy Number

The number of the cancelled policy.

Type

The type of transaction (e.g., Cancellation Confirmation or Cancellation Request).

Reason

The reason selected for the cancellation.

Transaction Description

The description entered for the cancellation.

Transaction Premium

The premium entered for the cancellation transaction.

Entry Type

Identifies how the policy was entered in AMS360. Types include:

Field	What is this?
Data Entry	The policy was created by selecting New Policy, Copy Policy, or Renew/Rewrite and the data was typed into the system.
Download	The policy was created by an electronic download from the company.
Conversion	The policy was created by converting data from another management system.
AL3	The policy was created by importing information from an integration partner such as QuoteWorks or AMS Producer Plus.

Customer - Firm Name

The Firm Name entered for the commercial customer.

Customer - Last name, First name

The Last, First Name entered for the personal or commercial customer.

Policy Term

The effective and expiration dates of the referenced policy.

Company

The parent company for the cancelled policy.

Company Type

The type of company identified and assigned to the policy.

Insurance
Brokerage
Subscription

Writing Company

The writing company entered for the cancelled policy.

Company Underwriter

The underwriter selected on the policy transaction.

Policy Notation

The notation assigned to the policy transaction.

Policy Flag

The current status of the referenced policy (e.g., cancelled, rewritten, not taken).

Policy Type

The type of policy selected in Basic Policy Information.

Bill Method

The method of billing selected for the policy (e.g. agency bill, direct bill).

Total Cost

The sum of all the premium columns for the entire policy and non-premium rows for fees and taxes only. Does not include financed non-premium rows or down payments. It also excludes rows where "Do not include in premium totals" is marked.

Full Term Premium

The amount entered in the Full Term Premium field on the policy transaction.

Invoice #

The invoice number for the cancellation transaction.

Invoice Date

The invoice effective date of the cancellation transaction.

Policy Executive

The Executive, Representative, and Broker (if applicable) assigned to the cancelled policy.

Policy CSR

Policy Broker

Business with Agency

A one-letter abbreviation identifies the business the customer has with the agency. The translations are as follows:

P = Personal
C = Commercial
L = Life
H = Health
B = Benefits
F = Financial
N = Non-Property & Casualty