Client Analysis Report

The Client Analysis Report prints an analysis of a selected Client or a range of Clients. The report totals all new business during a selected date range, all debtor payments received during this time period, and results. Totals are printed for the number of accounts and payments. Total values and averages are also printed.

The report lists monthly totals reflecting all business reported in the selected date range. The report also lists yearly totals for all business. For the Year To Date totals, Collect! reads the year from the FROM field and TO field in your date range. Then it prints totals from January 1st of the FROM year up to the TO date selected in the date range.

The Client Analysis Report's Results columns show Liquidation percent, Cost Factor (average commission), Yield, and Year To Date commission amounts.

This report prints the following information:

1) Client information

* client
* number
* name
* last business date

2) Business Placed

BY MONTH

* number of new accounts
* total value of the new accounts

BY YEAR TO DATE - (January 1st - TO range)

* number of accounts placed this year
* total value of these accounts
* average value of these accounts

3) Collections

BY MONTH

*number of payments
* total value of these payments
* average value of these payments

BY YEAR TO DATE - (January 1st - TO range)

* number of payments
* total value of these payments
* average value of these payments

4) Results

Liquidation Percentage

This is the percentage of collections over listings.

Liquidation percentage =
(year to date payments / year to date account values) x 100

Cost Factor

This is the average commission percentage for the Client.

Cost Factor =
(year to date commission / year to date payments) x 100

Yield

This is the average amount of commission per account.

Yield =
year to date commission / number of accounts entered during the date range.

Year Commission

This is the year to date total commission.

Year Commission = Sum of all commissions for the date range.

When the totals are calculated, the program scans through all the client's debtors and transactions and adds up the principal, interest and debtor payments. For clients with many debtors, this may take some time.

Running The Report

When you run the Client Analysis report, you will be prompted for three things -- Client #, Clients with billing period, and Date Range to include in the report. These are explained below.

Client #

Select a range of Clients to include in your report.

This allows you to choose a specific Client or a range of Clients in numerical order by Client #. If no Client # is specified, the report will display all clients.

Clients With Billing Period

Select the billing period you wish to report on.

This allows you to choose a specific billing period to include in this report. The billing period method must be selected first in your settings for specific clients.

Date Range

Pick a date range to cover in this report. Click the small calendar icon to display the calendar.

The range that is displayed is usually preset to the current month from the 1st to the 31st of the month. If you choose an earlier date, make sure you choose the 1st to the 31st of the month.

If no date range is selected, a complete summary of all client activity is displayed.

For yearly totals, the report takes into account the FROM year. Yearly totals start on January 1st of the selected year.

Enter dates as MM/DD/YY. This report expects monthly ranges from the 1st to the 30/31st of the month. If you select other ranges where dates span across months, this may produce unexpected results.

From

Choose the beginning of the date range to include in this report. This is the date that your report will begin to calculate from.

Monthly totals go by month/ day. Yearly totals start from January 1st of the selected year.

To

Choose the end of the date range to include in this report. This is the date that your report will calculate TO.

Indicate the exact Month, Day and Year that you want your report to include.

This form has hidden fields that can be used in reports for more filters. Please refer to the Help topic How To Use Prompts In A Report for more information.

Help

Press this button for help on the Client Analysis Report dialog and links to related topics.

OK

Select this button to save your settings and proceed to the printing options.

Cancel

Select this button to cancel the printing process and return to the previous screen.

Using Internal Reports

These reports are important for tracking financials accurately and reconciling statements. They work well for basic simple payments and occasional NSFs to accounts. More sophisticated methods require custom reports to accommodate more complex details. This can be accommodated.

Any of the internal reports may be replaced with your own customized version. To make Collect! run your own custom reports via the Print menu, Daily, Monthly, Analysis and Trust reports, change the Start On to something other than INTERNAL, depending on the particulars of your report, and place your own report codes in the Report Body of the report.