Report: Direct Bill Statement

The Direct Bill Statement Report assists you with reviewing and managing your direct bill business by providing a listing of direct bill entries recorded on AMS 360.

Access from the Company Center Quick Reports menu to compare to the company-produced statement where you can identify and correct any differences and errors.

Report Selections

What is this?

Company Type

Select All (default) to include direct bill commission statements for the company types listed below:

Brokerage
Insurance

When All is selected, the Company field is disabled. When a specific Company Type is selected, only those companies matching that particular company type are included in the Company list.

Company

This field is enabled when the Company Type is:

Brokerage
Insurance

Select one specific company or All companies for the selected company type.

When All is selected the Statement field is disabled. When a specific Company is selected, only the statements matching that particular company are included in the Statement list.

Division

Choose One or All (default) divisions.

The divisions appearing in the list are subject to division security. If the user has access to any of the departments in the division, then they have access to all of the direct bill statements in that division.

If All divisions are selected for printing, the report only includes direct bill statements belonging to divisions for which the user has security rights.

Statement

Statement Selection

The Statement combo is disabled when the Company = All.
If a specific company is chosen, then the Refresh button is enabled.
Select Refresh to fill the Statement combo with only those statements belonging to the selected company and divisions. Each statement row reports:
Company Name
Division Name
Statement Date
Statement Description
Status: (In Progress, Ready to Post, Posted)

You can select a specific statement or All statements.

If you select a specific statement, the Statement Date Range group and the Status field are disabled.

Statement Date Range

If you select a specific statement, the Statement Date Range group is disabled.

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default option is Current Date.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From List option.

Status

You can select All statements or just those with a specific status:

In Progress
Ready to Post
Posted

If you select a specific statement, the Status field is disabled.

Primary Sort

This field gives you the opportunity to re-sort the direct bill statement transactions before printing. You can sort by:

Customer
Effective Date
LOB/Chg - Line of Business for premium, Charge Code for Non-premium.
Policy Number
Writing Company

Your first opportunity to sort was in the build process.

Secondary Sort

Once a primary sort is selected you can also select a Secondary Sort. You can sort by:

Customer
Effective Date
LOB/Chg - Line of Business for premium, Charge Code for Non-premium.
Policy Number
Writing Company

Sorting the Direct Bill Commission Statement in the same format as the company statement makes it easier to spot errors or omissions.

Include Direct Bill Statement Adjustments

When you check this box, adjustments to the transactions on the statement appear after the Direct Bill Statement details.

There is no page break between the statement details and the adjustments.

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.

Report Fields

Description

Statement Information

Information in this section pulls from the General Information section of the Direct Bill Commission Statement.

Fields	What is this?
Description	The Description field in the Direct Bill Commission Statement form.
GL Date	General ledger date.
Comment	The Comments field in the Direct Bill Commission Statement form.
Company Statement Premium	These are the Premium, Fees & Taxes and Commission totals from your company-issued commission statement. These totals reflect all items on the statement as a whole. The goal on a statement is that the Company Statement Totals and the Agency Statement Totals agree before the statement is posted.
Company Statement Fees & Taxes
Company Statement Commissions
Agency Statement Premium	These are the Premium, Fees & Taxes and Commission totals that reflect all items on the statement as a whole. As items are added, removed or edited on the statement, the totals are updated to reflect changes. The goal on a statement is that the Company Statement Totals and the Agency Statement Totals agree before the statement is posted.
Agency Statement Fees & Taxes
Agency Statement Commission

Direct Bill Statement Billed Transactions

The Direct Bill Statement Billed Transactions, if any, appear first on the Direct Bill Commission Statement report.

Totals

These totals pull from the Statement Totals Detailed section of the Direct Bill Commission Statement form.

Fields	What is this?
Premium to Date	Cumulative total of all Direct Bill Statement Billed premium, taxes and fees, previously received on other accepted statements, relative to the items on this statement.
Fees & Taxes to Date
Premium Received	Cumulative total for all Direct Bill Statement Billed premiums, taxes and fees, and agency commission received on transactions in this statement.
Fees & Taxes Received
Comm Received

Detail

Detail output prints in the sort order designated on the report selection form.

Fields	What is this?
Name	The customer name on the transaction.
Policy	The policy number from Basic Policy, on the transaction.
WritCo	The Writing Company on the transaction.
EffDate	The transaction effective date.
LOB/Chg	This field reflects the Line of Business short name for premium transactions, and the Charge Code for non-premium (taxes/fees) transactions.
Tran	This is the Policy Transaction Code for the transaction.
Class	The classification for the commissioned person on the transaction (Broker, Exec, Rep).
ShortN	The short name for the commissioned person on the transaction.
Persn%	The commission percent on the transaction for the commissioned person.
M'd	The commission method used for the commissioned person on the transaction.
PersnComm	The dollar amount of commission earned by the commissioned person on the transaction.
Agcy%	The agency commission rate for the transaction.
AM'd	The agency commission method for the transaction.
AgcyComm	The agency commission amount received on the transaction.
Prem/Fee/Tax	The premium/fees/taxes received on the transaction.
Rec	Is the policy transaction fully reconciled (Yes/No). The letter 'M' also appears in this column if direct bill statement matching was successful on the item.

Customer Center Billed Transactions

The Customer Center Billed Transactions, if any, appear after the Direct Bill Statement Billed Transactions on the Direct Bill Commission Statement report.

Totals

These totals pull from the Statement Totals Detailed section of the Direct Bill Commission Statement form.

Fields	What is this?
Premium	Cumulative total of all customer center billed premium, taxes and fees, and agency commission for items on this statement.
Fees & Taxes
Agcy Comm
Comm Balance	Cumulative total of all customer center billed unpaid agency commission balances, commission received, and commission adjustments for items on this statement.
Comm Received
Comm Adjust

Detail

Detail output prints in the sort order designated on the report selection form.

Fields	What is this?
Name	The customer name on the transaction.
Policy	The policy number from Basic Policy, on the transaction.
WritCo	The Writing Company on the transaction.
EffDate	The invoice effective date.
LOB/Chg	This field reflects the Line of Business short name for premium transactions, and the Charge Code for non-premium (taxes/fees) transactions.
Tran	This is the Policy Transaction Code for the transaction.
Invoice	This is the invoice number for the transaction.
Prem/Fee	This is the total premium, fees and taxes for this invoice transaction.
Agcy%	This is the agency commission rate for this invoice transaction.
AM'd	The agency commission method for the transaction.
AgcyComm	This is the agency commission dollar amount for this invoice transaction.
CommBal	This is the unpaid agency commission for this invoice transaction.
JEAdjust	This is the journal entry adjustment made to the agency commission receivable/commission income accounts for the commission balance, if any, when the item is marked Reconciliation Complete.
CommRcv'd	This is the amount of commission received for this invoice transaction, per the company statement.
Rec	Is the accounting transaction fully reconciled (Yes/No).

Adjustments

Detail

Detail output prints in the sort order designated on the report selection form.

Fields	What is this?
Name	The customer name on the transaction.
Policy	The policy number from Basic Policy, on the transaction.
WritCo	The Writing Company on the transaction.
EffDate	The invoice effective date.
LOB/Chg	This field reflects the Line of Business short name for premium transactions, and the Charge Code for non-premium (taxes/fees) transactions.
Tran	This is the Policy Transaction Code for the transaction.
Description	The Description of the adjustment.
Invoice	This is the invoice number for the transaction.
Agcy%	This is the agency commission rate for the transaction.
AM'd	The agency commission method for the transaction.
AgcyComm	This is the agency commission dollar amount for the transaction.
Prem/Fee/Tax	This is the total premium, fees and taxes for the transaction.

CSV Columns

Description

Company

The company assigned to the direct bill commission statement.

Division

The division assigned to the direct bill commission statement.

StmtDate

The statement date assigned to the direct bill commission statement.

ThruDate

The through date that was specified on the Direct Bill Statement Modifiers form when the direct bill commission statement was created. Transactions that were smaller than or equal to this date pulled to the statement.

Transaction Type	What date?
Direct Bill Statement Billed Transactions	The through date looks at the policy transaction effective date of the transaction.
Customer Center Billed Transactions	The through date looks at the invoice effective date of the transaction.

Status

The direct bill commission statement status.

In Progress
Ready to Post
Posted

IncDB

When the direct bill commission statement was created, did you check the option to include Direct Bill Statement Billed Transactions, (Y/N).

IncCB

When the direct bill commission statement was created, did you check the option to include Customer Center Billed Transactions, (Y/N).

IncPers

When the direct bill commission statement was created, did you check the option to include Personal Lines transactions, (Y/N).

IncComm

When the direct bill commission statement was created, did you check the option to include Commercial Lines transactions, (Y/N).

IncNonPC

When the direct bill commission statement was created, did you check the option to include Non-Property & Casualty transactions, (Y/N).

GLDate

This is the date the direct bill commission statement will/has posted to the general ledger.

StmtComment

Is there a statement level comment? Yes/No.

BillType

The billing type for the direct bill commission statement transaction.

Billing Type Description	What is this?
StmtBill	Direct bill statement billed transaction.
Centerbill	Customer center billed transaction.

CustName

The customer name on the transaction.

PolicyNo

The policy number from Basic Policy on the transaction.

Writing

The Writing company short name on the transaction.

EffDate

The effective date of the transaction.

Transaction Type	What date?
Direct Bill Statement Billed Transactions	The policy transaction effective date.
Customer Center Billed Transactions	The invoice effective date.

LOB/Chg

The Line of Business short name for premium transactions, or the Charge Code for non-premium (taxes/fees) transactions.

Tran

This is the Policy Transaction Code for the transaction.

Direct Bill Statement Billed Transaction Columns

These columns pertain to transactions in the Direct Bill Statement Billed Transactions section of the Direct Bill Commission Statement.

Column	What is this?
DBPrem/Fee	The total premium, fees or taxes received on the transaction.
DBGross	The total premium, fees or taxes on the transaction.
DBGrossToDate	The cumulative total of all premium, taxes or fees previously received on other posted statements, relative to this transaction.
DBAgcyComm	The agency commission amount received on the transaction
DBAgcy%	The agency commission rate for the transaction.
DBAMd	The agency commission method for the transaction.
DBRecon	Is this transaction reconciliation complete, (Y/N)?
DBMatch	Indicates if a transaction is matched or unmatched to a company downloaded direct bill accounting transaction. M = Matched U = Unmatched

Customer Center Billed Transaction Columns

These columns pertain to transactions in the Customer Center Billed Transactions section of the Direct Bill Commission Statement.

Column	What is this?
Invoice	This is the invoice number of the transaction.
CBPrem/Fee	This is the total premium, fees and taxes for this invoice transaction.
CBAgcy%	This is the agency commission rate for this invoice transaction.
CBAM'd	The agency commission method for the transaction.
CBAgcyComm	The agency commission dollar amount for this invoice transaction.
CBCommBal	The unpaid agency commission for this invoice transaction.
CBJEAdjust	This is the journal entry adjustment made to the agency commission receivable/commission income accounts for the commission balance, if any, when the item is marked Reconciliation Complete.
CBCommRcvdToDate	The cumulative total of all commissions previously received on other posted statements, relative to this transaction.
CBCommAdjToDate	The cumulative total of all adjustments previously made on other accepted statements, relative to this transaction.
CBCommRcvd	The commission amount received for this invoice transaction, per the company statement.
CBRecon	Is the accounting invoice transaction fully reconciled, (Y/N)?

DB/CBComment

Does a transaction level comment exist, (Y/N)?

Custid

The internal customer ID.

Polid

The internal policy ID.