How to Read an Aging Report — AiranSuite Academy
schoolBeginner · 7 min

How to Read an Aging Report (Without a Finance Degree)

Module 1: Accounts Receivable Fundamentals, Chapter 3

The short answer

An aging report sorts every unpaid invoice into buckets based on how overdue it is, usually Current, 1-30, 31-60, 61-90, and 90+ days. Reading one well means checking two things: how much of your total AR sits in the older buckets, and which specific clients are driving that number.

What is an aging report actually for?

It turns a long list of unpaid invoices into a shape you can act on at a glance. Instead of scrolling through every open invoice individually, you see your total receivables broken into time-based buckets, so it's immediately obvious whether your AR is mostly current and healthy, or increasingly stuck in the older, riskier columns.

What are the standard aging buckets?

Standard structure
BucketWhat it means
CurrentNot yet past due
1–30 daysRecently overdue, usually still low risk
31–60 daysWorth a direct follow-up, this is often the first real alert
61–90 daysA genuine problem account, needs escalation
90+ daysHigh risk of never being collected

Some businesses add finer buckets (91-120, 120+) for more granularity, but the five above are the standard almost every accounting platform defaults to.

What does a healthy aging report look like?

For a small B2B business on Net 30 terms, a reasonable benchmark is roughly 70% or more of total AR sitting in the Current bucket, under 20% in the 1-30 day bucket, and under 5% beyond 60 days combined. If more than about 20-25% of your total AR is past due, that's usually a sign collections needs real attention, not just patience.

Worked example

Reading a real aging report
BucketAmount% of Total
Current$42,00060%
1–30 days$14,00020%
31–60 days$7,00010%
61–90 days$4,2006%
90+ days$2,8004%

This business is close to healthy but not quite there, Current is a bit below the 70% benchmark, and the 61-90 and 90+ buckets combined are at 10%, above the 5% threshold worth watching. The right response isn't panic, it's a direct follow-up on whichever specific accounts are sitting in those two oldest buckets.

How often should you actually look at it?

Weekly for active collections work, monthly at minimum as part of a broader financial review. Waiting a full month to check means an invoice that slipped into the 31-60 day bucket in week one doesn't get any attention until it's already deep into the next bucket.

What's the one mistake almost everyone makes reading one?

Looking only at the total dollar amount overdue, and ignoring which specific clients are driving it. A single slow-paying client can distort the whole picture. The aging report's real value isn't the summary number, it's the ability to drill into exactly who's aging and act on that account specifically.

Quick check

Three questions. No email required, this one's just for you.

1. A client's invoice was due 45 days ago and still hasn't been paid. Which bucket does it fall into?

2. For a small B2B business on Net 30 terms, what's a reasonable target for the Current bucket?

3. What's the biggest mistake business owners make when reading an aging report?

Frequently asked questions

Can I customize the aging buckets for my business?

Yes. The 0-30/31-60/61-90/90+ structure is the default in most accounting platforms, but you can adjust bucket sizes to match your own payment terms or add categories like "Disputed" or "In Payment Plan."

Does a big 90+ day balance mean that money is gone?

Not automatically, but the odds get worse the longer it sits. Treat any invoice that reaches this bucket as a priority to resolve directly, whether that's payment, a payment plan, or a formal write-off decision.

Is an aging report the same as a DSO calculation?

No. DSO gives you one overall number describing your average collection speed. An aging report shows the same information broken out by client and by how overdue each invoice is, more detail, less summary.

Sources

  1. Stripe, "What is an aging report for accounts receivable?"
  2. Can You Pay That, "Accounts Receivable Aging Report: How to Read & Use It"
  3. Ledgerup, accounts receivable aging report guide

Prefer to have this run for you?

A Receivables Review shows exactly where your own AR process could improve.

Book a Receivables Review
Footer snippet — AiranSuite