EDI 820 Payment Order / Remittance Advice Decoder & Excel Reconciler

Reconcile bulk ACH wire deposits against hundreds of paid 810 invoices (RMR) and uncover hidden retailer chargebacks, coop deductions, and cash discounts (ADX).

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

Clean Excel spreadsheet with all order lines, store breakdown, quantities, and prices ready to open in Microsoft Excel or Google Sheets.

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

EDI 820 Remittance Advice (BPR, RMR, ADX) Reconciliation 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
BPRI48500.25CACH...	$48,500.25 ACH Deposit	Total Wire / ACH Payment	BPR02 gives the exact cash amount deposited into your bank account; BPR16 is the settlement date.
TRN1ACH-TRACE-998811~	ACH-TRACE-998811	Bank Trace / Check #	Matches the ACH trace number on your commercial bank statement.
RMRIVINV-2026-8801*2258.402305.00*46.60~	Paid $2,258.40 on INV-2026-8801	Invoice # / Gross / Net / Terms Disc	Links each paid invoice (RMR02) with Net Paid (RMR04), Gross Billed (RMR05), and Terms Discount Taken (RMR06).
ADX-250.00CSCMCB-8812~	-$250.00 Chargeback Deduction	Deduction Amount & Reason Code	Reveals short-ship, late-ASN, or barcode compliance deductions subtracted from your check.

Critical Chargeback & Import Pitfalls We Prevent

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

Posting Net ACH Cash Without Recording ADX Deductions

Risk: Unreconciled A/R Aging

If a retailer pays $2,055.00 on a $2,305.00 invoice due to a $250 chargeback, applying only cash leaves $250 open on your QuickBooks A/R aging forever.

Break out RMR06 (terms discount) and ADX01 (deductions) into separate credit/expense lines.

Missing the 30-Day Chargeback Dispute Window

Risk: Permanent Revenue Loss

Walmart Retail Link and Amazon Vendor Central require dispute claims within 30 days of the 820 remittance date.

Decode 820 ADX reason codes immediately upon receiving the remittance file.

Negative RMR04 Credit Memo Offsets

Risk: Misapplied Payments

Retailers include negative RMR lines for returns or defective allowances inside the same 820 batch.

Sort RMR rows by positive vs negative amounts before importing into your ERP.

How to Reconcile EDI Invoices & Remittances

Zero middleware setup — complete in under 60 seconds

1. Upload Your EDI File to the Inspector

Examine segment values, invoice references, and monetary totals.

2. Audit Allowances, Discounts & Chargeback Codes

Spot discrepancies between billed amounts and net settlements.

3. Export to Excel (.XLSX) or QuickBooks

Download a clean table for your bookkeeper or CPA.

Frequently Asked Technical Questions

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

What is the difference between RMR and ADX in an EDI 820?

RMR (Remittance Advice Accounts Receivable Open Item Reference) identifies a specific invoice being paid and its gross/net amounts. ADX (Adjustment) details specific deductions, chargebacks, or credit adjustments taken against that invoice or the overall payment.

Are BPR02 and RMR04 implied decimals (N2) or explicit decimals?

Unlike 810 TDS01 (which is N2 implied decimal), BPR02 and RMR04 in an EDI 820 use data type R (real numbers with explicit decimal points, e.g., 2258.40).