Create Lockbox File

Refer to Example Lockbox Files for example of the format of lockbox files.

Each lockbox file must include the following lines:

• Line 1 — A header line that provides information about the lockbox file: Information in the header line must be in the order listed. Each item in the header line must be separated from the following item by a single comma. Refer to the Contents of the Header Line table for an explanation of each part of the header line.

  • The name of the lockbox service company

  • The name or number of the lockbox

  • The name of your company

  • The date the lockbox file was created

  • The total value of the payments included in the lockbox file

• Line 2 — Header labels (separated by a single comma) that identify the information that will be listed in the columns in the payment lines, each column corresponding to a header label. Refer to the Contents of the Header Labels Line table for an explanation of each column label.

  • Line Number

  • Account Number

  • Customer Name

  • Deposit Date

  • Amount

  • Currency

  • Bank Routing Number

  • Bank Account Number

  • Check Number

  • Invoice Number

  • Invoice Due Date

  • Invoice Amount

• Lines 3 through nn (Detail Records) — Comma-separated values that correspond to the header labels in Line 2. Refer to Example Lockbox Filesfor examples.

If you decide to omit information from one of the columns for which there is a header label, you must include a comma in place of the missing data to prevent Gotransverse from reading the information from the next column as if it were from the column whose information is missing. Reading the wrong information will cause the record to err.

The following table includes the contents of the Header line:

Lockbox File Header Fields

Field Number	Description	Required	Contents and Format	Example
1	Bank Name	Yes	Alphanumeric	Bank of Texas
2	Lockbox Number	Yes	Alphanumeric	LAC-01234
3	Company Name	Yes	Alphanumeric	ABC Company
4	Batch File Date	Yes	Numeric	5292004
5	Control Amount	Yes	Numeric	12345.67

The following table includes the contents of the Header Labels line:

Lockbox Header Labels Line - Column Names

Column Name	Required Y/N	Maximum Characters	Contents and Format	Description
Line Number	No (optional)	5	Numeric	Line number (optional).
Account Number	Yes	20	Alphanumeric	Customer billing account number.
Customer Name	No (optional)	50	Alphanumeric	Customer's name (optional).
Deposit Date	Yes	8	Numeric (MMDDYYYY)	Deposit date of customer's payment.
Amount	Yes	20	Numeric	Payment amount (decimal; for example: 123.55).
Currency	Yes	25	Alphanumeric	Currency of the payment amount. Only one currency type per file. If the file includes multiple currencies, the file will be rejected.
Bank Routing Number	No (optional)	9	Numeric	Customer's bank's 9-digit routing number.
Bank Account Number	No (optional)	25	Alphanumeric	Customer's bank account number.
Check Number	Yes	20	Numeric	The number of the tendered check.
Invoice Number	No	100	Alphanumeric	Customer's invoice number (optional). If payment is for multiple invoices, separate invoice numbers with a ";" (semi-colon).
Invoice Due Date	No	8	Numeric (MMDDYYYY)	Invoice due date (optional).
Invoice Amount	No	100	Numeric	The amount that is due per the invoice (decimal; for example: 123.55) (optional). If invoice amount is for multiple invoices, separate invoice amounts with a ";" (semi-colon).

 

 

 

Topic updated: 10/2024.