What Is an Accounts Receivable Aging Report and How Do You Read One?

What Is an Accounts Receivable Aging Report and How Do You Read One?

An accounts receivable aging report is a list of every unpaid customer invoice, sorted by how long it has been outstanding. It groups balances into age buckets, typically current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90, so you can see not just how much you are owed but how long you have been waiting for each piece of it.

Your accounting software can produce one in a click. Most owners have never opened it. That is a shame, because it is the single most actionable report a small business has, and unlike the profit and loss it tells you something you can do something about this week.

What the Report Actually Contains

Every aging report has the same anatomy: one row per customer, columns for each age bucket, and a total. Some versions break out individual invoices under each customer, which is the more useful view once a customer has more than one open item.

Here is a simplified example for a business with 148,000 dollars outstanding.

Customer	Current	1-30	31-60	61-90	90+	Total
Northside Property Mgmt	18,000	16,000	14,000	0	0	48,000
Grantham Medical	12,000	0	0	0	0	12,000
Vertex Offices	9,000	9,000	0	0	0	18,000
Lakeshore Retail	4,000	4,000	4,000	4,000	22,000	38,000
31 other accounts	21,000	8,000	3,000	0	0	32,000
Total	64,000	37,000	21,000	4,000	22,000	148,000

The total is the least interesting number on the page. Everything useful is in the distribution.

How to Read the Buckets

Current is money not yet due under your terms. A healthy business has most of its balance here. If yours does not, you have either a collections problem or terms that do not match how your customers actually pay.

1 to 30 days past due is normal friction. Invoices get routed to the wrong person, approvals wait for someone's return from vacation, a check cycle runs twice a month instead of weekly. This bucket rarely requires action beyond a reminder.

31 to 60 days past due is where the report earns its keep. An invoice at this age is still a reminder rather than a confrontation, and the customer relationship is intact. Every dollar you collect here is a dollar that never enters the difficult buckets. If you only have fifteen minutes a week for receivables, spend all of it here.

61 to 90 days past due means something specific has gone wrong. A dispute you were not told about, an invoice that never arrived, a customer with a cash problem of their own, or a purchase order requirement nobody communicated. Find out which. The answer determines whether this is a paperwork fix or a credit risk.

Over 90 days is a decision, not a follow-up. Escalate, negotiate a payment plan, send it to collections, or write it off. What it should not be is a number that sits on the report indefinitely making your balance sheet look better than your business is.

In the table above, the distribution tells two completely different stories. Northside is large but moving normally through the buckets, which is the profile of a big customer with a slow approval process. Lakeshore has 22,000 dollars past 90 days and a steady drip in every other bucket, which is the profile of a customer you are still serving while they do not pay you. Same report, opposite problems.

How to Calculate DSO From the Same Data

Days sales outstanding converts the aging report into one number you can trend. The standard formula is accounts receivable divided by revenue for the period, multiplied by the number of days in the period.

Using the example: 148,000 dollars of receivables against 165,000 dollars of revenue for a 30-day month gives roughly 27 days. Compare that to your terms. If you bill net-30 and run at 27 days, collections are working. If you bill net-30 and run at 60, you have about a month of revenue sitting in someone else's bank account.

Two cautions on DSO. It is distorted by a single large invoice at either end of the period, so read it as a trend over several months rather than as a monthly verdict. And a seasonal business will produce swings that reflect the calendar rather than performance, so compare each month to the same month last year rather than to last month.

Concentration Is a Separate Finding

The aging report answers a question most owners never ask: how much of what you are owed depends on one relationship?

In the example, Northside is 48,000 dollars of a 148,000 dollar balance, roughly a third. That is a different risk from having the same amount spread across thirty accounts. If Northside delays a cycle, you feel it in payroll. If they fail, you have a serious problem rather than a bad month.

Concentration is not automatically bad, and large anchor clients are how many service businesses become profitable in the first place. It is a risk to know about and manage, through deposits, progress billing, tighter terms, or deliberately pursuing accounts that reduce the ratio over time.

When a Receivable Stops Being an Asset

An invoice sits on your balance sheet as an asset at full value until you decide otherwise. That is a convention, not a fact about whether you will be paid.

There are two broad approaches to that gap. Under GAAP, businesses estimate expected credit losses and record an allowance for doubtful accounts, a contra-asset that reduces receivables to the amount realistically collectible. This keeps the balance sheet honest without waiting for certainty on any single invoice. Many small businesses on simpler books instead use direct write-off, removing a specific invoice once it is determined to be uncollectible.

The two approaches are not interchangeable for tax purposes. An estimated allowance is generally not deductible; the business bad debt deduction generally requires that a specific debt be worthless, and it is generally available only to businesses on the accrual basis, since a cash-basis business never recorded the income in the first place. That distinction catches people out, so the book treatment and the tax treatment are worth confirming separately with your accountant.

Practically speaking, a receivable stops being an asset when you would not accept it as payment for anything. If you would not take that invoice in trade, do not carry it at face value.

Making the Report Do Work

The report has no value as a report. It has value as a fifteen-minute weekly habit with one person accountable for it, working the 31-to-60 bucket, with a defined escalation ladder so early contacts can stay friendly.

For a worked example of what that looks like in practice, see how a commercial cleaning company cut its collections cycle from 68 days to 34. If your books are too far behind for the report to be trustworthy, that is the first thing to fix, and you can compare bookkeepers and accountants by specialty and verified client reviews in the Sam's List directory.

Frequently Asked Questions

What are the standard accounts receivable aging buckets? Most reports use current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. These groupings are a widely used convention rather than an accounting requirement, and businesses with unusual payment cycles sometimes adjust them. What matters is that the buckets are measured against your stated payment terms.

How do I calculate DSO from an aging report? Divide total accounts receivable by revenue for the period, then multiply by the number of days in that period. For 148,000 dollars of receivables against 165,000 dollars of monthly revenue, DSO is roughly 27 days. Compare the result to your billing terms and read it as a multi-month trend, since one large invoice can distort a single period.

How often should I review the aging report? Weekly is the practical standard for a business that invoices on terms, and fifteen minutes is usually enough. Reviewing monthly means invoices routinely reach the 60-day bucket before anyone notices, which is the point at which a reminder becomes a negotiation.

What is the difference between an allowance for doubtful accounts and a write-off? An allowance is an estimate of receivables you do not expect to collect, recorded as a contra-asset that reduces the reported balance without identifying specific invoices. A write-off removes a specific invoice determined to be uncollectible. Under GAAP the allowance approach is standard; for tax purposes a deduction generally requires a specific worthless debt and an accrual-basis business, so confirm both treatments with your accountant.

---

About the author: Kimberly Green is the cofounder of Sam's List, where business owners and high earners find vetted CPAs, financial advisors, and fractional CFOs. She's met one-on-one with 400+ financial professionals and writes from the real data behind thousands of client-advisor matches. Ask her anything about finding an accountant - she's heard it all, including the questions people are afraid to ask.