The A/P Aging Detail in QuickBooks Online

The Accounts Payable Aging Detail is the same overdue view as the A/P Aging Summary, opened up to show every unpaid bill on its own line instead of a single total per vendor. It groups your open bills into the same aging brackets, current, 1-30 days, 31-60 days, 61-90 days, and over 90 days, but inside each bracket it lists the individual bills that make up the amount. The report is stated as of a single date, so it shows which bills were outstanding, and how overdue, as of the report date you choose.

What the A/P Aging Detail shows

For each aging bracket, the report lists every open bill that falls in it: the bill date, the vendor, the reference or bill number, the due date, the number of days past due, the original amount, and the open balance still owed. Bills that are not yet due appear under current, and the rest are sorted by how far past their due date they are. Each bracket subtotals, and the report totals to your full accounts payable balance as of the report date, the same figure the A/P Aging Summary shows in one line per vendor. Because it names each bill, this is the report you use when a summary total needs to be traced to the specific invoices behind it.

The A/P Aging Detail is a date-based report. It does not toggle between cash and accrual basis the way the ledger and the statements do; what it reflects is the set of open bills and their due dates as of the date you choose.

Why a CPA or auditor asks for it

When an accountant is verifying the accounts payable balance on your Balance Sheet, the detail report is what lets them test it, because the total breaks down into named bills, each with a date and a due date. In due diligence before a sale, a buyer uses it to see the actual obligations they would be taking on rather than a lump sum. It also helps at year end to confirm that bills owed before the cutoff were recorded in the right period, which matters for an accrual-basis return. A summary tells you how much; the detail tells you which bills, which is what an examiner or a vendor dispute usually comes down to.

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

1. Go to the Reports menu and type "A/P Aging Detail" into the report search box, then open it.
2. Set the report date. The report is stated as of one date, so run it as of each fiscal year-end you want to keep, and as of your cancellation date for the final position.
3. If you want to change the aging brackets, set the days per aging period and the number of periods. When the report date is in the past, set the aging method to Report date so bills age as of that date, then run it.
4. Use the export control at the top of the report to export it to Excel or PDF. Excel is usually easier to work with because the detail can run long.
5. Repeat for any other as-of dates you need, such as each prior fiscal year-end.

The bill-level detail is heavier than the summary, so a business with many open bills will get a longer file. Our guide to exporting all your data from QuickBooks covers how the payables reports fit with the records you keep.

Keeping the A/P Aging Detail after you cancel

The A/P Aging Detail is part of your Books Backup archive. It matters because a cancelled paid QuickBooks Online company goes 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 cases. Once the company is gone, the bill-by-bill record of what you owed and when it came due goes with it, and that detail is hard to rebuild from a bank statement alone.

Frequently asked questions

How is this different from the A/P Aging Summary?

The A/P Aging Summary shows one line per vendor with the total owed spread across the aging columns. The A/P Aging Detail expands each of those totals into the individual bills behind it, with a due date and a past-due count for each. Auditors often want both: the summary for the picture and the detail for the proof.

Does the A/P Aging Detail vary by cash or accrual basis?

No. The aging reports are driven by dates rather than the accounting method, so switching between cash and accrual does not change the detail. It lists the bills that were open as of the report date and ages each one from its due date.

Can I keep every open bill from a specific date?

Yes. Set the report date to the date you care about, such as a fiscal year-end, and the report lists every bill that was still open then. Exporting it while the company is open preserves that snapshot, which you cannot re-create once the company has been deleted.