Back to Tables
Payments Table
Payment records from Xero with date filtering. View payment dates, amounts, bank accounts, and related invoices.
Parameters
Date Range (Required)
Filter payments by date. Use Smart presets, Cell references, or Fixed dates.
Output Columns
| Column | Description |
|---|---|
| Date | Payment date |
| Amount | Payment amount |
| CurrencyRate | Exchange rate |
| Reference | Payment reference |
| Status | Payment status |
| PaymentType | Type of payment — e.g., ACCRECPAYMENT (accounts receivable), ACCPAYPAYMENT (accounts payable), AROVERPAYMENT, ARPREPAYMENT, APOVERPAYMENT, APPREPAYMENT |
| IsReconciled | Whether reconciled |
| Invoice | Related invoice number |
| Account | Bank account used |
| BankAmount | Amount in bank currency |
| PaymentID | Xero unique identifier |
| XeroLink | Click-through link that opens the payment in Xero (where available) |
Plus OrgID, OrgName, and Timestamp columns.
The XeroLink column is ticked on by default — see Open in Xero for how the links work.
Deleted payments excluded
Deleted (cancelled/reversed) payments are excluded — the Status column never shows DELETED.
Tips
- Use IsReconciled to find unreconciled payments
- Link to Invoices table using the Invoice column
- Check BankAmount for multi-currency reconciliation
- The XeroLink column opens a payment in Xero where a link is available; payment types that aren't linked yet show a blank cell