Setting Up Bank Import Schedule in NetSuite 2026.1
In NetSuite 2026.1, the Bank Import Schedule feature streamlines bank data imports for reconciliation, enhancing efficiency and accuracy.
In NetSuite 2026.1, the banking module has been enhanced with new help topics for setting up and troubleshooting bank import schedules. These additions provide users with essential guidance for automating the import process, which is crucial for efficient bank reconciliation.
What Changed?
The update introduces two new help topics:
- Setting Up a Bank Import Schedule: This guide explains how to configure an automated schedule for importing bank transactions.
- Troubleshooting Bank Import Schedule Issues: This resource addresses common errors encountered during the scheduling process, ensuring users can resolve issues effectively.
Setting Up a Bank Import Schedule
To set up an automated bank transaction import schedule for profiles configured for bank reconciliation, follow these steps:
- Navigate to Setup > Accounting > Financial Institution > List.
- Select an existing financial institution or create a new record if needed.
- Choose a format profile for importing data or create a new one by clicking Add under the Format Profile: Configuration subtab.
- Set the Profile Type to Bank Reconciliation and select a connectivity method.
- In the Account Linking subtab, link at least one GL account necessary for the import schedule to be activated.
- Go to the Import Schedule subtab. The system will pre-fill default values for the schedule:
- Unit of Time: Day
- Frequency: 1 day
- Scheduled Import Date: Default date
- Randomized Import Time: Between 4:00 AM and 7:00 AM Pacific Time
Important: Transactions will only be imported starting from the date set in the Earliest Transaction Date for Import field, located in the Account Linking subtab.
Troubleshooting Import Schedule Issues
Here are some common issues and their solutions:
- Record Not Saved: Make sure every field under the Import Schedule is filled in or left entirely blank. Partial entries are not allowed.
- No Active Linked Accounts: Ensure that there is at least one active linked account in the Account Linking subtab. Without it, the import process cannot be initiated.
Additional Notes
- The specified import time adheres to the time zone selected during the schedule setup, overriding the system's default time zone. Only the last successful import time displayed on relevant pages will reflect the respective time zone setting.
Who This Affects
- Administrators: Responsible for setting up import schedules and managing financial institution records.
- Accountants: Users engaged in bank reconciliations that rely on timely imported transaction data.
Key Takeaways
- New help topics for setting up and troubleshooting bank import schedules were introduced in NetSuite 2026.1.
- An automated bank import schedule enhances the efficiency of bank reconciliations by ensuring timely data updates.
- Proper linking of GL accounts is essential for activating import schedules.
- Transaction imports depend on configurations in specified fields, particularly the Earliest Transaction Date for Import.
- Users should refer to the troubleshooting guide to resolve any setup issues encountered during the process.
Frequently Asked Questions (4)
Do I need to enable a feature flag for the Bank Import Schedule in NetSuite 2026.1?
What permissions are required to set up a bank import schedule in NetSuite?
How does the Bank Import Schedule interact with existing financial institution records?
What happens if the account linking subtab does not have an active linked account?
Was this article helpful?
More in Banking
- Manually Running Reconciliation Rules in NetSuite 2026.1
In NetSuite 2026.1, you can now manually run reconciliation rules from the Match Bank Data page to streamline bank transaction matching.
- Payment Date Prediction for Invoices in NetSuite 2026.1
Starting in NetSuite 2026.1, you can now see AI-generated payment date predictions for invoices, enhancing cash flow planning.
- Submitting Matched Transactions in NetSuite 2026.1
In NetSuite 2026.1, streamline your transaction submission process with enhancements for matched and user-cleared transactions.
- Payment Automation Enhancements in NetSuite 2024.2
Explore Payment Automation enhancements in NetSuite 2024.2, including multi-subsidiary support for streamlined payment processes.