QuickBooks Online · AP aging report

The accounts payable aging report in QuickBooks Online

The accounts payable aging report groups open vendor bills by due date so AP can see what is current, what is past due and where credits or overpayments may be sitting.

What QuickBooks Online's documentation says

  1. QuickBooks Online has two payables aging reports, Accounts payable aging summary and Accounts payable aging detail, available in Essentials, Plus and Advanced. Source 1 (opens in a new tab)
  2. In QuickBooks Online aging reports the Current column holds anything not yet due and the 1-30 and later columns count days past the due date; a transaction with no due date is treated as due on receipt and aged from its transaction date. 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

In QuickBooks Online, the payables aging reports are Accounts payable aging summary and Accounts payable aging detail, available in Essentials, Plus and Advanced. They organize open vendor bills by due date. The Current column holds anything not yet due. The 1-30 and later columns count days past the due date. A transaction with no due date is treated as due on receipt and aged from its transaction date, so a missing due date can put a bill into an overdue column immediately.

Read the report from the Current column outward. Current is not a promise that every bill is valid; it only means the due date has not passed. A bill in 1-30 or later needs a reason for nonpayment: missing approval, a dispute, a missing credit or a payment that was not applied. If the aging report and the vendor statement disagree, do not assume the report is right. Look for a bill entered twice, a credit never applied or a payment posted to the wrong vendor record.

The report is a control list, not an approval-to-pay list. Before releasing a payment, match the bill to the vendor record, the invoice, receiving and the approval. AP teams get into trouble when they work only from the aging total and pay every open line without checking the underlying bill.

Reading credits and debit balances

A credit balance on a vendor line needs a clear owner. It can come from a credit memo, an overpayment, a duplicate payment or a vendor credit that was never applied. A debit balance often points the other way: you paid more than the open bills support, or you paid a statement as well as the invoices behind it. In either case, do not clear the balance by intuition. Find the transaction that created it.

Start with the vendor record in QuickBooks Online or your ERP. Check whether the same supplier exists twice, once with the bill and once with the credit. That is common when a supplier is set up under a different name, spelling or remit-to address. If the credit sits on one record and the bill on another, the aging report can show both as open even though the net position is a credit. Consolidate or offset only after you have documented which record is correct.

When the credit belongs to an open bill from the same vendor, apply it. When there is no open bill, or the credit came from an overpayment, ask the supplier for a refund or a written credit confirmation. Keep the request and the response with the vendor record. If a credit or void does not appear as expected, check QuickBooks Online's own help rather than guessing about the report.

Using aging to spot overpayments

Overpayments usually enter through ordinary AP work. The same invoice is re-keyed with a slightly different number, such as INV-1043 and 1043. The same supplier is set up twice. A statement is paid as well as the invoices. A payment run is sent twice. A credit is received but never applied. The aging report can surface these because it shows open items and balances by vendor, but only if someone reads it against source documents.

Use the Accounts payable aging detail in QuickBooks Online when you need to check individual bills. In the export, the Num column carries the supplier invoice number. Sort by vendor and Num, then compare amount and date windows. Treat INV-1043 and 1043 as a possible duplicate until the supplier confirms they are separate invoices. Also check for a bill and a credit on the same vendor that never offset, and for a debit balance that no open bill explains.

Worked situation: a supplier statement lists INV-1043. A clerk re-keys the same invoice later as 1043. The aging detail shows two open items for the vendor, with the same amount and close dates, and the Num values differ only by the prefix. Hold both, check receiving and approval, and ask the supplier to confirm which invoice number is correct. If both were already paid, ask for a refund or a credit. Another situation: a payment run is sent twice, leaving a debit balance or an unapplied credit on the vendor. Reconcile the statement, then ask the supplier for a refund or credit.

A monthly routine

Make the aging report part of a monthly routine, not a once-a-year cleanup. Run Accounts payable aging summary in QuickBooks Online for a vendor-level scan. Run Accounts payable aging detail for vendors with credit balances, debit balances, old items or repeated invoice numbers. Both reports are available in Essentials, Plus and Advanced. Check the Current column first, then the 1-30 and later columns. Flag every bill with no due date; it is treated as due on receipt and aged from its transaction date.

Reconcile vendor statements for the vendors that carry the largest balances and for any vendor with a credit or debit balance. Match on vendor, amount and date windows. Use the Num column in the export to compare supplier invoice numbers, and watch for INV-1043 against 1043. Check whether the same supplier has two records. Check whether a credit was received but never applied. Check whether a payment run was sent twice.

Resolve what you find. Apply valid credits to open bills. Ask suppliers for refunds or written credit confirmations when the balance is an overpayment. Correct duplicate vendor records. Record the reason for every adjustment so the next person does not reopen the same item. Follow up on old items until they are cleared or documented as disputed.

If the report does not match the vendor statement after these checks, check QuickBooks Online's own help for report behavior and for what happens after a void. Do not force a balance to zero just to close the month.

To review paid bills outside QuickBooks Online, export them: Export paid bills from QuickBooks Online. The supplier's invoice number is in the Num column.

Questions

What are the payables aging reports in QuickBooks Online?

QuickBooks Online has Accounts payable aging summary and Accounts payable aging detail, available in Essentials, Plus and Advanced. They organize open vendor bills by due date. Check QuickBooks Online's own help for report-specific details not covered here.

Why is a bill with no due date already in the 1-30 column?

In QuickBooks Online aging reports, the Current column holds anything not yet due. A transaction with no due date is treated as due on receipt and aged from its transaction date, so it can land in 1-30 or later immediately.

How do I find duplicate invoice numbers such as INV-1043 and 1043?

Export the Accounts payable aging detail and use the Num column, which carries the supplier invoice number. Sort by vendor and Num, then compare amount and date windows. Treat INV-1043 and 1043 as a possible duplicate and confirm with the supplier before paying or requesting a refund.

What should I do with an unapplied vendor credit on the aging report?

Check whether the credit belongs to an open bill from the same vendor. If it does, apply it. If there is no open bill or the credit came from an overpayment, ask the supplier for a refund or written confirmation. If the credit does not behave as expected after a void, check QuickBooks Online's own help.

Updated Nov 8, 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.