Accounts Receivable Aging Report: Small-Business Guide

Accounts Receivable Aging Report: A Complete Guide for Small Businesses

Your total accounts receivable balance tells you how much customers owe.

It does not tell you how much is overdue, how long invoices have remained unpaid or which accounts require immediate attention.

An accounts receivable aging report answers those questions by separating outstanding invoices according to age.

Used correctly, the report becomes more than an accounting document. It becomes a working collection tool.

What is an accounts receivable aging report?

An accounts receivable aging report organizes unpaid customer invoices into time-based categories called aging buckets.

A typical report contains:

  • Current invoices
  • 1–30 days overdue
  • 31–60 days overdue
  • 61–90 days overdue
  • More than 90 days overdue

The report may also show:

  • Customer name
  • Invoice number
  • Invoice date
  • Due date
  • Original invoice amount
  • Outstanding balance
  • Total amount owed by each customer
  • Collection notes
  • Dispute status
  • Last contact date
  • Next planned action

The purpose is to show not only how much money is outstanding but where collection risk may be building.

What do the aging buckets mean?

Current

These invoices have not reached their due date.

Current does not mean they should be ignored. Large invoices, new customers and accounts with complicated approval procedures may benefit from a courteous pre-due-date confirmation.

1–30 days overdue

These invoices are recently past due.

The first step is usually to confirm that the invoice was received and determine whether an administrative problem is delaying payment.

31–60 days overdue

At this stage, follow-up should become more direct.

The business should identify disputes, request a payment status and obtain a specific payment date when possible.

61–90 days overdue

These balances require greater attention.

Management may need to review continued credit, broken payment promises, unresolved disputes and the likelihood of collection.

More than 90 days overdue

Invoices in this category may represent elevated collection risk.

The business should verify the documentation, determine why payment remains outstanding and decide whether internal escalation or qualified outside assistance is appropriate.

How to calculate invoice age

Invoice age should normally be measured from the contractual due date—not automatically from the invoice date.

For example:

  • Invoice date: July 1
  • Payment terms: Net 30
  • Due date: July 31
  • Reporting date: August 20

The invoice is 20 days overdue on August 20.

If the report calculates age from July 1, it would incorrectly show the invoice as 50 days old without distinguishing between the allowed payment period and actual delinquency.

Why aging reports matter

Aging reports help businesses:

  • Identify overdue balances
  • Detect growing collection problems
  • Prioritize follow-up activity
  • Review customer payment behavior
  • Track disputed invoices
  • Evaluate credit decisions
  • Estimate allowance for doubtful accounts
  • Support cash-flow planning
  • Monitor collection performance

The report also helps expose operational weaknesses. If many invoices become overdue for the same reason, the problem may be billing accuracy or internal workflow—not customer behavior.

Example of an aging report

CustomerCurrent1–30 Days31–60 Days61–90 Days90+ DaysTotal
Customer A$8,000$0$0$0$0$8,000
Customer B$0$4,500$0$0$0$4,500
Customer C$0$0$7,200$0$0$7,200
Customer D$0$0$0$3,100$6,500$9,600

Customer D deserves attention because the account contains both 61–90-day and 90-plus-day balances.

However, the report alone does not explain whether the invoices are disputed, covered by a payment arrangement or already scheduled for payment.

Analyze your own receivables

Use the free Accounts Receivable Aging Calculator to enter balances by aging category and calculate:

  • Total accounts receivable
  • Total overdue receivables
  • Percentage overdue
  • Percentage more than 60 days overdue
  • Distribution by aging bucket

The calculator provides directional analysis. It is not a substitute for reviewing individual customer accounts.

How to use the report for collections

Do not simply start with the oldest invoice and work downward.

Consider:

  • Amount outstanding
  • Days overdue
  • Customer payment history
  • Recent communication
  • Broken payment promises
  • Open disputes
  • Last follow-up date
  • Strategic importance
  • Likelihood of recovery

Read How to Prioritize Overdue Invoices for a more complete prioritization method.

Aging report versus DSO

An aging report and Days Sales Outstanding measure different things.

An aging report shows where unpaid balances are sitting. DSO estimates how long the business takes to convert credit sales into cash.

Use the free DSO Calculator to measure collection speed, then compare that result with the aging report.

A reasonable DSO can still conceal several severely overdue invoices.

Common aging-report mistakes

Avoid:

  • Aging invoices from the wrong date
  • Leaving paid invoices open
  • Ignoring credits and partial payments
  • Combining disputed and undisputed balances
  • Failing to update payment promises
  • Using broad customer totals without invoice detail
  • Treating every overdue balance the same
  • Allowing multiple spreadsheet versions to circulate

The report must be accurate before it can guide action.

Turn aging data into a workflow

A report identifies the problem. It does not manage the follow-up.

PaymentPilot’s AI accounts receivable software helps small businesses organize invoices, identify priority accounts, review recommended next actions and maintain collection history with human oversight.

Use your aging report to determine where money is sitting, then make sure every important overdue invoice has an owner and next action.

Additional business resources

Use the free Small Business Assessment Tool to review additional operational and insurance considerations.

To discuss your business, schedule a 30-minute conversation.

Samuel Bennett, Licensed Insurance Agent
Island Insurance Group
sam@islandinsurancegroup.com
954-804-8144

This article provides general information and is not accounting, financial or legal advice. Aging methods and reporting practices should be reviewed with a qualified accounting professional.

Similar Posts