Skip to the app
Search
The operating system for desk work that lives in files
Try a sample
Banking, Payments & Capital Markets · Systems talking · Hours back · sample run · 66 ms

EDI 820 Remittance Router

$51,872.00 of $55,612.00 received applied to 9 invoices; $1,328.00 in deductions to research and $4,040.00 unapplied, across 9 exceptions.

Evidence · 820 payment CG-EFT-000551
RMR*IV*INV-24101**12480.00*12480.00
Working

RMR04 paid $12,480.00 against $12,480.00 open on INV-24101: $12,480.00 applied, nothing left open.

Method

1Delimiters read from the ISA header: element '*', segment '~'. Envelope counts and control numbers are checked.

2RMR04 is the amount paid on each RMR02 reference; an ADX after an RMR explains that invoice's short pay, an ADX with no RMR before it in its ENT loop adjusts the whole payment.

$1,328.00
Deductions to research · 4 item(s)
PaymentInvoiceCustomer
CG-EFT-000551INV-24101Crestline Grocers
CG-EFT-000551INV-24102Crestline Grocers
CG-EFT-000551INV-24103Crestline Grocers
1 to 3 of 12
Reads

Raw ANSI X12 820 file, plus open AR invoices

Produces

Cash application journal and unmatched items (Cash application journal (CSV), Cash application (JSON), Exceptions and unmatched items (CSV))

Price

$2,500 / month, 30% to the referring partner

Your files

Read in memory for the session, never stored, never used to train a model.

Standard and product names belong to their owners. BaseLoom is not affiliated with or certified by them; validate converted files with your trading partner before production use.