How do you calculate the average balance in accounts receivable?

The average will be more representative if you include additional balances in the computation. For example, if you compute the average balance for the year 2022 by using the balances from only two days (December 31, 2021 and December 31, 2022), you are ignoring the balances on the other 364 days of 2022. That's a problem if the majority of the company's activity occurs in the months of March through October. If that's the case, using only the December 31 balances will result in an average that is misleading.

To overcome the shortcoming of using only the balance at the beginning of the year and the balance at the end of the year, some accountants use 13 balances: the balance at the beginning of the year plus the balances at the end of each month. For example, the 2022 average would be calculated using the ending balance on December 31, 2021 + the ending balance on January 31, 2022 + the ending balance on February 28, 2022 and so on. Obviously, this is better than using only the two December 31 balances. Of course you need to have access to the monthly balances.

Still better is to compute the average for the year by using the balances on each of the 365 days in the year—thereby considering fluctuations that occur within a month.

If you need a monthly average for accounts receivable, the logic is the same: 30 or 31 points of data is far better than merely using the beginning of the month balance and the end of the month balance.

View our business form for Average: 13 month.