Report: Billing Register

The Billing Register reports billings posted for a selected date range. The report is a valuable tool for verifying the accuracy of posted billing transactions.

This report does not include items billed through the Direct Bill Commission Statement, as these items are included on the Direct Bill Commission Statement report. In addition, corrections made to items originally billed on the Direct Bill Commission Statement via the Customer Center, are not reported.

Subscription billings are not reported at the company level for this report. See Viewing an Invoice if verification of subscription company assignment is required.

Report Selections

What is this?

Date Range

Options	What is this?
Current Date	This is the default, to allow for running the report on a daily basis.
Select Dates	Choose the Select Dates option if you want to enter a specific date range into the From / To fields. You can key in the dates or use the Date Picker.

Business Unit

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

Posted By

The default is (All) or a specific employee can be selected from the list.

This feature is especially helpful for spot-checking the billing accuracy of new employees.

Bill Method

The default is (All) or you may select to report only agency bill or direct bill invoices.

Installment Reporting

Defaults as unchecked. Check this box if you want to report all installments for posted billings.

If this option is not selected, reporting is summarized across installments.

Report Only Correction Billings

Defaults as unchecked. Check this box to print a report of corrected billings for the selected date, or date range.

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

Column Headings

These headings print on each page of the report and identify the information found in the corresponding columns/rows of detail information.

Column Heading

What is this?

PostBy

This is the employee login ID of the person (employee) who posted the billing.

Change

This field indicates if certain information that defaulted into the billing was overridden before posting of the billing. One or more of the following codes may appear in this field, separated by commas:

Code	What is this?
C	Defaulted agency commission changed.
E	Defaulted employee/broker commission changed.
B	Defaulted billing date changed.
S	A business unit split template or policy specific split was applied and used for the billing.

Use this code to identify system setups that may need updating so that information defaults correctly.

Insured

Customer name on the billing.

This field is formatted to fit the available space.

Writing

The writing company short name.

Tran

Policy Transaction Code.

LOB

The line of business short name.

BillDate

The billing date is the date entered into the Invoice Date field, in the Policy Transaction section, of the Invoice form prior to posting.

Eff/Inst

Reports the transaction effective date for Summary reporting and the invoice/installment effective date when Installment Reporting is a selected option.

Type

This field contains one of the following report labels identifying the type, or invoice action, that created the billing:

Label	Billing Type
Standard	Standard billing.
Binder	Binder billing.
RepBndr	Replace binder billing.
Correct	Billing correction.
ChgPers	Change personnel.
ChgCo	Change company.
ChgCm	Change commission. For commission corrections initiated from a company or commission payable statement or a direct bill statement.
Void	Voided invoice.

Inv

Invoice number.

For Summary reporting, when installments exist, this field displays the word "Instalmts".

Policy #

Policy number.

If this is a multi-entity billing, (ME) will precede the policy number.
If the Type of billing is a billing correction, change personnel, change company, change commission or void, the policy number is truncated to 10 characters and a billing message appears to the right of the policy number.

Prem/Non Amt

Gross amount of the premium/non-premium amount.

Agency Rate/Comm Amt

This is the agency rate and commission amount. Commission rates report as:

Rate Type	What is this?
%P	Percent of premium.
%A	Percent of agency commission.
FR	Flat rate of commission.
*	An asterisk at the end of the commission rate denotes a memo or net commission condition. Applies only to employee/broker commissions.

Comm Person Rate/Comm Amt

Name of the primary executive, the commission rate and amount.

Comm Person Rate/Comm Amt

Name of the primary representative, the commission rate and amount.

Comm Person Rate/Comm Amt

Name of the broker, if any. If no broker exists, then an additional exec, if any, reports. If no broker or additional exec exists, an additional rep, if any, reports.

This is the third commission person's rate and amount.

Only 3 commission persons are reported regardless of how many additional persons exist for the billing.

CSV Columns

Description

Division

Division name.

Department

Department name.

TemplateName

The name of the commission template on a policy.

BillPost

The invoice posting date.

Postby

This is the employee short name who entered the billing.

PostbyName

Last Name, First Name of the employee who entered the billing.

Insured

Customer firm name or last/first name.

Tran

Policy Transaction type.

BillDate

The billing date is the date entered into the Invoice Date field, in the Policy Transaction section, of the Invoice form prior to posting.

AMethod

Bill method:

ABI = Agency Bill Invoice

DBI = Direct Bill Invoice

Type

This column contains one of the following report labels identifying the type, or invoice action, that created the billing:

Label	Billing Type
Standard	Standard billing.
Binder	Binder billing.
RepBndr	Replace binder billing.
Correct	Billing correction.
ChgPers	Change personnel.
ChgCo	Change company.
ChgCm	Change commission. For commission corrections initiated from a company or commission payable statement or a direct bill statement.
Void	Voided invoice.

MultiEntity

Is this a multi-entity billing, Y/N?

Policy#

Policy number.

Change

This column indicates if certain information that defaulted into the billing was overridden before posting of the billing. One or more of the following codes may appear in this field, separated by commas:

Code	What is this?
C	Defaulted agency commission changed.
E	Defaulted employee/broker commission changed.
B	Defaulted billing date changed.
S	A business unit split template or policy specific split was applied and used for the billing.

ParentShortName

Short name of the parent company.

ParentCompany

Parent company name.

WritingShortName

Short name of the writing company.

WritingCompany

Writing company name.

LOBShortName

Line of Business short name.

LineOfBusiness

Line of Business description.

InvEffDate

Invoice effective Date.

Invoice

Invoice number.

Prem/NonAmt

Gross amount of the premium or non-premium.

ARate

Agency commission rate and method, or (FR) for flat rate

ACommAmt

Agency commission dollar amount.

1CommPersType

The first commission person's type.

1CommPersName

The first commission person's name.

1CommPersRate

The first commission person's commission rate and method.

1CommPersMemo/Net

For the first commission person, reports whether the commission is memo for employees. Y/N.

1CommPersAmt

The first commission person's commission dollar amount.

2CommPersType

The second commission person's type.

2CommPersName

The second commission person's name.

2CommPersRate

The second commission person's commission rate and method.

2CommPersMemo/Net

For the second commission person, reports whether the commission is memo for employees. Y/N.

2CommPersAmt

The second commission person's commission dollar amount.

3CommPersType

The third commission person's type.

3CommPersName

The third commission person's name.

3CommPersRate

The third commission person's commission rate and method.

3CommPersMemo/Net

For the third commission person, reports whether the commission is memo for employees or net for brokers. Y/N.

3CommPersAmt

The third commission person's commission dollar amount.

PolTranEff

Policy transaction effective date.

CorrectionMessage

Invoice Correction note.

GLBranch

Branch name.

GLGroup

Group name.

IsSplit

Reflects if the item has been split due to a business unit template used within the policy [indicated by "Y" or "N"].

Type

Indicates whether the line item is summary or detail.

TemplateName

The type or name of the Business Unit Split Template used on the policy.