Report: Broker Receivable Activity

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

The Broker Receivable Activity shows all financial activity for a Broker based on the date range selected. It only reports broker invoice postings and may not be a complete financial summary for the customer, when that customer has broker and non-broker activity.

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 Broker Receivable Activity. This opens the Report - Broker Receivable Activity selection form. Make your selections, pull down the File menu and select to:

Print
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page

Report Selections

What is this?

Receivable Activity Date Range

All invoices with a non-zero balance equal to or greater than the Begin Date, and smaller than or equal to the End Date are included on the report.

In addition, if an invoice has a zero balance, but has had activity during the reporting period, it is included on the report along with any activity posted to that invoice.

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

Broker

You can select to include activity for OneorAllbrokers on the report.

Business Unit

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

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.

Whether the invoice activity is detailed or summarized on your report, is dependent upon the selection made in the Agency Setup, Premium and Non-Premium Grouping option.

You can find this option from any center or form with a Toolbox menu.

Click Toolbox > System Administration > Agency.
From the Agency Setup form, click the Name, Address and Phone Numbers section > Invoice/Customer Statement - Agency Forms Customization sub-section.
Then look in the Customer Default Settings group > Premium and Non-Premium Grouping field.

Detailed Report

Summarized Report

The Broker Receivable Activity report is sorted by:

Customer
then by On Account Transactions
then by Policy
then by Invoice Number
and then by transaction date.

Report Fields

Description

Broker Header Rows

Broker Header Rows	What is this?
Broker Name	Broker last name, first name, or firm name.
Bus Phone	Broker business phone number and extension, if any.

Customer Header Rows

Customer Header Rows	What is this?
Broker On Account	If there are on-account invoices for a broker, an On Account header row appears before any customer information. Since broker On Account invoices do not have a branch, department, or group, they are reported whenever the business unit selection includes the division matching the On Account invoice division.
Customer Name Master Customer Sub-customer	Standard Customer Prints the last name, first name, or firm name. Multi-Entity Customer Master Customer: Receivable Responsibility When the master customer has receivable responsibility, only the master customer prints on the report. All receivable activity is printed under the master. Sub-Customers: Receivable Responsibility When the sub-customers have receivable responsibility, each sub-customer prints on the report with its receivable activity.
Account #	The account number assigned to the customer.
Res Phone	Residence phone number for the customer.
Bus Phone	Business phone number for the customer.
Exec	The executive assigned to the customer.
Rep	The representative assigned to the customer.

Policy Header Rows

Policy Header Rows	What is this?
On Account	If there are on account invoices for a customer, the words On Accountprint instead of the policy number and term. On account invoices print before policy invoices.
Policy No	Policy number from basic policy.
Effective/Expiration Dates	The policy effective and expiration dates (policy term) print to the right of the policy number.
Company	Prints the Insurance or Brokerage company name from basic policy. If there is no insurance or brokerage company assigned, then prints the word Subscription.

Detail Rows

Detail Rows	What is this?
Adv	If the invoice effective date for the invoice is greater than the End Date for the report, an (*) appears in this column indicating the invoice is billed in advance.
Posted	This is the general ledger date that the transaction was posted.
Invoice #	Standard Billing The invoice number does not include leading zeros. Multi-Entity Billing Master Customer: Receivable Responsibility If the master customer has receivable responsibility the invoice number has a suffix of 0. Sub-Customers: Receivable Responsibility If the sub-customers have receivable responsibility the invoice number includes a suffix. The suffix excludes leading zeros.
Type	This is the type of general ledger transaction. For more information, please consult the Accounting Transaction Code table. If the billing is for a net broker, then the invoice transaction is followed by a broker commission credit with a (BCC) transaction type.
Binder	If this is an unreplaced binder transaction, an () appears in this column. This is not an historical indicator. If the binder is replaced, no () appears in this column, even if the report date range is before the binder was replaced. If this is a commission credit line, the word (binder) appears in this column.
Eff/Ref#	The invoice effective date appears here if the transaction is an invoice or beginning balance journal entry. For all other transactions, the system generated reference number appears here.
Tran	If the transaction is an invoice, the policy transaction type, or charge type appears in this column (NBS, RWL). Otherwise, this column is blank. If this is a commission credit line, this field is blank.
Description	If the transaction is an invoice, prints the transaction description. Then, if the invoice transaction is an installment, the description is preceded by an [I]. For all other transactions, prints the general ledger transaction description. If this is a commission credit line, the XXX% (commission percent), of -999,999,999.99 (invoice transaction amount), or the words Flat Rate, AND the line of business or charge code appears in this field. Example: 6% on 6,000.00, Business Auto Example: Flat Rate, Business Auto
Amount	Prints the amount of the invoice, or general ledger transaction. If the amount is a credit, the amount is preceded by a (-). If the billing amount is for a net broker, then the invoice debit amount is followed by a broker commission credit amount.

Invoice Balance

Sums all debit and credit amounts for an invoice. Prints the balance in bold in the Amountcolumn, adjacent to theInvoice Balanceheader. If the balance is a credit, the number is preceded by a (-).

Policy Balance

Sums all debit and credit amounts for the policy. Prints in bold to the right of the Amount column. If the balance is a credit, the number is preceded by a (-).

Account Balance

Sums all debit and credit amounts for the customer. Prints in bold to the right of the Amount column, under the Policy Balances. If the balance is a credit, the number is preceded by a (-).

Total Receivables

The totals below print for Each broker AND print for All brokers.

Totals	What is this?
Total Excluding Advanced	Each Broker Sums all debit and credit amounts for all customers, for each broker included on the report, excluding any amount marked as advanced (). If the balance is a credit, the number is preceded by a (-). All Brokers Sums all debit and credit amounts for all customers, for all brokers included on the report, excluding any amount marked as advanced (). If the balance is a credit, the number is preceded by a (-).
Total Advanced (Adv)	Each Broker Sums all debit and credit amounts for all customers, for each broker included on the report that are marked advanced (). All Brokers Sums all debit and credit amounts for all customers, for all brokers included on the report that are marked advanced ().
Total Including Advanced	Each Broker Sums all debit and credit amounts for all customers, for each broker included on the report. All Brokers Sums all debit and credit amounts for all customers, for all brokers included on the report.

Report Fields	Description
CustomerName	The last name, first name, or firm name of the customer.
MasterCustName	The last name, first name, or firm name of the master customer, if any.
AccountNo	The account number assigned to the customer.
ResPhone	Residential phone for the customer and extension, if any.
BusPhone	Business phone for the customer and extension, if any.
Exec	The executive assigned to the customer.
Rep	The representative assigned to the customer.
PolicyNo	On Account If this is an on account transaction, the wordsOn Accountappear here. Policy # If the transaction belongs to a policy, the policy number appears here.
PolicyTerm	On Account This field is blank for on account transactions. Policy #/Term The policy effective and expiration dates appear here.
Company	On Account If this is an on account entry, this field is blank. Policies The Insurance or Brokerage company name from basic policy. If there is no insurance or brokerage company assigned, then the word Subscription appears.
GLDivision	The division assigned to the transaction.
GLDepartment	The department assigned to the transaction.
Broker	The last name, first name, or firm name of the broker.
BrokerBusPhone	The broker's business phone and extension, if any.
Posted	This is the general ledger date when the transaction posted.
InvoiceNo	The invoice number of the transaction, excluding leading zeros.
Suffix	If the invoice is a multi-entity billing, then the invoice suffix prints. Master customers have a suffix of 0.
Type	This is the type of general ledger transaction. For more information, please consult the Accounting Transaction Code table.
Binder	If this is an unreplaced binder transaction, an () appears in this column. This is not an historical indicator. If the binder is replaced, no () appears in this column, even if the report date range is before the binder was replaced. If this is a commission credit line, the word (binder) appears in this column.
Eff/Ref#	The invoice effective date appears here if the transaction is an invoice or beginning balance journal entry. For all other transactions, the system generated reference number appears here.
Adv	If the invoice effective date for the invoice is greater than the End Datefor the report, an (*) appears indicating the invoice is billed in advance.
Tran	If the transaction is an invoice, the policy transaction type, or charge type appears in this column (NBS, RWL). Otherwise, this field is blank. If this is a commission credit line, this field is blank.
Description	If the transaction is an invoice, the transaction description appears. For all other transactions, the general ledger transaction description appears.
Amount	The amount of the invoice, or general ledger transaction. If the amount is a credit, the amount is preceded by a (-).
GLBranch	The branch assigned to the transaction.
GLGroup	The group assigned to the transaction.

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