Auto processing Bank Statement files that are in the file cabinet

Owned by Tania Hudig (Deactivated)
Last updated: Feb 16, 2023 by Filip Lundoloqui (Unlicensed)
2 min read

This page is for users to setup auto processing of files that are already imported into the file cabinet. The user will need to setup 2 file folders in Netsuite, 1 for files that need to be processed and another for files that have been processed.

This process replaces the need for the user to import a file manually and create and match a bank statement.

Instructions

  1. Create a new File Cabinet Folder for both unprocessed and processed files.

    1. The processed folder may not be a sub folder of the unprocessed folder! Note the folder ID for both folders.

    2. Make sure you use the ID of the processed folder as Statement folder ID for the Bank Account configurations subject to auto process statements for

  2. Create a "Bank Statement File Processing" record.

    1. Go to Setup > Bank Reconciliation > Bank Statement File Processing

    2. Create a New Bank Statement File Processing record and select either the Bank Account Configuration for single file imports or the Multiple Configuration Record for multi file imports. (Save)

  3. Schedule Script 1: Type: Map/Reduce - BS MR File Processing (former Bank Statement File Processing MR)

    1. Go to Customisation > Scripting > Scripts and find a script called “BS MR File Processing” (former Bank Statement File Processing MR). See more details here.

    2. Click on the Deploy button

    3. Schedule this to run daily after you know the new file will be available in the file cabinet. Eg. 8.00am if you know the file is expected at 07.30am.

    4. This script will move the file from the unprocessed folder to the Processed folder & create the auto import record

    5. The auto import record will be set to “No”

  4. Schedule Script 2: Type: Scheduled - BS SC Import

    1. Go to Customisation > Scripting > Scripts and find a script called "BS SC Import".

    2. Click on the Deploy button

    3. Schedule this to run daily at least 1 hour after the previous script. This will give the first script time to execute before running the next one. In our example at 9.00am the earliest.

    4. This script will create the bank statement from the auto import record

    5. The auto import record will be set to “Yes”

  5. Go to Transactions, Bank Reconciliation, Statement list to find the statements that have been imported. 

  6. NOTE: The last script (BS SC import) holds two preferences under the Parameters tab:

BS SC import script deployment

  1. ONLY SPLIT FILES - if checkbox is enabled, you will find the statements in the Statements to Process list

  2. ENABLE AUTO IMPORT PROCESSING LIMITATION - if enabled, the script will ONLY process bank statements created from files inserted to the File Cabinet (by ignoring manually imported)