How do you calculate the average balance in accounts receivable?
The average will be more representative as you consider more daily balances in the computation. For example, if you compute the average balance for the year 2006 by using the balances from two days (December 31, 2005 and December 31, 2006), you are ignoring the balances on the other 364 days of 2006. 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 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 2006 average would be calculated using the ending balance on December 31, 2005 + the ending balance on January 31, 2006 + the ending balance on February 28, 2006 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.
Comments
5 Responses to “How do you calculate the average balance in accounts receivable?”
Leave a Reply
 | Free updates with your feed reader (or) receive our monthly Q&A newsletter by filling out the form below: |
Accounting Cheat Sheet
Receive our popular 15-page Cheat Sheet at no cost when
you join our free newsletter:
|
We keep your email address 100% safe and secure.
Most Recent Questions
- What is the meaning of sundry and sundry debtors?
- If an accrual adjusting entry increases an expense and a liability, how does the balance sheet remain in balance?
- What is the difference between liquidity and liquidation?
- What is the meaning of pro rata?
- What is the difference between financial accounting and management accounting?
- What is the difference between accounts payable and accounts receivable?
- In a bank reconciliation, what happens to the outstanding checks of the previous month?
Questions by Category
- Debits and Credits
- Depreciation
- Financial Accounting
- Financial Ratios
- Improving Profits
- Income Statement
- Inventory and Cost of Goods Sold
- Lower of Cost or Market
- Manufacturing Overhead
- Nonmanufacturing Overhead
- Payroll Accounting
- Present Value of a Single Amount
- Present Value of an Ordinary Annuity
- Standard Costing
- Stockholders' Equity
Why AccountingCoach.com?
AccountingCoach.com is designed to help people without an accounting background easily understand accounting concepts at no cost.
By investing thousands of hours, we have created clear and concise accounting information for both business people and students of all ages.
Read 1,200+ Visitor Testimonials
how can i calculate debtors turnover ratio
I wanted to know about capitalized cost concept. Some companies when they take a lot of debt for capacity expansion purposes, they don’t pay the interest immediately,infact they do pay immediately after taking debt but don’t show the financial charges in their income statement.Instead they capitalize it and apply amortisation charges to it. Has anyone come across this concept?
to calculate debtor ratio, the following method maybe be useful for u
Trade debtor/ turnover
have not got the asnwer
I am filling out a credit application form with a vendor. The vendor want to know our average monthly A/R and A/P. How in the world do I calculate these? My accounting software does not have a report to generate these.