1. On the Lockboxes tab, click the Add icon to start the configuration.

2. In the window that opens, complete the following configurations and click Next Step.

   • Bank File Name: Specify a name to identify the lockbox file format being created. It is recommended the name correspond to the bank from which the lockbox files are obtained.

     For example, BoA, Wells Fargo, First Union, etc.

   • Sample File: Select a lockbox sample file to be uploaded. The sample file can be an actual lockbox file.

   • Process Option: Select the process option for the uploaded lockbox file.

     • Account Only: Payments will be made based on the account information in the lockbox file.

     • Invoice Only: Payments will be made based on the invoice information in the lockbox file.

     • Account and Invoice: Payments will be made based on both the account and the invoice information in the lockbox file.

       If payments cannot be processed based on the invoice information (for example, the invoice number is incorrect), payments will still be processed based on the account information and processing rules.

     • Document Only (Debit Memo and/or Invoice): Payments will be made based on billing documents including debit memo and/or invoice information in the lockbox file.

   • File Format - Identify the format of the file being uploaded. Additional fields may be required depending on the format selected.

     File Format	Settings
     Comma Separated Values (CSV)	Header Row Number: Identify the line number of the header row in the uploaded document. CSV file values separated by a semicolon will not be accepted.
     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 be processed from bank file. Must be separated by a comma with no spaces. Codes not listed will not be processed.
     Fixed Width Text - Single-Record Type	Column header: Define the field that will be defined in the selected sample file and file format: Invoice Number, Account Number. Starts from: Identify the character number that corresponds to where the information starts in the selected file. Ends at: Identify the character number that corresponds to where the information ends in the selected file. Add an additional row by selecting the + sign. Rows can be added if additional information is needed for mapping purposes.
     Fixed Width Text - Multi-Record Type	Column header: Define the field that will be defined in the selected sample file and file format: Invoice Number, Account Number. Record type: Select the record type from the list or specify the record type. Only numeric values of 4, 5, and 6 are supported. Starts from: Identify the character number that corresponds to where the information starts in the selected file. Ends at: Identify the character number that corresponds to where the information ends in the selected file. Add an additional row by selecting the + sign. Rows can be added if additional information is needed for mapping purposes.
     SWIFT Structured File Format - MT940	Check Multiple Fields for Invoice or Account Number: Check the checkbox to select multiple lockbox file header fields for Invoice or Account Number or both in Zuora Payments Field. Check Multiple Fields for Invoice or Account Number checkbox is enabled only when you select Invoice Only or Account and Invoice option under the Process Option dropdown.

CSV file formats are preferred over Excel for data transfer because they store plain text, which helps to avoid errors from complex formatting, formulas, or hidden cells.

• Header row number: The number of header rows.

Empty rows below the header row in the sample file will prohibit sample values from being properly displayed.