Pull sales invoices from Xero with date and status filtering. Includes all invoice details with optional expanded contact information.
This is the fastest way to export Xero invoices to Excel and keep them current: pick a date range and status once, and refresh the table from the task pane instead of re-exporting a CSV.
How to export Xero invoices to Excel
Open the XO Report task pane and click Tables and Reports.
Choose Invoices.
Pick the organisation (this step is skipped when only one is connected).
Set the date range and status (Authorised and Paid are pre-selected); tick Contact Details if you want email, phone and address columns.
Click Insert Table. The list lands on a new sheet named “Invoices”, with a link back to each invoice in Xero.
Parameters
Parameter
Required
Description
Date Range
Yes
Filter invoices by date
Status
No
DRAFT, SUBMITTED, AUTHORISED, PAID, VOIDED
Contact Details
No
Expand to include contact name, email, phone, address
Output Columns
Column
Description
InvoiceNumber
Invoice number
Contact
Contact/company name
Date
Invoice date
DueDate
Payment due date
Status
Invoice status
Type
ACCREC (receivable)
LineAmountTypes
Exclusive, Inclusive, or NoTax
SubTotal
Amount before tax
TotalTax
Tax amount
Total
Total including tax
AmountDue
Outstanding amount
AmountPaid
Amount paid
AmountCredited
Credits applied
Reference
Invoice reference
CurrencyCode
Currency code
CurrencyRate
Exchange rate
SentToContact
Whether sent to customer
ExpectedPaymentDate
Expected payment date
PlannedPaymentDate
Planned payment date
FullyPaidOnDate
Date fully paid
InvoiceID
Xero unique identifier
XeroLink
Click-through link that opens the invoice directly in Xero
Plus OrgID, OrgName, Timestamp, and optional Contact Details columns (Contact.Name, Contact.Email, Contact.Phone, Contact.Address).
The XeroLink column is ticked on by default. See Open in Xero for how the links work.
Status Filters
Status
Description
AUTHORISED
Approved and awaiting payment (default)
SUBMITTED
Awaiting approval
PAID
Fully paid (default)
DRAFT
Not yet approved
VOIDED
Cancelled
Tips
Use date presets like "Last Month" for reports that auto-update
Enable Contact Details to get email addresses for customer follow-up
Filter by status to focus on outstanding (AUTHORISED) invoices