{"id":22576,"date":"2023-04-01T07:55:51","date_gmt":"2023-04-01T07:55:51","guid":{"rendered":"https:\/\/envoice.eu\/?p=22576"},"modified":"2024-01-31T11:42:33","modified_gmt":"2024-01-31T11:42:33","slug":"how-to-forecast-accounts-receivable-for-small-business","status":"publish","type":"post","link":"https:\/\/envoice.eu\/en\/blog\/how-to-forecast-accounts-receivable-for-small-business\/","title":{"rendered":"How to Forecast Accounts Receivable for Small Business"},"content":{"rendered":"

Forecasting is a valuable skill that allows small businesses to make informed decisions.\u00a0 However, it may not feel like a priority, with so many other things to consider.<\/span><\/p>\n

Forecasting accounts can incorrectly be thought of solely as an accounts function. It is, in fact, in the best interest of all small business owners to stay on top of their cash flow.<\/span><\/p>\n

Learning to forecast accounts receivable does not have to be stressful.\u00a0 With a small amount of knowledge and consistent practice, <\/span>this skill can become invaluable and a game-changer for small businesses.<\/b><\/p>\n

Accounts receivable in a nutshell<\/span><\/h2>\n

Accounts Receivable (AR) is money due for goods and services the company has provided but has yet to receive payment for.<\/span><\/i>\u00a0 This has a net effect on funds available to manage operating expenses in the business.<\/span><\/p>\n

On the balance sheet,\u00a0 accounts receivable is an <\/span>asset<\/b>. A decrease in accounts receivable means an increase in cash.\u00a0\u00a0<\/span><\/p>\n

What is an accounts receivable forecast?<\/span><\/h2>\n
\"\"
Source: Pexels<\/figcaption><\/figure>\n

If the process of understanding collections and how much cash will be available to the business over time.\u00a0 It is also a model that is used to predict future payments that will be made to the company.<\/span><\/p>\n

Factors that could affect accounts receivable<\/span><\/h2>\n

According to a survey of small businesses in 2021: <\/span>[1]<\/span><\/p>\n

39%<\/b> of all invoices are not paid on time in the United States<\/span><\/p>\n

48%<\/b> of customers will delay making payments until the last moment\u00a0<\/span><\/p>\n

61%<\/b> of invoices are paid late due to incorrect information\u00a0\u00a0\u00a0<\/span><\/p>\n

These numbers make a huge impact on the cash flow of small businesses. Some easy, proactive measures, such as payment reminders and accurate invoices, can aid accounts receivable forecasting.<\/span><\/p>\n

What makes accounts receivable forecasting difficult?<\/span><\/h2>\n
\"office
Source: Pexels<\/figcaption><\/figure>\n

The reason forecasting is difficult is that action is required by the customer. Payment terms are agreed upon upfront,\u00a0 but it is still in the hands of the customer to pay on or before the due date.<\/span><\/p>\n

A business cannot predict the exact date on which payment will be made.\u00a0 It can only predict the maximum number of days a balance will be outstanding.<\/span><\/p>\n

This creates a high level of unpredictability regarding accounts receivable forecasting.\u00a0 Not exactly a comfort to most small business owners.<\/span><\/p>\n

Forecasting for a period of two to four weeks can be quite accurate. Longer periods introduce many variables, such as invoice volumes, payment turnaround times and economic factors beyond the business’s control.\u00a0<\/span><\/p>\n

However, it’s still highly beneficial to do simple calculations that will help you understand where your business’s vulnerabilities lie.<\/span><\/p>\n

Importance of a sales forecast in accounts receivables<\/span><\/h2>\n

The forecasting process begins by looking at possible sales over a period of time, a month or a quarter.\u00a0 Use historical data such as monthly sales, number of new customers, number of active customers and sales targets achieved.\u00a0\u00a0<\/span><\/p>\n

Customer Relationship Management (CRM) software can assist you to draw reports for sales forecasting.\u00a0 For a small business, a basic free CRM service, such as that provided by HubSpot <\/span>[2]<\/span>, can be invaluable.\u00a0<\/span><\/p>\n

Envoice<\/span><\/i><\/a> ingrates with CRM systems and small business accounting software seamlessly, providing you with powerful data at your fingertips.<\/span><\/i><\/p>\n

–<\/span> Short-term forecasting of sales – helpful formulas<\/span><\/h3>\n

Financial modeling ties accounts receivable to revenue since they are closely related.\u00a0 The SalesHacker site provides useful formulas for predicting sales <\/span>[3].\u00a0 <\/span>Let\u2019s look at this example based on historical data.<\/span><\/p>\n

Example:<\/span><\/p>\n

Monthly Recurring Revenue (MRR)<\/span> $150 000<\/span><\/p>\n

% growth of sales monthly (12 months)<\/span> 12%<\/span><\/p>\n

Monthly Churn %<\/span> 1%<\/span><\/p>\n

($150,000 * 1.12) \u2013 ($150,000 * .01) = $166,500<\/b><\/p>\n

Sales revenue figures tell a story of their own regarding cash flow management.\u00a0 Not only will they help you to predict accounts receivable, but they provide valuable information when considering your accounts payable data.\u00a0 These two variables tell a business how much cash will be available.<\/span><\/p>\n

Forecasting accounts receivable using days sales outstanding (DSO)<\/span><\/h2>\n

The formula is as follows:<\/span><\/p>\n

DSO = (Accounts receivable\/Revenue) x Number of days<\/span><\/i><\/p>\n

The projected Accounts Receivable Balance is then equal to:<\/span><\/p>\n

Projected Accounts Receivable = [DSO\/365] x Revenue<\/span><\/i><\/p>\n

–<\/span> Example:<\/span><\/h3>\n

A company that re-sells compounded medication has net credit sales of $100 000 and for a period of 50 days, the accounts receivable is $60 000<\/span><\/p>\n

DSO = (Accounts Receivable \/ Revenue) x Number of Days<\/span><\/p>\n

=<\/span> (60000\/100000) x 50<\/span><\/p>\n

=<\/span> 30 Days<\/b><\/p>\n

Thus, this company anticipates recovering its collections in 30 days. Generally, a DSO of less than 45 days means that the company will have a consistent cash flow.<\/span><\/p>\n

How can I calculate the AR cycle?<\/span><\/h2>\n
\"accounts
Source: waytosimple<\/figcaption><\/figure>\n

The accounts receivable cycle begins when goods or services have been delivered but the invoice still needs to be paid. \u00a0 It ends when the invoice has been fully settled.\u00a0<\/span><\/p>\n

The aim of this cycle is to manage the amount of money coming into the business on a consistent basis.\u00a0<\/span><\/p>\n

The cycle is based on the number of days it takes to settle invoices fully. The average payment period is 30 days for small businesses.\u00a0<\/span><\/p>\n

Investopedia provides the following definition:<\/span><\/p>\n

\u2018The average collection period is calculated by dividing a company’s average accounts receivable balance by its net credit sales for a specific period, then multiplying the quotient by 365 days\u2019<\/span><\/i> [4]<\/span><\/p>\n

The benefit of Accounts Receivable Automation in forecasting<\/span><\/h2>\n

The data integrity with automation is much higher than with manual processes.\u00a0 Human error is substantially reduced and instead, data tracking is done by the software.<\/span><\/p>\n

The automation process assists with the collections process by notifications of payments due and automatic reminders sent out to customers.\u00a0<\/span><\/p>\n

Since invoices are produced from populated information and sent directly to the customer in electronic format, the chances of invoices not being paid on time are minimized.<\/span><\/p>\n

Customized reports can be set up to collect forecasting information, greatly increasing the efficiency of the process.\u00a0<\/span><\/p>\n

Envoice<\/span><\/i><\/a> integrates with your accounting software to fully automate the extraction of data from invoices and other documents, providing accurate and real-time data.<\/span><\/i><\/p>\n

\"money
Source: Pexels<\/figcaption><\/figure>\n

Conclusion<\/span><\/h2>\n

As a small business owner, you want as much control as possible over the cash that flows in and out of your business.\u00a0\u00a0<\/span><\/p>\n

One bad payer can negatively affect the financial viability of your business.\u00a0 The entire aim of forecasting is to provide you with the means to prevent or mitigate this.\u00a0<\/span><\/p>\n

Even if you do not have an automated process, you can still benefit from simple accounts receivable calculations.\u00a0 <\/span>This information puts the power back in your hands as a small business owner – exactly where it should be.<\/b><\/p>\n

Further Reading: <\/b>The 7 Best Practices in Accounting That You Should Be Aware Of<\/span><\/a><\/p>\n

 <\/p>\n

Footnotes:<\/b><\/p>\n

[1]<\/span> https:\/\/about.gosite.com\/blog\/accounts-receivable-statistics<\/span><\/a><\/p>\n

[2]<\/span> https:\/\/www.hubspot.com<\/span><\/a><\/p>\n

[3]<\/span> https:\/\/www.saleshacker.com\/sales-forecasting-101\/<\/span><\/a><\/p>\n

[4]<\/span> https:\/\/www.investopedia.com\/terms\/a\/average_collection_period.asp<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Forecasting is a valuable skill that allows small businesses to make informed decisions.\u00a0 However, it may not feel like a priority, with so many other things to consider. Forecasting accounts can incorrectly be thought of solely as an accounts function. It is, in fact, in the best interest of all small business owners to stay […]<\/p>\n","protected":false},"author":1,"featured_media":22579,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[88],"tags":[],"class_list":["post-22576","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounts-receivable"],"acf":[],"_links":{"self":[{"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/posts\/22576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/comments?post=22576"}],"version-history":[{"count":4,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/posts\/22576\/revisions"}],"predecessor-version":[{"id":24573,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/posts\/22576\/revisions\/24573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/media\/22579"}],"wp:attachment":[{"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/media?parent=22576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/categories?post=22576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/envoice.eu\/en\/wp-json\/wp\/v2\/tags?post=22576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}