Set Up a Bank File in Cash Application Manager

After setting up a bank in Cash Application Manager, the connector provides you with the following options to import a bank file:

• FTP connection with bank
• Manually upload the bank file

Configure FTP connection with a bank

When the Enable Manual Upload Mode setting is unchecked under Settings > General, you can import a bank file using the FTP connection with the bank.

To configure a FTP connection with a bank:

1. Uncheck the Enable Manual Upload Mode setting under Settings > General.
2. In the Flows tab, click Settings () next to the Bank File to NetSuite flow.
   
3. In the File import tab, update details in the following settings:
   • Directory path: Provide the path of the Directory in the FTP server where the files are stored.
   • File name starts with: Provide the first few characters of the file name which the integration app should read.
   • File name ends with: Provide the last few characters of the file name which the integration app should read.
   • Leave file on server: Check this setting if the integration app should leave the files on the FTP server after reading. Otherwise, the file will be deleted from the FTP server after reading.
4. Click Save & close to save these details and go back to the integration app flows.

Manually upload the bank file

When the Enable Manual Upload Mode setting is checked under Settings > General, you can manually add a bank file from your local system.

To manually upload the bank file:

1. Check the Enable Manual Upload Mode setting under Settings > General.
2. In the Flows tab, click Settings () next to the Bank File to NetSuite flow and the following settings will appear:
   
3. Click Close to go back to the integration flows.
4. Enable the Bank File to NetSuite flow for which you want to manually upload the file.
5. To manually upload a file in the integration app, click Run () next to the Bank File to NetSuite flow.
   A window is displayed that allows you to select the bank file from your local system that you wish to use for Accounts Receivable processing.

Configure file parsing settings

There are various options for parsing multiple types of bank files and standards. The Cash Application Manager supports fixed width and comma separated formats. Based on the type of bank file, the 'parser' settings may vary.

To access the file parsing settings, click Settings () next to the Bank File to NetSuite flow in the Flows tab.

Whenever a data file is imported into the Cash Application Manager, the data is extracted based on the positions defined in the File Parsing tab. Set the positions of the fields from the data file and modify the settings based on the data file. The positions vary according to the bank standard, payment type and file format. A sample of parser settings for data files which use fixed width is shown below:

For banks that use CSV format, you need to update the column index settings in the File parsing tab. Based on the column index settings updated, and that would enable it to extract the data accordingly. The column index needs to be specified for the file. A sample of parser settings for data files which use column width is shown below:

Configure file processing settings

You can configure the file processing settings for the Bank Transactions to NetSuite flow.

To access the file processing settings, click Settings () next to the Bank Transactions to NetSuite flow in the Flows tab.

In the File processing tab, update details in the following settings:

• Payment account: Select the account from which the payment has to be made.
• Dummy customer: Enter the NetSuite Internal ID of the customer that will be the dummy customer for the scenario when the invoice and customer details are not available.
• Write off Threshold amount: Provide the threshold amount or percentage for which write off needs to be created. For percentage, provide a number followed by the % character. For example, 10%.
• Write off Debit account: Select the account from which the threshold amount will be debited.
• Credit memo: Choose this setting if the integration app should sync credit memos.
• Match Consolidated Invoices: Check this setting to match Consolidated Invoices in NetSuite.
• NetSuite Consolidated Invoice Identifier: Select the NetSuite field that needs to match the Invoice Id in the Invoice with the Consolidated Invoice Id from the bank file.

Related topics

• Understanding Cash Application Manager Data Flows and Status Dashboard
• Settings for Cash Application Manager for NetSuite
• Add a Bank in Cash Application Manager