Back to Tables
Bills Table
Purchase bills from Xero with date and status filtering. View supplier details, amounts, and payment status.
Parameters
Date Range (Required)
Filter bills by date. Use Smart presets, Cell references, or Fixed dates.
Status Filter
AUTHORISEDApproved and awaiting payment
SUBMITTEDAwaiting approval
PAIDFully paid
DRAFTNot yet approved
VOIDEDCancelled
AUTHORISED and PAID are selected by default.
Contact Columns (Optional)
Select Contact.Name, Contact.Person (first and last name of the contact person), Contact.Email, Contact.Phone, and Contact.Address in the Columns step. They are unticked by default.
Output Columns
| Column | Description |
|---|---|
| InvoiceNumber | Bill number |
| Contact | Supplier name |
| Date | Bill date |
| DueDate | Payment due date |
| Status | DRAFT, SUBMITTED, AUTHORISED, PAID, VOIDED |
| Type | ACCPAY (payable) |
| LineAmountTypes | Exclusive, Inclusive, or NoTax |
| SubTotal | Subtotal before tax |
| TotalTax | Tax amount |
| Total | Total amount |
| AmountDue | Outstanding amount |
| AmountPaid | Amount paid |
| AmountCredited | Credits applied |
| Reference | Your reference |
| CurrencyCode | Currency |
| CurrencyRate | Exchange rate |
| ExpectedPaymentDate | Expected payment date |
| PlannedPaymentDate | Planned payment date |
| FullyPaidOnDate | Date fully paid |
| InvoiceID | Xero unique identifier |
| XeroLink | Click-through link that opens the bill directly in Xero |
Plus OrgID, OrgName, Timestamp, and optional Contact Details columns (Contact.Name, Contact.Person, Contact.Email, Contact.Phone, Contact.Address).
The XeroLink column is ticked on by default. See Open in Xero for how the links work.
Tips
- Filter by AUTHORISED to see unpaid bills for cash flow planning
- Use DueDate for aging analysis
- Check AmountDue for outstanding balances