Report: Broker Aged Accounts Receivable

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

Use the Broker Aged Accounts Receivable report as a collection tool. It shows the amounts due your agency from your brokers, by age of the invoice. This report can be run for one broker or all brokers, and for functionality, can be limited by division, department, representative, and/or executive.

To run the report for customers with credit balances, choose the Credit Balance Invoices = Onlyoption. Then use the information on the Customer A/R tab to see if debit invoices exist that you can apply the credit balances to. You can also use theSmart Buttonsto take action on the credit balances.

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 Aged Accounts Receivable. This opens the Report - Broker Aged Accounts Receivable 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?

Invoice Balances and Aging As Of

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

Invoice Age

Option

What is this?

All Ages

Select the All Ages (default) option if you want to include invoices of all ages as of the selected end date.

Age Greater Than ___ Days Old

Select the Age Greater Thanoption and key in the number of days in theDays Oldfield, if you wish to limited your report to just receivables that are a certain number of days old.

The age of an invoice is based on the later of the Invoice Date or the Invoice Effective Date relative to the report's As of Date.

If a customer has one invoice that is greater than the number of days entered in the Days Old field, then all open invoices for that customer are reported.

To exclude reporting for Advanced Invoices, select the Age Greater Than option and type 0 in the Days Old field.

Sort Order

What is this?

Primary Sort

Select the primary sort for your report. Your choices are:

Broker
Division

Secondary Sorts

If the primary sort is by Division, then sort by Broker, by customer On Account transactions, by Policy Number, and by Invoice Number.
If the primary sort is by Broker, then sort by Customer On Account transactions, by Policy Number, and then by Invoice Number.

Description

Accept the default description, or enter a new on that describes the report you are requesting.

Credit Balance Invoices

Option	What is this?
Include	Select the Include (default) option if you want to include credit balance invoices on the report.
Exclude	Select the Exclude option if you want to exclude credit balance invoices from the report.
Only	Select the Only option if you want to include only credit balance invoices on the report. To focus on customers with credit balance invoices that need to be cleared, run the report with the Only option selected for Credit Balance Invoices. Then, go to the Customer Register view and consider doing one of the following where available: Waive a small balance. Action = W Cut a check for return premium. Action = CK. Offset the balance of this credit invoice to a debit invoice. Action = A.

Broker

Select to include One or All (default) brokers on your report.

Business Unit

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

Representative

Select to include One, Multiple or All representatives and executives on your report.

If a selection is made for a specific Exec or Rep, broker On Account invoices that do have an Exec or Rep, are reported whenever the business unit selection includes the division matching the On Account invoice division.

Executive

Report Totals Only

Check this box to report totals only (no detail). Unchecked is the default.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Report Columns

Detail Report

Report Rows/Columns

Description

Header Information

Header Info	What is this?
Broker	This is the Brokerlast name, first name, or firm name. Broker heading information is printed once per broker. If the information for a broker continues to another page, then the broker name plus the word 'Continued' is printed at the top of the page.
Contact	This is the contact person within the Broker's office.
Bus Phone	This is the Broker's business phone.
Res Phone	This is the Broker's residence phone.
Email	This is the Broker's email address.

Customer

Customer	What is this?
Customer Name	Print customer Last Name, First Name. If none, print Firm Name.
Res Phone	Customer residence phone and extension, if any
Exec	Print the executive's Last Name, First Name for the customer.
Last Pay	Print the date of the last payment posted to the customer account. This date is determined from the open invoices reported.
Account Balance	The total of all invoice balances for the customer.
Account Number	The account number for the customer. Leading zeros are not printed.
Bus Phone	Customer business phone and extension, if any.
Rep	Print the representative's Last Name, First Name for the customer.
Last Amt	Print the last payment amount posted to the customer account. This amount is determined from the open invoices reported.
Oldest Invoice Age	Print the age (number of days) of the oldest invoice for the customer. The age is based on the later of the invoice date or the invoice effect date.

Policy

What is this?

Policy/Inv

Policy Number

Print the policy number from basic policy.

Invoice Number

Print the invoice number without the leading zeros.

On Account

Policy Type

Print the policy type next to the policy:

BOP
Package
Line of Business or Monoline

If the policy is monoline, then the line of business (LOB) description prints here. If there are multiple lines of business, then the first LOB input prints. If there are no lines of business, then "monoline" prints.

Balance Due

The balance due for each invoice on the report.

Inv/Eff Age

Age Type	What is this?
Invoice Age	Reported in the left column. The age of the invoice based on the invoice date. This number is always 0 or greater.
Invoice Effective Age	Reported in the right column. The age of the invoice based on the invoice effective date. This number could be negative due to advanced billing.

Effective Date

This is the invoice effective date.

Aging Categories

Print the invoice balance in the appropriate age column based on the later of the invoice date or invoice effective date.

Late Charge

Print the late charge component of the invoice balance.

If the agency has late charges turned off, AND there are no late charges posted to the general ledger, then this column does not appear on the report.

For more information on turning agency late charges on/off, go to the Accounting Options/Late Charge Options section of the Agency Setup topic.

Totals

Totals	What is this?
Policy Total	Print the total of all invoices for a policy if there is more than one invoice.
Broker Total	Print the total receivables for each broker on the report by aging category. There are no report level totals.
Total Receivables Excluding Late Charges	Print the total of all receivables for the broker excluding late charges.
Total Receivables Including Late Charges	Print the total of all receivables for the broker including late charges.

Totals Only Report

Calculating the Customer and Invoice Balance

Calculating the Invoice Age

Determine Invoice Balance Amount

Last Pay and Last Amount

Page Breaks

Reporting for an individual customer will match the Aged A/R view when:

The report and the view are accessed by the same user, as data is subject to the user's Business Unit security access.
The report selection for Business Unit, Executive, and Representative equal All.
The report selection for Credit Balance Invoices equal Include.
The report selection As Of date is the same as the view.
The report Invoice Age equals All Ages.
The report Credit Balance InvoicesequalsAll.

CSV Columns	Description
BrokerName	Broker's last name, first name, or firm name.
Contact	Contact person within the Broker'soffice.
BrokerBusPhone	The Broker'sbusiness phone.
BrokerResPhone	The Broker'sresidence phone.
Email	The Broker'semail address.
CustomerName	The Customerlast name, first name, or firm name.
AccountNo	The account number for the customer. Leading zeros are not included.
CustResPhone	The Customer residence phone and extension, if any.
CustBusPhone	The Customer business phone and extension, if any.
InvExec	The executive on the invoice.
InvRep	The representative on the invoice.
PolicyNo	The policy number from basic policy.
Invoice	The invoice number.
MESuffix	The multi-entity invoice suffix, if any.
Balance	Balance due for each invoice.
InvAge	The age of the invoice based on the invoice date. This number is always 0 or greater.
EffAge	The age of the invoice based on the invoice effective date. This number could be negative due to advanced billing.
GLAge	The age of the invoice based on the general ledger date. This date is equivalent to the later of the invoice or invoice effective date.
LateCharge	The late charge component of the invoice balance.
InvLastPmtDate	The date of the last payment posted on the invoice.
InvLastPmtAmt	The last payment amount posted on the invoice.
EffDate	The invoice effective date.
GLDivision	The division assigned to the general ledger transaction.
GLDepartment	The department assigned to the general ledger transaction.
PolicyID	This is anAMS 360unique internal identifier for the policy number.
PolicyType	The policy type (BOP, Package, Line of Business).
CustExec	The executive assigned to the customer.
CustRep	The representative assigned to the customer.
CustLastPmtDate	The date of the last payment posted on the customer.
CustLastPmtAmt	The last payment amount posted on the customer.
GLBranch	The branch assigned to the general ledger transaction.
GLGroup	The group assigned to the general ledger 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