Fifth Third Bank — IDX format

How to identify this file: A single flat text file. Each line starts with either 5 (payment record) or 6 (invoice record). Lines starting with 5 are always followed by one or more 6 lines for that check's invoices.

Payment Record (Type "5") – Field Mapping Documentation

1. Record Identifier

   1. Located at position 0

   2. Fixed value: "5"

   3. Identifies the record as a payment record

2. Business Date

   1. Located at positions 1–8

   2. Format: yyyyMMdd

3. Lockbox Number: Located at positions 9–14

4. Batch Number: Located at positions 15–19

5. Transaction Sequence: Located at positions 20–22

6. Cheque Amount:

   1. Located at positions 23–34

   2. Fixed length of 12 characters

   3. Last 2 digits represent cents

   4. Decimal is inserted during parsing

7. Check Number / Serial: Located at positions 35–44

8. Routing Number: Located at positions 45–53

9. Account Number: Located at positions 54–67

10. Image File Name:

    1. Located at positions 68–147

    2. Fixed length of 80 characters

Invoice Record (Type "6") – field mapping documentation

1. Record Identifier

   1. Located at position 0

   2. Fixed value: "6"

   3. Identifies the record as an invoice record

2. Business Date

   1. Located at positions 1–8

   2. Format: yyyyMMdd

3. Lockbox Number: Located at positions 9–14

4. Batch Number: Located at positions 15–19

5. Invoice Sequence: Located at positions 20–22

6. Image File Name:

   1. Located at positions 45–124

   2. Fixed length of 80 characters

Key considerations

Format type: Fixed-width, positional — single file

Keyed-in (remittance data)? No — invoice records contain image references only, no keyed invoice number or amount

Image files? Referenced by file name in both record types

What is parsed: Check amount, routing, account, check number, lockbox number, batch, business date, image references

What is not parsed: Invoice number, invoice amount (image path present but no keyed data)