About Customer Statistics
Accounts Receivable tracks or calculates the following statistics for each customer, and displays them on the Statistics tab of the A/R Customers screen:
- The amount and number of invoices, receipts, discounts, credit notes, debit notes, adjustments, write-offs, interest charges, returned checks, and paid invoices.
- The total invoices paid, the total days to pay and average days-to-pay figures for the customer.
- The year-to-date total days to pay and average days to pay.
Note: You can view these statistics by the type of year (fiscal or calendar) and length of period specified on the A/R Options screen for customer statistics.
It also displays the following figures for the customer account on the Activity tab:
- The outstanding balance and outstanding retainage, and the number of open invoices for the customer's account.
- The balance and the date of the last customer statement.
- The year-to-date amounts and the dates of the highest balance and largest invoice in the current and previous years.
- The amount and date of the last invoice, receipt, credit note, debit note, adjustment, write-off transaction, interest charge, returned check, discount, revaluation, and refund processed for the customer.
- The total invoices paid, the total days to pay, and the average days-to-pay.
Editing Customer Statistics
You can edit the statistics in a customer record if the Allow Edit Of (customer) Statistics option is selected on the A/R Options screen.
Note: You cannot change the outstanding balance, outstanding retainage, number of open invoices, last statement balance, or last statement date for the account, regardless of the selection for this option.
Accumulating Tax Amounts in Statistics
The totals Accounts Receivable keeps for invoices, credit notes, and debit notes can include or exclude tax amounts posted with documents, depending on the selection for the Include Tax In (customer) Statistics option on the A/R Options screen.