IDI version 26.8 is now available.  Click here for details: IDI Updates.

Payment File Format (lockbox)

Prev Next

Before payments can be loaded from a file, the file data must be in a specific format. The format is comma delimited, with no header or trailer records. Each record must have 8 fields (7 commas). The fields are in the following order:

  • customer account number - alphanumeric

  • payment amount - currency

  • payment type code - numeric (as set up in Data Management)

  • payment date - mm/dd/yyyy

  • description (not required) - alphanumeric

  • apply to invoice number - numeric (if applicable)

  • check number - numeric (if applicable)

  • batch ID - numeric (not required)

    This is an example of a payment file. If your company has purchased OnlineBill, another choice is Authorize.net Batch Download.

    SamplePaymentFile