Accounts receivable aging report: Guide for 2023

As a small business owner, there’s nothing more disgruntling than not getting paid. Business owners use accounts receivable aging reports to determine which customers have invoices with outstanding balances. This collection tool makes it easy for businesses to identify late-paying customers and set invoice payment terms. In an aging schedule, accounts receivables are broken down into age categories, indicating the total outstanding receivables balance. The aging schedule shows the relationship between unpaid invoices and bills of a business with their due dates. The aging schedule is used to determine which clients are paying on time and may also estimate cash flow.

They can be cleaned up by finding which invoices they are applied against and reducing the amount of overdue receivables on the aging report. The report primarily contains invoices, but it may also contain credit memos that have not been used by customers, or which have not yet been matched against an unpaid invoice. Maybe the invoice got lost in the mail or perhaps the customer fell upon financial hardship and isn’t able to pay you as promised. Occasionally, a customer will withhold payment because they are dissatisfied with the product or service you sold to them. You’ll list all your customers that have an open invoice and then do the same thing we did in step three for all your customers.

  • You group your customer invoices into date ranges rather than listing specific dates for when an invoice is due.
  • Depending on their customers’ payment history and behavior, many business owners don’t get overly concerned about amounts in the 1-30 silo.
  • The specific receivables are aggregated at the bottom of the table to display the total receivables of a company, based on the number of days the invoice is past due.
  • It’s that simple and is a canned report in most, if not all, accounting packages.
  • However, if you see multiple clients are late on payments, it might be an issue with your customer credit policy.

The aging method also makes it easier for management to make changes in credit policies and discounts offered to customers. An aging report allows you to identify problems and issues in accounts receivable. You can then take steps to remedy those problems, such as getting clients to pay invoices faster or preventing cash flow issues. The aging schedule is used to identify clients that are late in paying their invoices. If the bulk of the overdue amount is attributable to a single client, the business can take necessary steps to ensure that the customer’s account is collected promptly.

To demonstrate the application of the aging method, we will use the data from the Porter Company. The total of these figures represents the desired balance in the account Allowance for Uncollectible Accounts. 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.

It means the company estimates 1% of the total unpaid invoices due within 30 days are historically not collected. Similarly, once an invoice goes beyond 90 days, there is a 50% chance it will not be paid by the client. The next step in the calculation is to assign a percentage weightage to each category of accounts receivable to calculate bad debt allowance. Late payments are problematic for several reasons, including disrupting a company’s cash flow.

What is the approximate value of your cash savings and other investments?

Estimating bad debts allows a company to revise its allowance for doubtful accounts. Companies usually use previous A/R aging reports to determine the historical percentage of invoice dollar amounts for each date period that resulted in bad debts. With this report, you’re able to look at which customers owe money and how behind they are on payments. Accounts receivable aging is useful in determining the allowance for doubtful accounts. When estimating the amount of bad debt to report on a company’s financial statements, the accounts receivable aging report is useful to estimate the total amount to be written off.

You can see whether this ratio goes up over time, taking a long time to collect. You’ll notice this sample company — Craig’s Design and Landscaping Services 10 things to consider when choosing an accounting firm — has amounts due from several customers. However, if you see multiple clients are late on payments, it might be an issue with your customer credit policy.

  • While generating the accounts receivable aging report, make sure to include the client information, status of collection, total amount outstanding and the financial history of each client.
  • The delinquency reports and bad debt figures can be calculated easily directly from the invoice data management system too.
  • An aging report allows you to identify problems and issues in accounts receivable.
  • The second one is to calculate the aged accounts receivable by using the formula listed below.

You can then take action to get your outstanding payments addressed, such as sending a follow-up invoice or reaching out to a collection agency. Depending on your preferences, you can adjust date ranges in your A/R aging report. Business owners use the aging schedule to determine which clients are paying on time and which clients have outstanding invoices.


First, based on a historical analysis of collectibility, we assign a probability of collection to each category. Obviously, the older an account is, the less likely we will be able to collect it. Get up and running with free payroll setup, and enjoy free expert support. The total of the amounts due in each date silo is shown at the bottom of each column.

They might refuse to do additional work for the customer until the balance is paid in full, and they might refuse to extend credit to that customer in the future. Some business owners will even start mentioning the possibility of sending the amount to collections at this point. As a business owner, the last thing you want is to sell your products or services and not get paid or be paid late. That’s why it’s important to stay on top of your finances and keep track of who owes you to maintain your company’s financial health. The aging report also shows the total invoices due for each customer when grouped based on the age of the invoice. The company should generate an aging report once a month so management knows the invoices that are coming due.

Types of Accounts Receivables Aging

Accounts receivable aging is a periodic report that categorizes a company’s accounts receivable according to the length of time an invoice has been outstanding. It is used as a gauge to determine the financial health and reliability of a company’s customers. The aging report is generated by accounting software to structure the report for a different date range. The report contains invoices and credit memos that customers have not used.

How to create an AR aging report

Often, the longer accounts receivables remain outstanding, the less likely you will collect them. You’re left with adjusted general journal entries for bad debt expense, which you can later use to identify bad credit risks early and avoid them. Reviewing your accounts receivable aging report at least monthly—and ideally more often—can help to ensure that your customers and clients are paying you. It at least tells you where they stand so you can take steps to collect if necessary.

Example of an Aging Report

Next, sort all invoices by customer name and itemize each client’s invoice. If a client has several bills at different times, the report will show how much is due at what time. It’s worth noting the reason we multiply by 360 days—as opposed to the year’s actual 365. Choosing 360 allows you to avoid overcomplicating your DSO with fractions. Whether or not your company calcululates with 360 or 365 is up to your discretion.

If this is the case, you can compare your credit risk to industry standards to see if you’re taking too much credit risk. For example, most companies bill their customers toward the end of the month, and the aging report is generated days later. This means that the report will show the previous month’s invoices as past the due date, when, in fact, some could have been paid shortly after the aging report was generated. The typical column headers include 30-day windows of time, and the rows represent the receivables of each customer. Aging is considered the most important information when analyzing accounts receivables with ages above an appropriate number of turnover days that will negatively affect a company’s operations. Accounts receivable aging reports can be misleading at times due to several reasons.

The accounts receivable aging report can also indicate which customers are becoming a credit risk to the company. Older accounts receivable expose the company to higher risk if the debtors are unable to pay their invoices. Accounts receivable aging is a cash management technique used by accountants to evaluate the accounts receivable of a company and identify existing irregularities. Additionally, the aging of accounts receivables will help you identify potential delays in the company’s cash flow. By uncovering potential credit risks, you can take preventative measures to protect yourself from more risky customers. The accounts receivable aging report summarizes how long invoices have been unpaid based on predefined buckets, often 30 day increments as of the report date.

If you extend credit to your customers, managing your accounts receivable is one of the most important accounting functions in your business. Without proper management, your accounts receivable can get out of control, causing significant cash flow problems for your business. For example, 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. Also, generating the report before the month ends will show fewer receivables whereas, in reality, there are more pending receivables.

About the Author

About the Author

Jessica Samson, MBA, CHRP, C. Mgr.

Leave a Reply

Your email address will not be published. Required fields are marked *