OVERVIEW
Average Days to Pay or ADP is the average number of days it takes a customer account to pay an invoice in full. It is sometimes referred to as average days delinquent (ADD) or days beyond terms (DBT). The software uses ADP instead of ADD or DBT because ADD and DBT both suggest that customers pay beyond terms while ADP shows how long a customer takes to pay (early, on time, or late).
ADP is calculated based on either the invoice creation date (if using the Invoice Due Date fields as the default aging method) or more commonly calculated based on the invoice due date (if using By Due Date as the default aging method). Average Days to Pay can be defined for up to 7 ranges of invoice sizes using the invoice amounts in the home currency. These ranges can be user defined in site options or they may be automatically and dynamically calculated based on the invoice data synchronized from the ERP system.
NOTE - Average Days to Pay uses the Last Payment Date. If there are no payments and the "Last Payment Date" field is empty or null, then the "Transaction Date" field is used.
An overview of the ADP information for each customer can be found in the "History" tab of the customer drop-down menu. Search for a customer at the top of the page, then select the arrow to the left of the search bar to find this information.
The "Late Days Overall" is the same as the "Average Days Late" field and the "Late Days Weighted by Amount" is the same as the "Average Days Late Weighted" field. The amount fields on the left represent the ADP amount buckets set on the Site Options page.
FIELDS
Average Days Late (AvgDaysLate) - This calculation is based on invoices with a zero balance that have payments applied to the invoice. The calculation totals up "DaysPaidLate" field and calculates the average based on the number of zero balance invoices with payments.
Average Days Late Weighted (AvgDaysLateWeighted) - Represents the average number of days they are late on paying any invoice (regardless of invoice size) but weighted based on the amount past due. See below for more information.
Average Days Late Difference (AvgDaysLateDiff) - The difference between the Average Days Late and the Average Days Late Weighted (by amount) is provided in this field (AvgDaysLateDiff).
Average Days to Pay Total (AvgDaysToPayTotal) - This is the count of the number of invoices a customer has in the application, open or closed. If the customer has 50 invoices, regardless of whether they are closed or not, this field will show as "50."
Average Days Amount Total (AvgDaysAmtTotal) - The total number of days for transactions included in average days late calculations is provided in this column (AvgDaysAmtTotal). It is not useful for collectors but used strictly to calculate the Average Days Late and Average Days Late Weighted by amount metrics.
Average Days Count Total (AvgDaysCountTotal) - The total number of transactions included in average days late calculations is provided in this column (AvgDaysCountTotal). It is not useful for collectors but used strictly to calculate the Average Days Late and Average Days Late Weighted by amount metrics.
Days Paid Late (DaysPaidLate) - An invoice level field that shows how many days late it took for an invoice to be paid. It is calculated on invoices with a (0.00) balance, showing the amount of days between the "LastPmtDate" field and the "DueDate" field.