JPMorgan Chase (JPMC) — IDX format

How to identify this file: A single comma-delimited text file. Each line has a type identifier at field index 7 (the 8th comma-separated value). Three line types appear: C (check/payment), M (material/image), R (remittance/invoice).

Payment Record (Type "C")

• Index 0: Business date (MMddyyyy)

• Index 3: Lockbox number

• Index 4: Batch number

• Index 5: Transaction sequence

• Index 6: Sequence number

• Index 7: Record type = "C"

• Index 8: Front image file name

• Index 9: Back image file name

• Index 10: Cheque amount (last 2 digits = cents; decimal added during parsing)

• Index 11: Payment number

• Index 12: Serial / routing number

• Index 13: Account number

Material Record (Type "M")

• Index 7: Record type = "M"

• Index 8: Additional image file name (linked to preceding C record)

Invoice Record (Type "R")

• Index 6: Invoice sequence

• Index 7: Record type = "R"

• Index 8: Invoice number (quotes stripped)

• Index 9: Invoice amount (quotes stripped; last 2 digits = cents)

Key considerations

Format type: Comma-delimited with record-type identifier — single file. Records are logically linked as C → M → R within a transaction.

Keyed-in (remittance data)? Yes — invoice numbers and amounts are keyed-in

Image files? Referenced in C and M records; multiple images are concatenated

What is parsed: Check amount, routing, account, payment number, serial number, invoice number, invoice amount, image references

What is not parsed: Invoice amount of 0 is skipped unless the invoice already exists in the system