Welcome to Zuora Product Documentation

Explore our rich library of product information

Wells Fargo

Describes the Wells Fargo lockbox file format, which uses two fixed-width flat files (images.dat and optional fields.dat) to provide check MICR data, image paths, and operator-keyed remittance and invoice information.

How to identify this file

Two flat text files delivered together in a folder/archive:

  1. images.dat — check (MICR) data

  2. fields.dat — keyed-in remittance data (optional; if absent, no invoice data is extracted)

images.dat – Fixed-Width Field Mapping

  1. Positions 14–23: Lockbox number

  2. Positions 24–31: Deposit date (yyyyMMdd)

  3. Positions 36–43: Batch number

  4. Positions 47–49: Transaction ID

  5. Positions 59–60: Document type

    1. Must be "CK"

    2. Non-CK records are skipped

  6. Positions 61–74: Cheque amount

  7. Positions 75–86: Cheque serial number

  8. Positions 88–107: Routing number

  9. Positions 108–127: Account number

  10. Positions 128–180: Image path

fields.dat – Fixed-Width Field Mapping

  1. Positions 14–23: Lockbox number

  2. Positions 24–31: Deposit date

  3. Positions 36–43: Batch number

  4. Positions 47–49: Transaction ID (links to images.dat)

  5. Positions 57–59: Field sequence number

  6. Positions 61–96: Field name

    1. Examples: INVOICE NUMBER, INVOICE AMOUNT, REMITTER NAME

  7. Positions 98–133: Field value (keyed-in data)

Key considerations

Format type: Two fixed-width flat files (images.dat + fields.dat)

Keyed-in (remittance data)? Yes — fields.dat contains operator-keyed invoice and remitter data

Image files? Yes — image path in images.dat

What IS parsed: Check amount, routing, account, serial, lockbox/batch/date, image path (from images.dat); invoice number, invoice amount, remitter name (from fields.dat)

What is NOT parsed: Lines in images.dat where document type is not "CK" are ignored

fields.dat is optional. If missing, the check is still processed but without invoice or remitter data.