Average accounts receivable is the sum of starting and ending accounts receivable over a time period (such as monthly or quarterly), divided by 2.
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.
The formula for calculating net credit sales is as follows. Net Credit Sales = Gross Credit Sales – Returns – Discounts – Allowances. Average Collection Period = (Accounts Receivable ÷ Net Credit Sales) × 365 Days. Receivables Turnover = Net Credit Sales ÷ Average Accounts Receivable.
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 forecasted accounts receivable balance is equal to the days sales outstanding (DSO) assumption divided by 365 days, multiplied by 365 days.
AR Ratio Formulas The AR balance is based on the average number of days in which revenue is received. Revenue in each period is multiplied by the turnover days and divided by the number of days in the period.
To calculate a company's DSO, you divide its accounts receivable by its total credit sales and multiply the result by the total amount of days within the period. The formula is:DSO = (accounts receivable / credit sales) x number days in specific periodRelated: Q&A: What Is Accounts Receivable and How Does It Work?
Accounts Receivable Net (A/R Net) refers to the total outstanding amount of customer invoices after subtracting any allowances for doubtful accounts or uncollectible amounts.
The days' sales in accounts receivable is calculated as follows: the number of days in the year (use 360 or 365) divided by the accounts receivable turnover ratio during a past year.