Convert an X12 820 remittance to Excel
One payment, many invoices, and a file that will not tell you which is which at a glance. Drop the 820 and get the remittance detail as rows you can reconcile against your open items.
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 document that closes the loop
The 820 says what was actually paid and against which invoices: the file that decides whether your receivables ledger is right. It carries a payment total in the BPR segment and then a set of RMR references, each with the invoice number and the amount applied, frequently with adjustments attached. Reading those in a spreadsheet is the difference between a reconciled month and a guessed one.