Accounts Receivable Aging Report: What It Is, How to Read It, and How to Use It

An accounts receivable aging report is a summary of every unpaid customer invoice, grouped by how long it has been outstanding. It sorts what you are owed into age buckets, usually current, 1 to 30, 31 to 60, 61 to 90, and 90+ days past due, so you can see at a glance which invoices are overdue, how badly, and who owes you the most. It is the single most useful report in accounts receivable, and this guide explains how to read one, how to build it, and how to act on it.

What is an accounts receivable aging report?

An accounts receivable aging report, sometimes called an AR aging report or a schedule of accounts receivable, lists each customer and the total they owe, broken out by the age of the debt. Rather than one lump sum for "total receivables," it shows the same balance split across time buckets so you can separate the invoices that are simply not due yet from the ones that are quietly turning into bad debt. Every accounting system, from QuickBooks to Xero to NetSuite, can produce one, and it is usually run at month-end and any time you want a clear picture of collections.

The report answers three questions a plain balance cannot: how much of what you are owed is actually overdue, which specific customers are behind, and how old the oldest debts have become. That is why lenders, CFOs, and auditors all ask for it. It is the clearest early-warning signal you have for cash-flow trouble.

How do you read an aging report?

You read an aging report left to right, oldest money last. Each row is a customer; each column is an age bucket. The columns move from current (not yet due) through progressively older past-due buckets. Money sitting in the right-hand columns is the money at risk, so a healthy report has most of its balance on the left and very little on the right. Here is what a small report looks like:

Read that report and three things jump out. Acme is healthy, with almost everything current. Bright Retail is slipping, with a balance marching steadily into older buckets, which usually means the reminders are not landing. Delta looks fine on the surface but has $6,750 stuck at 90+ days, the most dangerous number on the page, because debt that old is the least likely to ever be collected. The point of reading the report is to spot exactly those patterns and act before the money ages further.

What are the aging report buckets?

The standard aging buckets are 30-day windows measured from the invoice due date: current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. Some teams add a 120+ column for the oldest debt. The buckets exist because collectability drops sharply with age, so grouping by 30-day bands tells you where each invoice sits on that curve. As a rough rule of thumb that many finance teams use:

• Current: not yet due. Nothing to chase, just keep it moving.
• 1 to 30 days: recently overdue. Usually an oversight; a prompt reminder clears most of it.
• 31 to 60 days: genuinely late. Needs firmer, more frequent follow-up and a specific payment date.
• 61 to 90 days: at risk. Time to escalate beyond email to a call and a promise-to-pay.
• 90+ days: seriously delinquent and increasingly likely to be written off. Final notices, payment plans, or last-resort escalation.

How do you calculate an aging report?

To calculate an aging report, take today's date, subtract each open invoice's due date to get its days-past-due, then drop the invoice amount into the matching bucket and total each column. For a single invoice the math is simple: an invoice due June 1, viewed on July 5, is 34 days past due, so its balance lands in the 31 to 60 column. Do that for every open invoice, group the rows by customer, and sum the columns.

Two related metrics make the report more useful. The first is days sales outstanding, or DSO, which turns the whole report into one number: the average days it takes to collect after a sale. The second is the average collection period for each customer, which shows who consistently pays slow. Rather than rebuild these by hand every month, most teams let their accounting system generate the aging report and then export it to a spreadsheet for deeper analysis. If you need to hand a lender or your board a clean picture of receivables alongside the rest of the numbers, you can turn that same export into a board-ready set of financial statements in a few minutes.

What is a good accounts receivable aging report?

A good aging report is heavily weighted toward the current and 1-to-30 columns, with only a small tail in the older buckets. As a general benchmark, healthy B2B companies keep the large majority of their receivables current and under 30 days, with very little past 90. If a meaningful share of your balance keeps drifting into the 60-plus columns, that is not a customer problem so much as a process problem: the follow-up is not consistent enough, and cash that you have already earned is sitting on the sidelines.

The report also feeds a real accounting entry. Companies use the aging schedule to estimate their allowance for doubtful accounts, applying a higher expected-loss percentage to each older bucket, because a dollar at 90+ days is worth far less than a dollar that is current. That is why auditors lean on it and why keeping the right-hand columns thin is worth real effort. The mechanics of that estimate, including FASB's own worked example and the plug entry people get wrong, are in the aging of accounts receivable method guide.

How to use the aging report to get paid faster

The report only creates value when it drives action. The routine that works is to run the aging report on a fixed cadence, sort by the oldest bucket, and work the list from the most overdue down, matching the firmness of your outreach to the age of the debt. Early buckets get a friendly nudge; older ones get a call and a firm request for a payment date. Consistency is everything, because the main reason balances age is not stubborn customers but follow-up that stops when month-end gets busy.

This is exactly the work that automation handles well. Instead of pulling the report by hand and chasing each line, an collections automation platform reads your live aging report and follows up on every overdue invoice on schedule. The most complete version is an AI accounts receivable agent that connects to QuickBooks, Xero, or NetSuite, watches the aging report in real time, and chases each invoice across email, SMS, and a live AI phone call as it moves from one bucket to the next. It also applies incoming payments and reconciles, so the report stays accurate without anyone touching a spreadsheet. For the mechanics of the follow-up itself, see our guide on how to get customers to pay invoices faster, and for keeping the ledger clean as payments land, our cash application software.

The bottom line

An accounts receivable aging report turns a vague sense that "some invoices are late" into a precise, prioritized worklist. Read it right to left, keep the balance weighted toward the current and 1-to-30 buckets, and act on the oldest debt first. Do that consistently, or let an agent do it for you, and the report becomes less a rear-view mirror and more a steering wheel for your cash flow.