An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?
Before you start
- Administrator, Standard + reports, Sales and purchases, Purchases or Viewer user role
The Xero way
Where to find it: Reporting > All reports > Aged Payables Summary or Aged Payables Detail
- In the Reporting menu, select All reports. Open Aged Payables Summary for totals by supplier or Aged Payables Detail for each bill.
- Choose the Date or a set period such as End of last month.
- Set Ageing Periods and Ageing By (Due Date or Invoice Date). Add filters or grouping if needed.
- Click Update. Click an amount to drill into the detail report.
- Save the layout as a custom report to reuse it.
Limits in Xero
- The report includes bills, credit notes, expense claims and overpayments, not only bills.
- Bills awaiting payment on the report date are included even if paid since.
Example in Xero
Example Pty Ltd runs Aged Payables Summary at 31 October with Ageing By set to Due Date.
| Line | Amount | Tagged to |
|---|---|---|
| Current | $22,300.00 | Not yet due |
| 1 to 30 days overdue | $5,800.00 | Review |
| 31 to 60 days overdue | $900.00 | Open the detail report |
| Older | $640.00 | Check for an unallocated credit |
Total $29,640.00. Click the $640.00 older amount to open Aged Payables Detail and see which bills sit behind it.
Common mistakes
- Reading the report as bills only. It also includes credit notes, expense claims and overpayments.
- Forgetting to set the date. Bills awaiting payment on the date show even if paid since.
More help
- How to run the Aged Payables report in AccountRight
- How to run the Unpaid bills report in MYOB Business
- How to run the Aged Creditors in Sage 50
- How to apply a credit note to a bill in Xero
- How to close the month in accounts payable in Xero
- All Xero how-to guides
- Pulsify setup guides
Sources
Last checked 2026-10-19. Confidence: confirmed.
Common questions
What is the difference between the summary and detail report?
Aged Payables Summary gives totals by supplier. Aged Payables Detail lists each bill. Click an amount in the summary to drill into the detail.
Can I age by invoice date instead of due date?
Yes. Set Ageing By to Due Date or Invoice Date and set the Ageing Periods. Then click Update.
What does the report include besides bills?
Credit notes, expense claims and overpayments. Bills awaiting payment on the report date are included even if paid since.
Does Pulsify run this report?
No. Run it in your accounting system.
Want this done for you?
Book a call to see how Pulsify handles supplier bills in Xero.