What QuickBooks Desktop's documentation says
- The aged payables reports are A/P Aging Summary and A/P Aging Detail. The aging basis is set in Edit > Preferences > Reports & Graphs > Company Preferences: Age from due date or Age from transaction date, changed only by the administrator. Source 1 (opens in a new tab)
- A bill credit or bill payment not applied to a bill shows as a negative amount on Unpaid Bills and can leave paid bills showing as open on aging reports until it is applied in Pay Bills. Source 2 (opens in a new tab)
Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.
What the aging report shows
The A/P Aging Summary and A/P Aging Detail are the two aged payables reports in QuickBooks Desktop. The Summary gives you one line per vendor with the balance split across aging periods. The Detail gives you the individual bills behind each vendor total, including the supplier invoice number, so you can work item by item.
Both are built from bills that still carry a balance. A bill you paid and applied drops off. That is exactly why these reports earn their place on a Monday morning: anything sitting there is either genuinely unpaid or unpaid in the system's eyes because a credit or a payment never got matched to it.
The aging basis is set in Edit > Preferences > Reports & Graphs > Company Preferences. You choose Age from due date or Age from transaction date, and only the administrator can change it. The choice matters more than people expect. Under one basis the clock starts on the bill date. Under the other it waits for the due date. So the same open bill can look a month older or a month younger because of a setting nobody in AP remembers touching.
When you export the A/P Aging Detail, the supplier invoice number comes out in the Num column. That column turns the report into a working file. Sort by vendor, then by Num, and repeats become easy to see.
Reading credits and debit balances
Negative amounts on the aging are normal up to a point, and plenty of teams scroll straight past them. A bill credit or bill payment that has not been applied to a bill shows as a negative amount on Unpaid Bills, and it can leave paid bills showing as open on aging reports until it is applied in Pay Bills. So one vendor line can carry an open bill you already paid and a credit you never used, with the two quietly cancelling each other out.
The usual cause is a credit that arrived and got entered but never matched. A supplier short ships, you receive a credit memo, someone keys it in as a bill credit, and it sits there. Two months later the supplier statement treats that credit as used, your ledger treats it as loose, and the balances no longer agree.
Refunds leave the same shape. If a supplier sends money back and the clerk records it as a bill payment with no bill to point at, you get a negative line instead of a clean zero. Prepayments and deposits sometimes land the same way.
Treat every negative line as a job. Open Unpaid Bills, work out which bill the credit belongs to, and apply it in Pay Bills. If there is no bill for it, decide whether it goes against the next invoice or back to the supplier as a refund, and write that decision down. Where you are unsure what happens to a credit after a void or a deletion, check QuickBooks Desktop's own help rather than guessing.
Using aging to spot overpayments
Duplicates are the most common overpayment, and formatting is usually the reason. One clerk keys INV-1043. Another keys 1043 for the same shipment because the prefix looked like a system code. Same vendor, same amount, days apart. Neither entry looks wrong on its own, and the aging detail lists them as two separate open bills.
Export the A/P Aging Detail and sort by vendor, then by the Num column. Read down each vendor's block looking for the same amount with invoice numbers that differ only by punctuation or a prefix. Set an amount tolerance and a date window, say anything within a few dollars and within a few weeks, and work the pairs by hand. The report will not tell you which entry is the duplicate. It just puts them next to each other.
A supplier set up twice causes a quieter version of the same problem. Bills land under one vendor record, the credit lands under the other, and neither record tells the full story. The aging looks reasonable on both lines. Reconcile against the supplier statement and the gap appears. Merging vendor records is a vendor-record task in QuickBooks Desktop, so confirm the steps in its help before you touch anything.
Two more sources are worth checking. A statement paid in full as well as the individual invoices, and a payment run sent twice after a bank detail change or a failed transmission. A second payment with nothing to apply to shows up as a negative line, while the bill it was meant to clear can still look open. When you find a real overpayment, ask the supplier in writing for a credit or a refund, and quote their invoice number and your payment reference.
A monthly routine
Run the A/P Aging Detail on the same day each month, ideally right after the payment run and before you close the period. Same report, same aging basis, so month to month comparisons mean something. If the aging basis changes, note it, because every open bill will jump.
Export the detail and tie your largest vendors to their statements. The statement is the outside check on your own data, and it catches the credits and duplicate records your ledger hides. Work the negative lines first, then the oldest open items, then anything that moved oddly since last month.
Next, scan for duplicates on vendor, amount and Num. Keep a short log of what you checked and what you found, with dates. It takes ten minutes and it stops the same bill being investigated three times by three people.
Close the loop with suppliers. Ask for credits, refunds and written confirmation, and file the replies with the vendor record. If a credit is going to be applied to a future invoice, note that on the log so the next person does not chase it again.
To review paid bills outside QuickBooks Desktop, export them: Export paid bills from QuickBooks Desktop. The supplier's invoice number is in the Num column.
Questions
How do I change the aging basis on the A/P Aging report in QuickBooks Desktop?
Go to Edit > Preferences > Reports & Graphs > Company Preferences and choose Age from due date or Age from transaction date. Only the administrator can change it. For anything about column intervals or other report settings, check QuickBooks Desktop's own help.
Why is a bill I already paid still on my A/P Aging Detail?
A bill credit or bill payment that was not applied to a bill shows as a negative amount on Unpaid Bills and can leave paid bills showing as open on aging reports until it is applied in Pay Bills. Apply the credit to the bill, then run the report again.
What is the Num column in an exported A/P Aging Detail?
It carries the supplier invoice number. Sorting by vendor and then by Num is the quickest way to spot one invoice keyed twice, for example INV-1043 and 1043.
Does a negative balance on AP aging mean I overpaid a vendor?
Not always. It often means a credit or a payment is sitting unapplied. Check Unpaid Bills, match the credit to its bill, and if the balance is still negative after that, get a statement from the supplier before you request a refund.
Updated Nov 15, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.