Report: Customer Receivable Activity

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

The Customer Receivable Activity shows all financial activity for a customer based on the date range selected. This report includes broker activity, if any.

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 Customer Receivable Activity. This opens the Report - Customer 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 open invoices (with a non-zero balance) equal to or greater than the Begin Date, and less 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. The default option is Current Month.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From Listoption.

Customer

You can select to run the report for All customers (default) or One. To run for one customer, click Search and select the customer.

Include Sub-customers with Master

If you select to run the Customer Receivable Activityreport for aMastercustomer, check this box to include the master's sub-customers on the report. This box is checked by default.

Business Unit

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

Representative

You can run the report for one, multiple or (All) (default) representatives.

Executive

You can run the report for one, multiple or (All) (default) executives.

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 that has 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 Customer 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

Customer Header Rows

Customer Header Rows	What is this?
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	Residential phone number for the customer and extension, if any.
Bus Phone	Business phone number for the customer and extension, if any.
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 Account print instead of the policy number and term. On account invoices print before policy invoices.
Pol No	The policy number from basic policy.
Policy Term	The policy effective date, and expiration date from basic policy.
Company	Print the Insurance or Brokerage Company name from basic policy. If there is no insurance or brokerage company assigned, then print the word Subscription.
Div/Dept	The division and department short name.
Broker	Print the brokers last name, first name or firm name from basic policy, if one exists.

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 transaction date from the general ledger.
Inv #	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 () prints 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.
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 contains (***).
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.
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. Credit amounts are preceded by a (-).

Invoice Balance

Sums all debit and credit amounts for an invoice. Prints the balance in bold in the Amount column, adjacent to the Invoice Balance header. 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 Amountcolumn, under thePolicy Balances. If the balance is a credit, the number is preceded by a (-).

Total Receivables

Totals	What is this?
Total Excluding Advanced	Sums all debit and credit amounts for all customers 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)	Sums all debit and credit amounts for all customer invoices included on the report that are marked advanced (*). If the balance is a credit, the number is preceded by a (-).
Total Including Advanced	Sums all debit and credit amounts for all customers included on the report. If the balance is a credit, the number is preceded by a (-).

CSV Columns	Description
CustomerName	The last name, first name, or firm name of the standard, master or sub-customer. For more information on multi-entity customers, see the Report Fieldssection of this topic.
Master	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 number for the customer and extension, if any.
BusPhone	Business phone number for the customer and extension, if any.
Exec	The executive assigned to the customer.
Rep	The representative assigned to the customer.
PolicyNo	The policy number from basic policy.
PolicyTerm	The policy effective and expiration dates from basic policy.
Company	The Insurance or Brokerage Company name from basic policy. If there is no insurance or brokerage company assigned, then print the word Subscription.
GLDivision	The division assigned to the transaction.
GLDepartment	The department assigned to the transaction.
Broker	Prints the brokers last name, first name or firm name from basic policy, if one exists.
BrokerBusPhone	The brokers business phone number and extension, if any.
Posted	This is the general ledger date when the transaction was posted.
InvoiceNo	The invoice number of the transaction without leading zeros.
Suffix	If the invoice is a multi-entity billing, then print the invoice suffix. 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.
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 in this column 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 column is blank.
Description	If the transaction is an invoice, prints the transaction description. For all other transactions, prints the general ledger transaction description.
Amount	Prints the amount of the invoice, or general ledger transaction. If the amount is a credit, the amount is preceded with 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 11:01 PM