The A/R Aging Detail in QuickBooks Online

The Accounts Receivable Aging Detail is the invoice-by-invoice version of the aging report. Where the A/R Aging Summary gives you one line per customer with their balance spread across age buckets, the detail lists each individual open invoice, grouped by how overdue it is, so you can see exactly which invoices make up each customer's outstanding balance. It is the report you run when a total is not enough and you need to know precisely what is unpaid.

What the A/R Aging Detail shows

The report is organized into aging periods, the same buckets used by the summary: Current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and 91 days and over. Under each period it lists the open transactions that fall there, showing the date, the transaction type, the number, the customer, the due date, the original amount, and the open balance still owed. Most of these are unpaid or partially paid invoices, and the report can also show other open receivable items such as credit memos or unapplied payments. Each open item lands in one bucket based on the report date and the aging method, and the periods subtotal up to the same grand total the summary reports. It turns the single number on your books into a specific list of invoices you can act on or explain.

A snapshot as of one date

Like the summary, this is an as-of report and does not vary with the cash or accrual accounting method. It shows the invoices that were open as of the single date you run it for, so the same report on a later date drops the invoices that have since been paid and adds any new ones that have gone overdue. The report date is part of what the record means, which is why an aging detail as of a year-end is worth keeping in its own right.

Why a CPA or auditor asks for it

When an accountant or auditor questions the accounts receivable figure on your Balance Sheet, the aging detail is the supporting schedule that shows what the number is made of. It lets them test specific invoices, confirm that old balances are real rather than stuck from a data error, and judge how much of the total is genuinely collectible. In due diligence before a sale, a buyer uses it to see whether receivables are concentrated in a few slow-paying customers. It is the bridge from the one-line balance to the actual transactions, and its subtotals reconcile back to the A/R Aging Summary.

How to run and export the A/R Aging Detail in QuickBooks Online

1. Go to the Reports menu and type "A/R Aging Detail" into the report search box, then open it.
2. Set the report date to the as-of date you want the invoices measured against. For an archive, run it as of each fiscal year-end so you keep the detail behind each year's receivable balance.
3. If you need to match a specific setup, adjust the aging method and the days per aging period near the top, then run the report.
4. Use the export control at the top of the report to export it to Excel or PDF. The file downloads to your computer.
5. For a plain list of every unpaid invoice without the aging buckets, run Open Invoices instead.

Because the detail is a point-in-time snapshot, an All Dates run does not preserve where things stood at each year-end, so a run as of each year-end is what keeps the history intact. The Excel export is usually easier to work with than a PDF when the list is long, because you can sort and filter it.

Keeping the A/R Aging Detail after you cancel

The A/R Aging Detail is part of your Books Backup archive. A cancelled paid QuickBooks Online company stays read-only for 12 months and is then permanently deleted, a trial only 90 days, and the IRS generally expects business records to be kept for at least three years, and longer in some situations. Once the company is gone, you cannot pull that exact aging detail from QuickBooks Online again, and rebuilding it later is difficult unless you exported enough history first, which is why the detail belongs in a copy you keep.

Frequently asked questions

When should I use the Detail instead of the Summary?

Use the summary when you want the shape of your receivables at a glance, and the detail when you need to see the specific invoices behind a customer's balance. The A/R Aging Summary is the overview; the detail is the itemized schedule that supports it.

Does the A/R Aging Detail include partially paid invoices?

Yes. Each open invoice shows both its original amount and the balance still owed, so an invoice that has been partly paid appears with the remaining balance, placed in the bucket that matches its age as of the report date.

Why keep the detail if I still have the invoices in another system?

The aging detail records how those invoices stood as of a specific date, including which were overdue and by how much, which the invoices on their own do not preserve once balances are settled. For an audit of a past year or a question about collections at a year-end, the saved detail answers what the raw invoices cannot.