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