By continuing your visit to this site, you accept the use of cookies. They ensure the proper functioning of our services and display relevant ads. Learn more about cookies and act

Not yet registered? Create a OverBlog!

Create my blog

How to calculate accounts receivable turnover

Knowing how many times a business turns over its accounts receivable is a useful guide to the speed it collects its debts. Here, we look at the turnover formula used and other points to consider once you have the information.

The maths

The ratio itself is fairly simple. Take a business’s annual sales turnover and divide it by the average balance of the accounts receivable (AR) over the same period. For example, if annual sales turnover is £2,000,000, average AR balance is £ 250,000 (2,000,000/250,000), the accounts receivable is 8. The resulting figure gives an indication that on average, the business turned over its accounts receivable eight times over the course of the year. What does this tell me? The number eight may not mean an awful lot to anyone unfamiliar with accounting ratios. However, it does provide the basis to drill down even further. By dividing the number of days in the year (360 or 365 will suffice) by the number eight, we arrive at another figure of 45. These two simple sums tell us that accounts receivable turned over eight times during the year or, put another way, every 45 days. Is this good? To make any real use of this information, it is important to know three other things: how it compares to the industry standard, how it compares to prior years and how it compares to the business’s actual credit policy. If sales turnover is generated on the basis of 30 days credit, then on average, debts are being collected 15 days past due. On the other hand, if the business sells on 60-day terms, it clearly has a robust trade receivables department.

Where can I find the necessary information?

Any well run business will close down their books on a monthly basis and prepare accounts covering this period. 12 months sales turnover figures gives the total sales for the year and by noting each month ends accounts receivable balance, it is easy to arrive at an average monthly figure.
Remember, it is only an average Whilst undoubtedly a useful starting point, you should always bear in mind that any yearly average ratio can mask certain anomalies. For instance, many of very fast moving debt will offset any overdue or even delinquent debt in the figures. In this respect, and whilst you have access to a business’s books, it would be very worthwhile looking at a detailed aged receivables report. Final word Do not stop there though, with 12 months figures at hand, why not do a days sales outstanding calculation for different periods of the year and compare them to the annual average?

Same category articles Accounting

How to obtain a copy of birth certificate in UK

How to obtain a copy of birth certificate in UK

All births in the UK must be registered with the Registrar of Births, Deaths and Marriages in the district where the baby is born. In England and Wales, the birth must be registered within 42 days, and in Scotland within 21 days. If you need to obtain a copy of a birth certificate, you must contact either the Register Office where the birth was registered, or the General Register Office (GRO).
How to spot "creative accounting"

How to spot "creative accounting"

Creative accounting is used to overstate a business’ assets or understate its liabilities. The result of creative accounting can be a misleading picture of a business’ financial condition. It is relatively easy to spot creative accounting if you know where to look. This article will show you how.
How to use a budget spreadsheet

How to use a budget spreadsheet

A budget spreadsheet is a tool used to organise individual as well as organisational budgets. This article briefly describes how you can utilise it to manage your finances.
How to increase your credit score

How to increase your credit score

A number of people fail to realise how important their credit score really is. In today’s modern world where a number of borrowers fail to pay their debts and file for bankruptcy, lenders are increasingly emphasising the need for you to have a great credit score. A credit score is a three-digit number generated from your credit report. If you have a lower score, there are some ways tin which you can increase your score.