Report: Direct Bill Entry Statement

Fields/Options

What is this?

Company Type

Select the Company Type for your report. The default is All. Your choices are:

• All

• Brokerage

• Insurance

Company

The Company list fills based on your Company Type selection. Select one or all companies you wish to report on.

Division

Select one or all divisions you want to report on. This field is always available. The default is All.

Divisions in the list are subject to the users security.

Refresh  

Refreshes the statements available in the Statementlist, based on yourInsuranceandDivisionselections above.

Statement

Choosing a specific statement is only available if you select to report on one Insurance or one Brokerage company. It is necessary to click refresh after making your insurance/brokerage company and division choices.

Statement Date Range

Status

Select the Status of the statement(s) you wish to report on. Your choices are:

• All

• In Progress

• Posted

• Ready to Post

Primary Sort

Select the Primary Sort for your report (e.g., Customer). Then, choose the Secondary Sort for your report (e.g., Policy number).

Your data is sorted by customer. Within customer, the data sorts by policy number.

Secondary Sort

Override Transactions Only

To use this report as an audit report check this box to include only those transactions where the Direct Bill Entry Statement defaults were overridden/changed.

If this option is checked, be sure to un-check the Include Statement Adjustmentscheckbox as these two options are mutually exclusive.

Include Statement Adjustments

Check this box to include only those transactions where an adjustment was made outside the Direct Bill Entry Statement process.

If this option is checked, be sure to uncheck the Override Transaction Onlyoption. These two options are mutually exclusive.

Description

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

Print Cover Page

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

CSV Columns

What is this?

Company

This is the Parent Companyname for the direct bill entry transaction.

Division

This is the Divisionassigned to the direct bill entry transaction.

StmtDate

This is the date entered into the Statement Date field in the Direct Bill Entry data entry form.

You should enter the statement date from the company generated direct bill statement into this field.

Status

This is the Status of the statement.

• In Progress

• Posted

• Ready to Post

Description

This is the description of the statement, entered into the Description field on the Direct Bill Entry form. The object is to make this description meaningful so you can tell the difference between the AMS360Direct Bill Entry Statements.

GLDate

This is the date entered into the GL Datefield in the Direct Bill Entry Statement, and the date that the statement posts to the general ledger.

TotCoStmtAmt

This is the total premium and non-premium amount specified on the company generated commission statement.

TotCoStmtAgCm

This is the total agency commission amount specified on the company generated commission statement.

TotAgStmtAmt

This is the total agency premium and non-premium amount entered into the Direct Bill Entryform. This should eventually equal theTotCoStmtAmt.

TotAgStmtAgCm

This is the total agency commission entered into the Direct Bill Entryform. This should eventually equal theTotCoStmtAgCm.

Name

This is the Customer'sfirm name and/or last name, first name for the direct bill entry transaction.

Policy

This is the policy number on the direct bill entry transaction.

Deptname

This is the Departmentshort name associated with the direct bill entry transaction.

WritName

This is the Writing Companyname on the direct bill entry transaction.

TranEffDate

This is the Transaction Effective Date on the direct bill entry transaction.

TranDesc

This is thetransaction description, (e.g., NBS, RWL, PCH).

LOB

This is the Line of Businesson the direct bill entry transaction.

Plan

This is the company Planassigned to the direct bill entry transaction.

TypeOfBus

Based on the line of business, this is the type of business on the direct bill entry transaction. The options are:

• BenefitPoint - only available if your agency is licensed for BenefitPoint.

• Commercial Lines

• Financial Services

• Health

• Life

• Non Property & Casualty

• Personal Lines

IncomeGroup

This is the Income Group assigned to the direct bill entry transaction.

As you enter the transactions onto the statement, based on the Line of Business, the transactions are assigned anIncome Group.

• Financial Services Premium

• Life and Health Premium

• Other Premium

• Property and Casualty Premium

PolEffDate

This is the Policy effective date of the policy, on the direct bill entry transaction.

PolExpDate

This is the Policy expiration date of the policy, on the direct bill entry transaction.

Agcy%

This is the agency commission percent on the direct bill entry transaction.

AM'd

This is the agency commission method used on the direct bill entry transaction.

AgcyComm

This is the agency commission amount for the direct bill entry transaction.

Amount

This is the total premium or non-premium for the direct bill entry transaction.

Ov'd

A Yes in this column indicates that a commission change/override was made to the agency commission for this direct bill entry transaction.

A No indicates no changes were made to the agency commission for this direct bill entry transaction.

Branch

If business unit Branch was activated in Business Unit Setup, this is the Branch assigned to the direct bill entry transaction. Otherwise, this field is blank.

Group

If business unit Group was activated in Business Unit Setup, this is the Group assigned to the direct bill entry transaction. Otherwise, this field is blank.

Polid

The Polid is an internal code representing the Policy #for this direct bill entry transaction.