Back to Reports
Aged Payables Report
Outstanding bills for a single supplier with overdue status. See what you owe each supplier and how overdue each bill is.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Contact | Yes | Select a supplier from the searchable dropdown. This report shows bills for a single contact. |
| As of Date | Yes | Point-in-time date for aging calculation. Recalculates overdue status but shows all bills. |
| Invoice Date Filter | No | Restrict which bills appear by date range (From/To). When a From date is used, an Opening Balance row shows bills before the filter start date. |
| Organization | No | Xero organization to report on. |
Output
OrgID — Organization shortcode (auto-added)
OrgName — Organization name (auto-added)
Date — Bill date
Reference — Bill number
DueDate — Payment due date
Status — Overdue status text (e.g., "16 days overdue")
Total — Bill total
Paid — Amount paid
Credited — Amount credited
Due — Amount still due
Tips
- Focus on bills in the Due column for payment prioritization
- The Status field shows aging in human-readable form (e.g., "16 days overdue")
- Use the Invoice Date Filter to narrow results when a supplier has many bills
- Cash Basis is not applicable for aged reports