Your files are read in your browser. Orders and pricing never leave your computer.
EDIParse

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.

  1. 1Load your order file
  2. 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
walmart-820-remittance.edi
No file handy? Open a sample:

No chargeback risks found. This order passes every check.

Checked against the Walmart supplier guide for EDI 820.

EDI 820 — Payment Order / Remittance Advice

Transaction Type
EDI 820 Payment Order / Remittance Advice
Control #
ST #0001
Group #70820 · v005010
Trading Partners
925485US00 → 5551234567
ISA #000070820
Total Segments
14 Business Segments
18 Total Lines (with Envelope)
Structured X12 Business Document View: Automatically translated all 14 segments of this EDI 820 transaction into human-readable business fields.
Line #Section NameBusiness MeaningExtracted Values
#3
STTransaction Set Header
Marks the start of an individual business document (850, 856, 810).
Transaction Set Identifier Code:820Transaction Set Control Number:0001
#4
BPRBPR Data Segment
Standard X12 business data segment
BPR01:IBPR02:2258.90BPR03:CBPR04:ACHBPR05:CCPBPR06:01BPR07:021000021BPR08:DABPR09:987654321BPR10:1078742000BPR12:01BPR13:111000025BPR14:DABPR15:123456789BPR16:20261110
#5
TRNTRN Data Segment
Standard X12 business data segment
TRN01:1TRN02:ACH-WMT-20261109-8801TRN03:1078742000
#6
CURCurrency
Specifies the currency code (e.g., USD, CAD) used in the transaction.
Entity Identifier Code:PRCurrency Code:USD
#7
REFReference Identification
Carries critical retailer identifiers such as Department # (DP), Vendor # (IA), or BOL # (BM).
Reference Identification Qualifier:IA (Internal Vendor Number (Assigned by Retailer))Reference Identification Value:123456789
#8
DTMDate/Time Reference
Specifies shipping windows (Do Not Ship Before / After) and delivery dates.
Date/Time Qualifier:097Date (YYYYMMDD):20261109
#9
N1Party Identification
Identifies Ship-To DC (ST), Buyer (BY), Vendor (VN), Ship-From (SF), or Remit-To (RE) party and GLN/DC code.
Entity Identifier Code:PRParty Name:WALMART STORES INC APIdentification Code Qualifier:ULIdentification Code (DC / Store / GLN):0078742000008
#10
N1Party Identification
Identifies Ship-To DC (ST), Buyer (BY), Vendor (VN), Ship-From (SF), or Remit-To (RE) party and GLN/DC code.
Entity Identifier Code:PEParty Name:ACME HOME GOODS LLCIdentification Code Qualifier:92Identification Code (DC / Store / GLN):123456789
#11
ENTENT Data Segment
Standard X12 business data segment
ENT01:1
#12
RMRRMR Data Segment
Standard X12 business data segment
RMR01:IVRMR02:INV-2026-8801RMR04:2258.90RMR05:2305.00RMR06:46.10
#13
REFReference Identification
Carries critical retailer identifiers such as Department # (DP), Vendor # (IA), or BOL # (BM).
Reference Identification Qualifier:POReference Identification Value:4500991288
#14
REFReference Identification
Carries critical retailer identifiers such as Department # (DP), Vendor # (IA), or BOL # (BM).
Reference Identification Qualifier:DP (Department Number (Mandatory for Walmart & Target))Reference Identification Value:0018
#15
DTMDate/Time Reference
Specifies shipping windows (Do Not Ship Before / After) and delivery dates.
Date/Time Qualifier:003Date (YYYYMMDD):20261109
#16
SETransaction Set Trailer
Closes the ST transaction set and verifies exact segment count (SE01) and control number (SE02).
Number of Included Segments (ST through SE inclusive):14Transaction Set Control Number (Must match ST02):0001

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 / ElementSample Raw ValueTarget ERP / CSV ColumnTransformation & Validation Logic
BPR*I*48500.25*C*ACH...
$48,500.25 ACH Deposit
Total Wire / ACH PaymentBPR02 gives the exact cash amount deposited into your bank account; BPR16 is the settlement date.
TRN*1*ACH-TRACE-998811~
ACH-TRACE-998811
Bank Trace / Check #Matches the ACH trace number on your commercial bank statement.
RMR*IV*INV-2026-8801**2258.40*2305.00*46.60~
Paid $2,258.40 on INV-2026-8801
Invoice # / Gross / Net / Terms DiscLinks each paid invoice (RMR02) with Net Paid (RMR04), Gross Billed (RMR05), and Terms Discount Taken (RMR06).
ADX*-250.00*CS*CM*CB-8812~
-$250.00 Chargeback Deduction
Deduction Amount & Reason CodeReveals 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).

Related EDI Converters, Retailer Guides & X12 Segment References