Back to Tables
Credit Notes Table
Credit notes from Xero for customers and suppliers. View amounts, remaining credits, and application status.
Parameters
Date Range (Required)
Filter credit notes by date. Use Smart presets, Cell references, or Fixed dates.
Status Filter
AUTHORISEDApproved credit note
SUBMITTEDAwaiting approval
PAIDFully applied
DRAFTNot yet approved
VOIDEDCancelled
AUTHORISED and PAID are selected by default.
Contact Details (Optional)
Expand to include contact name, email, phone, and address columns.
Output Columns
| Column | Description |
|---|---|
| CreditNoteNumber | Credit note number |
| Contact | Contact name |
| Date | Credit note date |
| Status | DRAFT, SUBMITTED, AUTHORISED, PAID, VOIDED |
| Type | ACCRECCREDIT or ACCPAYCREDIT |
| LineAmountTypes | Exclusive, Inclusive, or NoTax |
| SubTotal | Subtotal before tax |
| TotalTax | Tax amount |
| Total | Total amount |
| RemainingCredit | Unapplied credit |
| CurrencyCode | Currency |
| CurrencyRate | Exchange rate |
| Reference | Your reference |
| SentToContact | Whether sent |
| FullyPaidOnDate | Date fully applied |
| CreditNoteID | Xero unique identifier |
Plus OrgID, OrgName, Timestamp, and optional Contact Details columns (Contact.Name, Contact.Email, Contact.Phone, Contact.Address).
Tips
- Check RemainingCredit for unapplied amounts
- Use Type column to distinguish customer vs supplier credits
- ACCRECCREDIT = customer credit, ACCPAYCREDIT = supplier credit