Supported formats

• Lockbox: Lockbox files represent remittance data from physical check processing. Parsers extract check details, invoice line items, and image references.

  1. Default IDX (Generic)

  2. Truist

     • IDX

     • XML

  3. Fifth Third Bank IDX

  4. JPMorgan Chase (JPMC) IDX

  5. Silicon Valley Bank (SVB) CSV

  6. Western Bank Alliance CSV

  7. Tophat CSV

  8. Wells Fargo

  9. BIDS (Bank Image Data Services) XML

• BAI2 (Bank Administration Institute Format 2)

  1. Citibank BAI2

     • Customisation for Amagi

  2. Truist BAI2

  3. Wells Fargo BAI2

• Other banking formats

  1. BAI3

  2. MT940 (SWIFT Customer Statement)

  3. CSV (generic type)

New banking file format: Sanity check

1. Receiver details:

   1. Receiving bank account number

   2. Receiver currency or the account currency

2. Payment Specific details:

   1. Payment Date

   2. Payment Currency (if absent at the payment record, the receiver currency would be used as the default)

   3. Payment Amount

   4. Payment Description

   5. Payment Code - To know which kind of transactions can be whitelisted

   6. Incoming vs Outgoing transactions differentiator.

   7. Bank charges - Optional

3. Sender details (usually part of the Payment description)

   1. Remitter/Originator Name

   2. Remittance details (i.e. invoice details) - Optional