Accounts Receivable Aging Report Explained
An accounts receivable (A/R) aging report lists every unpaid customer invoice and groups it by how long it has been outstanding. It answers two questions every owner should be able to answer at a glance: who owes us money, and how late are they? This guide explains how to read the report, which numbers to watch and how to keep it accurate.
How an A/R aging report is organized
Most accounting systems, including QuickBooks Online and Xero, group open invoices into buckets based on the due date (or invoice date, depending on settings):
| Customer | Current | 1–30 days | 31–60 days | 61–90 days | Over 90 | Total |
|---|---|---|---|---|---|---|
| Customer A | $4,000 | $1,500 | — | — | — | $5,500 |
| Customer B | $2,000 | — | $2,500 | — | — | $4,500 |
| Customer C | — | — | — | $1,200 | $3,800 | $5,000 |
| Total | $6,000 | $1,500 | $2,500 | $1,200 | $3,800 | $15,000 |
“Current” means not yet due. “1–30 days” means up to 30 days past the due date, and so on.
What to look for
- The share of receivables over 60 days. In the example, $5,000 of $15,000 — one third — is more than 60 days past due, and all of it belongs to Customer C. That concentration is a collection risk.
- Customers moving to older buckets. A customer who usually pays on time but now shows 31–60 days may be having cash trouble.
- Credits and negative balances. Unapplied payments or credit notes show as negative amounts. They usually mean a payment wasn’t matched to the right invoice.
- Very old items. Invoices older than a year are often already paid (and not applied) or uncollectible.
Useful A/R metrics
Days sales outstanding (DSO) estimates how long it takes, on average, to collect after a sale:
DSO = (Accounts receivable ÷ Credit sales for the period) × Days in the period
Example: $15,000 of receivables, $45,000 of credit sales in a 30-day month → (15,000 ÷ 45,000) × 30 = 10 days. Track the trend: rising DSO means cash is being tied up longer.
Percent past due = past-due receivables ÷ total receivables. In the example, $9,000 ÷ $15,000 = 60% is past due, which would warrant follow-up.
Why the aging report is often wrong
- Payments not applied to invoices. A deposit is recorded directly as income instead of as a payment against the invoice, so the invoice stays open forever — and income is counted twice.
- Duplicate invoices created by integrations or re-entered by hand.
- Discounts, fees and short payments that were never written off, leaving small balances open.
- Wrong customer — a payment applied to the wrong customer leaves one overstated and another with a credit.
If you see these patterns, a cleanup is the first step. Our QuickBooks Online cleanup guide covers how to fix them.
Turning the report into action
- Review weekly if you invoice frequently; monthly at minimum.
- Follow up by bucket: a friendly reminder at 1–30 days, a call at 31–60 days, and a firmer escalation beyond that.
- Feed collections into your cash forecast. Expected payments from the aging report are the most reliable input for weekly receipts in our free 13-week cash flow forecast.
- Agree on write-offs with your accountant. Bad-debt treatment has accounting and tax implications.
Accounts payable aging works the same way
The A/P aging report lists unpaid bills by age. Reviewing both together shows your working-capital position: money coming in versus money going out over the next few weeks.
Let AccoTiva keep receivables current
Our monthly bookkeeping includes matching customer payments to invoices, A/R and A/P aging reports and a clear list of overdue accounts, for businesses in the US and Canada. Book a free consultation.