AR Aging Report: How to Read an Accounts Receivable Aging Report and Aging Schedule

An AR aging report lists every unpaid customer invoice sorted by how long it has been outstanding, grouped into buckets: current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. The total of the report equals the accounts receivable balance on your balance sheet as of the same date. It is the schedule that shows which customers owe you money, how late each one is, and how much of the receivable balance is probably never going to arrive.

Most people run it for collections, which is fair, but that is the smaller half of its value. The aging report is also the supporting schedule behind one of the largest numbers on your balance sheet, and it is the evidence a lender, a buyer or your CPA uses to decide whether that number is honest. Below: how to read the buckets, how the report ties to your financial statements, how the allowance for doubtful accounts is calculated from it under current US GAAP, how to run it in QuickBooks, and the accounts payable mirror image.

What is an accounts receivable aging report?

It is a listing of open receivables organized by age. Every invoice that has been issued and not fully paid appears on it, positioned in a column according to how many days have passed since it became due. Add up all the columns and you have total accounts receivable. Add up one column and you have how much money is stuck at that level of lateness.

The standard US bucketing is 30-day intervals: current (not yet due), 1 to 30 days past due, 31 to 60, 61 to 90, and 90 plus. Some companies use 60-day buckets, and businesses with very short terms sometimes use weekly ones, but 30-day intervals are what a bank or a buyer expects to see and there is little reason to depart from them.

One detail causes more confusion than anything else on this report: aging by due date versus aging by invoice date. If you sell on net 30 terms and you age by invoice date, an invoice issued 25 days ago shows up in the 1 to 30 bucket even though it is not late at all. Age by due date instead and the same invoice sits in current, where it belongs. Aging by due date is the more useful setting for collections and the one most systems default to, but you should confirm which one your report is using before you conclude anything from it, because the two produce completely different-looking reports from identical data.

The report is sometimes called an aging schedule, an aged receivables report, or simply the AR aging. A summary version shows one row per customer with a total per bucket. A detail version shows every individual invoice. Use the summary to see who to call, and the detail to see which specific invoice is the problem.

How to read an AR aging report

Read it in three passes, and resist the urge to start with the biggest number.

Pass one: the shape of the whole thing. What percentage of the total sits in current? In a healthy business selling on net 30, roughly 75 to 85 percent of the receivable balance should be current or in the 1 to 30 bucket. If more than 20 percent has aged past 60 days, you have either a collections problem or a customer quality problem, and the difference matters because the fixes are opposite.

Pass two: concentration. A $340,000 receivable balance made of 200 invoices is a completely different risk from the same $340,000 where one customer owes $180,000. Lenders test this specifically, and a single customer representing more than about 20 percent of receivables usually triggers a question in underwriting. Concentration in the over-90 column is worse still, because it means your largest exposure is also your slowest payer.

Pass three: the over-90 column, invoice by invoice. This is where you find out what is actually going on. Genuinely uncollectible debt and a disputed invoice look identical on the report, and neither one looks different from an invoice that was paid three months ago but never applied against the original receivable. That last case is common and it inflates both receivables and, if the payment landed somewhere odd, revenue. Anything sitting past 90 days needs a reason attached to it before you rely on the total.

A summary AR aging report, and what each row is telling you

Customer	Current	1 to 30	31 to 60	61 to 90	90+	Total	Read
Northwind Construction	$62,000	$18,000	$0	$0	$0	$80,000	Healthy, but 23% of total AR: a concentration a lender will ask about
Halbrook Dental Group	$14,500	$9,200	$7,400	$0	$0	$31,100	Slipping steadily. Terms are being treated as a suggestion
Verity Logistics	$0	$0	$0	$0	$41,800	$41,800	Nothing current. Either a dispute or a customer that has stopped paying
Cedar Ridge Partners	$0	$0	$0	$2,300	$1,100	$3,400	Small and old. Likely a misapplied payment, not a collections issue
All other customers	$121,000	$47,000	$12,300	$3,400	$0	$183,700	Normal distribution
Total	$197,500	$74,200	$19,700	$5,700	$42,900	$340,000	Must equal AR on the balance sheet at the same date

In this example 80 percent of the balance is current or under 30 days, which is fine, but $42,900 sits past 90 days and almost all of it is one customer. The headline number looks healthy and the tail does not. That is the pattern the report exists to expose.

How the aging report ties to your balance sheet

This is the part that gets skipped, and it is the reason the report matters beyond collections. The total of your AR aging report as of a given date must equal the accounts receivable balance in the current assets section of your balance sheet as of that same date. If the two disagree, one of them is wrong, and you cannot issue financial statements until you know which.

The disagreement usually has one of four causes. A journal entry was posted directly to the accounts receivable account rather than through an invoice, so it hits the balance sheet but never appears on the aging. A customer payment was recorded but not applied to a specific invoice, leaving an unapplied credit that the two reports treat differently. The two reports were run on different accounting bases, since an aging report is inherently accrual while your balance sheet may be set to cash. Or the reports were run as of different dates, which sounds too obvious to be a real cause and is nonetheless the most frequent one.

Run this tie-out every month as part of your close, alongside the bank reconciliations and the undeposited funds check. It takes two minutes and it catches errors that would otherwise reach a lender. The full sequence is in our month end close checklist, and the related account that inflates current assets the same way is covered in our guide to undeposited funds in QuickBooks.

Once the tie-out is clean, the aging feeds the statements in two places. Net accounts receivable on the balance sheet is gross receivables less the allowance for doubtful accounts, and the allowance is calculated from the aging. Bad debt expense on the income statement is the change in that allowance plus any direct write-offs. So an aging report nobody has scrubbed produces an overstated asset and an understated expense at the same time, which flatters both the balance sheet and the P&L.

Calculating the allowance for doubtful accounts from the aging

The traditional method assigns a loss rate to each bucket and sums the result: perhaps 1 percent of current, 3 percent of 1 to 30, 10 percent of 31 to 60, 25 percent of 61 to 90, and 50 percent of everything past 90. Apply those to the table above and you get an allowance of about $28,700, most of it driven by the over-90 column.

Under current US GAAP that calculation needs one adjustment. ASC 326, the current expected credit loss model, applies to trade receivables held by private companies for fiscal years beginning after December 15, 2022, so it is in force now rather than pending. The change is that your loss rates can no longer be based purely on historical write-off experience. CECL requires an expected loss over the life of the receivable, incorporating current conditions and reasonable and supportable forecasts. In practice, for a private company with short-dated trade receivables, this usually means starting from your own historical loss rate per bucket and then adjusting it for what you actually know: a customer entering bankruptcy, a construction client whose project has stalled, a sector under visible strain. You also need to document the reasoning, because an aging-schedule allowance with no forward-looking adjustment and no documentation is exactly what a reviewer will question.

Two further points that reviewers raise. Group receivables that share risk characteristics and apply loss rates by pool rather than treating a $400 invoice the same as a $180,000 one from a customer in distress. And where a specific receivable is known to be impaired, evaluate it individually rather than burying it in a pooled percentage. AIStatements carries the allowance through to net receivables and flags concentration in the aged buckets when it builds the statement pack; the presentation conventions are on our QuickBooks balance sheet page.

How to run the accounts receivable aging report in QuickBooks

In QuickBooks Online, go to Reports and search for "A/R Aging Summary" or "A/R Aging Detail." Open it, then use Customize to set the report date, and check the Aging Method setting, which is where you choose between aging by due date and aging by transaction date. You can also change the interval and the number of periods if you want something other than four 30-day buckets. Save it as a custom report so the settings survive.

In QuickBooks Desktop, the same reports are under Reports, then Customers and Receivables. The aging preference lives in Edit, Preferences, Reports and Graphs, Company Preferences, where you set aging from due date or from transaction date for the whole company.

Three settings quietly change the answer. The report date defaults to today, so running it on the 4th of the month gives you a report that is not comparable to the balance sheet you produced as of the 31st. The accounting basis should be accrual, since an aging report on a cash basis is close to meaningless. And unapplied customer payments show as negative amounts, often in the current column, which offsets the total and hides the real gross exposure until you go and apply them.

Exporting to Excel and reformatting by hand is where most of the time goes, particularly when you need the aging alongside a full statement pack for a lender. AIStatements builds the statements from the same export and ties net receivables through to the balance sheet automatically, which is the step people usually do manually at 11pm the night before a bank meeting. The broader workflow is on our QuickBooks financial statements page.

If the review turns up a systematic collections problem rather than a reporting one, the fix is upstream of accounting: consistent, automatic follow-up on every invoice the day it goes past due, which is a job worth handing to software that chases overdue invoices automatically by email and SMS rather than to whoever remembers. The aging report tells you what went wrong; it does not collect anything.

The accounts payable aging report

The AP aging is the same report pointed the other way: every unpaid vendor bill, bucketed by how overdue it is, totaling to the accounts payable balance on your balance sheet. Run it the same way, in QuickBooks under Reports as "A/P Aging Summary," and tie it out to the liability the same way. The payables side has its own failure modes, including negative balances from unapplied vendor credits and journal entries posted straight to the control account, which are covered in how to read an accounts payable aging report.

Read together, the two agings tell you something neither one says alone. If your receivables are aging faster than your payables, you are financing your customers out of your own working capital, and that gap is where a profitable business runs out of cash. Lenders read the pair specifically to see whether a business is stretching vendors to cover slow collections, since a payables balance that has quietly drifted into the 60-plus buckets is one of the earlier visible signs of a cash squeeze. The working capital picture that comes out of both is covered on our financial statements for a business loan page.

Turning the aging into metrics: DSO and CEI

Days sales outstanding is the standard summary measure: average accounts receivable divided by credit sales for the period, multiplied by the number of days in the period. A DSO of 47 on net 30 terms means you are collecting roughly 17 days late on average. Track it monthly, because the trend says far more than any single reading, and compare it to your own terms rather than to a generic benchmark.

DSO has a known weakness: it moves when sales move, so a sales spike makes collections look worse when nothing about collections changed. The collection effectiveness index corrects for that by comparing what you actually collected against what was available to collect, expressed as a percentage. Anything above 80 percent is generally considered solid. Where DSO tells you how long money is taking, CEI tells you how well the collections process itself is working, which is the number to watch if you are trying to decide whether a problem is your team or your customers.

One more from the aging directly: the percentage of receivables past 90 days, tracked month over month. It is the earliest reliable signal that write-offs are coming, and it moves before DSO does. The wider set of measures worth tracking is in our note on financial ratios small business owners should track, and the equity effect of eventual write-offs flows through to our statement of retained earnings page.

Frequently asked questions

What is an AR aging report used for?

Two things. Operationally, it shows which customers owe money and how late each one is, so collections can be prioritized. In accounting, it is the supporting schedule behind the accounts receivable balance on the balance sheet and the basis for calculating the allowance for doubtful accounts. Lenders, buyers and auditors request it to test whether the reported receivable is collectible.

What are the standard aging buckets for accounts receivable?

Current (not yet due), 1 to 30 days past due, 31 to 60 days, 61 to 90 days, and over 90 days. Thirty-day intervals are the US convention and what lenders expect. Some companies use 60-day intervals or add a 120-plus bucket. What matters more than the interval is whether the report ages by due date or by invoice date.

Does the AR aging report have to match the balance sheet?

Yes. The total of the aging report must equal the accounts receivable balance on the balance sheet as of the same date, run on the same accounting basis. A mismatch usually means a journal entry was posted directly to the AR account, a payment was received but never applied to an invoice, or the two reports were run as of different dates or different bases.

How often should you run an accounts receivable aging report?

Monthly at minimum, as part of the close, to tie receivables to the balance sheet. Businesses with meaningful credit exposure or tight cash usually run it weekly for collections purposes. Run it as of the same date as the statements you are producing, not as of today, or the two will not agree.

What is a good percentage of receivables past 90 days?

Under 5 percent of the total balance is generally healthy for a business selling on net 30 terms. Between 5 and 10 percent warrants attention. Above 10 percent usually signals either a collections process that is not being run or a customer quality problem, and it should be reflected in a larger allowance for doubtful accounts rather than left in the asset.