AR Average Pay Days

Would anyone happen to know how the number of days for the average pay days found in customer inquiry is calculated?  Of course I know how to calculate an average, but I'm curious as to what length of time the average is based on.  I know the Payment Analysis Report will give more detailed information on average pay days.  We use customer inquiry for an at-a-glance look. 

  • I believe it is based on all the paid invoices on file for that customer.   The Customer Inquiry window displays a value in the 'Avg days to pay' field to represent the average number of days it takes that customer to pay an invoice.  To reconcile the number shown:

    1. Run a Payment Analysis Report for  All Transactions to display all available invoice information.
    2. Add up all of the numbers in the 'days' column of the customer in question that do not have asterisks (these are the open invoices and are not included in the average days to pay calculation).
    3. Divide by the total number of invoices that have "something" showing in the days column (excluding open invoices, but including the one's where days=0). The result of this should be the average days to pay figure plus or minus one day due to rounding.

     

  • Thanks for the response.  I tried some calculations to see if this is the case.  I'm not sure if I'm not calculating correctly or if this is not the accurate length of time used to calculate the average pay days shown in customer inquiry.

     

    I ran a payment analysis report showing all transactions.  I added only the paid invoices and divided by the number of paid invoices.  The result matches the total shown on the report labeled customer totals based on payments in full.  However, customer inquiry shows a number 5 days more than my calculation.

  • I think I might have found the answer.  I ran a "summary" payment analysis report and checked the average shown over the last six months.  This figure is the same (give or take a day) as the figure shown in customer inquiry.  I assume this is correct.  If anyone else finds something different, please let me know.

  • in reply to michelleb82
    Sage 50
    I need a report which shows the days to pay value found in the client inquiry window as discussed in this
    thread.
    At minimum I would need customer id and the days to pay value.
  • in reply to sevendogzero
    Sevendogzero-
    Unfortunately, this is the Sage BusinessWorks Forum. If you need assistance with the Sage 50 product, you will need to go to that forum.
    Thanks,
    Coleen