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
PAIDFully applied
DRAFTNot yet approved
VOIDEDCancelled
Output Columns
| Column | Description |
|---|---|
| CreditNoteNumber | Credit note number |
| Contact | Contact name |
| Date | Credit note date |
| Status | DRAFT, 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 |
Tips
- Check RemainingCredit for unapplied amounts
- Use Type column to distinguish customer vs supplier credits
- ACCRECCREDIT = customer credit, ACCPAYCREDIT = supplier credit