Report: Customer Receivable Activity

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

The Customer Receivable Activity report is also available as a quick report on the Customer Center sidebar menu. Use this report when you need invoice-level detail regarding a customer’s accounts receivable activity. It also provides a good chronological record to help locate billing errors, such as incorrect commissions or misapplied payments.

Report Selections

When the Customer Receivable Activity report is accessed through a quick reports menu, some of the options are pre-filled by default. The Customer field defaults from the customer selected in the Customer Center and cannot be changed. All other fields are modifiable.

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

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 Activity report for a Master customer, 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.

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 if the transaction is an invoice or beginning balance journal entry. For all other transactions, the system generated reference number appears.
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 Amount column, under the Policy 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

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 if the transaction is an invoice or beginning balance journal entry. For all other transactions, the system generated reference number appears.
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.