Xero invoice export to Excel: what you can pull out and what you cannot
A Xero invoice export to Excel is a flat CSV of invoice and line-item transaction data from Xero's accounting system, used for financial reconciliation but not designed to show job costs, product margin, or operational reporting detail.
When you click Export on Xero's invoices screen, the file that downloads is a CSV document that opens directly in Excel. It contains one row per invoice line item: contact name, invoice number, dates, description, quantity, unit amount, account code, tax type, and tracking category values if configured. That is useful for reconciling outstanding balances or sharing transaction lists with an accountant. What it does not contain is anything about job costs, product revenue aggregated by item, or margin - the export is a financial record of what was invoiced, not a report on how the business performed.
What the export actually contains
The export is accessed from Business > Invoices in Xero by clicking the Export button on any status tab - Awaiting Approval, Awaiting Payment, Paid, or Drafts. The file downloads as CSV and opens in Excel without conversion.
Each invoice line item appears as its own row. A single invoice with four line items produces four rows. The columns in a standard export are:
- ContactName - the customer on the invoice
- InvoiceNumber and Reference - the document identifiers
- InvoiceDate and DueDate - the financial dates
- Description - free-text entered per line at the time of invoicing
- Quantity and UnitAmount - the per-line pricing
- AccountCode - the chart-of-accounts code assigned
- TaxType and TaxAmount - VAT or applicable tax treatment
- Tracking category columns - only present if tracking categories are configured in your Xero account
The export covers a maximum of 500 transactions per batch. Larger date ranges require multiple exports that must be combined manually.
Batch limit
Xero's invoice CSV export is capped at 500 transactions. Filter by a shorter date range or by invoice status to stay within the limit, then merge the resulting files in Excel.
What the export cannot tell you
The columns available are accounting data. They record what was invoiced: to whom, for how much, against which account code. They carry no information about what the work cost to deliver.
A business asking "which jobs were most profitable last quarter?" cannot answer that from this file. Job costs - labour, materials, subcontractors - are held in Xero's expense and bill records and are not linked to the invoice row in the export. Connecting revenue to cost requires either Xero Projects (which tracks time and expenses against individual projects) or an external job management system that holds both sides of the transaction.
A business asking "how much revenue came from product X?" faces a similar problem. The Description column contains free-text entered at invoicing time, not a consistent product code. Xero's Sales by Item report provides product-level revenue data for businesses using Xero's built-in product catalogue, but it covers only items registered there - not products managed in a separate quoting or order system.
Businesses that manage the full order cycle - from quote through delivery to invoice - typically find that Xero's invoice record answers the accounting question but not the operational one. Zigaflow's invoices feature pushes invoice data to Xero at the point of raising, while keeping job cost detail inside the job record so that reporting can show margin by order without a manual spreadsheet step.