Articles in this section

File parser settings in Cash Application Manager

Tom Santiago
Updated

File parser settings in CAM provide various options for parsing multiple types of bank files. Below are the parser settings shown for the mostly used File formats.

  • BAI2 6,4: Mostly used for lockbox or mixed payment types.

  • BAI2 16,88: Mostly used for wires and ACH payment types.

  • MT940: Mostly used for wire payment types.

  • CSV: Used by major banks and for all payment types.

  • XML / CAMT.053: Used by most of the European banks.

Set up parsing settings for bank data files

This section enables you to set positions of fields from a data file in the application. Whenever a data file is imported into CAM, the data is extracted based on the positions defined in the setting. The positions vary according to the bank standard, payment type, and file format. CAM supports the following formats:

  • Fixed-width (BAI2 6,4): For banks that have fixed-width, the fields' starting and ending position must be specified.
  • Comma separated (BAI2 16,88; MT940; CSV): For banks that have CSV type of formats, a column index setting is provided that allows you to set up and extract the data accordingly. The column index must be specified for the file. For banks that have comma separated (BAI2 16,88 and MT940), the customer details and the invoice details are provided as part of the continuation records. This is typically raw data with no standardized way to identify with one-to-one mapping. You can enter a regular expressions to capture the data.
  • XML (CAMT.053)

 

Capture a new field your bank adds to the file

When your bank adds a field to the file it sends, such as a Bank Reference number, you add the field to the parser settings and then map it. The new field is available in the Bank Transactions to NetSuite flow's mappings as soon as you save the parser row.

  1. In the Bank File to NetSuite flow's settings, open File Parsing and select the record that carries the new field. For a BAI2 lockbox file, that is Type 6 – Detail Record.
  2. Select + Add New Row and enter a field description and the position of the field. For a fixed-width format such as BAI2 6,4, enter the start and end positions your bank published; for a comma-separated format, enter the column index. Save the settings.
  3. In the Bank Transactions to NetSuite flow's Field Mappings, the new field is available as Transactions[*].['<Field Description>'], for example Transactions[*].['Bank Reference']. Map it to the Celigo Cash App Transaction field that should hold it, for example the transaction record's Bank Reference field.
  4. To carry the field onto the customer payment, map it in the General section's NetSuite cash app transaction to NetSuite customer payment flow. See Understand the General section integration flows.