Convert an EDIFACT INVOIC to Excel
Drop the .edi or .txt file exactly as your partner sent it. The INVOIC message is parsed into a table, and the segments that only mean something to your trading partner are shown as they are rather than guessed at.
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 |
|---|
Where EDI stops being self-explanatory
EDIFACT is older than any of the XML formats and far more permissive: the same INVOIC message can be written a dozen legal ways, and the meaning of a qualifier is frequently agreed in a partner-specific implementation guideline rather than in the standard. This parser names what the standard names, and for the rest it shows you the segment, the element and the value. A wrong label on a finance document is worse than an unlabelled one.