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