Configure the basic settings of a bank file format in Configurable Lockbox, including the file name, sample file, process option, and file format.

1. In the Lockbox application, navigate to Lockboxes tab.
2. On the Lockboxes tab, click the Add icon to start the configuration.
3. In the window that opens, complete the following configurations:
4. Bank File Name: Specify a name to identify the lockbox file format that you are creating. Zuora recommends that the name correspond to the bank from which you obtain the lockbox files. For example, BoA, Wells Fargo, or First Union.
5. Sample File: Select a lockbox sample file to upload. The sample file can be an actual lockbox file.
   Note: Empty rows below the header row in the sample file prevent sample values from displaying correctly.
6. Process Option: Select the process option for the uploaded lockbox file.

   • Account Only: Zuora processes payments based on the account information in the lockbox file.

   • Invoice Only: Zuora processes payments based on the invoice information in the lockbox file.

   • Account and Invoice: Zuora processes payments based on both the account and the invoice information in the lockbox file. If Zuora cannot process payments based on the invoice information (for example, if the invoice number is incorrect), Zuora still processes payments based on the account information and processing rules.

   • Document Only (Debit Memo and/or Invoice): Zuora processes payments based on billing documents, including debit memo or invoice information, in the lockbox file.

7. File Format: Identify the format of the file that you are uploading. Additional fields might be required depending on the format that you select.
   Note: Zuora recommends CSV file formats over Excel for data transfer because CSV files store plain text, which helps avoid errors from complex formatting, formulas, or hidden cells.

   • Comma Separated Values (CSV):

     • Header Row Number: Identify the line number of the header row in the uploaded document.

     • Zuora does not accept CSV file values that are separated by a semicolon.

   • Excel:

     • Header Row Number: Identify the line number of the header row in the uploaded document.

   • Bank Administration Institute 2 (BAI2):

     • Select Summary or Transaction.

     • Type Code List: Enter the list of type codes to process from the bank file. Separate the codes with commas and no spaces. Zuora does not process codes that are not listed.

   • Fixed Width Text - Single-Record Type:

     • Column header: Define the field in the selected sample file and file format, such as Invoice Number or Account Number.

     • Starts from: Identify the character number where the information starts in the selected file.

     • Ends at: Identify the character number where the information ends in the selected file.

     • To add another row, click the + sign. Add rows if you need additional information for mapping purposes.

   • Fixed Width Text - Multi-Record Type:

     • Column header: Define the field in the selected sample file and file format, such as Invoice Number or Account Number.

     • Record type: Select the record type from the list, or specify the record type. Only the numeric values 4, 5, and 6 are supported.

     • Starts from: Identify the character number where the information starts in the selected file.

     • Ends at: Identify the character number where the information ends in the selected file.

     • To add another row, click the + sign. Add rows if you need additional information for mapping purposes.

   • SWIFT Structured File Format - MT940:

     • Check Multiple Fields for Invoice or Account Number: Select this checkbox to select multiple lockbox file header fields for Invoice Number, Account Number, or both in Zuora Payments Field. This checkbox is enabled only when you select Invoice Only or Account and Invoice from the Process Option dropdown list.

8. Click Next Step.