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.
Was this article helpful?