Convert an EDI 850 purchase order to Excel
The 850 is the order your American customer sends you, and it is the one that has to be right before anything ships. Drop it here and read it as a table.
Drop an invoice here
What do you want to do with your invoice?
Nothing is downloaded yet.
View on screen
Export to:
Seller and buyer
Line items
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
Tax breakdown and totals
| Category | Rate | Taxable base | VAT amount |
|---|
Payment and references
Remittance items
| # | Qualifier | Reference | Amount | Paid |
|---|
EDI segments
| Segment | Element | Value |
|---|
The order comes in, the invoice goes out
European suppliers issue their own invoices, so the inbound American documents that hurt are the order, the ship notice and the remittance rather than the 810. The 850 opens that sequence: line items, quantities, requested dates and ship-to addresses, in a syntax nobody outside the trade reads comfortably. In rows, it can be checked against what you can actually deliver.