How to Evaluate Accounts Receivables
According to the Federal Reserve Bank of St. Louis, collection agencies saw $16.28 billion in revenue in 2019. While revenues have declined somewhat in recent years, unpaid invoices are still big business. Accounts receivable aging reports can help companies identify and mitigate unpaid invoices and potentially lower a business’ need to send unpaid invoices to collection agencies.
An accounts receivable aging report analyzes how well a company manages its accounts receivables (AR) and identifies the level of any abnormalities. It looks at receivables based on their age; specifically, the time the invoice has been unpaid and outstanding. Then, once receivables have been analyzed for non-payment based on different time frames, the business can determine whether to follow up with the customer, send it to collections, or write the invoice off.
Whether it’s created manually through a spreadsheet or done in conjunction with accounting or billing software, either way the AR aging report takes data from the company’s accounts receivable ledger. The following is a general overview of how to create this report:
Step 1: Aggregate invoices and determine if any credit memos or outstanding adjustments on outstanding invoices need to be addressed first.
Step 2: Create time frames for the invoices, be it buckets such as: 1. 0-30 days. 2. 31-60 days. 3. 60+ days. These can be referred to as “aging buckets” to categorize the invoices.
Step 3: Ensure fields for customer information, invoice details, invoice amounts, notes, etc., are ready for the information to flow into.
Step 4: Calculate unpaid invoice balances and group them by customer and time frame.
While this is only an example and can be modified based upon the company’s needs, it’s a starting point for further analysis. From there, along with updating the report on a monthly, quarterly or annual basis, the company can identify how to improve its cash position by determining its weak points.
One important consideration, especially for businesses with high levels of old, uncollected receivables, is that the company’s collection practices can be re-evaluated more effectively. The analysis can show that some customers take too long, and the company needs to be more proactive in following up with them sooner. It can also convey the need to incentivize their collections with early payment discounts.
This data also enables a company to identify customers who have outstanding payments and assess the associated risk to the company’s credit rating. Especially for publicly traded companies, and even for private equity investment evaluations, investors can see how competitive or not their credit rating is compared to similar companies in the same industry. When analyzing customers, it may be necessary to tighten terms or simply stop doing business with the customer.
Companies can offer pre- or early payment terms, with discounts available to customers who pay their invoices upon receipt or within a certain time frame. During challenging conditions for a particular sector or for the economy overall, businesses can set up payment plans to maintain positive relations with certain customers.
While there’s no perfect accounts receivable aging report, an effective one will organize, identify, and reduce the likelihood of increasing numbers of unpaid invoices.
Sources
https://fred.stlouisfed.org/series/REVEF56144ALLEST
Disclaimer 
