Average Collection Days Report

This report calculates the average days between the Invoice date and the date of the payment, for a selected customer range and a selected date range.

The Average Collect calculation is:

#AVG. COLLECT = TOTAL PAYMENT AMOUNT * THE NUMBER OF DAYS THE CUSTOMER TOOK TO PAY THE INVOICES
                                     TOTAL DOLLAR VALUE OF PAYMENTS

The prompts are:

DIVISION, "ALL" OR "SEL"

• Type ALL to include all divisions in the report.
• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined Division Select By Region.

ALL CUSTOMERS

Check this box to include all customers in the report.

Uncheck this box to select a customer range.

FROM CUSTOMER #

Enter the starting customer number in the range, or search for it in the Accounting Customer Search window.

TO CUSTOMER #

Enter the ending customer number in the range, or look it up in the window.

FROM DATE

Accept the starting date, or type in a preferred starting date for the report.

TO DATE

Accept today's date, or type in a preferred ending date for the report.

REPORT TYPE

Select one of the following report options:

• Select Detail to generate the Detailed report with the Customer # and a list of the Invoices, Invoice dates, Invoice Amounts, Amounts Paid.
  The report output also includes the Average number of days before collection.

  
  Select Summary to generate the summarized output listing only the Customer #, Name, # of Invoices used in the calculation, and the Average number of days.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click ACCEPT to generate the report, or CANCEL to abort.