Xero · AP aging report

The accounts payable aging report in Xero

The accounts payable aging report in Xero groups what you still owe suppliers by due date or bill date. AP teams use it to catch duplicates and overpayments before paying again.

What Xero's documentation says

  1. Xero's aged payables reports are Accounts Payable Aging Summary and Accounts Payable Aging Detail in the US edition (Aged Payables Summary and Aged Payables Detail elsewhere), under Reporting > All reports. Source 1 (opens in a new tab)
  2. The reports have an Aging By setting: Due Date shows outstanding items in the period they fell due, and Bill Date (Invoice Date outside the US) in the period they were raised. Source 2 (opens in a new tab)
  3. The Accounts Payable Aging Summary total includes all outstanding bills, credit notes, expense claims and overpayments as at the report date. Source 3 (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 Xero, the report is Accounts Payable Aging Summary and Accounts Payable Aging Detail in the US edition. Outside the US it is Aged Payables Summary and Aged Payables Detail. You find them under Reporting > All reports.

The Aging By setting changes the columns. Due Date shows outstanding items in the period they fell due. Bill Date (Invoice Date outside the US) shows them in the period they were raised. Due Date answers what is overdue now. Bill Date answers what came in during a period and is still open.

The Accounts Payable Aging Summary total includes all outstanding bills, credit notes, expense claims and overpayments as at the report date. That mix matters. A total that includes credits and overpayments is not the same as the sum of unpaid bills. If you compare the report to a payment run, expect a difference from credits and overpayments sitting in the list.

Pull the Detail when the Summary is not enough. The Summary is the report with the total described above.

Reading credits and debit balances

Credits sit in the aging as items that reduce what you owe. A credit note that has not been applied to a bill is not a bill you should pay. It is a reduction waiting to be matched. Debit balances can also come from an overpayment. Do not net them silently against a supplier total without checking the items behind them.

Re-keyed invoice numbers are a common source of duplicates. One clerk enters INV-1043. Another enters 1043 for the same supplier invoice. The vendor record now holds two open items. If both go into a payment run, the supplier is paid twice. If only one is paid, the other sits in the aging and distorts the balance. Export the report and sort on the Reference column. The supplier invoice number in the export is Reference. Compare vendor, Reference and date window.

The same supplier set up twice causes the same problem. Two vendor records look alike, and each holds part of the activity. The bill sits in one record and the credit in the other. The aging looks clean in each record but the net position is wrong. Fix the vendor record, then apply the credit to the bill. A supplier statement is the outside check.

Paying a statement as well as the invoices on it is another repeat mistake. The statement total includes invoices you have already entered. If you pay the statement and later pay the invoices, the invoices stay open and the cash is gone. Re-sent payment runs do the same thing. The bill may show as paid, but an overpayment or unapplied cash item remains. Check credits and overpayments before you pay again.

Using aging to spot overpayments

Use the aging to find overpayments by looking for items that should have cleared. An invoice that is still open after you know it was paid is a signal. So is a supplier account with a credit or overpayment but no open bill. Before you pay anything, match the open item to the payment record. If the payment is there, the problem is allocation, not a missing payment.

Export the report and group it by vendor. Then look at amount and a date window. A duplicate usually shares the vendor, the amount and a narrow window. The invoice number may differ by a prefix or a space, as with INV-1043 and 1043. That is why the Reference field matters more than a visual scan. Sort by Reference and by vendor, then read the pairs.

Statement reconciliation catches what the aging cannot. Tick each open item on the supplier statement to the report. If the supplier shows a credit you do not have, ask for the credit note and enter it. If you show an item the supplier has already cleared, ask for the remittance that cleared it. Ask for a refund when a credit cannot be applied to a future bill. Put the Reference values in the request so the supplier can match it.

Missed discounts are a separate cost, but they belong in the same review. If you pay late and lose a discount, the loss is real. Compare the discount rate with your own cost of funds before you decide to stretch payment.

A monthly routine

Pick a fixed day each month and run Accounts Payable Aging Summary and Accounts Payable Aging Detail as at Thursday, Jan 15, 2026, or your own month end. Use Due Date for the payment conversation. Use Bill Date (Invoice Date outside the US) for the period review. Keep the same date across both reports so the numbers tie.

Reconcile the Summary total to the vendor record. Remember that the total includes outstanding bills, credit notes, expense claims and overpayments as at the report date. Break the total into those groups before you call it a payables balance. If the total moves without a matching bill, look for a credit, an overpayment or an expense claim.

Clear credits and overpayments first. Apply a credit to an open bill where the supplier allows it. If the credit is old or cannot be applied, ask for a refund or a clear statement. A credit that sits for months often points to a missing bill, a duplicate payment or cash posted to the wrong supplier. Fix the cause, not just the balance.

Before each payment run, run the aging again and scan for duplicates. Check vendor names that look alike, invoice numbers like INV-1043 and 1043, and bills that were already paid. Do not pay from a statement without ticking the invoices it covers. Keep the export with your payment run so the next clerk can see what was checked.

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

Questions

What is the difference between Accounts Payable Aging Summary and Accounts Payable Aging Detail in Xero?

Xero lists Accounts Payable Aging Summary and Accounts Payable Aging Detail in the US edition under Reporting > All reports. Outside the US the names are Aged Payables Summary and Aged Payables Detail. The Summary total includes all outstanding bills, credit notes, expense claims and overpayments as at the report date.

Why does my AP aging total not match my unpaid bills?

The Accounts Payable Aging Summary total includes all outstanding bills, credit notes, expense claims and overpayments as at the report date. Credits and overpayments change the total, so it will not equal the sum of open bills alone. Check those items before you treat the gap as an error.

How do I find duplicate invoices in the aging export?

Export the report and sort on the Reference column, which holds the supplier invoice number. Look for the same vendor with invoice numbers like INV-1043 and 1043 in a close date window. Check the bills before you reverse or pay anything.

What does Aging By Due Date mean in Xero?

Due Date shows outstanding items in the period they fell due. Bill Date (Invoice Date outside the US) shows them in the period they were raised. Use Due Date to see what is overdue and Bill Date for a period review.

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