The formula for net credit sales is = Sales on credit – Sales returns – Sales allowances. Average accounts receivable is the sum of starting and ending accounts receivable over a time period (such as monthly or quarterly), divided by 2.
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!
How is accounts receivable turnover calculated? Net annual credit sales are calculated as sales on credit minus sales returns and sales allowances. Average accounts receivable is calculated as the sum of the starting and ending receivables over a period, divided by two.
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.
The pro forma accounts receivable (A/R) balance can be determined by rearranging the formula from earlier. The forecasted accounts receivable balance is equal to the days sales outstanding (DSO) assumption divided by 365 days, multiplied by 365 days.
By dividing DSO by 365 (the total number of days per year), you get a daily rate of how long it typically takes to collect a receivable. Multiplying this rate by your sales forecast gives you an estimated accounts receivable amount you can expect for that period.
The realizable value refers to the accounts receivable amount expected to be received.
How to calculate accounts receivable days on hand? One can calculate the accounts receivable days of a business by dividing the pending AR with the revenue during a fixed period and multiplying it by the number of days at the time.
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.