# How do you calculate the average balance in accounts receivable?

Author:
Harold Averkamp, CPA, MBA

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 2023 by using the balances from only two days (December 31, 2022 and December 31, 2023), you are ignoring the balances on the other 364 days of 2023. 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 2023 average would be calculated using the ending balance on December 31, 2022 + the ending balance on January 31, 2023 + the ending balance on February 28, 2023 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.

Join PRO to Track Progress

• Perform better at your job
• Get hired for a new position

#### Earn Our Certificates of Achievement

• Debits and Credits
• Financial Statements
• Balance Sheet
• Income Statement
• Cash Flow Statement
• Working Capital and Liquidity
• Financial Ratios
• Bank Reconciliation
• Accounts Receivable and Bad Debts Expense
• Payroll Accounting

#### PRO Plus

Features
Explanations
Quizzes
Q&A
Word Scrambles
Crosswords
Bookkeeping Video Training
Financial Statements Video Training
Flashcards
Visual Tutorials
Quick Tests
Quick Tests with Coaching
Cheat Sheets
Bookkeeping Study Guide
Managerial Study Guide
All PDF Files
Progress Tracking
Certificate - Debits and Credits
Certificate - Financial Statements
Certificate - Balance Sheet
Certificate - Income Statement
Certificate - Cash Flow Statement
Certificate - Working Capital
Certificate - Financial Ratios
Certificate - Bank Reconciliation
Certificate - Accounts Receivable and Bad Debts Expense
Certificate - Payroll Accounting