Convert EDI 810 & 850 to Xero Sales Invoice CSV (26 Columns)

Export 100% compliant Xero Sales Invoice CSV files with mandatory asterisk headers (*ContactName, *InvoiceNumber, *Quantity, *UnitAmount, *AccountCode) and PO Reference mapping.

Drop your file below, check the order, then download for Xero Accounting (CSV).

1Load your order file
2Check it and match your SKUs

Drop your EDI order file here

.edi, .x12 or .txt. The file is read on your computer and is not uploaded.

Now showing

amazon-810-invoice.edi

No file handy? Open a sample:

No chargeback risks found. This order passes every check.

Checked against the Amazon supplier guide for EDI 810.

Invoice 3-way math balanced: IT1 Subtotal ($2330.00) + SAC ($-25.00) === TDS01 ($2305.00).

Commercial Invoice Summary & Line Items

Invoice #

INV-2026-8801

Purchase Order #

AMZ-PO-77665544

Invoice Date & Terms

11/09/2026 · 2/10 NET 30

Invoice Total

$2,305.00 USD

Line	Your SKU	Retailer Item # / UPC	Description	Invoiced Qty	Unit Price	Line Total
#1		Item: B08N5WRWNW UPC: 012345678905	ORGANIC COTTON BATH TOWEL ROYAL BLUE	100 EA	$12.50	$1250.00
#2		Item: B09X1KLMNP UPC: 012345678912	LUXURY WAFFLE ROBE WHITE XL	60 EA	$18.00	$1080.00

Invoice Balance VerifiedItems Subtotal ($2330.00) + Allowances/Charges ($-25.00) = Invoice Total ($2305.00)

Download for your software

Pick where the order is going, then download. Files are ready for Excel, QuickBooks, Shopify or a thermal printer.

Official Xero Sales Invoice import template with PO Number and account mapping.

Field mapping table: which EDI segment fills which column (for IT & bookkeepers)

EDI 810 / 850 to Xero 26-Column Sales Invoice CSV Mapping

Deterministic segment-to-column mapping rules enforced by our client-side X12 engine

Source X12 Segment / Element	Sample Raw Value	Target ERP / CSV Column	Transformation & Validation Logic
N1BT / N1BY / N1*ST	AMAZON.COM KYDC LLC	*ContactName & POAddressLine1..POCountry	Populates mandatory customer contact name and shipping/billing address columns.
BIG02 & BIG04 (or BEG03)	INV-2026-8801 / PO #AMZ-PO-77665544	*InvoiceNumber & Reference	Maps Invoice # to *InvoiceNumber and buyer PO # + Dept # to Reference.
IT1 / PO1 + PID05	SKU-TOWEL-BLU-L / 100 @ 12.50	InventoryItemCode, Description, Quantity, *UnitAmount	Outputs mapped item code, description, quantity, and unit price.
REF*DP & CUR02	Dept 0018 / USD	TrackingName1="Department", TrackingOption1, Currency	Maps retail department to Xero Tracking Categories and sets *AccountCode="200".

Critical Chargeback & Import Pitfalls We Prevent

Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors

Removing Leading Asterisks (*) from Xero CSV Headers

Risk: Xero Import Rejection

Xero’s importer strictly requires asterisks on mandatory column headers (*ContactName, *InvoiceNumber, *InvoiceDate, *DueDate, *Description, *Quantity, *UnitAmount, *AccountCode, *TaxType).

Our Xero exporter locks all 26 official header names verbatim.

Missing AccountCode or TaxType Values

Risk: Draft Invoice Error

Leaving AccountCode or TaxType blank causes Xero to halt the import.

We prefill *AccountCode="200" (Sales) and *TaxType="Tax Exempt (0%)" for wholesale B2B orders.

Importing SAC Allowances Without Negative UnitAmount

Risk: Overstated Invoice Total

In Xero CSV imports, discount rows must carry a negative *UnitAmount with *Quantity=1.

Our exporter outputs SAC*A rows with negative unit amounts so Xero calculates the exact net total.

How to Import EDI Invoices into Xero in 3 Steps

Zero middleware setup — complete in under 60 seconds

1. Load Your EDI 810 or 850 File Above

Verify line items and net totals in the business view.

2. Select "Xero Sales Invoice (CSV)" & Download

Preview the 26-column CSV in the Exporter Panel and click Download.

3. In Xero: Business → Invoices → Import

Upload the CSV file to create draft or awaiting-payment invoices.

Frequently Asked Technical Questions

ANSI X12 specification details, retail companion rules, and ERP import answers

Does the Xero CSV include all 26 official columns?

Yes. Every column from *ContactName to Currency is included in the exact order specified by Xero’s official template.

Where does the buyer Purchase Order number appear in Xero?

The buyer PO number (BEG03 or BIG04) and Department number (REF*DP) are written to the Xero "Reference" column.