EDI 810 Commercial Invoice Inspector & QuickBooks / Xero Converter

Audit 810 invoices for TDS01 implied decimal balance, promotional SAC allowances, and mandatory retailer REF segments—then export balanced accounting entries.

Drop your file below, check the order, then download for QuickBooks Online (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).

Raw EDI Code Inspector

29 lines

1ISAISA*00* *00* *12*5551234567 *ZZ*AMAZON *261109*1745*^*00501*000030810*0*P*:~

2GSGS*IN*5551234567*AMAZON*20261109*1745*30810*X*005010~

3STST*810*0001~

4BIGBIG*20261109*INV-2026-8801*20261105*AMZ-PO-77665544***DI~

5CURCUR*SE*USD~

6REFREF*IA*VEND-AMZ-99~

7REFREF*DP*0018~

8REFREF*BM*BOL-99887766~

9N1N1*ST*AMAZON.COM KYDC LLC (OAK4)*92*OAK4~

10N3N3*1555 N CHRISMAN RD~

11N4N4*TRACY*CA*95304*US~

12N1N1*RE*ACME HOME GOODS LLC*92*VEND-AMZ-99~

13N3N3*1200 INDUSTRIAL PKWY~

14N4N4*DALLAS*TX*75201*US~

15ITDITD*01*3*2**10**30*****2/10 NET 30~

16DTMDTM*011*20261109~

17FOBFOB*PP*OR*DALLAS~

18IT1IT1*1*100*EA*12.50*PE*BP*B08N5WRWNW*UP*012345678905*VN*SKU-TOWEL-BLU-L~

19PIDPID*F****ORGANIC COTTON BATH TOWEL ROYAL BLUE~

20IT1IT1*2*60*EA*18.00*PE*BP*B09X1KLMNP*UP*012345678912*VN*SKU-ROBE-WHT-XL~

21PIDPID*F****LUXURY WAFFLE ROBE WHITE XL~

22TDSTDS*230500*233000*225840*4660~

23SACSAC*A*D240***2500**********PROMOTIONAL ALLOWANCE~

24CADCAD*M***ODFL*OLD DOMINION FREIGHT LINE**BM*BOL-99887766~

25ISSISS*160*EA*185*LB~

26CTTCTT*2~

27SESE*25*0001~

28GEGE*1*30810~

29IEAIEA*1*000030810~

BIGBeginning Segment for Invoice (810)

Line #4

Primary header of an EDI 810 Invoice linking your accounting invoice number back to the retailer Purchase Order.

BIG01Invoice Issue Date (YYYYMMDD)

20261109

BIG02Invoice Number

INV-2026-8801

BIG03Purchase Order Date (YYYYMMDD)

20261105

BIG04Purchase Order Number

AMZ-PO-77665544

BIG07Transaction Type Code

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.

Ready-to-import QuickBooks Online invoice file including items, quantities, allowances, and freight.

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

EDI 810 Invoice Segments to Accounting Fields 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
BIG20261109INV-2026-8801...AMZ-PO-77665544	INV-2026-8801	InvoiceNo / DOCNUM / PONUM	Maps BIG01 to Invoice Date, BIG02 to Invoice #, and BIG04 to Customer PO #.
IT11100EA12.50PEBP*B08N5WRWNW...	100 @ $12.50 = $1,250.00	Item / Quantity / Rate / Amount	Extracts ASIN/DPCI/UPC/Vendor SKU and computes exact line total.
SACAD240***2500~	-$25.00 Allowance	Discount / Allowance SPL Row	Divides N2 integer by 100 and creates a balancing discount line.
TDS230500233000~	$2,305.00 Total	Total Invoice Amount (TRNS)	Verifies TDS01 / 100 === Sum(IT1) + Sum(SAC) to the cent.

Critical Chargeback & Import Pitfalls We Prevent

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

100x Invoice Overstatement from Unscaled TDS01

Risk: Corrupted A/R Ledger

Importing raw TDS01 ("230500") into QuickBooks without dividing by 100 posts a $230,500.00 invoice instead of $2,305.00.

All EDIParse exporters automatically scale N2 elements by 0.01.

TDS01 vs Line-Item Sum Mismatch

Risk: Automated AP Rejection

If IT1 lines minus SAC allowances equal $2,305.00 but TDS01 says 233000, the retailer rejects the invoice immediately.

Our 3-Way Match linter highlights any penny discrepancy and auto-fixes TDS01.

Unbalanced QuickBooks Desktop .IIF Splits

Risk: QBD Import Error

QuickBooks Desktop rejects .IIF files if TRNS.AMOUNT plus all SPL.AMOUNT rows do not sum to exactly 0.00.

Our .IIF exporter mathematically locks TRNS and SPL rows in cents.

How to Convert EDI 810 Invoices to QuickBooks or Xero

Zero middleware setup — complete in under 60 seconds

1. Upload Your EDI 810 File

Verify that the green N2 3-Way Match banner confirms zero penny variance.

2. Select QuickBooks (.IIF / QBO CSV) or Xero CSV

Choose your accounting software tab in the Exporter Panel.

3. Download & Import into Your Accounting Ledger

Import the balanced file into QuickBooks or Xero in seconds.

Frequently Asked Technical Questions

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

Why does TDS01 in an EDI 810 have no decimal point?

In ANSI X12, TDS elements use data type N2 (numeric with 2 implied decimal places). Thus $2,305.00 is transmitted as 230500.

How are SAC allowances handled when exporting to QuickBooks?

In QuickBooks Online CSV, SAC allowances are exported as a negative Discount line item; in QuickBooks Desktop .IIF, they are posted as a positive debit split to Sales Discounts so the invoice balances to the penny.