Fintrix Consulting LLC

Cash flow

Accounts receivable and the AR aging report

November 19, 2026 · 9 min read

← All articles
Envelope marked past due in red pen, surrounded by hundred-dollar bills and a yellow legal pad
Photo via Pexels

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:

BucketAmountShare of ARIllustrative loss rateAllowance
Current (not yet due)$102,00054.8%1%$1,020
1–30 days past due$48,00025.8%3%$1,440
31–60 days past due$18,0009.7%10%$1,800
61–90 days past due$9,0004.8%25%$2,250
Over 90 days past due$9,0004.8%50%$4,500
Total$186,000100%$11,010

Where the $186,000 of receivables sits

A hypothetical cleaning company, aging at November 30

Current (not yet due)Current (not yet due): $102,000$102k1–30 days past due1–30 days past due: $48,000$48k31–60 days past due31–60 days past due: $18,000$18k61–90 days past due61–90 days past due: $9,000$9kOver 90 days past dueOver 90 days past due: $9,000$9k

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.

Monthly AR aging review

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

010203040Terms: net 30Jun · DSO (days): 31Jul · DSO (days): 32Aug · DSO (days): 33Sep · DSO (days): 35Oct · DSO (days): 36Nov · DSO (days): 3737JunJulAugSepOctNov

Hypothetical example. November: $186,000 ÷ $450,000 × 90 days = 37 days.

Show the numbers
 DSO (days)
Jun31
Jul32
Aug33
Sep35
Oct36
Nov37

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:

AccountDebitCredit
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:

AccountDebitCredit
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.

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.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

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.