Customer Period Analysis Report overview

Customer > Reports > AR Reports > ARRP

Function acronym: ARRP

Use this report to show an aging of customers' balances for Periods 1 – 5 to determine how long the customers' debts have been outstanding. The report shows the average collection time, and enables you to determine if greater effort is required to make collections.

You can customize the format of the report. These options are available:

  • Print a detail line for every transaction
  • Print the grand totals for each customer
  • Print the period balances
  • Include or exclude C.O.D. transactions in the period balances
  • Print customers with zero balances
  • Print detail reports by ship-to/job
  • Print information for a selected range of ship-to values
  • Print detail reports by invoice number
  • Age the invoices by due date or by invoice date

Some options can affect the appearance of the report.

The first two lines of the report show static customer information on the detail report. The contents of these lines vary depending on whether you print the detail transactions.

The detail report can display one or two sections per customer. The first section includes the invoice number, invoice and due date, the balance on the invoice, and any service charges and future invoices. The balance of the invoice is also shown in the appropriate period column.

The second section includes a listing of miscellaneous credits and unapplied cash. If there are no miscellaneous credits or unapplied cash, or if you did not select Age Service Charges in SA Administrator Options-Customers-Balances, the second section is not included on the report.

For the summary report, a separate line is displayed for each customer. This includes the customer name and number, the total balance, service charge, and future invoices. A total of all invoices that fall into each period category is included in each of the appropriate period columns.

When you include ship to subtotals on the summary report, the first line is the total for the customer without an assigned ship to. If there are no transactions without a ship to assigned, the first line prints without a customer name and a 0.00 total. The last line is the total for the customer, and all transactions with and without assigned ship tos. Lines between the first and the last are the subtotals by ship to.

Note: You cannot use the Customer Period Analysis Report to roll balances. You must run the Customer Entry Roll Balances Report to roll balances.

The grand total average days to pay that is printed at the end of the report is an average accumulation of all customers. The average days to pay, which is printed for each customer, is calculated with this formula :

Number of payments x average days to pay = total payment days

(total payment days + days to pay) / (number of payments + 1) = average days to pay

invoice payment date - invoice date = days to pay

Totals are included for each customer, and grand totals are included, or you can print grand totals only. Divisional totals are included if the Grand Totals Only? option is Noand By Division option is Yes.

At the end of the report, a total of all customers out of balance print. Customers are listed as out of balance if the cutoff date is equal to the current date. The Total Credits at the end of the report includes all credits for all customers and Domestic Total Credits.

Note: If you are restricted to a home warehouse on your SA Operator Setup record, your home warehouse is not the default value for the warehouse range of this report.