How to Calculate the Year-End Accounts Receivable Balance Based on ACP

Westend61/Westend61/GettyImages

The ability to come up with an estimate for year-end accounts receivable (A/R) helps companies assemble budgets or forecast financial statements. Accounts receivable represents the credit sales a company makes to its customers that have been billed but not yet paid by the customer. Getting a feel for how much customers could owe the company on credit at the end of the year helps a company project sales, expenses and cash flow needs, among other financial metrics.

What's ACP?

Companies want to know how soon they'll get their money after making a credit sale to a customer. Once a sale is made but before the customers send in a check for payment, the company accounts for unpaid customer balances in its financial statements in the A/R asset account on the balance sheet. The company can calculate its average collection period (ACP), which shows management the average number of days the company waits before the customers pay their bills – in other words until the company collects on its accounts receivable balance.

Figuring Out Year-End A/R

To calculate year-end accounts receivable, you don't need to estimate your company’s ACP. Take the starting A/R balance at the beginning of the year, plus the ending A/R balance at the end of each month. This gives you 13 months of A/R balances. Add these and divide the total by 13 to get the average A/R balance for the year; use this for your year-end figure. Using the balance each month as part of your averaging calculation allows you to factor in fluctuations in A/R due to busier sales during certain months such as the Christmas holiday season.

Calculate the ACP

Now that you've calculated your year-end average A/R balance, you can use this to calculate your company's ACP and understand the relationship between these figures. To calculate the ACP, first need to estimate the company's full year's sales amount made to customers, but only those made on credit terms. For a budget or forecast, you could use the previous year's credit sales numbers as a starting point and then factor in some growth to arrive at an estimate for the current or upcoming year forecast.

To solve for ACP, you use the following formula:

ACP = 365 days ÷ A/R Turnover ratio

Where A/R turnover ratio = (Annual credit sales ÷ Average A/R)

You may also calculate ACP more simply:

ACP = Average A/R balance ÷ Average credit sales per day

Where average credit sales per day = (Annual credit sales ÷ 365).

What the ACP Reveals About Accounts Receivable

A lower ACP is favorable and shows that you collect your receivables quickly. For example, if your ACP calculation is 30, this suggests your company collects its accounts receivable invoices, on average, within 30 days. A company might also find that, even though it issues invoices with payment terms of net 30 (giving the customer 30 days to pay), the ACP calculation shows that it has been taking customers 45 or more days to pay. This could impact cash flow and the company's ability to pay its bills if it's not being paid quickly enough by its customers.

References

About the Author

Cynthia Gaffney has spent over 20 years in finance with experience in valuation, corporate financial planning, mergers & acquisitions consulting and small business ownership. She has worked as a financial writer and editor for several online finance and small business publications since 2011, including AZCentral.com's Small Business section, The Balance.com, Chron.com's Small Business section, and LegalBeagle.com. A Southern California native, Cynthia received her Bachelor of Science degree in finance and business economics from USC.