How to Read an Accounts Receivable Aging Report

How to Read an Accounts Receivable Aging Report

An unpaid invoice does not always mean a customer is late. One invoice may be due next month, another may be overdue, and a third may already have been paid but recorded incorrectly.

An accounts receivable aging report helps you separate these situations. It organizes outstanding customer balances so you can see what is owed and which amounts need attention.

Learning how to read an accounts receivable aging report starts with checking its date and settings. From there, you can interpret the aging columns, investigate unusual balances, and prepare a sensible follow-up list.

What Is an Accounts Receivable Aging Report?

An accounts receivable aging report groups unpaid customer balances into age ranges, often called aging buckets.

A summary report typically presents balances by customer. A detail report shows the individual transactions behind those balances, allowing you to investigate specific invoices, payments, and credits. Oracle’s documentation describes this distinction between its receivables summary and detail reports. docs.oracle.com

The report helps answer:

  • Who owes the business money?
  • How much remains unpaid?
  • Which amounts are overdue?
  • Which invoices need investigation or follow-up?

It is a snapshot of recorded receivables, not a guarantee of when customers will pay.

Check These Settings Before Reading the Numbers

1. The Report Date

Look for an “as of” date.

A report dated 31 October represents balances at that date. A payment received on 1 November may therefore leave the invoice outstanding in the October report.

Also check whether the software ages balances using today’s date or the selected report date. Intuit documents both approaches and explains that mismatched settings can affect comparisons with other accounting reports. quickbooks.intuit.com

2. The Aging Basis

Confirm whether age is measured from:

  • Invoice date: How long the invoice has existed.
  • Due date: How long payment has been overdue.

These are different measurements.

For example, an invoice issued 45 days ago on 60-day payment terms is not yet overdue. An invoice-date report may show it as 45 days old, while a due-date report should still classify it as current.

FreshBooks explicitly distinguishes outstanding balances aged from the invoice issue date from overdue balances aged from the due date. FreshBooks

3. Currency and Filters

Check whether the report:

  • Includes all relevant customers.
  • Excludes particular accounts or transaction types.
  • Shows original currencies or converted amounts.
  • Includes customer credits and unapplied payments.

Do not add different currencies together without an appropriate conversion basis.

Understand the Aging Columns

The following structure assumes aging is based on days past the due date.

ColumnTypical meaning
CurrentNot overdue as of the report date
1–30 daysPayment is 1–30 days overdue
31–60 daysPayment is 31–60 days overdue
61–90 daysPayment is 61–90 days overdue
91+ daysPayment is more than 90 days overdue
TotalCustomer’s net outstanding balance shown in the report

Software may use different intervals or labels. Intuit’s guidance, for example, distinguishes current amounts from balances aged by days after their due dates. quickbooks.intuit.com

An amount in the oldest bucket deserves investigation, but age alone does not establish that it is uncollectible.

Example: Reading an Accounts Receivable Aging Report

The following figures and customer names are hypothetical. All amounts use the same currency, and balances are aged by due date.

Report date: 31 October

CustomerCurrent1–30 days31–60 days61–90 days91+ daysTotal
Cedar Studio$1,200$300$0$0$0$1,500
Harbor Retail$0$800$400$0$0$1,200
Maple Services$600$0$0$500$0$1,100
Summit Projects$0$0$0$0$700$700
Total$1,800$1,100$400$500$700$4,500

Read Across Each Customer Row

Cedar Studio owes $1,500, but only $300 is overdue. The remaining $1,200 is current.

Harbor Retail owes $1,200 across two overdue buckets. Open the detail report to identify the invoices involved.

Maple Services has both current and older balances. Do not assume its full $1,100 is late.

Summit Projects has $700 more than 90 days overdue. Investigate the reason, previous contact, and any payment arrangement.

Read Down Each Aging Column

The column totals show the overall distribution:

  • Current: $1,800.
  • Overdue: $2,700.
  • More than 60 days overdue: $1,200.

This helps you identify where attention is concentrated.

Calculate the Overdue Percentage

Overdue percentage = Overdue receivables ÷ Total receivables × 100

For this example:

$2,700 ÷ $4,500 × 100 = 60%

That means 60% of the balances shown are overdue.

It does not mean 60% will be lost. Compare the result with your payment terms, previous reports, disputes, and customer circumstances.

This simple calculation assumes positive receivables without unapplied credits. If credits materially affect the report, investigate them before interpreting the ratio.

Use the Detail Report Before Contacting Customers

A summary balance is a starting point. Review the underlying invoice before sending a reminder.

Check:

DetailWhy it matters
Invoice numberIdentifies the exact charge
Invoice and due datesConfirms whether it is late
Remaining balancePrevents requesting an amount already paid
Payment and credit allocationsReveals incomplete accounting entries
Purchase order referenceHelps the customer process the invoice
Dispute statusDetermines whether clarification is needed
Previous correspondencePrevents conflicting follow-ups

A partially paid invoice should contribute its remaining balance rather than its original total. Unapplied payments and credits can also affect customer totals, depending on the report. docs.oracle.com

Common Problems to Investigate

A Customer Says They Already Paid

Check the bank record, payment date, customer account, and allocation.

The payment may have been recorded after the report date or left unapplied to the invoice.

Ask for a payment reference through an appropriate private channel if necessary. Avoid sending repeated demands before checking the records.

A Negative Balance Appears

A negative amount may represent a credit, overpayment, or unapplied receipt. It does not automatically mean the report is wrong.

Investigate the transaction and its correct treatment rather than deleting it to make the total look cleaner.

The Aging Report Does Not Match the Balance Sheet

Compare the reports using the same date, relevant accounts, currency basis, and appropriate accounting settings.

Check filters, opening balances, and entries affecting receivables. Intuit specifically recommends matching report dates and using an accrual-basis balance sheet or trial balance when checking its aging reports. quickbooks.intuit.com

Ask your bookkeeper to investigate unresolved differences.

The Due Date Is Wrong

A default payment term may differ from the agreed contract.

Check the original agreement before correcting the record. Do not change dates merely to move an overdue balance into a newer bucket.

Turn the Report Into a Follow-Up Plan

Prioritize using more than age alone.

Consider the outstanding amount, payment history, dispute status, previous promises, and cash-flow importance.

SituationPractical next step
Current invoiceConfirm it was delivered correctly; avoid an overdue demand
Recently overdueSend a polite reminder
Missing PO or processing informationSupply the required details
Disputed chargeAssign someone to resolve the issue
Agreed payment date missedFollow up on the recorded commitment
Long-overdue balance without progressEscalate under your approved process

Australian government guidance recommends starting with a friendly reminder and discussing a payment date or schedule where appropriate. Formal recovery steps require attention to applicable obligations. business.gov.au

Polite Reminder Template

Subject: Payment reminder — invoice [number]

Hello [name],

Our records show an outstanding balance of [amount] on invoice [number], due on [date].

Could you please confirm the expected payment date? If payment has already been made, please share the payment reference so we can check our records.

If you need another copy of the invoice or additional processing information, please let us know.

Thank you,
[Name and business]

Use this after checking the invoice and recent payments. Keep payment disputes and personal information out of public channels.

What the Report Cannot Tell You

An aging report does not independently establish:

  • Whether an invoice is correct.
  • Why payment is delayed.
  • Whether a customer can pay.
  • Whether the balance is legally recoverable.
  • The appropriate bad-debt allowance or tax treatment.
  • When cash will reach your bank account.

Do not automatically write off every invoice in the oldest bucket. Assess the facts and follow the applicable accounting and tax requirements.

Create a Regular Review Routine

Choose a frequency that fits your invoice volume and cash-flow needs. A weekly operational review may suit a busy credit-sales business; another business may need a different schedule.

For each balance requiring action, record:

  • Responsible staff member.
  • Last contact date.
  • Reason for delay.
  • Agreed action.
  • Promised payment date.
  • Next review date.

Compare successive reports using consistent settings. A falling total is encouraging only when you understand whether it reflects payments, credits, write-offs, or other changes.

Frequently Asked Questions

1. What is the difference between accounts receivable and accounts payable aging?

Receivable aging concerns amounts customers owe your business. Payable aging concerns amounts your business owes suppliers.

2. Does “current” mean the customer has paid?

No. In a due-date-based report, current generally means the outstanding amount is not overdue.

3. Can one customer appear in several aging buckets?

Yes. Different invoices can have different due dates. Review the detail report before treating the customer’s entire balance as overdue.

4. Is every invoice over 90 days overdue a bad debt?

No. It requires investigation, but age alone does not determine collectibility or the correct accounting treatment.

5. Can I use the aging report as a cash-flow forecast?

Use it as an input. Add realistic collection dates, payment arrangements, disputes, and other expected cash movements to build a forecast.

Conclusion

Read the report in three stages: confirm the settings, understand the balances, and investigate the invoices requiring attention.

Then assign clear follow-up actions and keep payment records current. The report becomes useful when its numbers lead to accurate conversations, resolved discrepancies, and realistic collection plans.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

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