AR Aging Report: What It Is and How to Use One

An AR aging report, also called an accounts receivable aging report, shows the unpaid invoices a business is waiting to collect. It groups those invoices by how long they have been outstanding.

Most reports use categories such as current, 1–30 days overdue, 31–60 days overdue, 61–90 days overdue, and 90+ days overdue.

For a small business, this report answers three practical questions: Who still owes you money? How late are they? Which invoices need attention first?

An AR aging report is especially useful when a business has several unpaid invoices. Instead of looking through invoices one by one, the owner can see the entire outstanding balance in one place.

What Is an AR Aging Report?

Accounts receivable (AR) is money customers owe a business for products or services that have already been provided. Once you send an invoice and the customer has not paid it yet, that amount becomes part of your accounts receivable.

An AR aging report takes those unpaid invoices and organizes them by age.

For example:

The report shows more than the total amount customers owe. It shows how long each balance has been outstanding.

That distinction matters.

Imagine two businesses each have $20,000 in unpaid invoices. In the first business, $17,000 is still within the agreed payment terms. Secondly, $12,000 is more than 60 days overdue.

Both businesses have $20,000 in accounts receivable. But the second business has a much bigger collection concern.

An aging report makes that difference visible.

How Does an AR Aging Report Work?

An AR aging report starts with a list of unpaid invoices. Each invoice is assigned to an aging category based on its due date.

The most common categories are:

The exact categories can vary by business. Some businesses may use different ranges based on their payment terms.

Current

A current invoice has not passed its due date. It is still part of accounts receivable, but there is no reason to treat it as a late payment.

For example, if your payment terms are Net 30 and the invoice is only 10 days old, it would normally remain in the current category.

1–30 Days Overdue

These invoices have recently passed their due dates.

A simple reminder may be enough. Before assuming the customer is avoiding payment, check that the invoice was received and that there are no billing issues.

31–60 Days Overdue

At this point, the payment deserves more attention.

Contact the customer directly. Ask whether the invoice is being processed and whether anything is preventing payment.

61–90 Days Overdue

An invoice that has been unpaid for two or three months is a more serious concern.

The business may need to make a more direct payment request. It is also worth checking whether there is a dispute about the work, price, or invoice.

90+ Days Overdue

Invoices in this category carry a higher collection risk.

That doesn't necessarily mean the customer will never pay. But the business should not treat a 90-day-old invoice the same way it treats one that is five days late.

At this stage, the business may need to review its collection process, payment history, and any available options for recovering the balance.

Why Is an AR Aging Report Important for Small Businesses?

Large companies may have dedicated accounting teams tracking receivables. Small businesses often don't.

The owner may be handling sales, customer service, projects, invoices, and collections at the same time. It is easy for an overdue invoice to get overlooked.

An aging report gives the business a simple way to see what needs attention.

It Helps Find Overdue Invoices

Without a regular review, an unpaid invoice can sit unnoticed for weeks.

An aging report puts overdue invoices in one place. You can quickly see which customers have not paid and how late each payment is.

It Helps Prioritize Follow-Ups

Not every overdue invoice deserves the same response.

A $150 invoice that is three days late is different from a $5,000 invoice that is 75 days late.

You can use the report to focus on invoices that are both old and significant in value.

For example:

This doesn't mean ignoring smaller invoices. It simply helps a business decide where to spend its limited time first.

It Can Reveal Cash Flow Problems

An unpaid invoice represents expected revenue, not cash in the bank.

This is an important distinction for small businesses.

Suppose your business has $30,000 in outstanding invoices. That sounds positive until you look at the aging report and discover that $15,000 is more than 60 days overdue.

The problem isn't necessarily a lack of sales. It may be a collection problem.

If the amount sitting in the older aging categories keeps growing, the business may need to review its payment terms, invoicing process, or customer follow-up practices.

How to Create and Use an AR Aging Report

You can create an AR aging report in a spreadsheet, accounting system, or invoicing software. The basic process is the same.

List Your Outstanding Invoices

Start with invoices that have an unpaid balance.

Include partially paid invoices if a balance is still outstanding.

Record the Key Information

At minimum, include:

• Customer name
• Invoice number
• Invoice date
• Due date
• Original amount
• Amount paid
• Outstanding balance

You can also include a notes field for payment promises, disputes, or previous follow-ups.

Calculate the Age of Each Invoice

Compare the invoice's due date with the current date.

If the due date has not passed, mark the invoice as current.

If it has passed, calculate how many days overdue it is and place it in the appropriate category.

Review the Totals

Don't only look at individual invoices. Look at the total amount in each aging category.

For example:

This gives you a quick picture of your receivables.

The $26,500 total is useful, but the distribution is more informative. The $3,200 in the 90+ category deserves attention because those invoices have been outstanding for much longer.

Follow Up Based on the Aging

You can use the report to guide your collection process.

These are guidelines, not fixed rules.

Your approach should also depend on the customer's history. A reliable customer who is usually on time may simply need a reminder. A large unpaid balance from a new customer may require faster attention.

Before escalating a payment request, check whether there is a legitimate reason for the delay. The customer may not have received the invoice. The invoice may have been sent to the wrong person. There may also be a dispute over the amount or work performed.

An aging report tells you which invoices need attention. It does not tell you why the customer hasn't paid. That still requires communication.

What Should an AR Aging Report Include?

A useful report doesn't need to be complicated.

For most small businesses, these fields are enough:

You may also want to track the last follow-up date and next follow-up date.

This is useful when several invoices are overdue. You don't want to send repeated reminders to the same customer without knowing when someone last contacted them.

The report should also be reviewed regularly. A business that sends many invoices may want to review its receivables every week. A smaller business with fewer invoices may review them every two weeks or once a month.

The goal is not to create another report just for record keeping. The goal is to catch payment problems early.

An AR aging report gives a small business a clearer view of its unpaid invoices. It shows which payments are still within their terms, which are overdue, and which may need immediate attention. Used regularly, it can turn invoice follow-up from a last-minute task into a normal part of managing receivables.