My business customers require formal invoices for every eBay purchase. I converted my Transaction Report to Xero invoice format with the EB- prefix, and each order came through with proper line items and shipping separated. My accounts receivable tracking is finally accurate.
eBay to Xero Invoice Create Sales Invoices from eBay Orders
Transform eBay sales into professional Xero invoices. Perfect for B2B sellers, documentation requirements, and AR tracking.
Free preview — then from $5. Save with bundles.How to Convert Your File
Export from Ebay Seller
My eBay → Seller Hub → Reports → Download report
Upload and Configure
Upload Transaction Report CSV and choose Sales Invoice format
Preview and Download
Review converted data, download Xero-ready file
Import to Xero
Business → Invoices → Import → Upload CSV
Output is in Xero Invoice CSV format — ready to import directly, no manual reformatting needed.
How People Use This
I needed sales invoices in Xero for my tax records but eBay does not generate them. Converting my eBay transactions to Xero invoice CSV gave me professional invoice records with correct regional date formatting for my UK organization. Month-end close is straightforward now.
For clients who need AR tracking alongside bank reconciliation, I convert their eBay orders to Xero invoices with separate shipping line items. The custom invoice numbering keeps eBay sales distinct from other revenue sources, and the tax handling matches each client's Xero setup.
Every B2B customer on eBay asks for a proper invoice. I converted a full quarter of transaction data to Xero invoice format in one upload. Multi-item orders appeared as separate line items on each invoice, and the sales account codes mapped directly to my existing Xero chart of accounts.
Common Conversion Questions
Should I use invoices or bank statements for eBay accounting?
For most eBay sellers, bank statement format is simpler and sufficient. Use invoice format if you need AR tracking, B2B documentation, or customer-facing invoice records. Many sellers use both - invoices for documentation and bank statements for reconciliation.
How are eBay fees handled in invoices?
eBay fees are NOT included in invoices - they're business expenses, not customer charges. Invoices show what the customer paid. Track fees separately using our Bank Statement converter with two-line mode.
Can I import multi-item orders?
Yes! Each item in an order becomes a line item on the invoice. Shipping appears as an additional line if enabled. The invoice groups all items under the same invoice number.
When You Need Invoices from eBay Sales
B2B Sellers Need Invoice Documentation
Accounts Receivable Tracking
Your Conversion is Secure
Browser-Only Processing
All conversion runs in your browser. Files are never uploaded to any server.
No Data Retention
Nothing is stored after conversion. Close the tab and your data is gone.
GDPR Compliant
Full EU data protection compliance. Your privacy rights are fully protected.
// PRICING //
Choose the plan that fits your needs
Just start processing on any tool page
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
Credit Bundles
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Monthly Bundles Pro
Best for professionals and content creators
- Credits refresh monthly
- Priority processing
Purchase Credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
Do unused credits expire?
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
Is my data secure?
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Can I get a refund?
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Terms of service applies. VAT included where applicable.
More credits - more savings
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
Field Mapping
How Ebay_Seller Transactions fields map to Xero Invoice
| Ebay_Seller Transactions | Source Value | Xero Invoice | Target Value | Note | |
|---|---|---|---|---|---|
Buyer name |
John Smith |
→ | ContactName |
John Smith
|
Customer name for invoice |
Buyer email |
john@example.com |
→ | EmailAddress |
john@example.com
|
Customer email |
Order number |
11-12345-67890 |
→ | InvoiceNumber |
11-12345-67890
|
eBay order as invoice number |
Transaction creation date |
Jan-15-2026 |
→ | InvoiceDate |
Jan-15-2026
|
Sale date |
Transaction creation date |
Jan-15-2026 |
→ | DueDate |
Jan-15-2026
|
Same as sale (pre-paid) |
Item title |
Widget Pro - Black |
→ | Description |
Widget Pro - Black
|
Product description |
Quantity |
2 |
→ | Quantity |
2
|
Quantity sold |
Item subtotal |
100.00 |
→ | UnitAmount |
100.00
|
Unit price |
Shipping and handling |
8.00 |
→ | UnitAmount |
8.00
|
Shipping as line item |
Why Use This Converter?
Customer Invoices
Creates proper sales invoices linked to buyer contact records in Xero.
Line Item Details
Products and shipping appear as separate line items with descriptions.
Flexible Numbering
Customizable invoice prefix keeps eBay sales organized in Xero.
Tax Handling
Configure tax types to match your Xero setup and local requirements.
Regional Formatting
Automatic date formatting for UK, US, AU, NZ, and EU organizations.
Browser Privacy
All processing happens locally. Customer data never leaves your device.
Data Transformation
eBay orders become Xero invoices with line items
One or more transactions per order
Order number,
Transaction creation date
Common Sales Invoice Import Errors
Issues you might encounter when importing Transaction Report data to Sales Invoice - and how we solve them
Order Has Multiple Items
One order with multiple products
Order 11-123: Widget ($50), Gadget ($30)
Invoice 11-123-EB with 2 line items
Each item becomes an invoice line
Lines grouped under same invoice number
Missing Buyer Information
Buyer name or email not in export
Buyer name: (blank)
ContactName: eBay Customer
Default name used for import
Update contact in Xero after import if needed
Marketplace Tax Complexity
eBay collects tax in some states
Seller collected: $0, eBay collected: $8.00
Tax line depends on your settings
eBay-collected tax is excluded by default
Only seller-collected tax appears on invoice
Refunds Not Invoices
Refund transactions shouldn't be invoices
Type: Refund, Amount: -$50
Skipped (use Credit Note format)
Refunds filtered out automatically
For refunds, use Xero Credit Note import
Frequently Asked Questions
Ebay Seller → Xero Data Ecosystem
All available data flows from Ebay Seller to Xero
Buyer name → Name
Buyer email → EmailAddress
Buyer phone → PhoneNumber
Transaction creation date → Date
Net amount → Amount
Gross transaction amount → Amount
Buyer name → ContactName
Buyer email → EmailAddress
Order number → InvoiceNumber
Also available as
This platform pair is available in 1 other hub
Quick question before you go
Help us improve—what stopped you today?
Thank you!
Enter your email to claim your welcome bonus