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 |
| IsReconciled | Whether reconciled |
| Invoice | Related invoice number |
| Account | Bank account used |
| BankAmount | Amount in bank currency |
| PaymentID | Xero unique identifier |
Tips
- Use IsReconciled to find unreconciled payments
- Link to Invoices table using the Invoice column
- Check BankAmount for multi-currency reconciliation