Average Collection Days Report


Accounts Receivable Menu -> Collections -> 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.

Topic Keyword: ARCH03
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)