Western Bank Alliance — CSV format

How to identify this file: A CSV file with a header row. Column names are mapped via a template configuration — the column order is not fixed. The file contains one row per invoice line item (multiple rows per check).

Format type

• CSV with header row — single file, template-mapped columns

• Fields are dynamically mapped using a configurable template

• Enables flexible adaptation across different bank file formats

Template-based logical field mapping

• date: Business date (format is configurable)

• amount: Invoice amount

• lockboxNo: Lockbox number

• lockboxBatchNo: Batch number

• invoiceNo: Invoice number

• reference: Check number (leading zeros stripped)

• lockboxFileName: Source file name (used for grouping)

Key considerations

Keyed-in (remittance data)? Yes — invoice numbers and amounts are included per row

Image files? Not referenced — image linking not supported in this format

What is parsed: Invoice number, invoice amount, check number (as reference), lockbox/batch, date

What is not parsed: Routing number, account number, image paths

Special behavior: Rows are grouped by reference + lockboxFileName. The check-level amount is computed as the sum of all invoice amounts for that group — it is not read directly from the file.

Column mapping must be pre-configured as a template. Without the header-to-field mapping, the file cannot be parsed.