Cash flow
Accounts receivable and the AR aging report
November 19, 2026 · 9 min read

Quick answer
Accounts receivable is money customers owe you for work or goods you've already delivered. An AR aging report lists every unpaid invoice by customer and sorts it into buckets by how late it is (current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due). Read it every month: the older an invoice gets, the less likely you'll collect it, and the buckets tell you where your cash is stuck and how much to reserve for bad debts.
Your profit and loss says November was a great month. Your bank account disagrees. You know some customers are behind, but you couldn't say how far behind, how much in total, or whether it's getting worse. That's the gap the AR aging report closes.
It's one of the most useful reports in your accounting software, and one of the least opened. This post explains how accounts receivable works, how to read the aging report, what days sales outstanding (DSO) tells you, and how to account for invoices that won't be paid. For the collection side (reminder emails, terms, when to stop work), see how to collect overdue invoices.
What is accounts receivable?
Accounts receivable (AR) is the total of unpaid customer invoices. When you send an invoice on accrual books, revenue goes up and AR goes up. When the customer pays, cash goes up and AR comes down. Revenue doesn't move again.
That's why a profitable month can leave you short of cash. Revenue is recorded when you earn it. Cash arrives when the customer decides to pay. AR is the difference, sitting on your balance sheet as a current asset.
If your books are on the cash basis, AR doesn't appear on the balance sheet at all, though most software still tracks open invoices and can still run an aging report. Run it anyway.
What does an AR aging report show?
An AR aging report has one row per customer (or per invoice in the detail version) and columns for how late the money is. The standard buckets are:
- Current: not yet due
- 1 to 30 days past due
- 31 to 60 days past due
- 61 to 90 days past due
- Over 90 days past due
Some reports age from the invoice date instead of the due date. Check which yours uses. On net 30 terms, "31 to 60 days" from the invoice date means 1 to 30 days late, which is a very different conversation from 31 to 60 days late. QuickBooks Online and Xero both let you choose.
A worked example: reading one company's aging
Say you run a commercial cleaning company that bills offices and clinics on net 30 terms. At November 30, your aging summary looks like this:
| Bucket | Amount | Share of AR | Illustrative loss rate | Allowance |
|---|---|---|---|---|
| Current (not yet due) | $102,000 | 54.8% | 1% | $1,020 |
| 1–30 days past due | $48,000 | 25.8% | 3% | $1,440 |
| 31–60 days past due | $18,000 | 9.7% | 10% | $1,800 |
| 61–90 days past due | $9,000 | 4.8% | 25% | $2,250 |
| Over 90 days past due | $9,000 | 4.8% | 50% | $4,500 |
| Total | $186,000 | 100% | $11,010 |
Where the $186,000 of receivables sits
A hypothetical cleaning company, aging at November 30
Hypothetical example. Buckets add up to $186,000.
Show the numbers
| Current (not yet due) | $102,000 |
| 1–30 days past due | $48,000 |
| 31–60 days past due | $18,000 |
| 61–90 days past due | $9,000 |
| Over 90 days past due | $9,000 |
Here's how an experienced accountant would read it.
More than half is current. $102,000 isn't due yet. That's healthy.
The 1 to 30 bucket is big. $48,000 a few weeks late is normal for many businesses. It's the bucket to work this week, because it's still easy to collect.
$36,000 is more than 30 days late. That's 19.4% of receivables. Look at which customers make it up. If it's one clinic group with a disputed invoice, that's a phone call. If it's spread across a dozen customers, your process has a gap.
$9,000 is over 90 days. Every one of those invoices needs a decision this month: a payment plan, a collection step, or a write-off.
The customer rows matter as much as the totals. One customer holding 30% of your receivables is a concentration risk even if they always pay.
How do you read an aging report each month?
Pull it at month end, after the close, so payments are applied and invoices are complete. Then work through it in this order.
Check the report is right
- Total AR on the aging equals AR on the balance sheet
- No unapplied payments or credits sitting on customer accounts
- No customer appears twice under slightly different names
Read the buckets
- Share of AR more than 30 days past due, compared with last month
- Any customer whose balance moved into an older bucket
- Your top five balances and what share of total AR they are
Decide
- A named next step and owner for every invoice over 60 days
- Write off anything you've truly given up on
- Update the allowance for doubtful accounts
The first group is the one people skip. An aging report full of unapplied payments shows customers as late when they've already paid, and nobody wants to chase a client who paid three weeks ago.
What is DSO, and what's a good number?
Days sales outstanding (DSO, or AR days) is the average number of days it takes to collect a sale. The usual formula:
DSO = accounts receivable ÷ credit sales for the period × days in the period
For the cleaning company, credit sales over the last 90 days were $450,000. So DSO is $186,000 ÷ $450,000 × 90 = about 37 days.
Compare it with your terms. On net 30, a DSO of 37 means customers pay a week late on average. On net 45, it would be good. There's no universal "good" DSO; what matters is the gap to your terms and the direction.
Days sales outstanding, June to November
The same cleaning company, on net 30 terms
Hypothetical example. November: $186,000 ÷ $450,000 × 90 days = 37 days.
Show the numbers
| DSO (days) | |
|---|---|
| Jun | 31 |
| Jul | 32 |
| Aug | 33 |
| Sep | 35 |
| Oct | 36 |
| Nov | 37 |
That slow climb is the real story. A day or two a month doesn't feel like anything. Over six months it means roughly $30,000 more cash tied up in receivables at this sales level (six extra days of $5,000 a day in sales). DSO is worth putting on your weekly KPI list and in your cash flow forecast.
How do you account for invoices that won't be paid?
There are two ways, and the books and the tax return usually use different ones.
On GAAP books: an allowance. You estimate how much of your receivables won't be collected and record an allowance for credit losses (often still called the allowance for doubtful accounts). It reduces AR on the balance sheet, and the change goes to bad debt expense. The aging buckets are the most common way to estimate it, which is exactly what the table above does: $11,010 of expected losses, so net receivables are $174,990.
Trade receivables fall under the current expected credit loss rules (ASC 326). For annual periods beginning after December 15, 2025, ASU 2025-05 lets companies assume current conditions continue instead of building economic forecasts, and lets private companies consider cash collected after the balance sheet date. Our posts on CECL for small businesses and the ASU 2025-05 shortcut go further.
Say the allowance was $7,500 last month. The month-end entry tops it up to $11,010:
| Account | Debit | Credit |
|---|---|---|
| Bad debt expense | $3,510 | |
| Allowance for credit losses | $3,510 |
Then a customer that owes $4,000 closes its doors, and you give up on the invoice. The write-off uses the allowance, not the P&L, because you already expensed the estimate:
| Account | Debit | Credit |
|---|---|---|
| Allowance for credit losses | $4,000 | |
| Accounts receivable | $4,000 |
On the tax return: the specific charge-off method. IRS Publication 334 says that generally you must use the specific charge-off method: you deduct specific debts when they become wholly or partly worthless, and a partial deduction is limited to what you charged off on your books that year. Growing your book allowance isn't, by itself, a deduction. And you can only deduct a bad debt if the amount was included in income first. On the cash basis, an unpaid invoice was never income, so there's nothing to deduct.
Common mistakes with receivables
Never looking at the aging. Revenue gets reviewed every month. AR gets reviewed when cash runs short. By then the old invoices are older.
Leaving dead invoices on the books. A $6,000 invoice from a customer who went out of business two years ago inflates your assets and your current ratio. Write it off.
Payments not applied to invoices. Deposits recorded straight to income leave the invoice open, so AR is overstated and the customer looks late. This is the most common reason an aging report is wrong.
Aging from the wrong date. Aging from invoice date on net 60 terms makes everyone look late. Know which setting you're using.
Treating AR as cash in your forecast. Collections lag. Forecast cash from your actual collection pattern, not from invoice due dates.
When should you get help?
Reading your own aging report is very doable. Twenty minutes a month with the checklist above covers most small businesses.
Get help when the aging doesn't tie to the balance sheet, when there are unapplied payments you can't match, when DSO keeps climbing, or when a lender wants GAAP statements with a proper allowance. At Fintrix Consulting, books are closed by the 10th and statements with a short note on what changed arrive by the 12th, so a slipping DSO gets noticed while it's still a few days, not a few months. Here's how our bookkeeping works.
Frequently asked questions
Is accounts receivable an asset or revenue?
An asset. The revenue was recorded when you sent the invoice. AR is the amount still owed, and it sits on the balance sheet as a current asset until the customer pays.
How often should I run an AR aging report?
At least monthly, after the close. If cash is tight or you bill a lot of customers, weekly is better for the collection side.
What's the difference between AR aging summary and detail?
The summary shows one line per customer with totals in each bucket. The detail lists every open invoice. Use the summary to spot problems and the detail to act on them.
When should I write off an unpaid invoice?
When you've reasonably given up on collecting it: the customer has closed, gone bankrupt or stopped responding after your full collection process. For tax, the deduction belongs in the year the debt becomes worthless, so don't sit on a dead invoice for years.
Does writing off an invoice mean I can't collect it later?
No. A write-off is an accounting entry. If the customer pays later, you reverse the write-off and record the payment, and for tax a recovered bad debt is generally income in the year you get it back.
The bottom line
Accounts receivable is revenue you've earned but can't spend yet, and the aging report shows exactly how stuck it is. Make sure it ties to the balance sheet, read the buckets every month, watch DSO against your terms, and decide on every invoice over 60 days. Keep an allowance if you need GAAP statements, write off what's truly gone, and remember the tax rules count bad debts one invoice at a time.
Sources
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Bookkeeping and cash planning for seasonal businesses
November 19, 2026
- Running a weekly cash meeting
November 19, 2026
- Can you afford your next hire? A cash-based way to decide
November 18, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.