Once connectivity is established (either via Connectivity API or Connectivity SFTP) and your bank files are incoming to the NetSuite File Cabinet, to enable the bank statement processing for reconciliation (converting the banking file into bank statements ready for reconciliation), it is mandatory to schedule one script record only.
Note: If connecting to your bank via Connectivity SFTP, it is mandatory to execute the following step, prior continuing with the scheduling Bank Statement File Processing User Guide. The Bank Statement File Processing Rules are already automatically generated if your connectivity was executed via Connectivity API.
To execute the scheduling, make sure you are logged into NetSuite as Administrator. Navigate to Customisation > Scripting > Scripts. Filter the results based on Type 'Map/Reduce' and click 'View' of the ZR Auto Import MR:
Under 'Deployments', click on the script title:
Edit the script record and make sure to enable the following parameters:
- Status - set it to 'Scheduled'
- Under the schedule section - make sure to enable the preference 'Daily event'
- Start time - should be early in the morning as 5:30am
- The repeat frequency recommendation is - each 12 hours, but open to adjustments per preference
- No End Date checkbox - must be enabled
Save. If you are executing this action during work time, the first scheduled action will be executed the next day, at 5:30am in the morning.
If you would like to instantly process the bank statements, edit the script, update the status to 'Testing', then Save and execute:
With this action, the bank statements will be processed to the Statement list. To reach the statement list, navigate to Transactions > ZoneReconcile > Statements list:
Your bank statements will be created and matched with transactions (open Invoices, Vendor bills) if applicable. Click 'Edit' on any of the statements:
To create payments for the matches transactions, just save the Bank Statement:
The system will generate a payment.
To update your settings and generate payments without Editing and Saving your statements, update the settings on the Bank Statement File Processing Rule. Navigate to Setup > ZoneReconcile Setup > Bank Statement File Processing, edit the record of your bank institution:
and set the Statement auto import settings to Create bank statement, match and process transactions.
This step is not required if your File processing record was generated in advance when configuring the SFTP connection.
To continue with reconciliation, follow the guidelines of Process Bank Transactions.