Aged Payables Report
What you owe every supplier as of a chosen date, aged into Current, 1-30, 31-60, 61-90 and Over 90 day bands. Built from your Xero data the same way Xero's own Aged Payables report is, for all suppliers at once.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Organization | Yes | A single Xero organization. This report can't combine several organizations. |
| As of Date | Yes | The date balances are calculated at and aged from. |
| View | No | Summary (default) gives one row per supplier. Detail gives one row per outstanding bill or credit note. |
| Age by | No | Due date (default) or Bill date. |
| Include report date in current column | No | Checked by default, matching Xero's default. Saved with the report and reused on refresh. |
Output
Summary view (default)
Detail view
Detail view adds five columns before the bands: Document type (Bill or Credit note), Document number, Reference, Document date and Due date. Each item's amount sits in its band column and repeats in Total.
How amounts are valued
Foreign-currency items are converted to your organization's base currency at Xero's own exchange rate for the as-of date, the rate Xero prints under its own aged report. The rate on the original bill is never used. See the worked example on the Aged Receivables report page; the same rule applies here.
Expense claims aren't included
Xero's own Aged Payables report can include expense claims. XO Report can't read expense claims from Xero, so its total can be lower than Xero's for organizations that use them. The table's context row says "Excludes expense claims" as a reminder.
Tips
- Balances follow your Xero ledger as it is today, calculated back to the as-of date, like Xero's own aged reports. A bill paid or voided since then shows its current state.
- A negative row is a remaining credit note balance, or an early payment on a bill that isn't due yet.
- Unallocated prepayments don't get their own row (matching Xero). They only show through the bills they've been applied to.
- If nothing was outstanding, you'll see a message and no table is created.
- If XO Report can't confirm the figures against Xero, nothing is written and any existing table is left as it was.
- Refresh and Refresh All re-run the report with its saved settings.
- There's no contact filter. For one supplier's bills, use Aged Payables by Contact.
- Cash Basis is not applicable for aged reports.
- Excel add-in only. Not currently available in the Google Sheets add-on.