What Is Accounts Receivable Aging? How To Read An Aging Report**

Accounts receivable aging is a method of grouping unpaid customer invoices by how long they have been outstanding or past due. An accounts receivable aging report turns an overdue balance into a clearer picture of which invoices need attention, how old the cash is and where collection risk may be increasing.

Aging is useful because $100,000 that is one day overdue is not the same collection problem as $100,000 that has been unpaid for 90 days. The balance may look identical in the general ledger but the likelihood of collection, the required action and the potential impact on cash flow can be very different.

Aging schedules commonly use 30-day groups such as 30 days, 31–60 days and 61–90 days past due. Aging reports can also help businesses identify receivables at risk of delay or default and improve cash flow forecasting.

What Is An Accounts Receivable Aging Report?

An accounts receivable aging report is a report that categorises outstanding customer invoices according to how long each invoice has been unpaid or overdue. The report usually shows the customer, invoice details, outstanding amount, due date and an aging bucket.

The purpose is not simply to produce another finance report. An aging report helps a finance team decide where to focus collection work. A customer with a $25,000 invoice that is 5 days overdue may need a routine reminder, while a $25,000 invoice that is 95 days overdue may require a different conversation, an escalation or an assessment of collection risk.

Aging reports are also commonly called accounts receivable aging reports, AR aging reports or aging schedules.

How Does Accounts Receivable Aging Work?

Accounts receivable aging works by taking unpaid invoices and sorting them into time-based buckets. The exact buckets can vary by business but 30-day intervals are common.

The buckets are not a universal risk score. A customer with 60-day payment terms may naturally have invoices that remain current longer than a customer on 30-day terms. Aging needs to be interpreted alongside the agreed payment terms, customer history, invoice amount, disputes, payment commitments and other context.

What Information Is Included In An Aging Report?

A typical accounts receivable aging report includes customer information, invoice details, outstanding amounts, due dates and the amount of time an invoice has been outstanding.

The most useful aging reports allow finance teams to move from the summary to the underlying invoices. A total such as "$1.2 million over 60 days" is useful for management but it becomes actionable only when the team can identify which customers and invoices make up that balance.

A practical aging report may include:

• Customer name or account: Identifies who owes the money.
• Invoice number: Connects the balance to the original receivable.
• Invoice date: Shows when the receivable was created.
• Due date: Establishes when payment was expected.
• Outstanding amount: Shows how much cash remains unpaid.
• Aging bucket: Shows how long the invoice has been overdue.
• Payment status: Distinguishes unpaid, partially paid, and paid invoices where applicable.
• Collection context: Adds information such as disputes, payment commitments, or the next action.

The last category is where a traditional aging report can become less useful. Age tells finance how long cash has been stuck. It does not always explain why.

How Do You Calculate Accounts Receivable Aging?

Accounts receivable aging is calculated by comparing an invoice's due date with the reporting date and assigning the unpaid balance to the appropriate aging bucket.

For example, if an invoice was due on July 1 and the report is run on August 15, the invoice is 45 days overdue and would normally fall into the 31–60 day bucket.

The basic process is:

• Identify all outstanding invoices.
• Confirm each invoice's due date.
• Compare the due date with the reporting date.
• Calculate the number of days overdue.
• Assign each invoice to an aging bucket.
• Total the outstanding amounts within each bucket.
• Review the oldest and highest-value balances first.

The calculation itself is simple. The harder part is deciding what each aging balance means and what action should follow.

Why Is An Accounts Receivable Aging Report Important?

An accounts receivable aging report is important because it shows where unpaid cash is concentrated and helps finance teams prioritise collection work. It can also reveal credit risk, recurring payment problems, collection weaknesses and potential bad debt.

Aging can also improve cash forecasting. If $500,000 is current and $300,000 is more than 90 days overdue, treating the entire $800,000 as equally likely to arrive soon can produce an unrealistic cash forecast.

How Should You Read An Aging Report?

Read an aging report from the oldest balances and highest-value exposures, then investigate why those invoices remain unpaid. The goal is to identify which balances are likely to convert to cash, which require collection action and which are blocked by an issue that chasing alone cannot solve.

Look for five signals:

1. A growing 60+ or 90+ balance. This can indicate that cash is becoming harder to collect or that the collection process is not addressing the underlying blockers.
2. A small number of customers holding a large share of overdue cash. Concentration increases exposure because one customer can materially affect cash flow.
3. The same customers appearing in older buckets repeatedly. This can indicate persistent payment behaviour or a customer-specific process issue.
4. Invoices that are overdue despite an active dispute. A disputed invoice should not be treated like an ordinary late payment because the blocker may be an incorrect amount, PO mismatch, scope question or another objection.
5. Large balances with no clear next action. An aging report shows age but someone still needs to decide what should happen next.

The most useful question is not "How much is overdue?" It is "What is blocking each significant balance from becoming cash?"

What Does An Aging Report Tell You About Cash Flow?

An aging report tells you how much receivable cash is current, recently overdue, materially overdue or severely overdue. That distribution helps finance teams estimate how much of the outstanding balance is likely to convert soon and where cash flow may be under pressure.

An aging report is not a cash forecast by itself. It is one input into forecasting because actual collection depends on customer behaviour, payment terms, disputes, payment commitments, invoice accuracy and other factors.

What Are The Limitations Of Accounts Receivable Aging?

An aging report can show where cash is stuck without fully explaining why it is stuck. Payment timing, unusual credit terms, billing cycles, unapplied credits, disputes and recently initiated payments can all affect how a balance appears.

For example, an invoice may look severely overdue even though the customer has already provided payment evidence. Another invoice may be 15 days overdue because the customer is disputing the amount. A third may be 45 days overdue because nobody followed up.

These three invoices have the same basic aging problem but require three different actions.

This is why aging should be combined with invoice-level context. The report should help prioritise attention, not replace judgment.

How Can You Use Aging To Improve Collections?

Use aging to prioritise collection work rather than treating every overdue invoice equally. The oldest balances and largest exposures usually deserve immediate review but the reason behind the delay should determine the next action.

The important distinction is between collection activity and problem resolution. A reminder can help when the customer simply needs a prompt. It cannot fix a wrong invoice, resolve a PO mismatch or answer a scope question.

How Does Accounts Receivable Aging Connect To DSO?

Accounts receivable aging and days sales outstanding measure different aspects of collections. Aging shows how unpaid invoices are distributed by age while DSO measures the average number of days it takes to collect receivables.

A business can have a reasonable DSO while still carrying a worrying concentration of very old invoices. Conversely, a temporary increase in DSO may be less concerning if the oldest aging buckets remain stable and the increase comes from a large volume of recently issued invoices.

Using both metrics gives finance teams a better view of cash movement. DSO provides a high-level trend while aging shows where the underlying receivables sit.

How Does Bruvora Receivables Help Finance Teams Act On Aging?

Bruvora Receivables connects invoice activity, customer engagement, follow-ups, disputes, payment information and cash application in one accounts receivable workspace. The goal is to give finance teams context around outstanding invoices instead of reducing every unpaid balance to another reminder.

Aging tells the team how old a receivable is. Bruvora Receivables helps provide the context needed to determine what should happen next.

For example, an overdue invoice can have customer engagement around it, an active dispute, a payment commitment, or payment information that needs to be connected to the receivable. Bruvora Receivables keeps those activities connected to the invoice so the team can identify what is blocking cash and prioritise the next action.

Bruvora Receivables also supports invoice approvals before an invoice is sent, automated follow-ups, dispute management, customer self-service, payment advice, settlements and cash application. These workflows address different reasons why an invoice can remain unpaid, rather than treating aging as a problem that can always be solved with another reminder.

The result is a more useful way to work from aging data: identify the oldest cash, understand what is blocking it, assign the right action and let appropriate workflows handle the repetitive parts.

Improve Your Accounts Receivable Process With Bruvora

Aging shows you where your cash is stuck. Bruvora Receivables helps you understand what is blocking payment and take the right action.

Start a free trial or book a 15-minute walkthrough with the Bruvora team to see how you can turn aging data into more actionable collections workflows.