Can I connect my bank account in my NetSuite Sandbox account?
Bank Connectivity via the Connectivity API is not supported in Sandbox environments. Real-time bank connections are exclusively available in Production accounts. To test reconciliation scenarios in a Sandbox environment, it is recommended to establish the bank connection in your Production account, download the relevant bank statements, and then manually upload those statements into the Sandbox for testing purposes.
My Bank GL account is not available to be selected under the ‘Bank GL Accounts’ table.
ZoneReconcile 2.0 automatically filters out Bank GL Accounts in the NetSuite GL Account field if they are already associated with an existing Bank Account configuration.
If needed, you can proceed without selecting a value in the NetSuite GL Account field. In this case, the system will still create a new bank account configuration, but it will be set to inactive by default.
To complete the setup:
- Go to Setup > ZoneReconcile Setup > Bank Account Configurations
- Locate and inactivate the old configuration that uses the same Bank GL Account
- Edit the newly created (inactive) configuration and assign the correct Bank GL Account
- Activate the updated configuration to begin using it
How is the Global balance calculated?
The Global balance will always be displayed using the currency of the Parent subsidiary. If your headquarters within NetSuite hold USD as main currency, the system will display the Global balance using USD currency.
Navigate to Setup > Company > Subsidiaries > Parent subsidiary > View:
The main currency of the Parent subsidiary is USD:
Accordingly, the Global balance will be displayed in USD:
For example, if you are working with the following data:
- Parent subsidiary USD
- Child Subsidiary EUR
- Child Subsidiary Bank Account is in EUR
Bank Account balance retrieved from BankConnectivity for the German subsidiary is 110 eur and 220 eur. ZoneReconcile covert this value using the FX rate of the date of retrieval with the following calculation: Bank balance * NetSuite’s exchange rate (USD to EUR) of the day of retrieval. Example:
Exchange rate available:
(110 eur + 210 eur) * 1.11289001 = 356,12 USD:
What happens if I disconnect a bank account? Can I reconnect it again?
Yes, there can be events in which connections can fail due to different reasons (see Institution errors). Within the Dashboard, try to ‘Connect’ again by clicking ‘Connect’ to the bank account. If connection is still not available, reach Zone’s support team by generating a support ticket.
What does the ‘As of’ date represent?
Each column of the ‘Bank Accounts’ table on hover holds information about what data is displayed under. For example, ‘As of’ date is the date of the latest synced transactions.
I do not see my bank institution name under the connectivity QuickStart?
In these cases, it’s likely that your bank does not support the Connectivity API. The next step is to verify if your bank supports SFTP protocols. Reach out to a contact at your bank, explain your objective, and ask about SFTP support. If SFTP is available, they will likely ask you to generate a Key Pair. Follow the instructions in this link (Generate New Public Keys) to generate new public keys.
Can I update the initially selected schedule of data retrieval?
Yes, the initially selected schedule can be updated. The easiest way would be to navigate to Setup > ZoneReconcile Setup > Bank Account configurations > select (View) the account configuration for which you want to execute the update for. Navigate to the sublist of Bank Connectivity and click on the field BC BANK INSTITUTION. This action will take you to the form of the Bank Institution record. Edit the record and update the Import Schedule. Save.
How far backwards am I allowed to download transactions?
Transactions can only be downloaded for the past 30 days through this integration. If you need to upload historical bank data beyond this period, log in to your e-banking portal directly and manually download the transaction history for your desired date range. Once downloaded, you can upload the file into the system to complete the data import.
When will the transactions sync start?
Once the connection is successfully established and the import schedule is set to 'Daily', the initial transaction download will typically occur within 24 hours. However, this timing also depends on the Initial Sync Date configured during the setup:
If the Initial Sync Date is set to today or a past date, the system will initiate the first sync within 24 hours of connection.
If the Initial Sync Date is set to a future date, the sync will begin automatically once that date is reached.
If you prefer not to wait for the scheduled sync, you can manually trigger a sync at any time. To do so, go to the Bank Accounts Dashboard and click 'Retrieve Transactions'. This will initiate an immediate download and reset the daily sync cycle to recur exactly 24 hours from that manual action.
Can I send payment and payroll files via Connectivity API?
No, sending payment and payroll files to a banking institution is only supported via Connectivity SFTP.
How often does Plaid fetch bank data?
Plaid typically operates on a schedule, polling the bank for new data approximately every six hours.
How does our system get the statement data?
Our system pulls the data from Plaid based on a scheduled script execution. The script responsible for this action is the ZR Plaid Transaction Sync MR with a start schedule as of 5:00am.
Can the statement fetch script (ZR Plaid Transaction Sync MR) be triggered instantly when Plaid imports data?
No. The script is currently time-based (scheduled) and cannot be instantly triggered via an event or webhook from Plaid.
What is the recommended script execution time for maximum speed?
We recommend scheduling the script execution (e.g., at 5:00 AM) to allow for Plaid to complete its earliest daily sync, ensuring the most complete previous day's data is available. Accordingly, it is the ZR Auto Import MR script that processes the statements from the File Cabinet. The same by default is scheduled to start execution at 5:30 AM.
Does BankConnectivity AP support intraday statements?
No. We only support standard end of day statements provided by the bank.