Report: Transaction

The Transaction report gives you the tool to review specific transactions for specific policies, or to see a list of policies with a specific transaction. For example, all policies with a transaction of New Business for a specific date.

Although it appears that this report can be used to forecast expected agency and producer commissions because it includes billed premium, the Production Analysis report is a better choice for that type of information.

You can use the Transaction report to review policy retention. Run an Expiration/Renewal report for a specific time period to show the number of policies that need to be renewed. Then run the Transaction report for the same time period to see the actual policies that have been renewed.

You can also use the Production Analysis report. For more information, see Production Analysis - Retention Reporting.

Report Selections

What is this?

Transaction Date Range

Options	What is this?
Current Month	Use this option to select the current calendar month.
Select Dates	Use this option to select a date range other than the current month. You can type it in or use the date picker.

Customer Selection

Options	What is this?
Customer	Select a specific customer or All (default) customers.
Search	Use this link to search for a customer.
All	Check this option to print the report for all customers.
Customers Added on or After	Select a date to limit the report to customers added on or after the date specified. You can type a date or select it from the Date Picker. The customer added date field is the date you enter a new customer, or the date you change the status of a prospect or suspect to a customer. To clear the date, use the backspace key or highlight the date and press delete.

Basic Policy Selection

Options

What is this?

Executive

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

Representative

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

Broker

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

Type of Business

Select One, Multiple, or All types of business (e.g., Commercial Lines, Personal Lines, Life).

Line of Business

Select to include business for One, Multiple, or All lines of business (e.g., Crime, Dwelling Fire, Private Passenger Auto).

Transaction Type

Select to include business for One, Multiple, or All transaction types (e.g., New business, Renewal, Policy Change).

Business Unit

Click the link to open the Business Unit Selections form and make your selections.

Company

Group/ Field	What is this?
Type	You can select All, (default), Insurance, or Brokerage companies.
Parent	You can select One, Multiple, or All (default) Parent companies. The available companies are subject to the Type selected above.
Writing	You can select One Multiple, or All (default) Writing companies. The available writing companies are subject to the Parent companies selected above.

Include Billed Premium

Check to include an additional row in the Company/Total Cost/ Premium column for Billed Premium.

Print Options

Options

What is this?

Show Detailed Information

The Detail report includes:

Customer Name
Business with Agency
Policy Personnel
Business Units
Policy #
Policy Term
Flag
Premium by Line of Business
Transaction Date and Time
Transaction Type
Transaction Description
Source of Entry
Company
Total Cost
Total Premium
Billed Premium (if selected)

Show Summarized Information

The Summary report displays summarized totals based on the selected sort option.

The report includes the following columns:

Includes	What is this?
Sort Option	The left-most column reflects the sort order of the report (broker, customer, executive, or representative).
Total Tran Premium
Total Tran Billed Premium	If the Include Billed Premium check box is checked, than this column appears. Otherwise the column is not on the report.
Total Clients	If sort order is other than customer.
Total Policies
Total Transactions

Report Options

Options

What is this?

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Sort Order

Select the primary sort for the report. Your options are as follows:

Broker
Page breaks between brokers.
Company
Page breaks between companies.
Customer (default)
No page breaks.
Executive
Page breaks between executives.
Representative
Page breaks between representatives.

If the primary sort is by customer, the report then sorts by policy #, and then by transaction date in ascending order.

If the primary sort is other than customer, the report then sorts by customer, then by policy #, and then by transaction date in ascending order.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Report Fields

Detailed Transaction Report

Report Fields

Description

Customer Name

If a customer has both a Firm Name and Last Name, then the Firm Name prints first followed by the DBA, if entered, then the Last Name and 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

Policy Personnel

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

Division

The Business Unit link invokes the Business Unit Selections form. This form allows you to select the appropriate Division and Department, and if checked in Agency Setup, allows you to choose the correct Branch and Group.

Branch

Department

Group

Policy #

The number of the referenced policy.

Term

The effective and expiration dates of the referenced policy.

If this is a continuous policy, then the word continuousappears in place of the expiration date.

Flag

The current status of the referenced policy.

Line of Business

The line(s) of business associated with the transaction.

Premium

The premium for the line of business.

If duplicate lines of business exist, then the premium is summarized by line of business.

Transaction Date

The transaction effective date.

Type

The type of transaction.

Example New Business, Renewal, Policy Change.

Description

The description entered for the transaction.

Source of Entry

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

Field	What is this?
Data Entry	The policy was created by selecting New Policy, Copy Policy, or Renew/Rewrite and the data was entered 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.
Import AL3	The policy was created by importing information from an integration partner such as PL Rating or Producer Plus.

Company

The parent company for the policy.

Total Cost

The sum of all premiums by line of business plus non-premium fees and taxes for the transaction.

This total does not include financed non-premium rows or down payments. It also excludes rows where "Do not include in premium totals" is marked.

Premium

The total premiums by line of business entered for the transaction.

Sub Totals

The detailed report subtotals when the sort is by Broker, Company, Executive, or Representative and gives you:

Sort Order	Policies	Transactions	Tran Premium	Tran Billed Premium
Broker	Total Policies by broker.	Total Transactions by broker.	Total Tran Premium by broker	Total Tran Billed Premium by broker.
Company	Total Policies by company.	Total Transactions by company.	Total Tran Premium by company	Total Tran Billed Premium by company.
Executive	Total Policies by executive.	Total Transactions by executive.	Total Tran Premium by executive	Total Tran Billed Premium by executive.
Representative	Total Policies by representative.	Total Transactions by representative.	Total Tran Premium by representative	Total Tran Billed Premium by representative.

Summarized Transaction Report

Report Fields

Description

When the Sort Entity is...

The First Column on the Report is...	What is this?
Broker	If the report sorts by Broker, then the report summarizes by the broker on the policy.
Company	If the report sorts by Company, then the report summarizes by the parent company on the policy.
Customer	If the report sorts by Customer, then the report summarizes by customer. If the firm name exists, it prints, otherwise, the customers last name, first name prints.
Executive	If the report sorts by Executive, then the report summarizes by the executive on the policy.
Representative	If the report sorts by Representative, then the report summarizes by the representative on the policy.

Total Tran Premium

The sum of all transaction premiums that meet the report selection criteria. If the Sort Order is company, broker, customer, executive, or representative, this total only includes the premiums for the specific sort entity.

Example If Company is selected ,the Total Tran Premium is the sum of all premiums for that parent company.

Total Tran Billed Premium

The sum of Customer Center and Direct Bill Statement transaction premiums that are billed and meet the report selection criteria. If the Sort Order is company, broker, customer, executive, or representative, this total only includes the premiums for the specific sort entity.

Example If Executive is selected ,the Total Tran Billed Premium is the sum of all premiums for that executive.

Total Clients

The total number of customers that meet the report selection criteria. If the Sort Order is company, broker, executive, or representative, this total only includes the number of customers for the specific sort entity.

Example If Representative is selected, the Total Clients is the sum of all customers for that representative.

This column is not available if the report is sorted by Customer.

Total Policies

The total number of policies that meet the report selection criteria. If the Sort Order is company, broker, customer, executive or representative, this total only includes the number of policies for the specific sort entity.

Example If Customer is selected, the Total Policies are the sum of all policies for that customer.

Total Transactions

The total number of transactions that meet the report selection criteria. If the Sort Order is company, broker, customer, executive or representative, this total only includes the number of transactions for the specific sort entity.

Example If Broker is selected, the Total Transactions are the sum of all transactions for that broker.

CSV Columns

Description

Transaction Date

The effective date of the transaction.

Policy Number

The number assigned to the policy.

Transaction

The type of transaction (e.g., new business, renewal, policy change).

Cancellation Reason

The reason for cancellation, if the transaction was cancellation.

Transaction Description

The description entered for the transaction.

Entry Type

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

How Entered	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.
Import AL3	The policy was created by importing information from an integration partner such as QuoteWorks or AMS Producer Plus.

Processed By

The short name of the employee who last processed a transaction.

Customer - Firm Name

The Firm Name entered for the commercial customer.

Customer - Last name, First name

The Last and First Name of the customer.

Policy Term

The effective and expiration dates of the referenced policy.

If this is a continuous policy, then the word "continuous" appears in place of the expiration date.

Company

The parent company for the policy.

Company Type

The type of company identified and assigned to the policy.

Insurance
Brokerage
Subscription

Writing Company

The writing company entered for the 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.

Policy Type

The Policy Type selected in Basic Policy Information.

Line of Business

The line of business associated with the transaction.

LOB Premium

The premium for the line of business.

If duplicate lines of business exist, then the premium for same LOBs are summarized.

Bill Method

The method of billing selected for the policy.

Agency Bill

Direct Bill

Transaction Premium

The premium entered for the transaction.

Total Cost

The sum of all premiums for all lines of business plus non-premium fees and taxes for the transaction.

This total 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 in the basic policy section of Policy data entry.

Billed Premium

The sum of Customer Center and Direct Bill Statement premiums for the transaction.

Policy Executive

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

Policy CSR

Policy Broker

Policy Division

The Business Unit to which the policy is assigned.

Policy Branch

Policy Department

Policy Group

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