Open topic with navigation

This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

Related Topics Link IconR

Report: Producer/Broker

The Producer/Broker report lists information by employee or broker including the following:

ClosedAccessing the Producer/Broker Report

This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - All list, where you can make your selection.

Click Producer/Broker Report. This opens theReport - Producer/Brokerselection form. Make your selections, pull down the File menu and select to:

ClosedReport Selections

Report Selections

What is this?

Date Range

The Producer/Broker report is evaluated based on the later of invoice/invoice effective date for the date range selected.

Options

What is this?

From List

Use this option to select a predefined date range from the list. The default option is Current month minus 1.

Select Dates

Use this option to type in a specific date range not covered by the choices in the From Listoption.

Business Unit

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

Commission Person Type

The default is All, or you can select either Employee or Broker.

When you select All, both the Employee and Broker fields are available to select One, multiple, or All employee and/or brokers.

Employee

The default is All, or you can select a specific or multiple employees.

This field is only available when the Commission Person TypeisAllorEmployee.

Broker

The default is All, or you can select a specific or multiple brokers.

This field is only available when the Commission Person TypeisAllorBroker.

Report Type

There are four Report Types available:

Selection

What is this?

Billing Detail Report Totals Only

Billing details with totals by billing type and combined totals at the end of the report.

Sorting & Page Breaks

The report is sorted first by division, and then by producer/broker, by customer, and then by policy.

The report page breaks by producer/broker.

Report Includes:

  • Billing Details

Billing Detail with Reconciliation and Transaction Summary

This is the default selection.

Billing details with totals by billing type and combined totals at the end of the report.

Sorting & Page Breaks

The report is sorted first by division, and then by producer/broker, by customer, and then by policy.

The report page breaks by producer/broker.

Report Includes:

  • Billing Details

  • Reconciliation to the General Ledger

  • Transaction Summary

Billing Detail with Reconciliation Only

Billing details with totals by billing type and combined totals at the end of the report.

Sorting & Page Breaks

The report is sorted first by division, and then by producer/broker, by customer, and then by policy.

The report page breaks by producer/broker.

Report Includes:

  • Billing Details

  • Reconciliation to the General Ledger

Transaction Summary

Includes Transaction Summary information only.

ClosedBilling Details

Reports billing details for Agency Bill and Direct Bill business billed through the Customer Center, Direct Bill Commission Statement and the Direct Bill Entry Statement, with totals for each billing type and combined billing totals at the end of the Billing Details portion of the report.

Invoice transactions are reported if the later of the invoice date or invoice effective date is in the report date range for invoices billed in the Customer Center, and if the invoice transaction GL date is in the report range for invoices billed through the Direct Bill Commission Statement and the Direct Bill Entry Statement.

ClosedReconciliation to the General Ledger

Agency/Broker Policies

Reconciliation breaks out the commission payable posting and memo commission posting by Agency Policies (written by agency personnel) or Broker Policies (placed with the agency by an outside broker).

Billing Method

Transaction totals are also broken out by type of business; Agency Bill-Customer Center (ABI), Direct Bill-Customer Center (DBI), Direct Bill Commission Statement (CSI), and Direct Bill Entry (CEI) and whether commissions are memo or net.

Non-Billing Transactions

Non-Billing Transaction totals include checks, receipts and/or journal entries posted against the commissions payable account for the employee/broker. The activity for the selected date range is then totaled and listed in a reconciliation format including period beginning balance, plus/minus activity in period and resulting ending balance.

Reconciliation

The report-calculated ending balance is then compared to the actual general ledger balance for the producer/broker commission payable balance and any difference is noted.

Total Due Producer/Broker

Then, Employee Draw account transactions and Employee Expenses and Reimbursement transactions are detailed and totaled.

Finally a grand total of the commission payable balance, minus (-) any Employee Draws and plus/minus (+/-) any Employee Expenses & Reimbursement GL balances, is reported.

ClosedTransaction Summary

The Transaction Summary report evaluates billing details by transaction type (New Business, Renewal, Cancellation, etc.) and reports the results by billing category (ABI, DBI CSI and CEI). Combined totals are then reported.

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.

ClosedReport Fields

The Producer/Broker report page breaks by the commissioned person and each commission person's page is split by Agency Bill and Direct Bill business with totals for each. Following this is a grand total for each commissioned person for both agency bill and direct bill (ABI, DBI, CSI, CEI)

Billing Detail Header Rows

What is this?

Insured Name

Customer last, first name, or firm name.

Policy

Policy number.

Invoice

Invoice number.

Bdr

Field contains a "B" if the transaction is a binder.

GL Date

General ledger date.

LOB/Chg

Line of Business if premium; Charge code if non-premium.

Tran

Policy Transaction

A/B

  • A = Agency Customer

  • B = Broker's Customer

T

Personnel type of the producer/broker:

  • E = Exec  (plus "A" if additional personnel)

  • R = Rep   (plus "A" if additional personnel)

  • B = Broker

  • S = Sales Center

Prem/NPrem

Premium/Non-premium amount on the transaction.

Agcy Comm

Agency commission amount on the transaction.

P/B Comm

Producer/Broker commission amount.

Status

If the commission person on the transaction is a net broker, then "Net" appears in this field. If the commission person is an executive or representative, and the transaction is memo, then "Memo" appears in this field.

An asterisk (*) appears alone or immediately after the words "net" or "memo" if the data row is included in the average on the Summary page.

ClosedCSV Columns

CSV records report only for billing detail items. There is one CSV record for every detail record.

CSV Columns

Description

Commission Person

Employee or Broker's last name and first name. Broker Firm Name reported, if not an individual.

Division

Invoice Division.

Department

Invoice Department.

Insured

Customer last, first name or firm name.

Policy

Policy number.

Invoice

Invoice number.

GLDate

General ledger date.

LOB/Chg

Line of Business if premium; Charge code if non-premium.

TranType

Policy Transaction.

TranDescription

Transaction description (New Business/Renew Policy, etc).

PolicyBusType

Policy Business Type

  • A = Agency Bill / Center Billed

  • D - Direct Bill / Center Billed

  • E - Direct Bill / Direct Bill Entry Statement

  • S- Direct Bill / Direct Bill Commission Statement

PersType

Personnel type of the producer/broker:

  • E = Exec (plus "A" if additional personnel)

  • R = Rep (plus "A" if additional personnel)

  • B = Broker

  • S = Sales Center

Prem/NPrem

Premium/Non-premium amount on the transaction.

AgencyComm

Agency commission amount on the transaction.

WritingCompany

The writing company on the policy.

ProdBrokerMethod

The producer/broker commission method:

  • A - % of agency commission

  • P - % of premium/fees

  • F - flat rate.

ProdBroker%

Producer/Broker commission percentage.

ProducerBrokerComm

Producer/Broker commission dollar amount.

TotCommPaid

Total commission paid on the transaction.

IncForAvg

Is the item included in the calculation of average producer/broker commission rate? Y (Yes) or N (No).

Status

If the commission person on the transaction is a net broker, then "Net" appears in this field. If the commission person is an executive or representative, and the transaction is memo, then "Memo" appears in this field.

An asterisk (*) appears alone or immediately after the words "net" or "memo" if the data row is included in the average on the Summary page.

BinderIndicator

B if billing is a binder transaction; otherwise blank.

Branch

Invoice Branch

Group

Invoice Group.

My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com


© 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 10:58 PM