To calculate net accounts receivable, you need: total accounts receivable, allowance for doubtful accounts, and sales returns and allowances. Then, subtract the allowance for doubtful accounts, sales returns and allowances from the Total Account Receivables.
To forecast accounts receivable, divide DSO by 365 for a daily collection rate. Multiply this rate by your sales forecast to estimate future accounts receivable. This method helps predict the amount you can expect to receive over a specific period.
Average accounts receivables is calculated as the sum of the starting and ending receivables over a set period of time (usually a month, quarter, or year). That number is then divided by 2 to determine an accurate financial ratio.
The accounts receivable turnover ratio is a simple metric used to measure a business's effectiveness at collecting debt and extending credit. It is calculated by dividing net credit sales by average accounts receivable. The higher the ratio, the better the business manages customer credit.
Gross accounts receivable represents the total amount of outstanding invoices or the sum owed by customers. It's perhaps the easiest to calculate, too - you simply add up all the outstanding invoices at a given time!
(average accounts receivable balance ÷ net credit sales ) x 365 = average collection period. You can also essentially reverse the formula to get the same result: 365 ÷ (net credit sales ÷ average accounts receivable balance) = average collection period.
Average accounts receivable is calculated as the sum of starting and ending receivables over a set period of time (generally monthly, quarterly or annually), divided by two.
Find the total sales for each year and the total value of all annual outstanding accounts. Find the average percentage that the debt accounted for and divide the value by your total sales figures for each year. You can then apply that percentage to your current sales figures.