A doubtful account is an account that you expect will never be paid off. You can use aging to estimate what your allowance for doubtful accounts will be. There is one more point about the use of the contra account,Allowance for Doubtful Accounts. In this example, the $85,200 totalis the net realizable value, or the amount of accounts anticipatedto be collected.

Benefits of accounts receivable aging

The second reason is so that the company can calculate the number of accounts for which it does not expect to receive payment. Using the allowance method, the company uses these estimates to include expected losses in its financial statement. Accounts receivable aging sorts the list of open accounts in order of their payment status. There are separate buckets for accounts that are current, those that are past due less than 30 days, 60 days, and so on.

• For the past 52 years, Harold Averkamp (CPA, MBA) has worked as an accounting supervisor, manager, consultant, university instructor, and innovator in teaching accounting online.
• Either way, the past due intervals show you how much is overdue, how long it has been an outstanding balance, and which accounts need immediate attention (e.g., contact the customer for payment).
• The calculation matches bad debtwith related sales during the period.
• Update these reports regularly (many businesses choose a monthly cadence).
• It helps estimate uncollectible receivables and can improve collections.

What Is Accounts Receivable Aging?

The aging report is an essential tool to estimate potential bad debts used to revise allowance for doubtful debts. The general method is to derive the historical percentage of invoice dollar amounts and apply the percentage total columns of the aging report. If your business chooses to factor in outstanding invoices (i.e., sell debts from credit sales for someone else to collect), AR aging reports are a necessary piece of documentation. These reports will help your factoring company set the factoring rate. If you do end up incurring a bad debt expense, you’ll need to provide evidence in the form of accounts receivable aging reporting (along with other documentation). As a result, it’s important that the company’s credit terms match the time periods on the report for an accurate representation of the company’s financial health.

Disadvantages of Aging Report

Since many companies bill at month-end and run the aging report days later, outstanding accounts from a month prior will show up. Even though payments for some invoices are on the way, receivables falsely appear in a bad state. Running the report prior to month-end billing includes fewer AR and shows little cash coming in, when, in reality, much cash is owed.

On the assumption that the longer an account is outstanding, the less likely its ultimate collection is, an increasing percentage is applied to each of these categories. A credit entry is made to Allowance for Uncollectible Accounts, thereby adjusting the previous balance to the new, desired balance. The debit part of the entry is made to the Uncollectible Accounts Expense account. The aim is to estimate what percentage of outstanding receivables at year-end will not be collected. This amount becomes the desired ending balance in the Allowance for Uncollectible Accounts.

Bad Debt Expense increases (debit), and Allowance for DoubtfulAccounts increases (credit) for $48,727.50 ($324,850 × 15%). Thismeans that BWW believes $48,727.50 will be uncollectible debt.Let’s consider that BWW had a $23,000 credit balance from theprevious period. To illustrate, let’s continue to use Billie’s WatercraftWarehouse (BWW) as the example. BWW estimates that 5% of its overall credit saleswill result in bad debt.

The company’s management should generate aging reports monthly to know about the due invoices and notify customers accordingly. Accounts receivables aging is the time period from when sales are realized, and accounts receivables are created to the balance sheet. The aging schedule is used to identify clients that are late in paying their invoices. If the bulk of your overdue amounts is attributable to a single client, your business can take the necessary steps to ensure that the customer’s account is collected promptly. Your AR aging report is a useful tool when deciding whether to adjust your practices and policies for selling and extending credit to clients, such as only accepting cash sales. These changes can be made for all of your accounts or could be implemented for only high-risk customers who regularly struggle to make payments on time.

Let’s assume that a company’s Accounts Receivable has a debit balance of $89,400. However, there are a few customers’ invoices that are more than 60 days past due. Those past due accounts are reviewed closely and based on each customer’s information it is estimated that approximately $7,400 of the $89,400 will not be collected. Therefore the credit balance in the Allowance for Doubtful Accounts must be $7,400. This will result in the balance sheet reporting Accounts Receivable (Net) of $82,000.

The understanding is that the couplewill make payments each month toward the principal borrowed, plusinterest. With an aging report, you can identify problems in your accounts receivables. For example, payroll journal entries for salaries many business owners bill customers toward the end of the month. This can make an aging A/R report misleading because if a customer pays just a few days later, it can show up as past due on the report.

AR aging reports are important because they can help businesses keep track of outstanding payments from customers. You can generate an accounts receivable aging report to calculate and improve your accounts receivable turnover ratio. An aging schedule is an accounting table that shows a company’s accounts receivables, ordered by their due dates. Often created by accounting software, an aging schedule can help a company see if its customers are paying on time. It’s a breakdown of receivables by the age of the outstanding invoice, along with the customer name and amount due. Without an accounts receivable aging report, it can be difficult to maintain a healthy cash flow and identify potentially bad credit risks to your business posed by doubtful accounts.