#AVERAGE ACCOUNTS RECEIVABLE FORMULA FULL#

This is an average of the amount of receivables outstanding as of the end of each business day, divided by the number of days being used to compile the average (presumably at least one month).

These two figures are so far apart in time that it is quite unlikely that they will relate to credit sales in any given month, so the result is likely to be a skewed calculation of average collection time. This is the sum of the ending receivable balances at the end of the last two years, divided by two. Thus, this alternative tends to combine a realistic measurement time period and a relatively simple calculation.

#AVERAGE ACCOUNTS RECEIVABLE FORMULA FULL#

It suffers from the same problems as using the balances at the end of the last two months, but probably also covers the full range of dates over which the typical company has receivables outstanding. This calculation is based on the ending receivable balances in the past three months. Average of Consecutive Month-End Balances for Three Months This approach may yield a somewhat high average receivable, since many companies issue a large number of invoices at month-end, but it at least covers the period over which receivables are currently outstanding. Perhaps the most common calculation for average accounts receivable is to sum the ending receivable balances for the past two months and divide by two. Average of Consecutive Month-End Balances for Two Months Though it is the simplest option, we do not recommend it. Its results are likely to be most variable when receivables are comprised of a few large billings, since the collection of one or two them near month-end can drastically alter the ending balance. It is not an average at all, since it is comprised of a single data point, and so can yield highly variable results from month to month. This is the ending receivable balance for the month. Here are several variations on the concept, with a critique of each one: Month-End Balance Calculation The method used to calculate it can have a profound impact on the resulting calculation of the average collection period. It is a key part of the calculation of receivables turnover, for which the calculation is as follows:Īverage accounts receivable ÷ (Annual credit sales ÷ 365 Days) Average accounts receivable is the average amount of trade receivables on hand during a reporting period.

Average accounts receivable formula