No API or App Required
Works with standard Etsy CSV exports. No OAuth, no Etsy API keys, no third-party apps.
Enter your email to receive a sign-in link
Convert Etsy CSV Order Items to Xero Sales Invoice format in seconds. No API, no subscription, no sync issues.
Free preview — then from $5. Save with bundles.Shop Manager → Settings → Options → Download Data → Order item → Download CSV
Upload CSV Order Items CSV and choose Sales Invoice format
Review converted data, download Xero-ready file
Business → Invoices → Import → Upload CSV
Output is in Xero Sales Invoice CSV format — ready to import directly, no manual reformatting needed.
Download 'CSV Order Items' from Shop Manager → Settings → Options → Download Data. This contains all sales with line-item detail.
Each item becomes one invoice line. Items with the same Order ID share the same InvoiceNumber, so Xero groups them into one invoice.
This tool focuses on recording sales revenue. For fee tracking and bank reconciliation, use our Etsy Payments → Xero Bank tool.
Works with standard Etsy CSV exports. No OAuth, no Etsy API keys, no third-party apps.
Upload → Preview → Download. No waiting for sync cycles or API rate limits.
Etsy exports one row per item. We create proper multi-line invoices that Xero groups automatically.
Converts Etsy dates to UK (DD/MM/YYYY) or US (MM/DD/YYYY) format based on your Xero settings.
Etsy collects and remits tax in many jurisdictions. Choose to exclude or record for 1099-K matching.
Small files process locally in your browser. Your data never leaves your computer.
How Etsy_Seller Order_Items fields map to Xero Invoice
| Etsy_Seller Order_Items | Source Value | Xero Invoice | Target Value | Note | |
|---|---|---|---|---|---|
Order ID |
3001234567 |
→ | InvoiceNumber |
3001234567
|
Order number with ETSY- prefix |
Sale Date |
Jan 15, 2026 |
→ | InvoiceDate |
Jan 15, 2026
|
Date converted to DD/MM/YYYY or MM/DD/YYYY |
Full Name |
John Smith |
→ | ContactName |
John Smith
|
Buyer name for invoice |
Item Name |
Handmade Ceramic Mug - Blue Glaze |
→ | Description |
Handmade Ceramic Mug - Blue Glaze
|
Product description |
Quantity |
2 |
→ | Quantity |
2
|
Quantity ordered |
Price |
25.00 |
→ | UnitAmount |
25.00
|
Unit price |
Order Sales Tax |
4.62 |
→ | TaxAmount |
4.62
|
Marketplace tax (optional) |
Currency |
USD |
→ | Currency |
USD
|
ISO currency code |
All conversion runs in your browser. Files are never uploaded to any server.
Nothing is stored after conversion. Close the tab and your data is gone.
Full EU data protection compliance. Your privacy rights are fully protected.
Each Etsy order item becomes one Xero invoice line
One row per item sold
Order ID,
Item Name,
Price,
Quantity
One row per invoice line (Xero groups by InvoiceNumber)
Issues you might encounter when importing CSV Order Items data to Sales Invoice - and how we solve them
Etsy uses 'Jan 15, 2026' format which needs conversion
Jan 15, 2026
15/01/2026 (UK) or 01/15/2026 (US)
Our converter automatically transforms dates to your Xero region format
Select your Xero region in options
Xero requires unique InvoiceNumbers, Etsy Order IDs might conflict
12345678 (bare number)
ETSY-12345678 (prefixed)
ETSY- prefix added automatically to prevent duplicates
Prefix is added by default
Xero requires ContactName, some Etsy orders may lack names
(blank name)
Etsy Customer
Falls back to Etsy username or 'Etsy Customer' generic name
Generic contact created if name missing
Etsy collects/remits tax - not your liability to record
Order includes $4.62 tax Etsy collected
Tax excluded (Etsy remits it)
By default, marketplace-collected tax is excluded
Use 'record' tax mode if you need 1099-K matching
Orders with multiple items need multiple invoice lines
Order 123 with 3 items
3 invoice lines with same InvoiceNumber
Xero's line-item format is natively supported
Each item becomes one invoice line (Xero groups by InvoiceNumber)
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Etsy Seller to Xero
Full Name → Name
First Name → FirstName
Last Name → LastName
Order ID → InvoiceNumber
Sale Date → InvoiceDate
Full Name → ContactName
Date → Date
Net → Amount
Type → Description
This platform pair is available in 1 other hub
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli