An accounts receivable (AR) aging report lists every unpaid customer invoice and sorts each balance into time buckets — current, 1–30, 31–60, 61–90, and 91+ days past due — so you can see who owes what and how late it is. It matters to any US small or midsize business that invoices customers instead of collecting at the time of sale. Read it weekly, tie its total to the balance sheet, and work the largest and oldest balances first. Its biggest limitation: the report only summarizes the bookkeeping behind it, so miscoded invoices and unapplied payments produce a misleading picture.
Quick answer
An AR aging report answers three questions: how much customers owe in total, how much is past due, and how late each balance is. To use it:
- Run the aging summary (totals by customer) and the aging detail (every open invoice) in your accounting software.
- Tie the aging total to the accounts receivable balance on the balance sheet before trusting any bucket.
- Act by bucket: reminders in the 1–30 range, calls and credit review at 31–90 days, escalation or write-off evaluation past 90 days.
- Respect escalation limits: contract terms, state collection law, and the federal rules on third-party debt collectors all constrain what “acting on” an overdue invoice may look like.
The report is a management tool, not a cash-flow forecast: it shows what was still unpaid on one date, not when money will arrive.
What is an accounts receivable aging report?
An AR aging report is a standard accounting-software report that groups unpaid customer invoices by how long they have been outstanding or past due, typically in 30-day buckets, with a column total that should equal the accounts receivable account on the balance sheet. It serves three distinct uses that should not be confused: internal management reporting, book accounting under US generally accepted accounting principles (US GAAP) on the accrual basis, and tax treatment of unpaid invoices.
QuickBooks’ AR aging report documentation, accessed July 27, 2026, describes the report this way:
“Aging reports give you an overview of your customers’ outstanding balances … and how long they’re past due.” — QuickBooks (Intuit) help documentation
Late customer payment is not an edge case for US small businesses. The Federal Reserve Banks’ 2024 Report on Payments, based on the 2023 Small Business Credit Survey, found:
“Roughly four of every five small firms face challenges related to these payments.” — Federal Reserve Banks, 2024 Report on Payments
The same report notes that professional services, real estate, and manufacturing firms are more likely than other industries to report slow-paying customers as a challenge. More recently, the Federal Reserve’s 2026 Report on Employer Firms (published March 3, 2026, from a survey of 6,525 firms fielded September 3 to November 14, 2025) found that 56% of firms that sought financing did so to meet operating expenses — the kind of gap that overdue invoices create. Both surveys are nationwide convenience samples, so treat these percentages as directional rather than exact.
For the surrounding close-and-report workflow, see our accounting operations and reporting hub.
How do you run an AR aging report in QuickBooks Online?
These steps reflect US QuickBooks Online as of July 2026, per the official QuickBooks aging report steps (accessed July 27, 2026):
- Go to Reports, then Standard reports.
- In the Who owes you section, select Accounts receivable aging summary for totals by customer, or Accounts receivable aging detail to see each open transaction.
- Open the general options to set the number format, aging periods, and — critically — the aging method: aging by due date measures lateness against your invoice terms; aging by report date measures time since the invoice was issued.
- Save the customized report so the whole team reads the same version each week.
Worked example: reading the buckets
The following is a hypothetical illustration with made-up inputs; it is not data from an RFS client. Maple Ridge Fabrication LLC, a fictional US metal fabricator on the accrual basis with net-30 invoice terms, runs its aging summary on June 30, 2026.
Table 1: Hypothetical AR aging summary as of June 30, 2026 (made-up inputs, USD).
| Customer | Current | 1–30 days | 31–60 days | 61–90 days | 91+ days | Total |
|---|---|---|---|---|---|---|
| Alder Construction | $18,400 | $6,200 | $0 | $0 | $0 | $24,600 |
| Beacon Retail Group | $0 | $9,750 | $4,150 | $0 | $0 | $13,900 |
| Cedar Point Schools | $12,000 | $0 | $0 | $0 | $0 | $12,000 |
| Dune Hospitality | $0 | $0 | $7,300 | $2,800 | $0 | $10,100 |
| Elm Street Diner | $0 | $0 | $0 | $1,650 | $950 | $2,600 |
| Total | $30,400 | $15,950 | $11,450 | $4,450 | $950 | $63,200 |
Against the $63,200 grand total, current invoices are 48.1% of receivables, the 1–30 bucket is 25.2%, 31–60 is 18.1%, 61–90 is 7.0%, and 91+ is 1.5% (percentages rounded, so they sum to 99.9%). Just over half of receivables — $32,800, or 51.9% — is already past due, and $5,400 (8.5%) is more than 60 days past due. The collection priority is obvious: Dune Hospitality’s $10,100 is drifting toward the 90-day cliff, and Elm Street Diner’s $2,600 needs a decision, not another reminder.
The aging also feeds the book side of US GAAP accrual accounting. Suppose Maple Ridge’s policy reserves 1% of current balances, 3% of the 1–30 bucket, 10% of 31–60, 50% of 61–90, and 90% of 91+ as an allowance for doubtful accounts — again, hypothetical inputs. The estimated allowance would be $304.00 + $478.50 + $1,145.00 + $2,225.00 + $855.00 = $5,007.50, leaving an estimated net realizable value of $58,192.50. That allowance is a book estimate to review with an accountant — not the same thing as a tax deduction, as the bad-debt section below explains.
Structured receivables tracking supported one published RFS engagement: a Miami-based US manufacturer and exporter whose receivables aging was not structured enough to support cash-flow planning. After the aging reports were linked to export documentation, the published manufacturing case study reports an 18% reduction in days sales outstanding (DSO — the average time invoices take to get paid). That is one client’s reported result, not a typical or promised outcome.
How do you tie the aging report to the balance sheet?
Before acting on any bucket, confirm the aging total equals the AR control account: in Table 1, the $63,200 aging total must equal the accounts receivable balance on Maple Ridge’s June 30, 2026 balance sheet. QuickBooks’ aging report matching guidance, accessed July 27, 2026, gives the reconciliation logic:
- Run the balance sheet (or trial balance) as of the same date as the aging, using the accrual accounting method — a cash-basis balance sheet will not show the same AR figure.
- Set the aging method to report date in the report options; the default aging view can differ from the balance sheet figure.
- Check that both reports cover the same date range and that you are comparing the AR control total, not a subtotal.
- If they still differ, look for transactions that hit AR without appearing on the customer subledger — journal entries posted directly to the AR account, unapplied payments or credits, and timing differences from payments recorded near the report date.
- Investigate every unexplained difference before using the aging for collection or allowance decisions.
A tie-out that fails usually signals a bookkeeping problem — not a collections problem — which is why cleanup comes before escalation.
What collection actions fit each bucket?
The aging buckets double as an escalation ladder. The actions below are common practice for US business-to-business receivables; adjust them to your contracts, customer relationships, and state law.
Table 2: Suggested collection actions by aging bucket, using the Table 1 example.
| Bucket | Example balance | Typical action | Escalation limit |
|---|---|---|---|
| Current | $30,400 | None beyond normal statements; confirm invoices were received | None |
| 1–30 days | $15,950 | Automated reminder, resend invoice, confirm payment date | Keep tone routine; most invoices here still pay |
| 31–60 days | $11,450 | Direct call or email from the owner or AR lead; ask for a specific date; review credit terms for new work | Document disputes before assuming nonpayment |
| 61–90 days | $4,450 | Formal written demand, payment plan offer, hold on new orders | Late fees or interest only if the contract allows them and state law permits |
| 91+ days | $950 | Final demand; engage a collection agency or attorney; or evaluate write-off | Third-party collectors are federally regulated; statute-of-limitations windows vary by state |
The interpretation: the older the bucket, the more the action shifts from reminders to decisions. An invoice that reaches 91+ days needs a yes-or-no answer — escalate, settle, or write off — because indefinite reminding costs more than most balances are worth.
Two legal boundaries matter here, and this article is not legal advice on either. First, late fees and interest on overdue invoices are governed by the written contract and state law, not by a single federal rule for ordinary business-to-business invoices. Second, the federal Fair Debt Collection Practices Act (FDCPA), 15 U.S.C. §§ 1692–1692p, regulates third-party debt collectors working consumer debts; its definition of a “debt collector” excludes:
“Any officer or employee of a creditor while, in the name of the creditor, collecting debts for such creditor.” — Fair Debt Collection Practices Act § 803(6)(A), text published by the Federal Trade Commission
A business collecting its own commercial invoices in its own name is generally not the FDCPA’s target — but once a file goes to an agency or attorney, federal rules apply to them, and state collection statutes may reach your own conduct regardless. State statutes of limitations on unpaid-invoice lawsuits are another reason not to let 90+ balances age indefinitely.
When does an overdue invoice become a bad debt?
A write-off is the last stop on the escalation ladder, and it means different things in the three frames from earlier:
- Management reporting: remove the invoice from active collection work so the aging reflects collectible balances.
- Book accounting (accrual, US GAAP): record the write-off against bad debt expense or the allowance for doubtful accounts. In QuickBooks Online, the official bad-debt workflow (accessed July 27, 2026) creates a “Bad debts” expense account, creates a matching non-inventory item, issues a credit memo, and applies it to the open invoice.
- Tax treatment: a deduction is narrower than a book write-off. The Internal Revenue Service (IRS) states in Topic No. 453, Bad Debt Deduction (accessed July 27, 2026):
“Generally, to deduct a bad debt, you must have previously included the amount in your income or loaned out your cash.” — Internal Revenue Service, Topic No. 453
For an accrual-basis business, invoice income was already reported, so a genuinely worthless business debt can generally be deducted in the year it becomes worthless, after reasonable collection efforts. A cash-basis business never reported the unpaid invoice as income, so there is generally nothing to deduct. Worthlessness is a facts-and-circumstances judgment to make with your tax preparer, not a routine month-end entry. Clean, current books are what make these distinctions workable, which is the same foundation described in how clean bookkeeping feeds financial analysis and planning.
FAQs
How often should a small business run an AR aging report?
Weekly is common practice for businesses that live on invoiced revenue, with a monthly tie-out to the balance sheet at close. That is a recommendation, not a rule — the right cadence catches a 31-day bucket before it becomes a 91-day bucket.
Is there a benchmark for how much should be in the 90+ bucket?
No authoritative US benchmark sets a universal “acceptable” percentage, and this article deliberately cites none. Treat the 91+ share as a trend metric: if it rises month over month, tighten credit terms and earlier-bucket follow-up. Any percentage target is internal policy, not an industry standard.
Why does my aging report not match my balance sheet?
The usual causes are a cash-basis balance sheet, an aging method set to due date instead of report date, mismatched report dates, or entries that touched the AR account outside the customer subledger. QuickBooks documents these in its aging report matching steps.
Can a cash-basis business deduct an unpaid invoice?
Generally no. Because cash-basis income is not reported until received, an unpaid invoice was never in income, and the IRS bad-debt deduction generally requires the amount to have been previously included in income or to be cash actually loaned out.
When should an overdue invoice go to a collection agency or attorney?
When direct efforts have failed, the balance justifies the collection cost, and the claim is still within your state’s statute of limitations. Third-party collectors working consumer debts are federally regulated under the FDCPA, and state rules can apply more broadly — involve counsel before escalating large or disputed balances.
The bottom line
The working loop: run the aging weekly, tie it to the balance sheet, act on the largest and oldest balances, and escalate or write off deliberately rather than endlessly. If your aging total does not tie out, or overdue balances keep rolling forward without decisions, the fix is the receivables reporting workflow itself. RFS remote bookkeeping services keep invoicing, payment application, and aging tie-outs current so collection decisions run on reliable numbers.
This article provides general educational information, not tax, legal, or accounting advice. Bad-debt deductions, late-fee terms, and collection escalation depend on your facts, contracts, and state law; consult a qualified CPA or attorney before acting.