Report: Broker Aged Accounts Receivable

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 view 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.

The Broker Aged Accounts Receivable report is also available as a quick Report from the sidebar menu on the Broker Center. The quick report provides a collection tool that shows the amounts due your agency from the broker, by age of the invoice.

Report Selections

When the report is accessed from a Quick Reports menu, some selections populate by default. You can change default entries as needed.

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 List option.

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 Than option and key in the number of days in the Days Old field, 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 Data

Detail Report

Report Rows/Columns

Description

Header Information

Header Info	What is this?
Broker	This is the Broker last 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

Since On Account invoices do not have a department, they are reported whenever the business unit selection includes the division matching the On Account invoice division.

Since broker On Account invoices do not have an exec or rep, they are not reported whenever a specific exec or rep is selected. Broker On Account Invoices are only reported when the Exec

Policy Type

Print the policy type next to the policy:

BOP
Package
Line of Business or Monoline

If the policy is monoline, the line of business (LOB) description prints . If there are multiple lines of business, the first LOB input prints. If there are no lines of business, "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

The Totals Only report prints the following:

Broker heading for each broker.
Customer heading and total receivables with aging totals for each customer.

Total Receivables excluding late charges.
Total Receivables including late charges.

Additional Information:

Calculating the Customer and Invoice Balance	Add up all debit amounts less credit amounts for all customers, where the general ledger transaction date is equal to or less than the report As Of date. If the invoice total is not equal to zero, print it on the report. Then print totals at the invoice and customer levels.
Calculating the Invoice Age	Calculate the age of each invoice based on the later of the invoice date or the invoice effective date, relative to the As Of date. Then evaluate whether to keep an invoice based on the Invoice Age selection (All Ages or an Age Greater than a specific number of days old).
Determine Invoice Balance Amount	Evaluate which invoices to include in the customer's total receivables, based on the Credit Balance Invoices choice (Include, Exclude, or Only) made on the selection form.
Last Pay and Last Amount	Is determined from the open invoices on the report.
Page Breaks	There are page breaks by division when the primary sort is by division.

CSV Columns

CSV Columns	Description
BrokerName	Broker's last name, first name, or firm name.
Contact	Contact person within the Broker's office.
BrokerBusPhone	The Broker's business phone.
BrokerResPhone	The Broker's residence phone.
Email	The Broker's email address.
CustomerName	The Customer last 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 an AMS360 unique 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.