This document outlines the step-by-step process for migrating from ZoneReconcile to ZoneReconcile 2.0, with a specific focus on enabling Bank Connectivity via API or SFTP (features that are not available by default in the upgraded version).
Prerequisites & Preparation
Before starting the migration, please review the following requirements to ensure a smooth transition:
- License Provisioning: Confirm with your ZoneReconcile account manager or administrator that the ZoneReconcile 2.0 license, including the required Bank Connectivity module, has been provisioned for your account.
-
Team Coordination:
- Align with your Finance Team to schedule and agree on a firm 'Cutover Date.' This is the date you will stop using the old system (manual import of bank statements) and switch to the new one (automated daily sync of bank statements).
- Coordinate with your team if you need assistance with API credentials or SFTP server details.
- Required Role: All steps should be performed by a user with the Administrator role in NetSuite to ensure proper permissions for license retrieval and configuration.
Migration Checklist
Use this checklist to track your progress through the migration.
- Review the above mentioned 'Prerequisites and preparations'
- Retrieve and activate the ZoneReconcile 2.0 license in NetSuite
- Choose your connection path (Connectivity API or Connectivity SFTP)
- Path A (API): Follow the 5-step API migration process
- Path B (SFTP): Follow the 5-step SFTP migration process
- Agree on and document the final reconciliation cutover date
- Execute all "Pre-Migration Setup" steps for your chosen path
- On the cutover date, execute all "Migration Day Actions"
- Perform post-migration validation to confirm success
Step-by-Step Migration Process
Implementing ZoneReconcile 2.0 is a simple, two steps process ensuring the system is properly licensed, connected, and configured for your organization. Whether you are connecting to your bank via SFTP or Connectivity API, follow the instructions accordingly:
Step 1: The common step of the migration process is the license retrieval
-
Step 2: Select your connection path:
Path A: Connectivity API Migration: Choose this if you connect to your bank directly via an API
Path B: Connectivity SFTP Migration: Choose this if you exchange statement files with your bank via an SFTP server
Step 1: License retrieval - Ask your Administrator to enable the provisioned license
Availability of the Connectivity feature is license driven. The very first step is to retrieve the license. For this process, it is recommend to login to NetSuite as an Administrator. Once logged in, navigate to Setup > ZoneReconcile Setup > ZoneReconcile License. Make sure to click 'Retrieve license' as below:
Once retrieved and 'Activated', your system is ready to be configured.
Step 2: Follow Connectivity Migration Instructions
Path A: Follow Connectivity API Migration Instructions
***Video Guide*** As a complete walkthrough of the steps below, you can watch the following video: Full Connectivity API Migration Link.
The migration process consists of a couple of steps outlined here below:
Establish bank connectivity
Agree on Cutover Date
Pre-Migration Setup
Migration Day Actions
Post-Migration Support
The table below summarises the detailed action points against each activity.
| Activity | Actions to execute | Important notifications |
| Establish bank connectivity | Establish bank connectivity using the following instructions (Connectivity API, Setup Assistant) |
You might not be able to select the Bank GL Accounts under 'Link NetSuite GL Accounts' dashboard because they are already assigned to an existing Bank Account configuration. Please leave the NetSuite GL Account field empty. The system will automatically create the Bank Account configuration and set it as inactive. When you’re ready to migrate, you can activate the configuration. Preferably, as described in the video recording, you can inactivate the old Bank Account configuration in advance. This action can take place when the cutover date is 'tomorrow' for example. |
| Agree on Cutover Date | Coordinate with the Finance Team to finalise the reconciliation cutover date |
The last date of processing bank statement using the old formats must be clearly defined. All transactions from the cutover date forward, will be reconciled using the JSON format (the statement format predefined by BankConnectivity). |
| Pre-Migration Setup |
Bank connectivity is established and connection is active In the Production account, a JSON configuration is created in ZoneReconcile (currently inactive) JSON format tested and verified for compatibility in Sandbox |
If the 'Initial date of transactions sync' is in the past, click the 'Retrieve transactions' button within the Bank Accounts dashboard. The system will download a statement file in the File Cabinet (folder named 'BankConnectivity'). Download the file to your local disk. Make sure to generate a configuration with JSON file format within your Sandbox account (copy the exact same from the Production instance). Test the file you saved to your local disc, by uploading it manually in Sandbox. |
| Migration Day Actions |
Inactivate the old Bank Account Configuration Activate the JSON Configuration Process a test reconciliation or validate the first JSON file Monitor for errors or mismatches during the first few runs |
Navigate to Setup > ZoneReconcile Setup> Bank Account Configuration Edit the active (existing) Bank Account Configuration > enable the checkbox 'Configuration is inactive' > Save In the list of the Bank Account configurations enable the checkbox 'Show inactives' > Edit the Bank Account configuration created via BankConnectivity > Record the Bank GL Account > Check remaining parameters that you require to be updated (cross-reference the existing old configuration) > Save |
| Post-Migration Support | Make sure new incoming statements are uploaded utilising the new Bank Account configuration | The next day, new incoming statements will be auto-processed |
A short functional summary of the steps to be executed:
- Establish BankConnectivity following the Connectivity API, Setup Assistant guide
- Review the last date of your statements import
- Retrieve transactions to the File Cabinet using the 'Retrieve transactions' button on the Bank Accounts table
- To automate this process Enable the Auto Import Logic
- Download a file from the File Cabinet to your local disk (optional)
- Create a bank account configuration in your Sandbox account by coping the Bank Account configuration from the Production instance (optional)
- Upload the bank statement manually in sandbox to verify transactions retrieved (optional)
- Inactivate the old Bank Account Configuration (within the Production account)
- Activate the new (JSON) Bank Account Configuration (within the Production account)
The process of migration with Connectivity API is completed.
Path B: Follow Connectivity SFTP Migration Instructions
The migration process is very similar to the migration process of Connectivity API. Unlike Connectivity API, Connectivity SFTP can also be tested in Sandbox. To proceed with Sandbox testing, make sure the bank/provider you are connecting to, provides a testing instance, to which you could connect. The process below is related only to migrating your production instance.
Establish bank connectivity
Agree on Cutover Date
Pre-Migration Setup
Migration Day Actions
Post-Migration Support
Once again, the table below summarises the detailed action points against each activity.
| Activity | Actions to execute | Important notifications |
| Establish bank connectivity | Establish bank connectivity using the following instructions (Configure Connection Configuration) |
Make sure to follow all the setup steps starting from Configuring connection, down to Statement & Files retrieval configuration. This configuration will ensure the successful download of bank statements to your File Cabinet Folder. Once the statements are received in the File Cabinet, check their file format. The file format must be a format supported by ZoneReconcile. |
| Agree on Cutover Date | Coordinate with the Finance Team to finalise the reconciliation cutover date |
The last date of processing bank statement using the old formats must be clearly defined. All transactions from the cutover date forward will be reconciled using the new format (the format predefined by your bank/provider). |
| Pre-Migration Setup |
New bank statement format is tested and verified for compatibility Bank connectivity established and connection is active |
Make sure to generate a bank account configuration with the new file format within your Sandbox instance. Ensure transactions can be manually uploaded successfully. |
| Migration Day Actions |
Inactivate the old Bank Account Configuration Activate the new format bank account configuration Process a test reconciliation or validate the first statement file Monitor for errors or mismatches during the first few runs |
Navigate to Setup > ZoneReconcile Setup> Bank Account Configuration Edit the active (existing) Bank Account Configuration > enable the checkbox 'Configuration is inactive' > Save Generate a new bank account configuration with the new format matching the format of the statement files delivered from your bank. To process bank statements, the next action is to schedule the AutoImport process as described under this article Enable the Auto Import Logic. |
| Post-Migration Support | Make sure new incoming statements are uploaded utilising the new Bank Account configuration | The next day, new incoming statements will be auto-processed |
A short functional summary of the steps to be executed:
- Establish BankConnectivity following the Configure Connection Configuration guide
- Create 2 new folders in the File Cabinet (both folders must be in the same level, one Unprocessed, one Processed folder)
- Configure Statement & Files retrieval (Download Action Configuration)
- Retrieve bank statements to the File Cabinet using the 'Download files' button of the Download Action Configuration record
- To automate the process download bank statements follow the instructions of this link Trigger Download Scheduled Script
- Inactivate the old Bank Account Configuration (csv file configuration for example)
- Create a new Bank Account Configuration (CAMT.053 file configuration for example) based on the file type the statements are retrieved within the File Cabinet
- Download a file from the File Cabinet to your local disk (optional)
- Upload the bank statement manually to verify transactions retrieved (optional)
- Once statements are downloaded to the File Cabinet, follow the instructions of Auto processing Bank Statement files that are in the file cabinet
The process of migration with Connectivity SFTP is completed.
How to confirm a successful migration
You can confirm the migration is complete and successful by verifying the following:
- Correct Configuration is used: Navigate to Setup > ZoneReconcile Setup > Bank Account Configuration. Ensure that the new configuration JSON (CAMT.053 for example in a SFTP connection) file type configuration is active and the old bank account configuration ((csv for example in a SFTP connection)) is inactive.
- New Statements are processed: On the day after your cutover, check that new bank statements have been automatically imported to the Bank Statement List and processed.
- No Reconciliation errors: Open the processed reconciliation and verify that transactions are matching correctly without new or unexpected errors.
Important: As outlined in the Migration Day Actions, compare your old and new bank account configurations. Ensure you copy all Matching and Processing preferences exactly to prevent any disruptions to transaction processing.
Where to get help
If you encounter issues during the migration, please:
- Re-read this guide and the linked documentation to ensure all steps were followed
- Consult your internal Administrator
- Visit BankConnectivity's FAQ page
- Contact ZoneReconcile Support: If you are still stuck, please log a support ticket via Support Center portal by providing detailed steps and expectations for our support team
Next steps
If you would like to explore the possibility of sending payments or payroll files automatically utilising the SFTP connection, follow the instructions available on the following link Configure Payment & File transfers (Upload Action Configuration). Please note, this is a functionality limited to Connectivity SFTP only.