Back to Reports
Aged Payables by Contact Report
Outstanding bills for a single supplier with overdue status. See what you owe one supplier and how overdue each bill is. For every supplier at once, use the Aged Payables report.
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")
Currency: The bill's own currency code. Home-currency bills and the Opening Balance row show your organization's home currency
Total: Bill total, in the bill's currency
Paid: Amount paid, in the bill's currency
Credited: Amount credited, in the bill's currency
Due: Amount still due, in the bill's currency
Due (Base Currency): Amount still due in your organization's home currency, at Xero's exchange rate for the report date. Same as Due for home-currency bills
Suppliers with bills in several currencies
If a supplier has bills in more than one currency, the table shows a mix of currencies, and the Currency column tells you which one each row is in. Total, Paid, Credited and Due are in each bill's own currency, so don't add them up across rows. To get what you owe the supplier in total, add up the Due (Base Currency) column only.
Tables inserted before 25 September 2026
- Older tables keep their original 10 columns, without Currency or Due (Base Currency). Insert the report again to get the new columns.
- Figures for home-currency suppliers, and for suppliers billing in a single foreign currency, were already correct.
- For suppliers with bills in several currencies, and for a foreign-currency supplier's Opening Balance row, Paid, Credited and Due could show wrong amounts (often 0). They are correct after your next refresh.
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
- If Xero sends the report in a layout XO Report does not recognise, you see an error instead of figures that might be wrong