The following sections describe the calculations that appear at the top of the Accounts Receivable Analysis Report.
Your Accounts Receivable is up/down xx % over the last period (% Change column in the report):
= Current Total Receivables - First Prior Period Total Receivables x 100
First Prior Period Total Receivables
and up/down xx % over the prior nn period average:
APTR = Sum of Total Receivables for nn Prior Periods
nn Prior Periods
(where APTR = Average Prior Total Receivables)
Up/Down Percent = Current Total Receivables - APTR x 100
APTR
xx % of Accounts Receivable is over 30 days old:
= Current Amount Over 30 Days + Current Amount Over 60 Days x 100
Current Total Receivables
compared to xx % last period:
= First Prior Period Amount Over 30 Days + 60 Days x 100
First Prior Period Total Receivables
and xx % over the prior nn-period average:
= Sum of 30-Day and 60-Day Amounts for nn Prior Periods x 100
Sum of Total Receivables for nn Prior Periods
Your average invoice is $xx.xx for Open Item Customers:
= Total of All Open Item Invoice Amounts in the Open Invoice File
Total Number of Open Item Invoices in the Open Invoice File
and is xx days old (Average Days column in the report):
= Total number of invoice days old
Total number of invoices
The Total Number of Days Old is calculated by the sum of the days for each open item customer invoice in the Open Invoice file subtracted by the Original Invoice Date to the Period End Date (run date or A/R module date).
Note These invoices include finance charges and credit memos, but never include balance forward customer's invoices.
Period End Processing updates the Accounts Receivable Analysis Data file after zero-balance invoices have been purged, excludes future invoices, but includes unapplied DMs, CMs, and prepayments with dates that are not in the future, but remain unapplied.
For more information, see Accounts Receivable Analysis and Accounts Receivable Analysis Report.
