Report: Finance Company Receivable Activity

Reports all financial activity for Finance Companies based on the selected date range.

What is this?

Receivable Activity Date Range

Reporting is "Open Item" based. This means that all activity for any invoice with a non-zero balance one day prior to the report begin date is included along with all activity posted to Finance Company Receivables for all invoices through the ending date.

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.

Finance Company

You can select to run the report for All finance companies (default) or One. To run for one company, select the desired finance company from the list.

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.

Report Fields

Description

Finance Company

Prints the name of the finance company.

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?
Pol No	The policy number from basic policy.
Effective/Expiration Dates	The policy effective and expiration dates from basic policy.
Company	Prints the Insurance or Brokerage company short name. If there is no insurance or brokerage company assigned, then prints the word Subscription.
Div/Dept	The division and department assigned to the policy.
Broker	Prints the broker's 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.
Invoice #	Standard Billing Prints the invoice number, without any 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.
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). If the invoice is an installment and the customer has a premium grouping option that summarizes transactions, three (***) appear. If the transaction is not an invoice, the column 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.
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, adjacent to the Policy Balance header. If the balance is a credit, the number is preceded by a (-).

Account Balance

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

Total Receivables

This section lists totals for the finance company being reported. If the balance is a credit, the number is preceded by a (-).

Totals	What is this?
Total Excluding Advanced	Sums all debit and credit amounts for all customers for a specific finance company, excluding any amounts marked as advanced (*).
Total Advanced (Adv)	Sums all debit and credit amounts for all customers for a specific finance company that are marked advanced (*).
Total Including Advanced	Sums all debit and credit amounts for all customers for the finance company.

Total Receivables for All Finance Companies

This section, appearing at the end of the report, lists totals for all finance companies included on the report. If the balance is a credit, the number is preceded by a (-).

Totals	What is this?
Total Excluding Advanced	Sums all debit and credit amounts for all finance companies on the report, excluding any amount marked as advanced (*).
Total Advanced (Adv)	Sums all debit and credit amounts for all finance companies on the report that are marked advanced (*).
Total Including Advanced	Sums all debit and credit amounts for all finance company entries included on the report.

CSV Columns

Description

CustomerName

The last name, first name, or firm name of the customer.

MasterCustName

The master customer's last name, first name, or firm name.

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 date, and policy expiration date from basic policy.

FinanceCompany

The finance company on the transaction.

Company

The Insurance or Brokerage company name from basic policy. If there is no insurance or brokerage company assigned, then the word Subscription prints.

GLDivision

The division short name.

GLDepartment

The department short name.

Broker

Prints the broker's last name, first name or firm name from basic policy, if one exists.

BrokerBusPhone

The broker's business phone number and extension, if any.

Posted

This is the general ledger date when the transaction was posted.

InvoiceNo

The invoice number excluding leading zeros.

Suffix

If the invoice is a multi-entity billing, then the invoice suffix prints, otherwise this field is blank.

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 Date for 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).

If the transaction is not an invoice, the column is blank.

Description

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 short name.

GLGroup

The group short name.