CPA Firms In Houston

How To Forecast Accounts Receivable For Small Business

Forecasting accounts receivable (“A/R”) requires determining “average accounts receivable days” and “projected daily sales” and then multiplying average accounts receivable days by projected daily sales to figure forecasted accounts receivable.

That is a mouthful, so let’s break out the above formula in more detail.

Step 1 – Understanding the Formula’s Concept

To understand the concept, you need to know that when a business makes a sell on credit, revenue is recorded and accounts receivable is increased. Therefore, there are always a certain amount of “sales on the balance sheet”

This means another way to think about how to forecast accounts receivable for small business, is to think: “How much sales will I have in accounts receivable at the end of year or forecast period?”. This leads us to step 2 –

Step 2 – Determine Average Accounts Receivable Days (With Example)

Please keep the above concept in mind during this step. What we are trying to do here is to find out what percentage of sales are on the balance sheet and then to express that in days.

Accordingly, we can do that by dividing Average Accounts Receivable by sales to determine A/R turnover. See our website for a more detailed analysis.

This will produce a ratio or you can think of it as a percentage expressing the percentage of sales that are in accounts receivable.

After this, you need to express this in days in a year by taking this ratio and multiplying it by 365.

Example:

ABC Company’s annual revenue is $1,000,000 for the year ending 12/31/2022.

Their ending A/R for the year ending 12/31/2021 was $120,000

Their ending A/R for the year ending 12/31/2022 was $96,000.

Therefore, their average A/R for the time periods mentioned is $108,000 ($120,000 / $96,0000).

And their A/R turnover equals .108 ($108,000 / $1,000,000).

Finally their Average A/R days is approximately 39 (365 * .108)

Step 3 – Determine Projected Daily Sales

Now, that you have the “average accounts receivable days” you need to have an estimated average daily sales. There are several methods that you can use to determine projected daily sales. I will briefly discuss my favorite –

Method 1 – Using Annual Forecasted Sales

This method uses what you have for an annual projected sales and divides by 365 to get daily sales. For example, if you are projecting $1,000,000 in annual sales, then your average daily sales would be approximately $2,740. Then you could multiply this figure by its “Average A/R days”. Using the example in Step 2 of 39, this means projected A/R would be $106,860 ($2,740 X 39).

Method 1 – Using Year To Date Actual Sales

This method takes average daily sales incurred year to date and uses this figure to project ending A/R. For example, let’s assume on January 31st, the company had made $95,000 in sales. Therefore, the average daily sales for the year would be approximately $3,065 ($95,000 / 31 days). Thus projected A/R using the figure from the Step 2 example would be $119,535 ($3,065 * 39).

Wrapping it all up

In conclusion, forecasting accounts receivable for small business requires knowing average accounts receivable days and then multiplying that figure by projected daily sales to end up with an estimated accounts receivable.

Like this article?

Share on Facebook
Share on Twitter
Share on Linkdin
Share on Pinterest

Leave a comment

Before You Go... Get Our "Best Of The Best" Reports When You
Grab a FREE Subscription to the Straight Talk Insider Monthly E-Newsletter

Every Month we will send you rock solid business and non-profit advice that you can quickly implement to generate more profits, peace of mind, and strategies FAST!